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

447.000 Eur

Semi-reformed manor house in Campo

Semi-reformed manor house in Campo

447.000 Eur

Dormitorios: 5 Baños: 1 M2 Viv.: 290

1 1 1 1

Dormitorios: 5 Baños: 1 M2 Viv.: 290

Majorca Majorca Majorca Majorca

Semideformed manor house in Campo. Maginifica typical Mallorcan manor house semireformada in the heart of the town of fields, the house is located in a quiet residential area but a few meters from all services such as schools, shops, banks and others. The house has a ground floor with 2 very large bedrooms...

Hace 7 dias

Hace 7 dias

451.000 Eur

Large finca to reform in Campos

Large finca to reform in Campos

451.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Large estate of 31,000 m2 and 900 m2 of construction to be renovated in Campos. This huge estate has 31,000 m2 of land with 900 m2 of housing and adjoining buildings that can be renovated, has unobstructed views and is in a totally private and quiet place for those who love the areas to relax. It has a hou...

Hace 2 meses

Hace 2 meses

1.395.000 Eur

Magnificent finca in Campos with luxury qualities and views to Cabrera. Magnificent finca in Campos

Magnificent finca in Campos with luxury qualities and vie...

1.395.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Magnificent finca in Campos with luxury qualities and views to Cabrera. Magnificent finca in Campos with stone facade, 28325 m2 of land and a charming house of 344 m2 in a pleasant, quiet environment, offering the opportunity to live in the countrys...

Hace 5 meses

Hace 5 meses

145.000 Eur

house with large patio

house with large patio

145.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

house with large patio and well located in fields House located in the center of the urban area of ​​fields, very well located, magnificent opportunity, 2 houses for the price of 1 Plot of 150m2 aprox on which is a building of about 252 m2 approx. Distributed in: Ground floor a large store of abo...

Hace mas de 6 meses

Hace mas de 6 meses

160.000 Eur

Flat with parking and swimming pool in Campos

Flat with parking and swimming pool in Campos

160.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

Flat with parking and swimming pool in Campos. Apartment with communal pool, garden, playground and parking in Campos. The flat has about 90 m2 and is composed of living room, kitchen, 2 bedrooms, 2 bathrooms, utility room. The property has cen...

Hace mas de 6 meses

Hace mas de 6 meses

690.000 Eur

Large typical Magnificent house with garden and pool in Campos

Large typical Magnificent house with garden and pool in C...

690.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Large typical Magnificent house with garden and pool in Campos. Magnificent house on the outskirts of Campos with 4 bedrooms, 3 bathrooms one of them en suite with jacuzzi and shower, large dining room, hall, games room in the upper part of the house...

Hace mas de 6 meses

Hace mas de 6 meses


    int(1)
  • 1