Something

SELECT street.value, house.value, flat.value
FROM user_additional_params AS street
LEFT JOIN user_additional_params AS house
ON house.userid=street.userid 
LEFT JOIN user_additional_params AS flat
ON street.userid=flat.userid 
WHERE street.paramid=1011 AND house.paramid=1012 AND flat.paramid=1013