Looking for a cabin rental on or near a lake/the water for 6 adults and a few kids-3 bedrooms minimum.

Can anyone recommend an area in CT or MA? I don't even know where to start.