Shiroiya Hotel

25 Zimmer ab €151 pro Nacht

“Der Architekt hat große Namen des Designs herangezogen, um das wohl stilvollste Hotel in Maebashi zu schaffen. Individuell gestaltete Zimmer mischen japanischen Minimalismus mit industriellem Flair. Gut ausgewählte Kunstwerke sind überall zu finden, und das Essen ist eine echte Verlockung, einschließlich eines Restaurants, das von Hiroyasu Kawate geleitet wird.”

Einrichtungen

Sauna/Dampfbad
Drei verschiedene Saunatypen: eine Nebelsauna, eine finnische Sauna und eine Schlafsauna
Bar
Nur an den Wochenenden geöffnet. Geleitet von einem renommierten Mixologen
Kinderfreundlich
Kinder unter 12 Jahren können ein Bett ohne Aufpreis teilen

Restaurant
Wifi
Privater Speisesaal

Aktivitäten

Tolle Spaziergänge
Verbringen Sie den Tag mit einer Wanderung durch die Berge von Gunma - einer der Hauptgründe für einen Besuch
Kajakfahren
Das Anwesen organisiert eine halbtägige Kanutour auf dem malerischen Shimako-See.

Andere Aktivitäten
Tauchen Sie bei einer traditionellen Teezeremonie in die lokale Kultur ein

Karte & Standort

Was ist in der Nähe

Anfrage senden

25 Zimmer ab €151 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

Shiroiya Hotel, Maebashi. Expertenbewertungen und Highlights | The Hotel Guru

The Hotel Guru
Japan
Maebashi
Shiroiya Hotel

Shiroiya Hotel

Maebashi (Gunma Prefecture), Japan

Zur Auswahlliste hinzufügen
Map & Location

Send Enquiry

25 Zimmer ab €151 pro Nacht

“The architect has pulled in weighty names in design to create arguably Maebashi's most stylish hotel. Individually styled rooms mix Japanese minimalism with an industrial feel. Well-chosen art can be found throughout while the food is a real lure including a restaurant overseen by Hiroyasu Kawate.”

Recommended For

Kunstwerke
Kunst ist das Herzstück des Hotels, wie das permanente rote digitale Kunstwerk von Tatsuo Miyajima zeigt
Designer
Der Architekt Sou Fujimoto hat ein Design-Meisterwerk geschaffen, das einen schicken japanischen Minimalismus mit einem industriellen Touch bietet
Feinschmecker
Verschiedene Speisemöglichkeiten reichen von einem schicken Café bis hin zu einem von einem mit einem Michelin-Stern ausgezeichneten Chefkoch kreierten Restaurant.
Tolle Spaziergänge
Verbringen Sie den Tag mit einer Wanderung durch die Berge von Gunma - einer der Hauptgründe für einen Besuch

Kajakfahren
Das Anwesen organisiert eine halbtägige Kanutour auf dem malerischen Shimako-See.
Andere Aktivitäten
Tauchen Sie bei einer traditionellen Teezeremonie in die lokale Kultur ein
Kinderfreundlich
Kinder unter 12 Jahren können ein Bett ohne Aufpreis teilen
Restaurant

Einrichtungen

Sauna/Dampfbad
Drei verschiedene Saunatypen: eine Nebelsauna, eine finnische Sauna und eine Schlafsauna
Bar
Nur an den Wochenenden geöffnet. Geleitet von einem renommierten Mixologen
Kinderfreundlich
Kinder unter 12 Jahren können ein Bett ohne Aufpreis teilen

Restaurant
Wifi
Privater Speisesaal

Aktivitäten

Tolle Spaziergänge
Verbringen Sie den Tag mit einer Wanderung durch die Berge von Gunma - einer der Hauptgründe für einen Besuch
Kajakfahren
Das Anwesen organisiert eine halbtägige Kanutour auf dem malerischen Shimako-See.

Andere Aktivitäten
Tauchen Sie bei einer traditionellen Teezeremonie in die lokale Kultur ein

Map & Location

What's Nearby

Send Enquiry

25 Zimmer ab €151 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 1.8119812011719E-5
Dispatch : 0.38868618011475
Output : 0.00160813331604
Total : 0.3903124332428
Peak memory: 1.8576736450195mb
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.00219 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00054 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.16010 : SELECT * FROM `hotel` WHERE `handle`='shiroiya-hotel-maebashi' LIMIT 0, 1
0.00566 : SELECT * FROM `imagestore` WHERE `global_id`='128849177030' ORDER BY image_id = "7a1537b2184a6900085d545234fa7bc1" DESC, position ASC
0.00086 : SELECT * FROM `location` WHERE `location_id`='32787'
0.00064 : SELECT * FROM `location_german` WHERE `location_id`='32787' LIMIT 0, 1
0.00089 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00102 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00138 : SELECT * FROM `location_german` WHERE `location_id`='21693' LIMIT 0, 1
0.00108 : SELECT * FROM `location` WHERE `location_id`='32787'
0.00053 : SELECT * FROM `location_german` WHERE `location_id`='32787' LIMIT 0, 1
0.00137 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00065 : SELECT * FROM `location_german` WHERE `location_id`='21693' LIMIT 0, 1
0.00067 : SELECT * FROM `review` WHERE (hotel_id='158180' OR hotel2_id='158180' OR hotel3_id='158180') AND is_published=1 AND datetime_published<1715653191 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00056 : SELECT * FROM `external_article` WHERE `hotel_id`='158180' LIMIT 0, 1000
0.04772 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(36.390172924828 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(36.390172924828 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((139.07005235553 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='158180' LIMIT 0, 3
0.00073 : SELECT * FROM `hotel` WHERE FALSE LIMIT 0, 1000
0.00112 : SELECT * FROM `hotel_german` WHERE `hotel_id`='158180' LIMIT 0, 1
0.00108 : SELECT hotel_id FROM `shortlist` WHERE `slid`='ede3fd4884205af5' ORDER BY datetime DESC
0.00456 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00276 : SELECT * FROM `imagestore` WHERE `global_id`='128849177030' ORDER BY image_id = "7a1537b2184a6900085d545234fa7bc1" DESC, position ASC
0.00366 : SELECT * FROM `imagestore_german` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1' LIMIT 0, 1
0.00404 : SELECT * FROM `imagestore_german` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741' LIMIT 0, 1
0.00236 : SELECT * FROM `imagestore_german` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1' LIMIT 0, 1
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1' LIMIT 0, 1
0.00055 : SELECT * FROM `imagestore_german` WHERE `image_id`='f28920967e67ec815ecd199103b20981' LIMIT 0, 1
0.00103 : SELECT * FROM `imagestore_german` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1' LIMIT 0, 1
0.00062 : SELECT * FROM `imagestore_german` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1' LIMIT 0, 1
0.00056 : SELECT * FROM `imagestore_german` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91' LIMIT 0, 1
0.00195 : SELECT * FROM `imagestore_german` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981' LIMIT 0, 1
0.00082 : SELECT * FROM `imagestore_german` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041' LIMIT 0, 1
0.00259 : SELECT * FROM `imagestore_german` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51' LIMIT 0, 1
0.00397 : SELECT * FROM `imagestore_german` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11' LIMIT 0, 1
0.00162 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00366 : SELECT * FROM `imagestore` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741'
0.00237 : SELECT * FROM `imagestore` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741'
0.00382 : SELECT * FROM `imagestore` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1'
0.00086 : SELECT * FROM `imagestore` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1'
0.00090 : SELECT * FROM `imagestore` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1'
0.00200 : SELECT * FROM `imagestore` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1'
0.00130 : SELECT * FROM `imagestore` WHERE `image_id`='f28920967e67ec815ecd199103b20981'
0.00100 : SELECT * FROM `imagestore` WHERE `image_id`='f28920967e67ec815ecd199103b20981'
0.00150 : SELECT * FROM `imagestore` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1'
0.00087 : SELECT * FROM `imagestore` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61'
0.00083 : SELECT * FROM `imagestore` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61'
0.00208 : SELECT * FROM `imagestore` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1'
0.00060 : SELECT * FROM `imagestore` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91'
0.00428 : SELECT * FROM `imagestore` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981'
0.00103 : SELECT * FROM `imagestore` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981'
0.00071 : SELECT * FROM `imagestore` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041'
0.00191 : SELECT * FROM `imagestore` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041'
0.00070 : SELECT * FROM `imagestore` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401'
0.00083 : SELECT * FROM `imagestore` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401'
0.00559 : SELECT * FROM `imagestore` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51'
0.00203 : SELECT * FROM `imagestore` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51'
0.00441 : SELECT * FROM `imagestore` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11'
0.00386 : SELECT * FROM `imagestore` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11'
0.00189 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00061 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00108 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00101 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00180 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00085 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00109 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00064 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('203', '1643', '473', '153', '833', '2063', '653', '123')
0.00080 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00082 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1573', '1413', '653', '123', '1153', '1773')
0.00080 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00091 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00114 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00075 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('153', '833', '2063')
0.00069 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00055 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00091 : SELECT * FROM `imagestore` WHERE `global_id`='128849177030' ORDER BY image_id = "7a1537b2184a6900085d545234fa7bc1" DESC, position ASC
0.00050 : SELECT * FROM `imagestore_german` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1' LIMIT 0, 1
0.00092 : SELECT * FROM `imagestore_german` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741' LIMIT 0, 1
0.00072 : SELECT * FROM `imagestore_german` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1' LIMIT 0, 1
0.00067 : SELECT * FROM `imagestore_german` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='f28920967e67ec815ecd199103b20981' LIMIT 0, 1
0.00114 : SELECT * FROM `imagestore_german` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1' LIMIT 0, 1
0.00060 : SELECT * FROM `imagestore_german` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1' LIMIT 0, 1
0.00083 : SELECT * FROM `imagestore_german` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91' LIMIT 0, 1
0.00071 : SELECT * FROM `imagestore_german` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981' LIMIT 0, 1
0.00041 : SELECT * FROM `imagestore_german` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041' LIMIT 0, 1
0.00058 : SELECT * FROM `imagestore_german` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401' LIMIT 0, 1
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore_german` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11' LIMIT 0, 1
0.00109 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00076 : SELECT * FROM `imagestore` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='ad03f2bd2892a4530dbcc4a590c99741'
0.00073 : SELECT * FROM `imagestore` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1'
0.00084 : SELECT * FROM `imagestore` WHERE `image_id`='faaeadb10007f087f8d18b616b6c4fa1'
0.00075 : SELECT * FROM `imagestore` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1'
0.00086 : SELECT * FROM `imagestore` WHERE `image_id`='038b539a6572fdb0fb21dee4b4b984e1'
0.00078 : SELECT * FROM `imagestore` WHERE `image_id`='f28920967e67ec815ecd199103b20981'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='f28920967e67ec815ecd199103b20981'
0.00064 : SELECT * FROM `imagestore` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1'
0.00078 : SELECT * FROM `imagestore` WHERE `image_id`='3efc6166cd6594b973ed15e92246bbd1'
0.00060 : SELECT * FROM `imagestore` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61'
0.00080 : SELECT * FROM `imagestore` WHERE `image_id`='f8f7e45512af7d16ccda5dd0d129db61'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1'
0.00068 : SELECT * FROM `imagestore` WHERE `image_id`='8551ab08aead3c03a61399fe38d7ecd1'
0.00064 : SELECT * FROM `imagestore` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91'
0.00069 : SELECT * FROM `imagestore` WHERE `image_id`='13483d4775feaf50e672ba2cb4027f91'
0.00071 : SELECT * FROM `imagestore` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981'
0.00097 : SELECT * FROM `imagestore` WHERE `image_id`='515fcef91c95a3ffb116aa5d2e937981'
0.00209 : SELECT * FROM `imagestore` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041'
0.00078 : SELECT * FROM `imagestore` WHERE `image_id`='12b4d844f55641883eb72e2ea56f7041'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401'
0.00088 : SELECT * FROM `imagestore` WHERE `image_id`='1c7ad04593ff1e6c653225a4dc3d9401'
0.00062 : SELECT * FROM `imagestore` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51'
0.00063 : SELECT * FROM `imagestore` WHERE `image_id`='84ad044a5f66cda343f073bce31dfa51'
0.00094 : SELECT * FROM `imagestore` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11'
0.00070 : SELECT * FROM `imagestore` WHERE `image_id`='6dbf74e5c11a8f4dc55ac03b0f791f11'
0.00129 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00085 : SELECT * FROM `imagestore` WHERE `image_id`='7a1537b2184a6900085d545234fa7bc1'
0.00097 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00096 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00108 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' 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.00076 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00079 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00055 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('203', '1643', '473', '153', '833', '2063', '653', '123')
0.00083 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00091 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1573', '1413', '653', '123', '1153', '1773')
0.00063 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00060 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00109 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00057 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('153', '833', '2063')
0.00084 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158180' AND `hotel_tag`.`strap` IS NOT NULL
0.00072 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='158180'
0.00086 : SELECT name FROM `shortlist_name` WHERE `slid`='ede3fd4884205af5'

Shiroiya Hotel

Hotel Zimmer

Empfohlen für

Einrichtungen

Aktivitäten

Karte & Standort

Was ist in der Nähe

Haben Sie Fragen?

Shiroiya Hotel

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Any Questions?