Property Record
42827 Irwin Dr, Harrison Township, MI 48045
Property Detail
42827 Irwin Dr
17-12-07-152-003
SUGAR BUSH SUBDIVISION LOTS 1; 2 & 3
Lightindustrial
Macomb
IND
Michigan
B and X Area of moderate flood hazard, usually the area between the limits of the 100-year and 500-year floods.
1
2025
1.86 AC
2025
Groesbeck North
247100
Detroit
25,141 SF
Detroit-Warren-Dearborn, MI
NEARBY LISTINGS FOR SALE OR LEASE
DEMOGRAPHICS near 42827 Irwin Dr
1 mile
3 mile
5 mile
2025 Total Population
4,719
58,181
163,698
2030 Population
4,911
59,281
165,894
Pop Growth 2025-2030
+ 4.07%
+ 1.89%
+ 1.34%
Average Age
35
42
42
2025 Total Households
1,940
25,274
68,470
HH Growth 2025-2030
+ 3.81%
+ 1.80%
+ 1.37%
Median Household Inc
$37,031
$69,213
$78,664
Avg Household Size
2.20
2.20
2.30
2025 Avg HH Vehicles
1.00
2.00
2.00
Median Home Value
$69,438
$243,998
$269,123
Median Year Built
1983
1977
1983
Nearby Places
Map Layers
Map Styles
Street
Aerial
Layers
Transit
Traffic
Biking
Places
Listings with unknown addresses are not visible on the map
- Restaurants
- Banks
- Shops
- Fitness
- Groceries
PUBLIC TRANSPORTATION
AIRPORT
Windsor International
Drive
Walk
Distance
Windsor International
60 min
35.6 mi
SALE & LEASE HISTORY
LISTING DATE
SALE/LEASE
Feb 15, 2024
For Lease
Aug 19, 2024
For Lease
Nearby Properties
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
404,160 SF
22.52 AC
I-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
44.65 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
74,382 SF
3.99 AC
OS-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
22.14 AC
RM-2
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
25.14 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
20.27 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
252,226 SF
52.79 AC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
16.06 AC
R-1-C
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
26.92 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
670,448 SF
37.23 AC
L-2
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
196,459 SF
19.18 AC
I-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
229,878 SF
19.93 AC
C4 MULT
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
42,385 SF
25.55 AC
B-2
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
72,572 SF
10 AC
B-3
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
134,327 SF
10.02 AC
I-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
152,198 SF
58.24 AC
WF
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
214,201 SF
24.10 AC
B-3
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
87.32 AC
MH
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
17.85 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
45,864 SF
4.60 AC
C2
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
11.87 AC
RM-2
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
120,360 SF
10.70 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
149,652 SF
8.04 AC
SP-1
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
10.43 AC
RML
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
6.06 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
322,418 SF
8.08 AC
MU
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
588 SF
39.38 AC
WF
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
252,226 SF
49.16 AC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
134,120 SF
13.45 AC
GC
Address
Land Use
TOTAL SIZE
Lot Size
Zoning
136,474 SF
12.62 AC
I-1
The World's #1 Commercial Real Estate Marketplace
Connect with us
© 2026 CoStar Group
The information above has been obtained from sources believed reliable. While we do not doubt its accuracy we have not verified it and make no guarantee, warranty or representation about it. It is your responsibility to independently confirm its accuracy and completeness. Any projections, opinions, assumptions, or estimates used are for example only and do not represent the current or future performance of the property. The value of this transaction to you depends on tax and other factors which should be evaluated by your tax, financial, and legal advisors. You and your advisors should conduct a careful, independent investigation of the property to determine to your satisfaction the suitability of the property for your needs.