(select id, starRating, address , ifnull(name_en, name_en) as name , ifnull(filename_en, filename_en) as filename from hotels where cityID = 12486 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 = 12486 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 = 12486 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 = 12486 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 = 12486 and starRating = 1 order by random limit 5 )
![]() |
|
||||||||||||||||||||||||||||||||||||||||||||||
Hotels in Piran / Slovenia |
|
4 stars hotels
Villa Mia Chanel
Dantejeva 31
3 stars hotels
Hotel Barbara Fiesa
Fiesa 68
Hotel Fiesa
Fiesa 57
Hotel Piran
Stjenkova 1
Hotel Tartini
Tartinijev Trg 15
Vila Piranesi
Kidrièevo Nabre¾je 4
2 stars hotels
Alibi T60 Hostel
Trubarjeva 60
Alibi B11 Hostel
Bonifacijeva 11
Alibi B14 Hostel
Bonifacijeva 14
Hostel Eva
Cankarjevo nabrezje 7
|
|
Find prices for hotels in :
Bled
50 hotels
Ljubljana
45 hotels
Sentjur
1 hotels
Pesnica
1 hotels
Prebold
1 hotels
Lendava
3 hotels
Rogaska Slatina
12 hotels
| |