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
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.
