Twitter
Facebook
Email
|
This is what dreams are made of! Sports enthusiast: view 1st Hole of Jack Nicklaus golf course or tee off relishing game day events. Cook etouffee & jambalaya in chef's kitchen. Lounge in private pool w/sweet tea watching waterfowl in lagoon below Live Oaks. Incomparably host & entertain in formal dining, breakfast, butler's pantry, & eat-in kitchen rms. Comfortably seat 24 as sound systm music streams. Abundant parking & ensuite accommodations w/3rd Flr, self-sufficient personal haven, million dollar views & elevator. Your most attainable celebrity level mansion dream is safely tucked away in NOLA's 24-hr security-gated English Turn Estates community. Full renovations completed (2023) w/interior designer expertise. No detail nor dollar was spared to create this awe-inspiring, tranquil resort-style home. Crystal chandeliers adorn living & dining rms, others grace 2 grand staircases & 2-story wrap around foyer w/soaring 23.5' ceilings. Gourmet kitchen reimagined w/Thermador applncs, incl dbl oven, twin dishwashers, wine cooler w/2 add'l dishwashers & ice maker in adjacent butler's pantry. Finest upgrades & improvements: total interior paint, refinished heart of pine floors, 3 fireplaces' hearths, epoxied floors in garage & workrm, security system, Lutron Maestro switches, H20 heaters, 3 of 4 zoned HVAC units, int/ext speakers, & 11 gas lamps imbue iconic NOLA ambience. Lower & upper level primary bedrms w/redesigned 2nd Flr primary bath in Calacatta Gold Marble to indulge luxurious spa retreat needs. 3rd floor ste boasts kitchenette, full bath, den, dining, dressing closet, multiple attic accesses. Otherworldly views: courtyards, golf course or water elements, incl inground gunite pool, fountain, & lagoon. Prime waterfront location offers whole home generator, privacy, plus convenient commutes to FQ/Magazine (20 mins) & airport (30 mins), featuring own clubhouse community recreation. Wake up here where well-deserved, never-ending dream is an absolute reality!
| DAYS ON MARKET | 7 | LAST UPDATED | 3/19/2026 |
|---|---|---|---|
| YEAR BUILT | 2006 | COUNTY | Orleans |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air, Multi Units |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Disposal, Ice Maker, Microwave, Refrigerator |
| CONSTRUCTION | Brick |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Central |
| HOA DUES | 1650 |
| INTERIOR | Entrance Foyer |
| LOT | 0.74 acre(s) |
| LOT DESCRIPTION | On Golf Course, Waterfront |
| LOT DIMENSIONS | 151/153 x 219/203 |
| PARKING | Attached, Garage |
| POOL DESCRIPTION | In Ground |
| STORIES | 3 |
| STYLE | French |
| WATERFRONT | Yes |
| WATERFRONT DESCRIPTION | Golf Course |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Compass Kenner (LATT30)
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".