Twitter
Facebook
Email
|
Experience exceptional design and quality in this stunning 2018 St. Jude Dream Home, built by Hyman Bartolo. Situated on a desirable corner lot in the heart of Lakeview, this beautifully appointed 4 bedroom, 2-1/2 bath home offers luxurious finishes, thoughtful details, and effortless everyday living. The open-concept living area features a fireplace and flows seamlessly into the chef's kitchen, complete with a premium Bosch stainless steel appliance package, including convection and steam oven, and built-in coffee system. The spacious first-floor primary suite serves as a private retreat with a spa-inspired bath featuring a curbless walk-in shower, dual shower heads, a soaking tub, and upscale finishes. Designed for both comfort and convenience, the home also includes a Generac whole-house generator, attached garage, security alarm system, custom solar shades, and abundant natural light throughout. Every detail reflects the exceptional craftsmanship and quality expected of a St. Jude Dream Home. Don't miss this rare opportunity to own one of Lakeview's most distinctive homes, combining timeless style, modern amenities, and an outstanding location. Flood Zone X
| DAYS ON MARKET | 5 | LAST UPDATED | 7/8/2026 |
|---|---|---|---|
| YEAR BUILT | 2018 | COUNTY | Orleans |
| STATUS | Active | PROPERTY TYPE(S) | Single Family |
| ADDITIONAL DETAILS | |
| AIR | Central Air, Multi Units |
|---|---|
| AIR CONDITIONING | Yes |
| APPLIANCES | Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer |
| CONSTRUCTION | Stucco |
| FIREPLACE | Yes |
| GARAGE | Attached Garage, Yes |
| HEAT | Central |
| LOT | 5663 sq ft |
| LOT DESCRIPTION | Corner Lot |
| LOT DIMENSIONS | 50 x 120 |
| PARKING | Attached, Garage |
| STORIES | 2 |
| STYLE | Traditional |
MORTGAGE CALCULATOR
TOTAL MONTHLY PAYMENT
0
P
I
*Estimate only
Listed with Coldwell Banker TEC MAGAZINE
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".