Branch Listings |
MLS # |
Address |
|
City |
Type |
Price
|
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240012245'
Array
20240012245 | 999 Pleasant Street | | Birmingham | Residential | $8,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240020381'
Array
20240020381 | 1500 Long Lake Road | | Bloomfield Twp | Residential | $6,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240013570'
Array
20240013570 | 1567 Island Lane | | Bloomfield Twp | Residential | $6,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240018828'
Array
20240018828 | 672 Vaughan Road | | Bloomfield Hills | Residential | $6,900,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240004212'
Array
20240004212 | 252 Linden Road | | Birmingham | Residential | $6,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230097044'
Array
20230097044 | 663 Shirley Road | | Birmingham | Residential | $5,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240019678'
Array
20240019678 | 611 Watkins Street | | Birmingham | Residential | $5,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240012193'
Array
20240012193 | 253 Marblehead Drive | | Bloomfield Hills | Residential | $3,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240019088'
Array
20240019088 | 540 Watkins | | Birmingham | Residential | $3,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240023198'
Array
20240023198 | 5930 Pontiac Trail | | Orchard Lake Village | Residential | $3,990,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240016233'
Array
20240016233 | 1765 Hillwood Drive | | Bloomfield Hills | Residential | $3,495,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 = '20230098765'
Array
20230098765 | 453 Martin Luther King Jr Boulevard | | Detroit | Commercial | $2,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240023907'
Array
20240023907 | 2020 Lake Angelus Shores | | Lake Angelus | Residential | $1,650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240020504'
Array
20240020504 | 7699 Minnick Road | | Rubicon Twp | Residential | $1,550,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240023782'
Array
20240023782 | 824 Wimbleton Drive | | Birmingham | Residential | $1,175,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230100467'
Array
20230100467 | 2300 24 Mile Road | | Shelby Twp | Residential | $1,100,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240027155'
Array
20240027155 | 2372 Pine Lake Road | | West Bloomfield Twp | Residential | $899,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221070308'
Array
20221070308 | 000 8 Mile Road | | Salem Twp | Vacant Land | $895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230056086'
Array
20230056086 | 6145 Whispering Meadows Drive | | White Lake Twp | Residential | $798,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240026281'
Array
20240026281 | 9355 Buckingham Street | | White Lake Twp | Residential | $769,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240026309'
Array
20240026309 | 160 Wolverine Drive | | Wolverine Lake Vlg | Residential | $749,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230098771'
Array
20230098771 | 1408 17Th Street | | Detroit | Commercial | $749,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230004366'
Array
20230004366 | 6420 Cowell Road | | Hamburg Twp | Residential | $699,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240002047'
Array
20240002047 | 291 Edmund Place | | Detroit | Condominium | $699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230055336'
Array
20230055336 | 5545 Franklin Road | | Bloomfield Twp | Vacant Land | $650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240025785'
Array
20240025785 |