I live in the Bay Area, and am quite familiar with the Atlanta Real Estate Market, having helped several clients invest there. As you may know, the Atlanta market is HUGE, and where you decide to live depends on many factors, such as commute distance/time to work, amenities, price range, to name just a few. I have worked with several real estate agents there, after interviewing a multitude. I'd be happy to refer you to one to help you make your move.
You would love the Alpharetta area! Most people who move to here find it appealing.
As Kathy noted if you plan on working here then commute time should be something to consider when choosing your location.
There are many great areas to choose from depending on your personal needs. I will be glad to help you sort them out when you are ready!
Best of luck with your new home.
Would be happy to chat with you at no obligation. I work with clients relocating into Atlanta all the time and just had clients last year leave Atlanta for the Sacramento area so I am somewhat familiar with the housing market you are leaving.