I live in the Bay Area. You should be able to get Comcast. You can get ESPN Full Court or Game Day if you want on Comcast. All the games on those packages. However, if you have Comcast Internet you can watch all the games on ESPN3.com for free. They have improved the streaming over the years so you should be fine. Broadcasting on ESPN3 is subpar but you can at least see all the games.
As for SNY, we can't get it on Comcast since I tried. Only DirecTV subscribers can get SNY I believe out here. Call your local Comcast rep to see if he can hook you up with a special deal. Usually, they can vs. what's available on their Website.
If we move to NBC, we are all set since all the games will be on Comcast. Comcast owns NBC in case anyone does not know.