Charlotte is becoming an increasingly expensive area to buy in so I would imagine that the majority of places worth buying are probably too expensive to cashflow. But, I've spent a decent amount of time in Charlotte so I know a little bit about it. Anything in Providence school district, Myers Park, Butler, Ardrey Kell, Mallard Creek, Independence, the Matthews area (suburb), Marvin Ridge, Indian Trail, anything near UNC Charlotte, Belmont Abbey college. A lot of Tryon road is where things start to decline in quality. As far as the going rate per unit, I suggest rentometer.com. You just type in an address and it will give you a ball park estimate.
Hello, Betseat! I'm an agent in Charlotte, and I've dealt with duplexes all over the city. There aren't nearly as many as you'll see in other cities, but it is possible to find a few hidden gems. The going rate is anywhere from about $150k to over $1M depending on things like location, size, age, etc.. Let's connect and I'll send you info on duplexes on the market currently and new ones that come on the market as we approach your move to the city! You're making a good call as Charlotte really is a gorgeous, new, and growing city!