Skip to content

Back to search

Listing Provided By Wendy Mullins with Atlanta Fine Homes Sotheby's International, 770-375-8689

  1. Photo 1 of 56, Alpharetta, GA 30009
  2. Photo 2 of 56, Alpharetta, GA 30009
  3. Photo 3 of 56, Alpharetta, GA 30009
  4. Photo 4 of 56, Alpharetta, GA 30009
  5. Photo 5 of 56, Alpharetta, GA 30009
  6. Photo 6 of 56, Alpharetta, GA 30009
  7. Photo 7 of 56, Alpharetta, GA 30009
  8. Photo 8 of 56, Alpharetta, GA 30009
  9. Photo 9 of 56, Alpharetta, GA 30009
  10. Photo 10 of 56, Alpharetta, GA 30009
  11. Photo 11 of 56, Alpharetta, GA 30009
  12. Photo 12 of 56, Alpharetta, GA 30009
  13. Photo 13 of 56, Alpharetta, GA 30009
  14. Photo 14 of 56, Alpharetta, GA 30009
  15. Photo 15 of 56, Alpharetta, GA 30009
  16. Photo 16 of 56, Alpharetta, GA 30009
  17. Photo 17 of 56, Alpharetta, GA 30009
  18. Photo 18 of 56, Alpharetta, GA 30009
  19. Photo 19 of 56, Alpharetta, GA 30009
  20. Photo 20 of 56, Alpharetta, GA 30009
  21. Photo 21 of 56, Alpharetta, GA 30009
  22. Photo 22 of 56, Alpharetta, GA 30009
  23. Photo 23 of 56, Alpharetta, GA 30009
  24. Photo 24 of 56, Alpharetta, GA 30009
  25. Photo 25 of 56, Alpharetta, GA 30009
  26. Photo 26 of 56, Alpharetta, GA 30009
  27. Photo 27 of 56, Alpharetta, GA 30009
  28. Photo 28 of 56, Alpharetta, GA 30009
  29. Photo 29 of 56, Alpharetta, GA 30009
  30. Photo 30 of 56, Alpharetta, GA 30009
  31. Photo 31 of 56, Alpharetta, GA 30009
  32. Photo 32 of 56, Alpharetta, GA 30009
  33. Photo 33 of 56, Alpharetta, GA 30009
  34. Photo 34 of 56, Alpharetta, GA 30009
  35. Photo 35 of 56, Alpharetta, GA 30009
  36. Photo 36 of 56, Alpharetta, GA 30009
  37. Photo 37 of 56, Alpharetta, GA 30009
  38. Photo 38 of 56, Alpharetta, GA 30009
  39. Photo 39 of 56, Alpharetta, GA 30009
  40. Photo 40 of 56, Alpharetta, GA 30009
  41. Photo 41 of 56, Alpharetta, GA 30009
  42. Photo 42 of 56, Alpharetta, GA 30009
  43. Photo 43 of 56, Alpharetta, GA 30009
  44. Photo 44 of 56, Alpharetta, GA 30009
  45. Photo 45 of 56, Alpharetta, GA 30009
  46. Photo 46 of 56, Alpharetta, GA 30009
  47. Photo 47 of 56, Alpharetta, GA 30009
  48. Photo 48 of 56, Alpharetta, GA 30009
  49. Photo 49 of 56, Alpharetta, GA 30009
  50. Photo 50 of 56, Alpharetta, GA 30009
  51. Photo 51 of 56, Alpharetta, GA 30009
  52. Photo 52 of 56, Alpharetta, GA 30009
  53. Photo 53 of 56, Alpharetta, GA 30009
  54. Photo 54 of 56, Alpharetta, GA 30009
  55. Photo 55 of 56, Alpharetta, GA 30009
  56. Photo 56 of 56, Alpharetta, GA 30009

Active

All 56 photos

Photos

Photo 1 of 56

Photo 1 of 56, Alpharetta, GA 30009

150 Mayfield Road

Alpharetta, GA 30009

$1,495,000

Beds
4
Baths
3 full, 1 half
Sq ft
3,242
Price per sq ft
$461
Year built
1949
Lot
0.51 acres
Garage
2 spaces

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.

Listed
Sep 1, 2026
Updated
Nov 7, 2026, 3:41 AM ET
Property type
Residential, Single Family Residence
Subdivision
None
FMLS #
7831707
County
Fulton - GA

Interior

Interior features
Beamed Ceilings, Crown Molding, Disappearing Attic Stairs, Double Vanity, High Speed Internet, His and Hers Closets, Recessed Lighting, Tray Ceiling(s), Vaulted Ceiling(s), Walk-In Closet(s)
Appliances
Dishwasher, Disposal, Electric Water Heater, Gas Oven, Gas Range, Microwave, Refrigerator, Self Cleaning Oven
Flooring
Hardwood, Luxury Vinyl, Tile
Fireplaces
2
Fireplace features
Electric, Family Room, Fire Pit, Gas Log, Gas Starter, Glass Doors
Basement
Daylight, Exterior Entry, Finished, Finished Bath, Full, Interior Entry
Cooling
Ceiling Fan(s), Central Air
Heating
Forced Air, Natural Gas
Laundry
Electric Dryer Hookup, Laundry Room, Main Level, Other
Kitchen
Breakfast Bar, Cabinets White, Kitchen Island, Pantry Walk-In, Second Kitchen, Stone Counters, View to Family Room
Primary bathroom
Double Vanity, Separate Tub/Shower, Soaking Tub
Levels
Two
Main-level bedrooms
2
Main-level bathrooms
2
Accessibility features
None
Windows
Double Pane Windows, Insulated Windows, Window Treatments

Exterior

Exterior features
Lighting, Rain Gutters, Rear Stairs, Storage
Patio and porch
Deck, Front Porch, Patio, Screened
Construction materials
Brick 4 Sides
Roof
Composition, Metal, Shingle
Fencing
None
Pool features
None
Private pool
No
Spa
None
View
Other
Waterfront
None
Foundation
Block, Slab

Lot & parking

Lot size (acres)
0.51
Lot dimensions
112x298x104x298
Lot features
Back Yard, Corner Lot, Front Yard, Landscaped, Level
Garage spaces
2
Parking
Driveway, Garage, Garage Door Opener, Garage Faces Front, Level Driveway, On Street, Parking Pad
Total parking spaces
3

Utilities

Sewer
Public Sewer
Water source
Public
Utilities
Electricity Available, Natural Gas Available, Phone Available, Underground Utilities, Water Available
Electric
110 Volts, Other
Energy efficiency
Insulation, Thermostat, Windows

HOA & taxes

Association
No
Annual tax amount
7026
Tax year
2025

Schools & community

Elementary school
Alpharetta
Middle school
Hopewell
High school
Cambridge
Subdivision
None
County
Fulton - GA
Community features
Near Schools, Near Shopping, Near Trails/Greenway

Construction

Architectural style
Mid-Century Modern, Modern, Ranch
Year built
1949
Property subtype
Single Family Residence
Condition
Resale
Building area (total)
3242
Above-grade finished area
3242

Location

Payment estimate

An estimate by Abbe Real Estate. It is not a loan offer, and it is not information from FMLS.

From the listing; you can change it.

Enter your own figure.

Enter the rate you expect.

For example, the term you plan to choose.

Enter a down payment, an interest rate and a loan term to see an estimate.

Questions about this home?

Your message goes to Abbe Real Estate. Abbe Real Estate is not the listing brokerage for this home.

Ask Abbe Real Estate about this home
What would you like?

By sending, you agree Abbe Real Estate may contact you by email or phone about this inquiry.

All photos (56)

  1. Photo 1 of 56, Alpharetta, GA 30009
  2. Photo 2 of 56, Alpharetta, GA 30009
  3. Photo 3 of 56, Alpharetta, GA 30009
  4. Photo 4 of 56, Alpharetta, GA 30009
  5. Photo 5 of 56, Alpharetta, GA 30009
  6. Photo 6 of 56, Alpharetta, GA 30009
  7. Photo 7 of 56, Alpharetta, GA 30009
  8. Photo 8 of 56, Alpharetta, GA 30009
  9. Photo 9 of 56, Alpharetta, GA 30009
  10. Photo 10 of 56, Alpharetta, GA 30009
  11. Photo 11 of 56, Alpharetta, GA 30009
  12. Photo 12 of 56, Alpharetta, GA 30009
  13. Photo 13 of 56, Alpharetta, GA 30009
  14. Photo 14 of 56, Alpharetta, GA 30009
  15. Photo 15 of 56, Alpharetta, GA 30009
  16. Photo 16 of 56, Alpharetta, GA 30009
  17. Photo 17 of 56, Alpharetta, GA 30009
  18. Photo 18 of 56, Alpharetta, GA 30009
  19. Photo 19 of 56, Alpharetta, GA 30009
  20. Photo 20 of 56, Alpharetta, GA 30009
  21. Photo 21 of 56, Alpharetta, GA 30009
  22. Photo 22 of 56, Alpharetta, GA 30009
  23. Photo 23 of 56, Alpharetta, GA 30009
  24. Photo 24 of 56, Alpharetta, GA 30009
  25. Photo 25 of 56, Alpharetta, GA 30009
  26. Photo 26 of 56, Alpharetta, GA 30009
  27. Photo 27 of 56, Alpharetta, GA 30009
  28. Photo 28 of 56, Alpharetta, GA 30009
  29. Photo 29 of 56, Alpharetta, GA 30009
  30. Photo 30 of 56, Alpharetta, GA 30009
  31. Photo 31 of 56, Alpharetta, GA 30009
  32. Photo 32 of 56, Alpharetta, GA 30009
  33. Photo 33 of 56, Alpharetta, GA 30009
  34. Photo 34 of 56, Alpharetta, GA 30009
  35. Photo 35 of 56, Alpharetta, GA 30009
  36. Photo 36 of 56, Alpharetta, GA 30009
  37. Photo 37 of 56, Alpharetta, GA 30009
  38. Photo 38 of 56, Alpharetta, GA 30009
  39. Photo 39 of 56, Alpharetta, GA 30009
  40. Photo 40 of 56, Alpharetta, GA 30009
  41. Photo 41 of 56, Alpharetta, GA 30009
  42. Photo 42 of 56, Alpharetta, GA 30009
  43. Photo 43 of 56, Alpharetta, GA 30009
  44. Photo 44 of 56, Alpharetta, GA 30009
  45. Photo 45 of 56, Alpharetta, GA 30009
  46. Photo 46 of 56, Alpharetta, GA 30009
  47. Photo 47 of 56, Alpharetta, GA 30009
  48. Photo 48 of 56, Alpharetta, GA 30009
  49. Photo 49 of 56, Alpharetta, GA 30009
  50. Photo 50 of 56, Alpharetta, GA 30009
  51. Photo 51 of 56, Alpharetta, GA 30009
  52. Photo 52 of 56, Alpharetta, GA 30009
  53. Photo 53 of 56, Alpharetta, GA 30009
  54. Photo 54 of 56, Alpharetta, GA 30009
  55. Photo 55 of 56, Alpharetta, GA 30009
  56. Photo 56 of 56, Alpharetta, GA 30009

Copyright 2026 First MLS. Listing content is believed accurate but not guaranteed.

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. 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 FMLS.

Abbe Real Estate

A trade name of Ryan Abbe Properties LLC

License #H-81887

13010 Morris Road, suite 650, Alpharetta, GA 30004

Office: (470) 383-3020

Listing search provided and supported by Ryan Abbe Properties LLC (Abbe Real Estate), ops@abberealestate.com, (470) 383-3020.

Report a data error

Equal Housing Opportunity. Abbe Real Estate supports the Fair Housing Act and equal housing opportunity for all.

Privacy notice

Terms of use

Listing data last updated Nov 7, 2026, 3:41 AM ET