Upon arriving at this inviting 5-bed, 5-bath home in Niwot's Waterford Park, you're greeted by the charming, covered porch that wraps around the home, setting the stage for gracious living. Inside, gleaming hardwood floors flow throughout the main level, illuminated by an abundance of natural light from a wall of windows surrounding a gas fireplace in the living room. Adjacent to the foyer is a cozy library/office & beyond the living room, you'll find a main-floor bedroom with an adjacent 3/4 bath. The kitchen showcases countertop seating, a butcher block island & a 6-burner gas stove highlighted by custom hood & backsplash. White appliances seamlessly blend into the upgraded white cabinets & an eat-in area allows for less formal gatherings, while a delightful dining room is perfect for more formal occasions. The functional floor plan locates a 1/2-bath, laundry room & mudroom at the entrance to the 3-car garage. Venture upstairs to discover the generous primary bedroom, featuring its own fireplace, large walk-in closet & a private balcony offering breathtaking views of Long's Peak & stunning sunsets over the Front Range mountains. The ensuite bathroom has an elegant freestanding tub & a separate shower. Completing the upper level are an extra office, 2 addl bedrooms & a recently remodeled bathroom. Downstairs, the finished basement offers a well-appointed wet bar, spacious family room, versatile rec room & a welcoming guest room with 3/4 bath. Guests can access the backyard via the basement patio outside a sliding glass door. This picturesque property backs to an HOA open space & features a large, private backyard perfect for playing and gardening. Featuring fresh paint, new carpet & newer furnace/AC unit. Trails from the backyard lead to Niwot's charming Downtown and the LoBo trail system. Just minutes from Niwot Elementary & High School, with easy access to Boulder via the Diagonal Hwy & to Longmont via 95th St.