Welcome to a rare waterfront gem located on a tranquil cul-de-sac in the heart of Foster City. This charming Cape Cod-style 3 bed, 2.5 bath residence offers effortless single-story living, enhanced by wide-water views, designer touches, and an abundance of natural light. A dramatic glass-ceiling entry sets the tone, bathing the foyer in sunlight and creating a striking first impression. Inside, light floors and an open, airy layout invite you to relax and unwind. The updated kitchen boasts stainless steel appliances and opens seamlessly to the cozy family room - an ideal setting for casual living and entertaining. In the living room, soaring angled ceilings, a gas fireplace, and floor-to-ceiling windows frame picture-perfect waterfront vistas. The primary suite offers a serene retreat with a generous walk-in closet and a beautifully updated ensuite bath. Two additional bedrooms, a stylish hall bath, and a well-placed half bath complete the smart, comfortable layout. Step outside to the walk-out deck - perfect for soaking up the sun, hosting evening gatherings, or simply enjoying quiet moments under the stars. All of this is set within an exclusive, resort-style community boasting two sparkling pools, tennis and pickleball courts, and an array of upscale amenities.