Experience year-round vacation living in one of the most magnificent homes in Historic Lewisburg, set on three expansive lots directly on the shores of Lake Pontchartrain. This extraordinary waterfront estate captures breathtaking panoramic views from every room and welcomes refreshing lake breezes across its many porches and patios.
Inside, a grand living room with soaring ceilings and elegant French doors opens seamlessly to a stunning screened-in porch complete with an outdoor TV—perfect for entertaining or unwinding at sunset. A separate den with a wet bar provides additional space to relax, while the glass-lined dining room beautifully blends indoor and outdoor living.
The chef’s kitchen is equipped with professional-grade appliances, sleek quartz countertops, and an adjacent climate-controlled wine cellar. The luxurious owner’s suite serves as a private retreat, featuring a spa-inspired bath and its own secluded study.
The ground level offers exceptional functionality with abundant storage, a climate-controlled gym, a full bath, and a covered patio designed for lakefront barbecues and crawfish boils. An elevator and whole-house generator add both convenience and peace of mind.
Extensive recent improvements elevate this remarkable property even further, including a newly constructed 500-foot all-steel and fiberglass pier with an 18-ton boat lift, enhanced grading with underground drainage and irrigation, a rebuilt exterior staircase, a finished ground floor with epoxy flooring, three new HVAC systems, a new septic system, and the addition of a private Padel tennis court.
Active
Price cut: $250K (6/11)
$2,700,000
100 Mulberry Ave, Mandeville, LA 70448
3beds
4,558sqft
Single Family Residence
Built in 2001
2.23 Acres Lot
$-- Zestimate®
$592/sqft
$-- HOA
What's special
Waterfront estatePrivate padel tennis courtRebuilt exterior staircaseElegant french doorsAdjacent climate-controlled wine cellarClimate-controlled gymSleek quartz countertops
- 397 days |
- 686 |
- 24 |
Zillow last checked:
Listing updated:
Listed by:
Alice McNeely 504-812-2236,
REVE, REALTORS 504-300-0700,
Rebecca Hammett 985-807-7672,
REVE, REALTORS
Source: GSREIN,MLS#: 2504031
Loading...
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Primary bedroom
- Description: Flooring: Wood
- Level: First
- Dimensions: 16.6X18.2
Bedroom
- Description: Flooring: Wood
- Level: Second
- Dimensions: 14.7X13.7
Bedroom
- Description: Flooring: Wood
- Level: Second
- Dimensions: 11.2X17.3
Breakfast room nook
- Description: Flooring: Wood
- Level: First
- Dimensions: 11.8X8
Den
- Description: Flooring: Wood
- Level: First
- Dimensions: 12.6X9.6
Dining room
- Description: Flooring: Wood
- Level: First
- Dimensions: 21X16.3
Other
- Description: Flooring: Wood
- Level: First
- Dimensions: 15.5X20.4
Kitchen
- Description: Flooring: Wood
- Level: First
- Dimensions: 21X13
Living room
- Description: Flooring: Wood
- Level: First
- Dimensions: 26X27
Heating
- Central, Multiple Heating Units
Cooling
- Central Air, 3+ Units
Appliances
- Included: Dishwasher, Ice Maker, Microwave, Oven, Range, Refrigerator
Features
- Cathedral Ceiling(s), Elevator, High Ceilings, Stainless Steel Appliances, Vaulted Ceiling(s)
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 9,035
- Total interior livable area: 4,558 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, Garage, Three or more Spaces, Garage Door Opener
- Has attached garage: Yes
Features
- Levels: Three Or More
- Stories: 3
- Patio & porch: Covered, Balcony, Porch, Screened
- Exterior features: Balcony, Dock, Enclosed Porch
- Pool features: None
- On waterfront: Yes
- Waterfront features: Waterfront, Lake
Lot
- Size: 2.23 Acres
- Dimensions: 2.23 Acres
- Features: 1 to 5 Acres, Outside City Limits
Details
- Additional structures: Other
- Parcel number: 38394
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence
Materials
- Stucco
- Foundation: Raised
- Roof: Metal
Condition
- Excellent
- Year built: 2001
Utilities & green energy
- Electric: Generator
- Sewer: Septic Tank
- Water: Well
Community & HOA
Community
- Security: Security System, Fire Sprinkler System
- Subdivision: Lewisburg
HOA
- Has HOA: No
Location
- Region: Mandeville
Financial & listing details
- Price per square foot: $592/sqft
- Tax assessed value: $1,268,142
- Annual tax amount: $15,773
- Date on market: 6/6/2025
Estimated market value
Not available
Estimated sales range
Not available
Not available
Price history
| Date | Event | Price |
|---|---|---|
| 6/11/2026 | Price change | $2,700,000-8.5%$592/sqft |
Source:  GSREIN #2504031 Report a problem | ||
| 6/9/2026 | Listed for sale | $2,950,000$647/sqft |
Source: GSREIN #2504031 Report a problem | ||
| 5/20/2026 | Contingent | $2,950,000$647/sqft |
Source: GSREIN #2504031 Report a problem | ||
| 4/8/2026 | Price change | $2,950,000-1.7%$647/sqft |
Source: GSREIN #2504031 Report a problem | ||
| 6/6/2025 | Listed for sale | $3,000,000$658/sqft |
Source: GSREIN #2504031 Report a problem | ||
| 6/6/2025 | Listing removed | $3,000,000$658/sqft |
Source: Latter and Blum #2461257 Report a problem | ||
| 9/18/2024 | Listed for sale | $3,000,000$658/sqft |
Source: GSREIN #2461257 Report a problem | ||
| 8/29/2024 | Pending sale | $3,000,000$658/sqft |
Source: Latter and Blum #2461257 Report a problem | ||
| 8/29/2024 | Contingent | $3,000,000$658/sqft |
Source: GSREIN #2461257 Report a problem | ||
| 8/20/2024 | Listed for sale | $3,000,000+8.1%$658/sqft |
Source: GSREIN #2461257 Report a problem | ||
| 12/15/2021 | Sold | -- |
Source: GSREIN #2262122 Report a problem | ||
| 12/2/2021 | Pending sale | $2,775,000$609/sqft |
Source: Latter and Blum #NAB21009270 Report a problem | ||
| 11/16/2021 | Contingent | $2,775,000$609/sqft |
Source: Greater Southern MLS #NAB21009270 Report a problem | ||
| 10/19/2021 | Pending sale | $2,775,000$609/sqft |
Source: GSREIN #2262122 Report a problem | ||
| 7/24/2021 | Price change | $2,775,000-7.5%$609/sqft |
Source: Latter and Blum #2262122 Report a problem | ||
| 7/23/2020 | Listed for sale | $2,999,000+114.2%$658/sqft |
Source: LATTER & BLUM INC/REALTORS #2262122 Report a problem | ||
| 12/28/2016 | Sold | -- |
Source: GSREIN #2048507 Report a problem | ||
| 12/10/2016 | Pending sale | $1,400,000$307/sqft |
Source: RE/MAX Elite #2048507 Report a problem | ||
| 3/9/2016 | Listed for sale | $1,400,000-6.7%$307/sqft |
Source: RE/MAX Elite #2048507 Report a problem | ||
| 9/30/2015 | Listing removed | $1,500,000$329/sqft |
Source: Dorian Bennett Sotheby's International Realty #961344 Report a problem | ||
| 6/22/2015 | Price change | $1,500,000-9.1%$329/sqft |
Source: Dorian Bennett Sotheby's International Realty #961344 Report a problem | ||
| 3/24/2015 | Price change | $1,650,000-10.8%$362/sqft |
Source: Dorian Bennett Sotheby's International Realty #961344 Report a problem | ||
| 3/19/2015 | Price change | $1,850,000+12.1%$406/sqft |
Source: Dorian Bennett Sotheby's International Realty #961344 Report a problem | ||
| 3/6/2015 | Listed for sale | $1,650,000$362/sqft |
Source: Dorian Bennett Sotheby's International Realty #961344 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2024 | $15,773 -31.7% | $126,814 -27.3% |
| 2023 | $23,107 | $174,325 |
| 2022 | $23,107 +44.9% | $174,325 +36.2% |
| 2021 | $15,942 +0.1% | $127,997 |
| 2020 | $15,925 -17.1% | $127,997 -13.3% |
| 2019 | $19,206 -0.1% | $147,598 |
| 2018 | $19,234 -1% | $147,598 +5.3% |
| 2017 | $19,430 +15.9% | $140,217 +16.8% |
| 2016 | $16,767 | $120,059 +10.4% |
| 2015 | $16,767 +7.4% | $108,775 |
| 2014 | $15,608 +1.1% | $108,775 -2.2% |
| 2013 | $15,444 -21.2% | $111,213 -17.9% |
| 2011 | $19,600 +0.4% | $135,433 |
| 2010 | $19,525 | $135,433 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: 70448
Nearby schools
GreatSchools rating
- 10/10Mandeville Elementary SchoolGrades: PK-3Distance: 1.5 mi
- 10/10Mandeville Junior High SchoolGrades: 7-8Distance: 1.9 mi
- 9/10Mandeville High SchoolGrades: 9-12Distance: 1.1 mi
A local agent can set up tours, give advice and negotiate with sellers.
- Louisiana
- Saint Tammany Parish
- Mandeville
- 70448
- 100 Mulberry Ave
Nearby cities
Nearby zip codes
Other Mandeville Topics
