A rare opportunity to own a true multi-family waterfront estate with unmatched scale, flexibility, and income potential. This custom retreat offers approx. 6,900+ sq ft of finished living space, including 3 full kitchens, 10 bedrooms, and 9 bathrooms, all set on a 250-ft private shoreline in Trenton. The seller has invested Over $500,000 in upgrades, enhancing functionality, layout, and finishes throughout. The main floor welcomes with vaulted ceilings, a grand foyer, multiple ensuite bedrooms, a formal dining area, and an oversized eat-in kitchen with walkout deck overlooking the indoor pool and hot tub. The fully finished lower level features a second kitchen, 3+1 bedrooms, laundry, and recreation space with walkout to the backyard and open water views. The garage has been converted into a functional 2-bedroom, 1-bathroom Apartment with It's Own Separate Entrance, offering added flexibility for multi-generational living or additional income use. Outdoors, enjoy custom decks, multiple lounge zones, and a large dock ready for boating, swimming, and lakeside enjoyment. Buyer to verify all measurements, zoning, and rental potential. Note: This property includes two separate land parcels (two PINs) sold together as one ownership. The main residence is located on PIN 403820175, and an additional waterfront parcel (PIN 403820134) along Bay of Quinte is included in the sale. Both parcels are being transferred together as one property. (id:63267)