Boat rental station Buchau
The rental offers pedal boats and SUP boards. The Buchau boat rental is run by the beach bar opposite.
Infrastructure on site
opening hours
Boats can be hired until 17:00 at the latest.
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` <= 1780770360) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780770360))))) ORDER BY RAND() ASC LIMIT 10
array(11 items) dcValue1 => array(1 item) 0 => '137' (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)
The rental offers pedal boats and SUP boards. The Buchau boat rental is run by the beach bar opposite.
Boats can be hired until 17:00 at the latest.