@Jason Malabute
I've been around the triangle my whole life, I'm not an agent but I'd like to think I know the area pretty well. I'll give you the best summary of the Triangle I can:
1. Chapel Hill Chapel Hill is probably the simplest of the 3 "Triangle" cities to explain. Homes are expensive compared to rent, property taxes are high, and most people keep their homes in great shape. No bad zip codes in Chapel Hill at all, maybe 1 or 2 class C apartment buildings, but everything is mostly the same (Class A/A-/B+ SFH). Great schools also, which reduce the market volatility
2. Raleigh Southeast Raleigh has long been the "bad part" of the city. It sounds like you have already found this. Raleigh is certainly picked over by the big cash buyers (as far as I can tell). Dawn Brenengen is the biggest Raleigh expert on BP, if you want Raleigh, I'd talk to her. Suburbs east of the city might be your best bet there. You could also look west of the Triangle proper, to Hillsborough or Mebane. I own a rental in Mebane that has gone well so far.
3. Durham Be careful. 20 years ago 90% of Durham was a warzone, but it has become much safer and favorable for investors. Unless you are in the city, it can still be difficult to distinguish the "up-and-coming" streets from the "do-not-touch" streets, and they are often right next to each other. Lots of Tech moving into Durham, so there will be some people who make themselves very wealthy investing in Durham for the next 10 years, but I would definitely recommend a savvy agent on the ground. I am not one, but happy to recommend mine if you PM.
Hope this helps!