GGGGGGGGGGGGGGGGGGGSELECT id FROM inmuebles WHERE visible=1 AND tipooperacion = '2' AND pais = '67' AND provincia = '7' AND municipio = '826' AND numhabitaciones = '2' AND tipoinmueble = '0' AND id!= '7472' ORDER BY fecha_pu desc LIMIT 0, 3
Tipo vivienda: town house
PVP:
2
4
186
0
, ,
Tel.
SIMILAR PROPERTIES