Mixed commercial/residential single family home
I'm trying to find a single family home that's in a commercial zone where the first story and/or basement could be turned into a small music venue and the second story bedrooms used as a place for the touring bands to sleep/shower/do laundry. Ideally in Minneapolis, Chicago, Seattle, Columbus, Pittsburgh, Philadelphia, etc. 

How should I search for this? A commercial real estate website, a residential real estate website like zillow? So far I've found [this](https://www.realtor.com/realestateandhomes-detail/3025-James-Ave-S_Minneapolis_MN_55408_M77360-36701?cid=eml_saf_property_detail) but I want a better way to find similar properties.

Ideally it'd have at least 4 bedrooms, 2.5 baths (half bath downstairs, full bath for bands bedrooms, en suite for master bedroom where I'd stay), 

I'd also need at least 1050 square feet in the venue portion of the house (first story or basement, not combined) not including the bathroom. Fire code regulations demand 7 square feet per person in a standing room venue, so 1050 sqft = 150 people. 

Some other things would also be ideal, like a small parking pad, a sprinkler system, a garage, the kitchen being on a different floor than the venue, and being surrounded by other commercial properties like offices that close at 5ish and won't be bothered by the noise. 

TL;DR How can I best search for a commercially zoned single family home?
[{"id": "f8ju0sa", "text": "Check out [1012 Dulaney Valley Rd, Towson, MD](https://www.redfin.com/MD/Towson/1012-Dulaney-Valley-Rd-21204/home/166002550)  and the surrounding properties", "replies": [], "depth": 1}, {"id": "f8kg062", "text": "4716 w Vliet Milwaukee Wi\n300k", "replies": [], "depth": 1}, {"id": "f8kl7a3", "text": "Try loopnet and for your snowflake, Craigslist. \n\nAnd familiarize yourself with the zoning laws of the cities you want to look in. They may have an overlay plan in run down areas that would allow your use.", "replies": [], "depth": 1}, {"id": "f8oryu4", "text": "Commercial broker.", "replies": [], "depth": 1}, {"id": "f8pqoxo", "text": "Why not buy an urban building with street level retail and an apartment above?  That seems way easier then finding what you want.  \n\n&gt; I'd also need at least 1050 square feet in the venue portion of the house (first story or basement, not combined) not including the bathroom. Fire code regulations demand 7 square feet per person in a standing room venue, so 1050 sqft = 150 people.\n\nKeep in mind there is more that goes into the occupancy number like bathrooms and you will be converting to an assembly use from a residential so you are about to get nailed with all kinds of shit you will have to bring up to code in a conversation from a house to a concert venue.  This will probably also include fireproofing between the concert and residential space.  Parking is also likely to be an issue.\n \nYou can accomplish what you want, but if you think it is the easiest way I'd encourage you to look at mixed use structures as they will probably be easier in the end than an endless stream of bullshit you will probably have to figure out to make this happen in a house.", "replies": [], "depth": 1}]