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

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!

More Information MLS# 4103181

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

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.