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` <= 1786470840) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786470840))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '32' (2 chars)
      1 => '91' (2 chars)
      2 => '469' (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)
Lipizzaner farm - Posthotel Achenkirch | Holiday Region Achensee
Accommodations
Experiences

Lipizzaner farm - Posthotel Achenkirch

Horse-drawn carriage ride below the Annakircherl in Achenkirch
Lipizzaner winter ride in Achenkirch, with the Annakircherl chapel in the background © Posthotel Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch © Posthotel Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch
horse-drawn carriage ride in Achenkirch - in the background the chapel Annakircherl © Posthotel Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch
in the riding stables of the Posthotel Achenkirch you can ride noble Lipizzaners © Posthotel Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch
woman rider on a Lipizzaner during a horseback ride in Achenkirch © Posthotel Achenkirch
Horse-drawn carriage ride below the Annakircherl in Achenkirch
Riding on noble Lipizzaners - this is possible in the riding stables of the Posthotel Achenkirch © Posthotel Achenkirch

The Posthotel Achenkirch offers a variety of equestrian activities, including riding lessons, lunge lessons, guided rides, as well as horse carriage and sleigh rides. Lessons are provided in English style in the indoor and outdoor arenas. There are also stables available for hire. The Posthotel is part of the largest private Lipizzaner stud farm in Europe.

more
less

Infrastructure on site

Posthotel Achenkirch
to resources

opening hours

open all day
Next 7 days
Tuesday
11.08.2026
00:00 - 00:00
Wednesday
12.08.2026
00:00 - 00:00
Thursday
13.08.2026
00:00 - 00:00
Friday
14.08.2026
00:00 - 00:00
Saturday
15.08.2026
00:00 - 00:00
Sunday
16.08.2026
00:00 - 00:00
Monday
17.08.2026
00:00 - 00:00
more less
Tuesday
18.08.2026
00:00 - 00:00
Wednesday
19.08.2026
00:00 - 00:00
Thursday
20.08.2026
00:00 - 00:00
Friday
21.08.2026
00:00 - 00:00
Saturday
22.08.2026
00:00 - 00:00
Sunday
23.08.2026
00:00 - 00:00
Monday
24.08.2026
00:00 - 00:00
open all day

Reservations at the riding stables are required.

Show on map

Posthotel Achenkirch
Obere Dorfstraße 382
6215 Achenkirch am Achensee
+43 (664) 2559861
lipizzaner@posthotel.at
https://www.posthotel.at/aktivurlaub/reiten

Infrastructure on site

Posthotel Achenkirch
to resources
EN

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

Open cookie settings
TVB Achensee KI Assist