Recent appraisal of $1,925,000 7-1-24 is now priced below market value at $1,549,000, offering an incredible $376,000 off market price. Welcome to your dream oasis! Nestled on a sprawling 18.54-acre farm next to the serene Boulder Creek in unincorporated Weld County, this stunning updated ranch home boast luxurious finishes and offers endless opportunities and breathtaking views. The completely remodeled HOME WITH EVERYTHING NEW - from the roof and windows to fixtures, Stainless appliances, cabinets, luxury kitchen and baths and wide plan oak flooring, HVAC, flooring, septic, water tap, and more! Surrounded by Boulder County Conservation Easements ensuring your peace and privacy. Live life along the picturesque Boulder Creek Riparian Corridor, with close proximity to Longmont, Niwot, Erie, Boulder, Denver and DIA. Picture yourself savoring beautiful sunsets and the tranquil country lifestyle, all while having the convenience of a school bus stop right out front. The property features irrigated pasture with included water rights, partially fenced areas, and a loafing shed perfect for your horses.(check County for options and what is possible). Enjoy the stunning views of the 10 lakes along and the panoramic mountain views to the West. You're just 10 minutes from Prospect, Niwot, Old Town Longmont, Erie, and Frederick, with Boulder only 20 minutes away and DIA a mere 30 minutes drive. Wildlife enthusiasts will be delighted with frequent sightings of birds and wildlife. This expansive 19-acre property in Weld County offers a unique opportunity for buyers. A smaller 11.54-acre portion of the property is also available for purchase, pending a lot line adjustment and Weld County approval. For details on the smaller lot, please refer to IRES MLS Listing #1014614- $350k less.