(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 15382 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 = 15382 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 = 15382 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 = 15382 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 = 15382 and starRating = 1 order by random limit 5 ) Hotels in Harlingen (Netherlands), 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 Harlingen (Netherlands) / Netherlands

3 stars hotels

Stadslogement Harlingen Kruisstraat 8-14
Hotel Restaurant vof 't Heerenlogement Franekereind 23
Logement Garjen Noorderhaven 73
Hotel Centraal Harlingen (Netherlands) Brouwersstraat 12
Holland Hotel Zeezicht Zuiderhaven 1

Find prices for hotels in :

Amsterdam 549 hotels
The Hague 73 hotels
Zuidvelde 1 hotels
Schinveld 2 hotels
Hulshorst 1 hotels
Middelharnis 1 hotels
Vasse 1 hotels
Hotels 4 Travelers | Browse by country | Search by hotel name