Gina Constantino
ERA Top Agent Realty
(985) 202-5457
96 Total Sales
24 in Mandeville
$230K - $650K Price Range
Estimated Value: $448,000 - $451,000
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!
Last Agent to Sell the Property
Moss Real Estate Services LLC License #995717123 Listed on: 03/31/2026
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Gina Constantino
ERA Top Agent Realty
(985) 202-5457
96 Total Sales
24 in Mandeville
$230K - $650K Price Range
STEPHANIE WOODSIDE
Keller Williams Realty New Orleans
(504) 688-4501
95 Total Sales
6 in Mandeville
$145K - $370K Price Range
DAVID TOSO
Freret Realty
(504) 677-8204
68 Total Sales
3 in Mandeville
$729,000 Price Range
Nicole Pellerin
The Pellerin Group NOLA LLC
(504) 285-9836
183 Total Sales
3 in Mandeville
$203,000 Price Range
Stacie Carubba
Crescent Sotheby's International Realty
(504) 285-2849
139 Total Sales
6 in Mandeville
$295K - $675K Price Range
Frank H. Boehm IV, J.D.
Compass Metro
(504) 290-0791
22 Total Sales
2 in Mandeville
$195,000 Price Range
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $449,900 | None Listed On Document | ||
| Impastato Salvatore James | $319,500 | Bromac Title | |
| Fain Stephen E | $289,000 | None Available | |
| Findley Catherine Franz | $278,000 | None Available |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $319,900 | ||
| Previous Owner | Fain Stephen E | $274,550 | |
| Previous Owner | Findley Catherine Franz | $222,400 |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 06/05/2026 06/05/26 | Sold | -- | -- | -- | |
| 04/06/2026 04/06/26 | Pending | -- | -- | -- | |
| 03/31/2026 03/31/26 | For Sale | $449,900 | +31.2% | $181 / Sq Ft | |
| 08/31/2017 08/31/17 | Sold | -- | -- | -- | View Prior Sale |
| 08/01/2017 08/01/17 | Pending | -- | -- | -- | |
| 04/28/2017 04/28/17 | For Sale | $343,000 | -- | $138 / Sq Ft |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $3,657 | $33,899 | $6,700 | $27,199 |
| 2024 | $3,657 | $33,899 | $6,700 | $27,199 |
| 2023 | $3,533 | $30,341 | $6,700 | $23,641 |
| 2022 | $327,759 | $30,341 | $6,700 | $23,641 |
| 2021 | $3,272 | $30,341 | $6,700 | $23,641 |
| 2020 | $3,269 | $30,341 | $6,700 | $23,641 |
| 2019 | $4,169 | $28,590 | $6,700 | $21,890 |
| 2018 | $4,175 | $28,590 | $6,700 | $21,890 |
| 2017 | $4,212 | $28,590 | $6,700 | $21,890 |
| 2016 | $4,243 | $28,590 | $6,700 | $21,890 |
| 2015 | $4,038 | $26,401 | $6,700 | $19,701 |
| 2014 | $3,998 | $26,401 | $6,700 | $19,701 |
| 2013 | -- | $26,401 | $6,700 | $19,701 |
DM
Seller's Agent in 2026
Dave mcguire
Moss Real Estate Services LLC
(504) 319-1873
21 Total Sales
EJ
Buyer's Agent in 2026
Emily Jocius
Keller Williams Realty-First Choice
(985) 630-3639
21 Total Sales
EB
Seller's Agent in 2017
Ellen Berry
O'Dwyer Realty
Buyer's Agent in 2017
Kerri Lawless
eXp Realty, LLC
(985) 960-3777
260 Total Sales
Source: New Orleans Metropolitan Association of REALTORS®
MLS Number: NO2545494
APN: 47965
Ask me questions while you tour the home.