(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 1198 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 = 1198 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 = 1198 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 = 1198 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 = 1198 and starRating = 1 order by random limit 5 )
![]() |
|
||||||||||||||||||||||||||||||||||||||||||||||
Hotels in Lugo / Spain |
|
4 stars hotels
Hotel Santiago Lugo
Crta Santiago Km 3.2
Gran Hotel Lugo
Avda. Ramon Ferreiro, 21
Pazo de Orban
Travesía do Mi?o 6
Jorge I Hotel Lugo
Crta. de Oviedo, Km. 89
3 stars hotels
Husa Hotel Aparthotel Ciudad de Lugo
Carril de Hortas, 29
Husa Puerta de San Pedro
Río Neira, 29
Hotel Mendez Nunez
Calle de la Reina 1
Pension San Roque
Plaza Comandante Manso, 11, 2?
2 stars hotels
Casa Pardo
Esperante, S/N
Los Olmos
Calle Rua Camino de Li?ares 15
Hotel Ceao Express Lugo
O Ceao, Rua Canteiros s/n
1 stars hotels
Casa Grande de Nadela Hotel Lugo
Nadela, 50
Pension Residencia Fisterra
Cami?o de Pipin, 29-1?
|
|
Find prices for hotels in :
Barcelona
976 hotels
Madrid
668 hotels
Ponga
1 hotels
Cervera del Rio Alhama
1 hotels
Riudellots de la Selva
2 hotels
Sant Pere de Ribes
5 hotels
Villacarriedo
1 hotels
| |