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

Search multiple hotel reservation websites
simultaneously at Hotels4Travelers for free.

Hotels in Leek / United Kingdom

4 stars hotels

The Cottage At The Retreat Leek 83 Mill Street

3 stars hotels

The Three Horseshoes Inn & Country Hotel Buxton Road,Blackshaw Moor

The Green man motel 38 Compton

Find prices for hotels in :

London 1586 hotels

Blackpool 507 hotels

Lewes (England) 16 hotels

Ely 9 hotels

Leicester 40 hotels

Barford St Martin 1 hotels

Pateley Bridge 3 hotels