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` <= 1776427920) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1776427920))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(4 items)
      0 => '70' (2 chars)
      1 => '114' (3 chars)
      2 => '116' (3 chars)
      3 => '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)
Fischerwirt am Achensee | Holiday Region Achensee
Accommodations
Experiences

Fischerwirt am Achensee

one of the most rustic parlours in the Fischerwirt am Achensee
Fischerwirt - terrace next to the entrance © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
The Fischerwirt am Achensee offers a spacious patio. © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
Winter view of the Fischerwirt am Achensee © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
Veranda parlour - this room offers space for approx. 55 people. © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
Fischerwirt am Achensee - Restaurant - flooded with light from large windows © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
The wine bar used to be used to store drinks and goods when there were no fridges. © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
The Fischerwirt menu includes various game dishes from local forests. © Fischerwirt am Achensee
one of the most rustic parlours in the Fischerwirt am Achensee
The Jagerei - event location from 20 people, for celebrations of all kinds - barrier-free access included.. © Fischerwirt am Achensee

The Fischerwirt am Achensee has been a popular family-run inn since 1885, combining tradition with warm hospitality. Situated at the northern tip of Lake Achensee, it offers spacious outdoor seating, cozy parlours, and traditional Tirolean cuisine. Whether you’re unwinding after a hike, enjoying a refreshing snack, or simply soaking up the charming atmosphere, it’s the perfect place to relax. Ideal for celebrating special occasions, the Fischerwirt creates unforgettable memories with bespoke group packages for events such as christenings, communions, and birthdays.

 


more
less

Infrastructure on site

Fischerwirt
to resources

opening hours

open until 23:30
Next 7 days
Friday
17.04.2026
10:00 - 23:30
Saturday
18.04.2026
10:00 - 23:30
Sunday
19.04.2026
10:00 - 23:30
Monday
20.04.2026
10:00 - 23:30
Tuesday
21.04.2026
10:00 - 23:30
Wednesday
22.04.2026
10:00 - 23:30
Thursday
23.04.2026
10:00 - 23:30
more less
Friday
24.04.2026
10:00 - 23:30
Saturday
25.04.2026
10:00 - 23:30
Sunday
26.04.2026
10:00 - 23:30
Monday
27.04.2026
10:00 - 23:30
Tuesday
28.04.2026
10:00 - 23:30
Wednesday
29.04.2026
10:00 - 23:30
Thursday
30.04.2026
10:00 - 23:30
now open
Show on map

Familie Kirchberger
Seestraße 15
6215 Achenkirch am Achensee
+43 (5246) 6258
https://www.fischerwirt.tirol

Infrastructure on site

Fischerwirt
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist