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` <= 1786473000) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786473000))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '107' (3 chars)
      1 => '1311' (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)
Playground Achenseehof | Holiday Region Achensee
Accommodations
Experiences

Playground Achenseehof

playground Achenseehof
playground Achenseehof © Achensee Tourismus
playground Achenseehof
playground Achenseehof © Achensee Tourismus
playground Achenseehof
playground directly by the lake near the Achenseehof area in Achenkirch © Achensee Tourismus
playground Achenseehof
Spielplatz Achenseehof © Achensee Tourismus

Achenseehof Playground is right by Lake Achensee at Achenseehof beach, only a short walk from the Achenseehof boat landing. The large lawn and the lakeside location make it a popular place for families. During the summer months, food trucks offer snacks and drinks in good weather. Toilets are available.

more
less

Infrastructure on site

Beach Achenseehof
to resources
Seehof WEST
to resources
Shipping pier Achenseehof
to resources
Food trucks beach Achenseehof
to resources
Show on map

Spielplatz Achenseehoff
Seehof 4
6215 Achenkirch am Achensee
+43 (5243) 5253
info@achenseeschifffahrt.at
https://www.achenseeschifffahrt.at

Infrastructure on site

Beach Achenseehof
to resources
Seehof WEST
to resources
Shipping pier Achenseehof
to resources
Food trucks beach Achenseehof
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist