If you believe there is a benefit in clustering your business with other artists, the arts districts in Charlotte are primarily in NoDa http://www.noda.org/arts.cfm and SouthEnd http://southendclt.com/south-end-gallery-crawl (See map link below). If you are OK to be in an individual location, there are some great options for live-work studios which would be good investments. You will generally not be able to have a shop that is open for the general public to come visit in residential zoned location.
Charlotte Art League (CAL) has working artist studios available for rent. Studios are based on an open concept. From their website http://www.charlotteartleague.org : During Gallery Hours the public is invited to tour the gallery and studios, meet with artists and purchase artwork. Studio artists have 24 hour access to work on their own schedule. Studios vary in size from one quarter, to one-half, to a full studio. Artists are expected to use their studios for the purpose of producing art. Generally accepted studio media are fine arts: painting, drawing, sculpting, printmaking and mixed media. There is no jurying of work based on ability, but applicants are subject to CAL approval. In both the studio and wall rentals, artists must price work available for sale to the general public. There are also some good live/work options in other locations.
If you decide to purchase, I'd enjoy working with you on this project. If you appreciate an answer, please give thumbs up. For the most helpful answer, please say thanks with a best answer click.