Business HoursMon-Fri: 9PM-5PM | Sat: 9AM-1PM
Offices418 HWY 90 Waveland, MS 39576
$847,000
Madison, MS 39110
MLS# 4103181
Status: Closed
6 beds | 4445 sqft
1 / 76
Property 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!
Details
Maps
Documents
Address and Location Information
Parcel Number: 071b-09-019-04-00
Community Of: N/A
Street Number: 174
Street Name: Hunt
Street Suffix: Circle
County: Madison
State: MS
Zip Code: 39110
Subdivision: Spring Brook Farms
Listing Information
Listing Service: Full Service
Status: Closed
List Date: 2025-02-06
List Price: $915,000
Current Price: $847,000
General Property Information
New Construction: No
Approx Lot Size Acres: 4.07
SqFt Source: Appraiser
List Price/SqFt: 205.85
Year Built Source: Public Records
Garage Spaces: 3
Carport Spaces: 0
Total Floors: 2
Bathrooms Half: 2
Bathrooms Three Quarter: 0
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 Sub Type: Single Family Residence
Approx H/C SqFt: 4445
Year Built: 1995
Bedrooms Total: 6
Bathrooms Full: 4
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
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!
Status Change Info
Appraised SqFt: 4492
Sold Price/SqFt: 190.55
Contract Date/Pending Date: 2025-04-27
Closing Date: 2025-06-30
Structure Type
House: 1
Architectural Style
Georgian: 1
Lot Features
Many Trees: 1
Wooded: 1
Covenants And Restrictions
Restrictive Covenants: 1
Levels
Two: 1
Sewer
Waste Treatment Plant: 1
Water Source
Public: 1
Listing Terms
Cash: 1
Conventional: 1
FHA: 1
Showing Requirements
Showing: Appointment Required
Lockbox Location: Front Door
Interior Features
Bookcases: 1
Cathedral Ceiling(s): 1
Ceiling Fan(s): 1
Crown Molding: 1
Double Vanity: 1
Eat-in Kitchen: 1
Entrance Foyer: 1
High Ceilings: 1
His and Hers Closets: 1
Kitchen Island: 1
Open Floorplan: 1
Pantry: 1
Primary Downstairs: 1
Split Plan: 1
Utilities
Cable Available: 1
Electricity Connected: 1
Natural Gas Connected: 1
Water Connected: 1
Special Purpose Rooms
Breakfast Area: 1
Formal Dining Room: 1
Mud Room: 1
Recreation/Play Room: 1
Storage: 1
Kitchen Features
Kitchen Island: 1
Bathroom Features
Double Vanity: 1
Free Standing Tub: 1
Soaking Tub: 1
Walk-In Shower: 1
Fireplace Features
Bedroom: 1
Den: 1
Gas Log: 1
Appliances
Built-In Electric Oven: 1
Built-In Refrigerator: 1
Cooktop: 1
Dishwasher: 1
Disposal: 1
Gas Cooktop: 1
Microwave: 1
Walls - Interior
Sheetrock: 1
Flooring
Carpet: 1
Ceramic Tile: 1
Hardwood: 1
Window Features
Vinyl: 1
Door Features
Double Entry: 1
Laundry Features
Inside: 1
Laundry Room: 1
Lower Level: 1
Sink: 1
Cooling
Ceiling Fan(s): 1
Central Air: 1
Ductless: 1
Electric: 1
Heating
Central: 1
Fireplace(s): 1
Natural Gas: 1
Foundation Details
Slab: 1
Exterior Construction/Siding
Brick: 1
Roof
Architectural Shingles: 1
Exterior Features
Private Yard: 1
Patio And Porch Features
Patio: 1
Screened: 1
Slab: 1
Fencing
None: 1
Driveway Features
Circular Drive: 1
Concrete Drive: 1
Parking Features
Attached: 1
Circular Driveway: 1
Garage: 1
Garage Door Opener: 1
Garage Faces Side: 1
Other Structures
Second Garage: 1
Community Features
Biking Trails: 1
Pool Features
Gunite: 1
Outdoor Pool: 1
Room Type
Family Room: 1
Family Room Level: Main
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
Room Information
| Room Name | Level |
| Family Room | Main |
Property Condition Disclosure Statement 
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.
$847,000
Madison, MS 39110
MLS# 4103181
Status: Closed
6 beds | 4445 sqft
1 / 76
Property 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!
Details
Maps
Documents
Address and Location Information
Parcel Number: 071b-09-019-04-00
Community Of: N/A
Street Number: 174
Street Name: Hunt
Street Suffix: Circle
County: Madison
State: MS
Zip Code: 39110
Subdivision: Spring Brook Farms
Listing Information
Listing Service: Full Service
Status: Closed
List Date: 2025-02-06
List Price: $915,000
Current Price: $847,000
General Property Information
New Construction: No
Approx Lot Size Acres: 4.07
SqFt Source: Appraiser
List Price/SqFt: 205.85
Year Built Source: Public Records
Garage Spaces: 3
Carport Spaces: 0
Total Floors: 2
Bathrooms Half: 2
Bathrooms Three Quarter: 0
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 Sub Type: Single Family Residence
Approx H/C SqFt: 4445
Year Built: 1995
Bedrooms Total: 6
Bathrooms Full: 4
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
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!
Status Change Info
Appraised SqFt: 4492
Sold Price/SqFt: 190.55
Contract Date/Pending Date: 2025-04-27
Closing Date: 2025-06-30
Structure Type
House: 1
Architectural Style
Georgian: 1
Lot Features
Many Trees: 1
Wooded: 1
Covenants And Restrictions
Restrictive Covenants: 1
Levels
Two: 1
Sewer
Waste Treatment Plant: 1
Water Source
Public: 1
Listing Terms
Cash: 1
Conventional: 1
FHA: 1
Showing Requirements
Showing: Appointment Required
Lockbox Location: Front Door
Interior Features
Bookcases: 1
Cathedral Ceiling(s): 1
Ceiling Fan(s): 1
Crown Molding: 1
Double Vanity: 1
Eat-in Kitchen: 1
Entrance Foyer: 1
High Ceilings: 1
His and Hers Closets: 1
Kitchen Island: 1
Open Floorplan: 1
Pantry: 1
Primary Downstairs: 1
Split Plan: 1
Utilities
Cable Available: 1
Electricity Connected: 1
Natural Gas Connected: 1
Water Connected: 1
Special Purpose Rooms
Breakfast Area: 1
Formal Dining Room: 1
Mud Room: 1
Recreation/Play Room: 1
Storage: 1
Kitchen Features
Kitchen Island: 1
Bathroom Features
Double Vanity: 1
Free Standing Tub: 1
Soaking Tub: 1
Walk-In Shower: 1
Fireplace Features
Bedroom: 1
Den: 1
Gas Log: 1
Appliances
Built-In Electric Oven: 1
Built-In Refrigerator: 1
Cooktop: 1
Dishwasher: 1
Disposal: 1
Gas Cooktop: 1
Microwave: 1
Walls - Interior
Sheetrock: 1
Flooring
Carpet: 1
Ceramic Tile: 1
Hardwood: 1
Window Features
Vinyl: 1
Door Features
Double Entry: 1
Laundry Features
Inside: 1
Laundry Room: 1
Lower Level: 1
Sink: 1
Cooling
Ceiling Fan(s): 1
Central Air: 1
Ductless: 1
Electric: 1
Heating
Central: 1
Fireplace(s): 1
Natural Gas: 1
Foundation Details
Slab: 1
Exterior Construction/Siding
Brick: 1
Roof
Architectural Shingles: 1
Exterior Features
Private Yard: 1
Patio And Porch Features
Patio: 1
Screened: 1
Slab: 1
Fencing
None: 1
Driveway Features
Circular Drive: 1
Concrete Drive: 1
Parking Features
Attached: 1
Circular Driveway: 1
Garage: 1
Garage Door Opener: 1
Garage Faces Side: 1
Other Structures
Second Garage: 1
Community Features
Biking Trails: 1
Pool Features
Gunite: 1
Outdoor Pool: 1
Room Type
Family Room: 1
Family Room Level: Main
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
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 2022 MLS United, LLC.