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

310.000 Eur

Casa adosa in Binissalem

Casa adosa in Binissalem

310.000 Eur

Dormitorios: 5 Baños: 4 M2 Viv.: 210

1 1 1 1

Dormitorios: 5 Baños: 4 M2 Viv.: 210

Majorca Majorca Majorca Majorca

For sale semi-detached house of 210 m2 in Binissalem. Property of three floors distributed in, ground floor with large garage, laundry, 1 bedroom and bathroom with shower, exit to patio with barbecue. First floor with large kitchen furnished and equipped with pantry and office, and exit to patio. Large living...

Hace 5 meses

Hace 5 meses

35.000 Eur

Rural property, Binissalem

Rural property, Binissalem

35.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

I am selling a rustic finca just 1 kilometer from Binissalem. 4. 250 m2. possibility of water and light at the foot of finca. Well comunicated. It is not buildable.

Hace mas de 6 meses

Hace mas de 6 meses