x
Showing 1 of 0
X
Save

2004 LOUISA Street
New Orleans LA 70117 US

$249,000

Active Listing ID 2549499
bed icon
4 bed
bath icon
3.00 Bath (2 Full , 1 Half)
home icon
Single Family Residence

$249,000

Active Listing ID 2549499
Save

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.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 2
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Courtyard, Fence, Outdoor Entertainment Area Beyond Your Average Patio, Porch, Security Cameras, Window Screens, Guest House, Workshop
  • Roof Type: Shingle
  • Heating Fuels: Central, Fireplace(s)
  • Additional Features
  • Fireplace
  • Patio

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 249000
  • unparsedaddress: 2004 LOUISA Street
  • postalcity: New Orleans
  • stateorprovince: LA
  • country: US
  • postalcode: 70117
  • bathroomsfull: 2
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 2132
  • livingareaunits: Square Feet
  • listagentfullname: Chris Smith
  • listagentemail: RealtorChrisSmith@gmail.com
  • listagentkey: 3yd-NOMARLA-smithchr
  • listagentmlsid: smithchr
  • listagentpreferredphone: 5042312004
  • listagentofficephone: 5048620100
  • listofficekey: 3yd-NOMARLA-KEWI01
  • listofficemlsid: KEWI01
  • disclaimer: Copyright © 2026 New Orleans Metropolitan Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: NOMARLA
  • yearbuilt: 1969
  • listingcontractdate: 2026-03-25
  • listagenturl: https://neworleans.yourkwoffice.com/
  • countyorparish: Orleans
  • appliances: Dishwasher, Dryer, Microwave, Range, Refrigerator, Washer
  • cooling: Central Air
  • constructionmaterials: Brick
  • heating: Central, Fireplace(s)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1
  • parkingtotal: 0
  • parkingfeatures: Garage
  • roof: Shingle
  • waterfrontyn: False
  • franchiseaffiliation: Keller Williams Realty
  • interiorfeatures: Ceiling Fan, Electric Garage, Granite Counters, No Carpet, Pantry, Pull Down Attic Stairs, Stainless Steel Appliances, Washer/Dryer Hookups
  • exteriorfeatures: Courtyard, Fence, Outdoor Entertainment Area Beyond Your Average Patio, Porch, Security Cameras, Window Screens, Guest House, Workshop
  • architecturalstyle: New Traditional
  • rooms: Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4
  • otherstructures: Guest House, Workshop
  • utilities: Electricity Available
  • patioandporchfeatures: Patio, Porch
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • fencing: Fenced
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"HODC LLC dba Keller Williams Realty New Orleans", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"RealtorChrisSmith@gmail.com", "ListBrokerageCity":"New Orleans", "ListBrokerageCountry":"US", "ListBrokerageEmail":"klrw125@kw.com", "ListBrokerageLogoUrl":null, "ListBrokerageName":"HODC LLC dba Keller Williams Realty New Orleans", "ListBrokeragePhone":"(504) 862-0100", "ListBrokeragePostalCode":"70118", "ListBrokerageStateOrProvince":"LA", "ListBrokerageUnitNumber":"Leake Ave", "ListBrokerageUnparsedAddress":"8601 Leake Ave", "ListBrokerageWebsiteUrl":"https://neworleans.yourkwoffice.com/", "ListOfficeAddress1":"8601 Leake Ave.", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"New Orleans", "ListOfficeCountry":"US", "ListOfficeEmail":"klrw125@kw.com", "ListOfficePostalCode":"70118", "ListOfficeStateOrProvince":"LA", "ListPriceCurrencyType":"USD", "ListingTitle":"Single Family - Detached, Traditional - New Orleans, LA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/2004-Louisa-St_New-Orleans_LA_70117_M83961-52003?f=listhub&s=NOMARLA&m=2549499&c=rexren", "MLSModificationTimestamp":"2026-03-25T13:56:40Z", "Neighborhoods":[{"Description":null, "Name":"St Claude"}], "PostalCode":null, "RawPropertySubType":"Single Family - Detached", "RawPropertyType":"Residential", "RoomCount":8, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 3/25/2026 8:04:36 PM GMT
Source Updated Date: 3/28/2026 6:51:25 PM GMT

Courtesy of: Chris Smith, Keller Williams Realty New Orleans, RealtorChrisSmith@gmail.com

Copyright © 2026 New Orleans Metropolitan Association of REALTORS®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.