0 of 30

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

$2,997,000

Listing Price

5beds

6baths

4,970sqft

31,184sqft lot

175 Andover Dr, Alpharetta, GA 30009

Member Features

Find Real Estate Bargain!

  • Full foreclosure details

  • Home value, equity and ownership info

  • Find homes priced below market

  • Get full access with a FREE Account

Already a member?

For Sale

Off Market

Single Family

Home type

603.02

Price / sqft

2025

Year built

Home Details

The Epitome of Alpharetta Luxury in the Garden District!nNot 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 Alpharettas 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 butlers 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 entertainers 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),

Interior Details

Square Feet
  • 4970

Bedrooms
  • 5

Bathrooms
  • 6

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Yes

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    N/A

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Gas

Basement
  • Has Basement:

    No

  • Basement Type:

    Partial

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 31184

Water
  • Yes

Sewer
  • Yes

Parking
  • Type:

    Garage, Basement

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    2

Deck
  • N/A

Patio
  • N/A

Fence
  • N/A

Pool
  • N/A

Porch
  • N/A

Stoop
  • N/A

Breezeway
  • N/A

Construction Details

Number of Stories
  • 2

Style
  • Conventional

Exterior
  • Stone

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • N/A

Tax History

Year

Amount

Land

Improvement

Percent Change

Assessment

2020

$2,411

$35,800

$103,720

--%

$139,520

2019

$2,105

$21,080

$124,520

--%

$145,600

2018

$3,001

$20,600

$121,600

--%

$142,200

2017

$2,281

$24,080

$74,520

--%

$98,600

2016

$2,268

$24,080

$74,520

--%

$98,600

2014

$1,593

$15,800

$48,920

--%

$64,720

2012

$1,547

$15,800

$48,920

--%

$64,720

2011

$1,835

$28,440

$49,440

--%

$77,880

percent-home-icon

Average Home Price in 30009

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$3,450,000

5 Beds

5 Baths

5,600 Sqft

15,071 Lot (sqft)

Sold 10/13/2026

$2,995,000

5 Beds

5 Baths

5,110 Sqft

18,905 Lot (sqft)

Sold 10/13/2026

$2,795,000

5 Beds

3 Baths

5,043 Sqft

17,998 Lot (sqft)

Sold 10/13/2026

$3,150,000

5 Beds

5 Baths

5,700 Sqft

17,998 Lot (sqft)

Sold 10/13/2026

$2,795,000

5 Beds

4 Baths

5,299 Sqft

18,025 Lot (sqft)

Sold 09/29/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
2,997,000
$
Down payment
599,400
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
17,982
$
HOA (Monthly)
0
$
PMI
0
$
$19,400
Your Payment
Total Monthly Payment:$19,400
Percent of Income:333%
Affordable:No

Details for 175 ANDOVER DR

Property Debt

Foreclosure Contact Details