(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 12823 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 = 12823 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 = 12823 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 = 12823 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 = 12823 and starRating = 1 order by random limit 5 ) Hotels in Cesis, hotel price comparison service

Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.

Hotels in Cesis / Latvia

3 stars hotels

Guest House Laimes Ligzda Lejasast?tes, Amatas novads, Drabe¹u pagasts

Hotel Atputa Cesis C?rul?¹u iela 49

Raksi Guesthouse Cesis ''Rak¹i''

Kolonna Hotel Cesis Vienibas Laukums 1

Hotel Tigra Veidenbauma 2

2 stars hotels

Saules Varti Vaives pagasts, Saulr?ti, C?su novads

Katrina Hotel Maza Katrinas 8

Karlamuiza Karli

Find prices for hotels in :

Riga 173 hotels

Jurmala 48 hotels

Sigulda 20 hotels

Uzava 3 hotels

Engure 1 hotels

Skrunda 1 hotels