Branch Listings |
MLS # |
Address |
|
City |
Type |
Price
|
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250009492'
Array
20250009492 | 26400/26200 Lahser Road | | Southfield | Commercial | $26,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087018'
Array
20240087018 | 16134 Tindall Road | | Groveland Twp | Vacant Land | $15,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240042657'
Array
20240042657 | 9842 Misery Bay | | Alpena | Residential | $9,900,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251019799'
Array
20251019799 | 999 Pleasant Avenue | | Birmingham | Residential | $8,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251019812'
Array
20251019812 | 2475 W Lake Angelus Road | | Lake Angelus | Residential | $6,499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240086826'
Array
20240086826 | Lot 1 Tindall Road | | Groveland Twp | Vacant Land | $6,300,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251018756'
Array
20251018756 | 26377 Willowgreen Drive | | Franklin Vlg | Residential | $5,699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251005505'
Array
20251005505 | 1241 Woodward Heights Boulevard | | Hazel Park | Multifamily | $5,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251023108'
Array
20251023108 | 1567 Island Lane | | Bloomfield Twp | Residential | $4,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251033004'
Array
20251033004 | 1295 Lakeside Drive | | Birmingham | Residential | $3,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251003467'
Array
20251003467 | 2759 Turtle Ridge Drive | | Bloomfield Twp | Residential | $3,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251022142'
Array
20251022142 | 1541 Shipman Boulevard | | Birmingham | Residential | $3,950,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251003905'
Array
20251003905 | 4150 Port Austin Road | | Lake Twp | Residential | $3,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230014027'
Array
20230014027 | 875 Green Street | | Elk Rapids Vlg | Vacant Land | $3,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087102'
Array
20240087102 | Lot 6 Tindall Road | | Groveland Twp | Vacant Land | $3,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251006041'
Array
20251006041 | 1251 Woodward Heights Boulevard | | Hazel Park | Multifamily | $2,950,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251004123'
Array
20251004123 | 10611 Lighthouse Point | | Green Oak Twp | Residential | $2,750,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230098765'
Array
20230098765 | 453 Martin Luther King Jr Boulevard | | Detroit | Commercial | $2,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087016'
Array
20240087016 | Lot 2 Tindall Road | | Groveland Twp | Vacant Land | $2,400,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251019108'
Array
20251019108 | 5001 Forest Valley | | Independence Twp | Residential | $2,399,990 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251006029'
Array
20251006029 | 1241 Woodward Heights Boulevard | | Hazel Park | Multifamily | $2,300,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087026'
Array
20240087026 | Lot 3 Tindall Road | | Groveland Twp | Vacant Land | $2,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251031544'
Array
20251031544 | 356 Pilgrim Avenue |