Horaires Ramadan:
Lun -Ven : 9h - 15h
Samedi: 9h - 13h30

71 706 900 - 98 (20) 538 070



Hôtels en Tunisie

Europe Cenrale Espagne Europe Cenrale Europe Espagne Portugal Paris Italy Portugal USA

Filtrer ma recherche

0 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 ((('' a1[2] '-' a1[1] '-' a1[0] '' BETWEEN du AND au) and ('1970-01-01' BETWEEN du AND au)) or (('' a1[2] '-' a1[1] '-' a1[0] '' BETWEEN du1 AND au1) and ('1970-01-01' BETWEEN du1 AND au1)) or (('' a1[2] '-' a1[1] '-' a1[0] '' BETWEEN du2 AND au2) and ('1970-01-01' 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 ) and o.`etat`=0 order by price ASC