17825 Sherwood St Hamtramck, MI 48212-1435
Entity Owned
21-yr Hold
Free & Clear
Estimated value (blended)
$520k
Range $468k – $572k (±10%)
Property ID
US43-3543079
Property profile
Verified
Property type
Office buildings
Use group
OFFICE BUILDING
Year built
1961
Total area
48,208 SF
Lot
3.48 ac (151,589 SF)
Zoning code
M4
APN
15012237-8
UPID
US43-3543079
Cap rate & NOI
Priority signal for investors
Implied cap rate, NOI & suggested price
Cap rate 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
$2.97M
Blend (final)
Blend
$520k
Owner & transaction history
since 2005
1 recorded transaction
Zoning & alternative use
M4 · Hamtramck, MI
Top alternative use upside
Commercial (general)
$4.4M
+48.1%
Restaurant
$4.4M
+48.0%
Neighborhood: shopping center
$3.7M
+22.9%
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
Value estimation
Instant AI valuation built from comps, income signals, and proprietary benchmarks. A defensible range, not a single guess.
17% off on annual
Unlock the complete Valuation workflow
Full NOI reconstruction, selected comps, alternative-use scenarios, data audit and PDF export.
6 alternative uses screened
Sensitivity value band
Source audit · 10 inputs
PDF export
Analytics Standard · 5 reports
from $99/month
from $99/month
Summary
1
Valuation conclusion
Included free
Estimated market value
$520k
Value range
$468k – $572k
±10% around blend
Estimated value / SF
$11 / SF
Confidence
Property data
63
Market benchmarks
67
Comparable evidence
60
$468k
blend $520k
$572k
Market-derived valuation under stabilized market assumptions. Desktop analysis. No physical inspection performed.
2
Subject property
Included free
GBA
48,208 SF
Lot area
3.48 ac
Year built
1961
Stories
2
APN
15012237-8
3
Income approach: direct capitalization
Partial preview
Not enough income data on file for a CAP-approach estimation.
4
Sales comparison
Partial preview
Sales approach indication
$2.97M
Range $1.23M – $4.90M
Evidence
6 found
Recent peer sales in this city
5
Sensitivity & risk
Partial preview
Downside
−10%
Base
$520k
Upside
+10%
Bounds of the ±10% band vs the blend — never simulated scenarios.
6
Current market position
Included free
Benchmark
Observed band ($/SF)AverageSubject delta
Submarket 206 sales
$62
-83%
County 473 sales
$97
-89%
Band = middle half (Q1–Q3) of recorded sale $/SF for this use type per geography; the diamond marks the subject at $11/SF. Delta below average reads as headroom. Source: Realmo CRE sales derivatives (county records).
7
Alternative use screening
Partial preview
Top alternative use
Commercial (general)
Gross theoretical uplift
+48%
vs current-use indication
Restaurant
Neighborhood: Shopping Center
Medical Building
Office Building · current use
Values shown before conversion costs, entitlement costs, capital expenditures and stabilization risk.
8
Data & methodology
Included free
Building area
County record
Property tax
Not available
Assessed value
Not available
Zoning designation
Not available
Operating expenses
Not available
Market rent
Not available
Actual rent roll
Not available
Tenant leases
Not available
Physical condition
Not inspected
Conversion costs
Not available
Not analyzed due to unavailable source data: tenant leases, physical condition and capital
requirements were not available for this desktop analysis. Cost Approach excluded due to
availability of income evidence.
Automated valuation analysis, not a licensed appraisal. Figures are derived from public
records and proprietary models. Desktop analysis: no physical inspection, tenant leases or reported
property income. Verify with a licensed appraiser before transacting.
Cap rate
Cap rate calculated from real income and expense signals, benchmarked against sales of similar assets nearby.
17% off on annual
Unlock the complete Cap Rate workflow
Full market tables, editable assumptions, comparable evidence, saved work and exports.
9-scenario matrix
Market rates by use type
PDF export
Analytics Standard · 5 reports
from $99/month
from $99/month
Overview
No cap rate is computable for this property yet: no recorded sale, income signal or market-rate row for its use type.
Price sensitivity
The rate is the decision lever; valuation is the consequence.
Test a cap rate
Implied value$520k
Move the market yield to see immediate price impact.
Value / SF
$11
Vs. selected
Base
Derivation
NOI ÷ cap
Arithmetic over the derived NOI * — not market scenario modeling.
NOI × cap matrix
Preview
Preview of 9 modeled outcomes.
NOI
5.00%7.00%9.00%
$33k
$655k
$468k
$364k
$36k
$728k
$520k
$404k
$40k
$801k
$572k
$445k
NOI sensitivity ±10% across the 5 / 7 / 9% anchors — derivation of the NOI above.
Property tax & assessments
Tax year 2023Property tax & assessments
Tax year 2023
Applied tax rate
82,010.0000
Automated cap rate analysis. Based on public records, market benchmarks and proprietary
models. Verify with a licensed professional before transacting.
Property description
Physical attributes from public recordsBuilding & lot
Public records
Property type
Office buildings
Use group
OFFICE BUILDING
Status
Off-Market
Year built
1961
Heating
FORCED AIR
Buildings
4
Stories
2
Total area
48,208 SF
Lot
3.48 ac (151,589 SF)
Zoning code
M4
APN
15012237-8
UPID
US43-3543079
Jurisdiction
WAYNE
Metro division
DETROIT-LIVONIA-DEARBORN, MI METROPOLITAN DIVISION
Zoning & alternative use
M4 · Hamtramck, MIZoning M4 · permitted uses
M4 · Hamtramck, MI
Permitted & conditional uses
Allowed uses · Special-permit conditions · Prohibited uses
Alternative use value scenarios
Repositioning upside vs current use
Alternative use deep dive — conversion cost, permits, timeline
Conversion cost estimate · Permit path & risks · Stabilized NOI per option
Building & site characteristics
From public records
Year built
1961
Heating
FORCED AIR
Stories
2
Buildings
4
Lot
3.48 ac
Zoning
The recorded zoning designation, what the district officially allows, and the municipal source it comes from.
Zoning designation
County-recorded code
M4
Jurisdiction
Hamtramck, MI
Recorded code
M4
Zoning Insight
What can be built and operated here — officially.
The district profile from the municipal source: what is on file for M4 in Hamtramck, MI.
What opens after registration
Zoning profile
2 official documentsVerified municipal sources with file download
Match provenanceAssignment basis, match tier and confidence
Private report access
See the official zoning profile for this address.
Registration is required before the official district profile is shown.
One complete report on every paid plan · 5 · 30 · 100 reports per month.
Ownership Intelligence
Find the owner behind the property.
Unlock the evidence behind ownership: portfolio, transactions, debt and signals that help you decide who to contact next.
What opens after registration
Ownership report
Owner identityResolved entity and name variants
Portfolio holdingsLinked properties and estimated value
Deal signalsSell-side activity worth following
Debt & historyRecorded loans and transaction history
Private report access
See the ownership record for this address.
Registration is required before any owner information is shown.
One complete report on every paid plan · 5 · 30 · 100 reports per month.
Owner of record and activity signals are derived from public records and modeled classifications.
They do not confirm beneficial ownership or intent to transact.
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 17825 Sherwood St?
List it free. Reach 20,000 daily buyers.
We’ve already pulled the facts. Confirm photos + price and you’re live in 2 minutes.
Full reports are paid
Unlock the full Property Analytics report
Pick a plan to open full owner contacts, all 4 valuations with methodology, the refine flow, comparable adjustments, the foot-traffic deep dive and PDF / CSV export. Cancel anytime.
