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!
Active
Price cut: $10K (9/1)
$642,000
2823 Constance St, New Orleans, LA 70115
2beds
2,775sqft
Townhouse, Single Family Residence
Built in 1921
4,266 Square Feet Lot
$626,600 Zestimate®
$231/sqft
$-- HOA
What's special
Tankless water heaterNewer ac compressorUpdated kitchensSoaring ceilingsSpacious roomsBeautiful wood floors
- 36 days
- 388
- 25
Zillow last checked:
Listing updated:
Listed by:
William Borrouso 504-228-4601,
Borrouso Realty 504-228-4601
Source: GSREIN,MLS#: 2565556
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 2
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Bedroom
- Level: First
- Dimensions: 12 x 12
Bedroom
- Level: Second
- Dimensions: 14 x 14
Heating
- Central
Cooling
- Central Air
Features
- Has fireplace: No
- Fireplace features: None
Interior area
- Total structure area: 2,775
- Total interior livable area: 2,775 sqft
Property
Parking
- Parking features: None
Features
- Levels: Two
- Stories: 2
Lot
- Size: 4,266 Square Feet
- Dimensions: 27 x 158
- Features: City Lot, Rectangular Lot
Details
- Parcel number: 411202223
- Special conditions: None
Construction
Type & style
- Home type: Townhouse
- Architectural style: Creole
- Property subtype: Townhouse, Single Family Residence
Materials
- Wood Siding
- Foundation: Slab
- Roof: Shingle
Condition
- Excellent
- Year built: 1921
Utilities & green energy
- Sewer: Public Sewer
- Water: Public
Community & HOA
HOA
- Has HOA: No
Location
- Region: New Orleans
Financial & listing details
- Price per square foot: $231/sqft
- Tax assessed value: $520,500
- Annual tax amount: $5,966
- Date on market: 7/16/2026
Estimated market value
$626,600
$595,000 - $658,000
$3,461/mo
Price history
| Date | Event | Price |
|---|---|---|
| 9/1/2026 | Price change | $642,000-1.5%$231/sqft |
Source: | ||
| 8/20/2026 | Price change | $652,000-1.5%$235/sqft |
Source: | ||
| 7/28/2026 | Listed for sale | $662,000+2%$239/sqft |
Source: | ||
| 3/23/2026 | Listing removed | $649,000$234/sqft |
Source: | ||
| 12/26/2025 | Listed for sale | $649,000$234/sqft |
Source: | ||
| 11/13/2025 | Listing removed | $649,000$234/sqft |
Source: | ||
| 9/12/2025 | Listed for sale | $649,000-3%$234/sqft |
Source: | ||
| 9/3/2025 | Listing removed | $669,000$241/sqft |
Source: | ||
| 6/13/2025 | Listed for sale | $669,000-1.6%$241/sqft |
Source: | ||
| 6/12/2025 | Listing removed | $680,000$245/sqft |
Source: | ||
| 3/29/2025 | Price change | $680,000-1.3%$245/sqft |
Source: | ||
| 1/27/2025 | Listed for sale | $689,000+46.6%$248/sqft |
Source: | ||
| 9/13/2021 | Sold | -- |
Source: | ||
| 7/9/2020 | Listing removed | $1,800$1/sqft |
Source: Nola Home Realty Group #2253782 Report a problem | ||
| 7/7/2020 | Price change | $1,800-10%$1/sqft |
Source: Nola Home Realty Group #2253782 Report a problem | ||
| 6/28/2020 | Price change | $2,000-9.1%$1/sqft |
Source: Nola Home Realty Group #2253782 Report a problem | ||
| 6/5/2020 | Listed for rent | $2,200+22.2%$1/sqft |
Source: Nola Home Realty Group #2253782 Report a problem | ||
| 10/6/2018 | Listing removed | $1,800$1/sqft |
Source: Keller Williams Realty 455-0100 #2175318 Report a problem | ||
| 9/30/2018 | Listed for rent | $1,800$1/sqft |
Source: KELLER WILLIAMS REALTY 455-0100 #2175318 Report a problem | ||
| 8/16/2018 | Sold | -- |
Source: | ||
| 7/17/2018 | Pending sale | $470,000$169/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 6/18/2018 | Price change | $470,000-5.8%$169/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 5/18/2018 | Price change | $499,000-4.8%$180/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 3/5/2018 | Listed for sale | $524,000$189/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 2/15/2018 | Pending sale | $524,000$189/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 1/11/2018 | Listed for sale | $524,000$189/sqft |
Source: Valmont Realtors #2100668 Report a problem | ||
| 11/6/2006 | Sold | -- |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2026 | $5,966 -4.6% | $52,050 -4% |
| 2025 | $6,253 -1.5% | $54,220 |
| 2024 | $6,346 +11.9% | $54,220 +15.1% |
| 2023 | $5,669 -15.2% | $47,100 |
| 2022 | $6,687 -5.7% | $47,100 -4.3% |
| 2021 | $7,088 +33.9% | $49,240 +35.2% |
| 2020 | $5,293 -3.8% | $36,410 |
| 2019 | $5,501 | $36,410 |
| 2018 | $5,501 | $36,410 |
| 2017 | $5,501 -1.9% | $36,410 -11.2% |
| 2016 | $5,610 +8.7% | $41,000 |
| 2015 | $5,163 | $41,000 |
| 2014 | $5,163 +2.1% | $41,000 |
| 2013 | $5,059 | $41,000 +11.4% |
| 2012 | -- | $36,810 |
| 2011 | -- | $36,810 -13.5% |
| 2010 | -- | $42,550 |
| 2009 | -- | $42,550 |
| 2007 | -- | $42,550 +463.6% |
| 2006 | -- | $7,550 |
| 2004 | -- | $7,550 +10.2% |
| 2002 | -- | $6,850 |
| 2001 | -- | $6,850 |
| 2000 | -- | $6,850 |
Find assessor info on the county website
Monthly payment
Est. payment







