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!
Property Details
Price:
$2,200,000
MLS #:
58050187495
Status:
Active
Beds:
0
Baths:
0
Type:
Commercial
Subtype:
BusinessandRealEstate
Neighborhood:
area03131warren
Listed Date:
Sep 5, 2025
Total Sq Ft:
7,335
Year Built:
1953
See this Listing
Schools
School District:
WarrenCon
Interior
Cooling
Window Units
Flooring
Carpet, Ceramic Tile
Heating
Natural Gas
Exterior
Building Features
DisabledAccess, Fixtures, Furniture, CeilingHeightLessthan16ft, CableInternetInstalled, LivingQuarters, LivingQuartersAttached, LivingQuartersDetached, PoleSign, Restrooms, Sprinklers, Sidewalks
Construction Materials
Brick, Shingle Siding
Fencing
Fenced
Other Structures
Guest House
Parking Features
Other
Roof
Shingle
Financial
Map
Community
- Address28710 VAN DYKE AVE Warren MI
- CityWarren
- CountyMacomb
- Zip Code48093
Subdivisions in Warren
- A J CHRISTES
- A/P # 09 CENTERLINE
- ABBOT & BEYMER’S HALF WAY GDS
- ABBOT & BEYMERS HALF WAY GARDENS
- ABBOTT & BEYMERS MAC PARK
- ARDEN PARK HEIGHTS
- ARLINGTON MANOR
- ARMANDA SUB
- ASPENWOOD
- ASSESSORS ADD
- BALMORAL PARK # 02
- BALMORAL PARK SUB
- BALMORAL PARK SUB 1
- BALMORAL PARK SUB 2
- BARBARY SUB
- BARBARY SUB 2
- BARCLAY SQUARE SUB
- BEACH LAWN SUB
- BEAR CREEK VILLAGE
- BEECH LAWN SUB
- BELANGERS GARDENS
- BERKSHIRE ESTATES
- BILTMORE HEIGHTS SUB
- BILTMORE HEIGHTS SUB 2
- BLACKETT LITTLE FARMS SUB
- BLISSMOR SUB
- BLOSSOM LANE ESTATES
- BOSTON COMMONS
- BROOKTON
- CAMEO HOMES SUB
- CAPITANI HEIGHTS SUB
- CAPLAN SUB
- CAPRI VILLA SUB 1
- CARLETON ESTATES SUB
- CAROLE LANE SUB
- CAROLE PARK SUB
- CEDAR PARK SUB
- CHAPP HIGHLAND SUB
- CITY CENTER ESTATES
- CITY CENTER SQUARE
- CITY CENTER SQUARE # 03
- CITY CENTER SQUARE # 04
- COACH LIGHT MANOR
- COLEMAN UNITY SUB
- CREEKS EDGE AT HERITAGE VILLAGE CONDO #961
- CUMBERLAND # 02
- DALBY & CAMPBELL VAN DYKE
- DALBY & CAMPBELL VAN DYKE # 01
- DALBY & CAMPBELL VAN DYKE SUB
- DANA MANOR
- DANA MANOR SUB
- DENTON INDUSTRIAL SUB
- DEVELYN SUB
- DOVER HEIGHTS SUB
- EAST POINTE VILLA
- EASTERN HEIGHTS
- EASTERN HEIGHTS SUB
- EASTVIEW SUB
- ELBERT H FOWLERS 12-RYAN
- ELEANORE SUB
- ELEANORE SUB 1
- ELM GARDENS SUB
- ELM PARK SUB
- ENGLISH COLONY
- EVA GARDENS SUB
- EXECUTIVE ESTATES SUB
- FAIRFIELD GARDENS
- FAIRFIELD GARDENS SUB
- FAIRLANE ESTATES SUB
- FEDERAL PARK
- FEDERAL PARK SUB
- FEDERAL PARK SUBDIVISION
- FEDERAL PARK SUBDIVISION, LOT #60
- FERGUSON ESTATES SUB
- FIELDING PARK SUB
- FITZGERALD HEIGHTS
- FOUR SONS ESTATES SUB
- FRANK C NALLS SUNSET HILLS
- FRANK PARK SUB
- FRAZHO LANE
- FROLING & GREEN SUB
- GEORGE A KARAM RIVARDS SUB
- GERRY STEARNS SUB
- GRANADER SUB
- GRAND OAKS I
- GREEN ACRES SUB 1
- GREEN FARMS SUB
- GREENBRIAR ESTATES
- GROBBEL CENTENNIAL
- H H RENSHAWS CENTERLINE # 01
- HAMPTON MANOR CONDO #952
- HAYES BLVD SUB
- HEATHERWOOD VILLAS
- HERRICK’S
- HESSE BROWN SUB
- HESSE-BROWN
- HEUSSNER GARDEN SUB
- HIGHLAND MANOR SUB
- HILLSIDE SITES
- HILLSIDE SITES SUB
- HITCHMANS INDEPENDENCE PARK
- HITCHMANS INDEPENDENCE PARK SUB
- HOLIDAY GROVES SUB
- HOPP & NEVILLE’S HALFWAY VILL # 01 WARREN
- INVESTMENT PARK
- JACKSON PARK
- JOHN B SOSNOWSKI EIGHT MILE ROAD
- JOHN F KEYS KEYSLAWN ESTATES
- JOSEPH MANOR CONDO
- KAISER GARDENS
- KAISER GARDENS SUB
- KARAMS SUNNYLANE # 01
- KEHOES NORTH VAN DYKE
- KINGSWOOD SUB
- LA JOLLA SUB
- LAETHEMS NEAR VAN DYKE
- LANCASTER WOODS
- LAURIE SUB
- LEATHEM’S NEAR VAN DYKE
- LEDGECLIFF ESTATES SUB
- LEO A TEMROWSKI’S GREATER VAN DYKE SUB
- LEO A TEMROWSKI’S SUB
- LEO A TEMROWSKIS SUB
- LEXINGTON TOWNHOUSES
- LIBERTY ACRES SUB
- LILA MANOR SUB
- LORRAINE SUB
- MAPLE GROVE
- MAPLE LANE VALLEY # 02
- MAPLE LANE VALLEY # 03
- MAPLE LANE VALLEY # 04
- MAPLES
- MARCEL GARDENS
- MIAMI
- MIAMI SUB
- MOCERI SUB
- MONTCLAIR HEIGHTS SUB
- MONTCLAIR HEIGHTS SUB LOT 85
- MORANDS VAN DYKE SUB
- MORGAN ESTATES SUB
- MORNINGSIDE MANOR # 01
- MORNINGSIDE MANOR SUB
- MORRIS GARDENS SUB
- MULLINS EIGHT MILE LAWN
- MULLINS EIGHT MILE LAWN SUB
- NATHAN KLING SUB
- NATIONAL GARDENS SUB
- NEWPORT GARDENS SUB
- NICOLAI ESTATE SUB
- NORMAN HALMICK
- O’MEARA
- OMEARA
- ORLEYS VAN DYKE
- PADEREWSKI PARK SUB
- PALMER WOODS ESTATES
- PATRICIAN SUB
- PETER OTTO SUB
- PETER PARK SUB
- PETER WEBERS NINE MILE
- PIPER’S SECOND VAN DYKE FARMS SUBDIVISION LOT 277
- PIPER’S VAN DYKE # 06
- PIPER’S VAN DYKE # 08
- PIPER’S VAN DYKE # 09
- PIPERS 1ST VAN DYKE FARMS
- PIPERS 2ND VAN DYKE FARMS
- PIPERS 3RD VAN DYKE FARMS
- PIPERS VAN DYKE
- PIPERS VAN DYKE # 07
- PIPERS VAN DYKE # 08
- PIPERS VAN DYKE # 09
- PIPERS VAN DYKE # 10
- PIPERS VAN DYKE SUB
- PIPERS VAN DYKE SUB 1
- PIPERS VAN DYKE SUB 2
- PIPERS VAN DYKE SUB 4
- PIPERS VAN DYKE SUB NO 4
- POLESKI VAN DYKE SUB
- POLESKI VAN DYKE WARREN
- PRESCOTT PARK SUB
- PRESIDENT VILLAGE
- PRINCETON COURT CONDO
- QUALMANNS PINECREST SUB
- RAMM & CO’S MOUND PARK # 01
- RAMM & COS MOUND PARK
- RAMM & COS MOUND PARK # 01
- RAMM AND CO’S WOODLANDS SUBDIVISION
- RAY KIMBERLEY SUB
- REBECCA
- REGENT PARK SUB
- RICE & MILLERS SUB
- RIVARDS GARDENS SUB
- RIVER HEIGHTS # 02
- RIVIERA SUB
- ROBINWOOD ESTATES SUB
- ROGER SUB
- ROMAN GARDENS
- ROYAL COURTS
- ROYAL MANOR
- ROYAL MANOR SUB
- RYAN MEADOWS SUB
- S/P # 02 WARREN
- S/P # 03 WARREN
- S/P # 05 WARREN
- S/P BLACKETT LITTLE FARMS
- S/P DENGS SMALL FARMS # 14
- S/P EAST DETROIT LITTLE FARMS
- S/P EIGHT MILE ROAD LITTLE FARMS
- S/P EYSTER-CROMIE DEQUINDRE FARMS
- S/P FOERSTERS LITTLE FARMS
- S/P GREEN MEADOWS
- S/P GREENWOOD HILLS
- S/P HEATH’S FAIRVIEW
- S/P HEATHS FAIRVIEW
- S/P HIGHLAND FARMS
- S/P JACOBS FARM
- S/P KALTZ HOMESTEAD
- S/P KIEFER LAND CO # 01
- S/P KIEFER LAND CO # 03
- S/P KLINGKAMMER FARM
- S/P KOELERS WOODLAND
- S/P LADD CENTER
- S/P LEFEVRE FARMS # 15
- S/P LONE MAPLE FARMS
- S/P MARTINS LITTLE FARMS
- S/P MASCH FARMS
- S/P MEADOWLANE
- S/P MIKOLOWSKI FARM
- S/P NUMMER FARM # 01
- S/P OLD HOMESTEAD FARMS
- S/P PAUL HOSTES 1ST
- S/P PROS RANCH
- S/P SCHULTZ FARMS
- S/P SIMONDS GARDENS HOMESITES
- S/P STOLZENFELD HOMESITES
- S/P WARREN ESTATES
- S/P WASMUND FARMS
- S/P WELTON OBENAUERS GARDEN GATE # 01
- S/P YOUNG GARDENS
- SCARBOROUGH SQUARE # 02
- SCARBOROUGH SQUARE CONDO
- SCHWEDER SUB
- SEBASTIAN SUB
- SEGUIN PARK
- SEGUIN PARK SUB
- SHARRON COMMONS SUB
- SHAWN PARK SUB
- SHAWNEE HWY SUB
- SHERWOOD PARK
- SMOKLER RYAN SUB
- SPRENGER PARK SUB
- ST ANNE’S ARDEN PARK # 05
- ST ANNES ARDEN PARK # 03
- ST ANNES ARDEN PARK # 07
- ST DOROTHY’S PARK
- ST JOHNS # 01
- ST REGIS PARK SUB
- STIEBERS SMALL ACRES SUB
- STONERIDGE/HERITAGE VILLAGE CONDO
- SUBURBAN VILLAS # 01
- SUBURBAN VILLAS SUB
- SUMERACKI’S VAN DYKE
- SUMERACKIS VAN DYKE
- SUMMERSET
- SUNFLOWER VILLAS #724
- SUNNY ACRES SUB
- SUNRISE VILLA
- SUPER VAN DYKE
- SUPER VAN DYKE SUB
- SUPERVISORS CHESTERFIELD PARK SUB 2
- SUPERVISORS METTERS SMALL FARMS SUB
- SUPERVISORS OF MEADOWLANE SUB
- SUPERVISORS OF WILLIAMS SUB
- SUPERVISORS PLAT NO 9 OF HEATHDALE
- T BOGDANSKI GARDENS
- TECH ESTATES SUB
- THE COURTYARDS AT HERITAGE VILLAGE CONDO #951
- THE LINCOLN SUB
- THE MAPLES SUB
- THE RESERVE AT HERITAGE VILLAGE CONDO #943
- THE TERRACES AT HERITAGE VILLAGE CONDO #966
- TIGER LANE SUB
- TOEPFER MANOR SUB
- TOWNE CENTER CONDO OF WARREN #970
- TREMBLETON SUB
- TWINBROOK SUB
- UNIVERSAL CITY ESTATES
- UNIVERSITY MANOR
- UNIVERSITY MANOR CONDOMINIUMS
- URBANREST FARMS SUB
- VALENTI SUB
- VALLEY HI SUB
- VAN DYKE VIEW SUB
- VAN THOME PARK SUB
- VANDENBOSSCHE
- VANDENBOSSCHE SUB
- VENTURA
- VICTOR HEIGHTS SUB
- VILLA CAPRI
- WAGNER LITTLE FARMS SUB
- WARREN CON 2
- WARREN FARMS SUB
- WARREN HIGHLANDS SUB
- WARREN OAKS SUB
- WARREN PARK SUB
- WARREN PLAZA SUB
- WASHINGTON GARDENS SUB
- WEDGEWOOD SUB
- WEDGEWOOD VILLAGE WEST #747
- WEST POINTE VILLA
- WILDWOOD PARK SUB
- WILLIAMSBURG
- WILLIAMSBURG SUB 2
- WINCHESTER SUB
- WM MASCH FARM
- WOODCREST PARK SUB
- YACHT GARDENS
Market Summary
Current real estate data for Commercial in Warren as of May 26, 2026
27
Commercial Listed
196
Avg DOM
139
Avg $ / SqFt
$968,170
Avg List Price
Property Summary
- 28710 VAN DYKE AVE Warren MI is a Commercial for sale in Warren, MI, 48093. It is listed for $2,200,000 To schedule a showing of MLS#58050187495 at 28710 VAN DYKE AVE in Warren, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby
28710 VAN DYKE AVE
Warren, MI