GGGGGGGGGGGGGGGGGGGSELECT id FROM inmuebles WHERE visible=1 AND tipooperacion = '2' AND pais = '67' AND provincia = '7' AND municipio = '818' AND numhabitaciones = '5' AND tipoinmueble = '40' AND id!= '5635' ORDER BY fecha_pu desc LIMIT 0, 3
Tipo vivienda: casa con terreno
PVP:
5
2
338
338
, ,
Tel.
PROPIEDADES SIMILARES