$2,900,000
— bd · — ba · 2,301 sqft · Commercial
254 N Main Street, Alpharetta, GA 30009
Listing by Coldwell Banker Realty
$3,500,000
Est. monthly cost
$22,330/mo
Listing by Ansley RE | Christie's Int'l RE
Nestled behind private gates on 2.45 acres of lush, meticulously landscaped grounds, this extraordinary custom farmhouse, built by renowned Steve Powell Homes, offers an unparalleled blend of timeless elegance, modern luxury, and resort-style living. Ideally located just minutes from Downtown Alpharetta, Avalon, and GA-400, this remarkable estate provides both privacy and convenience. A picture perfect farmhouse front porch welcomes you home with cedar beams, tongue-and-groove ceilings, and dual porch swings, creating an inviting setting to enjoy the peaceful surroundings. Inside, the thoughtfully designed open-concept floor plan showcases exceptional craftsmanship throughout, including stunning Pennsylvania barnwood hardwood floors and beautifully curated living spaces. The heart of the home features a fireside keeping room anchored by a striking floor-to-ceiling stone fireplace and a chef's kitchen designed to impress. Outfitted with premium Wolf and Sub-Zero appliances, a farmhouse sink, quartzite countertops, a custom vent hood, oversized pantry, and an adjacent wet bar complete with sink, ice maker, and beverage refrigeration, this space is perfectly suited for everyday living and entertaining alike. The oversized fireside dining room is a true showpiece, featuring floor-to-ceiling folding doors that seamlessly connect indoor and outdoor living. As you approach the expansive lanai, you're taken by the views of the spectacular retreat, complete with a sparkling pool, Pennsylvania bluestone decking, tanning ledge, spa, accent waterfall, and dedicated pool bath with shower. A beautifully fenced pool area with elegant black wrought iron fencing enhances both safety and style. The luxurious main level primary suite serves as a private sanctuary, offering a spa-inspired bath with heated floors, a soaking tub, oversized shower, and an expansive custom closet featuring built-ins and a center island. Also on the main level are an oversized mudroom and an exceptional laundry room equipped with dual washers and dryers, utility sink, abundant storage, and a dedicated workspace. Upstairs, a cozy loft provides the perfect gathering space, while spacious guest suites each feature private ensuite baths for ultimate comfort and privacy. The terrace level is equally impressive, offering an additional guest suite with full bath, a dedicated fitness room, a large home theater designed with tiered seating, and a full garage. Above the three car main garage, a private guest suite with a full bath creates the ideal space for extended family, guests, or an au pair. Additional luxury features include epoxy-coated garage floors, a home generator, Control4 home automation and security system, outdoor firepit, and complete perimeter fencing, ensuring privacy, comfort, and peace of mind. This one-of-a-kind estate offers an exceptional lifestyle where sophisticated design, resort-inspired amenities, and a coveted Alpharetta location come together to create the ultimate luxury retreat.
Beamed Ceilings · Double Vanity · High Ceilings · Master On Main Level · Separate Shower · Soaking Tub · Walk-In Closet(s) · Wet Bar
Dishwasher · Disposal · Double Oven · Microwave · Refrigerator
Sprinkler System
Electric · Zoned
Central Air · Zoned
Hardwood
Corner Lot · Level · Private
Estimated monthly cost
$22,330/mo
$700,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 |
|---|---|---|
| Jul 2, 2026 | Listed for sale | $3,500,000 |
Cogburn Woods
Elementary
Hopewell
Middle
Cambridge
High
School assignments can change — verify with the district before you buy.
Source: Georgia MLS · Updated 12m ago · Nov 13, 2026, 9:15 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 13, 2026, 9:15 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
$3,649,000
6 bd · 7.5 ba · 5,294 sqft · House
141 North Trace, Alpharetta, GA 30009
Listing by Matthews Real Estate Group
$3,349,000
7 bd · 8 ba · 11,145 sqft · House
117 Liberty Grove Pass, Alpharetta, GA 30004
Listing by The Rezerve
$3,500,000
6 bd · 7.5 ba