My father owns a few warehouses that are in borderline residential areas.
One of them he uses the majority of the space to house his car collection as well as his work area, hydraulic lift, etc.
But the rest of the building (old 1910's telephone company) is old office space with offices of various sizes/layouts.
He has a small lounge (couches, pool table, bar etc) attached to the main space with his cars, but the rest he rents out to whoever will pay, usually no questions asked. It tends to be local bands needing practice space who just hang out, play a little, drink a bit and smoke a bit of weed.
There are also a couple of people who live there at least a few nights every now and then. The building is not dual zone, but the odds of this being an issue are slim to none in the right neighborhoods. Unfortunately, the right neighborhoods in that sense are usually the wrong neighborhoods in every other sense. Unless you have mega bucks.
There are companies that take spaces like this and do exactly what you are looking for. HRI out of New Orleans immediately comes to mind.
http://www.hriproperties.com/Apartme...bsite_document[id]/15818
I am actually thinking about trying to get into historic renovation work after school, myself.