Skip to content
← Search homes
For sale

823 Lamarque Street

Mandeville, LA 70448

823 Lamarque Street, Mandeville, LA 70448, photo 1 of 271 / 27

Estimated payment

$3,086/mo

$2,478 principal & interest
$608 tax and insurance

$98,000
%
%
Term years

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

Style
  • Traditional
Features
  • 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
Parking
  • Concrete
  • Driveway
  • Open
Lot
  • Level
  • Private
  • Rear Yard Vehicle Access
  • Shade Tree(s)
  • Back Yard

Where it is

ROAM MLS IDX

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.