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