SELECT * FROM `properties` WHERE `property_type_id` = 10 AND `property_sub_type` LIKE '%\"id\":39,%' ESCAPE '!' 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 terrains de loisirs | Darcom Tunisia

TROUVER VOTRE

MAISON ICI

Jardin Piscine
Jardin Piscine
Jardin Piscine