Much closer to you, in Rocky Hill is the Scuba Shack. They offer a full line shop for everyone,
and specialize in higher end gear for more technical minded divers.The owner is somewhat of a local dive celebrity, being (I think) the only GUE instructor in the area, and offers clases from Bouyancy 1, to GUE fundies. The main line in the shop is Apeks / Aqualung, and Halcyon. They also own Brownstone park in portland, just minutes from Hartford, and a good place to grab a dive on short notice. There is also New England dive center in Wallingford, Family owned and run, they are great people, and Paul is one of the nicest (funniest) guys you can find in a dive shop. Thier base line is Scubapro, but offer a lot of other lines, and tech gear as well. The shop is CRAMMED with stuff! I live in Portland, 2 min. from the quarry, and Scubasaurus is damn near as close. If you want to meet locals, the quarry is probably the best place to go, as there are weekly classes there, and usually several local guys just getting wet.