MLS # 50187495 (MiRealSource)

RARE INVESTMENT OPPORTUNITY: Located at 28710 Van Dyke Ave, Warren, MI 48093, this exceptional property is a true gem in the heart of Warren, Michigan. Featuring a 20-Unit Extended Stay Motel, House, Restaurant, and Apartment, this recession-proof and pandemic-proof investment offers a lucrative endeavor for savvy investors. Situated on 0.88 acres with 246' of frontage on Van Dyke Avenue, this property boasts a prime location in a retail corridor surrounded by national tenants and close to Warren's prominent manufacturing and automotive facilities. With a daily vehicle count of 75,000, multiple points of ingress/egress, and 30,000 employees within a one-mile radius, this property presents an incredible opportunity for growth and profit. Highlights include a cap rate of 10.79%, recent renovations in 2022, including parking lot resurfacing and restaurant updates with a new 3-year lease, on-site manager 24/7, ample parking with 40 spaces, and excellent demographics. Don't miss out on this turnkey investment!
Source: SparkMLS
This 7,335 sq ft home built in 1953 sits in Warren in Warren.
Currently offered at $2,200,000 (about $300/sq ft).
Electric service is provided by DTE Electric Company; natural gas by Consumers Energy Company. Fiber internet is available at this address with download speeds up to 5,000 Mbps across 10 providers.
Location
Construction & Systems
Sale & Financing
Source: SparkMLS
FEMA Flood Zone: Zone X — Minimal flood risk
Source: FEMA NFHLUSDA Rural Development: Not Eligible
Verify eligibility at USDAListed by Tariq Herish
Brookstone, Realtors LLC
Estimate only. Does not include PMI or other fees. Consult a lender for exact rates.
Download
5 Gbps
Upload
5 Gbps
FCC Broadband Data Collection (Dec 2025). Max advertised speeds.
DTE Electric Company
Investor-Owned
Consumers Energy Company
Investor-Owned
MI Public Service Commission service territory boundaries.
Property
28710 VAN DYKE Avenue, Warren, MI 48093
View full property history →
Municipality
Warren
View all listings →
County
Macomb County
View county overview →
We'll notify you when something hits the market in Warren or nearby.
Munro Real Estate · MI Broker #6502405404 · No spam, one-click unsubscribe.