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 = 'campanet' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in campanet

75.000 Eur

 7646647

75.000 Eur

Dormitorios: 2 Baños: 1 M2 Viv.: 90

1 1 1 1

Dormitorios: 2 Baños: 1 M2 Viv.: 90

Majorca Majorca Majorca Majorca

Hace 2 dias

Hace 2 dias

199.900 Eur

Rustic property, 20,000 m2. Campanet

Rustic property, 20,000 m2. Campanet

199.900 Eur

M2 Viv.: 100

1 1 1 1

M2 Viv.: 100

Majorca Majorca Majorca Majorca

Sold property of 20,000 m2 with possibility of water and light, between Campanet and Selva. Currently with some old constructions of about 100 m2 totally to reform. Farm very clear. Views to tramuntana, Possibility to build 450 m2 maximum density 550...

Hace mas de 6 meses

Hace mas de 6 meses

290.000 Eur

Fantastic finca in Campanet

Fantastic finca in Campanet

290.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

For sale finca in Campanet with magnificent views to tramuntana and Bay of Alcudia. Privileged environment. Sold finca of 17,700 m2. Hillside of the mountain, farm stoned of two corteradas and average. With project for construction of 425 m2. 525 m2 total. Possibility of GESA light....

Hace mas de 6 meses

Hace mas de 6 meses

580.000 Eur

Finca, villa. Campanet

Finca, villa. Campanet

580.000 Eur

Dormitorios: 4 Baños: 3 M2 Viv.: 220

1 1 1 1

Dormitorios: 4 Baños: 3 M2 Viv.: 220

Majorca Majorca Majorca Majorca

Country house in Cami vell de Pollensa, Campanet, 6874 m2 with villa 220 m2., Consists of entrance hall, 2 furnished and equipped kitchens, living room, fireplace, 4 double bedrooms with fitted wardrobes 3 bathrooms, swimming pool, terraces, garden, garage , drinking water, light gesa, AA, fenced, views sierr...

Hace mas de 6 meses

Hace mas de 6 meses