Twitter
Facebook
Email
|
A rare offering in a gated Madisonville community, this exceptional residence delivers the feel of a custom-built luxury retreat with less than two years of occupancy. Thoughtfully curated well beyond standard builder finishes, the home pairs sophisticated interiors with a spectacular private outdoor resort. At the heart of the home, the chef-inspired kitchen is appointed with a premium Forno appliance package, seamless quartz waterfall countertops, an oversized entertaining island, pot filler, herringbone backsplash, under-cabinet lighting and reverse-osmosis filtration. Designer lighting, custom details and a dramatic 36" linear fireplace with floor-to-ceiling shiplap elevate the open-concept living spaces. The private primary suite offers its own dedicated HVAC, dual executive-style closets and a spa-inspired bath wrapped in floor-to-ceiling marble tile. The backyard is truly extraordinary, with more than $150,000 invested in a professionally designed resort oasis. A custom 36' x 18' gunite pool features PebbleTec finish, a tanning ledge, illuminated waterfalls, fire features, attached spa, heater/chiller and smart Jandy automation. The expansive covered outdoor kitchen is designed for effortless entertaining with built-in gas and pellet grills, cooktop, sink and an oversized Big Ass Fans(r) ceiling fan. Premium marble, artificial turf, tropical landscaping with 10 palm trees, landscape lighting, fire pit and outdoor shower complete the private resort setting. With dual HVAC systems, Vivint smart-home features, extensive designer upgrades and exceptionally low-maintenance outdoor living, this home offers a level of finish, comfort and lifestyle that would be difficult to recreate today.
| DAYS ON MARKET | 2 | LAST UPDATED | 8/18/2026 |
|---|---|---|---|
| TRACT | Coquille | YEAR BUILT | 2023 |
| COUNTY | St. Tammany | STATUS | Active |
| PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Ice Maker, Refrigerator |
| CONSTRUCTION | Brick, HardiPlank Type |
| EXTERIOR | Outdoor Kitchen |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Central |
| HOA DUES | 50 |
| LOT | 0.3099 acre(s) |
| LOT DIMENSIONS | 90 x 150 |
| PARKING | Attached, Garage |
| POOL DESCRIPTION | In Ground |
| STORIES | 1 |
| STYLE | Contemporary |
| SUBDIVISION | Coquille |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with The W Group Real Estate LLC
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 ReHive LLC are marked with the MLS approved icon for IDX (a little black house).
IDX information is provided exclusively for consumers’ personal, non-commercial use, that it 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.
Copyright 2026 REALTOR® Association of Acadiana MLS. All rights reserved
This IDX solution is (c) Diverse Solutions 2026.
| SATELLITE VIEW |
| / | |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for ReHive
Real Estate to contact you even if your name is on a Federal or State
"Do not call List".