There are a few worth checking out, depends on what your looking for. If your into shrimp I breed a few different kinds. Some stores here are.
ABC Reefs- Saltwater mostly, they do have a nice freshwater selection though. Plants, a few different fish.
ABC 2, mostly freshwater, plants, discus, small selection of shrimp, good service. Talk to Kapil or Rachel they know thier stuff.
FishFinatics, best trade in prices in the area, usually do more than 50% of what they list for. Lots of fresh and salt selection, 500g koi tank.
Jamesville Pond and Supply, Great people been there forever, really depends on the day if they have fully stocked. They slack off a bit when pond season hits hence the name.
Fairmount Aquariums, not really recommend this one but sometimes they have deals. Tanks arent always clean and prices are high depends on what your looking for. Other than the petco, petlands in the area these are the best ones. I hit them all up from time to time lol.
Any nice Fish stores in the Syracuse area? Might be worth a drive.