Villa
Apartment
Duplex
Penthouse
Ground floor
Cottage
Loft
Offices
Grounds
Companies
Building
Store
Business premises
Duplex-Penthouse
Parking
Mini-Penthouse
Cellar
select distinct lieux.ID,annonce.ville from annonce inner join lieux on lieux.Nom = annonce.ville WHERE 1 AND ( `idag` = '1' OR  `idag` = '474' OR  `idag` = '245' OR  `idag` = '232' OR  `idag` = '83' OR  `idag` = '509' OR  `idag` = '15' OR  `idag` = '457' OR  `idag` = '288' OR  `idag` = '175' OR  `idag` = '60' OR  `idag` = '210' OR  `idag` = '357' OR  `idag` = '281' OR  `idag` = '144' OR  `idag` = '233' OR  `idag` = '226' OR  `idag` = '574' OR  `idag` = '596' OR  `idag` = '291' OR  `idag` = '316' OR  `idag` = '440' OR  `idag` = '342' OR  `idag` = '379' OR  `idag` = '598' OR  `idag` = '599' OR  `idag` = '601' OR  `idag` = '604' OR  `idag` = '606' OR  `idag` = '607' OR  `idag` = '424' OR  `idag` = '427' OR  `idag` = '597' OR  `idag` = '605' OR  `idag` = '511' OR  `idag` = '513' OR  `idag` = '522' OR  `idag` = '525' OR  `idag` = '527' OR  `idag` = '529' OR  `idag` = '577' OR  `idag` = '595' OR  `idag` = '608' OR  `idag` = '609' OR  `idag` = '610' OR  `idag` = '611' OR  `idag` = '618' OR  `idag` = '617' OR  `idag` = '632' OR  `idag` = '621' OR  `idag` = '624' OR  `idag` = '629' OR  `idag` = '630' OR  `idag` = '631' OR  `idag` = '633' OR  `idag` = '634' OR  `idag` = '635' OR  `idag` = '636' OR  `idag` = '637' OR  `idag` = '625' OR  `idag` = '626' OR  `idag` = '627' OR  `idag` = '638' OR  `idag` = '639') AND annonce.date > '2023-11-13' ORDER by ville ASC

Infinitis
Contact: Dana Ariel

27 Published listings
19 With photos
32 Listings

in Israel

Free Email Alert
  • New Project, Published on 09/11/2024

    ₪4.350.000

    Apartment 3 rooms, 76

    Tel Aviv, Neve Avivim

  • New Project, Published on 09/11/2024

    ₪3.410.000

    Apartment 4 rooms, 98

    Herzliya, Herzliya

  • New Project, Published on 09/11/2024

    ₪2.850.000

    Apartment 2 rooms, 42

    Herzliya, Herzliya

  • New Project, Published on 09/11/2024

    ₪4.460.000

    Apartment 5 rooms, 150

    Herzliya, Herzliya

  • New Project, Published on 09/11/2024

    ₪2.888.000

    Apartment 4 rooms, 102

    Netanya, Netanya

  • New Project, Published on 09/11/2024

    ₪1.585.000

    Apartment 3 rooms, 79

    Ashkelon, Agamim

  • Sale, Published on 09/11/2024

    ₪1.999.000

    Apartment 4 rooms, 92

    EXCLUSIVE

    Ashdod, He