(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 20111 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 = 20111 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 = 20111 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 = 20111 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 = 20111 and starRating = 1 order by random limit 5 ) Hotels in Aarau, hotel price comparison service
 
 
Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.
  Hotels 4 Travelers     Browse by country     Search by hotel name  

Hotels in Aarau / Switzerland

3 stars hotels

Aarau-West Swiss Quality Hotel Muhenstrasse 58, Oberentfelden
Hotel Baeren Suhr Bernstrasse-West 56, Suhr
Sorellino Hotel Argovia Kasernenstrasse 24
Hotel Zum Kreuz Aarau Obere Dorfstrasse 1, Suhr

Find prices for hotels in :

Zermatt 182 hotels
Zurich 140 hotels
Blenio 2 hotels
Intragna 4 hotels
Twann 4 hotels
Tiefencastel 2 hotels
Rapperswil 4 hotels