Hi lupo ,

try this

SELECT id_car FROM car WHERE id_person IN
(SELECT id_person FROM property WHERE id_house='1' )


let me know if this works