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

71 706 900 - 98 (20) 538 070



Hôtels en Tunisie

PROMO HOTELS USA West Circuit SUD Europe Centrale

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 ((('2018-10-20' BETWEEN du AND au) and ('2018-10-23' BETWEEN du AND au)) or (('2018-10-20' BETWEEN du1 AND au1) and ('2018-10-23' BETWEEN du1 AND au1)) or (('2018-10-20' BETWEEN du2 AND au2) and ('2018-10-23' 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,52,316,110,134,376,462,463,573 ) and o.`etat`=0 order by price ASC

Trier par