823 Lamarque Street Mandeville, LA $ 490,000
823 Lamarque Street
$ 490,000
Recently Listed New Construction
Share Save

823 Lamarque Street

Mandeville, LA, 70448
$ 490,000
Bedrooms3 Baths3.0 Sq 1,690

Monthly Estimate*

$ 3,384

823 Lamarque Street, Mandeville, LA 70448 - Image 1
823 Lamarque Street, Mandeville, LA 70448 - Image 2
823 Lamarque Street, Mandeville, LA 70448 - Image 3
823 Lamarque Street, Mandeville, LA 70448 - Image 4
823 Lamarque Street, Mandeville, LA 70448 - Image 5
823 Lamarque Street, Mandeville, LA 70448 - Image 6
823 Lamarque Street, Mandeville, LA 70448 - Image 7
823 Lamarque Street, Mandeville, LA 70448 - Image 8
823 Lamarque Street, Mandeville, LA 70448 - Image 9
823 Lamarque Street, Mandeville, LA 70448 - Image 10
823 Lamarque Street, Mandeville, LA 70448 - Image 11
823 Lamarque Street, Mandeville, LA 70448 - Image 12
823 Lamarque Street, Mandeville, LA 70448 - Image 13
823 Lamarque Street, Mandeville, LA 70448 - Image 14
823 Lamarque Street, Mandeville, LA 70448 - Image 15
823 Lamarque Street, Mandeville, LA 70448 - Image 16
823 Lamarque Street, Mandeville, LA 70448 - Image 17
823 Lamarque Street, Mandeville, LA 70448 - Image 18
823 Lamarque Street, Mandeville, LA 70448 - Image 19
823 Lamarque Street, Mandeville, LA 70448 - Image 20
823 Lamarque Street, Mandeville, LA 70448 - Image 21
823 Lamarque Street, Mandeville, LA 70448 - Image 22
823 Lamarque Street, Mandeville, LA 70448 - Image 23
823 Lamarque Street, Mandeville, LA 70448 - Image 24
823 Lamarque Street, Mandeville, LA 70448 - Image 25
823 Lamarque Street, Mandeville, LA 70448 - Image 26
823 Lamarque Street, Mandeville, LA 70448 - Image 27
View a Virtual Tour

Single Family Home for sale in Mandeville, LA

for $490,000 with 3 bedrooms and 3 full baths. This 1,690 square foot home was built in 2022 on a lot size of 0.52.

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.

See more

Single Family Active

Price

$ 490,000

Bedrooms

3

Full Bath

3

Property Type

Single Family

Taxes

$ 0

Style

Traditional

Lot Size

0.52

Year Built

2022

Town/City

Mandeville

County/Region

Saint Tammany

MLS | Web ID

200IWX

Features
General
Living Area 1690.0
Sewer Public Sewer
Heating Central Multiple Units Natural Gas
Cooling Ceiling Fan(s) Central Air Multi Units
Utilities Electricity Connected Natural Gas Connected Sewer Connected Water Connected Internet Connected
Roof Metal
Appliances Dishwasher Microwave Dryer Gas Range Oven Range Hood Refrigerator Stainless Steel Appliance(s) Washer Gas Water Heater Tankless Water Heater
Zoning R1
Patio/Porch Features Porch Covered
Architectural Style Traditional
Security Features Carbon Monoxide Detector(s) Closed Circuit Camera(s) Security Gate Smoke Detector(s)
Construction Materials HardiPlank Type
Year Built 2022
Electric Circuit Breakers
View Neighborhood Trees/Woods
Levels Two
Property Subtype Single Family Residence
Parcel Number 58906
Community Features Close to Library Other Park
County St. Tammany
New Construction N
Property Type Residential
HOA N
Attached Garage N
Energy Efficient Appliances HVAC Insulation Lighting Water Heater Windows
Subdivision Name Lakefront
Garage Y/N N
Other Structures Guest House Shed(s)
Total Rooms 5
Full Baths 3
Status Active
Directions HEAD EAST ON FLORIDA ST TAKE RIGHT ON LAMARQUE ST. PROPERTY IS ON THE LEFT.
High School Mandeville High School
City Mandeville
Disclosures Property As Is
Senior Community Y/N N
High School District St. Tammany Parish
MLS Area None
Lot Size Units Acres
Lot Size Square Feet 22624.0
Carport Y/N N
Elementary School Woodlake Elementary School
Property Attached Y/N N
Year Built Details new construction completed in 2022
Land Lease Y/N N
Home Warranty Y/N N
Middle/Junior High School Lake Harbor Middle School Mandeville Jr High
Lease Renewal Y/N N
MLS Area Minor None
Lease Considered Y/N N
Rent Control Y/N N
Virtual Tour https://www.propertypanorama.com/instaview/roam/200IWX
Structure Type House
Living Area Units Square Feet
Standard Status Active
Occupancy Type Owner
Year Built Source Builder
Tax Lot Meas
Legal Description Sq 56 Lot Meas 112 X 202 Mandeville Cb 870 506 542 Cb 904 280 Cb 959 105 Cb 294 669 Inst No 2017986 Inst No 2073658 Inst No 2087284 [Mandeville Town F]Of]
Year Built Effective 2022
Water Body Access Y/N None
Accessibility Features Y/N None
See more
Interior
Interior Amenities Central Vacuum Computer Nook Custom Built Cabinets Double Vanity Dual Closets En Suite Granite Counters Guest Suite Separate Shower Standalone Tub Storage Walk-In Closet(s)
Flooring Tile Wood
Basement (Y/N) N
Air Conditioning Y/N Y
Heating Y/N Y
Window Features Aluminum Frames Double Pane Windows Insulated Windows Screens Window Treatments
Fireplace Y/N N
Half Baths 0
Laundry Features Electric Dryer Hookup Inside Laundry Closet Lower Level Main Level Sink Washer Hookup
Total Bedrooms 3
Total Baths 3
Heating-Natural Gas True
See more
Exterior
Exterior Amenities Entry Flat or Ramped Access Fire Pit Private Yard Smart Camera(s)/Recording Storage
Fencing Gate Wood Wrought Iron
Parking Features Concrete Driveway Open
Lot Features Back Yard Level Private Rear Yard Vehicle Access Shade Tree(s)
Water Source Public
Total Parking 4.0
Lot Size Area 0.52
Foundation Details Slab
Spa N
Building Area Total 1690.0
Lot Dimensions 112 X 202
Lot Size Acres 0.52
Road Surface Type Paved
Waterfront Y/N N
Door Features ENERGY STAR Qualified Doors
Road Frontage Type City Street
Crops Included Y/N N
Horse Y/N N
Irrigation Water Rights Y/N N
See more
Internal Only
Street Number 1 823
See more
* Excluded Features
List By
Steven Federer

Listing Agent

Affordability Calculator

$3,384
Per Month
100%
0%
0%
Monthly Principal & Interest
$3,384
Monthly Property Taxes
--
Monthly Home Insurance
--
Default based on a 30-year fixed rate of 7.375% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
5596212 Elementary School
5597693 Middle School
Mandeville High School High School
Pricing History
DatePricePrice ChangeDescription
11/1/2026$490,000 Listed Price

Map


See all

823 Lamarque Street, Mandeville, LA, 70448 is a Single Family Home for sale at $490,000 with 1,690 sqft and a lot size of 0.52. 823 Lamarque Street has 3 bedrooms, 3.0 baths, and was built in 2022. The property's zip code is 70448 which is in Mandeville, LA