Offers of Skiing Port Ainé
1 prices to book or gift of Skiing Port Ainé
1 offers
Best Skiing Deals in Port Ainé
-
Introduction to skiing in the Pyrenees 2 hours
Espot, Lleidafrom 28€ price/personHaven't you started snow sports yet? Do not wait any longer, the season has already begun and that is why we offer you these activities on the snow slopes in the Catalan station of Port Ainé, in...
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 (3033)
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 = 13
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC
All the Skiing companies in Port Ainé
Espot
from 26€
Arties
from 95€
Llavorsi
from 47€
La Coma
from 55€
Urbanització Vaqueira beret (Vaqueira be
from 55€
Vielha/viella
from 50€
Frequently asked questions about Skiing in Port Ainé
-
It can be bought or gifted from 19€. There are 55 companies and you have 1 offers to choose the one you like best.
-
The best-selling offers are:
-
The main locations are:
-
The related activities that you can give away are:
- Snowboarding Port Ainé
