Waterfront lodging in Connecticut places you close to the sea. Connecticut > State > Resorts and Luxury > Waterfront Lodging. New England’s coastal areas attract vacationers from all over the world, so it makes sense that waterfront hotels, resorts, including beach and ocean resorts, are prepared to highlight the best of the coast.