Horaires:
Lun -Ven : 9h - 17h30
Samedi: 9h - 13h

Call Center 7/7 de 7h à 19h

71 706 900 - 98 (20) 538 070



Hôtels en Tunisie

USA03 JORDANIE EUROPE01 EUROPE 02 ITALIE CIRCUIT SUD USA01 ESPAGNE USA02

Filtrer ma recherche

3 Nuitées



   
   

Catégorie d'Étoile

()
()
()
Gite Rural ()

Arrangements


Aménagements

Thèmes


AccueilHôtels en Tunisie
SELECT *,(select MIN(price + price*o.pourcentage/100) from periode where ((('2020-02-25' BETWEEN du AND au) and ('2020-02-28' BETWEEN du AND au)) or (('2020-02-25' BETWEEN du1 AND au1) and ('2020-02-28' BETWEEN du1 AND au1)) or (('2020-02-25' BETWEEN du2 AND au2) and ('2020-02-28' BETWEEN du2 AND au2))) and o.id_offre = id_offre ) as price FROM `offre` o , `ville` v where o.id_ville = v.id_ville and nom <>'' and o.id_offre in (0,46,52,59,61,65,67,319,72,77,79,91,94,321,322,103,105,106,107,108,109,114,331,337,117,121,123,341,342,343,347,125,326,128,131,135,140,144,203,224,502,511,176,190,196,201,249,254,255,225,348,351,290,294,285,271,270,280,372,371,365,370,516,432,436,457,458,462,463,466,476,486,497,500,512,517,523,527,528,543,550,549,553,566,581,583,585,594,599,605,606,618,620,622,623,625,627 ) and o.`etat`=0 and o.`id_ville`='12' order by price ASC