Skip to main content

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.