# 823 Lamarque Street, Mandeville, LA 70448 > **TL;DR:** 3bd/3ba single family, $490,000 ($290/sqft), built 2022, 1,690 sqft. > A/C. Est. $2,621/mo. Listed 3 days. ## Property at a Glance | Attribute | Value | |-----------|-------| | Price | $490,000 | | Price/sqft | $290 | | Bedrooms | 3 | | Bathrooms | 3 full | | Square Feet | 1,690 | | Year Built | 2022 | | Lot Size | 19,602 sqft (0.45 acres) | | Stories | 2 | | Property Type | Single Family (Single Family Residence) | | Status | Active | | Days on Market | 3 | ## Estimated Monthly Costs | Category | Amount | |----------|--------| | Principal & Interest (20% down, 30-year at 6.5%) | $2,478 | | Estimated Insurance | $143 | | **Total** | **$2,621** | ## Nearby Schools - **Elementary:** Woodlake Elementary School - **Middle:** Lake Harbor Middle School, Mandeville Jr High - **High:** Mandeville High School ## Key Amenities - A/C ## Property Highlights - Built in 2022 - 0.45 acre lot - 2 stories - 4 parking spaces ## Description ### Agent 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. ## Location - **Address:** 823 Lamarque Street, Mandeville, LA 70448 - **County:** St. Tammany - **Neighborhood:** Lakefront - **Coordinates:** 30.360834, -90.058254 - **Google Maps:** https://www.google.com/maps?q=30.360834,-90.058254 ## Listing Agent - **Name:** Steven Federer · **License:** 995715269 - **Brokerage:** Keller Williams Realty Services - **Broker Phone:** (985) 727-7000 - **Listing URL:** [View original listing](https://www.realtor.com/realestateandhomes-detail/823-Lamarque-St_Mandeville_LA_70448_M93743-62017?f=listhub&s=ROAMLA&m=200IWX&c=propsimple) ## Photos ![823 Lamarque Street - Photo 1](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1209482871r.jpg) ![823 Lamarque Street - Photo 2](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4121989433r.jpg) ![823 Lamarque Street - Photo 3](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1036520212r.jpg) ![823 Lamarque Street - Photo 4](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3455765097r.jpg) ![823 Lamarque Street - Photo 5](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3055236925r.jpg) ![823 Lamarque Street - Photo 6](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f391442427r.jpg) ![823 Lamarque Street - Photo 7](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3636750187r.jpg) ![823 Lamarque Street - Photo 8](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f444997228r.jpg) ![823 Lamarque Street - Photo 9](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4032403100r.jpg) ![823 Lamarque Street - Photo 10](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1952545317r.jpg) ![823 Lamarque Street - Photo 11](http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3141729294r.jpg) --- **MLS#:** 200IWX | **Updated:** 2026-11-01 **Source:** listhub *Copyright © 2026 ROAM MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.* [View on PropertySimple](https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6) --- ## Structured Data ```json { "@context": "https://schema.org", "@type": "RealEstateListing", "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#listing", "url": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6", "name": "823 Lamarque Street, Mandeville, LA 70448", "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.", "image": [ "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1209482871r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4121989433r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1036520212r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3455765097r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3055236925r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f391442427r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3636750187r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f444997228r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4032403100r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1952545317r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3141729294r.jpg" ], "primaryImageOfPage": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1209482871r.jpg", "caption": "823 Lamarque Street - Mandeville, LA" }, "datePosted": "2026-10-30", "dateModified": "2026-11-01T08:35:50.011Z", "mainEntity": { "@type": "Accommodation", "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#property", "name": "823 Lamarque Street, Mandeville, LA 70448", "address": { "@type": "PostalAddress", "streetAddress": "823 Lamarque Street", "addressLocality": "Mandeville", "addressRegion": "LA", "postalCode": "70448", "addressCountry": "US" }, "geo": { "@type": "GeoCoordinates", "latitude": 30.360834, "longitude": -90.058254 }, "image": [ "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1209482871r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4121989433r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1036520212r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3455765097r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3055236925r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f391442427r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3636750187r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f444997228r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f4032403100r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f1952545317r.jpg", "http://lh.rdcpix.com/a65b46d844b057f8f6caa824a00fa23el-f3141729294r.jpg" ], "identifier": { "@type": "PropertyValue", "propertyID": "MLS", "value": "200IWX" }, "accommodationCategory": "Single Family Residence", "numberOfBedrooms": 3, "numberOfBathroomsTotal": 3, "numberOfFullBathrooms": 3, "floorSize": { "@type": "QuantitativeValue", "value": 1690, "unitCode": "FTK", "unitText": "square feet" }, "yearBuilt": 2022, "amenityFeature": [ { "@type": "LocationFeatureSpecification", "name": "Heating", "value": "Natural Gas, Central" }, { "@type": "LocationFeatureSpecification", "name": "Cooling", "value": "Multi Units, Ceiling Fan(s), Central Air" }, { "@type": "LocationFeatureSpecification", "name": "Appliances", "value": "Dryer, Dishwasher, Gas Range, Microwave, Refrigerator, Range Hood, Washer, Gas Water Heater, Tankless Water Heater, Stainless Steel Appliance(s), Oven, Dryer, Dishwasher, Gas Range, Microwave, Refrigerator, Range Hood, Washer, Gas Water Heater, Tankless Water Heater, Stainless Steel Appliance(s), Oven" }, { "@type": "LocationFeatureSpecification", "name": "Flooring", "value": "Tile, Wood" }, { "@type": "LocationFeatureSpecification", "name": "Construction Materials", "value": "HardiPlank Type" }, { "@type": "LocationFeatureSpecification", "name": "Pool Features", "value": "Porch" }, { "@type": "LocationFeatureSpecification", "name": "Parking Features", "value": "Open, Driveway" }, { "@type": "LocationFeatureSpecification", "name": "Air Conditioning", "value": true } ], "additionalProperty": [ { "@type": "PropertyValue", "name": "Lot Size", "value": "0.45 acres" }, { "@type": "PropertyValue", "name": "Stories", "value": 2 }, { "@type": "PropertyValue", "name": "Parking Spaces", "value": 4 }, { "@type": "PropertyValue", "name": "Property Subtype", "value": "Single Family Residence" } ] }, "offers": { "@type": "Offer", "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#offer", "url": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6", "price": 490000, "priceCurrency": "USD", "businessFunction": "http://purl.org/goodrelations/v1#Sell", "availability": "https://schema.org/InStock", "seller": { "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#agent" } }, "provider": { "@type": "Person", "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#agent", "name": "Steven Federer", "worksFor": { "@type": "Organization", "@id": "https://staging.propertysimple.ai/listing/823-lamarque-street-mandeville-la-70448-02d28fe8ff7842ebadd7ec90aca96bc6#brokerage", "name": "Keller Williams Realty Services", "telephone": "(985) 727-7000", "logo": { "@type": "ImageObject", "url": "http://lh.rdcpix.com/c7f2420140cf11e782030242ac110009k-c59012689r.png" } } } } ```