Skip main navigation
Active
    • Price cut: $27K (7/14)
    $1,500,000

    150 Mayfield Rd, Alpharetta, GA 30009

    4beds
    3,242sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence, Residential
    Built in 1949
    0.51 Acres Lot
    $1,441,700 Zestimate®
    $463/sqft
    $-- HOA

    What's special

    Designer finishesTrex deckingLow-voltage lightingElevated tile installationsGrilling areaExtensively renovated homeCurated upgrades
    Perfectly positioned in the heart of Downtown Alpharetta, this extensively renovated home offers something genuinely rare, elevated design and a lifestyle that feels effortlessly connected to everything people love about the city. Over $500,000 in recent renovations transformed the home from the inside out, adding a substantial addition and curated upgrades that hit every mark. Designer finishes, elevated tile installations, and grasscloth-inspired custom closet cabinetry by Artisan bring a quiet sense of luxury to everyday living. And two primary suites on the main level, a feature uncommon to find, provide space and privacy. The redesigned layout flows naturally from intimate to expansive, equally suited for quiet mornings and full-house gatherings. Dual laundry areas and a widened driveway with additional access from Upshaw Drive add the kind of practical elegance that makes a home livable. The terrace level functions as a world of its own with a secondary kitchen, two additional bedrooms, and a private bath, creating a seamless option for extended guests, multigenerational living, or flexible entertaining space. Step outside, and the home only gets better. An expansive screened porch with cedar ceilings, Trex decking, a fireplace, grilling area, built-in bar, and wine fridge create the perfect setting to entertain long after dinner ends. Flagstone paths, a gas fire feature, privacy landscaping, and low-voltage lighting transform the backyard into a private retreat, remarkable for a home this close to the pulse of the city. And that walkability is the final piece. A short stroll separates you from Friday night concerts, the Alpharetta Farmers Market, brunch spots, and local favorites that make Downtown Alpharetta worth living in. This is living at its absolute best - polished, walkable, welcoming, and designed for the way people actually want to live.
    50 days
    |
    2,236
    |
    119
    |

    Likely to sell faster than

    Zillow last checked:

    Listing updated:

    Listed by:

    Wendy Mullins,

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

    Source: FMLS GA,MLS#: 7772899MLS Logo

    Loading...

      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, No Dock
      • 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,Ranch
      • Property subtype: Single Family Residence, Residential
      Materials
      • Brick 4 Sides
      • Foundation: Block, Slab
      • Roof: Composition,Metal,Shingle
      Condition
      • Updated/Remodeled
      • 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: $463/sqft
      • Tax assessed value: $757,200
      • Annual tax amount: $7,026
      • Date on market: 5/27/2026
      • Cumulative days on market: 44 days
      • Electric utility on property: Yes
      • Road surface type: Asphalt, Paved

        Estimated market value

        $1,441,700

        $1.37M - $1.51M

        $5,764/mo

        Price history

        DateEventPrice
        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
        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.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        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