NYC has a few places like this, but typically it is living space above the ground floor, and you can rent "dont-ask-dont-tell" space in the basement. Most people use it for storage, but I've seen a few workshops in them.