RanaCabeceiras

11 Total Photos [Click to View All]

823 Lamarque Street
Mandeville, LA 70448

$490,000 - Status: Active
Beds: 3
Baths: 3 full
SQFT: 1,690
MLS# 200IWX

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.

Property Features

MLS#: 200IWX
Zip: 70448
Subdivision: Lakefront
Development:
Property Type: Residential - Single Family
Cooling: Central Air, Ceiling Fan(s), Multi Units
Days on Site: 2
Heating: Central, Natural Gas, Multiple Units
Home Style: Traditional
Lot Size: 0.45 acres
Roof Type: Metal
Stories: 2.0
Year Built: 2022

Feature Descriptions

Appliances: Dryer, Dishwasher, Gas Range, Microwave, Refrigerator, Range Hood, Washer, Gas Water Heater, Tankless Water Heater, Stainless Steel Appliance(s), Oven
Community Features: Close to Library, Other
Door Features: ENERGY STAR Qualified Doors
Exterior: HardiPlank Type
Exterior Features: Fire Pit, Private Yard, Smart Camera(s)/Recording, Storage, Entry Flat or Ramped Access
Fencing: Wood, Wrought Iron, Gate
Flooring: Tile, Wood
Interior Features: Guest Suite, Separate Shower, Standalone Tub
Laundry: Laundry Closet, Electric Dryer Hookup, Main Level, Sink, Washer Hookup, Inside
Lot Description: Level, Private, Rear Yard Vehicle Access, Shade Tree(s), Back Yard
Lot Dimensions: 112 X 202
Parcel#: 58906
Parking: Concrete, Driveway, Open
Parking Notes: Concrete, Driveway, Open
Security: Carbon Monoxide Detector(s), Closed Circuit Camera(s), Smoke Detector(s), Security Gate
Sewer: Public Sewer
Utilities: Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected, Internet Connected
Water: Public
Window: Double Pane Windows, Screens, Aluminum Frames

Local Schools

High School: Mandeville High School
Middle School: Lake Harbor Middle School, Mandeville Jr
Elementary School: Woodlake Elementary School
School District: St Tammany Parish

823 Lamarque Street | MLS# 200IWX

This single family home located at 823 Lamarque Street, Mandeville, LA 70448 is currently listed for sale with an asking price of $490,000. This property was built in 2022 and has 3 bedrooms and 3 full baths with 1690 sq. ft. Lamarque Street is located in the Lakefront subdivision within the St Tammany Parish school district. Search Lakefront real estate on ranacabeceiras.riccire.com today.

Listed By / Shown By

Listed By

Agency Name: Keller Williams Realty Serv.
Agency Phone: 985-727-7000

Shown By

Agent Name: Rana Cabeceiras
Agent Phone: (504) 415-3638
Agency Title: Ricci Real Estate

IDX logo

Ask a Question

Ask a Question

AGENT INFORMATION

Ricci Real Estate Rana Cabeceiras (504) 415-3638

CONTACT ME

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 11/03/2026. The listing information on this page last changed on 11/03/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 11/03/2026 12:09:10 AM EST) or ROAM MLS (last updated Tue 11/03/2026 12:06:26 AM EST). Real estate listings held by brokerage firms other than Ricci Real Estate may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility


Agent License Information: #99563053

Login to My Homefinder