I'm in the very bottom of Hudson Valley in New Fairfield, CT. Not a lot of LFS around here, but if you're willing to take a ride (all are at least an hour away from me) there there are some worth the visit.
My personal favorite is Greenwich Aquaria in Riverside, CT. Fish are healthy and Jason, the owner, is known to get some rare ones in (he even discovered a new species named after him). They are also the most trustworthy and knowledgeable when it comes to stocking your tank and advice on equipment. They want you to have a good experience, even if that means not making the sale. Really great shop.
Five minutes from them is House of Fins in Greenwich,CT. They always have TONS of fish in stock, but the prices are almost 2x if not more than what you would find elsewhere. But with this being one of the most wealthy towns in the country, you can't blame them. I usually skip it because I never get a good vibe from the staff. Always feels like the used car salesman of reef-keeping. I would go here if you are just looking for stock options and have already done your research (including what is a reasonable price).
I'm always looking for other good LFSs if anyone in the area knows of any!