Fred is absolutely right. Since your office is in a great part of town, I would suggest that you look there. The Atlanta commute can be ridiculous, and to work close to home is a dream for most metro residents.
I would be glad to send you some rental listings if that would be helpful. Trulia is great, but the listings are often out of date. If you like I can directly connect you with the MLS system that agents use to get real-time listings.
On a personal note: I have a soft spot in my heart for Sandy Springs. My grandparents had an antique shop on Johnson Ferry Road for 40 years. They were just on the other side of the Chattahhoochee River, and the bridge only had one lane, so you had to wait your turn to drive across. You will love living near the river. There are beautiful hiking trails, and opportunities for kayaking and canoeing if that's your thing.
Let me know if I can help in any way!
Keller Williams Realty