While I love Lk Chelan and it's always booked solid it's really just a summer spot so you are banking on just 3-4 months. 

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

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.

@Jay Hinrichs is spot on with the online reviews.