SELECT * FROM `properties` WHERE ( `gouvernorat_id` = '141' ) 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 les Biens en nabeul| Darcom Tunisia

TROUVER VOTRE

MAISON ICI

Jardin Piscine
Jardin Piscine
Jardin Piscine