$3,800,000
NEW CONSTRUCTION

15154 Hopewell Rd Alpharetta, GA 30004

Estimated payment $21,118/month

Total Views 5,350
5 Beds
7 Baths
11,012 Sq Ft
$345 Price per Sq Ft

Highlights

  • Wine Cellar
  • Home Theater
  • New Construction
  • Summit Hill Elementary School Rated A
  • Pool and Spa
  • View of Trees or Woods

About This Home

Welcome to this stunning 11,000 sq ft luxury estate, boasting 7,369 sq ft of heated living space and masterfully designed to combine elegance, functionality, and high-end comfort. This extraordinary home features 5 spacious bedrooms, 5 full bathrooms, and 2 additional half baths, providing ample space for both privacy and entertaining.

Step into the heart of the home — a chef-inspired luxury kitchen with top-of-the-line appliances, premium finishes, and seamless flow into the living and dining areas. The attention to detail is unmatched, with intricate design elements and craftsmanship showcased throughout every room.

For the ultimate convenience, laundry rooms are located on each floor, making daily living a breeze. The expansive man cave offers the perfect retreat, complete with abundant storage and space to unwind.

Enjoy a fully finished mudroom with built-in storage and a dedicated dog wash station — ideal for busy families and pet lovers alike.

This home is thoughtfully designed for both relaxation and entertainment. Host guests in the custom wine room, take in a movie in your private theater, or unwind at the designer bar and adjacent lounge area. Dedicated spaces for a gym, salon, and recreational use ensure all your lifestyle needs are met.

The luxurious primary suite features a fully custom walk-in closet and an intended space for a future sauna — a perfect canvas for personalized wellness.

Listing Agent

Shundal Rodgers-Smith

HomeSmart License #244030 Listed on: 05/14/2025

HomeSmart

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $575

Year Built

  • Built in 2024 | New Construction

Lot Details

  • 2.28 Acre Lot
  • Landscaped
  • Cleared Lot
  • Private Yard
  • Back Yard

HOA Fees

  • Property has a Home Owners Association

Property Views

  • Woods
  • Neighborhood

Home Design

  • A-Frame Home
  • Brick Exterior Construction
  • Slab Foundation
  • Shingle Roof
  • Metal Roof
  • Lap Siding

Interior Spaces

  • 11,012 Sq Ft Home
  • 3-Story Property
  • Double Pane Windows
  • Insulated Windows
  • Aluminum Window Frames
  • Wine Cellar
  • Second Story Great Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • L-Shaped Dining Room
  • Home Theater
  • Loft
  • Home Gym
  • Wood Flooring
  • Fire and Smoke Detector
  • Finished Basement

Kitchen

  • Open to Family Room
  • Eat-In Kitchen
  • Breakfast Bar
  • Walk-In Pantry
  • Gas Oven
  • Microwave
  • Dishwasher
  • Stone Countertops
  • Wine Rack

Bedrooms and Bathrooms

  • 5 Bedrooms | 1 Primary Bedroom on Main
  • Dual Closets
  • Walk-In Closet
  • Dual Vanity Sinks in Primary Bathroom
  • Soaking Tub
  • Double Shower

Laundry

  • Laundry Room
  • Laundry on lower level

Parking

  • Attached Garage
  • Side Facing Garage

Eco-Friendly Details

  • Energy-Efficient Appliances
  • Energy-Efficient Windows
  • Energy-Efficient Lighting
  • Energy-Efficient Insulation
  • Energy-Efficient Thermostat

Pool

  • Pool and Spa
  • In Ground Pool

Outdoor Features

  • Balcony
  • Deck
  • Covered patio or porch
  • Outdoor Fireplace

Schools

  • Summit Hill Elementary School
  • Hopewell Middle School
  • Cambridge High School

Utilities

  • Central Heating and Cooling System
  • 220 Volts
  • 220 Volts in Garage
  • Septic Tank
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Assessor Parcel Number 22 488005340691

Community Details

Overview

  • Dog Trot Farms Subdivision

Amenities

  • Laundry Facilities

Home Details

Home Type

Single Family

Est. Annual Taxes

$575

Year Built

Built in 2024 | New Construction

Lot Details

0

HOA Fees

$83 per month

Listing Details

  • Standard Status: Active
  • Property Type: Residential
  • MLS Status: Active
  • Property Sub Type: Single Family Residence
  • Architectural Style: A-Frame
  • Property Condition: New Construction
  • Year Built: 2024
  • Levels Stories: Three Or More
  • Special Features: NewHome

Property Details

  • Property: Residential Detached

Interior Features

  • Flooring: Hardwood
  • Fireplace Features: Living Room, Outside
  • Number Of Fireplaces: 2
  • Appliances: Dishwasher, Gas Oven, Microwave, Refrigerator
  • Interior Amenities: His and Hers Closets, Walk-In Closet(s)
  • Basement: Finished
  • Kitchen Features: Breakfast Bar, Eat-in Kitchen, Pantry, Pantry Walk-In, Stone Counters, View to Family Room, Wine Rack
  • Common Walls: No Common Walls
  • Additional Rooms: Basement, Exercise Room, Great Room - 2 Story, Kitchen, Laundry, Loft, Media Room, Wine Cellar
  • Dining Room Features: Dining L
  • Square Footage: 11012.00
  • Spa Features: None
  • Window Features: Aluminum Frames, Double Pane Windows, Insulated Windows

Beds/Baths

  • Total Bedrooms: 5
  • Bedroom Features: Master on Main
  • Lower Bedrooms: 1
  • Main Bedrooms: 1
  • Total Bathrooms: 7
  • Total Full Baths: 5
  • Total Half Baths: 2
  • Lower Full Bathrooms: 1
  • Main Full Bathrooms: 1
  • Lower Half Bathrooms: 1
  • Main Half Bathrooms: 1
  • Master Bathroom Features: Double Shower, Double Vanity, Soaking Tub

Exterior Features

  • Construction Materials: Brick, Fiber Cement, Lap Siding
  • Roof Type: Metal, Shingle
  • Patio And Porch Features: Covered, Deck, Rear Porch, Side Porch
  • Exterior Features: Balcony, Private Yard
  • Pool Features: In Ground, Pool/Spa Combo
  • View: Neighborhood, Trees/Woods
  • Pool Private: No
  • Foundation: Slab

Garage/Parking

  • Parking Features: Attached, Garage Faces Side

Utilities

  • Sewer: Septic Tank
  • Water Source: Public
  • Security: Smoke Detector(s)
  • Cooling: Central Air
  • Heating: Central
  • Laundry Features: Common Area, Laundry Room, Lower Level, Upper Level
  • Utilities: Cable Available, Electricity Available, Water Available
  • Electric: 220 Volts, 220 Volts in Garage

Condo/Co-op/Association

  • Master Association Fee: 1000
  • Master Association Fee Frequency: Annually
  • Association: Yes
  • Home Warranty: Yes
  • Subdivision Complex: Dog Trot Farms

Schools

  • Elementary School: Summit Hill
  • Middle School: Hopewell
  • High School: Cambridge

Lot Info

  • Acres: 2.2760
  • Lot Features: Back Yard, Cleared, Landscaped
  • Lot Dimensions: x
  • Parcel Number: 22 488005340691
  • Horse Amenities: None
  • Land Lease: No
  • Property Attached Yn: No

Green Features

  • Efficiency: Appliances, Insulation, Lighting, Thermostat, Windows
  • Green Energy Generation: None

Tax Info

  • Taxes: 575.00
  • Assessor Parcel Number: 22-4880-0534-069-1
  • Tax Year: 2024

MLS Schools

  • Elementary School: Summit Hill
  • High School: Cambridge
  • Middle School: Hopewell

Map

Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $621 $22,000 $22,000 --
2023 $621 $22,000 $22,000 $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
06/10/2025 06/10/25 For Sale $3,800,000 +955.6% --
11/12/2021 11/12/21 Sold $360,000 0.0% --
10/13/2021 10/13/21 Pending -- -- --
07/29/2021 07/29/21 For Sale $360,000 -- --
Source: First Multiple Listing Service (FMLS)

Purchase History

Date Type Sale Price Title Company
Warranty Deed -- --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $2,229,040 New Conventional
Closed $1,408,000 New Conventional
Source: Public Records

Similar Homes in Alpharetta, GA

  • 316 S Esplanade, Alpharetta, GA 30009

    $3,390,000

    • 4 Beds
    • 4.5 Baths
    • 5,670 Sq Ft
    • 316 S Esplanade
    • Alpharetta, GA

    NEW PRICE!!! Courtyard Calm Meets Downtown Energy — and It’s Ready for a Quick Close!Now offered at $3,390,000, this stunning Grand Villa at 316 S. Esplanade blends modern sophistication with effortless charm—all in Avalon, the highly coveted, upscale community in the heart of Downtown Alpharetta.With designer finishes, wide-plank white oak floors, and move-in ready convenience,

    Rony Ghelerter HOME Real Estate, LLC

    Section Image
  • 4500 Candacraig, Alpharetta, GA 30022

    $2,995,000

    • 6 Beds
    • 6.5 Baths
    • 6,516 Sq Ft
    • 4500 Candacraig
    • Alpharetta, GA

    Stunning property in sought-after Cameron Crest Farms. This estate is truly one-of a kind on 5+/ acres with walking trail, pond, privacy among the trees and woods, lake front, gazebo and barn. The gated entrance leads to the tree line driveway and parking pad. Front porch opens to grand entrance foyer with stone flooring and spiral staircase. Large living room overlooks the park-like backyard.

    Bonneau Ansley Ansley Real Estate | Christie's International Real Estate

    Section Image
  • 15154 Hopewell Rd, Alpharetta, GA 30004

    $3,800,000

    • 5 Beds
    • 7 Baths
    • 15154 Hopewell Rd
    • Alpharetta, GA

    Welcome to this stunning 11,000 sq ft luxury estate, boasting 7,369 sq ft of heated living space and masterfully designed to combine elegance, functionality, and high-end comfort. This extraordinary home features 5 spacious bedrooms, 5 full bathrooms, and 2 additional half baths, providing ample space for both privacy and entertaining. Step into the heart of the home - a chef-inspired luxury

    Shundal Rodgers-Smith HomeSmart

    Section Image
  • 1960 Drummond Pond Rd, Alpharetta, GA 30004

    $3,250,000

    • 5 Beds
    • 5.5 Baths
    • 7,688 Sq Ft
    • 1960 Drummond Pond Rd
    • Alpharetta, GA

    Discover Unparalleled Luxury in the Coveted North Valley Community! Welcome to your dream home nestled on a stunning 2.42 acre private wooded lot in Milton's prestigious North Valley community. This exquisite residence has been meticulously renovated by Crownline Homes and offers an extraordinary living space featuring a timeless 4-sided brick structure with a beautiful cedar shake roof. As you

    Andrea Cueny Ansley RE|Christie's Int'l RE

    Section Image
  • 2785 Francis Rd, Alpharetta, GA 30004

    $3,200,000

    • 6 Beds
    • 7 Baths
    • 5,936 Sq Ft
    • 2785 Francis Rd
    • Alpharetta, GA

    Use 2785 Francis Road, Milton for project location. California zen modern masterpiece tucked away on the private enclave of 7 homes with a private lake in Brooke Hall in the heart of Milton. Design by Renown Wright Gardner Architect. Choose from our guild of qualified award-winning builders. A blend of the worlds best materials mixed with exquisite custom luxury interior fixtures, finishes and

    Mikel Muffley Weichert, Realtors - The Collective

    Section Image
  • 2425 Birmingham Rd, Alpharetta, GA 30004

    $3,500,000

    • 7 Beds
    • 4.5 Baths
    • 5,989 Sq Ft
    • 2425 Birmingham Rd
    • Alpharetta, GA

    Exceptional Value Opportunity! Spindlewick Farm is a one-of-a-kind equestrian estate that perfectly blends rustic charm with modern luxury, situated on nearly 10 acres of private, serene landscape in the highly desirable Milton/Alpharetta area. Originally built in 1986 as a replica farmhouse (per previous owner), this show stopping property underwent a meticulous renovation beginning in 2022 and

    Cynthia Steedle Serhant Georgia, LLC

    Section Image
  • 14870 E Bluff Rd, Alpharetta, GA 30004

    $3,650,000

    • 5 Beds
    • 7 Baths
    • 6,996 Sq Ft
    • 14870 E Bluff Rd
    • Alpharetta, GA

    Welcome to a rare offering in the coveted North Valley neighborhood of Milton — a picture-perfect whitewashed brick estate home nestled on nearly 5 acres of pristine land. This storybook property is the essence of charm, luxury, and serenity, where open pastures invite barefoot football games, tree climbing adventures, and twilight firefly chases.Thoughtfully designed and impeccably finished,

    Katie Reynolds Atlanta Fine Homes Sotheby's International

    Section Image
  • 14565 Hopewell Rd, Alpharetta, GA 30004

    $2,995,000

    • 5 Beds
    • 4.5 Baths
    • 7,800 Sq Ft
    • 14565 Hopewell Rd
    • Alpharetta, GA

    Welcome home! Rare opportunity to own 5.77+/- acres in sought-after Milton. This amazing property is a large sprawling home with all the bedrooms on the main level. The interior spans 6065+/- square feet on the main level, boasting 10-foot ceilings, Brazilian Cherry flooring, & extensive custom shelving. Key rooms include a library with decorative iron & glass doors, a great room with 25 ft

    Casey Schiltz Atlanta Fine Homes - Sotheby's Int'l

    Section Image
  • 1073 Kent Ct, Alpharetta, GA 30004

    $3,800,000

    • 6 Beds
    • 9 Baths
    • 10,000 Sq Ft
    • 1073 Kent Ct
    • Alpharetta, GA

    Located in Milton's The Manor Golf & Country Club on the 7th green, this spacious home includes inviting living spaces with exceptional finishes, 4 car garage, a pool with both spa & pool house as well as finished basement. Custom built by Loudermilk Homes, this brick and stone home impresses with a covered front entry opening to an inviting foyer with rich hardwood floors and an adjacent formal

    Jenny Doyle Atlanta Fine Homes Sotheby's International

    Section Image

Source: First Multiple Listing Service (FMLS)

MLS Number: 7579722

First Multiple Listing Service (FMLS)

APN: 22-4880-0534-069-1