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` <= 1786468020) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1786468020))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(4 items)
      0 => '56' (2 chars)
      1 => '71' (2 chars)
      2 => '103' (3 chars)
      3 => '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 12/08/2026 at 10:06
Next 7 days
Tuesday
11.08.2026
10:06 - 16:45
Wednesday
12.08.2026
10:06 - 16:45
Thursday
13.08.2026
10:06 - 16:45
Friday
14.08.2026
10:06 - 16:45
Saturday
15.08.2026
10:06 - 16:45
Sunday
16.08.2026
10:06 - 16:45
Monday
17.08.2026
10:06 - 16:45
more less
Tuesday
18.08.2026
10:06 - 16:45
Wednesday
19.08.2026
10:06 - 16:45
Thursday
20.08.2026
10:06 - 16:45
Friday
21.08.2026
10:06 - 16:45
Saturday
22.08.2026
10:06 - 16:45
Sunday
23.08.2026
10:06 - 16:45
Monday
24.08.2026
10:06 - 16:45
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