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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
14.0286
52.2387
Sport & Spa Resort A-ROSA Scharmützelsee
The Sport & SPA Resort A-ROSA Scharmützelsee is directly located at the largest lake in the old March of Brandenburg. It offers a succeeded symbiosis of relaxation, culinary experience and wellness. In......
Sport & Spa Resort A-ROSA Scharmützelsee
- Place: Germany, Brandenburg, Bad Saarow
- Price: starts with 121 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Lakeside, Golf, Sailing, Spa & Wellness
- Description: The Sport & SPA Resort A-ROSA Scharmützelsee is directly located at the largest lake in the old March of Brandenburg. It offers a succeeded symbiosis of relaxation, culinary experience and wellness. 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=1093 and (t1.name='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
10.0159500000
53.5616511000
The George
„The name is George, The George!“ Find British tradition with a contemporary touch and intercultural reminiscences of colonial times in the 125 rooms and suites. In the colourful St. Georg district of......
The George
- Place: Germany, Hamburg Region, Hamburg
- Price: starts with 145 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: british tradition, roof terrace
- Description: „The name is George, The George!“ Find British tradition with a contemporary touch and intercultural reminiscences of colonial times in the 125 rooms and suites. In the colourful St. Georg district 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=873 and (t1.name='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
13.8091438000
47.9074300000
Freisitz Roith Schlosshotel
Pleasure walks in the palace gardens, striding through long halls and exquisite meals served by a gourmet kitchen – the Hotel Freisitz Roith brings back the elegance of life in a castle....
Freisitz Roith Schlosshotel
- Place: Austria, Salzburg Region, Gmunden
- Price: starts with 150 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Pleasure walks in the palace gardens, striding through long halls and exquisite meals served by a gourmet kitchen – the Hotel Freisitz Roith brings back the elegance of life in a castle.
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
14.2954461
52.3805604
Gut Klostermühle
...
Gut Klostermühle
- Place: Germany, Brandenburg, Madlitz-Wilmersdorf
- Price: starts with 156 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description:
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
8.4330367
47.0319901
Post Hotel Weggis
The Post Hotel Weggis offers urban lifestyle in a beautiful location. Situated right next to Lake Lucerne it combines cool design with breathtaking scenery. In a stylish atmosphere the guests can find......
Post Hotel Weggis
- Place: Switzerland, Luzern, Weggis
- Price: starts with 156 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Waterski, Lifestyle, Quality
- Description: The Post Hotel Weggis offers urban lifestyle in a beautiful location. Situated right next to Lake Lucerne it combines cool design with breathtaking scenery. In a stylish atmosphere the guests can find...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
13.3499472000
47.8554430000
Iris Porsche Hotel
The Iris Porsche Hotel & Restaurant is a luxurious hideaway located directly next to the marketplace of Mondsee. Hospitality and unusual cordiality are alive here. The Iris Porsche Hotel has 11 spacious,......
Iris Porsche Hotel
- Place: Austria, Salzburg Region, Mondsee
- Price: starts with 180 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: The Iris Porsche Hotel & Restaurant is a luxurious hideaway located directly next to the marketplace of Mondsee. Hospitality and unusual cordiality are alive here. The Iris Porsche Hotel has 11 spacious,...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
18.159809
59.317103
Hotel J
Hotel J Nacka Strand, a Design Hotels™ member, sits among stately oaks and pines with an enchanting view over the marina, the Royal Park Djurgården and the lively boat life on the sea. The inspiration......
Hotel J
- Place: Sweden, Stockholm Region, Stockholm
- Price: starts with 200 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Newport, lakeview
- Description: Hotel J Nacka Strand, a Design Hotels™ member, sits among stately oaks and pines with an enchanting view over the marina, the Royal Park Djurgården and the lively boat life on the sea. The inspiration...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
11.7576200
47.6971700
Seehotel Überfahrt
The Seehotel Überfahrt, is located at the Tegernsee, in a health resort called Rottach- Egern and it's one of the most popular adress in the Alps. The hotel is a stylish retreat in an exceptional nature.......
Seehotel Überfahrt
- Place: Germany, Bavaria, Rottach-Egern
- Price: starts with 220 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Gourmetrestaurant with star-chef, Tegernsee, Spa, Golf
- Description: The Seehotel Überfahrt, is located at the Tegernsee, in a health resort called Rottach- Egern and it's one of the most popular adress in the Alps. The hotel is a stylish retreat in an exceptional nature....
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
11.2420861000
46.3972938000
...
Gius La Residenza
- Place: Italy, South Tyrol, Kaltern am See
- Price: starts with 230 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description:
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
6.0195120
46.2694430
Jiva Hill Park Hotel
Jiva Hill Park Hotel lies in a haven of peace and private tranquility. In the heart of the Jura Mountains, opposite the Mont Blanc and the Alpine mountain range, there is a world of Wellness and Spa in......
Jiva Hill Park Hotel
- Place: France, Rhône-Alpes, Crozet
- Price: starts with 250 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: wellness, Combination of great nature and modern design
- Description: Jiva Hill Park Hotel lies in a haven of peace and private tranquility. In the heart of the Jura Mountains, opposite the Mont Blanc and the Alpine mountain range, there is a world of Wellness and Spa 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=1295 and (t1.name='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
10.9646
46.5334
AROSEA Life Balance Hotel
The Arosea Life Balance Hotel offers a unique natural surrounding with natural resources. Alpine, natural materials dominate the design of the spacious rooms and suites. Health-stimulating pine wood, cosy......
AROSEA Life Balance Hotel
- Place: Italy, Southtyrol, St. Walburg
- Price: starts with 296 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: lakeside, life-balance, biological products
- Description: The Arosea Life Balance Hotel offers a unique natural surrounding with natural resources. Alpine, natural materials dominate the design of the spacious rooms and suites. Health-stimulating pine wood, cosy...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
7.1067405
46.9246476
Le Vieux Manoir
In a large park, directly on Lake Murten in Switzerland lies the romantic country house Le Vieux Manoir. In 1969, the Le Vieux was the first hotel in Switzerland which participated at the exclusive hotel......
Le Vieux Manoir
- Place: Switzerland, Freiburg, Murten
- Price: starts with 320 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Country hotels at the lake, unique living experiences, yacht trips and jaguar trips
- Description: In a large park, directly on Lake Murten in Switzerland lies the romantic country house Le Vieux Manoir. In 1969, the Le Vieux was the first hotel in Switzerland which participated at the exclusive hotel...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
14.2092183
46.6106442
Aenea
The Aenea Design Hotel is situated on the southern shore of the Wörthersee, harmoniously integrated into the breathtaking landscape. The hotel, designed by the internationally renowned designer Andreas......
Aenea
- Place: Austria, Kärnten, Reifnitz/Maria Wörth
- Price: starts with 350 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Business, Wellness
- Description: The Aenea Design Hotel is situated on the southern shore of the Wörthersee, harmoniously integrated into the breathtaking landscape. The hotel, designed by the internationally renowned designer Andreas...
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
select t2.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='Seeufer' or t1.name_en='Seeufer')
order by t2.hotel_id
14
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
