I am not opposed to using a platform like Propstream that would provide hard analytical data on markets, demographics, and such, but even just in terms of news about developing markets and real estate news I don't really know where to look for specialized real estate news that is not subjective/someone's personal take on what is happening in a given market or something.

Do you recommend I stick to my cash purchase strategy or approach a hard money lender?

This really clarified on how to approach lease options! 

I think a strong argument can be made for both approaches.

The fact that your board of realtors recommends it, or that is how it is traditionally done there, does not make it the best way to approach it. 

Does anyone know if a mixed use 7 unit building would be appraised with the income approach or by sales comparison.

There are two methods of appraisals, Sales approach vs cost approach.

As the winter is fast approaching here in Minnesota (MN), I'm curious to hear what your "must do" winter prep lists contains to make sure your rentals are good shape for the cold? 

For a HELOC approach that would be good as you will have a hard time finding any bank to give you more than 80% on a HELOC.On the other hand for your own residence, you can get away with much less downpayment, especially if this is your first home purchase.

I appreciate any suggestions or feedback on the approach I took.