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` <= 1791588720) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1791588720))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(1 item)
      0 => '32' (2 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)
Familienresort Buchau | Holiday Region Achensee
Accommodations
Experiences

Familienresort Buchau

the new, bright and modern indoor riding arena at the Familienresort Buchau
the new, bright and modern indoor riding arena at the Familienresort Buchau © Familienresort Buchau
the new, bright and modern indoor riding arena at the Familienresort Buchau
Horse riding at the Familienresort Buchau – ponies, riding lessons and rides out, available all year round in the indoor riding arena. © Familienresort Buchau
the new, bright and modern indoor riding arena at the Familienresort Buchau
Pony hire, riding lessons and guided rides available at the Familienresort Buchau. © Familienresort Buchau

The hotel Familienresort Buchau offers individual and group riding lessons, pony hire, lunge lessons, guided rides, as well as tiny tots riding lessons for children from 3 to 5 years old. The newly built, bright and modern indoor riding arena complements the riding facilities.

more
less

Infrastructure on site

Kinderhotel Buchau GmbH
to resources

opening hours

open all day
Next 7 days
Saturday
10.10.2026
00:00 - 00:00
Sunday
11.10.2026
00:00 - 00:00
Monday
12.10.2026
00:00 - 00:00
Tuesday
13.10.2026
00:00 - 00:00
Wednesday
14.10.2026
00:00 - 00:00
Thursday
15.10.2026
00:00 - 00:00
Friday
16.10.2026
00:00 - 00:00
more less
Saturday
17.10.2026
00:00 - 00:00
Sunday
18.10.2026
00:00 - 00:00
Monday
19.10.2026
00:00 - 00:00
Tuesday
20.10.2026
00:00 - 00:00
Wednesday
21.10.2026
00:00 - 00:00
Thursday
22.10.2026
00:00 - 00:00
Friday
23.10.2026
00:00 - 00:00
open all day

Please contact the provider directly to arrange an appointment.

Show on map

Familienresort Buchau
Buchauer Straße 3
6212 Maurach am Achensee
+43 (5243) 5210-772
info@buchau.com
https://www.buchau.com/reithotel-oesterreich

Infrastructure on site

Kinderhotel Buchau GmbH
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist