2848 GRAND ROUTE SAINT JOHN Street 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.