NOT LISTED FOR SALE

15290 Freemanville Rd Alpharetta, GA 30004

Estimated Value: $1,544,000 - $1,645,000

5 Beds
4.5 Baths
4,195 Sq Ft
$384/Sq Ft Est. Value

Last Sold May 28, 2025

Last sale price $1,630,000 $389 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $8,942/month

5 Days on Market

Highlights

  • Guest House
  • Home Theater
  • Private Lot
  • Birmingham Falls Elementary School Rated A
  • Seasonal View
  • Living Room with Fireplace

About This Home

As of May 2025

Welcome to your dream modern farmhouse retreat, complete with a charming guest house! Nestled on over an acre of land, this custom-built home exudes unparalleled craftsmanship and luxurious finishes at every turn. The chef-inspired kitchen is a culinary masterpiece, featuring high-end Wolf commercial-grade appliances, including a range, beverage cooler, and Thermador refrigerator. With a farmhouse sink, marble countertops, and shiplap ceilings, the kitchen seamlessly blends modern style with timeless charm. The open-concept layout includes a spacious breakfast room, an elegant formal dining room, and a vaulted living room with a striking brick fireplace-ideal spaces for both intimate living and entertaining. Rich hardwood floors flow throughout the main level, including the office and private owner's suite, which boasts a spa-like bath and an expansive walk-in closet. Step outside to the covered, vaulted patio with a wood-burning fireplace, surrounded by serene nature-the perfect spot for relaxing or entertaining. Upstairs, you'll find three generously sized bedrooms and a media room for ultimate comfort and entertainment. The private guest house offers a full kitchen, family room, bedroom, and bath, making it a versatile space for an in-law suite, pool house, or guest accommodations. Additional features include a spacious 3-car garage and storage shed with electricity. Located close to White Columns Country Club, highly regarded schools, local parks, and the dining and shopping options in Crabapple and Alpharetta, this home offers a lifestyle of luxury and convenience.

Last Agent to Sell the Property

Courtney Benjamin

Harry Norman Realtors Brokerage Phone: License #391302 Listed on: 04/03/2025

Harry Norman Realtors

Last Buyer's Agent

Catherine Marshall

Ansley RE|Christie's Int'l RE License #348740

Ansley RE|Christie's Int'l RE

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $15,734

Year Built

  • Built in 2016

Lot Details

  • 1.1 Acre Lot
  • Back and Front Yard Fenced
  • Wood Fence
  • Private Lot
  • Level Lot

Home Design

  • Traditional Architecture
  • Brick Exterior Construction
  • Slab Foundation
  • Composition Roof

Interior Spaces

  • 4,195 Sq Ft Home
  • 2-Story Property
  • Beamed Ceilings
  • Tray Ceiling
  • Vaulted Ceiling
  • Gas Log Fireplace
  • Double Pane Windows
  • Living Room with Fireplace
  • 2 Fireplaces
  • Breakfast Room
  • Home Theater
  • Home Office
  • Bonus Room
  • Seasonal Views

Kitchen

  • Breakfast Bar
  • Double Oven
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Disposal

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • Walk-In Closet
  • Double Vanity

Laundry

  • Laundry in Mud Room
  • Laundry Room
  • Dryer
  • Washer

Home Security

  • Carbon Monoxide Detectors
  • Fire and Smoke Detector

Parking

  • 3 Car Garage
  • Parking Pad
  • Parking Accessed On Kitchen Level
  • Side or Rear Entrance to Parking
  • Garage Door Opener
  • Off-Street Parking

Eco-Friendly Details

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

Outdoor Features

  • Patio
  • Outdoor Fireplace
  • Shed

Additional Homes

  • Guest House

Schools

  • Birmingham Falls Elementary School
  • Northwestern Middle School
  • Cambridge High School

Utilities

  • Forced Air Heating System
  • Heat Pump System
  • Heating System Uses Natural Gas
  • 220 Volts
  • Gas Water Heater
  • Septic Tank
  • Phone Available
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Kemmerer Park Subdivision

Listing and Financial Details

  • Legal Lot and Block 1 / 3

Home Details

Home Type

Single Family

Est. Annual Taxes

$15,734

Year Built

Built in 2016

Lot Details

0

Listing Details

  • Property Type: Residential
  • District: 2
  • Year Built: 2016
  • ArchitecturalStyle: Traditional
  • Main Level Half Bathrooms: 1
  • Electric: 220 Volts
  • Financing Type: Conventional
  • GreenEnergyEfficient: Thermostat, Windows, Insulation, Appliances
  • Levels: Two
  • Lot Size Acres: 1.10
  • Other Sturctures: Guest House, Shed(s)
  • Property Sub-Type: Single Family Residence
  • Structure Type: House
  • Total Finished Area2: 4195
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 2

Interior Features

  • Appliances: Dishwasher, Disposal, Double Oven, Dryer, Gas Water Heater, Microwave, Refrigerator, Washer
  • Bedrooms: 5
  • Basement: None
  • Total Finished Sq Ft: 4195
  • Above Grade Finished Sq Ft: 4195
  • Interior Amenities: Beamed Ceilings, Double Vanity, Vaulted Ceiling(s), Tray Ceiling(s), Walk-In Closet(s)
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Fireplace Features: Gas Starter, Gas Log, Outside, Living Room
  • Flooring: Tile, Hardwood, Carpet
  • Kitchen Features: Breakfast Bar, Breakfast Room, Kitchen Island
  • Window Features: Double Pane Windows
  • Price Per Square Foot: 388.557

Beds/Baths

  • Main Level Full Bathrooms: 2
  • Upper Level Full Bathrooms: 2
  • Bedroom Main Level: 2

Exterior Features

  • Common Walls: No Common Walls
  • Construction Materials: Brick
  • ExteriorFeatures: Other
  • Fencing: Back Yard, Front Yard, Fenced, Wood
  • Foundation Details: Slab
  • Lot Features: Level, Private
  • Patio And Porch Features: Patio
  • Property Condition: Resale
  • Roof: Composition
  • View: Seasonal View

Garage/Parking

  • Parking Features: Garage, Garage Door Opener, Kitchen Level, Off Street, Parking Pad, Side/Rear Entrance
  • ParkingTotal: 3

Utilities

  • Cooling: Heat Pump
  • Heating: Forced Air, Natural Gas
  • Laundry Features: In Mud Room
  • Security Features: Carbon Monoxide Detector(s), Smoke Detector(s)
  • Sewer: Septic Tank
  • Utilities: Cable Available, Electricity Available, Natural Gas Available, Phone Available, Water Available
  • Water Source: Public

Condo/Co-op/Association

  • Association: No
  • Community Features: None

Fee Information

  • Association Fee Includes: None

Schools

  • Elementary School: Birmingham Falls
  • High School: Cambridge
  • High School Bus: Yes
  • Middle School: Northwestern
  • Middle School Bus: Yes
  • Elementary School: Birmingham Falls
  • Middle School: Northwestern
  • High School: Cambridge

Lot Info

  • Lot: 1
  • Deed Book: 64682
  • Deed Page: 86
  • Plat Book: 272
  • Plat Page: 68-71

Multi Family

  • Total Fireplaces: 2

Tax Info

  • Year: 2024
  • Tax Annual Amount: 15734

MLS Schools

  • Elementary Bus Line: Yes

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 3, 2025
Closed on
May 28, 2025
Sold by
Allen Sandy
Bought by
Turner William and Turner Kristi Hamelryck
Seller's Agent
Courtney Benjamin
Harry Norman Realtors
Buyer's Agent
Catherine Marshall
Ansley RE|Christie's Int'l RE
List Price
$1,650,000
Sold Price
$1,630,000
Premium/Discount to List
-$20,000
-1.21%
Views
75
Current Estimated Value
$1,609,916

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$20,084
Avg. Annual Appreciation
-4.49%
Original Mortgage
$1,304,000
Outstanding Balance
$1,300,619
Interest Rate
6.76%
Mortgage Type
New Conventional
Estimated Equity
$309,297

Purchase Details

Listed on
Sep 17, 2021
Closed on
Oct 19, 2021
Sold by
Miller Matthew Stuart
Bought by
Allen Mark and Allen Sandy
Seller's Agent
Home With Sherry Team
Compass
Buyer's Agent
Courtney Benjamin
Harry Norman REALTORS
List Price
$1,100,000
Sold Price
$1,300,000
Premium/Discount to List
$200,000
18.18%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.47%

Purchase Details

Listed on
Nov 26, 2018
Closed on
Jan 14, 2019
Sold by
Reinsel Michael
Bought by
Miller Matthew Stuart and Miller Chandler
Seller's Agent
Christina Reinsel
Mission Homes Realty
Buyer's Agent
Noel Schenck
BHGRE Metro Brokers
List Price
$825,000
Sold Price
$810,000
Premium/Discount to List
-$15,000
-1.82%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
18.70%
Original Mortgage
$484,350
Interest Rate
4.6%
Mortgage Type
New Conventional

Purchase Details

Closed on
Aug 17, 2016
Bought by
Reinsel Michael and Reinsel Christina

Purchase Details

Closed on
May 30, 2012
Sold by
Kemmerer Robin K
Bought by
Macinnis Brian
Source: Public Records

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Purchase History

Date Buyer Sale Price Title Company
Turner William $1,630,000 --
Allen Mark $1,300,000 --
Miller Matthew Stuart $810,000 --
Reinsel Michael -- --
Macinnis Brian $120,000 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Turner William $1,304,000
Previous Owner Miller Matthew Stuart $484,350
Previous Owner Miller Matthew Stuart $484,350
Previous Owner Reinsel Michael $525,700
Previous Owner Kemmerer Robin K $110,000
Previous Owner Kemmerer Sheila L $200,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/28/2025 05/28/25 Sold $1,630,000 -1.2% $389 / Sq Ft
04/08/2025 04/08/25 Pending -- -- --
04/03/2025 04/03/25 For Sale $1,650,000 +26.9% $393 / Sq Ft
10/19/2021 10/19/21 Sold $1,300,000 +18.2% $310 / Sq Ft
09/20/2021 09/20/21 Pending -- -- --
09/17/2021 09/17/21 For Sale $1,100,000 +35.8% $262 / Sq Ft
01/14/2019 01/14/19 Sold $810,000 -1.8% $193 / Sq Ft
12/03/2018 12/03/18 Pending -- -- --
11/26/2018 11/26/18 For Sale $825,000 +369.0% $197 / Sq Ft
08/25/2015 08/25/15 Sold $175,900 +0.6% $193 / Sq Ft
07/16/2015 07/16/15 Pending -- -- --
07/08/2015 07/08/15 For Sale $174,900 -- $192 / Sq Ft
Source: Georgia MLS

Tax History Compared to Growth

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 $2,858 $694,600 $92,520 $602,080
2023 $2,858 $564,280 $55,200 $509,080
2022 $10,630 $404,040 $75,360 $328,680
2021 $6,537 $240,960 $73,160 $167,800
2020 $6,353 $228,600 $47,760 $180,840
2019 $974 $224,600 $46,920 $177,680
2018 $5,538 $219,320 $45,840 $173,480
2017 $3,735 $161,200 $20,960 $140,240
2016 $2,053 $70,360 $27,160 $43,200
2015 $1,846 $54,240 $20,960 $33,280
2014 $1,663 $54,240 $20,960 $33,280
Source: Public Records

Agents Affiliated with this Home

  • Courtney Benjamin

    Seller's Agent in 2025

    Courtney Benjamin

    Harry Norman Realtors

    (954) 593-5400

    2 in this area

    92 Total Sales

    Courtney Benjamin
    Section Image
  • Catherine Marshall

    Buyer's Agent in 2025

    Catherine Marshall

    Ansley RE|Christie's Int'l RE

    (770) 314-9699

    9 in this area

    68 Total Sales

    Catherine Marshall
    Section Image

  • H

    Seller's Agent in 2021

    Home With Sherry Team

    Compass

    (678) 744-8206

    25 in this area

    444 Total Sales

    Home With Sherry Team
    Section Image
  • Christina Reinsel

    Seller's Agent in 2019

    Christina Reinsel

    Mission Homes Realty

    (770) 294-2942

    1 in this area

    47 Total Sales

    Christina Reinsel
    Section Image
  • Noel Schenck

    Buyer's Agent in 2019

    Noel Schenck

    Better Homes and Gardens Real Estate

    (678) 754-4401

    4 in this area

    26 Total Sales

    Noel Schenck
    Section Image
  • Reid Casey

    Seller's Agent in 2015

    Reid Casey

    Keller Williams North Atlanta

    (770) 560-4493

    80 in this area

    227 Total Sales

    Reid Casey
    Section Image
See All Agents

Map

Source: Georgia MLS

MLS Number: 10488543

Georgia MLS

APN: 22-4400-0527-101-2

Georgia Fulton County Alpharetta 30004

15290 Freemanville Rd, Alpharetta, GA

This home is located at 15290 Freemanville Rd, Alpharetta, GA 30004 since 03 April 2025 and is currently estimated at $1,609,916, approximately $383 per square foot. This property was built in 2016. 15290 Freemanville Rd is a home located in Fulton County with nearby schools including Birmingham Falls Elementary School, Northwestern Middle School, and Cambridge High School.

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.

Georgia MLS The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of Georgia MLS. Real estate listings held by brokerage firms other than Redfin are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. Information deemed reliable but not guaranteed. Copyright 2025 Georgia MLS. All rights reserved.

Nearby Homes