Property Attributes
- MLS#2575711
- TypeSingle Family
- Listing Status Active
- ParishST CHARLES
- CityDestrehan
- NeighborhoodRed Church Estates
- Zip70047
- StyleTraditional
- Year Built1984
- Price$ 329,900
- Bedrooms4
- Full Bathrooms2
- Half Bathrooms1
- Sqr Footage2117
Data Source:
Gulf South Real Estate Information Network
Property Description
Tucked in a friendly Destrehan neighborhood, this well-maintained 4-bedroom, 2.5-bath home offers a rare blend of everyday comfort, space, and long-term savings. A 2021 roof gives the next owner peace of mind from day one. Step inside to durable laminate flooring throughout, updated bathrooms, and vaulted ceilings that give the living room an open, airy feel. The primary bath features a custom-tiled shower for a relaxing retreat at the end of the day. One of the standout features here is the owned solar system; no lease, no loan - which has kept the average Entergy bill at just $48.75. Meaningful savings for the next homeowner from day one. Out back, a detached flex building with its own window unit and half bath opens up options: home office, gym, studio, or guest space, whatever fits your life. Up front, a covered carport/patio area adds shaded outdoor living space for morning coffee or evening relaxing. With its location near Red Church Park and a layout that balances flexibility with charm, 400 Longwood Dr is ready to welcome its next owner!
| Price History | |
|---|---|
| 9/4/2026 | Listed $329,900 |
General Features
| Sewer | Public Sewer |
|---|---|
| Heating | Central |
| Cooling | Central Air,1 Unit |
| Roof | Shingle |
| Patio/Porch Features | Covered |
| Architectural Style | Traditional |
| Pool Features | None |
| Construction Materials | Brick Veneer,Vinyl Siding |
| Year Built | 1984 |
| Stories Count | 1 |
| Levels | One |
| Property Subtype | Detached |
| County | St Charles |
| Property Type | Residential |
| Subdivision Name | Red Church Estates |
| Other Structures | Other |
| Total Rooms | 10 |
| Full Baths | 2 |
| Status | Active |
| City | Destrehan |
| Carport Y/N | Yes |
| Property Condition | Very Good Condition |
| Standard Status | Active |
| Tax Lot | 322 |
| Property Sub Type Additional | Detached,Single Family Residence |
| PostalCity | Destrehan |
| Legal Description | LOT 322,RED CHURCH PLTN. ESTATES SUBD. |
Interior Features
| Fireplace Features | None |
|---|---|
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Half Baths | 1 |
| Total Bedrooms | 4 |
| LivingAreaSource | Measured |
Exterior Features
| Parking Features | Carport,Driveway |
|---|---|
| Lot Features | City Lot,Rectangular Lot |
| Water Source | Public |
| Foundation Details | Slab |
| Building Area Total | 2832 |
| Lot Dimensions | 60x100 |
Room Details
| Room | Dimensions | Level | Flooring | Details |
|---|---|---|---|---|
| Bathroom | Lower | Tile | ||
| Bedroom | Lower | Laminate,Simulated Wood | ||
| Bedroom | Lower | Carpet | ||
| Bedroom | Lower | Laminate,Simulated Wood | ||
| Bonus Room | Lower | |||
| Dining Room | Lower | Laminate,Simulated Wood | ||
| Kitchen | Lower | Laminate,Simulated Wood | ||
| Living Room | Lower | Laminate,Simulated Wood | ||
| Primary Bathroom | Lower | Tile | ||
| Primary Bedroom | Lower | Laminate,Simulated Wood |
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