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

109.000 Eur

Rustic plot Sineu, buildable

Rustic plot Sineu, buildable

109.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

For sale rustic property in Sineu. Cultivation area, with its own water well. Building land, there is a project for the construction of a detached house of 260 m2. At present there is an old stone construction of about 50 m2.

Hace 4 meses

Hace 4 meses

253.000 Eur

Rural property, Sineu

Rural property, Sineu

253.000 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 180

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 180

Majorca Majorca Majorca Majorca

Rustic land for sale in Sineu, of 7.300 m2 of land with a construction of 180 m2, distributed in 2 large living rooms, one with integrated kitchen, three bedrooms two bathrooms. One of the bedrooms very spacious with own bathroom. It has GESA light and own well water. Finca totally closed of dry wall. Very cl...

Hace mas de 6 meses

Hace mas de 6 meses

1.200.000 Eur

Finca, Sineu, 79,000 m2, house of 360 m2.

Finca, Sineu, 79,000 m2, house of 360 m2.

1.200.000 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 360

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 360

Majorca Majorca Majorca Majorca

Magnificent farm of 79.000 m2, located at the top of the hill, of authentic Mallorcan character, totally reformed. House with lots of charm, currently 3 bedrooms, 2 bathrooms, possibility to expand the house on the first floor. Several annex building...

Hace mas de 6 meses

Hace mas de 6 meses

199.000 Eur

Fantastic duplex, Sineu

Fantastic duplex, Sineu

199.000 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 140

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 140

Majorca Majorca Majorca Majorca

Fantastic duplex for sale of 140 m2. in Sineu. Magnificent qualities, ground floor, large living room, with exit balconies, fitted and equipped kitchen with laundry room, dressing room suite with bathroom. Upper floor with sloping ceilings, with terrace of about 30 m2. 2 bedrooms, bathroom, several closets. P...

Hace mas de 6 meses

Hace mas de 6 meses

289.000 Eur

Town House in Sineu

Town House in Sineu

289.000 Eur

Dormitorios: 4 Baños: 2 M2 Viv.: 140

1 1 1 1

Dormitorios: 4 Baños: 2 M2 Viv.: 140

Majorca Majorca Majorca Majorca

House for sale in Sineu. Ground floor, free roof with garden, overlooks two streets. Reformed with charm, preserving details. It consists of ground floor with entrance hall, 1 bedroom, large dining room, stone wall, spacious kitchen furnished and equipped with oficce and living room with fireplace, bathroom, ...

Hace mas de 6 meses

Hace mas de 6 meses

239.000 Eur

Country estate Sineu, Son Rossinyol.

Country estate Sineu, Son Rossinyol.

239.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Sold house of 110 m2. more terraces and porch, in a rustic Finca of 13.500 m2. Area Son Rossinyol. House slope finish finished work. 3 bedrooms, living room with open kitchen, living room with fireplace, 3 bedrooms. 1 bathroom, Torreon, marble finish...

Hace mas de 6 meses

Hace mas de 6 meses