New search
Property profile & analytics
OFF-MARKET
Estimated value
$84,895,000
Apartment buildings
400 Randall Rd, Dundee, IL 60118-9228
Entity Owned
3-yr Hold
~
Est. High Equity
Property ID
US28-2923990
Property summary
AI-generated overview
This exceptional retail leasing opportunity offers multiple spaces within high-traffic Meijer stores across the Midwest. Units range from 448 to 916 contiguous square feet, with a total of 1,364 square feet currently vacant. These prime, front-of-store locations provide unparalleled visibility and access to thousands of weekly customers. The all-inclusive monthly fee covers real estate taxes, property insurance, common area maintenance, and utilities. Interior and exterior signage opportunities are available for enhanced brand exposure. These spaces are situated in thriving trade areas with desirable demographics, making them ideal for a variety of businesses. Suitable uses include financial institutions, food and beverage establishments, service businesses, health and wellness providers, and more. Multiple vacancies exist in various Midwest locations. This "store-within-a-store" concept offers a unique opportunity to establish a presence in one of the Midwest's most recognizable retail destinations. Contact for details and availability.
Property profile
Verified
Property type
Apartment buildings
Use group
APARTMENT HOUSE (5+ UNITS)
APN
03-19-277-008
UPID
US28-2923990
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
Current use
Occupant on record · Public records
-
Electrify America Charging Station Electric Vehicle Charging Station
-
Jennifer Lange Physician
-
Valaji Spa Spa & Massage Center Skin Care Clinic
-
Western Union Bank Credit Union
-
Tutoring Club of Elgin Tutoring Service
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
by Request
Comparable Approach
Comparable
by Request
Blend (final)
Blend
$84.90M
Owner & transaction history
Redwood R&all Company LP · 3 yrs held
Redwood R&all Company LP
since 2022
Last sale
$84.9M
1 recorded transaction
Zoning & alternative use
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Cap rate
Implied · in-place · derived from last sale + estimated NOI
Implied Cap rate
#1
Implied · in-place · NOI ÷ last sale
In-place · derived from last sale + estimated NOI
Cap rate, NOI & submarket benchmark
Implied cap rate vs Dundee submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Dundee submarket · NOI estimate · typical band, median & reading
Refine your cap rate
8-question underwriting flow
1.
Property current status — Going-In vs Stabilized
2.
Price for denominator — asking / offer / market
3.
Leasing status & lease structure (NNN / Gross)
4.
Tenant risk profile & vacancy assumption
5.
Upload T12 / rent roll / OM (optional)
Refine in 60 seconds, get exact suggested price
T12 upload · Submarket benchmarks · Sensitivity grid
Suggested price · 3 cap rate anchors
Income approach @ 5% / 7% / 9% — aggressive / typical / conservative
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · Implied $/SF per anchor · Sensitivity grid
Suggested price at 5% / 7% / 9% cap
Aggressive / typical / conservative · implied $/SF · sensitivity
Value
AI, CAP & Alternative Use estimations · Realmo proprietary blendValue Estimations
Based on Realmo’s proprietary methodology
AI Approach
Method
Estimation
Statistic approach
$98,960,000
ML approach
by Request
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Blend value · Realmo final
$84.90M
Range $76.41M – $93.38M · ±10% · vs last sale $84.90M (Jul 7 2022)
Last sale anchor
$84.90M
Jul 7 2022
Realmo estimate · informational only.
These numbers are calculated by our models from public records and may not reflect actual market value.
Not an appraisal.
Verify with a licensed appraiser before transacting. Realmo accepts no liability for divergence from real-world outcomes.
View the full estimation — every method, every assumption
Confidence drivers & risk notes · Custom comparable set · Free for first 3 / day
Full estimation methodology
Every method · every assumption · confidence drivers
Price per SF
Sale + rent benchmarks
Subject property
—
Submarket sale & rent benchmarks
Median sale $/SF · Asking & closed rent · Submarket vacancy
Submarket sale & rent benchmarks
Median sale $/SF · asking & closed rent · submarket vacancy
Property tax & assessments
Tax year 2023Property tax & assessments
Tax year 2023
Tax billed
$2,518,957
Tax year 2023
Assessed value
$29,436,131
Assessed 2023
Previous assessed
$20,397,936
+44.3% YoY
Effective rate
8.56%
On assessed value
Assessed land
$1,871,610
Assessed improvement
$27,564,521
Land market value
$5,614,830
Improvement market value
$82,693,563
Total market value
$88,308,393
Comparables
6 recent transactions · within 1.5 miComparable in this city
6 recent transactions
Comparable in this City
Similar Nearby for Sale
Similar Nearby for Lease
Recent comparable sales
Sale price & price/SF · Sale date & distance · Adjustments & confidence
Recent comparable sales
Sale price & $/SF · sale date & distance · adjustments
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Apartment buildings
Use group
APARTMENT HOUSE (5+ UNITS)
Status
Off-Market
Heating
NONE
APN
03-19-277-008
UPID
US28-2923990
Jurisdiction
KANE
Metro division
CHICAGO-NAPERVILLE-JOLIET, IL METROPOLITAN DIVISION
Zoning & alternative use
Zoning · permitted uses
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Building & site characteristics
From public records
Heating
NONE
Current owner
From public records · entity-resolved
Redwood R&all Company LP
Entity
Mailing address
1 E WACKER DR STE #1600, CHICAGO, IL 60601-1901
Ownership since
2022
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
1 recorded event · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Jul 7, 2022
$84,897,000
Redwood R&all Company LP
Fred West Dundee LLC
Special Warranty Deed
$70,200,000 · Pnc Bank NA
Coming soon
Costs & Benchmarks
Operating expenses, capex projections, utility benchmarks, and submarket comparables — all in one view.
Coming soon
Risks
Flood, climate, environmental, title, and tenant-concentration risk — surfaced with mitigations and source citations.
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 400 Randall Rd?
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 →
Full reports are paid
Unlock the full Property Analytics report
Start free for 7 days — no card required. Full owner contacts, all 4 valuations with methodology, refine flow, comparable adjustments, foot-traffic deep dive, export to PDF / CSV.
