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

150.000 Eur

House for sale in the village of Montuiri

House for sale in the village of Montuiri

150.000 Eur

Dormitorios: 3 Baños: 1 M2 Viv.: 170

1 1 1 1

Dormitorios: 3 Baños: 1 M2 Viv.: 170

Majorca Majorca Majorca Majorca

House for sale in the village of Montuiri House for sale in the village of Montuiri very well located. . The property of about 170 m2 is divided into 2 floors, on the first floor is a spacious living room with fireplace, an inner courtyard of abou...

Hace mas de 6 meses

Hace mas de 6 meses

130.000 Eur

Building land in Montuiri

Building land in Montuiri

130.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Building land in Montuiri For sale Building land a few kilometers from Montuiri with good access, has electricity and water well. Has a clear view all around. Ref. BM5479

Hace mas de 6 meses

Hace mas de 6 meses


    int(1)
  • 1