$490,000
Mandeville, LA 70448
MLS# 200IWX
3 beds | 3 baths | 1690 sqft
1 / 11
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.
Details
Documents
Listing Information
Comp Sale YN: No
Property Sub Type: Single Family Residence
Lock Box Association: NOMAR
Status Change Information
Status Change Timestamp: 2026-11-01
Delayed Marketing: No
Address
Parish or County: St. Tammany
MLS Area Major: None
Street Number: 823
Street Name: Lamarque
Street Suffix: Street
City Limits YN: Yes
State: LA
Postal Code (Zip): 70448
Directions: HEAD EAST ON FLORIDA ST, TAKE RIGHT ON LAMARQUE ST. PROPERTY IS ON THE LEFT.
Parcel Number: 58906
Cross Street: Florida st, Montgomery St
Contract
Current Price: $490,000
Original List Price: 490000
Status: Active
Listing Contract Date: 2026-10-30
List Price: $490,000
Listing Agreement: Exclusive Right To Sell
Listing Service: Full Service
Occupant Type: Owner
Common Interest: None
List Price/SqFt: 289.94
Interior
Bedrooms Total: 3
Bathrooms Total: 3
Bathrooms Full: 3
Living Area: 1690
Living Area Units: Square Feet
Living Area Source: Public Records
Building Area Total: 1690
Non-Living Area: 557
Building Area Units: Square Feet
Building Area Source: Public Records
Basement YN: No
Fireplace YN: No
Parking Information
Garage YN: No
Carport YN: No
Parking Total: 4
Building
Year Built: 2022
Approximate Age: 4 - 5 Years
Year Built Source: Builder
Year Built Effective: 2022
Year Built Details: new construction completed in 2022
Property Attached YN: No
Home Warranty YN: No
Lot
Lot Size Acres: 0.45
Lot Size Square Feet: 19602
Lot Size Dimensions: 112 X 202
Pool Private YN: No
Land Lease YN: No
Waterfront YN: No
Sign On Property YN: Yes
Road Frontage Feet: 112
Remarks
Public Remarks: 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.
Land Details
Mineral Rights: Conveyed
Lock Box Location
Lock Box Location: Call Listing Agent
Utility Providers
Electric Provider: CLECO
Gas Provider: Atmos
Sewer Provider: City of Mandeville
Water Provider: City of Mandeville
Tax Legal
Subdivision Name: Lakefront
Property Features
Utilities: Electricity Connected; Internet Connected; Internet Connected; Natural Gas Connected; Sewer Connected; Water Connected; Electricity Connected; Internet Connected; Internet Connected; Natural Gas Connected; Sewer Connected; Water Connected
Appliances: Dishwasher; Dryer; Gas Range; Gas Water Heater; Microwave; Oven; Range Hood; Refrigerator; Stainless Steel Appliance(s); Tankless Water Heater; Washer
Architectural Style: Traditional
Community Features: Close to Library; Other
Construction Materials: HardiPlank Type
Cooling: Ceiling Fan(s); Central Air; Multi Units
Disclosures: Property As Is
Door Features: ENERGY STAR Qualified Doors
Electric: Circuit Breakers
Exterior Features: Entry Flat or Ramped Access; Fire Pit; Private Yard; Smart Camera(s)/Recording; Storage
Fencing: Gate; Wood; Wrought Iron
Flood Zone(s): X
Flooring: Tile; Wood
Foundation Details: Slab
Green Energy Efficient: Appliances; HVAC; Insulation; Lighting; Water Heater; Windows
Heating: Central; Multiple Units; Natural Gas
Interior Features: Granite Counters; Guest Suite; Separate Shower; Standalone Tub
Laundry Features: Electric Dryer Hookup; Inside; Laundry Closet; Main Level; Sink; Washer Hookup
Levels: Two
Listing Terms (Financing): Cash; Conventional; FHA
Lock Box Type: Supra
Lot Features: Back Yard; Level; Private; Rear Yard Vehicle Access; Shade Tree(s)
Other Structures: Guest House; Shed(s)
Parking Features: Concrete; Driveway; Open
Patio And Porch Features: Covered; Porch
Road Frontage Type: City Street
Road Surface Type: Paved
Roof: Metal
Security Features: Carbon Monoxide Detector(s); Closed Circuit Camera(s); Security Gate; Smoke Detector(s)
Sewer: Public Sewer
Showing Considerations: Occupied
Structure Type: House
View: Neighborhood; Trees/Woods
Water Source: Public
Window Features: Aluminum Frames; Double Pane Windows; Screens
Showing Requirements: 24 Hour Notice; Appointment Only; Listing Agent Must Accompany; Lockbox
Room Information
| Room Name | Level | Dimensions |
| Bedroom | Second | 15.4 X 12.8 |
| Bathroom | Second | 6.8 X 12.8 |
| Living Room | First | 12 x 20 |
| Bedroom | First | 11.6 x 12 |
| Bedroom | First | 11.7 x 12 |
Property Disclosure 
Listing Office: Keller Williams Realty Service
Office Phone: 985-727-7000
Office Email: larocca@kw.com
Last Updated: November - 03 - 2026
Information deemed reliable but not guaranteed.
Broker Attribution:
985-727-7000
GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for
IDX
. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.
Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.