(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 46396 and starRating = 5 order by random limit 5 ) union (select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 46396 and starRating = 4 order by random limit 5 ) union (select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 46396 and starRating = 3 order by random limit 5 ) union (select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 46396 and starRating = 2 order by random limit 5 ) union (select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 46396 and starRating = 1 order by random limit 5 ) Hotels in Agde, hotel price comparison service
 
 
Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.
  Hotels 4 Travelers     Browse by country     Search by hotel name  

Hotels in Agde / France

4 stars hotels

Camping Mer et Soleil Chemin De Notre Dame A Saint Martin

3 stars hotels

Lagrange Prestige L'ile Saint-Martin Maisons du Port, 44 Port Saint-Martin

2 stars hotels

Hotel Araur 7 Quai Du Commandant Reveille
Hotel La Galiote 5 place Jean Jaures
Relais Du Mont Saint Loup Route de Sete
Hotel Restaurant Aux Deux Freres 7-13 Av Victor Hugo
Hotel du Patriarche 32 Montée de Joly

Find prices for hotels in :

Paris 1480 hotels
Nice 189 hotels
Montargis 5 hotels
La Grande-Motte 16 hotels
Ecouen 1 hotels
Massieux 2 hotels
Saint-Desirat 1 hotels
Hotels 4 Travelers | Browse by country | Search by hotel name