Niantic, Connecticut - From its place along Long Island Sound, Niantic has allowed locals to enjoy water, sand and seafood for centuries. Featuring not only the sole waterfront main street in the state of Connecticut, Niantic also enjoys the distinction of having one of the longest sand beaches found anywhere along the state's coastline.