Durham is also has many neighborhoods that may meet your criteria. In many ways, Durham has "hipper" neighborhoods with an artsy flair. If you're planning to work in RTP, that may also be a worth considering.
Glenwood South has many restaurants and their is housing nearby. Mordecai is more of a neighborhood area but is certainly close to some excellent shops. I hope you're able to find something!
I know this is an older post, but there is so much going on in downtown Raleigh...its good to refresh this.
Glenwood South is fun too as is , in and around Cameron Village, Five Points area too.