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 => '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

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

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