Skip To Content

823 Lamarque Street

Mandeville, LA 70448
  • $490,000
  • STATUS: Active
  • ON SITE: 4 Days
  • MLS #: 200IWX
New On Site 4 Days Ago
UPDATED: 81 min ago
$490,000
  • 3
    BEDS
  • 0.52
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 1,690
    SQFT
  • $290
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
2022
County:
Area:

School Information

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 Payment Calculator

www.parishrealty.co/homes/183261431
Print Image

823 Lamarque Street Mandeville, LA 70448

  • Price: $490,000
  • Status: Active
  • On Site: 4 Days
  • Updated: 81 min ago
  • MLS #: 200IWX
3
Beds
3
Baths
0
½ Baths
0.52
Acres
1,690
SQFT
$290
$/SQFT
2022
Built
Neighborhood:
Lakefront
County:
St. Tammany
Area:
None
Elementary School:
Woodlake Elementary School
Middle School:
Lake Harbor Middle School, Mandeville Jr High
High School:
Mandeville High School
School District:
St. Tammany Parish
Property 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.
Exterior Features

Architectural Style Traditional Attached Garage YN No Carport YN No Construction Materials HardiPlank Type Door Features ENERGY STAR Qualified Doors Exterior Features Fire PitPrivate YardSmart Camera(s)/RecordingStorageEntry Flat or Ramped Access Foundation Details Slab Garage YN No Parking Features ConcreteDrivewayOpen Patio And Porch Features PorchCovered Pool Features [] Pool Private YN No Roof Metal View Trees/WoodsNeighborhood Waterfront Features [] Waterfront YN No Window Features Double Pane WindowsInsulated WindowsWindow TreatmentsScreensAluminum Frames

Interior Features

Appliances DryerDishwasherGas RangeMicrowaveRefrigeratorRange HoodWasherGas Water HeaterTankless Water HeaterStainless Steel Appliance(s)Oven Building Area Total 1690 Cooling Central AirCeiling Fan(s)Multi Units Cooling YN Yes Fireplace Features [] Fireplace YN No Flooring TileWood Green Energy Efficient AppliancesHVACInsulationLightingWater HeaterWindows Heating CentralNatural GasMultiple Units Heating YN Yes Interior Central VacuumDual ClosetsStorageWalk-In Closet(s)Guest SuiteSeparate ShowerStandalone TubComputer NookCustom Built Cabinets Interior Features Central VacuumDual ClosetsStorageWalk-In Closet(s)Granite CountersGuest SuiteSeparate ShowerStandalone TubComputer NookCustom Built Cabinets Laundry Features Laundry ClosetElectric Dryer HookupMain LevelSinkWasher HookupInsideLower Level Levels Two Rooms Total 5

Property Features

Association YN No Basement YN No Community Features ParkClose to LibraryOther Community Pool No Disclosures Property As Is Electric Circuit Breakers Fencing WoodWrought IronGate Home Warranty YN No Land Lease YN No Listing Terms CashConventionalFHA Listing Terms Financing CashConventionalFHA Lot Features LevelPrivateRear Yard Vehicle AccessShade Tree(s)Back Yard Mineral Rights Conveyed Other Equipment [] Other Structures Guest HouseShed(s) Parking Total 4 Property Attached YN No Property Sub Type Single Family Residence Road Frontage Ft 112 Road Frontage Type City Street Road Surface Type Paved Security Features Carbon Monoxide Detector(s)Closed Circuit Camera(s)Smoke Detector(s)Security Gate Senior Community YN No Sewer Public Sewer Special Listing Conditions [] Structure Type House Utilities Electricity ConnectedNatural Gas ConnectedSewer ConnectedWater ConnectedInternet Connected Water Source Public Year Built Details new construction completed in 2022 Zoning R1

 
https://bt-photos.global.ssl.fastly.net/roam/1280_boomver_2_20261026173706053608000000-2.jpg https://bt-photos.global.ssl.fastly.net/roam/1280_boomver_2_20261026173706053608000000-2.jpg https://bt-photos.global.ssl.fastly.net/roam/1280_boomver_2_20261026173706053608000000-2.jpg
Logo
Parish Realty Acadiana
307 Jefferson St
Lafayette LA, 70501