For Sale
3D Tour3D Tour
Single family home for sale at 2823 Constance St, New Orleans, LA 70115 | MLS# 2565556 | Listing updated on 2026-10-22
Photo 1 of Single family home for sale at 2823 Constance St, New Orleans, LA 70115 | MLS# 2565556 | Listing updated on 2026-10-22
Photo 2 of Single family home for sale at 2823 Constance St, New Orleans, LA 70115 | MLS# 2565556 | Listing updated on 2026-10-22
Photo 3 of Single family home for sale at 2823 Constance St, New Orleans, LA 70115 | MLS# 2565556 | Listing updated on 2026-10-22
Photo 4 of Single family home for sale at 2823 Constance St, New Orleans, LA 70115 | MLS# 2565556 | Listing updated on 2026-10-22
33+
Beds Icon

Virtual Tour

Beds Icon

Street View

$632,000

Monthly Est:$3,146

  • Beds Icon2 Beds
  • Beds Icon
    3 Baths
  • Beds Icon2,775sqft

2823 Constance St, New Orleans, LA 70115

$3,146/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1921

  • $-- HOA

  • -- sqft lot

  • $228/sq.ft

Description

Charming duplex in a highly sought-after Uptown location just steps from Magazine Street. Both units feature updated kitchens, spacious rooms, soaring ceilings, beautiful wood floors, and timeless New Orleans character. An excellent opportunity for an owner-occupant or investor seeking rental income in one of the city's most desirable neighborhoods.The back unit features a tankless water heater and was renovated in 2020 when it operated as a short-term rental. It performed exceptionally well as a short-term rental for three years, providing an excellent opportunity to continue as an income-producing property. The front unit features a newer AC compressor for added comfort and efficiency.The entire property was renovated in 2017, including foundation work, and is zoned as a historic home. The property also offers flexibility to be converted back into a single-family residence by simply removing the small wall near the stairs in the front unit.Enjoy the convenience of a prime Uptown location with a strong neighborhood feel, where many residents have called the area home for over 20 years. Experience easy access to popular restaurants, shopping, and local attractions. 24-hour advance notice is required for all showings due to tenant occupancy. Schedule your private showing today!

  • Houzeo last checked: 5 hours ago
  • Listing updated: October 22, 2026 at 7:58 pm
  • Listing Provided by: William Martin Borrouso (504) 228-4601 DRE #995683671 | Borrouso Realty (504) 228-4601
  • Source: Regional One Access Multiple Listing Service | MLS#: 2565556 Regional One Access Multiple Listing Service

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Orleans County

  • City

    New Orleans

  • Neighborhood

    Garden District

  • Year Built

    1921

  • HOA Fees

    -

  • Finished Area

    2,775 sqft

  • Lot Size

    -- sqft lot

  • Basement Area

    - sqft

  • MLS Name

    Regional One Access Multiple Listing Service

  • MLS Number

    2565556

  • MLS Status

    Active

  • Days on Market

    105

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 2

    Bathrooms: 3

Interior

  • Cooling

    Central Air

  • Heating

    Central

  • Sewer

    Public Sewer

Construction

  • Year Built

    Year Built: 1921

  • Home type

    Single Family Residence

  • Architectural Style

    Creole Townhouse

  • Foundation Details

    Slab

  • Roof

    Shingle

  • Construction Materials

    Wood Siding

Utilities & Energy

  • Parking Features

    None

  • Water Source

    Public

  • Utilities

    Natural Gas Available

Other Features

  • Disclosures

    Property As Is

  • Lot Features

    Other

Price History

DateEventPrice

09/29/2026

Source: mls_logoRegional One Access Multiple Listing Service #2565556

Listed for Sale

$632,000 +28627.27%

$395/sqft

03/16/2026

Source: mls_logoRegional One Access Multiple Listing Service #2535481

Sold

$2,200 -99.66%

$1/sqft

12/26/2025

Source: mls_logoNew Orleans Metropolitan AOR (NOMAR) MLS-LA #2535479

Off Market

$649,000

$406/sqft

12/12/2025

Source: mls_logoREALTOR® Association of Acadiana (Lafayette) MLS-LA #NO2506924

Listing Removed

$649,000

$406/sqft

09/12/2025

Source: mls_logoREALTOR® Association of Acadiana (Lafayette) MLS-LA #NO2506924

Listed for Sale

$649,000 -4.56%

$406/sqft

Show more

Garden District Ranks #5 in New Orleans, LA

Homes for sale
49

Homes

Rental prices
$1,426

Rental Prices

Median Home Price
$605K

Median Home Price

Garden District, New Orleans, LA neighborhood guide

Nearby Homes

Based on information from the ROAM MLS through Oct 29, 2026, 02:15PM. IDX information is provided exclusively for consumers' personal, non-commercial use. It 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. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 ROAM MLS. All Rights Reserved.

Advertising Broker: Karen Stokes | Fleur De Lis Realty Group

Skip to Main Content