150 Mayfield Road, Alpharetta, GA 30009

About this home

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.

How this list price compares in Alpharetta

• List price is 88% above the Alpharetta median list price of $795,000 (671 homes).
• Compared with 380 single-family homes in Alpharetta: 57% above the median of $949,901.
• List price per square foot is 70% above the Alpharetta median of $272/SF.
• All 671 homes for sale in Alpharetta, GA.
• 6,734 homes for sale in Fulton County.

Figures are list prices from current FMLS IDX inventory (Active, Active Under Contract and Pending), not sales prices or appraisals.

Home facts

Property type

Single-family home

Status

Active

Bedrooms

4

Full baths

3

Half baths

1

Living area

3,242 SF

Lot size

0.51 acres

Year built

1949

Levels

Two

Main-level bedrooms

2

Garage spaces

2

Parking

Driveway, Garage, Garage Door Opener, Garage Faces Front, Level Driveway, On Street, Parking Pad

Basement

Daylight, Exterior Entry, Finished, Finished Bath, Full, Interior Entry

Style

Mid-Century Modern, Modern, Ranch

Construction

Brick 4 Sides

Roof

Composition, Metal, Shingle

Flooring

Hardwood, Luxury Vinyl, Tile

Heating

Forced Air, Natural Gas

Cooling

Ceiling Fan(s), Central Air

Fireplaces

2

Appliances

Dishwasher, Disposal, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Self Cleaning Oven

Lot

Back Yard, Corner Lot, Front Yard, Landscaped, Level

Community

Near Schools, Near Shopping, Near Trails/Greenway

HOA

No

Annual tax

$7,026 (2025)

County

Fulton

Assigned schools

• HighCambridge
• MiddleHopewell
• ElementaryAlpharetta

As reported in the listing. Verify with the school district.