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(2 items)
      0 => '115' (3 chars)
      1 => '118' (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)
Strandcafé Pertisau | Holiday Region Achensee

Strandcafé Pertisau

The Strandcafé is located in the lakeside beach area of Pertisau, directly by the lake and just a short walk from the village centre. The spacious terrace offers views of Lake Achensee, with ice cream, coffee, light meals and take-away snacks on offer. Open during the bathing season from around mid-May until the first Sunday in September, daily from 10:00 to 18:00, weather permitting.
Note: Dogs are welcome in the restaurant and terrace area (on a lead), but are not allowed on the sunbathing lawn or in the swimming area.

more
less

Infrastructure on site

Beach Pertisau
Achenseeschifffahrt

Please note: Opening hours at Strandcafé Pertisau depend on weather conditions.

opening hours

Opening hours in the early season until the end of June 2026 depend on the weather and may vary. During the main season, from July to the end of September, open daily from 10:00 to 18:00.

Martin Hauser
Seepromenade 36
6213 Pertisau am Achensee

Infrastructure on site

Beach Pertisau
Achenseeschifffahrt
TVB Achensee KI Assist