You seem to be zeroing in on Carlysle vs Chatsworth and it might be important to you to to know that there is an abundance (2+ years) of inventory in Chatsworth right now. "Elite" can have a different meaning to some and neighborhoods like Devon, Faircroft, Linville, The Barony, The Registry and others all have price tags that put those homeowners in an elite category that is on par, if not superior to C&C.
Your individual lifestyle, neighborhood amenities, location to work or schools, etc. often play a role in home selections and by consulting with a knowledgeable and experience Broker you can get good guidance to make the best decision for you and your family.
North Raleigh area and Cary could be good options; in the current market there are good opportunities for investors. Please let me know if I can send you propertie's information via E-mail or if you preffer you can visit my web page at www.RaleighListings.net.