Residential development opportunity located at the corner of Tipple Parkway and Weld County Road 17 in Frederick. The property sits within the active growth corridor along Highway 52 and is zoned low-density residential with a Planned Unit Development (PUD) overlay. The site is conceptually planned for approximately 317 single-family detached lots, along with additional acreage that could accommodate an additional 67 single-family detached lots or up to 170 townhomes. The Town of Frederick currently requires raw water dedication; however, there is potential for a future non-potable irrigation system (pending completion of a water study), which could significantly reduce water-related fees. Utilities are not currently on-site. A nearby water line is located along Wheatland Boulevard, and sewer service can be extended from an adjacent development.
5 days
|
35
|
2
|
Zillow last checked:
Listing updated:
Listed by:
Travis Ackerman970-776-3900,
Cushman & Wakefield,
Matt Haskell970-690-1690,
URealty Inc
Source: IRES as distributed by MLS GRID,MLS#: 1065048
Facts & features
Property
Lot
Size: 125 Acres
Details
Parcel number: R1270396
Zoning: R-1
Special conditions: Private Owner
Utilities & green energy
Sewer: Public Sewer
Water: City
Community & HOA
Community
Subdivision: Frederick Rural
HOA
Has HOA: No
Location
Region: Frederick
Financial & listing details
Annual tax amount: $496
Date on market: 7/24/2026
Estimated market value
Zestimate®
Not available
Estimated sales range
Not available
Rent Zestimate®
Not available
Price history
Date
Event
Price
7/24/2026
Listed for sale
$6,000,000+674.2%
Source: IRES as distributed by MLS GRID #1065048Report a problem
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Source: IRES as distributed by MLS GRID. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.