We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

Agent on Call

agent

Candice Scriber, REALTOR® Sales Associate
337-277-6503


$632,000
2823 CONSTANCE Street
New Orleans, LA 70115
MLS# NO2565556
2 beds  |  2.1 baths  |  2775 sqft


Photo 1
  1 / 37  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 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
Documents
Listing Info
Status: Active
Listing Date: 2026-07-16
Delayed Marketing: No
Listing Price: 632000
Current Price: $632,000
List Price/SqFt: 227.75
Type: Single Family Residence
Document Modified: 2026-09-27 01:44:48.492763
Modification Timestamp: 2026-10-14T17:33:07Z
Photo Modified: 2026-07-29T21:29:27Z
General Property Description
# Bedrooms: 2
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
SqFt - Living: 2775
SqFt - Total: 2775
SqFt - Source: Measured
Stories: 2
Year Built: 1921
Acreage Range: 0 - 0.5
Lot Dimensions: 27X158
Originating Details
Originating System ID: ROAMM
Originating System Key: 58945132
Originating System Listing ID: 2565556
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 2823
Street Name: CONSTANCE Street
Parish: Orleans
State: LA
Zip Code: 70115
Tax Assessment Number: 411202223
Directions: Bounding Streets: Magazine, Laurel, Sixth, Washington
Property Features
Siding: Wood
Parking: No Parking
Foundation: Slab
Roof: Composition
Heating: Central
Cooling: Central Air
Rooms: Bedroom 1; Bedroom 2
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Bedroom 112.0012.00Bedroom
Bedroom 214.0014.00Bedroom
Listing Documents
View Document Property Disclosure Form
View Document Disclosure of Information on Lead-Based
View Document Waiver of Warranty and Rehibition Rights
View Document Agency Disclosure Form
View Document Utility Information Sheet

IDX
Listing Office: Borrouso Realty

Last Updated: October - 14 - 2026

The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and 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.


Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503

 

CALL US: 337-984-4345

 

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.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate