Offers of Ski Resorts Astún

Offers of Ski Resorts Astún

2 prices to book or gift of Ski Resorts Astún

Average price
122€
Based on
2 offers

Best Ski Resorts Deals in Astún

  • 4

    Accommodation 2 nights with breakfast + Astún Ski Pass
    from 123€ price/person

    Take advantage of this exclusive offer and come to the ski resort of Astún to spend unforgettable moments. You can practice the snow sport that you like, and without having to follow the level of...

    2-100 max Yes Yes
  • 3

    Astún Getaway Aragonese Pyrenees December Bridge
    from 120€ price/person

    Enjoy a spectacular getaway to Astún station, to get the most out of the December bridge. We offer you accommodation and ski passes. In addition, if you need extras, you can hire them directly with...

    6-6 max Yes
SELECT  IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS)  AS NEMPRESAS, N_OFERTAS AS NumOfertas,  N_EMPRESAS as NumEmpresas,
                        PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
                        REI.DESC_REGION,  REI.URL AS URL_REGION,
                        '' AS ID_GRUPO,   SECI.DESC_SECTOR AS DESC_SECTOR, SECI.URL AS URL_SECTOR 
                    FROM
                         LO_POBLACION_ES_STATS PS
                         INNER JOIN LO_POBLACION_ES PO ON PS.ID_POBLACION = PO.ID_POBLACION AND  PO.IDIOMA = 'en'  AND PO.ID_REGION IN (3028)
                        INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION AND REI.IDIOMA = 'en'
                        INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_SECTOR AND SECI.FK_ID_IDIOMA_SI18N = 'en'
                        
                    WHERE (PS.N_OFERTAS > 0 ) 
                          AND PS.ID_SECTOR = 53
                     GROUP BY PS.ID_POBLACION
                    ORDER BY N_OFERTAS  DESC

All the Ski Resorts companies in Astún

Frequently asked questions about Ski Resorts in Astún

  • It can be bought or gifted from 120€. There are 13 companies and you have 2 offers to choose the one you like best.
  • The main locations are:
  • The related activities that you can give away are:
    • Skiing Astún
    • Snowboarding Astún
    • Snowmobiles Astún
    • Snowshoeing Astún
    • Dog Sledding Astún
SELECT  IF(ISNULL(N_OFERTAS),0,N_OFERTAS)+IF(ISNULL(N_EMPRESAS),0,N_EMPRESAS)  AS NEMPRESAS, N_OFERTAS AS NumOfertas,  N_EMPRESAS as NumEmpresas,
                        PO.ID_POBLACION, PO.DESC_POBLACION, PO.URL_POBLACION AS URL_POBLACION, PO.ID_REGION,
                        REI.DESC_REGION,  REI.URL AS URL_REGION,
                        '' AS ID_GRUPO,   SECI.DESC_SECTOR AS DESC_SECTOR, SECI.URL AS URL_SECTOR 
                    FROM
                         LO_POBLACION_ES_STATS PS
                         INNER JOIN LO_POBLACION_ES PO ON PS.ID_POBLACION = PO.ID_POBLACION AND  PO.IDIOMA = 'en'  AND PO.ID_REGION IN (3028)
                        INNER JOIN LO_REGION_I18N REI ON REI.ID_REGION=PO.ID_REGION AND REI.IDIOMA = 'en'
                        INNER JOIN LO_SECTORES_I18N SECI ON SECI.ID_SECTOR = PS.ID_SECTOR AND SECI.FK_ID_IDIOMA_SI18N = 'en'
                        
                    WHERE (PS.N_OFERTAS > 0 ) 
                          AND PS.ID_SECTOR = 53
                     GROUP BY PS.ID_POBLACION
                    ORDER BY N_OFERTAS  DESC

prices Ski Resorts in Astún by location:

SUBSCRIBE ME