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

Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.

Hotels in Cham / Germany

4 stars hotels

Randsbergerhof Hotel Randsbergerhofstrasse 15-19

3 stars hotels

Gasthaus Am Ödenturm Cham Am Ödenturm 11

Parkhotel Cham Pralat Wolker Strasse 5

2 stars hotels

Hotel Sonnenhof Cham Am Fuchsbühl 14

Find prices for hotels in :

Berlin 1022 hotels

Munich 351 hotels

Schallbach 1 hotels

Annaberg-Buchholz 5 hotels

Friesenheim 2 hotels

Halle 22 hotels

Seevetal 4 hotels