(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 13269 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 = 13269 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 = 13269 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 = 13269 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 = 13269 and starRating = 1 order by random limit 5 )
![]() |
|
||||||||||||||||||||||||||||||||||||||||||||||
Hotels in Ostrov / Czech Republic |
|
3 stars hotels
Hotel Depandance Bellevue
Nove mesto 42
Pension Vetrny Vrch
Karlovarska 126
Krusnohor
Krusnohorska 1196
|
|
Find prices for hotels in :
Prague
764 hotels
Karlovy Vary
125 hotels
Policka
1 hotels
Varnsdorf
2 hotels
Bilina
1 hotels
Kdyne
1 hotels
Zdikov
1 hotels
| |