823 Lamarque Street, Mandeville, LA 70448

Mandeville
Local realty services provided by:Better Homes and Gardens Real Estate Rhodes Realty
823 Lamarque Street,Mandeville, LA 70448
$490,000
Virtual Tour
  • 3 Beds
  • 3 Baths
  • 1,690 sq. ft.
  • Single family
  • Active
Listed by: steven federer
Office: keller williams realty service
MLS#:200IWX
Source:LA_CLBOR

Price summary

  • Price:$490,000
  • Price per sq. ft.:$289.94

About this home

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...

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with a BHGRE®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a BHGRE®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (CENTURY 21® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:2022
  • Subdivision & Development:Lakefront
  • Listing ID #:200IWX
  • Added:8 day(s) ago
  • Updated:November 09, 2026 at 10:17 PM

Rooms and interior

  • Bedrooms:3
  • Total bathrooms:3
  • Full bathrooms:3
  • Rooms Total:5
  • Flooring:Tile, Wood
  • Bathrooms Description:Separate Shower
  • Kitchen Description:Dishwasher, Granite Counters, Microwave, Oven, Range Hood, Refrigerator, appl_Gas Water Heater, appl_Stainless Steel Appliance(s)
  • Living area:1,690 sq. ft.

Heating and cooling

  • Cooling:Ceiling Fan(s), Central Air, Multi Units
  • Heating:Central, Multiple Units, Natural Gas

Structure and exterior

  • Year built:2022
  • Building area:1,690 sq. ft.
  • Lot area:0.52 Acres
  • Lot Features:Back Yard, Level, Private, Rear Yard Vehicle Access, Shade Tree(s)
  • Construction Materials:HardiPlank Type
  • Exterior Features:Covered, Entry Flat or Ramped Access, Fire Pit, Porch, Storage
  • Foundation Description:Slab

Utilities

  • Water:Public
  • Sewer:Public Sewer

Finances and disclosures

  • Price:$490,000
  • Price per sq. ft.:$289.94

Features and amenities

  • Appliances:Dishwasher, Dryer, Gas Range, Gas Water Heater, Microwave, Oven, Range Hood, Refrigerator, Stainless Steel Appliance(s), Tankless Water Heater, Washer
  • Laundry features:Dryer, Electric Dryer Hookup, Inside, Laundry Closet, Lower Level, Washer, Washer Hookup
  • Amenities:Central Vacuum, Computer Nook, Double Pane Windows, Dual Closets, Guest Suite, Insulated Windows, Separate Shower, Standalone Tub, Storage, Walk-In Closet(s), Window Treatments

Parking

  • Parking description:Concrete, Driveway, Open

New listings near 823 Lamarque Street