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` <= 1786468140) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786468140))))) 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)
FAMILY-Eldorado - Atoll Achensee | Holiday Region Achensee

FAMILY-Eldorado - Atoll Achensee

Right next to the Atoll Achensee in the FAMILY eldorado, the adventure ship St. Benedikt is a popular attraction for young visitors. After cruising on Lake Achensee for almost 60 years, the 31-metre-long ship was taken out of service and converted into an outdoor play paradise. Do your children love playing pirates? There is a play tower, suspension bridge, bird’s nest tree and climbing net for young adventurers to explore. In addition, a low ropes course, swing set, seesaw and flying fox offer plenty of opportunities for kids to let off some steam. The XXL sandbox and the open and tube slides will keep smaller children entertained.

more
less

Infrastructure on site

SEE-Bad - Atoll Achensee
Atoll Achensee
Lagoon - Atoll Achensee
BEACH-Bar Atoll Achensee
SNACK-Bar Atoll Achensee

opening hours

opens on 12/08/2026 at 09:00
Next 7 days
Tuesday
11.08.2026
09:00 - 19:00
Wednesday
12.08.2026
09:00 - 19:00
Thursday
13.08.2026
09:00 - 19:00
Friday
14.08.2026
09:00 - 19:00
Saturday
15.08.2026
09:00 - 19:00
Sunday
16.08.2026
09:00 - 19:00
Monday
17.08.2026
09:00 - 19:00
more less
Tuesday
18.08.2026
09:00 - 19:00
Wednesday
19.08.2026
09:00 - 19:00
Thursday
20.08.2026
09:00 - 19:00
Friday
21.08.2026
09:00 - 19:00
Saturday
22.08.2026
09:00 - 19:00
Sunday
23.08.2026
09:00 - 19:00
Monday
24.08.2026
09:00 - 19:00
closed today

Atoll Achensee

Infrastructure on site

SEE-Bad - Atoll Achensee
Atoll Achensee
Lagoon - Atoll Achensee
BEACH-Bar Atoll Achensee
SNACK-Bar Atoll Achensee
TVB Achensee KI Assist