823 Lamarque Street, Mandeville, LA 70448
Local realty services provided by:CENTURY 21 Buelow-Miller Realty
823 Lamarque Street,Mandeville, LA 70448
$490,000
- 3 Beds
- 3 Baths
- 1,690 sq. ft.
- Single family
- Active
Listed by: steven federer
Office: keller williams realty serv.
MLS#:200IWX
Source:LA_CLBOR
Price summary
- Price:$490,000
- Price per sq. ft.:$289.94
About this home
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....
Contact an agent
Home facts
- Year built:2022
- Subdivision & Development:Lakefront
- Listing ID #:200IWX
- Added:1 day(s) ago
- Updated:November 01, 2026 at 01:16 PM
Rooms and interior
- Bedrooms:3
- Total bathrooms:3
- Full bathrooms:3
- Rooms Total:5
- Flooring:Tile, Wood
- Bathrooms Description:Separate Shower
- Kitchen Description:Dishwasher, Granite Counters, Microwave, Oven, Range Hood, Refrigerator, appl_Gas Range, appl_Gas Water Heater
- Living area:1,690 sq. ft.
Heating and cooling
- Cooling:Ceiling Fan(s), Central Air, Multi Units
- Heating:Central, Multiple Units, Natural Gas
Structure and exterior
- Year built:2022
- Building area:1,690 sq. ft.
- Lot area:0.45 Acres
- Lot Features:Back Yard, Level, Private, Rear Yard Vehicle Access, Shade Tree(s)
- Construction Materials:HardiPlank Type
- Exterior Features:Covered, Entry Flat or Ramped Access, Fire Pit, Porch, Storage
- Foundation Description:Slab
Utilities
- Water:Public
- Sewer:Public Sewer
Finances and disclosures
- Price:$490,000
- Price per sq. ft.:$289.94
Features and amenities
- Appliances:Dishwasher, Dryer, Gas Range, Gas Water Heater, Microwave, Oven, Range Hood, Refrigerator, Stainless Steel Appliance(s), Tankless Water Heater, Washer
- Laundry features:Dryer, Electric Dryer Hookup, Inside, Laundry Closet, Washer, Washer Hookup
- Amenities:Double Pane Windows, Guest Suite, Separate Shower, Standalone Tub
Parking
- Parking description:Concrete, Driveway, Open
New listings near 823 Lamarque Street
- New
$325,000Active3 beds 2 baths1,641 sq. ft.2320 America Street, Mandeville, LA 70448
MLS# 200IRBListed by: UNITED REAL ESTATE PARTNERS - New
$730,000Active4 beds 3 baths2,836 sq. ft.2109 Copper Canyon, Mandeville, LA 70448
MLS# 200IPDListed by: FALAYA - New
$109,900Active3 beds 2 baths1,540 sq. ft.1608 Franklin Street, Mandeville, LA 70448
MLS# 200HYIListed by: KELLER WILLIAMS REALTY SERV. - New
$209,900Active4 beds 2 baths1,495 sq. ft.370 Ridgewood Drive, Mandeville, LA 70471
MLS# 200HCKListed by: MOSS REAL ESTATE SERVICES LLC - New
$925,000Active4 beds 4 baths3,737 sq. ft.6 Falcon Drive, Mandeville, LA 70471
MLS# 200EWIListed by: BERKSHIRE HATHAWAY HS - MANDEVILLE - New
$449,000Active4 beds 2 baths2,130 sq. ft.940 Mcnamara Street, Mandeville, LA 70448
MLS# 200ENWListed by: 1 PERCENT LISTS PREMIER - New
$200,000Active0.34 Acres436 Adair Street, Mandeville, LA 70448
MLS# 200EJQListed by: REVE, REALTORS
$1,295,000Active4 beds 3 baths3,170 sq. ft.245 Antibes Street W, , LA
MLS# 2568233Listed by: CRESCENT SOTHEBY'S INTERNATIONAL REALTY- New
$379,500Active4 beds 2 baths1,692 sq. ft.21288 Firetower Road, Mandeville, LA 70471
MLS# 200EFLListed by: GREGORY M. PEACE