What are some solutions to overcome this?

so you can get teams in there to rehab/rebuild then you have to overcome the public stigma of said area to get actual tenants or buyers to pay for these housesand when all that is done, you have to show a profit....From a capitalist perspective, this is a money loserfrom a philanthropic perspective, there are more efficient ways to help and when the government gets involved and it's called gentrification

Footings and house connections may be the hidden detail to overcome.

Don't create more barriers for yourself to overcome by thinking that you "need" to do X, Y and Z before you start.

Think of ways to overcome seasonality & focus investment dollars to adding amenities that boost your listing in the off season, you only have 1 door so work to make year round income.Happy to share all I've learned about vacation rentals, STR management, guest vetting, providing a luxury guest experience, & stretching that investment dollar in the STR space.

Really trying to wrap my head around this and overcome bad information / bad communication / conflated definitions / etc.

I also am looking and analyzing deals all over the US... as much as i can do online... also as much as i can do with the knowledge i have ( which i small but growing each day).being in the military it has taught me that i can overcome anything. obviously, i would like to be put my self in the positions that best suits me.

I think you may have still have to go through the eviction process, but there are no technicalities that the tenant can use to overcome that you simply have decided not renew the lease.

And how can I overcome my nervousness and attack the deal with no hesitation and fear?

One of the first things to do to overcome all of the barriers to real estate investing is to decide what kind of investor you want to be.