select * from immobili i, localita l, tipi t where i.id_tipi=t.id_tipi and i.id_localita=l.id_localita and id_immobili=534