This spectacular property is truly like none other available in Boulder County! Nestled in the coveted Goldbranch subdivision in Niwot, this bright and flowing modern farmhouse features top-of-the-line finishes and a resort-style oasis complete with pool, spa and waterfall. Set on nearly an acre of land, the lot perimeter hosts a 700 ft private walking trail. Interior features include wood-beamed vaulted ceilings, chef's kitchen with mitered quartz island, Thermador appliances, gas range, wine fridge and buffet counter. The primary suite is privately set on the East side of the home with luxury spa bath and steam shower and a vast walk-in closet. Extensive 3-4-5" white oak flooring, impressive light fixtures, double-sided gas fireplace, open dining room and great room, 2 additional en-suite bedrooms and a 3/4 bath with access to pool and flex room comprise the remainder of the sprawling main level. The lovely daylight basement adds 2 more bedrooms, fitness room, 3/4 bath, rec room and plentiful storage. An entertainer's delight, the main floor extends to an exterior private retreat with covered patio and pergola sure to please the most discerning buyer. Owned Solar and a 3 car garage add a wonderful bonus! Goldbranch is a small, private subdivision with superior access to restaurants, shopping, trails, Niwot High School and more.