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 = 'ariany' AND provincias.en_url = 'majorca' ORDER BY fechaactualizado DESC, id DESC LIMIT 0,30" Property For Sale in ariany

140.000 Eur

Ariany, building 14.200 m2 buildable, views.

Ariany, building 14.200 m2 buildable, views.

140.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

For sale rustic property in Ariany, Buildable. estate on slope and with beautiful views on the upper part towards the Port of Alcudia. 2 water wells, with the possibility of irrigation water. surface 14,200 m2. Buildable

Hace 4 meses

Hace 4 meses

270.000 Eur

House for sale in Ariany

House for sale in Ariany

270.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

House for sale in Ariany House in Ariany of 2 floors, ground floor with 3 bedrooms, large living room, kitchen and bathroom. Ground floor in buc. Beautiful housing with access from 2 streets and with its more than 300m2 of patio makes it a magnificent opportunity to reform and to obtain a luxurious house ...

Hace 5 meses

Hace 5 meses

375.000 Eur

Finca in Ariany

Finca in Ariany

375.000 Eur

M2 Viv.: 1000

1 1 1 1

M2 Viv.: 1000

Majorca Majorca Majorca Majorca

Finca in Ariany with more than 1000m2. Finca in Ariany with more than 1000m2.  The farm is divided in 800m2 aprox. In agricultural warehouses plus a house of 200m2 aprox. It has a cistern of 100 tn. Of water plus two wells and electricity of gesa. Land of approximately 28000m2. Ref. BM5527...

Hace mas de 6 meses

Hace mas de 6 meses

160.000 Eur

Ground floor house in Ariany

Ground floor house in Ariany

160.000 Eur

Dormitorios: 3 Baños: 2

1 1 1 1

Dormitorios: 3 Baños: 2

Majorca Majorca Majorca Majorca

House on ground floor and first floor in Ariany of 250 m2, 3 bedrooms. 3 fireplaces, patio of 70 m2 and upper terrace of 40 m2. Cocheria for two cars, 2 dining rooms, full kitchen, 2 bathrooms, 1 toilet. PRICE 160,000, - EUROS

Hace mas de 6 meses

Hace mas de 6 meses

60.000 Eur

Urban plot Ariany.

Urban plot Ariany.

60.000 Eur

M2 Viv.: 200

1 1 1 1

M2 Viv.: 200

Majorca Majorca Majorca Majorca

Sold solar 400 m2 in Ariany. Central. Possibility of building 200 m2 on two floors. Currently there is an old house totally to be reformed.