An excellent opportunity for income generation or multigenerational living, this beautifully maintained two-family home is located on a quiet street in Stamford's desirable Waterside neighborhood. Thoughtfully renovated and updated throughout, the property features modern kitchens, renovated bathrooms, and stylish flooring, making it truly move-in ready. The upper unit is a spacious 3-bedroom residence featuring an inviting oversized foyer, a bright sunroom/office that provides additional living space, and a large private deck-perfect for barbecues, entertaining, or relaxing outdoors. This newly renovated unit is rented for $4,300 per month (the lease is signed and starts on August 15th). The lower unit #1 offers 3 bedrooms and is currently rented on a month-to-month basis at $4,500 per month, which is below market rent, creating an excellent opportunity to increase income potential for the next owner. It also includes a finished basement with plenty of storage, a bar area, a separate walk-out exit, and access to the garage, adding valuable additional space and convenience. A private deck overlooking the backyard creates a peaceful outdoor retreat. With a private backyard, multiple outdoor living spaces, quality updates throughout, and finished basement access, this property offers an ideal blend of comfort, flexibility, and long-term value.