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` <= 1780769460) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780769460))))) ORDER BY RAND() ASC LIMIT 10
Extbase Variable Dump
array(11 items)
   dcValue1 => array(3 items)
      0 => '70' (2 chars)
      1 => '114' (3 chars)
      2 => '115' (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)
Seehotel Einwaller | Holiday Region Achensee

Seehotel Einwaller

Have you ever tried the homemade ice creams? Feast on the various snacks, homemade pizzas and cake specialities and treat yourself to a cosy drink -always with a direct and unrestricted view of the crystal-clear lake, of course. In the evening, the à la carte restaurant serves a fine selection of varied dishes.

In order to continue to offer all guests the ideal moment of enjoyment away from the hustle and bustle, the hotel asks for table reservations.

Info: Breakfast 08:00–11:00 with reservation | Afternoon coffee, cakes & light dishes until 17:00 | From 18:00 à la carte with reservation

more
less

opening hours

Closing soon
Next 7 days
Saturday
06.06.2026
08:00 - 22:00
Sunday
07.06.2026
08:00 - 22:00
Monday
08.06.2026
08:00 - 22:00
Tuesday
09.06.2026
08:00 - 22:00
Wednesday
10.06.2026
closed
Thursday
11.06.2026
08:00 - 22:00
Friday
12.06.2026
08:00 - 22:00
more less
Saturday
13.06.2026
08:00 - 22:00
Sunday
14.06.2026
08:00 - 22:00
Monday
15.06.2026
08:00 - 22:00
Tuesday
16.06.2026
08:00 - 22:00
Wednesday
17.06.2026
closed
Thursday
18.06.2026
08:00 - 22:00
Friday
19.06.2026
08:00 - 22:00
now open

Familie Carina und Christian Angerer
Seepromenade 15
6213 Pertisau am Achensee
TVB Achensee KI Assist