SELECT * FROM `properties` WHERE ( `vocation_id` = 1 ) AND ( `property_type_id` = 1 ) AND ( `property_sub_type` LIKE '%\"id\":1,%' ESCAPE '!' ) AND `jumelee` = 0 AND ( `vocation_id` = 2 AND `statut_id` = 2 OR `statut_id` = 5 OR `vocation_id` = 1 AND `statut_id` = 2 ) AND `published` = 1 ORDER BY `id` DESC LIMIT 9 Liste des villas indépendant à vendre | Darcom Tunisia

TROUVER VOTRE

MAISON ICI

Jardin Piscine
Jardin Piscine
Jardin Piscine