.), I'd recommend that the residential units fully cash flow the loan as my experience is that mixed use properties are tougher to finance as most lenders tend to prefer one or the other and something in the middle gets more difficult.For example, and granted I don't know anything about the area/neighborhood, I would expect this property (https://www.realtor.com/realestateandhomes-detail/111-NW-Har...) to be easier to finance than the mixed-use property you mentioned. 

Any recommendations? 

The biggest challenge seems to be finding lenders that offer these loan products which is where I’m looking for help from the community with recommended lenders that serve Texas.The Fannie Mae (or Freddie Mac) options are preferred over FHA purely because of the (perhaps perceived) limit on renovation funds that the FHA option provides.

Hey Robert,I recommend looking at BiggerPockets calculator. 

Did you work with any real estate professionals (agents, lenders, etc.) that you'd recommend to others?

On top of this if at all possible I’d recommend choosing specific neighborhoods to become an expert on as opposed to just thinking “anywhere in the San Antonio market could work”.

I highly recommend a book called Foreclosures Unlocked by Matthew Tortoriello and Kevin Shippee.  

I recommend talking with an experienced broker who can help you shop multiple lenders  

I would also recommend that you do not narrow your investment options.

We had a structural engineer evaluate and he recommended installation of piers to stabilize the foundation.