bool(false) string(796) "SELECT anuncios.*, tipos.en as type, poblaciones.en as poblaciones, poblaciones.en_url as poblacion_url, tipos.en_url as tipos_url, provincias.en_url as provincia, provincias.en FROM anuncios left join tipos on tipos.id = anuncios.tipo left join poblaciones on poblaciones.id = anuncios.pueblo left join provincias on provincias.id = anuncios.provincia WHERE precioventa between 0 AND 50000000 AND poblaciones.en_url = 'porto-cristo-novo' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in porto cristo novo

150.000 Eur

Apartment in the center of Porto Cristo.

Apartment in the center of Porto Cristo.

150.000 Eur

Dormitorios: 4 Baños: 2 M2 Viv.: 96

1 1 1 1

Dormitorios: 4 Baños: 2 M2 Viv.: 96

Majorca Majorca Majorca Majorca

Flat in the center of Porto Cristo. Great apartment in a quiet area in the center of Porto Cristo just 2 minutes walk from the beach with all services such as supermarkets, shops and restaurant nearby, a great way to live comfortably in a village lik...

Hace 4 meses

Hace 4 meses

135.000 Eur

Penthouse with 40 m2 of terrace in Porto Cristo.

Penthouse with 40 m2 of terrace in Porto Cristo.

135.000 Eur

Dormitorios: 4 Baños: 1 M2 Viv.: 130

1 1 1 1

Dormitorios: 4 Baños: 1 M2 Viv.: 130

Majorca Majorca Majorca Majorca

Penthouse with approx 40 m2 terrace in Porto Cristo. This Maginifico apartment is located in the center of the Village of Porto Cristo with all kind of services around, 5 minutes from the beach and 5 minutes from the hospital of Porto Cristo. The ...

Hace 4 meses

Hace 4 meses