174 Hunt Circle, Madison, MS 39110 (MLS# 4103181)
174 Hunt Circle, Madison, MS 39110
$847,000
Property Type:
Residential
Bedrooms:
6
Square Footage:
4,445
Lot Size (sq. ft.):
177,289
Status:
Closed
Current Price:
$847,000
List Date:
4/20/2025
Last Modified:
7/01/2025
Overview
Description
...
(Read more)
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!
Listing Details MLS# 4103181
General Property Information
- Property Sub Type
- Single Family Residence
- New Construction
- No
- Approx Lot Size Acres
- 4.07
- Approx H/C SqFt
- 4445
- SqFt Source
- Appraiser
- List Price/SqFt
- 205.85
- Year Built
- 1995
- Year Built Source
- Public Records
- Garage Spaces
- 3
- Total Floors
- 2
- Bedrooms Total
- 6
- Bathrooms Full
- 4
- Bathrooms Half
- 2
- Fireplace
- Yes
- Fireplaces Total
- 2
- Pool
- Yes
- School District
- Madison CO Dist
- Elementary School
- Madison Station
- Elementary School 2
- N/A
- Intermediate School
- N/A
- Middle or Junior School
- Madison
- High School
- Madison Central
- Home Warranty
- No
- Accessibility Features
- No
Property Features
Structure Type:
House
Architectural Style:
Georgian
Lot Features:
Many Trees; Wooded
Levels:
Two
Covenants And Restrictions:
Restrictive Covenants
Interior Features:
Bookcases; Cathedral Ceiling(s); Ceiling Fan(s); Crown Molding; Double Vanity; Eat-in Kitchen; Entrance Foyer; High Ceilings; His and Hers Closets; Kitchen Island; Open Floorplan; Pantry; Primary Downstairs; Split Plan
Special Purpose Rooms:
Breakfast Area; Formal Dining Room; Mud Room; Recreation/Play Room; Storage
Kitchen Features:
Kitchen Island
Bathroom Features:
Double Vanity; Free Standing Tub; Soaking Tub; Walk-In Shower
Fireplace Features:
Bedroom; Den; Gas Log
Appliances:
Built-In Electric Oven; Built-In Refrigerator; Cooktop; Dishwasher; Disposal; Gas Cooktop; Microwave
Walls - Interior:
Sheetrock
Flooring:
Carpet; Ceramic Tile; Hardwood
Window Features:
Vinyl
Door Features:
Double Entry
Laundry Features:
Inside; Laundry Room; Lower Level; Sink
Cooling:
Ceiling Fan(s); Central Air; Ductless; Electric
Heating:
Central; Fireplace(s); Natural Gas
Utilities:
Cable Available; Electricity Connected; Natural Gas Connected; Water Connected
Sewer:
Waste Treatment Plant
Water Source:
Public
Foundation Details:
Slab
Listing Terms:
Cash; Conventional; FHA
Roof:
Architectural Shingles
Patio And Porch Features:
Patio; Screened; Slab
Exterior Features:
Private Yard
Fencing:
None
Driveway Features:
Circular Drive; Concrete Drive
Parking Features:
Attached; Circular Driveway; Garage; Garage Door Opener; Garage Faces Side
Other Structures:
Second Garage
Community Features:
Biking Trails
Pool Features:
Gunite; Outdoor Pool
Room Type:
Family Room
Address and Location Information
- Street Number
- 174
- Street Name
- Hunt
- Street Suffix
- Circle
- County
- Madison
- State
- MS
- Zip Code
- 39110
- Parcel Number
- 071b-09-019-04-00
- Subdivision
- Spring Brook Farms
- Community Of
- N/A
Listing Information
- Listing Service
- Full Service
Tax and Financial Information
- Tax Annual Amount
- 4328
- Tax Year
- 2024
- Homestead Y/N
- Yes
- Homestead Year
- 2023
- Additional Exemptions Y/N
- No
- Flood Insurance Required?
- No
- Leasehold Y/N
- No
- Association
- No
- Covenants Y/N
- Yes
- Legal Description
- LOT 23 SPRING BROOK FARM -4.07AC- B@76
Status Change Info
- Contract Date/Pending Date
- 2025-04-27
- Closing Date
- 2025-06-30
- Appraised SqFt
- 4492
- Sold Price/SqFt
- 190.55
More Information
Showing Requirements
- Showing
- Appointment Required
- Lockbox Location
- Front Door
Room Type
- Family Room Level
- Main
Room Information
| Room Name | Level |
|---|---|
| Family Room | Main |
Listing Office:
Keller Williams
Listing Agent:
Stephanie Remore

Last Updated: July - 01 - 2025
Information is deemed to be reliable but not guaranteed. Copyright 2026 MLS United, LLC.
Property Condition Disclosure Statement ›