Experience luxury waterfront living in this stunning 4-bedroom, 3-bath custom home, perfectly positioned along the Mohawk River in the highly sought-after Shenendehowa School District. Situated on approximately 0.78 acres that lives much larger, this exceptional property offers the perfect blend of elegance, privacy, and outdoor living. Enjoy direct river access and a beautifully landscaped backyard designed for both relaxation and entertaining, featuring a resort-style in-ground pool with a 1-year-old liner, tranquil water feature, expansive Trex deck, and mature trees that create your own private oasis. Inside, quality craftsmanship shines throughout with a chef's kitchen featuring granite countertops, spacious sun-filled living areas, a cozy gas fireplace, and timeless finishes. Recent improvements provide exceptional peace of mind, including a 3-year-old roof, new HVAC system (2024), new natural gas hot water heater, new refrigerator, and new flooring throughout the second level. The expansive basement with full-size windows and a Bilco egress offers endless possibilities to create additional finished living space. Combining luxury, thoughtful updates, direct waterfront access, and an unbeatable location, this is a rare opportunity to own one of the Capital Region's premier waterfront homes.