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

130.000 Eur

 7646610

130.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Apartment for sale in Arta with a clear view to the mountains and very quiet street of easy parking. The property is distributed: large living room with fireplace, kitchen, 3 bedrooms, 1 bathroom, balcony. more information www.blaumallorca.com te;n en www.blaumallorca.com Tel. (+34) 659 07 53 26...

Hace 3 horas

Hace 3 horas

1.590.000 Eur

Historic land for renovation close to Arta

Historic land for renovation close to Arta

1.590.000 Eur

Dormitorios: 5 Baños: 2 M2 Viv.: 500

1 1 1 1

Dormitorios: 5 Baños: 2 M2 Viv.: 500

Majorca Majorca Majorca Majorca

Historic land for renovation close to Arta This country house completely lined with stone, is framed in a land of 57600m2, with dry land, irrigated land and native trees. The whole of the estate maintains its essence of yesteryear and pushes you to s...

Hace 4 meses

Hace 4 meses

320.000 Eur

House with commercial premises in Arta.

House with commercial premises in Arta.

320.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

House with commercial premises, very close to the center. House of 474 meters built on a plot of 173 meters a few meters from the center of Arta. The property is distributed in ground floor, in a large garage for two cars, with bathroom, and area ...

Hace 4 meses

Hace 4 meses

80.000 Eur

Finca in Arta

Finca in Arta

80.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Finca in Arta Spectacular land in the area of ​​Na Pineda, "Bellpuig" of Arta. Clear views in a natural setting. Easy access to the farm. 7200m2 of land on which is a building of more than 150 years of about 20m2 approx. Ref. BM5701

Hace 4 meses

Hace 4 meses

7.000.000 Eur

Hotel for sale in Mallorca

Hotel for sale in Mallorca

7.000.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Hotel for sale in Mallorca HOTEL 113 Rooms 4 stars

Hace 5 meses

Hace 5 meses

172.000 Eur

House located in the center of the old town of Arta

House located in the center of the old town of Arta

172.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

House located in the center of the old town of Arta House located in the center of the old town of Arta, close to restaurants, shops ... The house is divided into three floors: Ground floor has 1 bedroom, kitchen, living room, bathroom and a se...

Hace 5 meses

Hace 5 meses

214.500 Eur

Plot with project in Artà Solar of 343 m2 in Artà to about 100 mts of the institute. It has a basic

Plot with project in Artà Solar of 343 m2 in Artà to ab...

214.500 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Plot with project in Artà Solar of 343 m2 in Artà to about 100 mts of the institute. It has a basic project of 4 flats, 2 premises and parking. You can also build a detached house. The plot is very well located and sunny in a corner stree...

Hace 5 meses

Hace 5 meses

990.000 Eur

Finca in Artá

Finca in Artá

990.000 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 180

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 180

Majorca Majorca Majorca Majorca

Finca in Artá ​​with splendid clear views to the mountain dels Ferrut. Finca 5 minutes from the town center but with the tranquility that gives living in the countryside surrounded by nature and beautiful views, this finca offers a house with a lot of character and charm typical Mallorquìn, has wooden b...

Hace mas de 6 meses

Hace mas de 6 meses

160.900 Eur

Commercial premises in Artà

Commercial premises in Artà

160.900 Eur

Dormitorios: 1 M2 Viv.: 80

1 1 1 1

Dormitorios: 1 M2 Viv.: 80

Majorca Majorca Majorca Majorca

Commercial premises in Artà Commercial premises in Artà of about 80 m2, distributed in 1 large room, a small room and 1 toilet. Ideal for any type of business. Located in commercial and busy area of Artà. Great opportunity for investors! Ref. BM5542...

Hace mas de 6 meses

Hace mas de 6 meses

177.000 Eur

House in the village of Artà

House in the village of Artà

177.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

House in the village of Artà to restore This village house in the heart of Artà with about 130 m2 of housing and about 100 m2 of patio and terraces has many possibilities. The house with two elevations is distributed in 4 bedrooms, 2 bathrooms, an entrance, a living room with fireplace, a kitchen with f...

Hace mas de 6 meses

Hace mas de 6 meses

305.500 Eur

House completely renovated in Artà

House completely renovated in Artà

305.500 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 126

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 126

Majorca Majorca Majorca Majorca

House completely renovated in Artà Nice townhouse in Arta with 126 m2, completely renovated and located in the center. It is distributed on two floors. On the ground floor when entering we find a diaphanous space comprising living room, dining room and kitchen. On this same floor there is a single bedroom...

Hace mas de 6 meses

Hace mas de 6 meses

643.500 Eur

Building land in Artà

Building land in Artà

643.500 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Building land in Artà This building land of 24.000 m2 is located near Artà in a quiet and accessible place and with beautiful clear views up to the mountains. It has well water. Electricity from "Gesa" passes directly at the entrance to the estate. Ref. BM5520...

Hace mas de 6 meses

Hace mas de 6 meses

375.000 Eur

Finca in Artà

Finca in Artà

375.000 Eur

Dormitorios: 2 Baños: 1 M2 Viv.: 174

1 1 1 1

Dormitorios: 2 Baños: 1 M2 Viv.: 174

Majorca Majorca Majorca Majorca

Finca in Artà Beautiful and nice Finca in Artà with a fenced plot of 11.103 m2 and a country house of 147 m2 plus an annex that can be converted into an independent studio. The Finca is located in a quiet area of "Bel Puig" with beautiful unobstructed views. The House of two heights has an entrance, a...

Hace mas de 6 meses

Hace mas de 6 meses

148.500 Eur

Charming old town house in Arta

Charming old town house in Arta

148.500 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Charming old town house in Arta Charming old town house in Arta with 4 bedrooms, 2 bathrooms, large kitchen with pantry, living room, living room, two small patios, terrace and two large reception rooms. The house has air conditioning in the living room and bedrooms, exposed beams throughout the house upst...

Hace mas de 6 meses

Hace mas de 6 meses

157.500 Eur

Duplex in Artá

Duplex in Artá

157.500 Eur

Dormitorios: 3 Baños: 2 M2 Viv.: 92

1 1 1 1

Dormitorios: 3 Baños: 2 M2 Viv.: 92

Majorca Majorca Majorca Majorca

Duplex in Artá ​​of 3 bedrooms, 2 bathrooms Duplex in Artá ​​of 3 bedrooms, 2 bathrooms, fitted and equipped kitchen, large living room, laundry and parking space. The house consists of heating, installation of solar panels in the community, water purifier for saving water in cisterns and others....

Hace mas de 6 meses

Hace mas de 6 meses

1.000.000 Eur

Urban plot in Arta

Urban plot in Arta

1.000.000 Eur

1 1 1 1

Majorca Majorca Majorca Majorca

Urban plot in Arta, Solar Urban located in privileged area at the entrance of the village of Arta. 2800 m2 approx. Edicable according to current legislation: Floor Sotano (parking) 100% Height of the building 1metros = Ground floor plus two heights. Ground floor .. or homes or commercial premis...

133.000 Eur

Apartment for sale in Arta

Apartment for sale in Arta

133.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Apartment in Arta Apartment for sale in Arta with a clear view to the mountains and very quiet street of easy parking. The property is distributed: large living room with fireplace, kitchen, 3 bedrooms, 1 bathroom, balcony. Ref. BM5356