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

212.000 Eur

Bright ground floor in Canyamel

Bright ground floor in Canyamel

212.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Bright ground floor in Canyamel In Canyamel, in a residential area, just 100 meters from the sea, this bright apartment is found on the ground floor. The 75 m2 of surface are distributed in such a way that it appears to be a much larger and spacious housing, as it also enjoys two wonderful terraces of 30 m...

Hace mas de 6 meses

Hace mas de 6 meses

139.500 Eur

Flat in Canyamel

Flat in Canyamel

139.500 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Flat in Canyamel with communal Pool and Gardens Nice apartment in communal area in Canyamel only 5 minutes walk from the beach with 40 m2 useful plus 15 m2 covered terrace. The apartment consists of 1 double bedroom with 2 built-in wardrobes, 1 large en-suite bathroom, living room with views to gardens and...

Hace mas de 6 meses

Hace mas de 6 meses

1.020.000 Eur

Villa for sale located in the urbanization of Canyamel

Villa for sale located in the urbanization of Canyamel

1.020.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Villa for sale located in the urbanization of Canyamel Villa for sale located in the urbanization of Canyamel in an area of ​​exclusive tranquility surrounded by pleasant views to the mountains and the sea, and with private access to the beach. ...

Hace mas de 6 meses

Hace mas de 6 meses