Back to Search
Property profile & analytics
FOR LEASE
Outlet malls
1951 Havemann Rd Celina, OH 45822
Entity Owned
5-yr Hold
Absentee Owner
Free & Clear
Property ID
US66-0385595
For Lease
$10 SF/Yr
1951 Havemann Rd, Celina, OH 45822
View Listing →
Property summary
AI-generated overview
Lakewood Village Shopping Center, located at 1951 Havemann Rd, Celina, OH 45822, offers 124,334 square feet of retail space in a single, one-story building. This multiple-tenancy shopping center sits on 20.37 acres of land and features 201 parking spaces. Built in 1990, the property includes 13 suites and is zoned B-3. The center enjoys a prime location just west of SR-29, serving as a retail hub for a large trade area extending from Fort Wayne, Indiana to Dayton, Ohio. The property's APN is 27-026900.0100, 27-026900.0102, and is situated in Mercer County's Ohio North Area submarket. Currently, available space includes 5,800 square feet of grocery-anchored retail space. The center is conveniently located near Irmscher Blvd.
Property profile
Verified
Property type
Outlet malls
Use group
WHOLESALE OUTLET, DISCOUNT STORE
Year built
1989
Total area
70,206 SF
Lot
9.54 ac (415,475 SF)
APN
06-32-401-005
UPID
US66-0385595
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
-
Dunham's Sports (Bike/Boat/Book/etc) Store
-
Harbor Freight Tools Building Supply Hardware & Home Improvement
Value estimations
Realmo proprietary · 4 methods
AI Approach
AI
by Request
CAP Approach
CAP
by Request
Comparable Approach
Comparable
$2.04M
Blend (final)
Blend
$1.87M
Owner & transaction history
Harbor Freight Tools USA INC · 5 yrs held
Harbor Freight Tools USA INC
since 2021
3 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 Celina submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Celina 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
Blend value · Realmo final
$1.87M
Range $1.68M – $2.06M · ±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
$27 / 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
$25,057
Tax year 2023
Assessed value
$525,340
Assessed 2023
Previous assessed
$493,980
+6.3% YoY
Effective rate
4.77%
On assessed value
Assessed land
$61,430
Assessed improvement
$463,910
Land market value
$175,500
Improvement market value
$1,325,450
Total market value
$1,500,950
Applied tax rate
16.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
Outlet malls
Use group
WHOLESALE OUTLET, DISCOUNT STORE
Status
For Lease
Year built
1989
Heating
NONE
Total area
70,206 SF
Lot
9.54 ac (415,475 SF)
APN
06-32-401-005
UPID
US66-0385595
Jurisdiction
MERCER
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
1989
Heating
NONE
Lot
9.54 ac
Current owner
From public records · entity-resolved
Harbor Freight Tools USA INC
Entity
Free & Clear · 5 yrs held
Mailing address
678 REISTERSTOWN RD, PIKESVILLE, MD 21208-5112
Mailing matches property
Different — outreach signal
Owner-occupied
No
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
3 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
May 4, 2021
—
Harbor Freight Tools USA INC
Raf Celina LLC
Lease
—
Feb 17, 2015
$5,812,000
Raf Celina LLC
Celina Venture LLC
Limited Warranty Deed
—
Jan 13, 2011
—
Celina Venture LLC
Lakewood Village Center LLC
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?”
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.
