Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Trahan Real Estate Group
Property view
Listing view 2
Listing view 3

2004 Louisa Street, 
New Orleans, LA 70117

$249,000


4

Beds


3

Baths


2,132

Sq Ft


Single Family

Pending

Listed by

Chris Smith

Keller Williams Realty New Orleans

504-862-0100

Last updated:

May 2, 2026, 10:18 AM

MLS#

NO2549499

Source:

LA RAAMLS

About This Home

2004 Louisa Street

Positioned on a commanding oversized CORNER LOT measuring 62' wide by 122' deep, this exceptional ALL BRICK residence offers space, flexibility, and efficiency in a truly compelling package. With its expansive footprint and thoughtful upgrades, this is a rare opportunity to secure a home that delivers both immediate comfort and long term value.

The main residence features 4 separate bedrooms and 2 FULL baths, complemented by a seamless open floor plan that effortlessly connects the dining area, den, living room, and Chef's Kitchen. The layout is designed for both everyday living and entertaining, filled with natural light and enhanced by newer double pane windows throughout.

Every detail has been carefully considered. ALL closets have been professionally customized by California Closets, offering refined organization and maximized storage. A spacious interior laundry center with washer and dryer included adds to the home's functionality and ease of living.

What truly sets this property apart is its remarkable energy efficiency. Outfitted with FULL SOLAR PANELS, the home delivers an average monthly electric bill of LESS THAN $30, an extraordinary benefit that dramatically reduces ongoing ownership costs. Combined with its solid brick construction and upgraded windows, this is a home built for both durability and performance.

Beyond the main residence, the property continues to impress with a detached oversized garage that also serves as a workshop or presents excellent potential for a future guest house or additional living space.

This home is in EXCELLENT MOVE IN READY condition and offers a rare combination of size, quality, and efficiency. A standout opportunity that checks every box for today's discerning buyer.

Home Facts

Single Family

3 Baths

4 Bedrooms

Built in 1969

Price Summary

249,000

$116 per Sq. Ft.

MLS #:

NO2549499

Last Updated:

May 2, 2026, 10:18 AM

Added:

a month ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

2

Interior

Living Area:

2,132 Sq. Ft.


Structure

Structure

Architectural Style:

Traditional

Building Area:

3,702 Sq. Ft.

Year Built:

1969


Lot

Lot Size (Sq. Ft):

7,562


Finances & Disclosures

Finances

Price:

$249,000

Price per Sq. Ft:

$116 per Sq. Ft.

Source:LA RAAMLS
The information being provided by REALTOR® Association Of Acadiana Mls is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 REALTOR® Association Of Acadiana Mls All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.