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

282.000 Eur

Business premises, Pollensa

Business premises, Pollensa

282.000 Eur

M2 Viv.: 190

1 1 1 1

M2 Viv.: 190

Majorca Majorca Majorca Majorca

For sale commercial premises of 190 m2, next to Plaza Miguel Capllonch, with small patio outside, Currently with facilities for bar, exit of fumes, bathrooms, and toilet handicapped.

Hace mas de 6 meses

Hace mas de 6 meses

2.350.000 Eur

Fartarix Roig Restaurant Reviews, Pollensa

Fartarix Roig Restaurant Reviews, Pollensa

2.350.000 Eur

M2 Viv.: 560

1 1 1 1

M2 Viv.: 560

Majorca Majorca Majorca Majorca

Impressive property FARTARIX ROIG in Pollensa - Lluch. property of 965.524 m2. 60 quarters of cultivation, rest and low forest. Incredible views to Cala San Vicenc, Formentor, Bay of Pollensa, Bay of Alcudia, Barcarets, reached, Coll Baix, Cavall Ber...

Hace mas de 6 meses

Hace mas de 6 meses