NOW priced $200,000 lower than recent appraisal PLUS $140,000 in water rights! This charming home is nestled in a historic development at the base of the foothills, offering private access to miles of trails on an adjacent open space preserve perfect for hiking, biking, or horseback riding. This exceptional generational estate has been cherished by the current owner for 31 years and is a rare find! Enjoy quick access to Horsetooth Reservoir for boating & the property allows for up to 4 horses & features a fenced pasture. Includes two shares of CBT water for irrigation, valued at $140,000 & sits on a year round water storage pond attracting abundant wildlife. The flagstone pergola & fountain complements the expansive waterfront deck, ideal for evenings outside. The CSU campus is less than 4 mi. away, and Old Town Fort Collins is just under 5 mi. and all on paved roads! This rare waterfront location allows young ones to fish for crawdads right from the deck or enjoy watching families of resident waterfowl raise their babies. Remodeled & expanded in 2006, the home boasts a seamless flow of living space, featuring designated yoga & gym areas, an office & three spacious bedrooms, plus dual living rooms provide multiple gathering spots for friends & family. Whether looking east to the waterfront or west to the foothills, views are everywhere. Four stone hearth fireplaces are perfectly placed in bedrooms & living spaces creating a cozy mountain-like retreat. Custom cabinetry, stone sinks, spacious walk-in showers & closets plus multiple balconies, decks & large windows, bring the outdoors into nearly every living space. The home includes a 2.5-car attached heated garage & a 1344 sqft heated shop, 700 sqft of bonus space upstairs plus an extra attached storage shed. We can't forget fido! This property also has a waterfront dog house & run w/ a view. The many abundant unique features of this property, make it truly one-of-a-kind residence retreat that should not be missed.