Investing in Connecticut

[Jason Chung]

Hi, I'm moving to Connecticut and will be working between east of New Haven towards Guildford to Waterford/New London and up to Norwich. I'm looking for an investment property/house hack around those areas, preferably close to the water, and a multiplex. Do any of those areas (or surrounding areas) have a:

1. Good positive cash flow/appreciation?
2. Strong rental demand?

Any assistance and investor friendly realtor recommendations would be greatly appreciated.