In terms of the title, you can go in together and the loan can be under one or both people depending on qualifications.

I'm going to sell one of my rental properties and offer seller financing with a 30-year mortgage term.

If you're not planning to live in the property long-term, I'd suggest prioritizing the property's standalone investment potential during evaluation, regardless of its role in a house-hack scenario.

The showing is scheduled and as long as no big concern arises, I am going to make an offer.

I currently own my primary residence and recently decided to buy a piece of raw land where my father’s construction company is, and with his help,  build a single family home on it which will become a long term rental when completed. 

Intel is a great example, who is building the largest chip manufacturing plant in the US right here, and it will be a $20 billion dollar investment that brings a few new thousand jobs.https://www.dispatch.com/story/business/2022/01/21/intel-ohio-building-computer-chip-factories-licking-county-jersey-township/9173472002/ Another example of economic growth is the upcoming Ohio State University Wexner Medical Center Inpatient Hospital which is a 1.9million square foot hospital that will bring over 800 new beds and a thousand new jobs. https://abc6onyourside.com/news/local/new-osu-hospital-expected-to-transform-health-careHere are a few more recent investments https://www.10tv.com/article/money/business/hydrogen-power-company-hyperion-bringing-700-jobs-to-columbus/530-25907aab-5517-4661-a9f3-d2ed2d5be6b0 https://news.wosu.org/news/2022-02-08/rumpke-to-build-50-million-recycling-facility-in-columbus Check out The Complete Guide to the Columbus, Ohio Real Estate Market which goes through the Columbus, Ohio market in depth and will give you a better scope of where the highest levels of growth are taking place and where to look to invest. 

My background is in analytics and have worn a couple of different hats in the space - sales compensation, business performance / reporting, COGS management, and opportunity / risk evaluation and implementation.Real estate investing is the first topic in a long time - maybe ever - in which I've been truly interested in learning more.

Real Estate investing is a long journey not a "get rich quick  phenomenon. 

Long and short, if you were to buy a primary residence at $500,000 you would have to put down 6%.".What are your thoughts at the moment?

So, long story short.