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

106.000 Eur

Sale of several plots in urbanization of Sa Rápita

Sale of several plots in urbanization of Sa Rápita

106.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Sale of several plots in urbanization of Sa Rápita OPPORTUNITY!!! Sale of several plots in urbanization of Sa Rápita, in a very quiet street 5 minutes walk from the coast of Sa Rápita and views to the Cabrera Island They are independent sola...

Hace 5 meses

Hace 5 meses

795.000 Eur

Comprising basement floor of 185m2

Comprising basement floor of 185m2

795.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Comprising basement floor of 185m2 with parking for 3 cars Comprising basement floor of 185m2 with parking for 3 cars, laundry, gym, rustic kitchen and storage area with shelves. Ground floor of 135m2, with nice and bright living room, fully equipped kitchen, 2 bathrooms 1 in suit, 2 bedrooms one with a co...

Hace mas de 6 meses

Hace mas de 6 meses

275.500 Eur

Detached villa in Sa Rápita

Detached villa in Sa Rápita

275.500 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Detached villa in Sa Rápita with views to the sea and Cabrera !! The house consists of living room, kitchen, bathroom and 4 bedrooms on the first floor and the second floor is composed of 2 bedrooms, bathroom, laundry and living room with sloping ceilings throughout the plant. The house has front porch co...

Hace mas de 6 meses

Hace mas de 6 meses

339.000 Eur

Beautiful Chalet 5 min from the sea in Sa Rápita

Beautiful Chalet 5 min from the sea in Sa Rápita

339.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Beautiful Chalet 5 min from the sea in Sa Rápita. This Chalet consists of 3 double bedrooms with fitted wardrobes each, 2 full bathrooms and equipped, living room, kitchen with laundry room, large front porch, large backyard with pool, barbecue area...

Hace mas de 6 meses

Hace mas de 6 meses


    int(1)
  • 1