There are good waves not that far from Manhattan - on Long Island, in north Jersey. It's true that the best surf around here tends to happen in winter, so you need a good wetsuit, and the time window of good waves is often pretty short, so you have to stay on top of the forecasts.