Your Searchresults 1 -
15
of
sort by price
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
13.6148124000
54.4015017000
CERÊS
The CERÊS. A place worth coming to. This hotel is located in a dreamlike setting with fascinating views of the ocean, directly by the pier in the sea-town of Binz.
The CERÊS was opened in the summer of......
CERÊS
- Place: Germany, Mecklenburg Vorpommern, Binz
- Price: starts with 158 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: sea view, design
- Description: The CERÊS. A place worth coming to. This hotel is located in a dreamlike setting with fascinating views of the ocean, directly by the pier in the sea-town of Binz. The CERÊS was opened in the summer of...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=1406 and (t1.name='Beach' or t1.name_en='Beach')
order by t2.hotel_id
-9.4680496
38.7005248
The Oitavos
The elegant Oitavos Hotel, is located in the Natural Park Sintra Cascais, directly on the dunes. The design is modern, with clean lines, simple and elegant interior focus attention outwards. There are......
The Oitavos
- Place: Portugal, Quinta da Marinha, Cascais
- Price: starts with 163 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: seaview, golf, horse riding, splendid natural landscape
- Description: The elegant Oitavos Hotel, is located in the Natural Park Sintra Cascais, directly on the dunes. The design is modern, with clean lines, simple and elegant interior focus attention outwards. There are...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
-8.9455867
37.0075994
Martinhal Beach Resort & Hotel
Martinhal Beach Resort & Hotel is a luxury family resort. The beachfront hotel is positioned within a protected natural park near the beautiful beach , and close to the historic town of Sagres, on ......
Martinhal Beach Resort & Hotel
- Place: Portugal, Algarve, Sagres
- Price: starts with 188 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Families, sufing, Easy Living
- Description: Martinhal Beach Resort & Hotel is a luxury family resort. The beachfront hotel is positioned within a protected natural park near the beautiful beach , and close to the historic town of Sagres, on ...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=613 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=832 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
8.4275647
55.0151175
Grand Spa Resort A-Rosa Sylt
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......
Grand Spa Resort A-Rosa Sylt
- 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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
12.3147482000
54.2821541000
Dünenmeer Hotel & Spa
Welcome to a beautiful, 60 km long white sandy beach! The Dünenmeer Hotel & Spa was opened in 2007 and lies just behind the dunes, directly by the beach.The Dünenmeer consists of the four star superior......
Dünenmeer Hotel & Spa
- Place: Germany, Mecklenburg Vorpommern, Ostseebad Dierhagen
- Price: starts with 210 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Welcome to a beautiful, 60 km long white sandy beach! The Dünenmeer Hotel & Spa was opened in 2007 and lies just behind the dunes, directly by the beach.The Dünenmeer consists of the four star superior...
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
39.3770253000
-5.9888423000
Melia Zanzibar
Welcome to Zanzibar - this Indian Ocean archipelago with its white sandy beaches is located 35 km off the Tanzanian main land. The Zamani Zanzibar Kempinski is Zanzibars leading international five-star......
Melia Zanzibar
- Place: Tanzania, Zanzibar, Kiwengwa
- Price: starts with 213 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Welcome to Zanzibar - this Indian Ocean archipelago with its white sandy beaches is located 35 km off the Tanzanian main land. The Zamani Zanzibar Kempinski is Zanzibars leading international five-star...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=1283 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
18.1272743
42.6384415
Hotel Villa Dubrovnik
The Hotel Villa Dubrovnik is a stylish and luxurious boutique hotel with 56 residential units. It is situated on the cliffs overlooking one of the most beautiful places in Dubrovnik. From here you have......
Hotel Villa Dubrovnik
- Place: Croatia, Dubrovnik-Neretva, Dubrovnik
- Price: starts with 220 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: stunning vistas, privacy, luxury, style
- Description: The Hotel Villa Dubrovnik is a stylish and luxurious boutique hotel with 56 residential units. It is situated on the cliffs overlooking one of the most beautiful places in Dubrovnik. From here you have...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=831 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
10.8779590000
53.9620120000
Grand Spa Resort A-ROSA Travemünde
The Grand SPA Resort A-ROSA Travemünde combines an impressive view of the beach and the Baltic Sea, classic spa architecture and modern design. It offers 155 spacious rooms and 39 suites and has a modern......
Grand Spa Resort A-ROSA Travemünde
- Place: Germany, Schleswig-Holstein, Travemünde
- Price: starts with 255 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: The Grand SPA Resort A-ROSA Travemünde combines an impressive view of the beach and the Baltic Sea, classic spa architecture and modern design. It offers 155 spacious rooms and 39 suites and has a modern...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
7.1392994000
53.7074556000
Seesteg
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......
Seesteg
- 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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
40.9222
-2.2993
The Majlis Resort
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......
The Majlis Resort
- 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='Beach' or t1.name_en='Beach')
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=1392 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
25.7304
35.24595
Elounda Mare
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......
Elounda Mare
- 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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=615 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
19.2815770
-34.4080469
Birkenhead House
Birkenhead House & Villa is located in unspoilt natural surroundings and only 1 1/2 hour from Cape Town. This retreat offers uninterrupted views and finest international cuisine.Perched high on the Hermanus......
Birkenhead House
- Place: South Africa, Cape Town, Hermanus
- Price: starts with 325 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: whale watching, deep- sea fishing, unspoiled nature, wine farms
- Description: Birkenhead House & Villa is located in unspoilt natural surroundings and only 1 1/2 hour from Cape Town. This retreat offers uninterrupted views and finest international cuisine.Perched high on the Hermanus...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
8.9145370000
38.9273703000
Forte Village Resort
For 12 years Forte Village Resort has held the title of World’s Leading Resort. Forte Village is a supreme resort just a few kilometres from Cagliari and looks out onto a magnificent beach and welcomes......
Forte Village Resort
- Place: Italy, Sardinia, Cagliari
- Price: starts with 335 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Resort with several hotels, familiy hotels, privacy
- Description: For 12 years Forte Village Resort has held the title of World’s Leading Resort. Forte Village is a supreme resort just a few kilometres from Cagliari and looks out onto a magnificent beach and welcomes...
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
6.6387738
43.2471106
Muse
The luxury hotel Muse is a Ramatuelle boutique hotel. Located towards the beach clubs of Pampelonne beach in Ramatuelle, A gated entry hidden inside a lush landscape of beach vegetation leads to this......
Muse
- Place: France, Cote d'azur, Ramatuelle
- Price: starts with 350 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: 15 spacious suites with names of celebrities like Audrey, Grace und Catherine, private cabanas
- Description: The luxury hotel Muse is a Ramatuelle boutique hotel. Located towards the beach clubs of Pampelonne beach in Ramatuelle, A gated entry hidden inside a lush landscape of beach vegetation leads to this...
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
-59.6411
13.1924
Coral Reef Club
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......
Coral Reef Club
- 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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=525 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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=827 and (t1.name='Beach' or t1.name_en='Beach')
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=1402 and (t1.name='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
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='Beach' or t1.name_en='Beach')
order by t2.hotel_id
23
previous < 1/2 >
next
Finest Lodges Destinations
- Argentina
- Austria
- Barbados
- Belgium
- Brasil
- Croatia
- Czech Republic
- England
- France
- Germany
- Greece
- Italy
- Kenya
- Maldives
- Morocco
- Netherlands
- Portugal
- South Africa
- Southafrica
- Spain
- Switzerland
- Tanzania
- Turkey
- USA
Most Rated Holidays
- Finest Lodges
- About Finest Lodges
- Partners
- Blog
- Terms & Conditions
- Privileges
- Special Deals
- Gifts
- become a Member
- Incentives
- Contact
- Adress
- Jobs & Careers
- Imprint
- copyright
