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/13/2026
Overview
Description
Listing Details MLS# 4152750
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
- Yes
- Fireplace
- Yes
- Fireplaces Total
- Yes
- 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
- Carport Spaces
- 0
- Bathrooms Three Quarter
- 0
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
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
- Listing Service
- Full Service
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
- Use ShowingTime Service
- Yes
More Information
Remarks & Miscellaneous
- Public Remarks
- 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!
Structure Type
- House
- Yes
Lot Features
- Cul-De-Sac
- Yes
- Many Trees
- Yes
Covenants And Restrictions
- Homeowner Association
- Yes
Levels
- Two
- Yes
Sewer
- Waste Treatment Plant
- Yes
Water Source
- Public
- Yes
Listing Terms
- Bank Loan
- Yes
- Cash
- Yes
- Conventional
- Yes
- FHA
- Yes
- Other
- Yes
Association Fee Includes
- Maintenance Grounds
- Yes
- Management
- Yes
Interior Features
- Breakfast Bar
- Yes
- Ceiling Fan(s)
- Yes
- Double Vanity
- Yes
- Entrance Foyer
- Yes
- His and Hers Closets
- Yes
- Kitchen Island
- Yes
- Pantry
- Yes
- Split Plan
- Yes
Utilities
- Cable Available
- Yes
- Electricity Connected
- Yes
Special Purpose Rooms
- Recreation/Play Room
- Yes
Bathroom Features
- Double Vanity
- Yes
- Jetted Tub
- Yes
- Separate Tub & Shower
- Yes
- Two Walk-In Closets
- Yes
Fireplace Features
- Gas Log
- Yes
Appliances
- Built-In Gas Oven
- Yes
- Dishwasher
- Yes
- Disposal
- Yes
- Gas Cooktop
- Yes
- Microwave
- Yes
- Range Hood
- Yes
- Stainless Steel Appliance(s)
- Yes
Cooling
- Ceiling Fan(s)
- Yes
- Central Air
- Yes
Heating
- Fireplace(s)
- Yes
- Natural Gas
- Yes
Foundation Details
- Slab
- Yes
Exterior Construction/Siding
- Brick
- Yes
Roof
- Architectural Shingles
- Yes
Exterior Features
- Private Yard
- Yes
- Rain Gutters
- Yes
Patio And Porch Features
- Front Porch
- Yes
- Patio - Covered
- Yes
Parking Features
- Attached
- Yes
- Driveway
- Yes
- Garage
- Yes
- Garage Door Opener
- Yes
Community Features
- Gated
- Yes
Listing Office:
Hopper Properties
Listing Agent:
Allison Cauthen
Last Updated: June - 13 - 2026
Information is deemed to be reliable but not guaranteed. Copyright 2022 MLS United, LLC.