349 STONEHAVEN Drive, Mandeville, LA 70471
$698,000
Property Type:
Residential
Bedrooms:
5
Baths:
4
Square Footage:
3,883
Status:
Active
Current Price:
$698,000
List Date:
4/15/2026
Last Modified:
5/31/2026
Listing Details MLS# NO2552160
Listing Info
- Delayed Marketing
- No
- Listing Price
- 698000
- List Price/SqFt
- 203.97
- Type
- Single Family Residence
- Document Modified
- 2026-04-14 18:59:21.811450
- Modification Timestamp
- 2026-05-31T16:11:38Z
- Photo Modified
- 2026-05-31T16:11:11Z
Location Tax Legal Info
- Street Number
- 349
- Street Name
- STONEHAVEN Drive
- Parish
- St. Tammany
- State
- LA
- Zip Code
- 70471
- Subdivision
- Lochmere Est
- Tax Assessment Number
- 48622
- Directions
- Bounding Streets: Lochmere, Sharp Rd
General Property Description
- # Bedrooms
- 5
- Baths - Full
- 4
- Total Baths
- 4
- SqFt - Living
- 3422
- SqFt - Total
- 3883
- SqFt - Source
- Appraiser
- Stories
- 2
- Year Built
- 1995
- Acreage Range
- 0 - 0.5
- Assn Fee $
- 675
- Assn Fee Terms
- Yearly
- Lot Dimensions
- 100 x 200
Originating Details
- Originating System ID
- ROAMM
- Originating System Key
- 57702440
- Originating System Listing ID
- 2552160
- Originating System Name
- ROAM Matrix
Remarks & Misc
- Remarks
- Welcome to Lochmere Estates, one of Mandeville's best-kept secrets tucked away just off Sharp Road. Situated on a beautiful half-acre lot backing to peaceful greenspace and a pond, this spacious 5-bedroom home (or 4 bedrooms plus a dedicated office) offers the perfect combination of privacy, comfort, and convenience. Designed for both everyday living and entertaining, the home features an expansive living area filled with natural light, a cozy wood-burning fireplace, and a kitchen with granite countertops. Upstairs, two separate staircases lead to generously sized bedrooms with abundant closet space. Step outside to your own backyard retreat featuring an in-ground pool, hot tub, and electric pool chiller that helps keep the water comfortable even during the hottest summer months. One of the home's most valuable features is the whole-house generator, providing peace of mind and uninterrupted comfort during storms and power outages. Additional highlights include ample storage and a two-car garage. Located in Flood Zones B and C, this property offers scenic rear views, exceptional amenities, and a highly desirable location in the heart of Mandeville. Rarely does a home combine this level of privacy, outdoor enjoyment, and everyday practicality in one of the Northshore's most sought-after neighborhoods.
Office/Member/Contract Info
- List AOR
- NOMAR
More Information
Style
- Acadian
- Yes
Siding
- Vinyl Siding
- Yes
Parking
- Garage
- Yes
Equipment
- Generator
- Yes
Construction
- Brick
- Yes
Foundation
- Slab
- Yes
Patio
- Covered
- Yes
Fireplace
- Wood Burning
- Yes
Roof
- Other
- Yes
Cooling
- 2 or More Units
- Yes
Countertops
- Granite
- Yes
Rooms
- Bathroom 1
- Yes
- Bedroom 1
- Yes
- Dining Room
- Yes
- Foyer
- Yes
- Kitchen
- Yes
- Laundry
- Yes
- Living Room
- Yes
- Primary Bathroom
- Yes
- Primary Bedroom
- Yes
- Office
- Yes
- Bedroom 2
- Yes
- Bedroom 3
- Yes
- Bedroom 4
- Yes
- Bedroom 5
- Yes
- Bathroom 2
- Yes
- Bathroom 3
- Yes
- Bathroom 4
- Yes
- Bathroom 5
- Yes
- Bedroom 6
- Yes
- Bedroom 7
- Yes
- Bedroom 8
- Yes
Fencing
- Wood
- Yes
Pool
- Inground
- Yes
Property Features
Style:
Acadian
Siding:
Vinyl Siding
Parking:
Garage
Construction:
Brick
Foundation:
Slab
Roof:
Other
Fireplace:
Wood Burning
Cooling:
2 or More Units
Countertops:
Granite
Rooms:
Bathroom 1; Bedroom 1; Dining Room; Foyer; Kitchen; Laundry; Living Room; Office; Primary Bathroom; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bathroom 2; Bathroom 3; Bathroom 4; Bathroom 5; Bedroom 6; Bedroom 7; Bedroom 8
Equipment:
Generator
Fencing:
Wood
Patio:
Covered
Pool:
Inground
Room Information
| Room Name | Length | Width | Remarks |
|---|---|---|---|
| Bedroom 1 | 21.00 | 12.00 | Bedroom |
| Living Room | 21.90 | 20.70 | Living Room |
| Living Room | 21.90 | 20.70 | Living Room |
| Bedroom 2 | 17.60 | 19.00 | Bedroom |
| Primary Bedroom | 15.30 | 19.70 | Primary Bedroom |
| Primary Bedroom | 15.30 | 19.70 | Primary Bedroom |
| Kitchen | 12.00 | 14.30 | Kitchen |
| Kitchen | 12.00 | 14.30 | Kitchen |
| Bathroom 1 | 8.40 | 5.00 | Bathroom |
| Office | 12.00 | 13.30 | Office |
| Office | 12.00 | 13.30 | Office |
| Laundry | 11.00 | 6.00 | Laundry |
| Laundry | 11.00 | 6.00 | Laundry |
| Bathroom 2 | 8.20 | 5.00 | Bathroom |
| Bathroom 3 | 8.40 | 5.00 | Bathroom |
| Bathroom 4 | 4.11 | 8.40 | Bathroom |
| Dining Room | 12.30 | 13.30 | Dining Room |
| Dining Room | 12.30 | 13.30 | Dining Room |
| Bedroom 3 | 19.30 | 12.00 | Bedroom |
| Bedroom 4 | 12.00 | 13.30 | Bedroom |
| Foyer | 19.10 | 8.30 | Foyer |
| Foyer | 19.10 | 8.30 | Foyer |
| Bedroom 5 | 17.60 | 19.00 | Bedroom |
| Bedroom 6 | 19.30 | 12.00 | Bedroom |
| Primary Bathroom | 10.90 | 15.70 | Primary Bathroom |
| Primary Bathroom | 10.90 | 15.70 | Primary Bathroom |
| Bathroom 5 | 8.20 | 5.00 | Bathroom |
| Bedroom 7 | 12.00 | 13.30 | Bedroom |
| Bedroom 8 | 21.00 | 12.00 | Bedroom |
Documents
Property Disclosure ›
IDX
Listing Office:
Dempsey Rogers, Inc.
Last Updated: May - 31 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.