5340 Drew Rd Alpharetta, GA 30004
Union Hill NeighborhoodEstimated payment $12,949/month
Highlights
- Water Views
- Barn
- Horse Property
- Free Home Elementary School Rated A-
- Stables
- Second Kitchen
About This Home
Set on 10 breathtaking pastoral acres, this exceptional equestrian estate offers a rare blend of luxury, functionality, and charm—truly everything you could need or want. The beautifully updated residence is both simple and elegant, featuring a sparkling pool and a fully equipped terrace-level in-law suite with private, stepless entry—ideal for guests or multigenerational living.
Equestrian enthusiasts will appreciate the impressive custom 10-stall show barn, thoughtfully designed with 12x12 stalls, an oversized tack room, spacious lounge, and a wash rack with both hot and cold water. The property is complete with a riding arena, round pen, and lush, established pastures boasting exceptional grass quality.
Entertain in style in the one-of-a-kind party barn, showcasing stunning custom woodwork, soaring vaulted ceilings, and a dramatic floor-to-ceiling stone fireplace. With both indoor and outdoor kitchens and a dedicated restroom, it’s the perfect setting for unforgettable gatherings.
A picturesque pond with a tranquil waterfall and inviting fire pit area adds to the property’s serene, storybook setting.
Turnkey and ready for its next chapter—this extraordinary estate invites you to live the lifestyle you’ve been dreaming of and create memories that will last a lifetime. Best Schools and amazing location. 30004 Zip Code with Cherokee County Taxes, Property being sold AS-IS with the right to inspect.
Listing Agent
Atlanta Fine Homes Sotheby's International Brokerage Phone: 770-826-8276 License #182516 Listed on: 04/20/2026
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $2,700
Year Built
- Built in 1989
Lot Details
- 10 Acre Lot
- Home fronts a pond
- Property fronts a county road
- Private Entrance
- Front Yard Fenced
- Landscaped
- Level Lot
Property Views
- Water
- Woods
- Rural
Home Design
- Craftsman Architecture
- Country Style Home
- Farmhouse Style Home
- Brick Foundation
- Composition Roof
- Four Sided Brick Exterior Elevation
Interior Spaces
- Bookcases
- Crown Molding
- Beamed Ceilings
- Vaulted Ceiling
- Ceiling Fan
- Double Pane Windows
- Insulated Windows
- Window Treatments
- Entrance Foyer
- Living Room with Fireplace
- Sitting Room
- Open-Concept Dining Room
- Dining Room Seats More Than Twelve
- Keeping Room with Fireplace
- 3 Fireplaces
Kitchen
- Country Kitchen
- Second Kitchen
- Breakfast Bar
- Double Oven
- Gas Cooktop
- Dishwasher
- Kitchen Island
- Stone Countertops
Flooring
- Wood
- Carpet
- Ceramic Tile
Bedrooms and Bathrooms
- 4 Bedrooms | 1 Primary Bedroom on Main
- Fireplace in Primary Bedroom
- Double Vanity
- Soaking Tub
- Bathtub With Separate Shower Stall
Laundry
- Laundry Room
- Laundry in Hall
- Laundry on main level
Finished Basement
- Walk-Out Basement
- Interior and Exterior Basement Entry
- Finished Basement Bathroom
- Natural lighting in basement
Home Security
- Security Gate
- Fire and Smoke Detector
Parking
- Detached Garage
- 6 Carport Spaces
- Driveway Level
- RV Access or Parking
Pool
- In Ground Pool
- Vinyl Pool
Outdoor Features
- Pond
- Horse Property
- Boarding Facilities
- Deck
- Covered Patio or Porch
- Outdoor Kitchen
- Separate Outdoor Workshop
- Outdoor Storage
- Outbuilding
Schools
- Free Home Elementary School
- Creekland - Cherokee Middle School
- Creekview High School
Farming
- Barn
- Farm
- Pasture
Horse Facilities and Amenities
- Round Pen
- Stables
- Arena
Utilities
- Forced Air Zoned Heating and Cooling System
- Underground Utilities
- 220 Volts
- Septic Tank
- Phone Available
- Cable TV Available
Listing and Financial Details
- Assessor Parcel Number 03N30 147
Community Details
Overview
- No Home Owners Association
- Equestrian Estate 10+Acres Subdivision
Amenities
- Laundry Facilities
Map
Home Values in the Area
Average Home Value in this Area
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 | $2,707 | $703,408 | $273,000 | $430,408 |
| 2024 | $6,047 | $599,728 | $235,600 | $364,128 |
| 2023 | $5,715 | $566,968 | $195,000 | $371,968 |
| 2022 | $4,262 | $459,968 | $195,000 | $264,968 |
| 2021 | $3,767 | $389,160 | $162,480 | $226,680 |
| 2020 | $3,978 | $396,200 | $162,480 | $233,720 |
| 2019 | $4,277 | $407,040 | $162,480 | $244,560 |
| 2018 | $4,307 | $403,240 | $162,480 | $240,760 |
| 2017 | $4,514 | $700,700 | $147,480 | $247,880 |
| 2016 | $4,286 | $668,600 | $122,480 | $240,120 |
| 2015 | $5,533 | $476,200 | $122,480 | $163,240 |
| 2014 | -- | $233,100 | $89,920 | $89,080 |
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 04/20/2026 04/20/26 | For Sale | $2,400,000 | +77.8% | $416 / Sq Ft | |
| 04/27/2015 04/27/15 | Sold | $1,350,000 | -3.6% | $220 / Sq Ft | View Prior Sale |
| 03/28/2015 03/28/15 | Pending | -- | -- | -- | |
| 02/12/2015 02/12/15 | For Sale | $1,400,000 | -- | $228 / Sq Ft |
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | -- | -- | |
| Limited Warranty Deed | $1,350,000 | -- | |
| Quit Claim Deed | -- | -- |
Source: First Multiple Listing Service (FMLS)
MLS Number: 7753499
APN: 003N30-00000-147-000-0000
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 visit www.fmls.com/dmca to review our DMCA policy and learn how to submit a takedown request. © 2026 First Multiple Listing Service, Inc.
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
- 4480 Indian Trace Dr
- 300 Arbor Green Ln
- 212 Silver Birch Ct
- 4645 Hamptons Dr
- 100 Hunting Valley Trail
- 4465 Mossbrook Cir
- 5055 Hamptons Club Dr
- 7610 Campground Rd
- 5085 Bristlecone Pine Way
- 5440 Bristlecone Pine Way
- 5170 Howard Rd
- 5510 Bristlecone Pine Way
- 5495 Lacebark Pine Ct
- 1209 County Line Rd
- 995 Freehome Rd
- 210 Little River Farms Trail
- 6645 Bentley Ridge Dr
- 949 Freehome Rd
- 108 Registry Ln
- 889 Freehome Rd
- 7675 Campground Rd Unit A
- 3595 Chastain Ct
- 3595 Chastain Ct
- 5150 Hyde Trail
- 2405 Mountain Rd
- 6797 Campground Rd
- 3040 Land Rd
- 5125 Staten Ln
- 5115 Staten Ln
- 5130 Franks Creek Way
- 6210 Pine Bluff Dr
- 7345 Samples Field Rd
- 3525 Moor Pointe Dr
- 7280 Samples Field Rd
- 3680 Moor Pointe Dr
- 510 Sable Walk Cir
- 6228 Lively Way
- 5450 Bridle Dr
- 2045 Kent Ct
- 1765 Horsham Trail
Ask me questions while you tour the home.