Stunning & stately Lakeview home located on a corner lot within walking distance to City Park, restaurants, & schools. This designer-built custom home by Tad Breaux of Design Build Custom Homes offers a unique architectural design & a large open floorplan w/soft contemporary touches.
As you enter through the elegant 9ft Solid Spanish Cedar door, you will be greeted by the grandeur of 10ft ceilings & 8ft interior doors featured downstairs. The first floor boasts an open floor plan with oversized windows, dining room, & wet bar area. The stylish kitchen features a glass backsplash, stone countertops, Wolf gas stove & oven, Sub-Zero freezer, refrigerator, two wine coolers, & an oversized island great for entertaining. The living room features a cozy gas fireplace, & there is a spare bedroom connected to a full bath, convenient for guests.
On the second floor, you will find the master suite w/ a custom closet & master bath that includes double sinks, large jacuzzi tub, & shower. The second floor also offers two additional bedrooms, a second full bathroom (Jack & Jill), & an office.
This home is adorned with specialty Corbett light fixtures, Emtek crystal door knobs, Leviton smart dimmer switches, an indoor & outdoor sound system, security cameras, a home generator, a stunning heated salt-water pool, & an outdoor entertaining space. Additional features include a tankless hot water heater, two separate attics for storage, a front & rear yard irrigation system, a landscaped yard, exterior soffit lighting, ground lighting, & an 8ft fence providing privacy to enjoy the pool oasis within.
The lot is 145' deep & includes a detached two-car garage w/ additional storage at the rear. The Lakeview Crime Prevention District provides extra security for this area. The property is in an X flood zone, & the assumable flood ins. is $930 yearly. Additionally, the property is under a Terminix termite contract. This home has many great features & details that must be seen. OWNER is a licensed real estate agent.
Active under contract
$998,000
5878 General Haig St, New Orleans, LA 70124
4beds
3,464sqft
Est.:
Single Family Residence
Built in 2004
7,248.38 Square Feet Lot
$-- Zestimate®
$288/sqft
$-- HOA
What's special
Detached two-car garageHome generatorAdditional storageHeated salt-water poolLandscaped yardLarge open floorplanLeviton smart dimmer switches
- 149 days
- on Zillow |
- 528 |
- 25 |
Zillow last checked: 7 hours ago
Listing updated: July 29, 2025 at 01:41pm
Listed by:
Frederick Yorsch 504-905-6930,
Frederick Eugene Yorsch 504-905-6930
Source: GSREIN,MLS#: 2485075

Travel times
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 21.90 x 16.80
Bedroom
- Description: Flooring: Wood
- Level: First
- Dimensions: 16.10 x 17.60
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 14.90 x 12.20
Bedroom
- Description: Flooring: Carpet
- Level: Second
- Dimensions: 13.80 x 17.60
Dining room
- Description: Flooring: Stone
- Level: First
- Dimensions: 15.70 x 14.70
Kitchen
- Description: Flooring: Stone
- Level: First
- Dimensions: 15.20 x 14.40
Laundry
- Description: Flooring: Tile
- Level: Second
- Dimensions: 12.20 x 5.10
Living room
- Description: Flooring: Stone
- Level: First
- Dimensions: 0.00 x 0.00
Office
- Description: Flooring: Wood
- Level: Second
- Dimensions: 11.80 x 16.60
Heating
- Central, Gas, Multiple Heating Units
Cooling
- Central Air, 2 Units
Appliances
- Included: Dishwasher, Ice Maker, Microwave, Oven, Range, Refrigerator, Wine Cooler
Features
- Attic, Wet Bar, Ceiling Fan(s), Guest Accommodations, Granite Counters, Stainless Steel Appliances
- Has fireplace: Yes
- Fireplace features: Gas
Interior area
- Total structure area: 4,020
- Total interior livable area: 3,464 sqft
Property
Parking
- Parking features: Detached, Garage, Off Street, Two Spaces
- Has garage: Yes
Features
- Levels: Two
- Stories: 2
- Patio & porch: Concrete, Patio
- Exterior features: Fence, Sprinkler/Irrigation, Patio, Sound System
- Pool features: In Ground, Salt Water
Lot
- Size: 7,248.38 Square Feet
- Dimensions: 50 x 145
- Features: Corner Lot, City Lot, Rectangular Lot
Details
- Parcel number: 206308813
- Special conditions: None
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Brick, Concrete
- Foundation: Slab
- Roof: Asphalt,Shingle
Condition
- Excellent
- Year built: 2004
Details
- Builder name: Tad Breaux
Utilities & green energy
- Electric: Generator
- Sewer: Public Sewer
- Water: Public
Green energy
- Energy efficient items: Insulation, Water Heater
Community & HOA
Community
- Security: Security System, Closed Circuit Camera(s)
- Subdivision: Lakeview
HOA
- Has HOA: No
Location
- Region: New Orleans
Financial & listing details
- Price per square foot: $288/sqft
- Tax assessed value: $390
- Annual tax amount: $4
- Date on market: 3/21/2025
- Loading