Coldwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Realty

Property view
Listing view 2
Listing view 3

175 Andover, 
Alpharetta, GA 30009

$3,097,000


5

Beds


7

Baths


4,970

Sq Ft


Single Family

Active

Listed by

Bonnie Majher

Atlanta Fine Homes Sotheby'S International

Last updated:

August 12, 2026, 01:37 PM

MLS#

7780248

Source:

FIRSTMLS

About This Home

175 Andover

The Epitome of Alpharetta Luxury in the Garden District! Not all homes are built the same. Rosen Custom Homes has been setting the luxury trend for over 25 years! Alluring, clean-line transitional design that meets exceptional craftsmanship in this 4-sided brick new construction estate, perfectly situated on a rare, non-HOA .71± level acre lot in Downtown Alpharetta’s highly desirable Andover neighborhood. Flooded with natural light, the home boasts expansive 8’ high all-metal windows and seamless indoor-outdoor transitions. An arched entrance opens to a dramatic two-story foyer, a formal dining room, and a premium butler’s pantry (wet bar, ice maker, beverage cooler). At the heart of the home, a vaulted two-story great room features a floor-to-ceiling stucco fireplace and 10’ high sliding glass doors. The culinary kitchen is an entertainer’s dream: custom beaded inset cabinetry, a massive quartzite island, Wolf 48” dual-fuel range with a hidden designer vent, and a 48” Sub-Zero fridge. A hidden walk-in pantry leads AND a full scullery (second fridge, sink, dishwasher, microwave) for effortless hosting. The breakfast room opens to a spectacular vaulted, auto-screened lanai with skylights, a fireside sitting area, and a built-in outdoor kitchen overlooking the private, level backyard—complete with a dedicated outdoor pool bath. Executive features include a main-level office, a mudroom with custom lockers, a marble feature-wall powder room, and dual primary suites (one on each level), both boasting spa-like retreats with soaking tubs, Kohler Anthem showers, and expansive walk-in closets. Upstairs there are three additional ensuite bedrooms with designer tile. A 2nd full size laundry room is offers ease of use. Ask me why we are considered a "healthy home". Experience ultimate privacy & quality built home just steps from the vibrant shopping, dining, and arts of Downtown Alpharetta. (Note: Some exterior photos digitally enhanced).

Home Facts

Single Family

7 Baths

5 Bedrooms

Built in 2026

Subdivision & Development:

Garden District

Price Summary

3,097,000

$623 per Sq. Ft.

MLS #:

7780248

Last Updated:

August 12, 2026, 01:37 PM


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

7

Full Bathrooms:

6

Interior

Living Area:

4,970 Sq. Ft.


Structure

Structure

Architectural Style:

Traditional

Building Area:

4,970 Sq. Ft.

Year Built:

2026


Lot

Lot Size (Sq. Ft):

31,188


Finances & Disclosures

Finances

Price:

$3,097,000

Price per Sq. Ft:

$623 per Sq. Ft.

MLS Logo
Listings identified with the FMLS IDX logo come from FMLS and are 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 (https://www.fmls.com/dmca) to review our DMCA policy and learn how to submit a takedown request. ©2026 First Multiple Listing Service, Inc.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.