Lundi - Vendredi:
8h30 - 18h00
Samedi:
8h30 - 13h30
71 706 900 - 98(20)538 070



Hôtels en Tunisie

Voyage USA Vienne & Prague DUBAI Malaisie & Thailande

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 ((('2017-05-03' BETWEEN du AND au) and ('2017-05-06' BETWEEN du AND au)) or (('2017-05-03' BETWEEN du1 AND au1) and ('2017-05-06' BETWEEN du1 AND au1)) or (('2017-05-03' BETWEEN du2 AND au2) and ('2017-05-06' 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,62,63,316,59,61,64,65,67,319,71,72,77,353,79,89,84,91,92,93,94,97,321,322,102,103,105,106,107,108,109,111,114,115,331,335,117,118,120,121,340,341,342,343,346,324,325,326,127,128,130,131,327,132,133,144,203,301,223,230,499,173,177,193,196,369,204,208,252,254,255,225,350,351,282,290,294,270,277,280,311,314,379,376,367,366,365,370,362,428,516,431,432,433,438,453,452,455,457,458,463,466,467,473,474,495,479,480,483,484,486,487,497,500,492,494,505,508,512,517,520,527,528,541,543,540,554,542,569,560,556,544,552,547,548,561,549,553,564,559,562,566,567,568,571,570 ) and o.`etat`=0 and o.`id_ville`='9' order by price ASC

Trier par
 

BIZERTA RESORT

Bizerte

Bizerta Resort : un hôtel de qualité, de standing international, au nord est de la Tunisie, dans la région de Bizerte, riche de potentialités. Bizerta ...

Détails Hôtel Galerie PhotosPlan de situation
130.800TND
Logement petit déjeuner
Total 3 Nuitées
784.800TND
Tarifs & Réservation