** Open House Sunday June 14th 12-2** Welcome to this exceptional home in the highly sought-after Niskayuna School District, offering over 3,000 square feet of living space, plus a fully equipped in-law suite with its own private entrance! This spacious 5-bedroom, 4 full-bath residence provides the perfect blend of comfort, functionality, and multi-generational living. The beautifully updated main home features a modern kitchen with brand-new appliances, generous living spaces, central air conditioning, a cozy wood-burning stove, and a heated and air-conditioned three-season room that provides the perfect space to relax and enjoy the surrounding views. The primary suite offers a private retreat complete with a walk-in closet and its own full bathroom. The impressive in-law suite includes a full kitchen, spacious bedroom, and full bath, making it ideal for extended family, guests, or flexible living arrangements. Two furnaces, both approximately 5 years old, provide efficient comfort throughout the home, while the roof is approximately 6 years old, offering added peace of mind for years to come. Situated on a rare double lot, the outdoor space is equally impressive with three decks perfect for entertaining, relaxing, or enjoying the peaceful surroundings. A large U-shaped driveway and oversized 3-car garage offering approximately 1,000 square feet provide ample room for vehicles, storage, hobbies, or a workshop. Rarely does a property offer this much space, flexibility, and value in such a desirable location. Don't miss your opportunity to own this one-of-a-kind Niskayuna property!