He's finding more properties than I can get qualified to purchase.If you're looking for commercial (5+ units) @Nathan Holsather is a good bet as well.If you're looking for someone who does value-add residential, @Jordan Moorhead is both a rehabber and an agent.

Being from NJ, I can try to help you determine the area stats.Also, from personal stand point, as an MFH investor, I don't like to bet on appreciation.

Would a HML be my best bet on this property .......... as i may have a better chance for being approved to do most of the repairs , as well as Having the best chance of getting a loan for the property?

The conventional may be my best bet, but I do have my house that I can work with.

As a newbie myself, I've quickly learned that you are in great location right now to begin your investment journey.

Your best bet is to have your agent contact the listing broker's employing broker and let them know the situation and request to be present when your offer is presented. 

If you have any questions about how we started our out of state investing journey please let me know.  

Thank you all for being a part of my journey!

However...Your best bet is to use a local credit union in CT.

@Adam Harward I have recently started my investment journey by purchasing a SFH in Akron last year.