The Saint Hotel

Key West (Florida), Vereinigte Staaten von Amerika

Zur Auswahlliste hinzufügen
Karte & Standort

36 Zimmer ab €356 pro Nacht

“Ein elegantes Hotel in der Nähe der Duval Street und des Strandes. Die Zimmer sind in Kobaltblau und Weiß gehalten und verfügen über stimmungsvolle Beleuchtung und Soundsysteme. Es gibt ein Restaurant mit amerikanischer Küche, eine glitzernde Bar, einen Außenpool und eine Terrasse mit üppiger Vegetation. Ein großartiger Ort, um Key West zu erkunden.”

Einrichtungen

Zimmer mit Balkon/Terrasse
Restaurant
Schwimmbad
Bar
Keine Haustiere
Sitzungssaal
Restaurants in Gehweite
Dachterrasse
Wifi
Sicher
Satelliten- / Kabelfernsehen
Fahrradverleih

Sit-out Terrace
Wäscherei
Aufzug
EV-Ladestation
Sitzungszimmer
Garten
Kinderfreundlich
Zimmerservice
Behindertengerechter Zugang
Suiten
Hausmeister
Klimatisierung

Aktivitäten

Andere Aktivitäten
Sehenswürdigkeiten in der Nähe
Schnorcheln
Lokale Märkte
Museen
Angeln

Radfahren
Golf
Wassersport
Weinverkostung
Nähe zum Nachtleben
Kajakfahren

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

Marquesa Hotel

Santa Maria Suites Resort

The Artist House

Verfügbarkeit prüfen

36 Zimmer ab €356 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

The Saint Hotel, Key West. Expertenbewertungen und Highlights | The Hotel Guru

The Saint Hotel

Key West (Florida), Vereinigte Staaten von Amerika

Zur Auswahlliste hinzufügen
Map & Location

36 Zimmer ab €356 pro Nacht

“A lively hotel next to Duval street and near the beach. The rooms are decorated in cobalt blue and white with moody lighting and sound systems. There's a restaurant serving American fare plus a glitzy bar, outdoor pool and a terrace with lush landscaping. A great spot for exploring Key West.”

Recommended For

Lokale Erkundung
Strandleben
Andere Aktivitäten
Sehenswürdigkeiten in der Nähe
Schnorcheln
Lokale Märkte
Museen
Angeln
Radfahren
Golf
Wassersport
Weinverkostung
Nähe zum Nachtleben
Kajakfahren

Zimmer mit Balkon/Terrasse
Restaurant
Romantisch
Stadtzentrum
Dachterrasse
Sit-out Terrace
Schick
Kinderfreundlich
Strand in der Nähe
Auf einer Insel
Behindertengerechter Zugang
Zeitgenössische
Charmant

Einrichtungen

Zimmer mit Balkon/Terrasse
Restaurant
Schwimmbad
Bar
Keine Haustiere
Sitzungssaal
Restaurants in Gehweite
Dachterrasse
Wifi
Sicher
Satelliten- / Kabelfernsehen
Fahrradverleih

Sit-out Terrace
Wäscherei
Aufzug
EV-Ladestation
Sitzungszimmer
Garten
Kinderfreundlich
Zimmerservice
Behindertengerechter Zugang
Suiten
Hausmeister
Klimatisierung

Aktivitäten

Andere Aktivitäten
Sehenswürdigkeiten in der Nähe
Schnorcheln
Lokale Märkte
Museen
Angeln

Radfahren
Golf
Wassersport
Weinverkostung
Nähe zum Nachtleben
Kajakfahren

Map & Location

What's Nearby

Browse more hotels nearby

Marquesa Hotel

Santa Maria Suites Resort

The Artist House

Check Availability

36 Zimmer ab €356 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.8119812011719E-5
Dispatch : 0.62176394462585
Output : 0.0017471313476562
Total : 0.62352919578552
Peak memory: 1.9484100341797mb
Server name: Linux ip-172-26-7-178 5.4.0-1030-aws #31-Ubuntu SMP Fri Nov 13 11:40:37 UTC 2020 x86_64

0.00413 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00369 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.35196 : SELECT * FROM `hotel` WHERE `handle`='the-saint-hotel-key-west' LIMIT 0, 1
0.00940 : SELECT * FROM `imagestore` WHERE `global_id`='128849177928' ORDER BY image_id = "baff4cc4265e5039bed59aa037856821" DESC, position ASC
0.00069 : SELECT * FROM `location` WHERE `location_id`='32383'
0.00072 : SELECT * FROM `location_german` WHERE `location_id`='32383' LIMIT 0, 1
0.00116 : SELECT * FROM `location` WHERE `location_id`='25'
0.00307 : SELECT * FROM `location` WHERE `location_id`='25'
0.00068 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00309 : SELECT * FROM `location` WHERE `location_id`='32383'
0.00077 : SELECT * FROM `location_german` WHERE `location_id`='32383' LIMIT 0, 1
0.00310 : SELECT * FROM `location` WHERE `location_id`='25'
0.00393 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00363 : SELECT * FROM `review` WHERE (hotel_id='159078' OR hotel2_id='159078' OR hotel3_id='159078') AND is_published=1 AND datetime_published<1715641443 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00058 : SELECT * FROM `external_article` WHERE `hotel_id`='159078' LIMIT 0, 1000
0.01484 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(24.556734049524 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(24.556734049524 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((-81.804239008182 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='159078' LIMIT 0, 3
0.00486 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('50393', '50413', '50453') LIMIT 0, 1000
0.00345 : SELECT * FROM `hotel_german` WHERE `hotel_id`='159078' LIMIT 0, 1
0.00066 : SELECT hotel_id FROM `shortlist` WHERE `slid`='abcdaabb637bd0e5' ORDER BY datetime DESC
0.00556 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00494 : SELECT * FROM `imagestore` WHERE `global_id`='128849177928' ORDER BY image_id = "baff4cc4265e5039bed59aa037856821" DESC, position ASC
0.00304 : SELECT * FROM `imagestore_german` WHERE `image_id`='baff4cc4265e5039bed59aa037856821' LIMIT 0, 1
0.00351 : SELECT * FROM `imagestore_german` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1' LIMIT 0, 1
0.00174 : SELECT * FROM `imagestore_german` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741' LIMIT 0, 1
0.00040 : SELECT * FROM `imagestore_german` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121' LIMIT 0, 1
0.00056 : SELECT * FROM `imagestore_german` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781' LIMIT 0, 1
0.00040 : SELECT * FROM `imagestore_german` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1' LIMIT 0, 1
0.00110 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00120 : SELECT * FROM `imagestore` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1'
0.00113 : SELECT * FROM `imagestore` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1'
0.00279 : SELECT * FROM `imagestore` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1'
0.00350 : SELECT * FROM `imagestore` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1'
0.00443 : SELECT * FROM `imagestore` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1'
0.00395 : SELECT * FROM `imagestore` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741'
0.00080 : SELECT * FROM `imagestore` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741'
0.00317 : SELECT * FROM `imagestore` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1'
0.00396 : SELECT * FROM `imagestore` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1'
0.00489 : SELECT * FROM `imagestore` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121'
0.00304 : SELECT * FROM `imagestore` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121'
0.00399 : SELECT * FROM `imagestore` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1'
0.00398 : SELECT * FROM `imagestore` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1'
0.00269 : SELECT * FROM `imagestore` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1'
0.00064 : SELECT * FROM `imagestore` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1'
0.00533 : SELECT * FROM `imagestore` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1'
0.00078 : SELECT * FROM `imagestore` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1'
0.00637 : SELECT * FROM `imagestore` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891'
0.00170 : SELECT * FROM `imagestore` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891'
0.00230 : SELECT * FROM `imagestore` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781'
0.00396 : SELECT * FROM `imagestore` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781'
0.00396 : SELECT * FROM `imagestore` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31'
0.00393 : SELECT * FROM `imagestore` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31'
0.00404 : SELECT * FROM `imagestore` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181'
0.00400 : SELECT * FROM `imagestore` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181'
0.00390 : SELECT * FROM `imagestore` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1'
0.00394 : SELECT * FROM `imagestore` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1'
0.00400 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00394 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00207 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='2' AND `tag`.`collection` IN ('3', '4', '5', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00076 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00070 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` NOT IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00060 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00060 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00056 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2383', '53', '2063', '733', '1743', '2373', '2483', '213', '273', '333', '453', '623', '1113', '833', '1483', '123', '1163', '1283', '1423', '2123', '443', '653', '793', '843', '853', '993', '1073')
0.00069 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00057 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1483', '123', '303', '1413', '1703', '1593', '1523', '1423', '1153', '1313', '1053', '1733', '2123', '2563', '2679', '2680', '703', '423', '653', '753', '853', '893', '1013', '3')
0.00058 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00052 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00069 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00269 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2063', '733', '1743', '2373', '2483', '213', '273', '333', '453', '623', '1113', '833')
0.00432 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00381 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00191 : SELECT * FROM `imagestore` WHERE `global_id`='128849177928' ORDER BY image_id = "baff4cc4265e5039bed59aa037856821" DESC, position ASC
0.00359 : SELECT * FROM `imagestore_german` WHERE `image_id`='baff4cc4265e5039bed59aa037856821' LIMIT 0, 1
0.00204 : SELECT * FROM `imagestore_german` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1' LIMIT 0, 1
0.00188 : SELECT * FROM `imagestore_german` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241' LIMIT 0, 1
0.00189 : SELECT * FROM `imagestore_german` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1' LIMIT 0, 1
0.00076 : SELECT * FROM `imagestore_german` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1' LIMIT 0, 1
0.00040 : SELECT * FROM `imagestore_german` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121' LIMIT 0, 1
0.00041 : SELECT * FROM `imagestore_german` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781' LIMIT 0, 1
0.00124 : SELECT * FROM `imagestore_german` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181' LIMIT 0, 1
0.00057 : SELECT * FROM `imagestore_german` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='50c3cc4b0e8c04044d09b7b7ba4fc3e1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='5e2aeec23913fbd6b7b679d637205241'
0.00066 : SELECT * FROM `imagestore` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='f0a102151f9fdaaf117b8b04e88dfed1'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='166606fa5c52cb44c3be912e348519b1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='a6e32fe52c5e032b5d03030fbaf17741'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='8229f86e7708ad3c02419ea99062ddf1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='65892379fbacc5c16b33d88f2096c121'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='180f8f81ed84bc4a85a6dcb99e06dfa1'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='0d2b11cd2e90f45e54890178a1e687d1'
0.00076 : SELECT * FROM `imagestore` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1'
0.00071 : SELECT * FROM `imagestore` WHERE `image_id`='a1c1c8468068ed5ce38e65dcd5e28ca1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='dbd11101bcc738e6babc6df07ad94891'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='0bbdc465818fa6b1f71ad7460b173781'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='c0a81f12559da9b88b9e02f128d71b31'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='79e4060f357b7365b8a2d657adfad181'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='5ee43ac736d4430ae11eb42bfb90e2c1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='baff4cc4265e5039bed59aa037856821'
0.00066 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='2' AND `tag`.`collection` IN ('3', '4', '5', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00083 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`score`='1' AND `tag`.`is_featured`='1' AND `tag`.`collection` NOT IN ('4', '6') ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00071 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00061 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00059 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2383', '53', '2063', '733', '1743', '2373', '2483', '213', '273', '333', '453', '623', '1113', '833', '1483', '123', '1163', '1283', '1423', '2123', '443', '653', '793', '843', '853', '993', '1073')
0.00064 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00049 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1483', '123', '303', '1413', '1703', '1593', '1523', '1423', '1153', '1313', '1053', '1733', '2123', '2563', '2679', '2680', '703', '423', '653', '753', '853', '893', '1013', '3')
0.00051 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00040 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00056 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00047 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('2063', '733', '1743', '2373', '2483', '213', '273', '333', '453', '623', '1113', '833')
0.00060 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159078' AND `hotel_tag`.`strap` IS NOT NULL
0.00085 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159078'
0.00071 : SELECT name FROM `shortlist_name` WHERE `slid`='abcdaabb637bd0e5'

The Saint Hotel

Hotel Zimmer

Empfohlen für

Einrichtungen

Aktivitäten

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

Haben Sie Fragen?

The Saint Hotel

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Browse more hotels nearby

Any Questions?