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

Familienparadies Sporthotel Achensee

Soothing relaxation massage with warm stones – gentle strokes and deep warmth for pure calm and relaxation.
Soothing relaxation massage with warm stones – gentle strokes and deep warmth for pure calm and relaxation. © Sporthotel Achensee
Soothing relaxation massage with warm stones – gentle strokes and deep warmth for pure calm and relaxation.
Experience wellness treatments at the Sporthotel Achensee © Familienparadies Sporthotel Achensee
Soothing relaxation massage with warm stones – gentle strokes and deep warmth for pure calm and relaxation.
relaxing massage with hot stones © Sporthotel Achensee
Soothing relaxation massage with warm stones – gentle strokes and deep warmth for pure calm and relaxation.
the Sporthotel Achensee offers individual massage treatments © Christian Vorhofer

Outside guests can book individual treatments at the Sporthotel Achensee Wellness and Spa.

more
less

opening hours

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

Guests are kindly asked to make an advance appointment for spa treatments.

Show on map

Familie Brigitte Hlebaina
Christlumsiedlung 114
6215 Achenkirch am Achensee
+43 (5246) 6561 109 - Rezeption
info@sporthotel-achensee.com
https://www.sporthotel-achensee.com
EN

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

Open cookie settings
TVB Achensee KI Assist