THIS ITEM HAS EXPIRED
 Save Up To 20% On Ski Rentals 

Save Up To 20% On Ski Rentals

Rent your skis and snowboards from North America's largest rental provider where we feature the best gear at the best locations. At Rentskis.com, you can reserve your gear online quickly, and your equipment will be waiting for you upon arrival – or for free, we will deliver right to your door.

Offer Valid Until: 30th April 2013

Disclaimer: Prices are subject to change. Call resort for updates.
SELECT resort_id, round( 6378 * 2 * atan2( sqrt( pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ), sqrt(1- pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ) ) ,1) as d FROM ots_si.resort r INNER JOIN ots_si.services_subscribed_web on resort=resort_id and is_listed='y' WHERE round( 6378 * 2 * atan2( sqrt( pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ), sqrt(1- pow(sin(radians(38,0000 - latitude) /2),2) + cos(radians(latitude)) * cos(radians(38,0000)) * (pow(sin(( radians(-97,0000 - longitude) )/2),2)) ) ) ,1) <= 480 order by d OnTheSkiInfo::Service::OXSOmniListHelper /home/webadmin/live_oxs_public/lib/perl/OnTheSkiInfo/Service/OXSOmniListHelper.pm 95

Snow Reports

No areas with new snowfall... Pray for snow!