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

71 706 900 - 98 (20) 538 070



Hôtels en Tunisie

USA Portugal Espagne Paris Italy hotel en tunisie Tour d'Espagne Europe Centrale 2 Europe Centrale 19 PARIS – BRUXELLES –

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 ((('2019-02-25' BETWEEN du AND au) and ('2019-02-28' BETWEEN du AND au)) or (('2019-02-25' BETWEEN du1 AND au1) and ('2019-02-28' BETWEEN du1 AND au1)) or (('2019-02-25' BETWEEN du2 AND au2) and ('2019-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,52,316,61,67,319,72,77,78,353,79,84,97,321,322,105,106,107,108,109,111,114,331,337,121,123,347,326,128,135,144,301,224,430,176,177,181,185,196,201,249,254,255,225,348,350,351,282,294,285,271,280,311,371,365,362,428,435,436,438,453,455,457,462,463,467,468,576,473,476,478,480,483,486,500,510,520,527,531,543,554,542,553,564,570,612,577,578,580,581,583,585,594,599,603,606,607,608,609,610,611,613 ) and o.`etat`=0 and o.`id_ville`='9' order by price ASC