Offers of Snowboarding San Isidro
2 prices to book or gift of Snowboarding San Isidro
2 offers
Best Snowboarding Deals in San Isidro
-
Full snow equipment rental, 1 day
Puerto De San Isidro, Leónfrom 20€ price/personEnjoy the slopes of the San Isidro station, renting the complete equipment for a day and take the board and surf the best tracks in an enviable environment. We have all models, brands and sizes and...
-
Private snow lesson in Puerto de San Isidro 1 h
Puerto De San Isidro, Leónfrom 14€ price/personIf you are looking to learn snowboarding in the most exclusive way, these private snow classes in the heart of the Cantabrian Mountains are all you need. Made to measure and together with great...
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 (3032)
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 San Isidro
Puerto De San Isidro
from 14€
Frequently asked questions about Snowboarding in San Isidro
-
It can be bought or gifted from 14€. There are 5 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 San Isidro
