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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Andrea Laborde, REALTOR® Sales Associate
337-277-6503


$899,000
4000 CONSTANCE Street
New Orleans, LA 70115
MLS# NO2562750
4 beds  |  2.1 baths  |  2270 sqft


Photo 1
  1 / 26  
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

Property Description
Perfectly positioned in the heart of Uptown just off Magazine Street, this distinctive former corner store New Orleans residence combines generous living spaces, historic character, and an unbeatable walkable location. Step outside your door and you're moments from some of the city's best restaurants, boutiques, and neighborhood cafes, yet tucked away on a quiet residential block that feels like a retreat. Inside, a unique and thoughtfully designed floor plan showcases soaring ceilings, abundant natural light, and architectural details that give the home its character. The main living area features a central fireplace and an easy, open flow between the living, dining, and kitchen spaces--ideal for both everyday living and effortless entertaining. A flexible first-floor room offers valuable versatility: use it as a second living area, home office, playroom, or guest suite. Nearby, French doors open to a private courtyard, seamlessly blending indoor and outdoor living. Upstairs, three well-appointed bedrooms and two full baths include a spacious primary suite with ample closet space and room for a sitting area or workspace. A full-length front balcony runs the width of the home, extending your living space outdoors and offering a classic Uptown vantage point over the neighborhood. Outside, the courtyard is a true hidden oasis. Mature landscaping, a sparkling temperature-controlled pool, and privacy walls create a tranquil escape in the middle of the city--perfect for morning coffee, evening cocktails, or weekend gatherings. Combining architectural charm, a flexible layout, and coveted proximity to Magazine Street, this home offers the exemplary Uptown lifestyle in a setting that feels both stylish and inviting.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 434.51
Document Modified: 2026-06-12 11:12:43.574320
Status: Active
Listing Date: 2026-06-12
Listing Price: 899000
Current Price: $899,000
Type: Single Family Residence
Modification Timestamp: 2026-06-16T18:54:39Z
Photo Modified: 2026-06-16T18:54:18Z
Location, Tax & Legal Info
Legal Desc: SQ 170 LOT 27
General Property Description
Lot Dimensions: 39' x 57'
Stories: 2
SqFt - Living: 2069
SqFt - Source: Measured
SqFt - Total: 2270
Acreage Range: 0 - 0.5
# Bedrooms: 4
Baths - Full: 2
Baths - 1/2: 1
Total Baths: 2.1
Year Built: 1915
Remarks & Misc
Remarks: Perfectly positioned in the heart of Uptown just off Magazine Street, this distinctive former corner store New Orleans residence combines generous living spaces, historic character, and an unbeatable walkable location. Step outside your door and you're moments from some of the city's best restaurants, boutiques, and neighborhood cafes, yet tucked away on a quiet residential block that feels like a retreat. Inside, a unique and thoughtfully designed floor plan showcases soaring ceilings, abundant natural light, and architectural details that give the home its character. The main living area features a central fireplace and an easy, open flow between the living, dining, and kitchen spaces--ideal for both everyday living and effortless entertaining. A flexible first-floor room offers valuable versatility: use it as a second living area, home office, playroom, or guest suite. Nearby, French doors open to a private courtyard, seamlessly blending indoor and outdoor living. Upstairs, three well-appointed bedrooms and two full baths include a spacious primary suite with ample closet space and room for a sitting area or workspace. A full-length front balcony runs the width of the home, extending your living space outdoors and offering a classic Uptown vantage point over the neighborhood. Outside, the courtyard is a true hidden oasis. Mature landscaping, a sparkling temperature-controlled pool, and privacy walls create a tranquil escape in the middle of the city--perfect for morning coffee, evening cocktails, or weekend gatherings. Combining architectural charm, a flexible layout, and coveted proximity to Magazine Street, this home offers the exemplary Uptown lifestyle in a setting that feels both stylish and inviting.
Office/Member/Contract Info
List AOR: NOMAR
Parking
No Parking: 1
Construction
Other: 1
Foundation
Piers: 1
Exterior
Balcony: 1
Patio
Covered: 1
Fireplace
Wood Burning: 1
Roof
Metal: 1
Heating
Central: 1
Cooling
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Dryer: 1
Refrigerator: 1
Washer: 1
Utilities
Elec: Entergy: 1
Rooms
Bedroom 1: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Bedroom 2: 1
Bedroom 3: 1
Fencing
Wood: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 58691266
Originating System Listing ID: 2562750
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 4000
Street Name: CONSTANCE Street
Parish: Orleans
State: LA
Zip Code: 70115
Tax Assessment Number: 4000
Directions: Bounding Streets: Constantinople, Magazine
Property Features
Parking: No Parking
Construction: Other
Foundation: Piers
Roof: Metal
Fireplace: Wood Burning
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Dryer; Refrigerator; Washer
Rooms: Bedroom 1; Dining Room; Kitchen; Laundry; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3
Fencing: Wood
Patio: Covered
Exterior: Balcony
Utilities: Elec: Entergy
Pool: Inground
Room Information
Room Name Remarks
LaundryLaundry
Primary BedroomPrimary Bedroom
Bedroom 1Bedroom
Living RoomLiving Room
Dining RoomDining Room
KitchenKitchen
Bedroom 2Bedroom
Bedroom 3Bedroom
Listing Documents
View Document Disclosures
View Document Floor plan

IDX
Listing Office: Crane Realtors

Last Updated: June - 16 - 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®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage