Being on Paseo and near the university helps, but that's still a tough spot.

@Sunny Burns is even more impressive and was on the BP podcast way back when. 

My biggest concerns are 1) the property is not exactly walking distance to the beach, and 2) the area looks a little crummy in spots with some trailers.

Unfortunately STR mixed with homeowners and families don't work well together, even in rural areas.Outside of the destination type spots for AirBNBs, I do have a few that are in very, very good areas of their respective cities.

Coffee, lunch or a local meet up spot would work great. 

So I check the plumbing that we replaced, I look under sink, I check smoke detectors, also look at spot I repaired under a bad window seal,  heck doors for light leaks.

Your interest in Ohio, especially Columbus, is spot-on for your SFH or small multifamily investment goals.

Once you understand the tradeoffs of getting an LLC vs not getting one, then you're in a great spot to decide what will work best for you. 

This approach aligns with my preference for immediate equity and the potential to replicate this strategy with a second property by year's end.House Hack a New Construction Duplex: I've spotted a duplex priced at $405k that's appealing for a live-in investment.

@Sunny Yu, an undeeded interest is still an interest in the real estate.