Most major lenders will do a 30 year mortgage on a non owner occupied single family property with 15% down so long as you don't exceed 4 residential mortgages.Once you get past 4 and go into 5-10 you need 25% down.

I assume this would only be possible if I owned the condo association or had majority hold in it.

I know this can appear "below the line" but on a 41 unit project you will have real, major costs down the road that you should be prepared for on top of your regular OpEx.

That, or I'd head out to the major airports like MCO. 

Now to my question, is their any site/blog/video that explains majority of the terms or do I just have to write them down when I come across them and research them?

Most major metro areas have pockets that are surprisingly affordable, and you might just need to network a bit more and meet some local folks who can guide you. 

If they are in the major and popular market it naturally leads me to question the underlying assumptions.

I'm looking at some nice areas in Tennessee that are a couple hours from major cities, but may be near scenic and/or natural attractions, and slightly "larger" smaller towns, like the county seat.

I don't see any local level risk that is going to impact Kansas City negatively in a major way.

The downside is you lose the experience of someone else with more or different experience than you, my guys have helped me avoid a lot of major issues through the years that I would have missed.