Offers of Snowboarding Port del Comte
2 prices to book or gift of Snowboarding Port del Comte
2 offers
Best Snowboarding Deals in Port del Comte
-
Private snowboard lessons Port del Comte 1 day
La Coma, Lleidafrom 265€ price/personThe Pre-Pyrenees is waiting for you to receive the private snowboarding class you have always wanted. Adapted to your level and in one of the best ski resorts in the north of the country, you will...
-
Private snowboard lesson Port del Comte 4h
La Coma, Lleidafrom 170€ price/personStop dreaming because it is a fact that this private snowboarding class in Port del Comte is for you. 4 hours improving and learning snow techniques with some of the best professionals. Can you ask...
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 = 14
GROUP BY PS.ID_POBLACION
ORDER BY N_OFERTAS DESC
All the Snowboarding companies in Port del Comte
Arties
from 205€
La Coma
from 170€
Vielha E Mijaran
from 15€
Espot
from 13€
Casau
from 48€
Llavorsi
from 47€
Vielha/viella
from 60€
Frequently asked questions about Snowboarding in Port del Comte
-
It can be bought or gifted from 170€. There are 35 companies and you have 2 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:
- Skiing Port del Comte
