SELECT DISTINCT r.uid, r.foreign_id, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.difficulty')) AS metadata_string, JSON_UNQUOTE(JSON_EXTRACT(r.json_data, '$.metadata.route_length')) AS metadata_string FROM `tx_webxgsmap_domain_model_resource` `r` INNER JOIN `tx_webxgsmap_resource_category_mm` `mm_category` ON `r`.`uid` = `mm_category`.`uid_local` WHERE (`mm_category`.`uid_foreign` IN (:dcValue1)) AND (`r`.`object_type` <> :dcValue2) AND (`r`.`object_type` <> :dcValue3) AND (`r`.`object_type` <> :dcValue4) AND (`r`.`object_type` <> :dcValue5) AND (`r`.`object_type` <> :dcValue6) AND (`r`.`object_type` <> :dcValue7) AND (`r`.`object_type` <> :dcValue8) AND (`r`.`object_type` <> :dcValue9) AND (`r`.`object_type` <> :dcValue10) AND (`r`.`sys_language_uid` = :dcValue11) AND (((`r`.`deleted` = 0) AND (`r`.`hidden` = 0) AND (`r`.`starttime` <= 1780773120) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780773120))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '114' (3 chars)
      1 => '115' (3 chars)
      2 => '121' (3 chars)
   dcValue2 => 'sportclimbing_2018_route' (24 chars)
   dcValue3 => 'sportclimbing_2018_sector' (25 chars)
   dcValue4 => 'sportclimbing_2018' (18 chars)
   dcValue5 => 'gdi_piste' (9 chars)
   dcValue6 => 'gdi_lift' (8 chars)
   dcValue7 => 'climbing_route_2018_route' (25 chars)
   dcValue8 => 'climbing_route_2018_sector' (26 chars)
   dcValue9 => 'event' (5 chars)
   dcValue10 => 'event_phoenix' (13 chars)
   dcValue11 => 1 (integer)
Seehotel St. Hubertus | Holiday Region Achensee
Accommodations
Experiences

Seehotel St. Hubertus

Seehotel St. Hubertus - the products come from Tirolean organic farmers
Seehotel St. Hubertus - between Maurach and Pertisau - located next to the lake © Seehotel St. Hubertus
Seehotel St. Hubertus - the products come from Tirolean organic farmers
Seehotel St. Hubertus - the products come from Tirolean organic farmers © Adobe Stock
Seehotel St. Hubertus - the products come from Tirolean organic farmers
Seehotel St. Hubertus - in the Tirolean parlour © Seehotel St. Hubertus

Restaurant Hubertus is known for its Tirolean homestyle cooking and game specialities. The culinary team prepares innovative dishes, using natural, regional ingredients from Tirolean organic farmers. Expect tasty changing specials and seasonally inspired dishes! 


Fish and game specialities

Thanks to the hotel's own hunters and fishermen, the menu features excellent seasonal fish and game specialities from the region. Enjoy your meal in the cosy Tirolean parlour or on the spacious sun terrace in summer.

more
less

opening hours

Closing soon
Next 7 days
Saturday
06.06.2026
08:00 - 23:00
Sunday
07.06.2026
08:00 - 23:00
Monday
08.06.2026
08:00 - 23:00
Tuesday
09.06.2026
08:00 - 23:00
Wednesday
10.06.2026
08:00 - 23:00
Thursday
11.06.2026
08:00 - 23:00
Friday
12.06.2026
08:00 - 23:00
more less
Saturday
13.06.2026
08:00 - 23:00
Sunday
14.06.2026
08:00 - 23:00
Monday
15.06.2026
08:00 - 23:00
Tuesday
16.06.2026
08:00 - 23:00
Wednesday
17.06.2026
08:00 - 23:00
Thursday
18.06.2026
08:00 - 23:00
Friday
19.06.2026
08:00 - 23:00
now open
Show on map

Familie Huber
Seepromenade 2
6213 Pertisau am Achensee
+43 (5243) 5233
https://www.hubertus-achensee.at
EN

The item cannot be displayed. To see the item, accept the marketing cookies.

Open cookie settings
TVB Achensee KI Assist