Welcome to this unique 3-bedroom, 2.5-bathroom home offering exceptional indoor/outdoor living and breathtaking river views. Nestled on a quiet street within the North Colonie School District, this custom property combines comfort, character, and convenience. Step inside to discover an open-concept main floor, perfect for entertaining, and an enclosed front porch where you can take in serene water views year-round. The lower-level family room features a one-of-a-kind live-edge wood bar, ideal for gatherings. High ceilings add an airy feel, while the private primary suite with en-suite bath provides a peaceful retreat. Sliding glass doors open to upper and lower decks, creating seamless transitions for relaxing or hosting outdoors. Set on 2.5 acres, the property offers a spacious backyard with an above-ground pool, plenty of room for gardening, play, or quiet evenings under the stars. Located just minutes from shopping, dining, and major conveniences, this home is truly a rare find.