$2,900,000
— bd · — ba · 2,301 sqft · Commercial
254 N Main Street, Alpharetta, GA 30009
Listing by Coldwell Banker Realty
$2,795,000
Est. monthly cost
$16,890/mo
Listing by Keller Williams Realty North Atlanta
Completely reimagined with an uncompromising attention to detail, this exceptional Windward estate showcases elevated finishes, bespoke craftsmanship, and thoughtfully curated living spaces. The extensively rebuilt kitchen features integrated custom cabinetry, Sub-Zero refrigeration, and Wolf appliances, while the dramatic great room impresses with a floor-to-ceiling stone fireplace, Restoration Hardware lighting, and custom black walnut shelving. White oak hardwood floors and refined architectural details enhance the sophisticated interiors. The second-level primary suite offers a private retreat with a cozy TV lounge and a separate sitting room with fireplace. The renovated primary bath features floor-to-ceiling porcelain tile, a custom-tiled open-entry shower with an oversized Grohe rain showerhead, Restoration Hardware vanities, and a separate soaking tub. A custom closet cabinetry system adds functionality. A main-level guest suite, three additional upstairs bedrooms, and renovated baths accommodate family and guests. The renovated terrace level includes a dedicated office with custom built-ins, flexible bonus room, and expansive entertainment area with wet bar. Outdoors, extensive landscaping and hardscape enhancements create a private setting for relaxation and entertaining. Custom patios, a fire pit, a secluded lanai, a tranquil water feature, and a dedicated grilling area complement the mature landscaping, while professionally designed lighting creates an inviting atmosphere after sunset. Additional highlights include a three-car climate-controlled garage with glass doors and epoxy flooring, all-new interior and exterior doors, and significant infrastructure updates, including a roof replaced in 2022, and HVAC systems and water heaters installed in 2019. Located in sought-after Windward, the home offers convenient access to Lake Windward, soccer fields, playgrounds, The Racket Social Club, and The Golf Club of Georgia. Shopping, dining, and entertainment at Avalon, Halcyon, and Downtown Alpharetta are nearby, along with quick access to GA-400 and top-rated North Fulton schools.
Beamed Ceilings · Bookcases · Double Vanity · Tray Ceiling(s) · Vaulted Ceiling(s) · Walk-In Closet(s) · Wet Bar
Dishwasher · Disposal · Double Oven · Dryer · Gas Water Heater · Microwave · Refrigerator · Washer
Garden
Natural Gas
Central Air
Carpet · Hardwood
Private
Estimated monthly cost
$16,890/mo
$559,000
Estimate only. Taxes use the listing's most recent figure where available; insurance assumes 0.6% of price per year, typical for the area, not including flood cover. Mortgage insurance applies below 20% down.
| Date | Event | Price |
|---|---|---|
| Nov 11, 2026 | Status: For sale | $2,795,000 |
| Nov 2, 2026 | Listed for sale | $2,795,000 |
Creek View
Elementary
Webb Bridge
Middle
Alpharetta
High
School assignments can change — verify with the district before you buy.
Source: Georgia MLS · Updated 11m ago · Nov 12, 2026, 12:45 AM ET

Listings courtesy of Georgia MLS. Listing information © 2026 Georgia MLS. All rights reserved. Each listing names its listing firm.
© 2026 Georgia MLS. All rights reserved. Information is deemed reliable but is not guaranteed. IDX information is provided exclusively for consumers' personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by GAMLS. Last updated Nov 12, 2026, 12:45 AM ET
Report a listing problem$2,900,000
— bd · — ba · 2,301 sqft · Commercial
254 N Main Street, Alpharetta, GA 30009
Listing by Coldwell Banker Realty
$2,900,000
Land · 0.57 acres · $5,096,587/acre
254 N Main Street, Alpharetta, GA 30009
Listing by Coldwell Banker Realty
$2,475,535
Land · 27.7 acres · $89,402/acre
0 Mountain Road, Alpharetta, GA 30004
Listing by Coldwell Banker Realty
$2,475,535
Land · 27.8 acres · $89,144/acre
0 Mountain Road, Alpharetta, GA 30004
Listing by Coldwell Banker Realty
$2,795,000
5 bd · 5.5 ba