Results of search

Add to my search Arrange for:
  • Search for:
  • Qualities:
Completely refurbished apartment,
Palma City / Ref 44011

Completely refurbished apartment,

Living-/dining room with integrated fitted kitchen, 1 bedroom, 1 bathroom en suite, porcelain stoneware floors, double glazing, air conditioning hot/cold by conduit.

283,000 €

Top quality flat in the centre of Palma,
Approx 105 m2, spacious living-/ dining room with chimney, fitted kitchen with dining area, 3 double bedrooms, wardrobes, 2 bathrooms, parquet floors, double glazing, heating, air conditioning, terrace of approx. 10 m2. Furnished.

567,000 €

Flat in area Avenidas,
Palma City / Ref 44263

Flat in area Avenidas,

Approx. 153 m2, spacious living-dining room, fitted kitchen, 4 bedrooms, wardrobes, 2 bathrooms, 1 en suite, parquet floors, double glazing, heating, air conditioning, porch of approx. 15 m2, 1 parking space.

650,000 €

Array
(
    [idIsland] => 1
    [idZone] => 1
    [idSubzone] => 6
    [idCity] => 0
    [propertyType] => 0
    [propertyTypeGroup] => 0
    [key_code] => V,VP
    [priceIni] => 0
    [priceEnd] => 15000000
    [roomIni] => 1
    [roomEnd] => 6
    [refNumber] => 
    [cpool] => 
    [cgarden] => 
    [cviews] => 
    [cdown] => 
    [cterrain] => 
    [luxuryweb] => 
    [order] => Array
        (
            [0] => price asc
        )

)
\nSELECT `v_geidshouses`.* FROM `v_geidshouses` WHERE (1) AND (published = 'YES') AND (id_subzone IS NOT NULL) AND (key_code IN ('V', 'VP')) AND (id_island = 1) AND ((id_zonesnatname = 1 OR id_zonesinternatname = 1)) AND ((id_subzonenatname = '6' OR id_subzoneinternatname = '6')) ORDER BY `price` asc