New search
Property profile & analytics
OFF-MARKET
Retail space
24500 John R Rd, Hazel Park, MI 48030-1142
Individually Owned
6-yr Hold
Free & Clear
Property ID
US43-0245954
Property profile
Verified
Property type
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Year built
1946
Total area
2,896 SF
Lot
0.07 ac (3,049 SF)
Zoning code
BI
APN
28-25-25-105-002
UPID
US43-0245954
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
-
Maxwell Building- Water and Fire Clean Up Hardware & Home Improvement Kitchen & Bath Showroom
-
Maxwell Building Services Construction Company General Contractor
-
Hornbacher Concepts Construction Company General Contractor
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
Francis X O'brien · 6 yrs held
Francis X O'brien
since 2020
Last sale
$175,000
7 recorded transactions
Zoning & alternative use
BI · Hazel Park, MI
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 Hazel Park submarket · NOI estimate · Typical band, median & reading
Implied cap rate, NOI & submarket benchmark
Cap vs Hazel Park 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
CAP Approach
Comparable Approach
Alternative Use
Get a detailed, property-specific estimation — fast and free
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
$7,742
Tax year 2023
Assessed value
$94,480
Assessed 2024
Previous assessed
$86,990
+8.6% YoY
Effective rate
8.19%
On assessed value
Total market value
$188,960
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
Retail space
Use group
RETAIL STORES (PERSONAL SERVICES)
Status
Off-Market
Year built
1946
Heating
YES
Cooling
YES
Stories
1
Units
1
Total area
2,896 SF
Lot
0.07 ac (3,049 SF)
Zoning code
BI
APN
28-25-25-105-002
UPID
US43-0245954
Jurisdiction
OAKLAND
Metro division
WARREN-TROY-FARMINGTON HILLS, MI METROPOLITAN DIVISION
Zoning & alternative use
BI · Hazel Park, MI
Zoning BI · permitted uses
BI · Hazel Park, MI
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Permitted & conditional uses
Allowed · special-permit conditions · prohibited
Hazel Park. Always verify with local authorities before improvements.
Building & site characteristics
From public records
Year built
1946
Heating
YES
Cooling
Yes
Stories
1
Units
1
Lot
0.07 ac
Current owner
From public records · entity-resolved
Francis X O'brien
Individual
Free & Clear · 6 yrs held
Mailing address
24500 JOHN R RD, HAZEL PARK, MI 48030-1142
Mailing matches property
Yes
Owner-occupied
Yes
Ownership since
2020
Owner contacts — direct phone, email, and related entities
Decision-maker phone · Verified email · Related entities & filings
Owner contacts
Email · phone · related entities
Sales History
9 recorded events · public records
Date
Price
Buyer
Seller
Deed Type
Mortgage
Oct 14, 2025
—
Maxwell Property Holdings LLC
—
Deed
related
$200,000 · Oxford Bank
Dec 21, 2021
—
Maxwell Property Holdings LLC
—
Deed
related
$204,000 · Oxford Bank
Nov 23, 2021
—
Maxwell Property Holdings LLC
—
Deed
related
$146,000 · Oxford Bank
Apr 30, 2020
$70,000
Francis X O'brien
Mark Hornbacher
Warranty Deed
—
Apr 30, 2020
$175,000
Maxwell Property Holdings LLC
Robert James Martin
Warranty Deed
$127,500 · Main Street Bank
Sep 26, 2018
$150,000
Mark Hornbacher
First Natl Acceptance Co
Warranty Deed
—
Aug 9, 2000
—
Mark Hornbacher
M & S Enterprises INC
Grant Deed
related
—
Sep 13, 1999
—
M & S Enterprise INC
Market Realty & Investment
Grant Deed
$100,000 · Seller
Sep 9, 1999
—
Realty Market
Mckinnon,charles C & Nola
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 24500 John R 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.
