Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

15000 Picadilly Rd
Brighton, CO 80603

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $12,000,000
Beds: 8
Baths: 2
Status: Active
SqFt: 3280
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 298 acre(s)
Property Type: Other
Year Built: 1982
Notes: Rock Family Farms is a rare and unique opportunity to own a high production farm operation with additional agricultural land on 298+/- Acres. With its great location, good infrastructure and exceptional land stewardship, the development and income possibilities for this farm are endless. Rock Family Farms is truly a remarkable find! The land consists of quality sandy loam soils, and has been well maintained with the highest standards of farming and growing practices. Included in the sale of this property are 25 shares of Burlington Reservoir Co., additional water rights, 2 residential homes, and multiple outbuildings with good improvements and infrastructure. Along with quality water and soils, the property also comes with 2 residential homes (providing great room for farm managers, family or guests), a 1,017 sf. Farm Utility Building, 4,000 sf. Farm Implement Equipment Shed, livestock facilities and working corrals, and several other additional improvements. Owned and farmed by the same family for four generations, the owners have transformed this incredible property into a diversified, quality farm operation. Water Rights for the property include: 25 Shares of Burlington Reservoir Company plus 149+/- AF of Central Water Conservancy District (adding tremendous value to this operation). Water Rights: 25 Shares of Burlington Reservoir Co.; 149+/- AF of Central Water Conservancy District. 1,788 square-foot 1 Story Ranch Home w/ 725 square-foot detached garage; 1,492 square-foot 1 Story Ranch Home; 1,017 square-foot Farm Utility Building; 4,000 square-foot Farm Implement Equip Shed; Irrigation Pivot; Irrigation Well; Zoning: Adams County A-1. Greenhouse Ground Lease with Right of First Refusal generates addl. annual income of $200,000. Greenhouses are available to purchase separately: 36,000 square-foot Nursery/ Greenhouse, multi-purpose facility, office and conference room; Seven 58,426 - 65,000 square-foot Nursery/ Greenhouses built within last 10 years.
MlsNumber: 996550


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (303) 619-6774
Office Name: Hayden Outdoors - Windsor
Office Phone: (303) 619-6774
Agent Name: Seth Hayden
Disclaimer: Copyright © 2024 Information and Real Estate Services, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 307 AND i.igate IN ('usahud','cohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cohud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for The Valdez Team
The Valdez Team
Mobile: (970) 231-0890

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App