| 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 | $11,800,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250002287'
Array
| 20250002287 | 4000 Vorhies Road | | Superior Twp | Residential | $9,499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250009729'
Array
| 20250009729 | 1500 Long Lake Road | | Bloomfield Twp | Residential | $6,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250013561'
Array
| 20250013561 | 252 Linden Road | | Birmingham | Residential | $6,599,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 = '20250000557'
Array
| 20250000557 | 540 Watkins Street | | Birmingham | Residential | $3,999,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250004206'
Array
| 20250004206 | 59 Hidden Ridge | | Bloomfield Hills | Residential | $3,890,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 = '20240091066'
Array
| 20240091066 | 303 State Avenue | | Alpena | Residential | $2,790,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250000549'
Array
| 20250000549 | 907 Ann Street | | Birmingham | Residential | $2,649,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 = '20240088587'
Array
| 20240088587 | 00 West Road | | Brownstown Twp | Vacant Land | $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 = '20240087026'
Array
| 20240087026 | Lot 3 Tindall Road | | Groveland Twp | Vacant Land | $2,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250013907'
Array
| 20250013907 | 7255 Baldwin Road | | Atlas Twp | Residential | $1,800,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240093387'
Array
| 20240093387 | 00 Saginaw Road | | Grand Blanc Twp | Vacant Land | $1,700,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240092116'
Array
| 20240092116 | 42 Beresford | | Bloomfield Hills | Vacant Land | $1,699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250011476'
Array
| 20250011476 | 2224 Lake Angelus Shores | | Lake Angelus | Residential | $1,599,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240091887'
Array
| 20240091887 | 6 Mccandlish Road | | Grand Blanc Twp | Vacant Land | $1,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250006843'
Array
| 20250006843 | 594 Chesterfield Avenue | | Birmingham | Residential | $1,499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240049522'
Array
| 20240049522 | 7699 Minnick Road | | Rubicon Twp | Residential | $1,459,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250004601'
Array
| 20250004601 | 624 Livernois Street | | Ferndale | Commercial | $1,399,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250004606'
Array
| 20250004606 | 624 Livernois Street | | Ferndale | Vacant Land | $1,399,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240088702'
Array
| 20240088702 | Parcel A West Road | | Brownstown Twp | Vacant Land | $1,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240088715'
Array
| 20240088715 | Parcel B West Road | | Brownstown Twp | Vacant Land | $1,250,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 = '20240073819'
Array
| 20240073819 | 000 8 Mile Road | | Salem Twp | Vacant Land | $895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240088402'
Array
| 20240088402 | 48041 Sugarbush Road | | Chesterfield Twp | Residential | $699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240088357'
Array
| 20240088357 | 00 Highland Road | | White Lake Twp | Vacant Land | $599,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250001184'
Array
| 20250001184 | 32375 West Road | | Huron Twp | Vacant Land | $599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20250013240'
