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

Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.

Hotels in Erfurt / Germany

5 stars hotels

Pullman Erfurt am Dom Theaterplatz 2

4 stars hotels

Airport Hotel Erfurt Binderslebener Landstrasse 100

Mercure Hotel Erfurt Altstadt Meienbergstrasse 26-27

Radisson Blu Erfurt Juri Gagarin Ring 127

Landhotel Burgen Blick Am Zwetschenberg 20

Pension Wegerich Erfurt Windthorststrasse 29

3 stars hotels

Landhotel Primavera Erfurt Hauptstraße 42

Hotel & Restaurant Park Cafe ISA Sternberger Strasse 6

Altstadtpension am Dom Erfurt Pergamentergasse 42

Wilna Hotel Vilniuser Strasse 2

Gastehaus Andreasstrasse Erfurt Andreasstrasse 44

2 stars hotels

Muller's Hotel & Restaurant Zum Haun 10

Gastehaus Allerheiligenstrasse Allerheiligenstr. 3

Ibis Erfurt Altstadt Barfuesserstrasse 9

Hotel Linderhof Azmannsdorfer Strasse 27

Hotel garni Daberstedt Buddestrasse 2

1 stars hotels

Hotel Alt-Erfurt Nordhäuser Str. 12

Fürstenhof Gasthof & Pension Erfurt Dietendorfer Strasse 50

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