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

163.000 Eur

 7646680

163.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Hace 7 dias

Hace 7 dias

445.000 Eur

House with pool in Palma de Mallorca

House with pool in Palma de Mallorca

445.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

House with pool in Palma de Mallorca House with pool in Palma de Mallorca. Villa located in residential area of Secar de la Real. Great quiet environment just 15 minutes from the center of Palma and a few minutes from the Hospital of Son Espasses an...

Hace 2 meses

Hace 2 meses

0 Eur

Apartment for rent, 5th without lift, attic

Apartment for rent, 5th without lift, attic

0 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

AVAILABLE AS OF DECEMBER 1. Rent 5th floor without elevator, without furniture. penthouse with terrace that surrounds the apartment. Living room with terrace. 2 bedrooms, 1 bathroom, small kitchen. Small community of only 10 neighbors. Community incl...

Hace 4 meses

Hace 4 meses

322.000 Eur

Flat for sale in Palma

Flat for sale in Palma

322.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Apartment for sale in Palma Apartment for sale in Palma, Olmos area, bright apartment with 3 bedrooms and 2 bathrooms. Large living room, kitchen furnished and equipped with appliances. The apartment is located in the center of Palma, area of bars and restaurants, playgrounds and shopping centers. ...

Hace 4 meses

Hace 4 meses

205.000 Eur

Flat, Palma, zone Son Rullán

Flat, Palma, zone Son Rullán

205.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Flat for sale in Son Rullán area of ​​Palma. Housing of 100 m2 consisting of 3 bedrooms, 2 bathrooms, one with shower, large living room with exit to balcony of 4 m2, fitted and equipped kitchen, utility room of 5 m2. Parking space and storage. First qualities, central heating and air conditioning....

Hace mas de 6 meses

Hace mas de 6 meses

320.000 Eur

Flat in Palma

Flat in Palma

320.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Flat in Palma, Flat in Palma, 134 mts of housing, plus parking space. The property is situated in a very sought after and sought after area of Palma center, just a few meters from Avenidas and Plaza España. Distribution: 4 bedrooms with wardrobes and 2 bathrooms. Large living room and dining room with 2 t...

Hace mas de 6 meses

Hace mas de 6 meses

600.000 Eur

Penthouse in Paseo Marítimo, Palma

Penthouse in Paseo Marítimo, Palma

600.000 Eur

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

1 1 1 1

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

Majorca Majorca Majorca Majorca

Spectacular penthouse in Palma de Mallorca, Paseo Marítimo. Great luminosity, spectacular views to the sea.It consists of 162m2 habitable and 153m2 of private terrace. The attic has heating and air conditioning, high quality parquet, all wood joinery, alarm and video intercom. Common areas: Impressive entran...

Hace mas de 6 meses

Hace mas de 6 meses