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


$825,000
2848-50 GRAND ROUTE SAINT JOHN Street
New Orleans, LA 70119
MLS# NO2577472
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
Stunning Eastlake Bayou St John residence with attached apartment - this beautiful home has been impeccably designed with House of Hazard and renovated with attention to every detail! With 2,270 SF under roof, the main residence offers 1802 SF with 2 bedrooms, 2 baths, and a home office. The double parlors serve as the formal living and dining rooms, while the redesigned and expanded kitchen features a 36" La Cornue range, Thermador refrigerator/freezer, dishwasher and beverage center, and Bosch speed oven (all appliances 2023), along with handmade Tabarka Studio terracotta tile, custom cabinetry with Rejuvenation hardware, and Ralph Lauren pendant lights. The kitchen is an entertainer's dream! The primary suite was also expanded and reimagined by adding a custom floating vanity with quartzite counters, Kelly Wearstler sconces, marble tile floor, shower, and chair rail from locally owned Stafford Tile & Stone, and a fully built-out walk-in closet. The 468 SF apartment features a separate entrance, one bedroom, one bathroom, and a kitchen with appliances and washer & dryer included. The apartment could also easily be incorporated back into the main house. The home's original architectural details remain intact, complemented by updated systems and finishes that make it truly turn-key. Refinished wood floors, custom window treatments, and designer lighting and hardware are found throughout. Low-maintenance turf and landscaping offer easy lock-and-leave living, while the attached apartment provides flexible guest space, rental income potential, or room to expand. The roof was replaced in 2022, with HVAC systems replaced in 2026 and 2022. The elevated deck, rebuilt in 2025, offers both sunrise and sunset views, and the home is equipped with a security system and closed-circuit cameras. This custom home is located just blocks from the Fair Grounds and Jazz Fest, with easy access to the restaurants and conveniences along Esplanade Avenue and nearby Bayou St. John.

Details
Documents
Listing Info
Status: Active
Listing Date: 2026-09-21
Delayed Marketing: No
Listing Price: 825000
Current Price: $825,000
List Price/SqFt: 363.44
Type: Duplex
Document Modified: 2026-10-12 11:10:07.459737
Modification Timestamp: 2026-10-12T16:15:13Z
Photo Modified: 2026-09-28T22:21:59Z
General Property Description
Number of Units: 2
Stories: 1
SqFt - Total: 2270
SqFt - Source: Measured
Individual Metered?: Yes
Lot Dimensions: 33x125
Currently Not Used
Acreage Range: 0 - 0.5
Originating Details
Originating System ID: ROAMM
Originating System Key: 59775124
Originating System Listing ID: 2577472
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 2848-50
Street Name: GRAND ROUTE SAINT JOHN Street
Parish: Orleans
State: LA
Zip Code: 70119
Tax Assessment Number: 17
Directions: Esplanade towards downtown, take LEFT on Grand Route, house on RIGHT Bounding Streets: Esplanade, Gentilly, N. Broad
Property Features
Siding: Wood
Parking: No Parking
Foundation: Piers
Roof: Composition
Heating: Central
Cooling: Central Air
Exterior: Balcony
Fencing: Other
Owner Pays: Electric; Gas; Water
Listing Documents
View Document Disclosures + Addendums
View Document Floorplan + Additional Features
View Document Insurances
View Document Floorplan + Additional Features
View Document Floorplan + Additional Features
View Document Floorplan + Additional Features

IDX
Listing Office: McEnery Residential, LLC

Last Updated: October - 12 - 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