I know at least one house in my neighborhood was zoned mixed use (residential and commercial) because they had little basement area with a single-chair hair salon.

It's been re-sold twice since I've lived here and rezoned to pure residential. I'm not sure if that was to simplify things but that's kind of what I infer from it.

Still - maybe something to look for as a compromise.