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` <= 1786468080) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786468080))))) 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 => '115' (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)
Achensee Stüberl | Holiday Region Achensee
Accommodations
Experiences

Achensee Stüberl

The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach.
The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach. © Achensee Tourismus
The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach.
Beach Achensee North in Achenkirch © Achensee Tourismus
The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach.
Achensee Stüberl © Alpen Caravan Park Achensee
The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach.
Bar in the Achensee Stüberl © Alpen Caravan Park Achensee
The Alpen Caravan Park Achensee in Achenkirch – on the right, the large adventure playground by the lakeside beach.
on the left in the picture the Alpen Caravan Park Achensee in Achenkirch © Achensee Tourismus

Enjoy well-deserved rest and refreshments on the sun terrace and soak in panoramic views of Lake Achensee and its surrounding mountains. From the conservatory, watch your children letting off some steam on the water playground. There is also an indoor play area which is open to the restaurant's patrons.

In winter, the restaurant of the Alpen Caravan Park has a cosy sitting area by the stove.

more
less

Infrastructure on site

Sixen - Liegewiese West
to resources

opening hours

open until 22:30
Next 7 days
Tuesday
11.08.2026
10:00 - 22:30
Wednesday
12.08.2026
10:00 - 22:30
Thursday
13.08.2026
10:00 - 22:30
Friday
14.08.2026
10:00 - 22:30
Saturday
15.08.2026
10:00 - 22:30
Sunday
16.08.2026
10:00 - 22:30
Monday
17.08.2026
10:00 - 22:30
more less
Tuesday
18.08.2026
10:00 - 22:30
Wednesday
19.08.2026
10:00 - 22:30
Thursday
20.08.2026
10:00 - 22:30
Friday
21.08.2026
10:00 - 22:30
Saturday
22.08.2026
10:00 - 22:30
Sunday
23.08.2026
10:00 - 22:30
Monday
24.08.2026
10:00 - 22:30
now open
Show on map

Thomas Brunner
Sixenstraße 17
6215 Achenkirch am Achensee
+43 (5246) 6239
https://www.camping-achensee.com/camping-alpen-kinder.html

Infrastructure on site

Sixen - Liegewiese West
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist