USALAMandevilleLakefront823 Lamarque Street
823 Lamarque Street | Image 1
New
823 Lamarque Street | Image 2
823 Lamarque Street | Image 3
823 Lamarque Street | Image 4
823 Lamarque Street | Image 5
823 Lamarque Street | Image 6
823 Lamarque Street | Image 7

$490,000

For Sale

6 hours ago

823 Lamarque Street, Mandeville, LA

House

MLS® 200IWX

3 Bed

3 Bath

1690 sqft

4 Parking

  • Key Facts
  • Description
  • Rooms
  • Map

Key Facts

Type Single Family Residence
Levels Residential
Size 1690 sqft
Garage 
Taxes 
Days Active 0
Lot Size 0.45 Acres
Approx. Age 2022
Avg. Price Per Sqft $289
MLS® Number 200IWX

Property Address: 823 Lamarque Street, Mandeville, LA, 70448

Average square foot calculated using Size range provided by listing agent.

Description

Charming Mandeville Historic District Home with Established Short-Term Rental Income! Enjoy a walkable lifestyle just steps from the Trailhead Market, local shops, Library, restaurants, the Tammany Trace, Local Music Venues and the Lake Pontchartrain lakefront. Currently operating as Birdie & Rascal's B&B, a rare turnkey investment opportunity in the heart of Historic Mandeville. This nearly new, 3-bedroom, 3-full bath residence offers a documented history of business income potential, and the short-term rental permit can transfer to the new owner. Three private living and working spaces make this property adaptable to many uses. The City of Mandeville permits other home-based businesses, and the floor plan suits multi-generational living, a mother-in-law suite, student, an at home caretaker, or continuing current hospitality business. Custom-built 557 sq ft shed with 20' storage capacity, metal roof, and covered deck. Brick patio with smokeless fire pit. Mature landscaping, wooded views ideal for bird watching, and five varieties of fruit trees. Ample room on the lot to expand. Flood Zone X500! Standing seam metal roof. Spray foam insulation. Energy efficient: average summer power bill of $199/month. Tankless water heater. Natural gas. Backup generator (requires connection to natural gas line). Central vacuum with four ports installed. In Mandeville School District! Buyer has option to purchase home fully furnished. Priced below most recent appraisal. Schedule a Private Showing. Book showings through Showing Time.
MLS® Number200IWX
Laundry LevelMain
Central VacNo
FireplaceNo
Acreage
Exterior
Garage
Approx. Age2022
Basement
DrivewayConcrete, Driveway, Open
Garage Spaces
HeatCentral, Natural Gas, Multiple Units
A/CCentral Air, Ceiling Fan(s), Multi Units

Extras

Rooms

Change to metres

Other:First Floor12 × 11.59 ft
Living Room:First Floor20 × 12 ft
Other:Second Floor12.67 × 6.67 ft

Price History

-End Date
Not Sold YetSold Price

For Sale

Nov 1, 2026List Date
$490,000List Price
  • Commute

Commute

Starting Address
Destination Address
823 Lamarque Street, Mandeville, LA

Like what you see?

Complete the form and we'll be in touch. No login necessary.

Add a Comment
Loading...

Similar Listings

Comparable Properties

Explore eXpFind an AgentJoin eXpInvestor RelationsCompany CareersHome Guides
eXp LifeZoocasaSUCCESS®SUCCESS® LendingeXp RevenoseXp CommercialeXp LuxuryeXp Land and RanchAccessibility
Terms and ConditionsPrivacy Rights RequestPrivacy PolicyCookie PolicyBrand GuidelinesSitemap

2219 Rimland Drive, Suite 301, Bellingham, Washington, 98226

1 833-303-0610

[email protected]

eXp REALTY

DMCA Notice

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply

Fair Housing and Reasonable Accommodations

MLS Compliance Statements

Karen Richards - Designated Managing Broker, Broker Operations - TX

Texas Real Estate Commission information about brokerage services

Texas Real Estate Commission Consumer Protection Notice

eXp Realty® is committed to adhering to the guidelines of The New York State Fair Housing Regulations.The Fair Housing Notice →

*Standardized Operating Procedure for Purchasers of Real Estate Pursuant to Real Property Law 442-H.Learn More →

eXp Realty of California, Inc. | CA DRE# 01878277 | Deborah Penny - Designated Broker

eXp Realty of Southern California, Inc. | CA DRE#01325837 | Jason Crawford – Designated Broker

eXp Realty of Greater Los Angeles, Inc. | CA DRE# 01240990 | Mike Mendibles - Designated Broker

eXp Realty of Northern California, Inc. | CA DRE# 01951343 | Ryan Rosas - Designated Broker

© 2026 eXp Realty. eXp World Holdings, Inc. All Rights Reserved