Ihre Suchergebnisse 1 -
15
von
Sortieren nach Preis
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=600 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=618 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=628 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=640 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=643 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=959 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1273 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=834 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=829 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=626 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1275 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=608 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=636 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1093 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1289 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=536 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=907 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=904 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=625 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1020 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1277 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1343 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=638 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=598 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=873 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=606 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1305 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=953 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=979 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1046 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=898 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=612 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
13.6148124000
54.4015017000
CERÊS
Das CERÊS. Ein Ort an dem es sich lohnt anzukommen. In traumhafter Lage mit einem faszinierenden Blick aufs Meer liegt das Hotel an der Seebrücke in Binz. Das CERÊS hat im Sommer 2007 eröffnet und bietet eine......
CERÊS
- Location: Deutschland, Mecklenburg Vorpommern, Binz
- Preis: ab 158 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Meerblick, Design, Panoramafenstern zum Meer, Strandlage
- Beschreibung: Das CERÊS. Ein Ort an dem es sich lohnt anzukommen. In traumhafter Lage mit einem faszinierenden Blick aufs Meer liegt das Hotel an der Seebrücke in Binz. Das CERÊS hat im Sommer 2007 eröffnet und bietet eine...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=624 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=876 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1072 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1406 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
-9.4680496
38.7005248
The Oitavos
Das elegante Hotel Oitavos ist im Naturpark Sintra Cascais direkt an den Dünen gelegen. Das Design ist modern gehalten, klare Linien und elegantes simples Interieur lassen den Fokus nach draußen schweifen.......
The Oitavos
- Location: Portugal, Quinta da Marinha, Cascais
- Preis: ab 163 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Designhotels in den Dünen, Golf, Reiten, herrlicher naturbelassener Landschaft
- Beschreibung: Das elegante Hotel Oitavos ist im Naturpark Sintra Cascais direkt an den Dünen gelegen. Das Design ist modern gehalten, klare Linien und elegantes simples Interieur lassen den Fokus nach draußen schweifen....
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=692 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=603 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=622 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=725 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=957 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1136 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=468 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=602 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=944 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=592 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=989 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
-8.9455867
37.0075994
Martinhal Beach Resort & Hotel
Das Martinhal Beach Resort & Hotel ist ein luxuriöses 5 Sterne Familien-Resort. Es liegt inmitten der unberührten Natur der westlichen Algarve am Rande eines Nationalparks, direkt an einem weißen Sandstrand.......
Martinhal Beach Resort & Hotel
- Location: Portugal, Algarve, Sagres
- Preis: ab 188 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Familien, Wellenreiter, Easy Living
- Beschreibung: Das Martinhal Beach Resort & Hotel ist ein luxuriöses 5 Sterne Familien-Resort. Es liegt inmitten der unberührten Natur der westlichen Algarve am Rande eines Nationalparks, direkt an einem weißen Sandstrand....
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=504 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=528 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=964 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=613 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1064 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=633 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=940 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1143 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1065 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=832 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1030 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=605 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1364 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
8.4275647
55.0151175
Grand Spa Resort A-Rosa Sylt
Das Grand Spa Resort A-Rosa ist ein exklusiver Rückzugsort in mondänem Baustil klassischer Nord- und Ostseebäder auf Sylt, der prominenten Insel im Norden Deutschlands. Feiner Sandstrand und Dünen umgeben......
Grand Spa Resort A-Rosa Sylt
- Location: Deutschland, Sylt, List
- Preis: ab 208 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Lifestyle, Wattenmeer, Golf
- Beschreibung: Das Grand Spa Resort A-Rosa ist ein exklusiver Rückzugsort in mondänem Baustil klassischer Nord- und Ostseebäder auf Sylt, der prominenten Insel im Norden Deutschlands. Feiner Sandstrand und Dünen umgeben...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=601 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
12.3147482000
54.2821541000
Dünenmeer Hotel & Spa
Das Dünenmeer Hotel & SPA liegt an einer Düne an einem 60 Kilometer langen weißen Strand. Die Halbinsel Fischland-Darß-Zingst bietet eine der schönsten Dünenlandschaften der Ostsee. Das Hotel selber wurde......
Dünenmeer Hotel & Spa
- Location: Deutschland, Mecklenburg Vorpommern, Ostseebad Dierhagen
- Preis: ab 210 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Meerblick, privatem Strand, Strandhäusern und Reetdach
- Beschreibung: Das Dünenmeer Hotel & SPA liegt an einer Düne an einem 60 Kilometer langen weißen Strand. Die Halbinsel Fischland-Darß-Zingst bietet eine der schönsten Dünenlandschaften der Ostsee. Das Hotel selber wurde...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=438 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
39.3770253000
-5.9888423000
Melia Zanzibar
Willkommen auf Sansibar – dieses Archipel mit seinen weißen Sandstränden liegt im Indischen Ozean, 35 km entfernt vom Festland Tansanias. Das Zamani Zanzibar Kempinski ist ein 5 Sterne Hideaway Resort......
Melia Zanzibar
- Location: Tansania, Sansibar, Kiwengwa
- Preis: ab 213 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Sandstränden, Privatvillen, Tennis am Indischen Ozean
- Beschreibung: Willkommen auf Sansibar – dieses Archipel mit seinen weißen Sandstränden liegt im Indischen Ozean, 35 km entfernt vom Festland Tansanias. Das Zamani Zanzibar Kempinski ist ein 5 Sterne Hideaway Resort...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=627 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=620 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=577 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=948 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1015 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1360 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=867 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=442 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=665 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=629 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1013 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1139 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1137 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1283 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1404 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
18.1272743
42.6384415
Hotel Villa Dubrovnik
Das Hotel Villa Dubrovnik ist ein stylisches und luxuriöses Boutique Hotel mit 56 Wohneinheiten. Es liegt auf den Klippen über einem der schönsten Plätze in Dubrovnik. Von hieraus eröffnet sich ein unvergleichlicher......
Hotel Villa Dubrovnik
- Location: Kroatien, Dubrovnik-Neretva, Dubrovnik
- Preis: ab 220 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Meerblick de luxe, absoluter Privatsphäre
- Beschreibung: Das Hotel Villa Dubrovnik ist ein stylisches und luxuriöses Boutique Hotel mit 56 Wohneinheiten. Es liegt auf den Klippen über einem der schönsten Plätze in Dubrovnik. Von hieraus eröffnet sich ein unvergleichlicher...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1297 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=925 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=632 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1299 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1362 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=433 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=587 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1057 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=831 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1008 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1295 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=842 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=467 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=634 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
10.8779590000
53.9620120000
Grand Spa Resort A-ROSA Travemünde
Das Grand Spa Wellness Hotel Resort A-ROSA Travemünde bietet einen herrlichen Blick auf den Strand der Ostsee und verbindet Kurhausarchitektur mit modernem Design. Das Resort Hotel verfügt über 155 Zimmer,......
Grand Spa Resort A-ROSA Travemünde
- Location: Deutschland, Schleswig-Holstein, Travemünde
- Preis: ab 255 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Meerblick, Wellness & Spa, Golf, Wassersport,
- Beschreibung: Das Grand Spa Wellness Hotel Resort A-ROSA Travemünde bietet einen herrlichen Blick auf den Strand der Ostsee und verbindet Kurhausarchitektur mit modernem Design. Das Resort Hotel verfügt über 155 Zimmer,...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1366 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=609 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=590 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=749 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1381 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=596 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
7.1392994000
53.7074556000
Seesteg
Vor über 110 Jahren, wurde dieses Hotel mit Wellnessangebot als Lagerhalle für die Planken des damaligen Seesteg von Norderney gebaut. Seit Januar 2007 ist dieses historische Gebäude mit architektonischem......
Seesteg
- Location: Deutschland, Niedersachsen, Norderney
- Preis: ab 270 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Strandlage, Rooftop Pools, Design & Style, Meerblick mit Sonnenuntergang
- Beschreibung: Vor über 110 Jahren, wurde dieses Hotel mit Wellnessangebot als Lagerhalle für die Planken des damaligen Seesteg von Norderney gebaut. Seit Januar 2007 ist dieses historische Gebäude mit architektonischem...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=614 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=455 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=641 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=646 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=899 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1066 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
40.9222
-2.2993
The Majlis Resort
Das Majlis ist ein privat geführtes Resort auf der Insel Manda im Lamu-Archipel vor Kenias Nordküste. Das Hotel ist elegant entworfen und bietet den besten Blick auf die Bucht Ras Kitau. Nur 10 Minuten......
The Majlis Resort
- Location: Kenia, Lamu Archipelago, Lamu Islands
- Preis: ab 280 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Style & Eco Hotels, Idyllic und Unique
- Beschreibung: Das Majlis ist ein privat geführtes Resort auf der Insel Manda im Lamu-Archipel vor Kenias Nordküste. Das Hotel ist elegant entworfen und bietet den besten Blick auf die Bucht Ras Kitau. Nur 10 Minuten...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1047 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1392 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=866 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
25.7304
35.24595
Elounda Mare
Erbaut als Herrenhaus, ist das Elounda Mare Hotel ein Beispiel der traditionellen Architektur und Design, mit Edelsteinen von antiken Möbeln und Kunstwerken.Das Hotel besteht aus dem Hauptgebäude mit verschiedenen......
Elounda Mare
- Location: Griechenland, Kreta, Elounda
- Preis: ab 290 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: großer Auswahl an Restaurants, exklusiven Familienhotels, Wassersport
- Beschreibung: Erbaut als Herrenhaus, ist das Elounda Mare Hotel ein Beispiel der traditionellen Architektur und Design, mit Edelsteinen von antiken Möbeln und Kunstwerken.Das Hotel besteht aus dem Hauptgebäude mit verschiedenen...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=946 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=635 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=694 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=888 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1132 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=615 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=883 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=540 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=623 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1368 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=942 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=576 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1111 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
19.2815770
-34.4080469
Birkenhead House
Nur 1 ½ Stunden von Kapstadt entfernt, liegt Birkenhead House & Villa, das 4 Sterne Hotel in Südafrika, in unberührter Natur. Geboten wird in diesem Ferienhaus nahezu alles: von freiem Blick aufs Meer......
Birkenhead House
- Location: Südafrika, Kapstadt, Hermanus
- Preis: ab 325 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: unberührter Natur, Hotels auf Klippen, Wale beobachten, Weingüter
- Beschreibung: Nur 1 ½ Stunden von Kapstadt entfernt, liegt Birkenhead House & Villa, das 4 Sterne Hotel in Südafrika, in unberührter Natur. Geboten wird in diesem Ferienhaus nahezu alles: von freiem Blick aufs Meer...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=821 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=644 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
8.9145370000
38.9273703000
Forte Village Resort
Das Forte Village ist ein einmaliges Resort und zählt zu den besten 5 Sterne Luxus Resort Hotels. Insgesamt gibt es in dem Resort 8 Hotels der 4 und 5 Sterne Hotel Kategorie mit insgesamt 44 Suiten, die Privatsphäre,......
Forte Village Resort
- Location: Italien, Sardinien, Santa Margherita di Pula Cagliari
- Preis: ab 335 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Resorts mit mehreren Hotels, Strandlage, Suiten, Privatssphäre, Gourmetrestaurants, Familien
- Beschreibung: Das Forte Village ist ein einmaliges Resort und zählt zu den besten 5 Sterne Luxus Resort Hotels. Insgesamt gibt es in dem Resort 8 Hotels der 4 und 5 Sterne Hotel Kategorie mit insgesamt 44 Suiten, die Privatsphäre,...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=950 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
6.6387738
43.2471106
Muse
Das Saint-Tropez Muse ist ein neues Ramatuelle 4 Sterne Boutique Hotel an der Côte d´Azur, dass außergewöhnlichen Service für die Gäste in großzügigen Suiten bietet, die jeweils nach einer inspirierenden......
Muse
- Location: Frankreich, Cote d'Azur, Ramatuelle
- Preis: ab 350 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: 15 großzügige Suiten mit Namen von verschiedenen Kino-Stars wie Audrey, Grace und Catherine, privaten Cabanas
- Beschreibung: Das Saint-Tropez Muse ist ein neues Ramatuelle 4 Sterne Boutique Hotel an der Côte d´Azur, dass außergewöhnlichen Service für die Gäste in großzügigen Suiten bietet, die jeweils nach einer inspirierenden...
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1147 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1285 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1383 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=812 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=864 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1038 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
-59.6411
13.1924
Coral Reef Club
Der Coral Reef Club ist ein kleines, luxuriöses familiengeführtes Hotel und liegt an der Westküste von Barbados. Coral Reef Club hat 88 Zimmer, Bungalows und Suiten, die inmitten wunderschöner Gärten liegen.......
Coral Reef Club
- Location: Barbados, Karibik, Porters, St. James
- Preis: ab 384 € pro Nacht und Zimmer
- Hotel oder Villa/Chalet: Hotel
- Für Freunde von: Karibik, luxuriösen familiengeführten Hotels
- Beschreibung: Der Coral Reef Club ist ein kleines, luxuriöses familiengeführtes Hotel und liegt an der Westküste von Barbados. Coral Reef Club hat 88 Zimmer, Bungalows und Suiten, die inmitten wunderschöner Gärten liegen....
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=645 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=729 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1097 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=358 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=491 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1394 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=637 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1388 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=983 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=860 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=525 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=621 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=572 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=631 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1398 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=923 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1193 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=827 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1402 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=995 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1179 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=874 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1019 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=845 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
select t2.hotel_id,t1.name
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1009 and (t1.name='Strand' or t1.name_en='Strand')
order by t2.hotel_id
23
zurück < 1/2 >
weiter
Finest Lodges Destinations
- Argentinien
- Barbados
- Belgien
- Brasilien
- Deutschland
- England
- Frankreich
- Griechenland
- Italien
- Kenia
- Kroatien
- Malediven
- Marokko
- Niederlande
- Portugal
- Schweiz
- Spanien
- Südafrika
- Tansania
- Tschechische Republik
- Türkei
- USA
- Österreich
Most Rated Holidays
- Finest Lodges
- Über Finest Lodges
- Partner
- Blog
- AGB
- Informationen
- Travelagents
- für Hotels
- für Villenbesitzer
- für Tourismus Branche
- Privileges
- Special Deals
- Geschenke
- Mitglied werden
- Incentives
- Kontakt
- Adresse
- Jobs & Karriere
- Impressum
- Datenschutz
