Everyone else gave you the right information,My only additional advice is to investigate some other loan options as well. 

I did some investigation recently and they cash flowed better than a SFH.

I'm just starting to learn how to analyze deals and am actively looking for areas with potential (investigating areas in North Carolina and southern part Virginia).

I don't intent on becoming an investigator just to figure out who has done what to the property.

After an investigation, the bank concluded someone with a similar user ID as mine entered my user ID by mistake.

And he doesn't really care to investigate it.

If you find an elder care facility that accepts Medicaid and if your MIL intends to go there, investigate it thoroughly on-site.

The new firm I am investigating has a more comprehensive team based service which includes for example tax and legal in-house counsel, but the advisor I spoke to didn’t have the depth of RI knowledge I wanted.

Do you recommend what I should need to ask or investigate further on?

The Connecticut statute also specifically provides protection to the tax deed purchaser against any liability for any condition existing or occurrence upon the property or adjoining public sidewalks and streets, or for any failure to act to remedy or investigate any such condition or occurrence during such redemption period.