Search
Updated Two-Unit Duplex

3970 Prescott Street, Hamtramck, MI 48212

For Sale
New
$290,000

Multifamily, 2 Story, Hamtramck, MI

Property Size2,500 SF
Lot Size0.09 Acres
Price / SF$116
Days on Market2

Property Features for 3970 Prescott Street

General Information

Property type Residential Multi Family
Property subtype Other
Zoning Residential
Bedrooms 6
Bathrooms 2
Full bathrooms 2
Rooms Bathroom 2, Bedroom 5, Bedroom 6, Bedroom 1, Bedroom 4, Bedroom 3, Bedroom 2, Bathroom 1
Pets allowed Yes
Interior features Circuit Breakers
Subdivision Shipman
Elementary school district Hamtramck
Middle school district Hamtramck
High school district Hamtramck
Directions North Of Caniff And East Of Conant
Standard status Active
APN 41008020165303
Size 2,500 SF
Lot size 0.09 Acres

Taxes and HOA fees

Tax Description LOT 165 EXC E 60 FT ALSO EXC S 8 FT SHIPMAN'S SUB FRAC SEC 17-20 TIS R12E L.25 P.43WCR
Tax Annual Amount 1734
Legal Description LOT 165 EXC E 60 FT ALSO EXC S 8 FT SHIPMAN'S SUB FRAC SEC 17-20 TIS R12E L.25 P.43WCR

Utilities

Heating system Forced Air
Cooling system Ceiling Fan(s)
Water source Public

Building Details

Year built 1920
Floors in Building 2
Number of units 2
Building materials Vinyl
Architectural style Other
Buildings 1
Listing Agency: EXP Realty Main
Listed By: Sayeduzzaman Khan
Added: Nov 19 Changed: Nov 20 Last Checked: Nov 20 at 3:06AM
MLS# 20261093526

Copyright © 2026 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Rey
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.

Investment Insights

Based on property information with market context.

This 2,500-square-foot duplex in Hamtramck contains two units, each with three bedrooms, one full bathroom, and its own kitchen. Recent interior work includes new kitchen cabinets, bathroom toilets and vanities, flooring, and paint. The roof was replaced in 2024, and the property also has a new porch. Forced-air heating and ceiling fans are listed among the building features.

The property sits on a 0.09-acre lot. The listing notes proximity to Detroit, major freeways, shops, and restaurants. A second home in the backyard has city approval, according to the property information.

Key Highlights

  • Two units, each with 3 bedrooms, 1 full bathroom, and a separate kitchen
  • 2,500‑square‑foot building on a 0.09‑acre lot
  • Roof replaced in 2024; new porch

Financial Insights

Estimated NOI and Cap Rate

NOI / Yr
$24,544
Cap Rate
8.46%
Suggested Prices Based on Cap Rates
Cap Rate 5%
$490,880 $490.9K
Cap Rate 7%
$350,629 $350.6K
Cap Rate 9%
$272,711 $272.7K
NOI Build-Up for 2,500 SF
Gross rent
$37.5K
($15.00/SF)
Vacancy
−$2.4K
(−$0.98/SF)
EGI
$35.1K
($14.03/SF)
OpEx
−$10.5K
(−$4.21/SF)
NOI
$24.5K
($9.82/SF)
Market Conditions
Area
Wayne County, MI
Vacancy
6.50%
Lease Rate
$15.00 /SF/Yr
Expense Ratio
30.00%
Simulate Cap Rate and NOI
Suggested Prices Based on Cap Rates
Cap Rate 5%
$490,880
Cap Rate 7%
$350,629
Cap Rate 9%
$272,711

Alternative Uses

Best Use
Multifamily LT 5
$350.6K
$306.8K – $409.1K (±1% cap)
NOI $24,544 @ 7.0% cap · market cap 8.46%
Second Best
Apartment 5plus
$322.0K
$281.7K – $375.6K (±1% cap)
NOI $22,537 @ 7.0% cap · market cap 7.77%
Theoretical Best
Specialty Retail
$462.9K
$405.0K – $540.0K (±1% cap)
NOI $32,400 @ 7.0% cap · market cap 11.17%
Zoning and permitted uses should be independently verified with authorities. How Realmo checks its estimates

Property Analytics

Who owns this building? See the owner, sales and loan history
Open Analytics

Lease Details

2
Residential units
Yes
Highway access

Location Intelligence

Trade Area within ½ mile

1,052
Businesses Nearby

Demographics for 48212, MI

43,192
Population
14,739
Households
2.9
Avg Household Size
29
Median Age
16%
College-Educated
68%
High-School Grad
5.3 sq mi
ZIP Area
8,149
Density / Sq Mi
$37,293
Median Household Income
$28,894
Median Earnings
$935
Median Rent
$98,200
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Average Price Trend$/SF for Duplexes in Wayne County, MI

$78.39 Jul
$70.47 Aug
$68.88 Sep
$71.5 Oct

Properties on Market for Duplexes in Wayne County

Jul
Aug
Sep
Oct

Vacancy Rate% for Multifamily in Midwest region

6.5% 2022
7.5% 2023
7.8% 2024
8% 2025

Frequently Asked Questions

What type of property is this?
Duplex - Both residences have three bedrooms, a full bathroom, and a separate kitchen.
Where is this duplex located?
The property is located at 3970 Prescott Street Hamtramck, MI.
What is the asking price?
The asking price for this property is $290,000.
What are key features of this property?
This property features: Two units, each with 3 bedrooms, 1 full bathroom, and a separate kitchen; 2,500‑square‑foot building on a 0.09‑acre lot; Roof replaced in 2024; new porch
Research This Page with AI

Rey answers here. ChatGPT, Grok and Claude get the same data packet.

Includes: Price & PSF · Cap rate · Location · Zoning

Ask Rey → ChatGPT Grok Claude
Preferred Make Realmo a preferred source.

Our comps and market reports get this label in your Google results.

Add as a preferred source on Google One click on Google
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message
Why this one?
Why hide this one?