REZONING JUST COMPLETED! Now officially zoned as Rural Planned Development (RPD), this incredible property offers an exceptionally wide variety of potential uses, making it a rare and versatile opportunity in Northern Colorado. With this new zoning, options could include museums, photography studio/galleries, medical/ dental offices, retail , rehab center, nursing/assisted living, places of worship, event venues, service shops, convenience shopping, automotive repair, & so much more. Buyers are encouraged to verify specific uses w/ the county, but the possibilities are truly remarkable. Set on 2.3 acres of beautifully maintained land, is a luxurious 4,500 sq ft residence w/ nearly 10,000 sq ft shop space, showroom, & loft. The primary shop area spans over 7,700 sq ft and features four oversized 14x14 doors, 220 power, abundant outlets including exterior eave outlets, and an 8x7 pass-through door connecting directly to the showroom. The interior is fully finished with hybrid insulation (batts over spray foam), ensuring efficiency. Above, the 1,700 sq ft loft with a private entrance provides endless opportunities-perfect for office space, a guest suite, or rentable unit. The residence itself is equally impressive, w/ 5 spacious beds, 5 bathrooms & a gourmet kitchen w/ large island, Jenn Air appliances and it flows seamlessly into the home's open living areas. Custom tilework, upgraded finishes, and thoughtful design elevate the home throughout. A large East facing patio is wired for a TV & firepit, creating the perfect setting to unwind or host gatherings. The property is fully sprinkled, has mature trees & the private well dramatically reduces water costs while keeping the grounds lush year-round. A gated entry and tree-lined ditch ensure security and seclusion, all while being just minutes from local amenities and top-rated schools. This property has been meticulously designed and maintained to accommodate both residential luxury and commercial potential.
Listing Office: RE/MAX Alliance-Loveland
Cable Available, Electricity Available, Internet Access (Wired), Natural Gas Available
Oversized Door, RV Access/Parking, Tandem
Eat-in Kitchen, Kitchen Island, Open Floorplan, Pantry, Walk-In Closet(s)
Dishwasher, Disposal, Oven, Refrigerator
Terms and Conditions: The content relating to real estate for sale in this Web site comes in part from the Internet Data eXchange ("IDX") program of METROLIST, INC., DBA RECOLORADO® Real estate listings held by brokers other than RE/MAX Professionals are marked with the IDX Logo. This information is being provided for the consumers personal, non-commercial use and may not be used for any other purpose. All information subject to change and should be independently verified.
Copyright 2025 METROLIST, INC., DBA RECOLORADO® -- All Rights Reserved 6455 S. Yosemite St., Suite 500 Greenwood Village, CO 80111 USA
Listing information last updated on August 22nd, 2025 at 4:05pm MDT.