(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 870 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 = 870 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 = 870 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 = 870 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 = 870 and starRating = 1 order by random limit 5 )
![]() |
|
||||||||||||||||||||||||||||||||||||||||||||||
Hotels in Heidelberg / Germany |
|
5 stars hotels
Der Europaische Hof Hotel Europa
Friedrich Ebert Anlage 1
Heidelberg Suites
Neuenheimer Landstrasse 12
4 stars hotels
Das Lamm Heidelberg
Pfarrgasse 3
Holiday Inn Heidelberg
Pleikartsförster Strasse 101
Leonardo Hotel Heidelberg
Bergheimer Strasse 63
Hip Hotel
Hauptstrasse 115
Hotel Zum Ritter St. Georg
Hauptstrasse 178
3 stars hotels
Alter Kohlhof Hotel & Landgasthof
Kohlhof 5
Hotel Villa Marstall
Lauerstrasse 1
Hotel Neu Heidelberg
Kranichweg 15
Hotel Heidelberg
Heuauer Weg 35-37
Parkhotel Atlantic
Schloss Wolfsbrunnenweg 23
2 stars hotels
Ibis Heidelberg
Willy Brandt Platz 3
Papas Pension
Fahrtgasse 1
Elite Hotel Heidelberg
Bunsenstrasse 15
Hotel Tannhaeuser
Bergheimerstrasse 6
Terra Di Bellobene Suite Heidelberg
Heiliggeiststraße 7/1
1 stars hotels
Car by Side
Rohrbacher Str. 32
Hotel DenRiKo
Hertzstr. 12
|
|
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
| |