select * from view_hotels_search where 1 and type='Hotel' order by price ASC
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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
9.9010320000
46.4945110000
Hotel Saratz
In 1865, a traditional Engadin farmhouse was converted into the Pension Saratz and in 1875, the era of belle époque, extended to create a splendid first-class hotel. 1996 the family Saratz reopened the......
Hotel Saratz
- Place: Switzerland, Engadine, Pontresina
- Price: by Request
- Hotel or Villa/Chalet: Hotel
- Description: In 1865, a traditional Engadin farmhouse was converted into the Pension Saratz and in 1875, the era of belle époque, extended to create a splendid first-class hotel. 1996 the family Saratz reopened the...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
9.8571721
46.5111845
Hotel Misani
Hotel Misan is a hip three star accommodation, located in St. Moritz-Celerina. It was originally built in 1878 as a wine trading company, and shortly afterwards used as a pension. The major increase was......
Hotel Misani
- Place: Switzerland, Graubünden, St. Moritz
- Price: starts with 75 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: individuality, personality
- Description: Hotel Misan is a hip three star accommodation, located in St. Moritz-Celerina. It was originally built in 1878 as a wine trading company, and shortly afterwards used as a pension. The major increase was...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1498 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
13.1430287000
47.1224539000
Miramonte
Take the slightly dusty ski resort Bad Gastein and some young creative. The result: The Miramonte. Among them, Ike Ikrath and his wife Evelyn, the Viennese architect and the hotelier of Bad Gastein and......
Miramonte
- Place: Austria, Salzburg Region, Bad Gastein
- Price: starts with 112 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Lifestyle, creative people,
- Description: Take the slightly dusty ski resort Bad Gastein and some young creative. The result: The Miramonte. Among them, Ike Ikrath and his wife Evelyn, the Viennese architect and the hotelier of Bad Gastein 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=1275 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
9.8678965
46.4970643
Hotel Lej da Staz
The Hotel-Restorant Lej da Staz lies adjacent to the Lake Staz –
close to St. Moritz. Ten hotel rooms proffer cosy alpine comfort in
privileged seclusion. The hotel restaurant Lej da Staz was built around......
Hotel Lej da Staz
- Place: Switzerland, Graubünden, St. Moritz
- Price: starts with 115 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: alpine charm, personal hospitality
- Description: The Hotel-Restorant Lej da Staz lies adjacent to the Lake Staz – close to St. Moritz. Ten hotel rooms proffer cosy alpine comfort in privileged seclusion. The hotel restaurant Lej da Staz was built around...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
9.8102658
46.9582770
Berghotel Wanna
The 300-year-old farmhouse was rebuilt in 2008 and is now an individual mountain lodge with 6 rooms (max. 20 beds). This mountain hotel is located 20 minutes away from Klosters in mountain area Graubünden.......
Berghotel Wanna
- Place: Switzerland, St. Antönien, Graubünden
- Price: starts with 122 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Mountains, rustic décor, 300 year old farmhouses, eventlocation
- Description: The 300-year-old farmhouse was rebuilt in 2008 and is now an individual mountain lodge with 6 rooms (max. 20 beds). This mountain hotel is located 20 minutes away from Klosters in mountain area Graubünden....
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1016 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
10.0966442
46.3982534
La Rösa
The Hotel La Rösa lies between the impressive Engadine glaciers and mild plains of Italy, in the romantic Valposchiavo. Built in the17th Century, this post and trading point La Rösa served previously as......
La Rösa
- Place: Switzerland, Graubünden, Valposchiavo
- Price: starts with 140 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Nature, Silence, Adventure, Lifestyle
- Description: The Hotel La Rösa lies between the impressive Engadine glaciers and mild plains of Italy, in the romantic Valposchiavo. Built in the17th Century, this post and trading point La Rösa served previously as...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1408 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1486 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
11.4315740
46.4139259
Ganischgerhof Mountain Resort & Spa
Guests can relax and be active, eat and drink, enjoy life and feel well at Ganischgerhof.
Harmony, balance and freedom – enjoyable holidays on which guests can follow their individual rhythm – the hotel’s......
Ganischgerhof Mountain Resort & Spa
- Place: Italy, South Tyrol, Deutschnofen
- Price: starts with 146 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Guests can relax and be active, eat and drink, enjoy life and feel well at Ganischgerhof. Harmony, balance and freedom – enjoyable holidays on which guests can follow their individual rhythm – the hotel’s...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
11.2146500
47.4721600
Das Kranzbach
In the Bavarian Alps not far from Garmisch-Partenkirchen, “THE KRANZBACH”, which opened inMay 2007, is a first-class hotel offering a maximum of peace and quiet to its guests. The hotel issituated on a......
Das Kranzbach
- Place: Germany, Bavaria, Krün
- Price: starts with 157 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: manors in the mountains, history, wellness
- Description: In the Bavarian Alps not far from Garmisch-Partenkirchen, “THE KRANZBACH”, which opened inMay 2007, is a first-class hotel offering a maximum of peace and quiet to its guests. The hotel issituated on a...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
13.1430287000
47.1224539000
Haus Hirt
A breathtakingly beautifully located Hideaway in the heart of the Alps. A fascinating combination of contemporary Zeitgeist and classic hospitality. A secret place full of inspiration. 19 double rooms,......
Haus Hirt
- Place: Austria, Salzburg Region, Bad Gastein
- Price: starts with 178 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: creatives , individuals, writers
- Description: A breathtakingly beautifully located Hideaway in the heart of the Alps. A fascinating combination of contemporary Zeitgeist and classic hospitality. A secret place full of inspiration. 19 double 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=603 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
11.50367
46.51737
Hotel Turm
The hotel is actually made up of three houses and towers: the old tower, the Kraiterhaus with its round tower, the tower of the owl, and the Wagenhaus. Each house and tower is unique in style and architecture.......
Hotel Turm
- Place: Italy, South Tyrol, Völs am Schlern
- Price: starts with 180 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Romance, Gourmet, Castles, Art
- Description: The hotel is actually made up of three houses and towers: the old tower, the Kraiterhaus with its round tower, the tower of the owl, and the Wagenhaus. Each house and tower is unique in style and architecture....
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
7.7426199
46.0138822
Hotel Matterhorn Focus
2008 haben Sonja und Christian Noti, zusammen mit Heinz Julen, ein neues Kunstwerk in Zermatt eröffnet. Die Komposition aus moderner Architektur, Service und einer fantatischen Lage direkt an der Talstation......
Hotel Matterhorn Focus
- Place: Switzerland, Wallis, Zermatt
- Price: starts with 180 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Design & modern architecture
- Description: 2008 haben Sonja und Christian Noti, zusammen mit Heinz Julen, ein neues Kunstwerk in Zermatt eröffnet. Die Komposition aus moderner Architektur, Service und einer fantatischen Lage direkt an der Talstation...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
12.8204214000
47.2842313000
Active by Leitners
Lifestyle in airy heights is what the ski hotel Active by Leitner’s am Kitzsteinhorn in Kaprun has to offer. Thanks to its excellent location, you can ski all year round and enjoy a fantastic spa vacation......
Active by Leitners
- Place: Austria, Salzburg Region, Kaprun
- Price: starts with 184 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Lifestyle in airy heights is what the ski hotel Active by Leitner’s am Kitzsteinhorn in Kaprun has to offer. Thanks to its excellent location, you can ski all year round and enjoy a fantastic spa vacation...
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1454 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1462 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
12.5985113
47.3792836
Alpen Karawanserai
Das Time Design Hotel Alpen Karawanserai
in Saalbach Hinterglemm im Salzburger Land ist ein 4 Sterne
Wellnesshotel in ruhiger, sonniger Lage im Zentrum von Hinterglemm. Das
Hotel wurde 2009 eröffnet......
Alpen Karawanserai
- Place: Austria, Salzburg Region, Saalbach Hinterglemm
- Price: starts with 187 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: wellness, design, ski in and out
- Description: Das Time Design Hotel Alpen Karawanserai in Saalbach Hinterglemm im Salzburger Land ist ein 4 Sterne Wellnesshotel in ruhiger, sonniger Lage im Zentrum von Hinterglemm. Das Hotel wurde 2009 eröffnet...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
10.8880230000
47.3949487000
Mohr Life Resort
A lifestyle hotel that was built 200 years ago, is listed as a historic building and has now been extended to include modern architecture. So that you get to feel good and truly relax, the Hotel has......
Mohr Life Resort
- Place: Austria, Tyrol, Lermoos
- Price: starts with 190 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: lifestylehotels, wellness
- Description: A lifestyle hotel that was built 200 years ago, is listed as a historic building and has now been extended to include modern architecture. So that you get to feel good and truly relax, the Hotel has...
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1436 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
12.4041487000
47.4438575000
Grand Spa Resort A-ROSA Kitzbühel
The Grand SPA Resort A-ROSA Kitzbühel is nestled among the Tyrolean Mountains against a magnificent Alpine backdrop. In the style of a Tyrolean castle this country estate is located on the sunny side of......
Grand Spa Resort A-ROSA Kitzbühel
- Place: Austria, Tyrol, Kitzbühel
- Price: starts with 198 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Spa & Wellness, Golf, Skiing
- Description: The Grand SPA Resort A-ROSA Kitzbühel is nestled among the Tyrolean Mountains against a magnificent Alpine backdrop. In the style of a Tyrolean castle this country estate is located on the sunny side 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=940 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1095 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1421 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1411 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1474 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=994 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1426 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1468 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1488 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1430 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1456 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1432 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1434 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1450 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1400 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1119 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1424 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1011 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1472 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_lage t1 join hotels_hotel_lage t2 on t1.id=t2.lage_id
where t2.hotel_id=1428 and (t1.name='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
select t2.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='Mountains' or t1.name_en='Mountains')
order by t2.hotel_id
47
previous < 1/4 >
next
Finest Lodges Destinations
- Argentina
- Australia
- Austria
- Barbados
- Belgium
- Brasil
- Croatia
- Czech Republic
- England
- France
- Germany
- Great Britain
- Greece
- Italy
- Kenya
- Lebanon
- Maldives
- Morocco
- Mosambique
- Netherlands
- Portugal
- South Africa
- Southafrica
- Spain
- Sweden
- 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
