select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=600 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=618 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=628 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=640 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=643 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=959 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1273 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=834 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=829 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=626 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1275 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=608 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=636 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1093 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1289 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=536 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=907 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=904 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=625 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1020 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1277 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1343 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=638 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=598 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=873 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=606 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1305 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=953 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=979 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1046 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=898 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=612 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=624 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=876 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1072 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
3.4581885
39.7196144
- Place: Spain, Majorca, Capdepera
- Price: starts with 160 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: agro tourism surrounded by history
- Description: Cases de Son Barbassa means agro tourism surrounded by history. The old houses of Son Barbassa , surrounded by the Natural Park of Llevant of Majorca, whose watchtower dates back to the 16th century,...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1406 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=692 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=603 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=622 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=725 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=957 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1136 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=468 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=602 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=944 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=592 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=989 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=504 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=528 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=964 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
2.3913258
39.5351852
- Place: Spain, Mallorca, Palma de Mallorca
- Price: starts with 190 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: wellness, design, lifestyle
- Description: The Maricel was build in the 1940s in the regional 16th and 17th century style. Guests have the best seats at the daily revelation of sunrise and sunset; can relax with an oriental massage in naturally...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=613 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1064 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=633 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=940 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1143 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1065 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
2.7100689
39.7715077
- Place: Spain, Majorca, Sóller
- Price: starts with 200 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Lovers and Nature lovers
- Description: This unique Finca offers 12 individually furnished rooms with the latest comforts with the charm of past times. Every room is unique, finished with a blend of traditional Majorcan architecture and decorative...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=832 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1030 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=605 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1364 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
8.4275647
55.0151175
- Place: Germany, Sylt, List
- Price: starts with 208 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Lifestyle, Wadden Sea, golf
- Description: The Grand Spa Resort A-Rosa is an exclusive and stylish hideaway in the style of classical North and Baltic Sea baths on Sylt, the prominent island in northern Germany. Fine sandy beach and dunes surround...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=601 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=438 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=627 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=620 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=577 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=948 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1015 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1360 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=867 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=442 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=665 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=629 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1013 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1139 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1137 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
3.0918233
39.5691425
- Place: Spain, Ibiza, San Juan
- Price: starts with 220 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: hip boutique hotels, sivity, pristine landscape
- Description: The Giri Residence is a small boutique Hotel, located in the north of Ibiza, featuring five suites with a warm atmosphere to create tranquility and comfort. Here you can enjoy the natural beauty of Ibiza...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1283 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1404 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1297 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=925 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=632 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1299 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1362 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=433 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=587 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1057 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
1.4357250
39.0533330
- Place: Spain, Ibiza, San Miguel
- Price: starts with 240 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Wedding, Honeymoon, Relaxation & Wellness
- Description: Located on a 7 hectare coastal plot, Hotel Hacienda Na Xamena sits 180 meters above sea level on a 2 kilometre stretch of coast amid a Mediterranean pine wood. The area in the North East of the island...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=831 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1008 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1295 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=842 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=467 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=634 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1366 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=609 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=590 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=749 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1381 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=596 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
7.1392994000
53.7074556000
- Place: Germany, Niedersachsen, Norderney
- Price: starts with 270 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Over 110 years ago, this building was used as a warehouse for the earlier promenade pier of the island Norderney. In January 2007 this historical building re-opened with architectonical charm and stylish...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=614 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=455 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=641 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=646 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=899 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1066 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
40.9222
-2.2993
- Place: Kenya, Lamu Archipelago, Lamu Islands
- Price: starts with 280 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Idyllic, luxurious, stylish & eco hotel
- Description: The Majlis is a privately owned resort set on Manda Island in the Lamu archipelago off Kenya´s north coast. The Hotel is elegantly desined and boasts the best views of the Ras Kitau bay. Only a 10 minutes...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1047 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
2.5296971
39.6346921
- Place: Spain, Mallorca, Puigpunyent
- Price: starts with 289 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: luxury agritourism and rural 5 star country hotel
- Description: The rural hotel in Majorca is located in a unique location inside the world heritage site and perfect for rural tourism near the idyllic town of Puigpunyent, at the foothills of the Puig de Galatzó...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1392 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=866 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
25.7304
35.24595
- Place: Greece, Crete, Elounda
- Price: starts with 290 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: great choice of restaurants, exklusive family hotels, watersports
- Description: Renowned for its genuine warmth and friendliness, the elounda mare hotel proudly upholds a tradition spanning twenty years of excellence in courtesy and cuisine. Honoured in 1987 as the first member in...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=946 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=635 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=694 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=888 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1132 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
2.7243
39.47613
- Place: Spain, Mallorca, Cala Blava
- Price: starts with 300 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: suites only, former military fortress
- Description: Cap Rocat is a former military fortress, hidden in the most secluded area of the bay of Palma de Mallorca. Blended into the landscape, this fortress has been totally refurbished without altering its...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=615 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=883 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=540 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=623 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1368 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=942 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=576 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1111 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=821 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=644 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=950 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1147 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1285 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1383 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=812 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=864 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1038 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
-59.6411
13.1924
- Place: Barbados, Carribean, Porters, St. James
- Price: starts with 384 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: carribean sea, small luxury family owned hotel
- Description: Coral Reef Club is a small luxury, family owned hotel located in on west coast of Barbados. Coral Reef Club has 88 rooms, suites and cottages which are set amidst beautiful landscaped gardens. The rooms...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=645 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=729 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1097 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=358 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=491 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1394 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=637 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1388 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=983 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=860 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
25.7332
35.24140
- Place: Greece, Crete, Elounda
- Price: starts with 500 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: The Elounda Peninsula is authentic artwork with its design and architecture, positioned close to the Aegean Sea. The Elounda peninsula has only suites no rooms. It enjoys an outstanding location overlooking...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=525 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=621 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=572 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=631 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1398 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=923 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1193 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
39.53506
-6.19056
- Place: Tanzania, Zanzibar, Bwejuu
- Price: starts with 645 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Swahili architecture, villas at top white sand beaches
- Description: The luxurious Baraza Resort & Spa is located at the white sandy beach of Stone Town, on the southeast coast of Zanzibar. This luxury resort offers an elegant blend of Arab, Indian and African-style and...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=827 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
14.23583
40.55742
- Place: Italy, Capri, Capri Napoli
- Price: starts with 700 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Playful details, lots of light and a sensational 180-degrees view of the entire coast: that’s the J.K. Capri. All around the isle of grottos Capri, the ocean is almost audaciously blue. Especially when...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1402 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=995 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1179 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=874 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1019 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=845 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1009 and (t1.name='Islands' or t1.name_en='Islands')
order by t2.hotel_id
18