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

Laurence Zemour
Contact: Zemour Laurence

thanks to over 20 years of professional experience, laurence zemour real estate agency will provide you with their best counselling services throughout your purchase, rental or investment operation. laurence zemour real estate agency will support you in all proceedings for you to have your dream come true. our working method advocates a high-level range of services including professional advice, patience and listening, reliability, follow-up at each stage of your transaction. we are located in raanana and our agency deploys its activity throughout the sharon district as well as in tel-aviv.

3 Published listings
3 With photos
36 Listings

in Israel

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

    ₪36.000

    Villa 9 rooms, 350

    EXCLUSIVE

    Raanana, 2003

  • Rent, Published on 13/11/2024

    ₪12.800

    Duplex 5 rooms, 160

    Raanana, 2003

  • Rent, Published on 13/11/2024

    ₪9.000

    Apartment 5 rooms, 135

    EXCLUSIVE

    Raanana, Est

  • Rent, Published on 13/11/2024

    ₪28.000

    Villa 7 rooms, 280

    EXCLUSIVE

    Herzliya, Herzliya Pitouah

  • Rent, Published on 13/11/2024

    ₪14.800

    Duplex 5 rooms, 160

    EXCLUSIVE

    Raanana, Near Yad Labanim

  • Sale, Published on 12/11/2024

    ₪4.800.000

    Mini-Penthouse 5 rooms, 150

    Raanana, 2003

  • Sale, Published on 12/11/2024

    ₪4.790.000

    Apartment 5 rooms, 166

    EXCLUSIVE

    Raanana, Near Yad Labanim