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:
$915,000
List Date:
4/20/2025
Last Modified:
7/01/2025
Overview
Description
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
- Carport Spaces
- 0
- Bathrooms Three Quarter
- 0
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
- Family Room
- Yes
Remarks & Miscellaneous
- Public Remarks
- 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!
Structure Type
- House
- Yes
Architectural Style
- Georgian
- Yes
Lot Features
- Many Trees
- Yes
- Wooded
- Yes
Covenants And Restrictions
- Restrictive Covenants
- Yes
Levels
- Two
- Yes
Sewer
- Waste Treatment Plant
- Yes
Water Source
- Public
- Yes
Listing Terms
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
Interior Features
- Bookcases
- Yes
- Cathedral Ceiling(s)
- Yes
- Ceiling Fan(s)
- Yes
- Crown Molding
- Yes
- Double Vanity
- Yes
- Eat-in Kitchen
- Yes
- Entrance Foyer
- Yes
- High Ceilings
- Yes
- His and Hers Closets
- Yes
- Kitchen Island
- Yes
- Open Floorplan
- Yes
- Pantry
- Yes
- Primary Downstairs
- Yes
- Split Plan
- Yes
Utilities
- Cable Available
- Yes
- Electricity Connected
- Yes
- Natural Gas Connected
- Yes
- Water Connected
- Yes
Special Purpose Rooms
- Breakfast Area
- Yes
- Formal Dining Room
- Yes
- Mud Room
- Yes
- Recreation/Play Room
- Yes
- Storage
- Yes
Kitchen Features
- Kitchen Island
- Yes
Bathroom Features
- Double Vanity
- Yes
- Free Standing Tub
- Yes
- Soaking Tub
- Yes
- Walk-In Shower
- Yes
Fireplace Features
- Bedroom
- Yes
- Den
- Yes
- Gas Log
- Yes
Appliances
- Built-In Electric Oven
- Yes
- Built-In Refrigerator
- Yes
- Cooktop
- Yes
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Microwave
- Yes
Walls - Interior
- Sheetrock
- Yes
Flooring
- Carpet
- Yes
- Ceramic Tile
- Yes
- Hardwood
- Yes
Window Features
- Vinyl
- Yes
Door Features
- Double Entry
- Yes
Laundry Features
- Inside
- Yes
- Laundry Room
- Yes
- Lower Level
- Yes
- Sink
- Yes
Cooling
- Ceiling Fan(s)
- Yes
- Central Air
- Yes
- Ductless
- Yes
- Electric
- Yes
Heating
- Central
- Yes
- Fireplace(s)
- Yes
- Natural Gas
- Yes
Foundation Details
- Slab
- Yes
Exterior Construction/Siding
- Brick
- Yes
Roof
- Architectural Shingles
- Yes
Exterior Features
- Private Yard
- Yes
Patio And Porch Features
- Patio
- Yes
- Screened
- Yes
- Slab
- Yes
Fencing
- None
- Yes
Driveway Features
- Circular Drive
- Yes
- Concrete Drive
- Yes
Parking Features
- Attached
- Yes
- Circular Driveway
- Yes
- Garage
- Yes
- Garage Door Opener
- Yes
- Garage Faces Side
- Yes
Other Structures
- Second Garage
- Yes
Community Features
- Biking Trails
- Yes
Pool Features
- Gunite
- Yes
- Outdoor Pool
- Yes
Room Information
Family Room
Level: Main
Listing Office:
Keller Williams
Listing Agent:
Stephanie Remore
Last Updated: July - 01 - 2025
Information is deemed to be reliable but not guaranteed. Copyright 2022 MLS United, LLC.
Property Condition Disclosure Statement ›