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` <= 1780765440) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780765440))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '56' (2 chars)
      1 => '103' (3 chars)
      2 => '111' (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)
Achenseebahn | Holiday Region Achensee

Achenseebahn

If that's not endurance: Since 1889, the Achensee steam cog railway has been working its way up from Jenbach in the Inn Valley to Lake Achensee. Europe's oldest steam cog railway climbs 440 meters in altitude over a distance of just under seven kilometers. 

Just a few minutes after departing from Jenbach station, Tirol's best-known nostalgic train has to master its greatest feat of strength: an incline of 16 percent. Hissing and snorting, it then takes guests up to Lake Achensee, passing lush meadows and shady forests. 

You can also look forward to magnificent views of the Inn Valley and the surrounding mountains as the wind blows around your nose. 

Having arrived at Lake Achensee, the old lady first needs a break. Passengers, on the other hand, can continue exploring right away and take a spin on the Achensee Shipping Company.

more
less

Infrastructure on site

Felderer Stadl
Kirchenwirt
Peter's Grill
ÖBB Bahnhof Jenbach P&R
Park & Ride Jenbach Railway Station (Parking Garage)

opening hours

opens on 07/06/2026 at 11:00
Next 7 days
Saturday
06.06.2026
11:00 - 16:35
Sunday
07.06.2026
11:00 - 16:35
Monday
08.06.2026
11:00 - 16:35
Tuesday
09.06.2026
11:00 - 16:35
Wednesday
10.06.2026
11:00 - 16:35
Thursday
11.06.2026
11:00 - 16:35
Friday
12.06.2026
11:00 - 16:35
more less
Saturday
13.06.2026
11:00 - 16:35
Sunday
14.06.2026
11:00 - 16:35
Monday
15.06.2026
11:00 - 16:35
Tuesday
16.06.2026
11:00 - 16:35
Wednesday
17.06.2026
11:00 - 16:35
Thursday
18.06.2026
11:00 - 16:35
Friday
19.06.2026
11:00 - 16:35
closed today

Achenseebahn Infrastruktur- und Betriebs-GmbH

Infrastructure on site

Felderer Stadl
Kirchenwirt
Peter's Grill
ÖBB Bahnhof Jenbach P&R
Park & Ride Jenbach Railway Station (Parking Garage)
TVB Achensee KI Assist