2823 Constance St, New Orleans, LA 70115

$652,000
2
BD
3
BA
2,775
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

List Price
$652,000
Price Change
▼ $10,000 1787272598
MLS#
2565556
Status
ACTIVE
Type
Single Family Residential
Style
Creole
Stories
2
Bedrooms
2
Bathrooms
3
Half-baths
1
Living Area
2,775
Parish
Orleans

Property 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!

Additional Information

Roof
Shingle
Sewer
Public Sewer
Water
Public
Property Condition
Excellent
Heating
Central
Cooling
Central Air

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Participants, subscribers, and all users acknowledge that the information contained in the Multiple Listings Service is owned by the New Orleans Metropolitan Association of REALTORS®, Inc. and no user may, nor may they authorize or allow anyone to, download the active listings, sold listing data, or other information contained in the MLS for the recommercialization (resale) or for any purpose not authorized in writing by the New Orleans Metropolitan Association of REALTORS®, Inc. or the Gulf South Real Estate Information Network, Inc. Copyright 2026, New Orleans Metropolitan Association of REALTORS®, Inc. All rights reserved. Information deemed reliable, but not verified or guaranteed. Users are responsible for checking the accuracy, completeness, currency, and status of all information. The sharing of MLS database, or any portion thereof, with any unauthorized third party is strictly prohibited. Information contained on this site is believed to be reliable; yet, users of this web site are responsible for checking the accuracy, completeness, currency, or suitability of all information. Neither the New Orleans Metropolitan Association of REALTORS®, Inc. nor the Gulf South Real Estate Information Network, Inc. makes any representation, guarantees, or warranties as to the accuracy, completeness, currency, or suitability of the information provided. They specifically disclaim any and all liability for all claims or damages that may result from providing information to be used on the web site, or the information which it contains, including any web sites maintained by third parties, which may be linked to this web site. The information being provided is for the consumer’s personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties which consumers may be interested in purchasing. The user of this site is granted permission to copy a reasonable and limited number of copies to be used in satisfying the purposes identified in the preceding sentence. By using this site, you signify your agreement with and acceptance of these terms and conditions. If you do not accept this policy, you may not use this site in any way. Your continued use of this site, and/or its affiliates’ sites, following the posting of changes to these terms will mean you accept those changes, regardless of whether you are provided with additional notice of such changes. Listing data provided by GSREIN. Listing data is deemed accurate but not guaranteed. Other Broker's Listing.