Skip main navigation
Active
  • Price cut: $10K (9/1)
    $642,000

    2823 Constance St, New Orleans, LA 70115

    2beds
    2,775sqft
    : 
    $4,217/mo
    Get pre-qualified
    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
    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!
    36 days
    388
    25

    Zillow last checked:

    Listing updated:

    Listed by:

    William Borrouso 504-228-4601,

    Borrouso Realty 504-228-4601

    Source: GSREIN,MLS#: 2565556MLS Logo

      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

        DateEventPrice
        9/1/2026Price change$642,000-1.5%$231/sqft
        Source: GSREIN #2565556 Report a problem
        8/20/2026Price change$652,000-1.5%$235/sqft
        Source: GSREIN #2565556 Report a problem
        7/28/2026Listed for sale$662,000+2%$239/sqft
        Source: GSREIN #2565556 Report a problem
        3/23/2026Listing removed$649,000$234/sqft
        Source: GSREIN #2535479 Report a problem
        12/26/2025Listed for sale$649,000$234/sqft
        Source: GSREIN #2535479 Report a problem
        11/13/2025Listing removed$649,000$234/sqft
        Source: GSREIN #2506924 Report a problem
        9/12/2025Listed for sale$649,000-3%$234/sqft
        Source: GSREIN #2506924 Report a problem
        9/3/2025Listing removed$669,000$241/sqft
        Source: GSREIN #2506924 Report a problem
        6/13/2025Listed for sale$669,000-1.6%$241/sqft
        Source: GSREIN #2506924 Report a problem
        6/12/2025Listing removed$680,000$245/sqft
        Source: GSREIN #2484476 Report a problem
        3/29/2025Price change$680,000-1.3%$245/sqft
        Source: GSREIN #2484476 Report a problem
        1/27/2025Listed for sale$689,000+46.6%$248/sqft
        Source: GSREIN #2484476 Report a problem
        9/13/2021Sold--
        Source: GSREIN #2308197 Report a problem
        7/9/2020Listing removed$1,800$1/sqft
        Source: Nola Home Realty Group #2253782 Report a problem
        7/7/2020Price change$1,800-10%$1/sqft
        Source: Nola Home Realty Group #2253782 Report a problem
        6/28/2020Price change$2,000-9.1%$1/sqft
        Source: Nola Home Realty Group #2253782 Report a problem
        6/5/2020Listed for rent$2,200+22.2%$1/sqft
        Source: Nola Home Realty Group #2253782 Report a problem
        10/6/2018Listing removed$1,800$1/sqft
        Source: Keller Williams Realty 455-0100 #2175318 Report a problem
        9/30/2018Listed for rent$1,800$1/sqft
        Source: KELLER WILLIAMS REALTY 455-0100 #2175318 Report a problem
        8/16/2018Sold--
        Source: GSREIN #2100668 Report a problem
        7/17/2018Pending sale$470,000$169/sqft
        Source: Valmont Realtors #2100668 Report a problem
        6/18/2018Price change$470,000-5.8%$169/sqft
        Source: Valmont Realtors #2100668 Report a problem
        5/18/2018Price change$499,000-4.8%$180/sqft
        Source: Valmont Realtors #2100668 Report a problem
        3/5/2018Listed for sale$524,000$189/sqft
        Source: Valmont Realtors #2100668 Report a problem
        2/15/2018Pending sale$524,000$189/sqft
        Source: Valmont Realtors #2100668 Report a problem
        1/11/2018Listed for sale$524,000$189/sqft
        Source: Valmont Realtors #2100668 Report a problem
        11/6/2006Sold--
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax 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

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: Irish Channel

        Getting around

        89 / 100
        Very Walkable
        54 / 100
        Good Transit
        74 / 100
        Very Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        A local lender can help you make sure your offer is ready when you are.

        Browse local experts