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

390.000 Eur

Industrial Building, Polígono Santa María

Industrial Building, Polígono Santa María

390.000 Eur

M2 Viv.: 300

1 1 1 1

M2 Viv.: 300

Majorca Majorca Majorca Majorca

It sells industrial ship in the Poligono of Santa Maria of the Cami, in solar of 500 m2. closed and with entrance barriers, front yard of 200 m2, built 600 m2 on two floors and a loft of 50 m2. Equipped with 8 cold rooms, two elevators, several rooms...

Hace mas de 6 meses

Hace mas de 6 meses

250.000 Eur

Rural property, Santa María del Camí

Rural property, Santa María del Camí

250.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Sold property in Santa Maria del Cami, 30.068 m2. Ideal for vineyards. Equivalent to 4 corteradas and a half. Finca very clear where at the moment there is an old construction totally to reform. On the farm you can build housing of 550 m2 const. 450 ...

Hace mas de 6 meses

Hace mas de 6 meses


    int(1)
  • 1