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_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=600 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=618 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=628 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=640 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=643 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1273 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
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_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1498 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
4.851209
53.039023
Design Hotel Texel Suites
The Design Hotel Texel Suites is located in an old warehouse from the early 20th Century, right in the historic harbor of Oudeschild. There are 3 spacious and modern suites: The Texel Suites.Well equipped,......
Design Hotel Texel Suites
- Place: Netherlands, Texel, Ae Oudeschild
- Price: starts with 80 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Designer interior, warehouse from the early twentieth century
- Description: The Design Hotel Texel Suites is located in an old warehouse from the early 20th Century, right in the historic harbor of Oudeschild. There are 3 spacious and modern suites: The Texel Suites.Well equipped,...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=834 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
13.4113999
52.5234051
The Weinmeister
Oversized beds, a buzzing location and a 24-hour mindset combine spectacularly at The Weinmeister Berlin-Mitte hotel which opened on 1 July, 2010. Situated in the city’s central district, Mitte, this 88-room......
The Weinmeister
- Place: Germany, Berlin Region, Berlin
- Price: starts with 99 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: Oversized beds, a buzzing location and a 24-hour mindset combine spectacularly at The Weinmeister Berlin-Mitte hotel which opened on 1 July, 2010. Situated in the city’s central district, Mitte, this 88-room...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=829 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
13.4113999
52.5234051
Lux 11
In East Berlin, only some steps away from the landmark television tower that has become an instantly recognisable symbol of the city, a sparkling white facade adorns a sprawling building. This jewel of......
Lux 11
- Place: Germany, Berlin Region, Berlin
- Price: starts with 109 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Design, pure, spacious suites, purism
- Description: In East Berlin, only some steps away from the landmark television tower that has become an instantly recognisable symbol of the city, a sparkling white facade adorns a sprawling building. This jewel of...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=626 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
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_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1275 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=608 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
13.0407687000
47.7998884000
Hotel Blaue Gans
The Blaue Gans - with its 660 year old tradtion - is the oldest inn in town and careful reconstructions since 2002 have transformed it into the art-hotel. The guests are invited to be inspired by the......
Hotel Blaue Gans
- Place: Austria, Salzburg Region, Salzburg
- Price: starts with 120 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: artlovers, individuals, tradition & design
- Description: The Blaue Gans - with its 660 year old tradtion - is the oldest inn in town and careful reconstructions since 2002 have transformed it into the art-hotel. The guests are invited to be inspired by the...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=636 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
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_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1093 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1289 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
4.8950039
52.3610780
La Remise
La Remise Bed & Breakfast is an intimate and luxurious urban retreat with three guestrooms. It's a urban retreat for a visit to Amsterdam. Located in the Noorderstraat within walking distance from museums,......
La Remise
- Place: Netherlands, North Holland, Amsterdam
- Price: starts with 126 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: minimalist design
- Description: La Remise Bed & Breakfast is an intimate and luxurious urban retreat with three guestrooms. It's a urban retreat for a visit to Amsterdam. Located in the Noorderstraat within walking distance from museums,...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=536 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
13.3401
52.5004
Ellington
In the setting of a magnificent building in the architectural style of the Golden Twenties, you will find in the 285 rooms and suites elegance and quality, in a very special atmosphere. It was here that......
Ellington
- Place: Germany, Berlin Region, Berlin
- Price: starts with 128 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: golden 20th, David Bowie & Lou Reed, vine tresors
- Description: In the setting of a magnificent building in the architectural style of the Golden Twenties, you will find in the 285 rooms and suites elegance and quality, in a very special atmosphere. It was here that...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=907 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=904 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=625 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
13.2590800000
47.4824690000
Auersperg
The Auersperg was erected around 1900 and has been modernised with a love for detail. 55 tastefully renovated rooms impeccably designed in a mix of styles from modern to classic to impart that special......
Auersperg
- Place: Austria, Salzburg Region, Salzburg
- Price: starts with 138 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- Description: The Auersperg was erected around 1900 and has been modernised with a love for detail. 55 tastefully renovated rooms impeccably designed in a mix of styles from modern to classic to impart that special...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1020 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
4.4048120
51.2157106
Hotel Les Nuits
Hotel Les Nuits is located in the heart of Antwerp, in walking distance of the cathedral and the main square. The Hotel offers relaxation in the sauna and the steam room or during beauty treatments. In......
Hotel Les Nuits
- Place: Belgium, Flanders, Antwerp
- Price: starts with 139 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Design, rooftop terraces, centre of Antwerpes
- Description: Hotel Les Nuits is located in the heart of Antwerp, in walking distance of the cathedral and the main square. The Hotel offers relaxation in the sauna and the steam room or during beauty treatments. In...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1016 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
-0.4824949
38.3445009
Hospes Amerigo
Lighten dream by the Mediterranean light, is how Hospes Amérigo is described. An environment that lures and invites: because relaxation, vitality and inspiration are more than just words. The austere......
Hospes Amerigo
- Place: Spain, Valencia, Alicante
- Price: starts with 140 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Hospes Group, modern contemporary hotel in buildings with a great history
- Description: Lighten dream by the Mediterranean light, is how Hospes Amérigo is described. An environment that lures and invites: because relaxation, vitality and inspiration are more than just words. The austere...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1277 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1408 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
7.012082
43.548404
Radisson Blu 1835 Hotel Cannes
The Radisson Hotel & Thalasso Blu 1835 is a luxurious 4-star hotel located in a picturesque old district of Cannes, known for its small winding streets with cozy restaurants and cafes.The hotel offers......
Radisson Blu 1835 Hotel Cannes
- Place: France, Cote d'Azur, Cannes
- Price: starts with 140 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: views to the old habour of cannes, seaview, modern rooms with nautical touch, thalasso
- Description: The Radisson Hotel & Thalasso Blu 1835 is a luxurious 4-star hotel located in a picturesque old district of Cannes, known for its small winding streets with cozy restaurants and cafes.The hotel offers...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1486 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
-0.1755549
51.4930855
Number Sixteen
The exclusive Number Sixteen Hotel is located in the middle of South Kensington and has a total of 42 rooms that are furnished stylish and modern, with great attention to the detail. In the neighborhood......
Number Sixteen
- Place: England, Greater London, London
- Price: starts with 140 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: romantic gardens, london town houses
- Description: The exclusive Number Sixteen Hotel is located in the middle of South Kensington and has a total of 42 rooms that are furnished stylish and modern, with great attention to the detail. In the neighborhood...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1343 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
-3.6028800
37.1719481
Hospes Palacio de los Patos
The Hospes Palacio de los Platos is a 5 star hotel in the center of Granada. The boutique hotel is the perfect starting point to explore the sights of the city. It consists of two buildings, on one hand......
Hospes Palacio de los Patos
- Place: Spain, Andalucia, Granada
- Price: starts with 141 € per Night and Room
- Hotel or Villa/Chalet: Hotel
- For those interested in: Palaces from the 19th century, classical architecture
- Description: The Hospes Palacio de los Platos is a 5 star hotel in the center of Granada. The boutique hotel is the perfect starting point to explore the sights of the city. It consists of two buildings, on one hand...
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=638 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=598 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=873 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=606 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1305 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=953 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=979 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1046 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=898 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=612 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=624 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=876 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1072 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1406 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=692 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=603 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=622 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=725 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=957 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1136 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=468 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1454 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1462 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=602 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=944 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=592 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=989 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=504 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=528 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=964 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=613 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1064 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1436 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=633 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=940 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1143 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1065 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1095 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1421 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=832 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1030 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=605 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1364 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=601 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1411 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=438 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=627 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=620 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=577 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=948 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1015 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1360 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=867 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=442 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=665 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=629 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1013 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1139 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1137 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1283 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1404 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1297 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=925 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=632 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1299 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1362 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=433 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=587 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1057 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=831 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1474 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1008 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1295 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=842 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=467 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=634 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1366 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=959 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=609 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=590 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=749 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=994 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1381 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=596 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=614 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=455 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=641 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=646 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=899 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1066 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1047 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1392 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=866 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=946 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1426 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=635 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1468 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=694 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=888 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1488 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1132 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1430 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=615 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=883 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1456 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=540 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=623 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1368 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=942 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1432 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=576 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1111 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=821 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=644 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=950 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1147 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1285 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1434 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1450 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1383 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=812 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=864 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1038 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=645 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1400 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1119 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1424 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=729 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1097 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=358 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1011 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=491 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1394 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=637 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1388 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=983 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=860 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=525 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=621 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=572 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=631 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1398 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=923 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1193 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=827 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1402 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=995 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1472 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1179 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1428 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=874 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1019 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=845 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
select t2.hotel_id,t1.name_en
from hotels_stil t1 join hotels_hotel_stil t2 on t1.id=t2.stil_id
where t2.hotel_id=1009 and (t1.name='Contemporary Hotels' or t1.name_en='Contemporary Hotels')
order by t2.hotel_id
110
previous < 1/8 >
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
