Mike Janquish, NewUser, loves brentwood, and others, thank you! I will definitely be adding the state fair, watching the fountains, and VRBO and the homewood suites to my list of research topics.
Most of all thank you for the consensus and clarity on staying in Raleigh. I was getting a bit lost in the details and that direction was exactly what I needed. This move is so long awaited and so exciting, but it is a little overwhelming.
We will definitely be staying in Raleigh and maybe take a big family trip to the beach (because it is the beach and all). This trip has a definitive purpose, but having all of us together for 5 nights is a rare luxury and hopefully we can have some great memories from the trip too.
Thanks again, I'll post any helpful findings of my househunting trip to for any future readers.