23158 Aspen Ave Warrens, WI 54666
This exceptional 63.24-acre property, known as Cranberry Farms, presents a unique redevelopment opportunity in Warrens, Wisconsin. Located at 23158 Aspen Ave, 54666, this mixed-use site boasts a strategic location just off I-94, across from Three Bears Resort, and adjacent to a county forest. The property includes three existing buildings totaling 11,280 square feet of net rentable space, with ceiling heights ranging from 10 to 12 feet. A high-capacity well and a 9-acre pond are also on the site, along with a residence situated on a 5-acre lot. The existing structures are part of a cranberry bog operation. The property is zoned commercial (comm) and features APNs 024-00144-000, 024-00145-5000, and 024-00143-0000. The asking price is $3,250,000, translating to $288.12 per square foot. This land offers diverse redevelopment potential, including but not limited to subdivision, golf course, water park, vineyard, outdoor adventure park, hotel, or casino development. A feasibility study has also explored the potential for frac sand pit development with a proposed reclamation plan. This is a rare opportunity to acquire a large, versatile parcel with significant existing infrastructure in a desirable location. The property is offered with a modified lease type and single tenancy. The buildings are single-story structures built in 1993.
Cap rate
Implied · in-place · derived from last sale + estimated NOIValue
AI, CAP & Alternative Use estimations · Realmo proprietary blendComparables
6 recent transactions · within 1.5 miComparable in this City
Similar Nearby for Sale
Property description
Physical attributes from public recordsZoning & alternative use
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.