There is nothing wrong with that, but here on BiggerPockets, in general, the term has come to mean a property where a majority of what you term hard work - locating the house, renovating the house and have management in place have been done.The problem is it does not mean the house is in a great neighborhood, it does not mean the renovation has even been done much less to a high standard and not all management is created equally.So, there is a ton of research, digging and understanding what the investment is you are making that has to be done before you can ever buy a property. 

Thanks for all of your help I am new to all of this but very excited to dig in and get started!!

If you haven't built on a vacant lot before I'd dig in a bit further on that as it can be a challenge in some jurisdictions and cheaper to buy than build.

In my market first thing we check is the tax records on how many units the property is.  98% of the time this is accurate...so if I see 3 units, and the tax record says 1 unit, I then need to dig further.

Have been digging through the list and gaining a ton of insight into how the city is structured/broken down.

For what it's worth the DSCR would be roughly 1.25 at these high-level numbers (please dig into the actuals)  Most banks would accept, but that doesn't mean it's a good deal.   

I’ll try to dig up some links for video training for you   

But I like what you are doing and if I digged into numbers I think my numbers would be similar: smaller for Airbnb where llast minute bookings are more common than on VRBO . 50 days average seems reasonable to me.As an input I think the last column should not be computed as a direct average, rather weighted by volume (either $ value or number of nights or even number of bookings).

Another idea is get a really good handyman that will dig into the problem if you're not sure how to narrow it down.

Before you commit to the condo/duplex idea I would have your agent dig into the neighborhood comparables a little more and see if half duplexes are selling for what you want.Duplexes will rent all day long, but selling half of a duplex is a different game.