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` <= 1780773120) AND (((`r`.`endtime` = 0) OR (`r`.`endtime` > 1780773120))))) ORDER BY RAND() ASC LIMIT 10

Extbase Variable Dump

array(11 items)
   dcValue1 => array(2 items)
      0 => '67' (2 chars)
      1 => '141' (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)

Alphaus Aparthotel | Holiday Region Achensee

Alphaus Aparthotel

Apart Garni Alpenperle in der Dämmerung

Apart Garni Alpenperle in der Dämmerung ©

Apart Garni Alpenperle in der Dämmerung

weitere Sommer Hausansicht ©

Apart Garni Alpenperle in der Dämmerung

Relax Lounge © Bildlmacher

Apart Garni Alpenperle in der Dämmerung

Alphaus Rezeption © Bildlmacher

Apart Garni Alpenperle in der Dämmerung

Alphaus Rezeption © Bildlmacher

Apart Garni Alpenperle in der Dämmerung

Alphaus Rezeption © Bildlmacher

Apart Garni Alpenperle in der Dämmerung

Ferienwohnung Rubin Wohnzimmer & Essecke © Bildlmacher

Welcome to a 4-star holiday in a beautiful, newly built house that awaits you in an idyllic, quiet, yet central location!

7 apartments for 2-10 pers. and 2 comfort double rooms offer generous space for approx. 30 guests.

The luxurious apartments and the two rooms are well above average and furnished in a high-quality Alpine style.

Your advantages:

* Officially 4-star certified

* SPA with sauna, steam bath, infrared cabin, relaxation area

* Gym and exercise room

Ideal for active vacation:

* Directly at the 18-hole champion golf course (20% green fee discount)

* Over 500km hiking trails, 250km bike routes from the house (bike cellar in the house)

* 150km of winter hiking trails

* 200km of cross-country trails, entry 50m at the house

* 6 (natural) toboggan runs

* 3 nearby family ski areas; Ski lift in Pertisau 200m close or free ski shuttle bus (ski cellar in the house)

more

less

Show on map

Alphaus Aparthotel

Naturparkstraße 39

6213 Pertisau am Achensee

+43 (5243) 20299

+43(676)6047599

info@alpenperlen-achensee.at

www.alpenperle-pertisau.at