823 Lamarque Street
Mandeville, LA 70448
1 / 27Estimated payment
$2,478 principal & interest
$608 tax and insurance
An estimate only, not a rate quote. The rate, tax and insurance are placeholders to change.
Open the full calculator →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.
Facts
- Bedrooms
- 3
- Bathrooms
- 3
- Square feet
- 1,690
- Lot
- 112 X 202
- Type
- Single Family
- Year built
- 2022
- Stories
- Two
- Price per sq ft
- $290
- Parking spaces
- 4
Details
- Traditional
- Central Vacuum
- Double Vanity
- Dual Closets
- Storage
- Walk-In Closet(s)
- Guest Suite
- Separate Shower
- Standalone Tub
- Computer Nook
- Custom Built Cabinets
- En Suite
- Dryer
- Dishwasher
- Gas Range
- Microwave
- Refrigerator
- Range Hood
- Washer
- Gas Water Heater
- Tankless Water Heater
- Stainless Steel Appliance(s)
- Oven
- Concrete
- Driveway
- Open
- Level
- Private
- Rear Yard Vehicle Access
- Shade Tree(s)
- Back Yard
Where it is
Source: ROAM MLS #200IWX. Listing courtesy of Keller Williams Realty Service, 985-727-7000, larocca@kw.com. Listing updated November 16, 2026 at 9:15 AM CST. Information deemed reliable but not guaranteed.