| 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 = '20261000975'
Array
| 20261000975 | 1295 Lakeside Drive | | Birmingham | Residential | $3,799,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 = '20240087102'
Array
| 20240087102 | Lot 6 Tindall Road | | Groveland Twp | Vacant Land | $3,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261005702'
Array
| 20261005702 | 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 = '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 = '20261003901'
Array
| 20261003901 | 608 Purdy Street | | Birmingham | Residential | $1,299,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250021788'
Array
| 20250021788 | 7699 Minnick Road | | Rubicon Twp | Residential | $1,299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087028'
Array
| 20240087028 | Lot 4 Tindall Road | | Groveland Twp | Vacant Land | $1,100,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251038757'
Array
| 20251038757 | 8650 Stone Road | | Maybee Vlg | Residential | $949,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251040440'
Array
| 20251040440 | 000 8 Mile Road | | Salem Twp | Vacant Land | $895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261005499'
Array
| 20261005499 | 38383 Saddle Lane | | Clinton Twp | Residential | $849,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251041237'
Array
| 20251041237 | 11436 NE Lakeview Road | | Kalkaska Twp | Residential | $799,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251029354'
Array
| 20251029354 | 22601 Highbank Drive | | Beverly Hills Vlg | Residential | $795,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251056664'
Array
| 20251056664 | 580 Brys Drive | | Grosse Pointe Woods | Residential | $779,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261005342'
Array
| 20261005342 | 4130 Ellwood Avenue | | Berkley | Residential | $725,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261005813'
Array
| 20261005813 | 8515 Sandy Crest Drive | | White Lake Twp | Residential | $650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240053359'
Array
| 20240053359 | 13850 Grand River Avenue | | Detroit | Commercial | $610,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261004794'
Array
| 20261004794 |