Im new in the investing space and im looking for more experienced commenters to give you more insight into how to navigate the financing aspect of things.On a more personal note, if you do get involved in buying a property from a family member, my advice would be for it to be a clean cut to minimize any future problems.

I prefer to create more value by buying building with lots extra unfinished spaces or big dry walk out basement walk in attics, attached barns etc adding bedrooms increases cash flow quicker cheaper than extra bathrooms and adding entire apartments great too.

In November another opportunity developed to purchase an office space building in the same area that included three current commercial tenants. 

Another tech expansion in Austin with the largest single office lease on record for Austin, TX.California-based Meta Platforms Inc. — the parent company of Facebook — recently leased the entire commercial half of Sixt...

Depending on your area and how you have the space setup you could also target traveling professionals through Furnished finder.

Does anyone have a referral to a rock star in this lending space?

You may need to begin networking with brokers in the multi-family space. 

The relationships I've built here in western Washington, allow for really good prices on work, plus I refer them out to my RE sellers and buyers for work to be done before listing or when after buying.Yes indeed, the three it's going up I think the only short-term rental that we would do in Washington would be converting our own house into a short-term rental space.

Also added covered outdoor entertaining space.

I plan on super "spiffifying" this property, Good price for a nice little property.You said you wanted to super spiffy it up.I did a quick mockup of a more modern look.Hardieboard, stone, metal roof, eaves extended, etc...Lighter colors look bigger.Good Luck!