$449,900
Mandeville, LA 70471
MLS# NO2545494
4 beds | 2.1 baths | 2875 sqft
1 / 22
Property Description
Nestled in the heart of Mandeville, 1242 Clearwater Drive offers the perfect blend of comfort, space and timeless style. A welcoming curb appeal, including a sweeping driveway and mature greenery, sets the tone for what awaits inside. Step through the front door into a light-filled interior featuring soaring ceilings, rich wood flooring and an open, airy layout designed for both everyday living and effortless entertaining. The spacious living area is anchored by a cozy fireplace and framed by oversized windows that invite in natural light and peaceful backyard views. A well-appointed kitchen boasts generous counter space, abundant cabinetry, and a functional layout ideal for gathering and meal prep. The spacious primary suite serves as a private retreat with tray ceilings and a spa-like ensuite featuring dual vanities, a soaking tub and a separate glass shower. Additional bedrooms offer flexibility for family, guests or a home office. Enjoy year-round relaxation in the sunroom overlooking the expansive backyard, complete with a covered patio and plenty of room to entertain or unwind. With its desirable location, thoughtful layout and inviting charm, this home offers a standout opportunity and Mandeville living at its finest!
Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 180.83
Document Modified: 2026-03-31 17:43:52.100005
Status: Active
Listing Date: 2026-03-31
Listing Price: 449900
Current Price: $449,900
Type: Single Family Residence
Modification Timestamp: 2026-04-01T00:46:38Z
Photo Modified: 2026-03-31T20:41:03Z
Location, Tax & Legal Info
Legal Desc: LOT 117 MEADOWBROOK SUB PH 1 CB 1502 292 CB 1553 162 INST NO 956158 INST NO 1155180 INST NO 1192732 INST NO 1139925 INST NO 1801545 INST NO 1832094 INST NO 2078793
General Property Description
Lot Dimensions: 90 x 140
Stories: 1
SqFt - Living: 2488
SqFt - Source: Public Record
SqFt - Total: 2875
Assn Fee $: 208
Assn Fee Terms: Quarterly
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
Year Built: 1993
Acres: 0.32
Remarks & Misc
Remarks: Nestled in the heart of Mandeville, 1242 Clearwater Drive offers the perfect blend of comfort, space and timeless style. A welcoming curb appeal, including a sweeping driveway and mature greenery, sets the tone for what awaits inside. Step through the front door into a light-filled interior featuring soaring ceilings, rich wood flooring and an open, airy layout designed for both everyday living and effortless entertaining. The spacious living area is anchored by a cozy fireplace and framed by oversized windows that invite in natural light and peaceful backyard views. A well-appointed kitchen boasts generous counter space, abundant cabinetry, and a functional layout ideal for gathering and meal prep. The spacious primary suite serves as a private retreat with tray ceilings and a spa-like ensuite featuring dual vanities, a soaking tub and a separate glass shower. Additional bedrooms offer flexibility for family, guests or a home office. Enjoy year-round relaxation in the sunroom overlooking the expansive backyard, complete with a covered patio and plenty of room to entertain or unwind. With its desirable location, thoughtful layout and inviting charm, this home offers a standout opportunity and Mandeville living at its finest!
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Vinyl Siding: 1
Parking
Attached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Patio
Covered: 1
Fireplace
Gas Log: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Cathedral Ceiling: 1
Cooling
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Den: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Amenities
Community Pool: 1
Gated Community: 1
Fencing
Wood: 1
Other: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57231499
Originating System Listing ID: 2545494
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 1242
Street Name: CLEARWATER Drive
Parish: St. Tammany
State: LA
Zip Code: 70471
Subdivision: Meadowbrook
Tax Assessment Number: 47965
Directions: Hwy 190, enter Meadowbrook, left on Meadowbrook, right on Clearwater Bounding Streets: Meadowbrook Drive
Property Features
Style: Traditional
Siding: Stucco; Vinyl Siding
Parking: Attached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Interior: Cathedral Ceiling
Fireplace: Gas Log
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Microwave
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Laundry; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Wood; Other
Patio: Covered
Amenities: Community Pool; Gated Community
Room Information
| Room Name | Length | Width | Remarks |
| Bedroom 1 | 11.80 | 11.60 | Bedroom |
| Bedroom 2 | 15.60 | 11.00 | Bedroom |
| Dining Room | 12.00 | 11.00 | Dining Room |
| Kitchen | 17.40 | 14.30 | Kitchen |
| Bedroom 3 | 13.70 | 12.00 | Bedroom |
| Den | 24.00 | 18.00 | Den |
| Laundry | 7.70 | 5.50 | Laundry |
| Primary Bedroom | 18.60 | 15.70 | Primary Bedroom |
New Attachment IDX
Listing Office: Moss Real Estate Services LLC
Last Updated: April - 01 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.
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.