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

215.000 Eur

Large house of 268 meters in a plot of 259 meters in Son Macia

Large house of 268 meters in a plot of 259 meters in Son ...

215.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Large house of 268 meters in a plot of 259 meters in Son Macia Large house of 268 meters in a plot of 259 meters in Son Macia. The house situated on a wide street, is divided into two floors. The ground floor is distributed with 4 bedrooms, lar...

Hace mas de 6 meses

Hace mas de 6 meses