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

Gasthaus Marie

icon inn
icon inn © Tirol Werbung

The history of the inn Die Marie dates back to 1895. Stop by for Tirolean and Austrian delicacies in a welcoming rustic atmosphere. In good weather, find a seat on the large sun terrace with the children’s playground and the fallow deer enclosure within eyeshot.

more
less

Infrastructure on site

Fountain at the Schanzkapelle
to resources

opening hours

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

Alexander Höllwart
Achenwald 600
6215 Achenkirch am Achensee
+43 (5246) 20216
https://www.gasthausmarie.at

Infrastructure on site

Fountain at the Schanzkapelle
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist