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

Tivouh Hillel
Contact: Uzan Meirav

1 Published listings
1 With photos
33 Listings

in Israel

Free Email Alert
  • Sale, Published on 13/11/2024

    ₪5.300.000

    Villa 7 rooms, 500

    EXCLUSIVE

    Ashkelon, Barnea

  • Sale, Published on 13/11/2024

    ₪5.300.000

    Villa 7 rooms, 500

    EXCLUSIVE

    Ashkelon, Barnea

  • Sale, Published on 13/11/2024

    ₪6.300.000

    Villa 6 rooms, 340

    EXCLUSIVE

    Ashkelon, Afridar

  • Sale, Published on 12/11/2024

    ₪1.850.000

    Apartment 4 rooms, 110

    EXCLUSIVE

    Ashkelon, City

  • Sale, Published on 03/11/2024

    ₪1.550.000

    Ground floor 3 rooms, 180

    EXCLUSIVE

    Ashkelon, Newe Dekalim

  • Sale, Published on 03/11/2024

    ₪3.800.000

    Villa 5 rooms, 420

    EXCLUSIVE

    Ashkelon, Barnea

  • Sale, Published on 30/10/2024

    ₪1.830.000

    Apartment 4 rooms, 114

    EXCLUSIVE

    Ashkelon, Barnea