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

$825,000
400 TURQUOISE Street
New Orleans, LA 70124
MLS# NO2577539
Status: Pending
4 beds  |  3 baths  |  3173 sqft


Photo 1
  1 / 42  
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 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42

Property Description
Beautifully renovated and move-in ready in sought-after West Lakeshore, this spacious 4-bedroom, 3-bath home offers approximately 3,173 square feet with the ease of predominantly single-level living. Thoughtfully updated throughout, the home features generous living and entertaining spaces, new hardwood floors, a refreshed kitchen with new countertops, backsplash, hardware and added pantry storage, plus three beautifully renovated bathrooms. Recent improvements also include interior and exterior paint, updated lighting and fans, new landscaping, a slate patio and extensive mechanical, electrical and roof improvements. A bonus room provides additional flexible living space, while the functional floor plan offers comfort and versatility for a variety of lifestyles. Situated directly across from a neighborhood park in one of Lakeview's established residential pockets, the property enjoys convenient access to the lakefront, recreation, shopping, dining and everyday amenities.

Details
Listing Info
Status: Pending
Listing Date: 2026-09-16
Delayed Marketing: No
Listing Price: 825000
Current Price: $825,000
List Price/SqFt: 260.01
Type: Single Family Residence
Modification Timestamp: 2026-09-16T18:44:59Z
Photo Modified: 2026-09-16T18:44:33Z
General Property Description
# Bedrooms: 4
Baths - Full: 3
Total Baths: 3
SqFt - Living: 3173
SqFt - Total: 3173
SqFt - Source: Appraiser
Stories: 1
Year Built: 1953
Acreage Range: 0 - 0.5
Assn Fee $: 25
Assn Fee Terms: Yearly
Lot Dimensions: 72X96X111
Originating Details
Originating System ID: ROAMM
Originating System Key: 59778012
Originating System Listing ID: 2577539
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 400
Street Name: TURQUOISE Street
Parish: Orleans
State: LA
Zip Code: 70124
Subdivision: West Lakeshore
Tax Assessment Number: 206415001
Directions: Bounding Streets: Cameo, Opal
Status Change Info
Under Contract Date: 2026-09-16
Property Features
Style: Ranch
Siding: Vinyl Siding
Construction: Brick
Foundation: Slab
Roof: Composition; Other
Heating: Central
Cooling: Central Air
Appliances: Dishwasher; Disposal; Refrigerator
Countertops: Granite
Rooms: Bedroom 1; Den; Dining Room; Kitchen; Living Room; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6
Fencing: Wood; Other
Lot: Corner
Utilities: Elec: Entergy
Room Information
Room Name Length Width Remarks
Bedroom 111.5012.80Bedroom
Bedroom 211.6013.10Bedroom
Dining Room17.0014.00Dining Room
Dining Room17.0014.00Dining Room
Primary Bedroom17.0013.80Primary Bedroom
Primary Bedroom17.0013.80Primary Bedroom
Den21.6015.20Den
Den21.6015.20Den
Living Room21.6015.00Living Room
Living Room21.6015.00Living Room
Kitchen24.0013.00Kitchen
Kitchen24.0013.00Kitchen
Bedroom 313.0012.00Bedroom
Bedroom 413.0012.00Bedroom
Bedroom 511.6013.10Bedroom
Bedroom 611.5012.80Bedroom

IDX
Listing Office: Compass Historic (LATT09)

Last Updated: September - 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-446-6053

 

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