$620,000
New Orleans, LA 70115
MLS# 2565556
2 beds | 3 baths | 2775 sqft
1 / 37
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!
Details
Listing Information
Price Change Timestamp: 2026-10-30T22:12:13Z
Comp Sale YN: No
Property Sub Type: Single Family Residence
Status Change Information
Status Change Timestamp: 2026-07-16
Delayed Marketing: No
Address
Parish or County: Orleans
Street Number: 2823
Street Name: CONSTANCE
Street Suffix: Street
City Limits YN: Yes
State: LA
Postal Code (Zip): 70115
Parcel Number: 411202223
Cross Street: Magazine, Laurel, Sixth, Washington
Contract
Current Price: $620,000
Original List Price: 662000
Status: Active
Listing Contract Date: 2026-07-16
List Price: $620,000
Listing Agreement: Exclusive Right To Sell
Listing Service: Full Service
List Price/SqFt: 223.42
Interior
Bedrooms Total: 2
Bathrooms Total: 3
Bathrooms Full: 2
Bathrooms Half: 1
Living Area: 2775
Living Area Source: Measured
Building Area Total: 2775
Fireplace YN: No
Building
Year Built: 1921
Approximate Age: 76+ Years
Year Built Effective: 2017
Property Attached YN: No
Home Warranty YN: No
Lot
Lot Size Dimensions: 27X158
Remarks
Public Remarks: 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!
Utility Providers
Electric Provider: Entergy
Room Types
Bedroom Level: Second
Property Features
Utilities: Natural Gas Available; Natural Gas Available
Architectural Style: Creole Townhouse
Construction Materials: Wood Siding
Cooling: Central Air
Disclosures: Property As Is
Foundation Details: Slab
Heating: Central
Levels: Two
Lot Features: Other
Parking Features: None
Roof: Shingle
Sewer: Public Sewer
Structure Type: House
Water Source: Public
Showing Requirements: Appointment Only; Lockbox; See Remarks; Showing Service
Room Types: Bedroom
Room Information
| Room Name | Level | Dimensions |
| Bedroom | First | 12 x 12 |
| Bedroom | Second | 14 x 14 |
Listing Office: Borrouso Realty
Office Phone: 504-228-4601
Office Email: billyborrouso@gmail.com
Last Updated: October - 30 - 2026
Information deemed reliable but not guaranteed.
Broker Attribution:
504-228-4601
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.