I’m interested to invest in the area, my husband and I are exploring all different options! 

Explore financing options 5.

So what are our options?

Alternatively, you could consider marketing directly to sellers as another option.

Last option, a hard money lender can help.

Also, you didn't mention it but I am also specifically not asking about seller finance, it is an option but not the topic of this thread.

Using a rental is one of the best reasons to buy one so I like your thinking there.The proliferation of STR in ski areas have made areas a little farther out more of an option in some of the ski areas so you can track the options by looking where they short-terms stop on the map in the areas you like.

If this trend is likely to continue, it might be financially straining to keep the property, especially if you need to invest more in renovations.Financing Options for Renovations: If you decide to renovate, consider how you'll finance these renovations.

I do agree that Mixed-Use took a beating these past few years and would like to see more competitive options. 

Yes you can put it in a CD, there are also many other investment options in real estate and outside real estate that still make sense today.