SELECT * FROM `properties` WHERE ( `gouvernorat_id` = '137' ) 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
Vous pouvez nous envoyer un mail
Mahdia , Mahdia
Mahdia
Envoyez nous vos demandes
Consultez vos demandes