You're browsing as guest. Top-line numbers are free. Full reports — owner contacts, refine, methodology — are paid. Guest mode. Top-line is free.
Back to Search
Property profile & analytics
OFF-MARKET
Distribution centers

23158 Aspen Ave Warrens, WI 54666

11,280 SF 63.24 ac lot Built 1993
Entity Owned 5-yr Hold
Property ID
US92-3173793
Property summary
AI-generated overview

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.

Property profile
Verified
Property type Distribution centers
Year built 1993
Total area 11,280 SF
Lot 63.24 ac (2,754,734 SF)
APN Parcels 024-00144-000, 024-00145-5000 and 024-00143-0000
UPID US92-3173793
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate vs submarket · NOI estimate · 3 price anchors
Implied cap rate, NOI & suggested price
Cap vs submarket · NOI estimate · 3 price anchors
Value estimations
Realmo proprietary · 4 methods
AI Approach AI
by Request
CAP Approach CAP
by Request
Comparable Approach Comparable
by Request
Blend (final) Blend
by Request
Owner & transaction history
K & S Cranberry Co LLC · 5 yrs held
K & S Cranberry Co LLC
since 2021
1 recorded transaction
2021
Price N/A
Zoning & alternative use
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Try Rey
Ask anything about this address in plain English.
“Is 15.6% cap rate sustainable?” · “Best tenant mix for BU1?” · “What’s the redev upside?”
You own 23158 Aspen Ave?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
List this address →
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message