Gravity Haus Steamboat

Preise von €216 pro Nacht

“Ein schickes Boutique-Hotel, das Ski-in/Ski-out-Luxus und Abenteuer an der Bergbasis von Steamboat bietet. Mit stilvollem Dekor und modernem Komfort, einem beheizten Außenpool, einem Whirlpool, einer nachhaltigen Kaffeestube und der White Rabbit Tavern ist es eine Oase der Entspannung und Aufregung.”

Einrichtungen

Parken
Suiten
Bar
Familien-Suiten
Ansichten
Wifi

Whirlpool
Klimatisierung
Behindertengerechter Zugang
Fitnessstudio
Schwimmbad
Restaurant

Aktivitäten

Sehenswürdigkeiten in der Nähe
Skifahren
Hotel Boote zu mieten

Reiten
Mountainbiken

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

The Inn at Steamboat

The Steamboat Grand

The Bristol Hotel, Steamboat

Anfrage senden

Preise von €216 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

Gravity Haus Steamboat, Steamboat. Expertenbewertungen und Highlights | The Hotel Guru

Gravity Haus Steamboat

Steamboat (United States), Vereinigte Staaten von Amerika

Zur Auswahlliste hinzufügen
Map & Location

Send Enquiry

Preise von €216 pro Nacht

“A chic boutique offering ski-in/ski-out luxury and adventure at the mountain's base by Steamboat. With stylish decor & modern comfort, an outdoor heated pool, hot tub, sustainable coffee spot, & the White Rabbit Tavern- it's a haven for relaxation and excitement”

Recommended For

Gruppen
Sehenswürdigkeiten in der Nähe
Skifahren
Totale Entspannung
Hotel Boote zu mieten
Reiten
Mountainbiken
Hügel und Berge

Restaurant
Fitnessstudio
Behindertengerechter Zugang
Charmant
Romantisch
Ansichten
Familien-Suiten

Einrichtungen

Parken
Suiten
Bar
Familien-Suiten
Ansichten
Wifi

Whirlpool
Klimatisierung
Behindertengerechter Zugang
Fitnessstudio
Schwimmbad
Restaurant

Aktivitäten

Sehenswürdigkeiten in der Nähe
Skifahren
Hotel Boote zu mieten

Reiten
Mountainbiken

Map & Location

What's Nearby

Browse more hotels nearby

The Inn at Steamboat

The Steamboat Grand

The Bristol Hotel, Steamboat

Send Enquiry

Preise von €216 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.8119812011719E-5
Dispatch : 0.23397207260132
Output : 0.0016548633575439
Total : 0.23564505577087
Peak memory: 1.894889831543mb
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.00065 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00059 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.09883 : SELECT * FROM `hotel` WHERE `handle`='gravity-haus-steamboat-steamboat' LIMIT 0, 1
0.00213 : SELECT * FROM `imagestore` WHERE `global_id`='128849177998' ORDER BY image_id = "4063c1b7e541cc3a0a91fb4ba544e041" DESC, position ASC
0.00164 : SELECT * FROM `location` WHERE `location_id`='32706'
0.00382 : SELECT * FROM `location_german` WHERE `location_id`='32706' LIMIT 0, 1
0.00415 : SELECT * FROM `location` WHERE `location_id`='25'
0.00394 : SELECT * FROM `location` WHERE `location_id`='25'
0.00397 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00115 : SELECT * FROM `location` WHERE `location_id`='32706'
0.00264 : SELECT * FROM `location_german` WHERE `location_id`='32706' LIMIT 0, 1
0.00213 : SELECT * FROM `location` WHERE `location_id`='25'
0.00061 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00067 : SELECT * FROM `review` WHERE (hotel_id='159148' OR hotel2_id='159148' OR hotel3_id='159148') AND is_published=1 AND datetime_published<1715664704 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00045 : SELECT * FROM `external_article` WHERE `hotel_id`='159148' LIMIT 0, 1000
0.02535 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(40.456540172894 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(40.456540172894 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((-106.80292370633 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='159148' LIMIT 0, 3
0.00078 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('157071', '157072', '157073') LIMIT 0, 1000
0.00115 : SELECT * FROM `hotel_german` WHERE `hotel_id`='159148' LIMIT 0, 1
0.00105 : SELECT hotel_id FROM `shortlist` WHERE `slid`='3ebaed5f0296bb7f' ORDER BY datetime DESC
0.00162 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00072 : SELECT * FROM `imagestore` WHERE `global_id`='128849177998' ORDER BY image_id = "4063c1b7e541cc3a0a91fb4ba544e041" DESC, position ASC
0.00068 : SELECT * FROM `imagestore_german` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041' LIMIT 0, 1
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='1cb71903545ae4525b32d3611f652901' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611' LIMIT 0, 1
0.00063 : SELECT * FROM `imagestore_german` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='157ab9643a62fbd71050e993380499b1' LIMIT 0, 1
0.00075 : SELECT * FROM `imagestore_german` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='20762c6f658c5e951ce6960415293661' LIMIT 0, 1
0.00091 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451'
0.00146 : SELECT * FROM `imagestore` WHERE `image_id`='1cb71903545ae4525b32d3611f652901'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='1cb71903545ae4525b32d3611f652901'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611'
0.00072 : SELECT * FROM `imagestore` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611'
0.00141 : SELECT * FROM `imagestore` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141'
0.00115 : SELECT * FROM `imagestore` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='157ab9643a62fbd71050e993380499b1'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='157ab9643a62fbd71050e993380499b1'
0.00065 : SELECT * FROM `imagestore` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='20762c6f658c5e951ce6960415293661'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='20762c6f658c5e951ce6960415293661'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00040 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00058 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00059 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00058 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00056 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00353 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00051 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('353', '733', '393', '1993', '1263', '93', '1173', '43', '123', '483', '853', '1073', '1163', '1193', '1393')
0.00099 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00215 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1353', '893', '1413', '1393', '1193', '1153', '973', '3', '853', '483', '303', '123')
0.00063 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00049 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00059 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00048 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('733', '393', '1263', '93', '1173')
0.00057 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00051 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00068 : SELECT * FROM `imagestore` WHERE `global_id`='128849177998' ORDER BY image_id = "4063c1b7e541cc3a0a91fb4ba544e041" DESC, position ASC
0.00040 : SELECT * FROM `imagestore_german` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='1cb71903545ae4525b32d3611f652901' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61' LIMIT 0, 1
0.00039 : SELECT * FROM `imagestore_german` WHERE `image_id`='157ab9643a62fbd71050e993380499b1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1' LIMIT 0, 1
0.00038 : SELECT * FROM `imagestore_german` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1' LIMIT 0, 1
0.00038 : SELECT * FROM `imagestore_german` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1' LIMIT 0, 1
0.00039 : SELECT * FROM `imagestore_german` WHERE `image_id`='20762c6f658c5e951ce6960415293661' LIMIT 0, 1
0.00062 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='1029e1ea37b1f183af5e16e784518451'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='1cb71903545ae4525b32d3611f652901'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='1cb71903545ae4525b32d3611f652901'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611'
0.00040 : SELECT * FROM `imagestore` WHERE `image_id`='50a196f243b32d672bb77d3139e6a611'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='84c40ff73a1aeb9e332744ef8cbbb141'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61'
0.00039 : SELECT * FROM `imagestore` WHERE `image_id`='1a4fc000978c20dda704b6f5e788ab61'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='157ab9643a62fbd71050e993380499b1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='157ab9643a62fbd71050e993380499b1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='d6ac8b360f41e939cff1e0782888fcf1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='971f9e3cc35e42754b1882d4f8b906e1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='785472e6d3fe8ef1fe93214da9d1d1c1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='1bde119304bdb5abec6d2637a221d7e1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='20762c6f658c5e951ce6960415293661'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='20762c6f658c5e951ce6960415293661'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='4063c1b7e541cc3a0a91fb4ba544e041'
0.00061 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00060 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00057 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' 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.00055 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00052 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00047 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('353', '733', '393', '1993', '1263', '93', '1173', '43', '123', '483', '853', '1073', '1163', '1193', '1393')
0.00069 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00047 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1353', '893', '1413', '1393', '1193', '1153', '973', '3', '853', '483', '303', '123')
0.00053 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00051 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00060 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00051 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('733', '393', '1263', '93', '1173')
0.00062 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='159148' AND `hotel_tag`.`strap` IS NOT NULL
0.00049 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='159148'
0.00073 : SELECT name FROM `shortlist_name` WHERE `slid`='3ebaed5f0296bb7f'

Gravity Haus Steamboat

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?

Gravity Haus Steamboat

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Browse more hotels nearby

Any Questions?