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

289.000 Eur

 7646602

289.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Hace 7 dias

Hace 7 dias

804.000 Eur

Villa for sale in Colonia de San Pedro

Villa for sale in Colonia de San Pedro

804.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Villa for sale in Colonia de San Pedro Detached villa of 3 floors with swimming pool, is located on a plot of 455 m² with a total built area of ​​445 m². In the basement we find a parking with capacity for 4 vehicles, 1 bedroom, storage room, e...

Hace 4 meses

Hace 4 meses

292.000 Eur

Large local in the sea area and the square in Colonia de San Pere

Large local in the sea area and the square in Colonia de ...

292.000 Eur

Baños: 2 M2 Viv.: 200

1 1 1 1

Baños: 2 M2 Viv.: 200

Majorca Majorca Majorca Majorca

Large place in the area of the sea and the square in Colonia de San Pere Local in a central area of about 200 m2 100 meters from the sea and the pedestrian zone of Colonia San Pere. The corner room consists of two floors. The ground floor and anot...

Hace 4 meses

Hace 4 meses

550.000 Eur

Finca of 25.000m2 of land and house with stunning sea views in Colonia San Pere

Finca of 25.000m2 of land and house with stunning sea vie...

550.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Finca of 25.000m2 of land and house with stunning sea views in Colonia San Pere !!! Finca of 25.000m2 of protected land with house to finish of 145 m2 plus cellar of other 140 m2 adaptable for garage or housing, this finca is in an excellent area of ...

Hace 4 meses

Hace 4 meses

550.000 Eur

Finca of 25.000m2 of land, house with sea and mountain views in Colonia San Pere

Finca of 25.000m2 of land, house with sea and mountain vi...

550.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Finca of 25.000m2 of land, house with sea and mountain views in Colonia San Pere !!! Finca of 25.000m2 of protected land with house to finish of 145 m2 plus cellar of other 140 m2 adaptable for garage or housing, this finca is in an excellent area of...

Hace 4 meses

Hace 4 meses

210.000 Eur

Building land near Colonia San Pere !!!

Building land near Colonia San Pere !!!

210.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Building land near Colonia San Pere !!! It is a farm located on the road from Colonia de Sant Pere to Manacor (just over 1 km from the junction on the road of Artá The farm has an area of approximately 20,000 square meters, it is a rustic farm compl...

Hace 4 meses

Hace 4 meses

236.000 Eur

Villa to finish in Colonia de Sant Pedro This Villa with about 245 m2 in Colonia de San Pere is buil

Villa to finish in Colonia de Sant Pedro This Villa with ...

236.000 Eur

M2 Viv.: 245

1 1 1 1

M2 Viv.: 245

Majorca Majorca Majorca Majorca

Villa to finish in Colonia de Sant Pedro This Villa with about 245 m2 in Colonia de San Pere is built on a plot of about 400 m2 in a quiet place and a few meters from the sea. It consists of 3 floors - the ground floor of 106 m2, the first floor ...

Hace 5 meses

Hace 5 meses

292.000 Eur

Maginifica house with sea views in Colonia San Pere

Maginifica house with sea views in Colonia San Pere

292.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Maginifica house with sea views in Colonia San Pere. House 50 m from the sea with views to the mountain. It consists of 3 bedrooms, 3 bathrooms, private garage, living room with fireplace, kitchen, storage room and cellar, plus 3 terraces, solariu...

Hace 5 meses

Hace 5 meses

107.300 Eur

Studio near the sea in Colonia Sant Pere Nice studio of 50 m2 in Colonia de Sant Pere just 20 meters

Studio near the sea in Colonia Sant Pere Nice studio of 5...

107.300 Eur

Baños: 1 M2 Viv.: 50

1 1 1 1

Baños: 1 M2 Viv.: 50

Majorca Majorca Majorca Majorca

Studio near the sea in Colonia Sant Pere Nice studio of 50 m2 in Colonia de Sant Pere just 20 meters from the beach. The studio is in very good condition with lots of light. It has air conditioning and fireplace. Colonia de Sant Pere is an ...

Hace 5 meses

Hace 5 meses