Nearby Ski and Snowboard Resorts

Find new snow totals, base depth, weather, visitor ratings and distance to ski resorts closest to your current location. Click over to Map View to see nearby ski resort locations on an interactive map.
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

No resorts found!

This search returned no current results. Check back soon, as resorts update snowfall information daily.

Advertisement

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!