In our area there really isnt much... you could check out ABCReefs south of syracuse. Cityzoo in Elmira is also decent.
If you're determined to come, you could check out Creature Comforts in Binghamton, or Nature's Best Fish on 26S in Vestal.... but it's usually not even worth the trip for me, and I live 15 min away