I have never purchased an investment property, have minimum knowledge besides what I've studied on, and have zero hands on experience.

Check out other online guides available here: https://www.biggerpockets.com/guides3.

I am closing on a property sold via foreclosure auction in Connecticut where the tenant needs to be evicted by the State Marshal in the future.

It's detached - the city knocked down the home on one side in 2018 and a private individual knocked down the home on the other side in 2022.

I’d love to hear your experiences on where and how to effectively conduct these searches.What tools or resources have you found most reliable for uncovering any liens, encumbrances, or issues that could affect the property title?

Check out other online guides available here: https://www.biggerpockets.com/guides3.

When I posted on a different website someone stated that there are different laws in every state.

.$3K spent on inspections with no house to my name yet. 

Would love your thoughts on this Melanie 

That can take longer than most people would be comfortable with on their investment properties but once you're on the books, things tend to run pretty well.