Discover an exceptional opportunity to own a beautifully designed three-unit waterfront property offering flexibility, privacy, and income potential, all set on 260 feet of picturesque frontage along the Sebasticook River. With truly separate living spaces, dual driveways, and layouts that support one-level living in multiple units, this property is ideal for multi-generational living, investment, or simply enjoying a spacious retreat with unmatched versatility. Unit 1 - The primary residence welcomes you with warm hardwood and tile floors and an expansive chef's kitchen featuring a large island and generous workspace. The attached 2-car garage provides convenient access, and beneath it you'll find valuable storage for kayaks, canoes, and outdoor equipment - perfect for riverfront living. This unit features two first-floor bedrooms, allowing for easy one-level living. Unit 2 - A completely separate two-bedroom apartment offers its own kitchen, full bath, living room, and dining area ideal for extended family, guests, or reliable rental income. With its own dedicated driveway, this apartment feels like an independent home, ensuring privacy for both occupants and owners. Unit 3 is above the garage as a remarkable studio apartment with private exterior access. This bright and open space is perfect as a guest suite, home office, art studio, or baking workspace. A built-in bookcase cleverly conceals a hidden bedroom and full bath, adding charm, character, and unexpected practicality. Creative buyers will appreciate the flexibility of this unique third unit. Whether you're envisioning a multi-generational compound, seeking strong rental income to offset expenses, or wanting private areas for guests, hobbies, or remote work, this three-unit property delivers outstanding adaptability. Peaceful water views enhance every corner of the property, offering a sense of relaxation and natural beauty that only true riverfront living can provide.