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

190.000 Eur

urban plot for sale in portocolom

urban plot for sale in portocolom

190.000 Eur

M2 Viv.: 300

1 1 1 1

M2 Viv.: 300

Majorca Majorca Majorca Majorca

urban plot for sale in portocolom For sale 2 urban plots in Portocolom, plots of 150sqm. Warehouse or garage of 30 m². Magnificent location just 5 minutes from the beach !!! Ref. BM5756

Hace 2 meses

Hace 2 meses

130.000 Eur

Apartment in a very nice area of ​​Portocolom

Apartment in a very nice area of ​​Portocolom

130.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Apartment in a very nice area of ​​Portocolom The apartment is located very close to the beach of Portocolom, in the second line of the sea. It consists of living room, kitchen, 2 bedrooms, 2 bathrooms and a large laundry and terrace. The p...

Hace mas de 6 meses

Hace mas de 6 meses


    int(1)
  • 1