NOT LISTED FOR SALE

174 Hunt Cir Madison, MS 39110

Estimated Value: $787,000 - $949,000

6 Beds
6 Baths
4,445 Sq Ft
$193/Sq Ft Est. Value

Last Sold June 30, 2025

Current estimated payment $4,890/month

79 Days on Market

Highlights

  • Private Pool
  • Wooded Lot
  • Fireplace
  • Madison Station Elementary School Rated A
  • Wood Flooring
  • 3 Car Attached Garage

About This Home

As of June 2025

A rare gem in Madison....
Welcome to 174 Hunt Circle, a stunning 4-acre estate offering everything you've dreamed of and more! With 6 spacious bedrooms, 4 full baths, and 2 half baths, this fully updated home is a true masterpiece. It boasts a brand-new pool, a serene pond, a large workshop, and ultra-premium appliances — all within the highly sought-after Madison School District and just minutes from shopping and dining.
Dont miss---
Gourmet Kitchen: Featuring gorgeous quartzite countertops, top-of-the-line Thermador appliances, a KitchenAid ice maker, a built-in microwave drawer, and a generous walk-in pantry. The beautiful breakfast nook is the perfect place to start your day. Open Living Spaces: The kitchen flows seamlessly into the living area, highlighted by a grand 20-ft stone fireplace. Additional living areas include a formal dining room, study, and an exercise room/home office. Main Floor Master Suite: Enjoy your own retreat with a cozy gas-log fireplace, a luxurious master bath with a large walk-in shower and soaking tub, plus access to a private screened porch leading to a dream deck and pool oasis. Upstairs Retreat: Upstairs features 2 bedrooms with a Jack-and-Jill bath, and an additional bedroom with its own private bath. A second set of stairs leads to 840 square feet of flexible living space — perfect for a media room, playroom, office, or studio. Outdoor Paradise: The 3/4-acre stocked pond with a gazebo and fishing deck creates a peaceful escape. The property also includes a workshop and is surrounded by lush greenery. Neighborhood Perks: The TCMBA Bike Trails, a hidden treasure for mountain biking enthusiasts, are nearby. This spectacular home is the perfect blend of luxury, privacy, and convenience. Don't miss the chance to experience it for yourself!

Last Agent to Sell the Property

Stephanie Remore

Keller Williams License #S45324 Listed on: 04/20/2025

Keller Williams

Last Buyer's Agent

Locke Ward

C H & Company Real Estate License #S27900

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,328

Year Built

  • Built in 1995

Lot Details

  • 4.07 Acre Lot
  • Wooded Lot
  • Many Trees

Parking

  • 3 Car Attached Garage

Home Design

  • Architectural Shingle Roof

Interior Spaces

  • 4,445 Sq Ft Home
  • 2-Story Property
  • Fireplace
  • Vinyl Clad Windows

Flooring

  • Wood
  • Carpet
  • Ceramic Tile

Bedrooms and Bathrooms

  • 6 Bedrooms

Outdoor Features

  • Private Pool
  • Slab Porch or Patio

Schools

  • Madison Station Elementary School
  • Madison Middle School
  • Madison Central High School

Utilities

  • Cooling Available
  • Heating Available

Listing and Financial Details

  • Assessor Parcel Number 071b-09-019-04-00

Community Details

Overview

  • Spring Brook Farms Subdivision

Recreation

  • Bike Trail

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,328

Year Built

Built in 1995

Lot Details

0

Parking

3

Listing Details

  • Unit Levels: Two
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Structure Type: House
  • Year Built: 1995
  • Lot Size Acres: 4.07
  • Subdivision Name: Spring Brook Farms
  • Garage Yn: Yes
  • New Construction: No
  • General Property Information:List PriceSqFt: 205.85
  • Special Features: None

Interior Features

  • Full Bathrooms: 4
  • Half Bathrooms: 2
  • Total Bedrooms: 6
  • Flooring: Ceramic Tile, Carpet, Hardwood
  • Window Features: Vinyl
  • Fireplace: Yes
  • Appliances: Cooktop, Disposal, Microwave, Dishwasher, Built-In Electric Oven, Built-In Refrigerator, Gas Cooktop
  • Bathroom Features: Double Vanity, Walk-In Shower, Free Standing Tub, Soaking Tub
  • Door Features: Double Entry
  • Fireplace Features: Bedroom, Den, Gas Log

Exterior Features

  • Lot Features: Wooded, Many Trees
  • Roof: Architectural Shingles
  • Patio And Porch Features: Screened, Patio, Slab
  • Pool Private: Yes
  • General Property Information:Accessibility Features: No
  • Foundation Details: Slab
  • Other Structures: Second Garage

Garage/Parking

  • Garage Spaces: 3.0
  • Attached Garage: Yes
  • Parking Features: Attached, Circular Driveway, Garage Door Opener, Garage, Garage Faces Side

Utilities

  • Sewer: Waste Treatment Plant
  • Water Source: Public
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Cooling: Ceiling Fan(s), Central Air, Ductless, Electric
  • Utilities: Cable Available, Electricity Connected, Natural Gas Connected, Water Connected
  • Laundry Features: Inside, Laundry Room, Lower Level, Sink

Condo/Co-op/Association

  • Community Features: Biking Trails

Schools

  • Elementary School: Madison Station
  • High School: Madison Central
  • Middle Or Junior School: Madison
  • Junior High Dist: Madison CO Dist

Lot Info

  • Parcel #: 071b-09-019-04-00
  • Lot Size Sq Ft: 177289.2

Tax Info

  • Tax Annual Amount: 4328.0
  • Tax Year: 2024

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 20, 2025
Closed on
Jun 30, 2025
Sold by
Burchett Brandon and Mccoy Jennifer
Bought by
Chandler James Kevin
Seller's Agent
Stephanie Remore
Keller Williams
Buyer's Agent
Locke Ward
C H & Company Real Estate
List Price
$915,000
Views
43
Current Estimated Value
$867,381

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.84%
Original Mortgage
$472,000
Outstanding Balance
$468,749
Interest Rate
6.01%
Mortgage Type
New Conventional
Estimated Equity
$387,272

Purchase Details

Listed on
May 24, 2022
Closed on
Jul 1, 2022
Sold by
Lane Adam C and Lane Ann Cayce
Bought by
Burchett Brandon and Mccoy Jennifer
Seller's Agent
Elizabeth Smith
Nix-Tann & Associates, Inc.
Buyer's Agent
Shellye Barnes
Front Gate Realty LLC

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-5.38%
Original Mortgage
$657,358
Interest Rate
5.25%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 10, 2014
Closed on
Jun 10, 2014
Sold by
Bank Of America Na
Bought by
Lane Adam C and Lane Cayce Ann
Seller's Agent
Lisa Bourgoyne
EXP Realty
Buyer's Agent
Chris Bond
Nix-Tann & Associates, Inc.
List Price
$489,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.41%
Original Mortgage
$485,650
Interest Rate
4.19%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jan 28, 2011
Sold by
Williams Earnestine A
Bought by
Bank Of America National Association

Purchase Details

Closed on
Jan 6, 2011
Sold by
Williams Earnestine A
Bought by
Bank Of America National Association

Purchase Details

Closed on
Sep 7, 2010
Sold by
Alexander Earnestine
Bought by
Dls Llc
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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

Purchase History

Date Buyer Sale Price Title Company
Chandler James Kevin -- None Listed On Document
Chandler James Kevin -- None Listed On Document
Burchett Brandon -- Maples & Richey Pllc
Lane Adam C -- Signature Title Llc
Bank Of America National Association $326,262 Landcastle Title Llc
Bank Of America National Association $326,262 None Available
Dls Llc -- Regency Title & Loan
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Chandler James Kevin $472,000
Closed Chandler James Kevin $472,000
Previous Owner Burchett Brandon $657,358
Previous Owner Lane Adam C $485,650
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/30/2025 06/30/25 Sold -- -- --
04/27/2025 04/27/25 Pending -- -- --
04/20/2025 04/20/25 For Sale $915,000 0.0% $206 / Sq Ft
04/03/2025 04/03/25 Pending -- -- --
03/26/2025 03/26/25 Price Changed $915,000 -1.1% $206 / Sq Ft
02/07/2025 02/07/25 Price Changed $925,000 -2.6% $208 / Sq Ft
02/07/2025 02/07/25 For Sale $949,900 +94.3% $214 / Sq Ft
07/01/2022 07/01/22 Sold -- -- -- View Prior Sale
07/01/2022 07/01/22 Off Market -- -- --
05/24/2022 05/24/22 Pending -- -- --
07/01/2014 07/01/14 Sold -- -- -- View Prior Sale
06/13/2014 06/13/14 Pending -- -- --
02/09/2014 02/09/14 For Sale $489,000 -- $114 / Sq Ft
Source: MLS United

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 $4,513 $46,143 $0 $0
2024 $4,328 $46,143 $0 $0
2023 $4,328 $46,143 $0 $0
2022 $4,236 $46,143 $0 $0
2021 $4,049 $44,239 $0 $0
2020 $4,049 $44,239 $0 $0
2019 $4,049 $44,239 $0 $0
2018 $3,785 $41,552 $0 $0
2017 $3,715 $40,844 $0 $0
2016 $3,552 $40,844 $0 $0
2015 $3,552 $40,844 $0 $0
2014 $5,407 $57,337 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Stephanie Remore

    Seller's Agent in 2025

    Stephanie Remore

    Keller Williams

    (601) 955-7176

    195 Total Sales

    Stephanie Remore
    Section Image
  • Locke Ward

    Buyer's Agent in 2025

    Locke Ward

    C H & Company Real Estate

    (601) 906-5577

    169 Total Sales

    Locke Ward
    Section Image
  • Elizabeth Smith

    Seller's Agent in 2022

    Elizabeth Smith

    Nix-Tann & Associates, Inc.

    (601) 506-4608

    20 Total Sales

    Elizabeth Smith
    Section Image

  • C

    Seller Co-Listing Agent in 2022

    Chris Bond

    Nix-Tann & Associates, Inc.

    (601) 672-7582

    19 Total Sales

    Chris Bond
    Section Image
  • Shellye Barnes

    Buyer's Agent in 2022

    Shellye Barnes

    Front Gate Realty LLC

    (601) 906-8442

    77 Total Sales

    Shellye Barnes
    Section Image

  • m

    Buyer's Agent in 2022

    mu.rets.5236

    mgc.rets.RETS_OFFICE

See All Agents

Map

Source: MLS United

MLS Number: 4103181

MLS United

APN: 071B-09-019-04-00

Mississippi Madison County Madison 39110

174 Hunt Cir, Madison, MS

Not Listed for Sale

Detached

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.

MLS United Information is deemed to be reliable but not guaranteed. Copyright 2026 MLS United, LLC.

Nearby Homes