Skip main navigation
Active under contract
  • $998,000

    5878 General Haig St, New Orleans, LA 70124

    4beds
    3,464sqft
    : 
    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
    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.
    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#: 2485075MLS Logo
    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