Skip main navigation
Active
    • $1,495,000

    150 Mayfield Rd, Alpharetta, GA 30009

    4beds
    3,242sqft
    : 
    $10,309/mo
    Get pre-qualified
    Single Family Residence, Residential
    Built in 1949
    0.51 Acres Lot
    $1,442,900 Zestimate®
    $461/sqft
    $-- HOA

    What's special

    Fully fenced backyardBeautifully reimagined homeWarm highly livable spacesTrex deckingElevated tile selectionsIntentional floor planStriking gas fire feature
    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.
    15 hours
    186
    16

    Zillow last checked:

    Listing updated:

    Listed by:

    Wendy Mullins,

    Atlanta Fine Homes Sotheby's International 770-375-8689

    Source: FMLS GA,MLS#: 7831707MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 3
      • 1/2 bathrooms: 1
      • Main level bathrooms: 2
      • Main level bedrooms: 2
      Rooms
      • Room types: Other
      Primary bedroom
      • Features: Double Master Bedroom, Master on Main
      • Level: Double Master Bedroom, Master on Main
      Bedroom
      • Features: Double Master Bedroom, Master on Main
      Primary bathroom
      • Features: Double Vanity, Separate Tub/Shower, Soaking Tub
      Dining room
      • Features: Open Concept
      Kitchen
      • Features: Breakfast Bar, Cabinets White, Kitchen Island, Pantry Walk-In, Second Kitchen, Stone Counters, View to Family Room
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Ceiling Fan(s), Central Air
      Appliances
      • Included: Dishwasher, Disposal, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Self Cleaning Oven
      • Laundry: Laundry Room, Main Level, Other
      Features
      • Beamed Ceilings, Crown Molding, Double Vanity, High Speed Internet, His and Hers Closets, Recessed Lighting, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s)
      • Flooring: Hardwood, Luxury Vinyl, Tile
      • Windows: Double Pane Windows, Insulated Windows, Window Treatments
      • Basement: Daylight,Exterior Entry,Finished,Finished Bath,Full,Interior Entry
      • Attic: Pull Down Stairs
      • Number of fireplaces: 2
      • Fireplace features: Electric, Family Room, Gas Log, Gas Starter, Glass Doors
      • Common walls with other units/homes: No Common Walls
      Interior area
      • Total structure area: 3,242
      • Total interior livable area: 3,242 sqft
      • Finished area above ground: 3,242

      Property

      Parking
      • Total spaces: 3
      • Parking features: Driveway, Garage, Garage Door Opener, Garage Faces Front, Level Driveway, On Street, Parking Pad
      • Garage spaces: 2
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Two
      • Stories: 2
      • Patio & porch: Deck, Front Porch, Patio, Screened
      • Exterior features: Lighting, Rain Gutters, Rear Stairs, Storage
      • Pool features: None
      • Spa features: None
      • Fencing: None
      • Has view: Yes
      • View description: Other
      • Waterfront features: None
      • Body of water: None
      Lot
      • Size: 0.51 Acres
      • Dimensions: 112x298x104x298
      • Features: Back Yard, Corner Lot, Front Yard, Landscaped, Level
      Details
      • Parcel number: 22 481211980590
      • Other equipment: Irrigation Equipment
      • Horse amenities: None

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Mid-Century Modern,Modern,Ranch
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick 4 Sides
      • Foundation: Block, Slab
      • Roof: Composition,Metal,Shingle
      Condition
      • Resale
      • New construction: No
      • Year built: 1949

      Utilities & green energy

      • Electric: 110 Volts, Other
      • Sewer: Public Sewer
      • Water: Public
      • Utilities for property: Electricity Available, Natural Gas Available, Phone Available, Underground Utilities, Water Available
      Green energy
      • Energy efficient items: Insulation, Thermostat, Windows
      • Energy generation: None

      Community & HOA

      Community
      • Features: Near Schools, Near Shopping, Near Trails/Greenway
      • Security: Carbon Monoxide Detector(s), Fire Alarm, Secured Garage/Parking, Security Lights, Smoke Detector(s)
      • Subdivision: None
      HOA
      • Has HOA: No
      Location
      • Region: Alpharetta

      Financial & listing details

      • Price per square foot: $461/sqft
      • Tax assessed value: $931,700
      • Annual tax amount: $7,026
      • Date on market: 9/23/2026
      • Electric utility on property: Yes
      • Road surface type: Asphalt, Paved

        Estimated market value

        $1,442,900

        $1.37M - $1.52M

        $4,171/mo

        Price history

        DateEventPrice
        9/23/2026Listed for sale$1,495,000-0.3%$461/sqft
        Source: FMLS GA #7831707 Report a problem
        7/21/2026Listing removed$1,500,000$463/sqft
        Source: FMLS GA #7772899 Report a problem
        7/14/2026Price change$1,500,000-1.8%$463/sqft
        Source: FMLS GA #7772899 Report a problem
        6/17/2026Price change$1,527,000-10.2%$471/sqft
        Source: FMLS GA #7772899 Report a problem
        5/27/2026Listed for sale$1,700,000+97.7%$524/sqft
        Source: FMLS GA #7772899 Report a problem
        4/6/2022Sold$860,000+11.8%$265/sqft
        Source: FMLS GA #7011085 Report a problem
        3/8/2022Pending sale$769,000$237/sqft
        Source: Harry Norman Realtors #7011085 Report a problem
        3/7/2022Contingent$769,000$237/sqft
        Source: FMLS GA #7011085 Report a problem
        3/3/2022Listed for sale$769,000+85.3%$237/sqft
        Source: GAMLS #10025787 Report a problem
        7/28/2017Sold$415,000-3.3%$128/sqft
        Source: FMLS GA #5843420 Report a problem
        6/29/2017Pending sale$429,000$132/sqft
        Source: VIRTUAL PROPERTIES REALTY BIZ #5843420 Report a problem
        6/11/2017Listing removed$2,650$1/sqft
        Source: VIRTUAL PROPERTIES REALTY.NET, LLC #5798595 Report a problem
        6/7/2017Listed for rent$2,650$1/sqft
        Source: VIRTUAL PROPERTIES REALTY.NET, LLC #5798595 Report a problem
        5/30/2017Price change$429,000-4.5%$132/sqft
        Source: VIRTUAL PROPERTIES REALTY BIZ #5843420 Report a problem
        5/4/2017Price change$449,000-6.4%$138/sqft
        Source: VIRTUAL PROPERTIES REALTY BIZ #5843420 Report a problem
        3/30/2017Price change$479,900-4%$148/sqft
        Source: Virtual Properties Realty. com #5811834 Report a problem
        3/19/2017Price change$500,000-3.7%$154/sqft
        Source: Virtual Properties Realty. com #5811834 Report a problem
        3/19/2017Listing removed$2,650$1/sqft
        Source: VIRTUAL PROPERTIES REALTY.NET, LLC #5798595 Report a problem
        3/3/2017Listed for sale$519,000+88.7%$160/sqft
        Source: Virtual Properties Realty. com #5811834 Report a problem
        2/11/2017Price change$2,650-7%$1/sqft
        Source: VIRTUAL PROPERTIES REALTY.NET, LLC #5798595 Report a problem
        1/29/2017Listed for rent$2,850$1/sqft
        Source: VIRTUAL PROPERTIES REALTY.NET, LLC #5798595 Report a problem
        9/11/2015Sold$275,000$85/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$7,038 +3.2%$372,680 +23%
        2024$6,821 +10.6%$302,880
        2023$6,166 +139.5%$302,880 +14.5%
        2022$2,574 +1.6%$264,520 +62.2%
        2021$2,535 -51.3%$163,120 -11.6%
        2020$5,208 +42.4%$184,520 +67.4%
        2019$3,657 $110,200 +2.4%
        2018$3,657 $107,640 -2.1%
        2017$3,657 -4.8%$110,000
        2016$3,842 +109.5%$110,000 +110.2%
        2015$1,834 +14.4%$52,320
        2014$1,604 $52,320
        2013-- $52,320
        2012$1,531 $52,320 -6.6%
        2011-- $56,000
        2010$1,626 $56,000 -7%
        2009-- $60,200
        2008-- $60,200 +5.5%
        2007$1,633 $57,040 +0.2%
        2005-- $56,920 +9.8%
        2004-- $51,840 +2.8%
        2003$1,545 $50,440 +7.2%
        2002-- $47,040 +31.5%
        2001$1,166 $35,760
        Find assessor info on the county website

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.
        Get pre-qualified

        Climate risks

        Neighborhood: Downtown

        Getting around

        58 / 100
        Somewhat Walkable
        26 / 100
        Some Transit
        48 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating
        Schools provided by the listing agent
        • Elementary: Alpharetta
        • Middle: Hopewell
        • High: Cambridge

        Source: FMLS GA. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes

              Nearby cities

              Nearby neighborhoods

              Nearby zip codes

              Other Alpharetta Topics

                Search
                Updates
                Favorites
                Plan
                Inbox