Welcome to a wildly rare waterfront opportunity. Tucked away at the very end of a dead-end street, this 0.69-acre property is the ultimate private sanctuary, boasting no neighbors on three sides and a million-dollar panoramic view of the Oneida River. With 144 feet of pristine, immaculate river frontage, the outdoor footprint is already set up for extraordinary waterfront living. Imagine launching a boat directly from your backyard, or hosting unforgettable summer gatherings by the water's edge. A massive two-tier dock complete with a gazebo waits right on the water, offering front-row seats to spectacular sunsets and river life. A convenient two-car garage sits at the front of the property. The existing 1,200-square-foot open ranch is a true blank canvas requiring a contractor’s mindset or a buyer with the vision to turn this rough diamond into an absolute masterpiece. The home is positioned perfectly to overlook the water, featuring huge windows in the main living space and a rear bump-out that flood the floor plan with natural light and frame those unmatched river views. Whether you envision a sleek, modern waterfront retreat or a cozy, rustic weekend getaway, the footprint and the breathtaking backdrop are already here waiting for your custom touch. While the property will require a large investment to reach its full potential, critical heavy-lifting mechanicals have already been updated, including two mini-splits, a new electrical service and breaker box, and a new hot water tank. Located just minutes from the massive new Micron Technology development, this is a home-run location with exponential upside. This is a chance to secure prime waterfront real estate in an area poised for historic economic growth and booming demand. Bring your architect, bring your contractor, and bring your imagination to transform this one-of-a-kind riverfront lot into the gem it was always meant to be. (Please Note: Due to the nature of the required renovations, this property is strictly available for Cash or 203k Rehab Loan buyers only.)