404 Locust Cove, Madison, MS 39110 (MLS# 4152750)

404 Locust Cove, Madison, MS 39110

New Listing

$635,000

Property Type: Residential Bedrooms: 4 Square Footage: 3,353 Lot Size (sq. ft.): 103,673 Status: Active

Current Price: $635,000 List Date: 6/13/2026 Last Modified: 6/16/2026

Description

Welcome to this truly amazing home located in a cul-de-sac on 2.38 beautiful wooded acres in the back of Twin Cedars. This home features 4 bedrooms, 4.5 baths, and large bonus room. Also featured are front and back porches, exposed brick, stainless steel appliances in the chef's kitchen, office space, large laundry room, and walk-in closets. This home has been recently painted and the upgrades are endless. If you are looking for privacy and a home that has it all, don't miss your opportunity to see this one. Call you favorite realtor for a tour!

More Information MLS# 4152750

Address and Location Information

Street Number: 404 Street Name: Locust Street Suffix: Cove County: Madison State: MS Zip Code: 39110 Parcel Number: 082h-34-048-00-00 PPIN: 23943 Subdivision: Twin Cedars Directions to Property: Hwy 51 to Twin Cedars entrance, drive down Twin Cedars Dr and take a right onto Quail Hollow, then left on Locust Cove. Home is on the left in culdesac. Community Of: N/A

Listing Information

Status: Active List Date: 2026-06-13 List Price: $635,000 Current Price: $635,000 Listing Service: Full Service

General Property Information

Property Sub Type: Single Family Residence New Construction: No Approx Lot Size Acres: 2.38 Approx H/C SqFt: 3353 SqFt Source: Appraiser List Price/SqFt: 189.38 Year Built Known: Yes Year Built: 1998 Year Built Source: Other Garage Spaces: 2 Total Floors: 2 Bedrooms Total: 4 Bathrooms Full: 4 Bathrooms Half: 1 Fireplace: Yes Fireplaces Total: 1 Pool: No School District: Madison CO Dist Elementary School: Madison Crossing Elementary School 2: N/A Intermediate School: N/A Middle or Junior School: Germantown Middle High School: Germantown Home Warranty: No Accessibility Features: No

Tax and Financial Information

Tax Annual Amount: 3533 Tax Year: 2025 Homestead Y/N: Yes Additional Exemptions Y/N: No Flood Insurance Required?: No Leasehold Y/N: No Association: Yes Covenants Y/N: Yes Legal Description: LOT 7 TWIN CEDARS BEING 2.38AC C@183

Showing Requirements

Showing: Appointment Required Lockbox Location: Front Door

Property Features

Structure Type: House Lot Features: Cul-De-Sac; Many Trees Levels: Two Covenants And Restrictions: Homeowner Association Association Fee Includes: Maintenance Grounds; Management Interior Features: Breakfast Bar; Ceiling Fan(s); Double Vanity; Entrance Foyer; His and Hers Closets; Kitchen Island; Pantry; Split Plan Special Purpose Rooms: Recreation/Play Room Bathroom Features: Double Vanity; Jetted Tub; Separate Tub & Shower; Two Walk-In Closets Fireplace Features: Gas Log Appliances: Built-In Gas Oven; Dishwasher; Disposal; Gas Cooktop; Microwave; Range Hood; Stainless Steel Appliance(s) Cooling: Ceiling Fan(s); Central Air Heating: Fireplace(s); Natural Gas Utilities: Cable Available; Electricity Connected Sewer: Waste Treatment Plant Water Source: Public Foundation Details: Slab Listing Terms: Bank Loan; Cash; Conventional; FHA; Other Roof: Architectural Shingles Patio And Porch Features: Front Porch; Patio - Covered Exterior Features: Private Yard; Rain Gutters Parking Features: Attached; Driveway; Garage; Garage Door Opener Community Features: Gated Showing Requirements: Use ShowingTime Service

Listing Office: Hopper Properties

Listing Agent: Allison Cauthen

Last Updated: June - 16 - 2026