About This Home

This 3-bedroom, 3-bathroom single family at 823 Lamarque Street in Mandeville, LA is listed for $490,000 ($290 per sqft). Built in 2022, the home offers 1,690 sqft of living space on a 0.45 acres lot.

Key Features

  • Built in 2022
  • 0.45 acre lot
  • 2 stories
  • 4 parking spaces

Property Details

2 stories
3 full
4 spaces
2022

Amenities

A/C
Listing 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.

Monthly Cost Estimate

$2,621/mo

20% down · 6.5% · 30 years

Principal$354
Interest$2,123
Insurance$143

Estimates only. Actual payments may vary.

Location

823 Lamarque Street

Mandeville, LA 70448

Lakefront

Features & Amenities

Interior Features

Guest SuiteSeparate ShowerStandalone Tub

Exterior Features

Fire PitPrivate YardSmart Camera(s)/RecordingStorageEntry Flat or Ramped Access

Property Details

Flooring

TileWood

Construction

HardiPlank Type

Outdoor Features

Porch

Parking

OpenDriveway

Heating

Natural GasCentral

Cooling

Multi UnitsCeiling Fan(s)Central Air

Appliances

DryerDishwasherGas RangeMicrowaveRefrigeratorRange HoodWasherGas Water HeaterTankless Water HeaterStainless Steel Appliance(s)OvenDryerDishwasherGas RangeMicrowaveRefrigeratorRange HoodWasherGas Water HeaterTankless Water HeaterStainless Steel Appliance(s)Oven

Questions & Answers

This 3-bedroom, 3-bathroom single family at 823 Lamarque Street is listed at $490,000 ($290/sqft). The estimated monthly payment is $2,621 based on 20% down, a 30-year loan at 6.5% interest, estimated insurance.

Key features include: Built in 2022, 0.45 acre lot, 2 stories, 4 parking spaces. Interior Features: Guest Suite, Separate Shower, Standalone Tub. Exterior Features: Fire Pit, Private Yard, Smart Camera(s)/Recording.

This property is listed by Steven Federer.

SF

Steven Federer

License 995715269

Agent at Keller Williams Realty Services

Listed by Keller Williams Realty Services · Broker phone: (985) 727-7000 · View on Broker Site · Broker website

MLS# 200IWX· Source: ROAM MLS· 2 days on PropertySimple

Copyright © 2026 ROAM MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

823 Lamarque Street, Mandeville, LA 70448

Open this listing in: