(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 23347 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 = 23347 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 = 23347 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 = 23347 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 = 23347 and starRating = 1 order by random limit 5 ) Hotels in Curia, 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 Curia / Portugal

4 stars hotels

Curia Palace, Hotel Spa & Golf Resort Curia

3 stars hotels

Hotel Das Termas Curia TAMENGOS
Curia Clube Hotel Rua das Tílias

2 stars hotels

Hotel Do Parque Curia R. Pinheiro Manso

Find prices for hotels in :

Lisbon 302 hotels
Albufeira 211 hotels
Sao Miguel do Mato 1 hotels
Afife 1 hotels
Foz do Arelho 3 hotels
Nelas 1 hotels
Canha 1 hotels
Hotels 4 Travelers | Browse by country | Search by hotel name