| Branch Listings |
| MLS # |
Address |
|
City |
Type |
Price
|
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251041223'
Array
| 20251041223 | 26400/26200 Lahser Road | | Southfield | Commercial | $24,999,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 = '20261001237'
Array
| 20261001237 | 999 Pleasant Avenue | | Birmingham | Residential | $8,999,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 = '20261000725'
Array
| 20261000725 | 395 Greenwood Street | | Birmingham | Residential | $4,650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261000726'
Array
| 20261000726 | 1120 Lyonhurst Street | | Birmingham | Residential | $3,895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251049884'
Array
| 20251049884 | 468 Willits Street | | Birmingham | Residential | $3,800,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251061833'
Array
| 20251061833 | 1541 Shipman Boulevard | | Birmingham | Residential | $3,799,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261000975'
Array
| 20261000975 | 1295 Lakeside Drive | | Birmingham | Residential | $3,799,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 = '20251043050'
Array
| 20251043050 | 572 Stanley Boulevard | | Birmingham | Residential | $3,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251049382'
Array
| 20251049382 | 10624 Jefferson Avenue | | Detroit | Commercial | $3,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251057273'
Array
| 20251057273 | 16385/16475 17 1/2 Mile Road | | Marshall | 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 = '20251033461'
Array
| 20251033461 | 907 Ann Street | | Birmingham | Residential | $2,399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251054593'
Array
| 20251054593 | 16385 17 1/2 Mile Road | | Marshall | Residential | $2,365,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261001825'
Array
| 20261001825 | 654 Shepardbush Street | | Birmingham | Residential | $2,249,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 = '20250037689'
Array
| 20250037689 | 303 State Avenue | | Alpena | Residential | $1,800,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261001201'
Array
| 20261001201 | 4294 East Torch Lake Drive | | Central Lake Twp | Residential | $1,659,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240091887'
Array
| 20240091887 | 6 Mccandlish Road | | Grand Blanc Twp | Vacant Land | $1,575,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251041942'
Array
| 20251041942 | 10924 Grand Lake Road | | Presque Isle Twp | Residential | $1,525,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261000979'
Array
| 20261000979 | 480 Southfield | | Birmingham | Condominium | $1,499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261003901'
Array
| 20261003901 | 608 Purdy Street | | Birmingham | Residential | $1,299,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250021788'
Array
| 20250021788 |