Schloss Sonnenburg

Zur Auswahlliste hinzufügen
Karte & Standort

40 Zimmer ab €136 pro Nacht

“Ein luxuriöses und historisches Anwesen mit einer beneidenswerten Lage in den Alpen. Die vierzig Zimmer strahlen den Charme der alten Welt aus und sind dennoch modern eingerichtet. Große Innen- und Außenpools und ein weitläufiges Spa sorgen für absolute Entspannung, während die umliegenden Berge für jede Menge Abenteuer sorgen.”

Einrichtungen

Schwimmbad
Innen- und Außenpools
Ansichten
Parken
Familien-Suiten
Bar
Fahrräder verfügbar
Sauna/Dampfbad
Massage
Bibliothek

Sit-out Terrace
Heilbad
Restaurant
Garten
Fitnessstudio
Kinderfreundlich
Wifi
Spielzimmer

Aktivitäten

Skifahren
Das Haus liegt nur 6 km von den zahlreichen Pisten des Dolomiti Superski entfernt.
Klettern
In den umliegenden Tälern gibt es zahlreiche Klettersteige.
Radfahren
Erkunden Sie die kilometerlangen Radwege mit einem der hoteleigenen Fahrräder.

Segeln
Machen Sie eine malerische Bootsfahrt über den Pragser Wildsee.
Trekking
Begeben Sie sich auf anspruchsvolle Wanderungen durch das Pustertal.

Karte & Standort

Was ist in der Nähe

Weitere Hotels in der Nähe suchen

Hotel Petrus

Gourmet and Boutique Hotel Tanzer

Niedermairhof B&B

Verfügbarkeit prüfen

40 Zimmer ab €136 pro Nacht

Haben Sie Fragen?

Kontakt aufnehmen

Schloss Sonnenburg, Südtirol. Expertenbewertungen und Highlights | The Hotel Guru

The Hotel Guru
Italien
Südtirol
Schloss Sonnenburg

Schloss Sonnenburg

Südtirol, Italien

Zur Auswahlliste hinzufügen
Map & Location

40 Zimmer ab €136 pro Nacht

“A luxurious and historic property boasting an enviable Alpine location. The forty rooms are filled with old world charm yet encompass modern sensibilities. Large indoor and outdoor pools and an expansive spa aid utter relaxation whilst the surrounding mountains provide plenty of adventure. ”

Recommended For

Totale Entspannung
Die alpine Umgebung, das verwöhnende Spa und das fabelhafte Restaurant sorgen für einen sehr entspannten Aufenthalt.
Families
Mit vielen Unterhaltungsmöglichkeiten für Erwachsene und Kinder ist dies der ideale Familienurlaub.
Skifahren
Das Haus liegt nur 6 km von den zahlreichen Pisten des Dolomiti Superski entfernt.
Radfahren
Erkunden Sie die kilometerlangen Radwege mit einem der hoteleigenen Fahrräder.
Segeln
Machen Sie eine malerische Bootsfahrt über den Pragser Wildsee.
Trekking
Begeben Sie sich auf anspruchsvolle Wanderungen durch das Pustertal.
Abgelegene Umgebung
Fernbedienung
Ruhig
Familien-Suiten
Ansichten
Sit-out Terrace

Voller Charakter
Antike
Hügel und Berge
Heilbad
Restaurant
Historisches
Fitnessstudio
Kinderfreundlich
Wellbeing
Traditionell
Luxus
Romantisch

Einrichtungen

Schwimmbad
Innen- und Außenpools
Ansichten
Parken
Familien-Suiten
Bar
Fahrräder verfügbar
Sauna/Dampfbad
Massage
Bibliothek

Sit-out Terrace
Heilbad
Restaurant
Garten
Fitnessstudio
Kinderfreundlich
Wifi
Spielzimmer

Aktivitäten

Skifahren
Das Haus liegt nur 6 km von den zahlreichen Pisten des Dolomiti Superski entfernt.
Klettern
In den umliegenden Tälern gibt es zahlreiche Klettersteige.
Radfahren
Erkunden Sie die kilometerlangen Radwege mit einem der hoteleigenen Fahrräder.

Segeln
Machen Sie eine malerische Bootsfahrt über den Pragser Wildsee.
Trekking
Begeben Sie sich auf anspruchsvolle Wanderungen durch das Pustertal.

Map & Location

What's Nearby

Browse more hotels nearby

Hotel Petrus

Gourmet and Boutique Hotel Tanzer

Niedermairhof B&B

Check Availability

40 Zimmer ab €136 pro Nacht

Any Questions?

Get in touch

Your Shortlist (0)

Init : 2.0980834960938E-5
Dispatch : 0.15475606918335
Output : 0.0018341541290283
Total : 0.15661120414734
Peak memory: 1.8497085571289mb
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.00058 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00048 : SELECT string_id, value FROM `strings_german` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.04865 : SELECT * FROM `hotel` WHERE `handle`='schloss-sonnenburg-south-tyrol' LIMIT 0, 1
0.00308 : SELECT * FROM `imagestore` WHERE `global_id`='128849111813' ORDER BY image_id = "00846adbfb06f011da1ea961e7d6ede1" DESC, position ASC
0.00077 : SELECT * FROM `location` WHERE `location_id`='7133'
0.00070 : SELECT * FROM `location_german` WHERE `location_id`='7133' LIMIT 0, 1
0.00066 : SELECT * FROM `location` WHERE `location_id`='19'
0.00065 : SELECT * FROM `location` WHERE `location_id`='19'
0.00066 : SELECT * FROM `location_german` WHERE `location_id`='19' LIMIT 0, 1
0.00067 : SELECT * FROM `location` WHERE `location_id`='7133'
0.00068 : SELECT * FROM `location_german` WHERE `location_id`='7133' LIMIT 0, 1
0.00063 : SELECT * FROM `location` WHERE `location_id`='19'
0.00061 : SELECT * FROM `location_german` WHERE `location_id`='19' LIMIT 0, 1
0.00061 : SELECT * FROM `review` WHERE (hotel_id='92963' OR hotel2_id='92963' OR hotel3_id='92963') AND is_published=1 AND datetime_published<1715656308 ORDER BY datetime_published DESC LIMIT 0, 1000
0.00044 : SELECT * FROM `external_article` WHERE `hotel_id`='92963' LIMIT 0, 1000
0.01889 : SELECT hotel_id FROM `hotel` WHERE (((ACOS(SIN(46.786074807413 * PI() / 180) * SIN(exact_location_lat * PI() / 180) + COS(46.786074807413 * PI() / 180) * COS(exact_location_lat * PI() / 180) * COS((11.892368911392 - exact_location_lng) * PI() / 180)) * 180 / PI()) * 60 * 1.1515)<5) AND `hotel_id`!='92963' LIMIT 0, 3
0.00092 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('76573', '108783', '138503') LIMIT 0, 1000
0.00061 : SELECT * FROM `hotel_german` WHERE `hotel_id`='92963' LIMIT 0, 1
0.00069 : SELECT hotel_id FROM `shortlist` WHERE `slid`='3ed914f88a4df57c' ORDER BY datetime DESC
0.00076 : SELECT * FROM `imagestore` WHERE `global_id`='128849111813' ORDER BY image_id = "00846adbfb06f011da1ea961e7d6ede1" DESC, position ASC
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1' LIMIT 0, 1
0.00059 : SELECT * FROM `imagestore_german` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521' LIMIT 0, 1
0.00054 : SELECT * FROM `imagestore_german` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611' LIMIT 0, 1
0.00049 : SELECT * FROM `imagestore_german` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581' LIMIT 0, 1
0.00051 : SELECT * FROM `imagestore_german` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41' LIMIT 0, 1
0.00201 : SELECT * FROM `imagestore_german` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11' LIMIT 0, 1
0.00047 : SELECT * FROM `imagestore_german` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1'
0.00040 : SELECT * FROM `imagestore` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1'
0.00042 : SELECT * FROM `imagestore` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621'
0.00041 : SELECT * FROM `imagestore` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581'
0.00114 : SELECT * FROM `imagestore` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21'
0.00067 : SELECT * FROM `imagestore` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41'
0.00103 : SELECT * FROM `imagestore` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791'
0.00040 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00063 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00070 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00061 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00052 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00045 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00047 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1993', '293', '393', '273', '1553', '1963', '1223', '1253', '1383', '1393', '1193', '2123', '2243', '553', '43', '63', '123', '383', '483', '653', '913', '953', '1103', '1163')
0.00062 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00045 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('303', '1193', '1353', '1393', '1413', '1453', '1573', '1613', '1713', '2123', '63', '123', '423', '483', '653', '1153', '1213')
0.00054 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00046 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00059 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00042 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('393', '2313', '273', '1553', '1963')
0.00049 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00044 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00067 : SELECT * FROM `imagestore` WHERE `global_id`='128849111813' ORDER BY image_id = "00846adbfb06f011da1ea961e7d6ede1" DESC, position ASC
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1' LIMIT 0, 1
0.00042 : SELECT * FROM `imagestore_german` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1' LIMIT 0, 1
0.00048 : SELECT * FROM `imagestore_german` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581' LIMIT 0, 1
0.00040 : SELECT * FROM `imagestore_german` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21' LIMIT 0, 1
0.00041 : SELECT * FROM `imagestore_german` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41' LIMIT 0, 1
0.00044 : SELECT * FROM `imagestore_german` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221' LIMIT 0, 1
0.00043 : SELECT * FROM `imagestore_german` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191' LIMIT 0, 1
0.00046 : SELECT * FROM `imagestore_german` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11' LIMIT 0, 1
0.00045 : SELECT * FROM `imagestore_german` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791' LIMIT 0, 1
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00041 : SELECT * FROM `imagestore` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521'
0.00052 : SELECT * FROM `imagestore` WHERE `image_id`='2a856c710c25e32e7e7f5fe6e1502521'
0.00049 : SELECT * FROM `imagestore` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='dda48dd2681b7e9f44534644583f50c1'
0.00141 : SELECT * FROM `imagestore` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621'
0.00050 : SELECT * FROM `imagestore` WHERE `image_id`='104e07a19c7ff6522fc64de86864d621'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='ae27d8a2d5413e32489c817538bef611'
0.00045 : SELECT * FROM `imagestore` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581'
0.00043 : SELECT * FROM `imagestore` WHERE `image_id`='dffdcb9ade3d3d7512c3bc9b7f60d581'
0.00048 : SELECT * FROM `imagestore` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='81a20f51789ea69abed986a7288e6c21'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='2b172bc0aefddacaf7ecf7141fface41'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221'
0.00054 : SELECT * FROM `imagestore` WHERE `image_id`='cce77d2a07b68a64f936fa8fe77a9221'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='52d6bb408e77052307a98ecf3da81781'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191'
0.00042 : SELECT * FROM `imagestore` WHERE `image_id`='164b7c052efde57b7895fb8c270c0191'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11'
0.00047 : SELECT * FROM `imagestore` WHERE `image_id`='626cd9562f48a8aca037203bd9338b11'
0.00044 : SELECT * FROM `imagestore` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='ff3c01266121b8ed27f02fbbc7b9b791'
0.00046 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00051 : SELECT * FROM `imagestore` WHERE `image_id`='00846adbfb06f011da1ea961e7d6ede1'
0.00070 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00068 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00068 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' 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.00064 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00049 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00053 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('1993', '293', '393', '273', '1553', '1963', '1223', '1253', '1383', '1393', '1193', '2123', '2243', '553', '43', '63', '123', '383', '483', '653', '913', '953', '1103', '1163')
0.00068 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `collection`='1' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00052 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('303', '1193', '1353', '1393', '1413', '1453', '1573', '1613', '1713', '2123', '63', '123', '423', '483', '653', '1153', '1213')
0.00054 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00047 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00064 : SELECT tag_id, hotel_tag.score, hotel_tag.strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `collection`='4' ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC
0.00050 : SELECT tag_id, title FROM `tag_german` WHERE `tag_id` IN ('393', '2313', '273', '1553', '1963')
0.00054 : SELECT tag_id, strap,title FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='92963' AND `hotel_tag`.`strap` IS NOT NULL
0.00052 : SELECT tag_id, strap FROM `hotel_tag_german` WHERE `hotel_id`='92963'
0.00079 : SELECT name FROM `shortlist_name` WHERE `slid`='3ed914f88a4df57c'

Schloss Sonnenburg

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?

Schloss Sonnenburg

Hotel Rooms

Recommended For

Einrichtungen

Aktivitäten

Map & Location

What's Nearby

Browse more hotels nearby

Any Questions?