Welcome to NC (power of positive thinking). I've called it home all my life, with the last 26 years in the RTP area. Keep an open mind about housing options, the realtors will probably automatically steer you to Cary or North Raleigh. I've done Cary, little too conservative for me. Back in Raleigh, now.
If schools are an issue (school-age children, or soon to be), be sure to research not only the school district you are looking to move into, but the neighboring ones as well. With the continued healthy growth of the area, redistricting is almost an annual event now. There are even examples of residents being able to stand outside their home, and see a school from their yard, and not be assigned to that school.
You'll also have to officially declare your loyalty within the first 6 months to either being a State Fan, a UNC Fan, or a Duke Fan. We won't accept waffling.
Moving Target in NC (a diehard NC State Wolfpack Fan)