New search
Property profile & analytics
OFF-MARKET
Estimated value
$1,400,000
Warehouses
5542 Columbus Pike, Lewis Center, OH 43035-9602
Individually Owned
21-yr Hold
~
Est. High Equity
Property ID
US66-2372902
Property summary
AI-generated overview
This exceptional retail property, located at 5542 Columbus Pike in Lewis Center, Ohio, presents a fantastic leasing opportunity. The single-story, 22,796 square foot building sits on a generous 4.05-acre lot and was constructed in 1996. Currently, 3,200 square feet of retail space is available for lease, ideal for a variety of businesses. The property is zoned for Industrial District use within Delaware County's North submarket, specifically the Lewis Center cluster. The building features ample parking, with a ratio of 6 spaces per 1,000 square feet. There are no elevators. The property's multiple tenancy structure provides a vibrant and diverse commercial environment. The address is 5542 Columbus Pike, Lewis Center, OH 43035. This prime location offers excellent visibility and accessibility, making it an attractive option for businesses seeking a strong presence in a thriving community. The property's size and layout offer flexibility for various retail concepts. Interested parties should inquire about lease terms and conditions.
Property profile
Verified
Property type
Warehouses
Use group
MINI-WAREHOUSE, STORAGE
Year built
1996
Total area
22,796 SF
Lot
4.05 ac (176,418 SF)
APN
418-330-01-076-000
UPID
US66-2372902
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
-
Power Equipment by NCI (Bike/Boat/Book/etc) Store Garden Center
-
Lewis Center's Best Summer Camp - Empower Sports and Camps Family Recreation Center
-
Empower Martial Arts: Lewis Center Training Center Sports School
-
Fireside by NCI Hardware & Home Improvement
-
Alden's Furniture Showroom Furniture & Home Goods Home Decor Store
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
$1.91M
Comparable Approach
Comparable
$922k
Blend (final)
Blend
$1.40M
Owner & transaction history
5542 Columbus Pike Ltd · 21 yrs held
5542 Columbus Pike Ltd
since 2004
6 recorded transactions
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 Lewis Center submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Lewis Center 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%
$2,065,000
6.5%
$1,905,000
7%
$1,770,000
Blend value · Realmo final
$1.40M
Range $1.26M – $1.54M · ±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
$61 / 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
$27,353
Tax year 2023
Assessed value
$613,210
Assessed 2023
Previous assessed
$515,940
+18.9% YoY
Effective rate
4.46%
On assessed value
Assessed land
$114,840
Assessed improvement
$498,370
Land market value
$328,100
Improvement market value
$1,423,900
Total market value
$1,752,000
Applied tax rate
5.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
Warehouses
Use group
MINI-WAREHOUSE, STORAGE
Status
Off-Market
Year built
1996
Heating
YES
Cooling
YES
Stories
1
Rooms
9
Bathrooms
2
Total area
22,796 SF
Lot
4.05 ac (176,418 SF)
APN
418-330-01-076-000
UPID
US66-2372902
Jurisdiction
DELAWARE
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
Year built
1996
Heating
YES
Cooling
Yes
Stories
1
Rooms
9
Bathrooms
2
Lot
4.05 ac
Current owner
From public records · entity-resolved
5542 Columbus Pike Ltd
Individual
Mailing address
5542 COLUMBUS PIKE, LEWIS CENTER, OH 43035-9602
Mailing matches property
Yes
Owner-occupied
Yes
Ownership since
2004
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
6 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Apr 12, 2007
—
5542 Columbus Pike Ltd
—
Grant Deed
related
$1,800,000 · First Knox National Bank
Oct 13, 2004
$2,000,000
5542 Columbus Pike Ltd
Team Investors Ltd
Deed Of Trust
related
$2,030,000 · Huntington National Bank
—
—
5542 Columbus Pike Ltd
—
Deed Of Trust
related
$2,101,234 · First Knox National Bank
—
—
5542 Columbus Pike Ltd
—
Deed Of Trust
related
$800,000 · First Knox National Bank
—
—
Shanahan LLC
—
Deed Of Trust
related
$1,890,500 · First Fin'l Bk&tr
—
—
5542 Columbus Pike Ltd
—
Deed Of Trust
related
$175,000 · Huntington National Bank
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 5542 Columbus Pike?
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.
