I would leverage your index funds if possible to use for a 90% purchase price / 100% rehab loan from Kiavi.

Definitely recommend reading up on or talking with a CPA on what expenses can be deducted as a repair and what has to be capitalized, as that will affect possible losses. 

I'm in Asheville but would be interested possibly.

The accounting software that you choose should not impact your relationship with your accountant as long as you can provide them a report that is easy to read and understand.I would suggest, if possible, to change softwares at the start of a year as it would make things easier.Furthermore, make sure you to carryover all balance sheet ending balances to your new accounting software.Best of luck

If you think there might be the possibility of development raising the value in the future, you could try renting out the property to others for non-intrusive uses - parking, roadside vendor, etc. 

My question is: Is this house better off being rented long term for tenants or should I gravitate toward a midterm rental for possible traveling nurses or traveling professionals who want a cleaner, more up to date space, closer to downtown?

You've possibly stated in writing that you (may have) violated several laws ie. working as a property manager w/o the proper licenses etc. 2.

I haven't reviewed the Standard Lease Agreement yet, but all I need is the right to sublet, and possibly some negotiated capital responsibilities (owner pays for repairs over a certain amount or split responsibilities on certain expenses).

Then after that, you have more trusted contacts, then diving into world is more possible

I know people who do STR in their house, but it's as private as possible.