Skip to content

823 Lamarque StreetMandeville, LA 70448

Lakefront · St. Tammany County

$490,000List price
3Beds
3Baths
1,690Sq Ft
2022Year built
0.52Acre lot
9 days agoOn market

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

Listings courtesy of ROAM MLS. IDX information is provided exclusively for consumers’ personal, non-commercial use. This data may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This data is deemed reliable but is not guaranteed accurate by the MLS

Commute Calculator

Explore commute times from 823 Lamarque Street, Mandeville, LA 70448.

Travel mode

Connect with a Local Real Estate Expert