If you were to log in, you'd be able to get more information on your fellow community member.
So the problem is that you want to be able to do more than just sleep and eat at your house... And the solution is constrained to be an industrial loft in suburbia or a forest?
Combining commercial and residential uses in a single building is antithetical to the principles and legal codes that define suburbia. You can get away with a home office (desk and a PC) in suburbia. Some people setup basement or garage woodworking shops. However, a home/dentistry office would be prohibited. A home/art gallery would not be allowed and could not benefit from the network effects of nearby business establishments. If the business expands between one (or two) employees, you'll have to move it to a commerical ghetto (strip center).
Farming is always an option in truly rural areas. Or, if you can afford a country estate, then of course you can build the workshop and the sculpture studio and the carriage house/inlaw suite.
So, you've mentioned the industrial warehouse district...