Looking for 1st small MF: House Hack or Long Distance - Cash Flowing or Appreciating?

[Ken Nieves]

Okay...somewhat of a feeler post, to see if I am even close to being accurate, with my research.

Currently looking in the Austin, TX and Boise, ID markets.  I have selected these two based off of a few core criteria principles. 
-Austin, TX seems to be a good LT appreciation play, cash flowing may be difficult but not impossible.  This would be a long distance investment strategy, as I do not want to relocate to Austin.
-Boise, ID seems to have better opportunity for cash flowing, while still having a good chance of LT appreciation.  Reports suggest 60% population growth in last decade, and forecasts show the same, for the next 10 years out.  This would be a house hacking strategy (duplex/twin home), as I am willing to relocate to Boise.

I have no previous experience in RE investing.  I have recently acquired a few different spreadsheets for analyzing deals, but very unsure if I am using them correctly.  In terms of budget, we are blessed to have family who is willing to help us get into something that pencils out (no commercial MF).

I could really use any and all advice, suggestions, insights and assistance in starting this journey.  Open to all.  And if anyone needs a remote assistant, for RE/MF investing related tasks, I can dedicate 40 hours monthly towards something like that, in exchange for training/guidance.

Thanks!