American Beech Hotel

Greenport, Vereinigte Staaten von Amerika

Zur Auswahlliste hinzufügen
Karte & Standort

11 Zimmer ab €260 pro Nacht

“Ein luxuriöses Boutique-Hotel im Herzen des historischen Greenport. Die elf modernen Designer-Zimmer sind mit Frette-Bettwäsche, schwarz-weißem Mobiliar und Maison Margiela-Ausstattung ausgestattet. Speisen Sie im eklektischen amerikanischen Restaurant und schlürfen Sie innovative Cocktails. Perfekt für einen Pärchen-Urlaub auf Long Island.”

Einrichtungen

Restaurant
Auf der Speisekarte stehen marktfrische und lokale Zutaten
Bar
Die Black Llama Bar ist eine Cocktail- und Austernbar
Haustierfreundlich
Es gelten zusätzliche Gebühren
Kinderfreundlich
Alle Altersgruppen sind willkommen
Satelliten- / Kabelfernsehen
Bademäntel
Parken

Sitzungssaal
Sit-out Terrace
Wifi
Hausmeister
Suiten
Behindertengerechter Zugang
Garten

Aktivitäten

Kajakfahren
Kajakfahren durch Buchten, Bäche und Sümpfe, umgeben von einer reichen Vogelwelt
Radfahren
Radeln Sie durch die Landstraßen und entdecken Sie versteckte Strände
Weinverkostung
Entdecken Sie das nahe gelegene Weinland von Long Island

Vogelbeobachtung
Nähe zum Nachtleben
Angeln

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

Sunset Beach Hotel

The Menhaden

Seven

Verfügbarkeit prüfen

11 Zimmer ab €260 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

American Beech Hotel, Greenport. Expertenbewertungen und Highlights | The Hotel Guru

American Beech Hotel

Greenport, Vereinigte Staaten von Amerika

Zur Auswahlliste hinzufügen
Map & Location

11 Zimmer ab €260 pro Nacht

“A boutique luxury hotel in the heart of historic Greenport. Eleven modern designer rooms features Frette linens, black and white furnishings and Maison Margiela amenities. Dine at the eclectic American restaurant and sip innovative cocktails. Perfect for a Long Island couples' break. ”

Recommended For

Strandleben
Nehmen Sie die Fähre nach Shelter Island und erkunden Sie die herrlichen Strände
Lokale Erkundung
Ein guter Ort für die Erkundung der weiteren Umgebung von Long Island
Kajakfahren
Kajakfahren durch Buchten, Bäche und Sümpfe, umgeben von einer reichen Vogelwelt
Radfahren
Radeln Sie durch die Landstraßen und entdecken Sie versteckte Strände
Weinverkostung
Entdecken Sie das nahe gelegene Weinland von Long Island
Vogelbeobachtung
Nähe zum Nachtleben
Angeln
Restaurant
Auf der Speisekarte stehen marktfrische und lokale Zutaten

Haustierfreundlich
Es gelten zusätzliche Gebühren
Kinderfreundlich
Alle Altersgruppen sind willkommen
Sit-out Terrace
Designer
Voller Charakter
Romantisch
Behindertengerechter Zugang
Shop
Meerblick

Einrichtungen

Restaurant
Auf der Speisekarte stehen marktfrische und lokale Zutaten
Bar
Die Black Llama Bar ist eine Cocktail- und Austernbar
Haustierfreundlich
Es gelten zusätzliche Gebühren
Kinderfreundlich
Alle Altersgruppen sind willkommen
Satelliten- / Kabelfernsehen
Bademäntel
Parken

Sitzungssaal
Sit-out Terrace
Wifi
Hausmeister
Suiten
Behindertengerechter Zugang
Garten

Aktivitäten

Kajakfahren
Kajakfahren durch Buchten, Bäche und Sümpfe, umgeben von einer reichen Vogelwelt
Radfahren
Radeln Sie durch die Landstraßen und entdecken Sie versteckte Strände
Weinverkostung
Entdecken Sie das nahe gelegene Weinland von Long Island

Vogelbeobachtung
Nähe zum Nachtleben
Angeln

Map & Location

What's Nearby

Other Reviews

American Beech Hotel

A splashy reno that marries Miami chic, beachy North Fork.

Originally published by CN Traveller

Browse more hotels nearby

Sunset Beach Hotel

The Menhaden

Seven

Check Availability

11 Zimmer ab €260 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.7881393432617E-5
Dispatch : 0.75726318359375
Output : 0.0017900466918945
Total : 0.75907111167908
Peak memory: 1.9322128295898mb
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.00057 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.58337 : SELECT * FROM `hotel` WHERE `handle`='american-beech-hotel-greenport' LIMIT 0, 1
0.00493 : SELECT * FROM `imagestore` WHERE `global_id`='128849175791' ORDER BY image_id = "81e6119a1a56d5e0201435f3ab14b631" DESC, position ASC
0.00083 : SELECT * FROM `location` WHERE `location_id`='32786'
0.00325 : SELECT * FROM `location_german` WHERE `location_id`='32786' LIMIT 0, 1
0.00140 : SELECT * FROM `location` WHERE `location_id`='25'
0.00250 : SELECT * FROM `location` WHERE `location_id`='25'
0.00116 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00072 : SELECT * FROM `location` WHERE `location_id`='32786'
0.00191 : SELECT * FROM `location_german` WHERE `location_id`='32786' LIMIT 0, 1
0.00299 : SELECT * FROM `location` WHERE `location_id`='25'
0.00099 : SELECT * FROM `location_german` WHERE `location_id`='25' LIMIT 0, 1
0.00078 : SELECT * FROM `review` WHERE (hotel_id='156941' OR hotel2_id='156941' OR hotel3_id='156941') AND is_published=1 AND datetime_published<1715633646 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00077 : SELECT * FROM `external_article` WHERE `hotel_id`='156941' LIMIT 0, 1000
0.05258 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(41.103865548997 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(41.103865548997 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((-72.35949754715 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='156941' LIMIT 0, 3
0.00095 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('49373', '145843', '156634') LIMIT 0, 1000
0.00136 : SELECT * FROM `hotel_german` WHERE `hotel_id`='156941' LIMIT 0, 1
0.00062 : SELECT hotel_id FROM `shortlist` WHERE `slid`='831ea2823363fee7' ORDER BY datetime DESC
0.00165 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00078 : SELECT * FROM `imagestore` WHERE `global_id`='128849175791' ORDER BY image_id = "81e6119a1a56d5e0201435f3ab14b631" DESC, position ASC
0.00073 : SELECT * FROM `imagestore_german` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631' LIMIT 0, 1
0.00087 : SELECT * FROM `imagestore_german` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1' LIMIT 0, 1
0.00056 : SELECT * FROM `imagestore_german` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1' LIMIT 0, 1
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1' LIMIT 0, 1
0.00066 : SELECT * FROM `imagestore_german` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71' LIMIT 0, 1
0.00053 : SELECT * FROM `imagestore_german` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1' LIMIT 0, 1
0.00079 : SELECT * FROM `imagestore_german` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='d09f83405110bd94886aa817ede158a1' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01' LIMIT 0, 1
0.00057 : SELECT * FROM `imagestore_german` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1' LIMIT 0, 1
0.00062 : SELECT * FROM `imagestore_german` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1' LIMIT 0, 1
0.00053 : SELECT * FROM `imagestore_german` WHERE `image_id`='7910916185131faafc0d667baa03a4a1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00072 : SELECT * FROM `imagestore` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1'
0.00103 : SELECT * FROM `imagestore` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1'
0.00074 : SELECT * FROM `imagestore` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1'
0.00080 : SELECT * FROM `imagestore` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1'
0.00058 : SELECT * FROM `imagestore` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1'
0.00084 : SELECT * FROM `imagestore` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1'
0.00065 : SELECT * FROM `imagestore` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1'
0.00071 : SELECT * FROM `imagestore` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1'
0.00066 : SELECT * FROM `imagestore` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1'
0.00067 : SELECT * FROM `imagestore` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1'
0.00104 : SELECT * FROM `imagestore` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451'
0.00071 : SELECT * FROM `imagestore` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='d09f83405110bd94886aa817ede158a1'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='d09f83405110bd94886aa817ede158a1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01'
0.00060 : SELECT * FROM `imagestore` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1'
0.00062 : SELECT * FROM `imagestore` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1'
0.00066 : SELECT * FROM `imagestore` WHERE `image_id`='7910916185131faafc0d667baa03a4a1'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='7910916185131faafc0d667baa03a4a1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00077 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00094 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00075 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00058 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00201 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00056 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('53', '2383', '833', '273', '623', '1143', '1113', '213', '123', '593', '653', '2123', '1643', '2243', '1163', '853', '263', '223')
0.00063 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00048 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('123', '1413', '593', '653', '1053', '1333', '1353', '1593', '2123', '1153', '1013', '893', '853', '423')
0.00061 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00047 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00058 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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 ('833', '273', '623', '1143', '1113', '213')
0.00066 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00068 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00083 : SELECT * FROM `imagestore` WHERE `global_id`='128849175791' ORDER BY image_id = "81e6119a1a56d5e0201435f3ab14b631" DESC, position ASC
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631' LIMIT 0, 1
0.00064 : SELECT * FROM `imagestore_german` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1' LIMIT 0, 1
0.00067 : SELECT * FROM `imagestore_german` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1' LIMIT 0, 1
0.00070 : SELECT * FROM `imagestore_german` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1' LIMIT 0, 1
0.00041 : SELECT * FROM `imagestore_german` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71' LIMIT 0, 1
0.00066 : SELECT * FROM `imagestore_german` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1' LIMIT 0, 1
0.00071 : SELECT * FROM `imagestore_german` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='d09f83405110bd94886aa817ede158a1' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1' LIMIT 0, 1
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='7910916185131faafc0d667baa03a4a1' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971'
0.00062 : SELECT * FROM `imagestore` WHERE `image_id`='c5aed1ba0e22a39e0a8bc7088b817971'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='6680cdfe2c4ae9e19f9b86b66b6853c1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1'
0.00064 : SELECT * FROM `imagestore` WHERE `image_id`='56de389b01ee5941ac33b3e18f8ff8a1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='c6491d7ab0ae13102f1ded55abd572f1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1'
0.00067 : SELECT * FROM `imagestore` WHERE `image_id`='e1f3574f75cc2f9a28428463cd3058d1'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='337c88058afb5ce3f99c7f997d682df1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71'
0.00064 : SELECT * FROM `imagestore` WHERE `image_id`='ab9e50badcbe48e42ce6b34399d42e71'
0.00076 : SELECT * FROM `imagestore` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='424c75258f5cd842dbc8ae3e6f8ed2f1'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='aefeff2ea141301ec701c780630c5fc1'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='4d33a956e85b8f454c7716f2e7fda451'
0.00057 : SELECT * FROM `imagestore` WHERE `image_id`='d09f83405110bd94886aa817ede158a1'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='d09f83405110bd94886aa817ede158a1'
0.00062 : SELECT * FROM `imagestore` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01'
0.00053 : SELECT * FROM `imagestore` WHERE `image_id`='85f5f71c6243f2ffe150aacd6b4f6b01'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='472318a6e7fd5e4fde1e3f10075162e1'
0.00069 : SELECT * FROM `imagestore` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='b9faa9f394f02d0babcd84f9f1ef81d1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='7910916185131faafc0d667baa03a4a1'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='7910916185131faafc0d667baa03a4a1'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='81e6119a1a56d5e0201435f3ab14b631'
0.00080 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00077 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00071 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' 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.00077 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00066 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00078 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('53', '2383', '833', '273', '623', '1143', '1113', '213', '123', '593', '653', '2123', '1643', '2243', '1163', '853', '263', '223')
0.00066 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00050 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('123', '1413', '593', '653', '1053', '1333', '1353', '1593', '2123', '1153', '1013', '893', '853', '423')
0.00061 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00070 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00066 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00053 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('833', '273', '623', '1143', '1113', '213')
0.00052 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='156941' AND `hotel_tag`.`strap` IS NOT NULL
0.00070 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='156941'
0.00076 : SELECT name FROM `shortlist_name` WHERE `slid`='831ea2823363fee7'

American Beech 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?

American Beech Hotel

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Other Reviews

American Beech Hotel

Browse more hotels nearby

Any Questions?