We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Andrea Laborde, REALTOR® Sales Associate
337-277-6503


$870,000
6471 GENERAL HAIG Street
New Orleans, LA 70124
MLS# NO2550835
Status: Pending
5 beds  |  3.1 baths  |  4216 sqft


Photo 1
  1 / 28  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28

Property Description
Welcome home to this inviting and beautifully spacious Lakeview retreat. Just two blocks from the energy of Harrison Avenue and moments from the scenic paths of City Park, this home offers a lifestyle that's as vibrant as it is peaceful. Located within the highly sought-after Hynes Charter School district, it's a place where convenience and community come together effortlessly. From the moment you step inside, you're greeted by a warm and welcoming layout designed for both everyday living and memorable gatherings. The oversized living room with built-in shelving invites you to relax and unwind, while the large dining room sets the stage for holidays, celebrations, and everything in between. The updated kitchen is both stylish and functional--truly the heart of the home. With five bedrooms, including two primary suites--one downstairs and one upstairs--this home offers incredible flexibility for guests, multi-generational living, or simply spreading out in comfort. Each suite features its own walk-in closet, creating a private retreat you'll look forward to at the end of the day. Upstairs, you'll also find spacious bedrooms, a cozy office nook, and a conveniently located laundry room designed with real life in mind. The garage adds even more value, fully insulated and air-conditioned--perfect for a home gym, workshop, or additional hangout space. This is more than just a home--it's a place to settle in, spread out, and truly enjoy everything Lakeview has to offer.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 251.15
Document Modified: 2026-04-02 08:05:36.494996
Status: Pending
Listing Date: 2026-04-01
Listing Price: 870000
Current Price: $870,000
Type: Single Family Residence
Modification Timestamp: 2026-06-09T11:59:47Z
Photo Modified: 2026-04-01T23:23:14Z
Location, Tax & Legal Info
Legal Desc: SQ 211 LOTS 1 2 LANE AND GEN HAIG 25 X 144 EA
General Property Description
Lot Dimensions: 50 x 144
Stories: 2
SqFt - Living: 3464
SqFt - Source: Measured
SqFt - Total: 4216
Acreage Range: 0 - 0.5
Pool on Subject Property: No
# Bedrooms: 5
Baths - Full: 3
Baths - 1/2: 1
Total Baths: 3.1
Year Built: 2002
Acres: 0.16
Remarks & Misc
Remarks: Welcome home to this inviting and beautifully spacious Lakeview retreat. Just two blocks from the energy of Harrison Avenue and moments from the scenic paths of City Park, this home offers a lifestyle that's as vibrant as it is peaceful. Located within the highly sought-after Hynes Charter School district, it's a place where convenience and community come together effortlessly. From the moment you step inside, you're greeted by a warm and welcoming layout designed for both everyday living and memorable gatherings. The oversized living room with built-in shelving invites you to relax and unwind, while the large dining room sets the stage for holidays, celebrations, and everything in between. The updated kitchen is both stylish and functional--truly the heart of the home. With five bedrooms, including two primary suites--one downstairs and one upstairs--this home offers incredible flexibility for guests, multi-generational living, or simply spreading out in comfort. Each suite features its own walk-in closet, creating a private retreat you'll look forward to at the end of the day. Upstairs, you'll also find spacious bedrooms, a cozy office nook, and a conveniently located laundry room designed with real life in mind. The garage adds even more value, fully insulated and air-conditioned--perfect for a home gym, workshop, or additional hangout space. This is more than just a home--it's a place to settle in, spread out, and truly enjoy everything Lakeview has to offer.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Parking
Detached: 1
Garage: 1
Construction
Brick: 1
Foundation
Slab: 1
Fireplace
Other: 1
Roof
Composition: 1
Heating
Central: 1
Cooling
Central Air: 1
Utilities
Elec: Entergy: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Kitchen: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Fencing
Wood: 1
Other: 1
Lot
Corner: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57608442
Originating System Listing ID: 2550835
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 6471
Street Name: GENERAL HAIG Street
Parish: Orleans
State: LA
Zip Code: 70124
Subdivision: Lakeview
Tax Assessment Number: 206404001
Directions: Bounding Streets: Lane St, Bragg St
Status Change Info
Under Contract Date: 2026-06-07
Property Features
Style: Traditional
Parking: Detached; Garage
Construction: Brick
Foundation: Slab
Roof: Composition
Fireplace: Other
Heating: Central
Cooling: Central Air
Rooms: Bedroom 1; Dining Room; Kitchen; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4
Fencing: Wood; Other
Lot: Corner
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Dining Room16.0014.00Dining Room
Living Room28.0018.00Living Room
Primary Bedroom20.0015.00Primary Bedroom
Bedroom 115.0013.00Bedroom
Bedroom 213.0012.00Bedroom
Bedroom 313.0012.00Bedroom
Kitchen17.0012.00Kitchen
Bedroom 411.0010.00Bedroom
Listing Documents
View Document New Attachment
View Document New Attachment
View Document New Attachment
View Document New Attachment

IDX
Listing Office: Hospitality Realty

Last Updated: June - 09 - 2026

The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503
 

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. 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 GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage