5400 LAMPIASI STREET Beautifully upgraded waterfront home with premium corner-lot privacy in the sought-after gated Esplanade at Palmer Ranch—offering direct gated access to the Legacy Trail just steps from your door. This rarely available Roma model features 2 bedrooms, 2 bathrooms plus den, an extended and oversized screened lanai, and a thoughtfully designed open floor plan ideal for both everyday living and entertaining. Situated on a premium corner waterfront lot, the home delivers peaceful views, added privacy, and seamless indoor–outdoor living. Notable structural upgrades include: • Extended kitchen • Primary suite bump-out • Trey ceilings • 8-foot interior doors • 4-foot garage extension • Gas line on lanai Designer and interior enhancements: • Crown molding throughout • Upgraded tile flooring • Plantation shutters and custom window treatments • Custom wall accents • New lighting fixtures • Culligan whole-home water filtration system • Upgraded laundry room with added cabinetry and backsplash The gourmet natural gas kitchen is perfect for entertaining, while the primary bath features a frameless glass shower enclosure for a spa-like retreat. Legacy Estates at Esplanade on Palmer Ranch is a gated, maintenance-free community offering world-class amenities: On-site Bahama Bar restaurant, resort-style pool, resistance pool, splash park, and hot tub Fitness center and private fitness studio with daily classes 8 pickleball courts, 2 tennis courts, and 3 dog parks Nature trail and direct access to the Legacy Trail—offering the perfect blend of luxury, lifestyle, and location. Schedule your private showing today.