Great question! We have some good information on just this type of financing. You can refer to our article on commercial real estate loans (https://fitsmallbusiness.com/commercial-real-estate-loans/) as well as our detailed guide on buying vs leasing commercial real estate (https://fitsmallbusiness.com/buying-vs-leasing-commercial-real-estate/).
We also have an upcoming article that addresses mixed-use financing that should be published within the next few weeks. In the meantime, I would look into mixed-use loans and mixed use financing, as these can finance spaces that have units that are zoned for multiple uses.
I hope these articles help!