Active$5,850,000
5 bd7 ba6,914 SFSingle-family home
250 Mayfield Road
Alpharetta, GA 30009 · Downtown Alpharetta · 34 days listed
FMLS #7840773 · Listing Provided By Peachtree Town & Country · 404-671-9100
Active228 days listed
FMLS #7731613 · Listing Provided By Ansley Real Estate | Christie's International Real Estate · 404-964-4662 · Listing agent Bobbie Schmitt

Set within the most exclusive enclave of Windward—The Peninsula—this extraordinary European-inspired lakefront estate offers a rare combination of privacy, security, and architectural grandeur. Positioned behind dual gates and boasting 243 feet of shoreline on Lake Windward, the residence spans nearly 16,000 square feet of impeccably designed living space. Renovated and updated – it’s move-in ready! A dramatic two-story foyer welcomes you with dual sweeping staircases, a domed ceiling, and a statement chandelier, setting the tone for the elegance found throughout the home. New picture windows fill the home with natural light while framing breathtaking lake views from many of the residence’s principal rooms. The recently renovated chef’s kitchen is thoughtfully designed for both everyday living and entertaining, featuring Sub-Zero and Wolf appliances, a full-size Sub-Zero refrigerator and freezer, dual workstation sinks, two ovens, two dishwashers, along with generous preparation space. Impeccably designed scullery and walk in pantry for seamless hosting. The owner’s suite serves as a private retreat overlooking the water, featuring a fireside sitting room, spa-inspired bath, and two expansive custom closets. Massive balcony off the main level provides awe-inspiring sunsets and lake views. Incredible judges paneling enhances the library which serves as a home office. Five additional ensuite bedrooms occupy the upper level, two of which include dedicated office spaces—ideal for work, study, or private sitting areas. Multi-passenger elevator serves all three levels. The terrace level is equally impressive, filled with natural light and opening to views of the heated pool, spa, and Lake Windward beyond. This level includes a state-of-the-art Golf Simulator, full fitness center, billiards room, game room, tiered theater, full second kitchen, full pool bath, spa room with enclosed jacuzzi and steam shower system. Large bedroom for house manager, au pair, in-laws or multigenerational living quarters with its own entrance. A dramatic double-sided stone fireplace anchors the main living area. Beyond the home, Windward’s 3,000-acre master-planned community offers an exceptional lifestyle centered around the 195-acre Lake Windward, along with access to the Windward Lake Club’s swim, tennis, and pickleball facilities, sports park, and the Golf Club of Georgia’s two award-winning championship courses, clubhouse, and fine dining. This is a rare opportunity to own one of Lake Windward’s most significant waterfront estates, where timeless architecture, scale, and setting come together to create an exceptional North Atlanta area residence.
Figures are list prices from current FMLS IDX inventory (Active, Active Under Contract and Pending), not sales prices or appraisals.
As reported in the listing. Verify with the school district.
Payment estimate
Prefilled with the list price of $5,850,000 and this week's average rate. Change anything to see your number.
$42,497/mo
This is an estimate only. Not a lender, not a loan offer and not a rate quote. Rates: Freddie Mac PMMS weekly average for 2026-10-22: 30-yr 7.32%, 15-yr 6.68%. Tax uses the annual tax amount in the listing; insurance assumes $1,500 a year. Conventional adds 0.5% a year mortgage insurance under 20% down; FHA uses 3.5% minimum down, a 1.75% upfront premium financed and 0.55% a year MIP; VA adds a 2.15% funding fee financed under 5% down and no monthly MI. Talk to a licensed lender for a real quote.
Active$5,850,000
5 bd7 ba6,914 SFSingle-family home
Alpharetta, GA 30009 · Downtown Alpharetta · 34 days listed
FMLS #7840773 · Listing Provided By Peachtree Town & Country · 404-671-9100
Active$5,900,000
5 bd7 ba8,316 SFSingle-family home
Alpharetta, GA 30005 · The Bridges · 63 days listed
FMLS #7829996 · Listing Provided By Keller Williams North Atlanta · 770-663-7291
Active$6,450,000
5 bd9 ba9,594 SFSingle-family home
Alpharetta, GA 30009 · Downtown Alpharetta · 55 days listed
FMLS #7836544 · Listing Provided By The Rezerve, LLC · 770-299-9529
Active$4,999,999
9 bd10 ba13,646 SFSingle-family home
Alpharetta, GA 30004 · Echelon · 117 days listed
FMLS #7798273 · Listing Provided By Atlanta Communities · 678-790-0217
Active$4,950,000
5 bd7 ba8,479 SFSingle-family home
Alpharetta, GA 30009 · Downtown Alpharetta · 5 days listed
FMLS #7846316 · Listing Provided By Armont Real Estate · 770-415-6668
Active$6,750,000
5 bd9 ba7,780 SFSingle-family home
Alpharetta, GA 30009 · Downtown Alpharetta · 19 days listed
FMLS #7850546 · Listing Provided By Armont Real Estate · 770-415-6668
Use the "Ask about this home" form on this page and include the days and times that work for you. Jeff Crowe will follow up to set up a showing.
Send your question through the form on this page. Listing details come from FMLS and are provided by Ansley Real Estate | Christie's International Real Estate, so confirm them before making an offer.
This page shows the status reported in FMLS (Active) as of the last update. Status can change quickly, so ask through the form to confirm before you tour.
It uses the list price, an average mortgage rate, the tax amount in the listing (or an estimated tax rate when none is given), estimated insurance and any HOA dues in the listing. It is an estimate only, not a loan offer. Talk to a licensed lender for a real quote.
See the similar homes section on this page, or browse all homes for sale in Alpharetta, GA.
Beyond homes
Jeff Crowe is a local, full-service agent with CENTURY 21 The Avenues who also works with buyers and sellers of apartment buildings, churches, commercial property and land across Georgia. The pages below are other property types and investor research, separate from this home listing.
Thinking about a rental or a building instead? Send Jeff a message.
Listings identified with the FMLS IDX logo come from FMLS and are held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request. ©2026 First Multiple Listing Service, Inc.