Welcome to 1165 Highland Park Rd; tucked inside one of Niskayuna's peaceful, non-drive-through neighborhoods, where neighbors stroll, ride bikes and walk their dogs beneath mature trees. This charming three-bedroom, 1.5-bath home blends warmth, flexibility and significant recent investment. Hardwood floors and a handsome fireplace anchor the inviting living room, which flows beautifully into the light-filled dining room. But the showstopper is the fabulous sunroom; a dreamy retreat overlooking the property's lush backyard oasis! Step outside onto the enormous deck, where a fishpond and waterfall create an incredibly peaceful setting for morning coffee, outdoor dining and effortless entertaining. Native perennial gardens, edible serviceberry trees, lilacs, a smoke bush and a cold-hardy nectarine tree make the backyard feel truly magical. Inside, the eat-in kitchen offers direct access to the outdoors, while a first-floor bedroom and half bath provide valuable flexibility. Upstairs, you'll find an oversized bedroom, a third bedroom, full bath, generous closets and additional WALK-UP attic storage. The major investments have already been made, including a new 40-year architectural-shingle roof by Star Roofing, upgraded 200-amp electrical service with room to expand, 2024 water heater, professional asbestos remediation, a new stockade fence, new driveway, new Andersen entry and storm doors, new dining-room and basement windows, updated appliances and numerous new plumbing fixtures. The 2011 boiler was professionally serviced in August 2026. A fabulous sunroom, extraordinary outdoor living, substantial improvements and a tucked-away Niskayuna setting...this dreamy home is something truly special!!