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

0 Eur

For sale Country house. 3,500 m2

For sale Country house. 3,500 m2

0 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Country house for rent in Llubi Santa Margalida road, completely closed with dry wall and barbed wire. Available from September 25th. with land of 3,500 m2 and stables or dependencies for animals of about 65 m2, not suitable for housing. with cistern....

Hace mas de 6 meses

Hace mas de 6 meses

690.000 Eur

Rural property Llubi, 76.325 m2

Rural property Llubi, 76.325 m2

690.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Country house in Llubi. Land of 76.325 m2. equivalent to about 10 corteradas. 2 own water wells with a flow of about 40,000 liters / hour. each. Safraig of 2 million liters. Sprinkler irrigation throughout the farm. Price 690,000 euros

Hace mas de 6 meses

Hace mas de 6 meses