Knowing that this will be an investment property in the future make sure you run your numbers conservatively and include the PMI for the FHA. 

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases.

You are thinking about it correctly.Of course, all strategies you choose has advantages and disadvantages, including SEO.If a strategy existed without any disadvantages no one would do anything else.The key is to analytically weigh in the disadvantages, feasibility, probability and risk when determining what to do.

We have severe land constraints, and Tesla is about to expand Giga Nevada to include the Tesla Semi factory which will lead to more rent and home appreciation.

While I can't definitively say which are the absolute top 5 zip codes in Columbus, I can help you narrow your search for Class A neighborhoods that offer a good balance of rental cash flow, low vacancy rates, safety, and strong school systems.Some promising areas to consider based on general market research include New Albany (43064), known for excellent schools, safety, and strong rental demand, although cash flow might be lower due to higher property values.

I am currently focused on tax strategies for our LLC (partnership with spouse).Can we sign a lease agreement with our LLC to provide/pay rent for use of our personal home/property, to include a portion of utilities, HOA, and insurance?

Our shorte(er) list includes Phoenix, LAs Vegas, Nashville, Atlanta, and Texas (Austin,Houston, San Antonio). 

@Richard Helppie-Schmieder Does your ARV include the ADU?

I've tried the getting the title company to pull them, but end up with every vacant parcel including landscaping medians!

From a purely financial return POV, cash is a smarter move than using debt on a lot of deals.