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` <= 1780781100) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780781100))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '107' (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)
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 07/06/2026 at 09:00
Next 7 days
Saturday
06.06.2026
09:00 - 19:00
Sunday
07.06.2026
09:00 - 19:00
Monday
08.06.2026
09:00 - 19:00
Tuesday
09.06.2026
09:00 - 19:00
Wednesday
10.06.2026
09:00 - 19:00
Thursday
11.06.2026
09:00 - 19:00
Friday
12.06.2026
09:00 - 19:00
more less
Saturday
13.06.2026
09:00 - 19:00
Sunday
14.06.2026
09:00 - 19:00
Monday
15.06.2026
09:00 - 19:00
Tuesday
16.06.2026
09:00 - 19:00
Wednesday
17.06.2026
09:00 - 19:00
Thursday
18.06.2026
09:00 - 19:00
Friday
19.06.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