Yes you can go out of the city, or upstate and get all of those things. NYC has great city parks as well. Prospect park comes to mind specifically.

>"Okay but what if they are outdoorsy and like to spend weekend in places like the Sierras, snowboard/ski, and proximity to national parks?"

Whiteface and Killington are about the same drive as Tahoe from SF, with vertical on par (3k+). Catskills even closer. There's no Yosemite obviously, but upstate NY/Vermont is as good as it gets east of the Rockies.

Okay but what if you move the goalposts again?