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 = 'algaida' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in algaida

499.000 Eur

Country house in Algaida, villa. 2 houses

Country house in Algaida, villa. 2 houses

499.000 Eur

Dormitorios: 6 Baños: 4 M2 Viv.: 446

1 1 1 1

Dormitorios: 6 Baños: 4 M2 Viv.: 446

Majorca Majorca Majorca Majorca

Country house for sale in Algaida, very private area. Finca totally closed and fenced. Finca of 22.000 m2 with 2 totally independent houses, with terraces and porches. Mallorquin style houses. Details like exposed beams, stone walls. The houses have ...

Hace mas de 6 meses

Hace mas de 6 meses

15.000 Eur

Land 5,000 m2. Algaida

Land 5,000 m2. Algaida

15.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

It sells land of 5,000 m2 in Algaida, bordering Montuiri. Possibility of water

Hace mas de 6 meses

Hace mas de 6 meses

350.000 Eur

Magnificent country house, between Algaida and Santa Eugenia

Magnificent country house, between Algaida and Santa Euge...

350.000 Eur

M2 Viv.: 150

1 1 1 1

M2 Viv.: 150

Majorca Majorca Majorca Majorca

LAST PRICE. NOT NEGOCIABLE. Magnificent finca rustic between Algaida and Santa Eugenia, 11 quarters of land part of the hill, part of the cultivation, several levels, garriga, House to reform 150 m2, with character, with the possibility of building 4...

Hace mas de 6 meses

Hace mas de 6 meses