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` <= 1791588720) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791588720))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '119' (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)
Zöhreralm | Holiday Region Achensee
Accommodations
Experiences

Zöhreralm

Zöhreralm in Achenkirch, situated at 1,334 metres above sea level
Zöhreralm in Achenkirch, situated at 1,334 metres above sea level © Achensee Tourismus
Zöhreralm in Achenkirch, situated at 1,334 metres above sea level
The Zöhreralm, situated at 1,334 metres, is beautifully located and offers wide views of the Karwendel mountains, the Bavarian foothills, and Achenkirch. © Achensee Tourismus

Hiking tours to the Unnutz lead past the Zöhreralm at an elevation of 1,334 metres above sea level. Beautifully situated, the mountain hut affords gorgeous views of the opposite Karwendel mountains, the Bavarian foothills of the Alps, and Achenkirch. Innkeeper Hannes Gruber serves up drinks and snacks with produce from the hotel's own farm.

more
less

Infrastructure on site

Achenkirch - Zöhreralm - Adlerhorst - Achenkirch
to resources
Achenkirch - Zöhreralm - Hochunnutz - Vorderunnutz - Achenkirch
to resources
4033 Zöhreralm
to resources

opening hours

opens at 10:00
Next 7 days
Saturday
10.10.2026
10:00 - 17:00
Sunday
11.10.2026
10:00 - 17:00
Monday
12.10.2026
closed
Tuesday
13.10.2026
closed
Wednesday
14.10.2026
closed
Thursday
15.10.2026
10:00 - 17:00
Friday
16.10.2026
10:00 - 17:00
more less
Saturday
17.10.2026
10:00 - 17:00
Sunday
18.10.2026
10:00 - 17:00
Monday
19.10.2026
closed
Tuesday
20.10.2026
closed
Wednesday
21.10.2026
closed
Thursday
22.10.2026
10:00 - 17:00
Friday
23.10.2026
10:00 - 17:00
open today
Show on map

Hannes Gruber
Am Weg zum Unnutz
6215 Achenkirch am Achensee
+43 (664) 5401687
https://www.posthotel.at/erwachsenenhotel/zoehreralm

Infrastructure on site

Achenkirch - Zöhreralm - Adlerhorst - Achenkirch
to resources
Achenkirch - Zöhreralm - Hochunnutz - Vorderunnutz - Achenkirch
to resources
4033 Zöhreralm
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist