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` <= 1791588600) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791588600))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(2 items)
      0 => '43' (2 chars)
      1 => '461' (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)
Water sports centre Achensee - Buchau | Holiday Region Achensee

Water sports centre Achensee - Buchau

The water sports centre in Maurach offers surfing lessons and kayak, canoe, SUP board and windsurf board rental right by the lakeshore in Buchau. Sun umbrellas and loungers are also available for rental. The Beach Bar Buchau with boat rental is located nearby. The water sports centre, bar and rental service are operated by the nearby Familienresort Buchau.

View more information at https://www.buchau.com/en/seewiese-beach-water-sports

more
less

Infrastructure on site

Boat rental station Buchau
Familienresort Buchau
Beach Bar Buchau
Kinderhotel Buchau GmbH

opening hours

Opening hours of the water sports centre depend on weather conditions. Please call if needed.

Infrastructure on site

Boat rental station Buchau
Familienresort Buchau
Beach Bar Buchau
Kinderhotel Buchau GmbH
TVB Achensee KI Assist