bool(false) string(786) "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 = 'escorca' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in escorca

475.000 Eur

House in Escorca, Sa Calobra, has a holiday license

House in Escorca, Sa Calobra, has a holiday license

475.000 Eur

Dormitorios: 5 Baños: 2 M2 Viv.: 320

1 1 1 1

Dormitorios: 5 Baños: 2 M2 Viv.: 320

Majorca Majorca Majorca Majorca

Natural stone house, has a vacation license and occupancy certificate. with 320 m², 1,500m² of garden, with possibility of swimming pool and 7,200 m² of land with olive trees and carob trees. It is located in the heart of the Serra de la Tramuntan...

Hace 2 meses

Hace 2 meses

398.000 Eur

Stone house in Lluc, Escorca, has a holiday license.

Stone house in Lluc, Escorca, has a holiday license.

398.000 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 135

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 135

Majorca Majorca Majorca Majorca

Nice natural stone chalet of 135 m², has a vacation license and occupancy certificate. built in the year 2000 in the heart of the Sierra de Tramuntana, in an urban plot of 1,400 m² with beautiful views of Tramuntana. Possibility to build a pool. It...

Hace 2 meses

Hace 2 meses