823 Lamarque StreetMandeville, LA 70448
Lakefront · St. Tammany County
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.
Property Information
- Property type
- Residential
- Sub-type
- Single Family Residence
- Structure type
- House
- Year built
- 2022
- Living area
- 1,690 Sq Ft
- Lot size
- 0.52 acres
- Lot dimensions
- 112 X 202
- Parking spaces
- 4
- Zoning
- R1
- Days on market
- 9
- MLS® Listing#
- 200IWX
Property Features
- Interior
- Central Vacuum · Storage · Walk-In Closet(s) · His and Hers Closets · Soaking Tub · Granite Counters · Built-in Features
- Exterior
- Fire Pit · Private Yard · Storage
- Appliances
- Dryer · Dishwasher · Gas Range · Microwave · Refrigerator · Range Hood · Washer · Gas Water Heater · Tankless Water Heater · Stainless Steel Appliance(s) · Oven
- Cooling
- Central Air · Ceiling Fan(s) · Multi Units
- Heating
- Central · Natural Gas
- Flooring
- Tile · Wood
- Parking
- Concrete · Driveway · Open
- Laundry
- Laundry Closet · Electric Dryer Hookup · Main Level · Sink · Washer Hookup · Inside · Lower Level
- Patio
- Porch · Covered
- Fencing
- Wood · Wrought Iron · Gate
- Lot features
- Level · Private · Back Yard
- Construction
- HardiPlank Type
- Foundation
- Slab
- Roof
- Metal
- Windows
- Double Pane Windows · Insulated Windows · Window Treatments · Screens · Aluminum Frames
- Security
- Carbon Monoxide Detector(s) · Closed Circuit Camera(s) · Smoke Detector(s) · Security Gate
- Other structures
- Guest House · Shed(s)
- Community
- Park · Other
- Utilities
- Electricity Connected · Natural Gas Connected · Sewer Connected · Water Connected
- Sewer
- Public Sewer
- Water source
- Public
Rooms
Second
- Bathroom6.8 X 12.8
- Bedroom15.4 X 12.8
First
- Bedroom11.6 x 12
- Bedroom11.7 x 12
- Living Room12 x 20
Schools
- Elementary
- Woodlake Elementary School
- Middle
- Lake Harbor Middle School, Mandeville Jr High
- High
- Mandeville High School
Financial Details
- HOA
- None
- Parcel number
- 58906
Directions
HEAD EAST ON FLORIDA ST, TAKE RIGHT ON LAMARQUE ST. PROPERTY IS ON THE LEFT.
Listing Courtesy: Keller Williams Realty Service - 985-727-7000
Listed By: Steven Federer - 5044006009
Commute Calculator
Explore commute times from 823 Lamarque Street, Mandeville, LA 70448.













