Your Guide to Moving, Living, and Thriving in Metro Atlanta

150 Mayfield Road; Alpharetta, GA 30009

$1,495,000

Imagine Friday night concerts, Saturday mornings at the Farmers Market, dinner at a favorite restaurant and an evening stroll home all just moments from your front door. This is the lifestyle that makes Downtown Alpharetta so sought after, paired with a beautifully reimagined home that feels remarkably private once you arrive. Extensively renovated and expanded, this distinctive residence blends sophisticated Mid-Century design with warm, highly livable spaces. The transformation reworked the home from the inside out with a more intentional floor plan, curated finishes and spaces designed for both everyday living and entertaining. Designer details are layered throughout, from elevated tile selections and custom cabinetry to grasscloth-inspired closet systems by Artisan. Two private primary suites on the main level, an exceptionally rare feature, offer beautifully appointed retreats and tremendous flexibility. Dual laundry areas, an expanded driveway and additional access from Upshaw Drive add thoughtful functionality, while a front fountain creates a welcoming arrival. The terrace level extends the living space with a secondary kitchen, two additional bedrooms and a private bath, ideal for extended stays, multigenerational living or guests. Outdoor living is equally special. An expansive screened porch with cedar ceilings, Trex decking and a fireplace is complemented by a grilling area, built-in bar and wine refrigerator. The fully fenced backyard features flagstone pathways, a striking gas fire feature, mature privacy landscaping and low-voltage lighting create a secluded setting just moments from Downtown Alpharetta. Sophisticated yet welcoming, private yet connected, this is a distinctly different way to experience Downtown Alpharetta.
Key Facts
  • Style:
  • Year Built: 1949
  • Status: Active
Schools
  • Elementary School: Alpharetta
  • Middle School: Hopewell
  • High School: Cambridge
Bedrooms
  • Beds Total: 4
Bathrooms
  • Baths Full: 3
  • Baths Half: 1
  • Main Full Baths: 2
  • Master Bath Features: Double Vanity, Separate Tub/Shower, Soaking Tub

Learn more about this property...

Private & Public Schools Nearby

  • 5 / 5
    Above
    Avg

    Alpharetta Elementary School

    192 MAYFIELD ROAD; Alpharetta, GA 30009
    Public PK-5th  |  550 students
    Metro Atlanta School Rank: 86th
  • 5 / 5
    Above
    Avg

    Hopewell Middle School

    13060 COGBURN ROAD; Alpharetta, GA 30004
    Public 6th-8th  |  1,506 students
    Metro Atlanta School Rank: 51st
  • 5 / 5
    Above
    Avg

    Cambridge High School

    2845 Bethany Bnd; Alpharetta, GA 30004
    Public 9th-12th  |  1,984 students
    Metro Atlanta School Rank: 20th

Similar Properties Nearby

Listing Provided Courtesy Of: Atlanta Fine Homes Sothebys Intl.
Listings on this website come from the FMLS IDX Compilation and may be 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. © 2026 FMLS.

For issues regarding this website (and/or listing search engine, as applicable) please contact KNOWAtlanta - 770-650-1102

Listing information last updated on November 15, 2026