Back to Search
Property profile & analytics
OFF-MARKET
Estimated value
$2,885,000
Strip malls
4866 Hamilton Rd Columbus, OH 43230
Entity Owned
4-yr Hold
Free & Clear
Property ID
US66-0753053
Property profile
Verified
Property type
Strip malls
Use group
SHOPPING CENTER, STRIP CENTER
Year built
2004
Total area
33,457 SF
Lot
3.83 ac (166,965 SF)
Zoning code
5300
APN
010-226263
UPID
US66-0753053
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
$3.45M
Blend (final)
Blend
$2.89M
Owner & transaction history
Longvalley I LLC · 4 yrs held
Longvalley I LLC
since 2021
7 recorded transactions
Zoning & alternative use
5300 · Columbus, OH
Permitted uses
Permitted uses
Allowed · conditional · prohibited
Top alternative use upside
Medical building
$4.5M
+24.9%
Office building
$4.5M
+24.7%
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 Columbus submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Columbus 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
by Request
ML approach
by Request
CAP Approach
CAP Return
Estimation
6%
by Request
6.5%
by Request
7%
by Request
Alternative Use
Use
Estimation
NEIGHBORHOOD: SHOPPING CENTER
$3,615,000
Current use
MEDICAL BUILDING
$4,520,000
Change: +25% · Conversion: Difficult
OFFICE BUILDING
$4,510,000
Change: +25% · Conversion: Moderate
RETAIL STORES
$3,590,000
Change: -1% · Conversion: Easy
COMMERCIAL (GENERAL)
$3,250,000
Change: -10% · Conversion: Easy
Blend value · Realmo final
$2.89M
Range $2.60M – $3.17M · ±10%
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
$86 / SF
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
$140,853
Tax year 2023
Assessed value
$1,928,220
Assessed 2023
Previous assessed
$1,597,790
+20.7% YoY
Effective rate
7.30%
On assessed value
Assessed land
$645,750
Assessed improvement
$1,282,470
Land market value
$1,845,000
Improvement market value
$3,664,200
Total market value
$5,509,200
Applied tax rate
10.0000
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
Strip malls
Use group
SHOPPING CENTER, STRIP CENTER
Status
Off-Market
Year built
2004
Heating
YES
Cooling
CENTRAL
Buildings
1
Stories
1
Rooms
7
Bathrooms
1
Total area
33,457 SF
Lot
3.83 ac (166,965 SF)
Zoning code
5300
APN
010-226263
UPID
US66-0753053
Jurisdiction
FRANKLIN
Zoning & alternative use
5300 · Columbus, OH
Zoning 5300 · permitted uses
5300 · Columbus, OH
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Columbus. Always verify with local authorities before improvements.
Alternative use value scenarios
Repositioning upside vs current use
NEIGHBORHOOD: SHOPPING CENTER Current
Est. value
$3.6M
MEDICAL BUILDING
Est. value
$4.5M
OFFICE BUILDING
Est. value
$4.5M
RETAIL STORES
Est. value
$3.6M
COMMERCIAL (GENERAL)
Est. value
$3.3M
NEIGHBORHOOD: SHOPPING CENTER Current
MEDICAL BUILDING
OFFICE BUILDING
RETAIL STORES
COMMERCIAL (GENERAL)
Alternative use deep dive — conversion cost, permits, timeline
Conversion cost estimate · Permit path & risks · Stabilized NOI per option
Alternative use deep dive
Conversion cost · permit path · stabilized NOI per option
Building & site characteristics
From public records
Year built
2004
Heating
YES
Cooling
Yes
Stories
1
Buildings
1
Rooms
7
Bathrooms
1
Lot
3.83 ac
Current owner
From public records · entity-resolved
Longvalley I LLC
Entity
Free & Clear · 4 yrs held
Mailing address
2500 LEHIGH AVE, GLENVIEW, IL 60026-8027
Ownership since
2021
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
12 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Sep 28, 2021
—
Longvalley I LLC
Keith N Hoogland
Quit Claim Deed
related
—
Sep 13, 2021
$96,000
Long Valley I LLC
Olivia C Reynolds
Quit Claim Deed
related
—
Sep 13, 2021
$400,000
Long Valley I LLC
Liza Hoogland Reynolds
Quit Claim Deed
related
—
Aug 25, 2021
—
Keith A Hoogland
Kathleen Knox Hoogland Family LP
Quit Claim Deed
related
—
Jan 20, 2021
—
Kathleen Knox Hoogland Fam LP
Grantor Hoogland 2006 Trust
Quit Claim Deed
related
—
Jan 11, 2011
—
Hoogland 2006 Grantor Trust
Family Video Movie Club INC
Grant Deed
$2,250,000 · Firstmerit Bank NA
Oct 22, 2010
—
Family Video Movie Club INC
Persi Investments II LLC
Grant Deed
—
Jun 27, 2006
$6,900,000
Persi Investments II LLC
Preserve Plaza LLC
Corporation Deed
$5,600,000 · Merrill Lynch Mortgage Lending INC
Aug 25, 2004
$1,435,900
Preserve Plaza LLC
New Albany Co LLC
Grant Deed
$4,800,000 · Sky Bank
Aug 25, 2004
$388,900
National Real Estate Dev Ltd
New Albany Co LLC
Grant Deed
$393,750 · Heartland Bank
Nov 17, 2003
$710,000
Key Bank NA
New Albany Co LP
Grant Deed
related
—
Aug 8, 2003
—
Dsm Holdings LLC
New Albany Co LP
Quit Claim Deed
related
—
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 4866 Hamilton 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.
