Results of search

Add to my search Arrange for:
  • Search for:
  • Qualities:
Apartment in residential with comunnal swimmingpool and gardens,
Living-dinig/room, kitchen, 1 double bedrooms, wardrobes, 1 bathroom, parket floors, terrace, comunnal swimmingpool and gardens,

130,000 €

Hire-Purchase. Detached chalet with comunnal swimmingpool,
Living room, furnished kitchen, 3 bedrooms, 1 bathrooms, toilet, cold/hot air conditioning, terraces, garden, comunnal swimming pool and garage.

275,000 €

Array
(
    [idIsland] => 1
    [idZone] => 28
    [idSubzone] => 87
    [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 = '28' OR id_zonesinternatname = '28')) AND ((id_subzonenatname = '87' OR id_subzoneinternatname = '87')) ORDER BY `price` asc