It is on a major road, and you cannot compare it to houses that sit within a normal neighborhood.

I ran across this property that has the potential to be a really good investment but the ENTIRE house has an extremely bad mold issue and it needs major repairs.

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.