This special home in the heart of downtown Alpharetta has undergone a complete transformation on a private +/- 1-acre lot just a stone's throw to the vibrant city center. With soon-to-be expanded sidewalks along Cumming Street, this is a coveted location with incredibly convenient and walkable access to an array of restaurants, retail and entertainment options, seasonal Saturday Farmers Market, concerts on the green, and more. Just a few minutes to the Avalon, this area also boasts easy access to the Alpha Loop walking and biking path and Brooke Street Park, where locals enjoy green space and popular events hosted throughout the year like the Home By Dark concert series. As you arrive to this freshly painted home that is a seamless blend of traditional colonial and classic farmhouse, the covered front porch beckons with wood beams and copper lanterns that perfectly frame the double set of front doors. The true magic unfolds within, where a 2-story entryway warmly greets visitors. The open and inviting floor plan creates a natural flow between the various living and dining spaces and the large kitchen, offering ample space for family and allowing you to host and entertain guests with ease. As you enter the great room, the expansive ceilings are beautifully appointed by exposed wood beams that add warmth and texture to the space, and stunning shiplap and meticulous trim detailing flow throughout the home. The footprint of the kitchen has been entirely reimagined, and is centered around an oversized eat-in island with gorgeous super marble countertops. The kitchen also showcases custom floor-to-ceiling cabinetry and drawers, a gas range and range hood, and large farmhouse sink overlooking bay windows. Off the kitchen is a breakfast room for informal and everyday dining, and the dedicated dining room for more formal gatherings is accentuated by a wood plank ceiling. A double-sided brick fireplace is shared between the great room and sunroom. True to form, the sunroom is bathed in natural light by skylights, large windows, and a double set of doors that lead to the courtyard patio. The private and level backyard has plenty of space for a custom outdoor oasis, complete with a pool or firepit if desired. The primary suite on the main level boasts a luxurious ensuite with vaulted ceilings, dual closets, double vanities framing the luxurious claw foot soaking tub and large picture window, frameless shower, and custom built-in cabinetry for additional storage. The main level is complete with an additional bedroom and full bathroom, along with a spacious laundry room and powder bathroom. Upstairs are three additional bedrooms and two full bathrooms including a jack-and-jill bathroom with separate vanities that maximize both functionality and privacy, as well as an office/craft room/den to use for your ever-changing needs. The terrace level has a finished space that can also cater to diverse needs as a bonus room or workshop, along with a large unfinished space ideal for storage. Storage space is abundant with the many closets and several attic closets inside the home. A carriage house over the garage offers a private retreat/bonus space with a full bathroom, and the spacious 2-car side-entry garage has upgraded epoxy flooring. This special property embodies timeless updates in a coveted and unrivaled location in the heart of Alpharetta with the outdoor oasis and charm you have been searching for in your next home.