Something

SELECT street.value, house.value, flat.valueFROM user_additional_params AS streetLEFT JOIN user_additional_params AS houseON house.userid=street.userid LEFT JOIN user_additional_params AS flatON street.userid=flat.userid WHERE street.paramid=1011 AND house.paramid=1012 AND flat.paramid=1013