LKV Realty
Logo
$998,000
$5,000Reward *
5878 GENERAL HAIG Street, New Orleans, LA 70124Listing ID 2485075

5878 GENERAL HAIG Street, New Orleans, LA 70124

Contingent
Lakeview
Time on site: 514 daysLast updated: Jul 29, 2025
Property Type
Property Type
Residential
Property Sub Type
Property Sub Type
Detached
Bedrooms
Bedrooms
4
Bathrooms
Bathrooms
3
Square Feet
Square Feet
4,020
Acres
Acres
0.17
Days on Site
Days on Site
513
Cooling
Cooling
Central Air, 2 Units
Heating
Heating
Central, Gas, Multiple Heating Units
Year Built
Year Built
2004
Stories
Stories
2
Parking
Parking
Detached, Garage, Off Street, Two Spaces

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.

Property Information

Property Details

Location

Address
5878 GENERAL HAIG Street
County
Orleans
City
New Orleans
Zip Code
70124
Subdivision
Lakeview

Interior Features

Beds and Baths

Bedrooms
4
Full Bathrooms
3

Building

Building Information

Square Feet
4,020
Year Built
2004
Stories
2
Construction
Brick, Concrete
Foundation
Slab
Roof
Asphalt, Shingle
Builder Name
Tad Breaux
Condition
Excellent

Financial

Special Conditions
None
Frederick Eugene Yorsch, (504) 905-6930

Market Report for 70124

* The market data shown is based on available information from Multiple Listing Service (MLS) and/or public records. Data provided is for informational and educational purposes only and may not represent the full housing market. For more accurate information, consumers should consult a certified appraiser or licensed real estate agent.

*Average of $2,150 in rewards is calculated based on the purchase or sale of a home between $400,000 to $449,000. The median home price for all housing types is in the United States is $405,400 as of 2025 as reported by the National Association of Realtors® (NAR). The actual reward amount may vary depending on the purchase or sales price of the home. Please see the Lakeview Home Rewards program terms and conditions for more details. The National Association of Realtors® is a registered trademark of the National Association of Realtors®.

Source: ROAM MLS, LLC
ROAM MLS, LLC logo

IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information Deemed Reliable But Not Guaranteed

For corrections to this data please contact Brytecore MLS Support.

YORSCFRE