We specialize in working with fix/flippers and work with a good amount of out of staters. 

My goal is to attract standard medical office tenants who do not require specialized equipment—such as Primary Care Physicians, Urgent Care Clinics, Chiropractors, Physical Therapy & Rehabilitation Centers etc

You should be fine, and I doubt anyone will care or say anything specially in a DSCR loan.

As I mentioned, advanced tax planning opportunities are going to be limited so finding a highly specialized CPA is probably unnecessary and going to reduce your pool of otherwise qualified accountants.

When I inquired about it, plumber said lining, it is usually not prefect since this is PVC breakage not just pipe cracks and the cost saving is not significant enough and maybe headache down the road.I will try to get more quotes and maybe a company that specializes in pipe lining options.I was told foundation work / under slab pipe repair is common in the Dallas TX area due to soil type.

Quote from @Havital Miltz: Normally you would set the LLC in the state where the property is.You have no tax benefits for setting up an LLC, it is more a protection from lawsuits and going after your personal assets, however not a guarantee....As a husband and wife you do not need to set up a partnership - IRS has special considerations for married couples for self employment, you could also apply that for a rental...Hope that helpsA joint venture is available to any 2 people co-owning real estate for investment purpose as tenant in common  under Proc. 2002-22 (unrelated to marriage) but it can't be owned in an LLC together. 

I would shy away from a mentor as mentors specialize in specifics and you dont know your "specifics" yet.

Essentially I am looking for a clean way to organize everything as right now its very messy with how my current accountant is working things as he doesn't specialize in real estate.

We specialize in sourcing distressed/discounted properties for investors.

Are there property managers who specialize in managing housing for section 8 tenants?