$698,000
Mandeville, LA 70471
MLS# NO2552160
5 beds | 4 baths | 3883 sqft
1 / 31
Property Description
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.
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 203.97
Document Modified: 2026-04-14 18:59:21.811450
Status: Active
Listing Date: 2026-04-15
Listing Price: 698000
Current Price: $698,000
Type: Single Family Residence
Modification Timestamp: 2026-05-31T16:11:38Z
Photo Modified: 2026-05-31T16:11:11Z
General Property Description
Lot Dimensions: 100 x 200
Stories: 2
SqFt - Living: 3422
SqFt - Source: Appraiser
SqFt - Total: 3883
Assn Fee $: 675
Assn Fee Terms: Yearly
Acreage Range: 0 - 0.5
# Bedrooms: 5
Baths - Full: 4
Total Baths: 4
Year Built: 1995
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
Style
Acadian: 1
Siding
Vinyl Siding: 1
Parking
Garage: 1
Equipment
Generator: 1
Construction
Brick: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Wood Burning: 1
Roof
Other: 1
Cooling
2 or More Units: 1
Countertops
Granite: 1
Rooms
Bathroom 1: 1
Bedroom 1: 1
Dining Room: 1
Foyer: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bathroom: 1
Primary Bedroom: 1
Office: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bathroom 2: 1
Bathroom 3: 1
Bathroom 4: 1
Bathroom 5: 1
Bedroom 6: 1
Bedroom 7: 1
Bedroom 8: 1
Fencing
Wood: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57702440
Originating System Listing ID: 2552160
Originating System Name: ROAM Matrix
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
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 |
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.
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.