966 Stillwater Bridge Rd Unique Home with Panoramic Water Views and Access to the Hudson River. One family's dream property is available for the next to fulfill and enjoy. This one-of-a-kind setting offers panoramic water views and total privacy. This 3BR, 2BA property is now in an estate so information is limited and the property is to be sold as-is. The original house dates to 1925, but the major renovation was believed to have been nearly completed in 2025. You'll find some well-planned projects are still in need of finishing touches but there is tremendous value for the right buyer. Take waterfront living to the extreme with your own .54 acre peninsula in the Hudson River. Cruise by boat North to Montreal, South to NYC, Florida or beyond to the Caribbean, or enjoy peaceful 14 mi. of crystal-clear water between the locks by boat, jet ski or kayak! If you prefer staying on land, enjoy your in-ground fiberglass pool overlooking the water and observe the wildlife: bald eagles, ducks and more. Interior highlights include: Updated kitchen with modern cabinets, quartz countertops, deep undermount sink, tiled backsplash and stainless steel appliances, stunning marble tiled bathrooms, stylish and durable LVP flooring, vinyl windows/siding, custom staircase and woodwork, vaulted primary bedroom and walk-up attic space! Condition: A home inspection was just completed by the estate for transparency, and estate set the list price to reflect the current condition. The home is being sold as-is. The inspection report is available in the documents for your review before all showings. Mold was found in the attic and can be remediated prior to closing, or a $5000 credit can be given for this amount. Qualified buyers that recognize and understand the remaining projects to be done are welcomed to schedule a showing. If you have the passion and the resources to complete the vision that has gone into this property so far, this might be the place for you!