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

660.000 Eur

Rural property, Selva

Rural property, Selva

660.000 Eur

M2 Viv.: 350

1 1 1 1

M2 Viv.: 350

Majorca Majorca Majorca Majorca

Rustic finca for sale in Selva of 26.000 m2 with elegant structure to finish of 350 m2. (Project with Pool). Magnificent views Alcudia, tramuntana, hamlets as buger and Campanet, The current construction already indicates the approach in terms of qualities, The project is made based on high end finishes with ...

Hace mas de 6 meses

Hace mas de 6 meses

163.000 Eur

Duplex house in Selva

Duplex house in Selva

163.000 Eur

Dormitorios: 3 Baños: 3 M2 Viv.: 185

1 1 1 1

Dormitorios: 3 Baños: 3 M2 Viv.: 185

Majorca Majorca Majorca Majorca

Nice Duplex in Selva of 185 m2 3 bedrooms and 3 bathrooms with two heights. It consists of two bedrooms with an en suite bathroom in one of them with exit to individual terrace, another bathroom with bath, kitchen with bar and living room upstairs. Salita with fireplace, living room with several heights, room...

Hace mas de 6 meses

Hace mas de 6 meses

375.000 Eur

Beautiful house in Selva

Beautiful house in Selva

375.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Sold beautiful house in Selva, central of 430 m2, with garden of 250 m2. Construction of 1,800 fully renovated. Great views. Possibility of two houses. The house consists of 4 double bedrooms. 5 bathrooms, 3 living rooms, 2 kitchens. Heating and air throughout the house. Barbecue, wood oven, Swimming pool, po...

Hace mas de 6 meses

Hace mas de 6 meses

950.000 Eur

Villa, country house in Selva

Villa, country house in Selva

950.000 Eur

Dormitorios: 6 Baños: 5 M2 Viv.: 750

1 1 1 1

Dormitorios: 6 Baños: 5 M2 Viv.: 750

Majorca Majorca Majorca Majorca

Villa, rustic property located in Selva, fantastic house of 750 m2 built, plus house of 100 m2 guests. 6 bedr. 5 bathrooms, lift, porches and terraces. Swimming pool, Jacuzzi, Jacuzzi in basement, (Possibility gym, cellar) Solar of 15.000 m2. Top quality, Oil heating, Very suitable for holiday. Beautiful tram...

Hace mas de 6 meses

Hace mas de 6 meses

259.000 Eur

Village house with garden, Selva

Village house with garden, Selva

259.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Beautiful village house with garden, in the center of Selva, stone facade, house with character, reformed to enter to live. excellent finishes, 160 m2. Hall, 2 living rooms, open kitchen furnished and equipped with large pantry - cellar and wood oven. Beautiful bathroom completp. 3 double bedrooms, spacious, ...

Hace mas de 6 meses

Hace mas de 6 meses

399.000 Eur

Detached house, Selva

Detached house, Selva

399.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Fantastic townhouse in Selva. New construction, house of about 260 m2, 3 bedrooms, 2 bathrooms, living room of 80 m2, pre-installation air conditioning, pre-installation heating, garage, fully independent housing

Hace mas de 6 meses

Hace mas de 6 meses