Twitter
Facebook
Email
|
Here it is! A dream of a house with perfection in every detail. Massive living areas both upstairs and down, with rooms to fit every purpose and every need. Downstairs... a Living Room overlooking patio, pool, spa & koi pond; a den with retractable glass doors that fully-open the outdoors to indoors; an office/library/gameroom with soaring ceiling & custom millwork; a sitting room/day kitchen overlooking garden and patio; a luxury Primary Bath w/ private patio; fireplaces both indoors and out; an expansive heated pool with tanning ledge; 2 outdoor kitchen & bar areas with ice-maker, gas burners, Blaze grill; an over-sized laundry/pantry/keeping room; a fenced vegetable garden; a pristine garage that can hold 3+ cars, an RV, and much more. Upstairs... A full pub/ game-room with disappearing glass doors, a wraparound gallery and an overhead view of the stunning pool & patio; a massive media/theatre room; a granny/nanny/guest quarter with full kitchen; a second primary suite. You could not dream up a longer list of amentities, all upgraded and updated! Please see the Amenities list attached to fully understand all this house offers and to see upgrades done by this owner.
| DAYS ON MARKET | 1 | LAST UPDATED | 8/4/2026 |
|---|---|---|---|
| TRACT | Brookstone | YEAR BUILT | 2009 |
| COUNTY | St. Tammany | 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, Stucco |
| EXTERIOR | Balcony, Outdoor Kitchen, Outdoor Shower |
| FIREPLACE | Yes |
| GARAGE | Yes |
| HEAT | Central |
| HOA DUES | 1500 |
| INTERIOR | Entrance Foyer, Pantry |
| LOT | 0 |
| LOT DIMENSIONS | 32 x 326 x 43 x 367 |
| PARKING | Garage, RV Access/Parking |
| POOL DESCRIPTION | In Ground |
| STORIES | 2 |
| STYLE | French |
| SUBDIVISION | Brookstone |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Coldwell Banker TEC
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".