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