Property Attributes
- MLS#4152750
- TypeSingle Family
- Listing Status Active
- ParishMadison
- CityMadison
- NeighborhoodTwin Cedars
- Zip39110
- StyleSingle Family Residence
- Year Built1998
- Taxes$ 3533
- Price$ 630,000
- Bedrooms4
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage3353
- Lot Size2.38 Acres
Data Source:
MLS United
Property 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!
| Elementary School | Middle School | High School |
|---|---|---|
| Madison Crossing Elementary School | Germantown Middle Middle School | Germantown High School |
| Price History | |
|---|---|
| 6/13/2026 | Listed $635,000 |
| 7/11/2026 | 1$630,000 |
General Features
| Property Subtype | Single Family Residence |
|---|---|
| Tax Year | 2025 |
| County | Madison |
| Property Type | Residential |
| HOA | true |
| Subdivision Name | Twin Cedars |
| Status | Active |
| City | Madison |
| Lot Size Units | Acres |
| Lot Size Square Feet | 103672.8 |
| Standard Status | Active |
| Heating | Fireplace(s),Natural Gas |
| Garage Spaces | 2 |
| Construction Materials | Brick |
| Year Built | 1998 |
| New Construction | false |
| Attached Garage | true |
| High School | Germantown |
| Elementary School | Madison Crossing |
| Middle/Junior High School | Germantown Middle |
| Sewer | Waste Treatment Plant |
| Patio/Porch Features | Front Porch |
| Community Features | Gated |
| Virtual Tour | https://www.propertypanorama.com/404-Locust-Cove-Madison-MS-39110/unbranded |
| Structure Type | House |
| Association Fee Includes | Maintenance Grounds,Management |
| Levels | Two |
| Utilities | Cable Available,Electricity Connected |
| Cooling | Ceiling Fan(s),Central Air |
| Roof | Architectural Shingles |
Interior Features
| Total Baths | 5 |
|---|---|
| Interior Amenities | Breakfast Bar,Ceiling Fan(s),Double Vanity,Entrance Foyer,His and Hers Closets,Kitchen Island,Pantry |
| Heating Y/N | true |
| Fireplace Features | Gas Log |
| Air Conditioning Y/N | true |
| Fireplace Y/N | true |
Exterior Features
| Lot Size Area | 2.38 |
|---|---|
| Lot Size Acres | 2.38 |
| Parking Features | Attached,Driveway,Garage Door Opener |
| Lot Features | Cul-De-Sac,Many Trees |
| Water Source | Public |
| Building Area Total | 3353 |
| Exterior Amenities | Private Yard,Rain Gutters |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Copyright © 2026 New Orleans Metropolitan Association of REALTORS®, Inc. All Rights Reserved. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real
MLS United® - All information deemed reliable but not guaranteed. All properties are subject to prior sale, change, or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.