Situated behind a private gated entrance, this fully fenced 8.59-acre waterfront estate offers sweeping lake and mountain views in one of Northern Colorado's most sought-after locations. In addition to the main residence, the property features an 800+ sq ft ADU complete with its own full bathroom and kitchen. Just minutes from TPC Colorado, this rare offering combines luxury living, equestrian amenities, and year-round recreation with no HOA, a half share of Handy Ditch water rights, and optional membership to Lonetree Reservoir. The extensively renovated home blends timeless craftsmanship with modern comfort. Beautiful Red Oak flooring was selected for its durability and stability in Colorado's climate, while expansive new windows throughout the home frame the surrounding scenery. Recent improvements include fresh interior/exterior paint, a remodeled kitchen, beautifully renovated bathrooms, and a new Class 4 impact-resistant shingle roof on the home, horse barn and shop. The primary suite opens to more than 1,000 square feet of covered Trex decking overlooking the water. The outdoor amenities are equally impressive. A private pond with a fountain, filtration system and walk-in steps creates a peaceful backyard retreat. The four stall horse barn features a tack room, community room, and guest apartment with its own entrance, remodeled kitchen, updated bathroom, and private living space. A 2,000 square foot shop, riding arena, additional outbuildings and fenced pastures provide exceptional flexibility. Enjoy the Colorado lifestyle with optional membership to Lonetree Reservoir, offering boating, wake surfing, sailing, fishing, paddleboarding and seasonal waterfowl hunting. The property includes a private dock, and a nearby trail provides convenient access to TPC Colorado. Whether your ideal day includes horseback riding, boating, an afternoon at TPC, or simply watching the sun set, this is a property designed to enjoy every season of Colorado living.