| Branch Listings |
| MLS # |
Address |
|
City |
Type |
Price
|
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081018'
Array
| 2200081018 | 220 Lake Park Drive | | Birmingham | Residential | $6,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210025637'
Array
| 2210025637 | 2050 W Valley Road | | Bloomfield Hills | Residential | $4,700,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210089601'
Array
| 2210089601 | 1100 Orchard Ridge Road | | Bloomfield Hills | Residential | $4,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210078529'
Array
| 2210078529 | 1765 Hillwood Drive | | Bloomfield Hills | Residential | $3,875,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210048885'
Array
| 2210048885 | 5430 Pontiac Trail | | Orchard Lake Village | Residential | $3,600,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210045518'
Array
| 2210045518 | 4150 Port Austin Road | | Lake Twp | Residential | $3,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210073994'
Array
| 2210073994 | 43275 S Interstate 94 Service Drive | | Van Buren Twp | Residential | $3,489,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210002058'
Array
| 2210002058 | 00 Mccandlish Road | | Grand Blanc Twp | Vacant Land | $3,400,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210055404'
Array
| 2210055404 | 6956 Cooley Lake Road | | White Lake Twp | Residential | $2,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210081001'
Array
| 2210081001 | 900 Adams Castle Drive | | Bloomfield Twp | Residential | $2,990,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210091441'
Array
| 2210091441 | 01 VL S Saginaw Road | | Grand Blanc Twp | Vacant Land | $2,900,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210097471'
Array
| 2210097471 | 665 Brown Street | | Birmingham | Condominium | $2,299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210043110'
Array
| 2210043110 | 4732 Anthony Wayne Drive | | Detroit | Commercial | $2,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210063677'
Array
| 2210063677 | 3751 Indian Trail | | Orchard Lake Village | Residential | $2,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210056884'
Array
| 2210056884 | 685 Hanna Street | | Birmingham | Residential | $1,999,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094062'
Array
| 2210094062 | 255 Camelot Way | | Oakland Twp | Residential | $1,999,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210043073'
Array
| 2210043073 | 295 E Ferry Street | | Detroit | Commercial | $1,900,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210076211'
Array
| 2210076211 | 28501 Fourteen Mile Road | | Farmington Hills | Residential | $1,900,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210082250'
Array
| 2210082250 | 600 Elizabeth Street | | Rochester | Condominium | $1,850,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210069422'
Array
| 2210069422 | 23900 Woodward Avenue | | Pleasant Ridge | Multifamily | $1,849,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210090621'
Array
| 2210090621 | 591 Rudgate Road | | Bloomfield Hills | Residential | $1,750,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210032402'
Array
| 2210032402 | 06 Mccandlish Road | | Grand Blanc Twp | Vacant Land | $1,695,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210092256'
Array
| 2210092256 | 2020 Lake Angelus Shores | | Lake Angelus | Residential | $1,680,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210072141'
Array
| 2210072141 | 3199 Big J Drive | | White Lake Twp | Residential | $1,650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210088179'
Array
| 2210088179 | 111 Willits Street | | Birmingham | Condominium | $1,630,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210045440'
Array
| 2210045440 | 185 Dourdan | | Bloomfield Twp | Residential | $1,600,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210043101'
Array
| 2210043101 | 670-682 Prentis Street | | Detroit | Commercial | $1,500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210045839'
Array
| 2210045839 | 3785 Poppleton Court | | Troy | Residential | $1,450,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210064728'
Array
| 2210064728 | 1791 Bowers Street | | Birmingham | Residential | $1,349,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210068811'
Array
| 2210068811 | 23900 Woodward Avenue | | Pleasant Ridge | Commercial | $1,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210014843'
Array
| 2210014843 | 00000 Plymouth Road | | Detroit | Vacant Land | $1,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210043706'
Array
| 2210043706 | 2156 Birchwood Way | | West Bloomfield Twp | Residential | $1,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210088957'
Array
| 2210088957 | 30185 Helmandale Drive | | Franklin Vlg | Residential | $1,170,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017114'
Array
| 2200017114 | 22736 Woodward Avenue | | Ferndale | Commercial | $1,150,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210092235'
Array
| 2210092235 | 2123 Chalgrove Drive | | Troy | Residential | $1,150,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210076573'
Array
| 2210076573 | 1317 N Sunset Shores Drive | | Leland Twp | Residential | $1,100,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017743'
Array
| 2200017743 | 000 Devonwood | | Troy | Residential | $1,099,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017075'
Array
| 2200017075 | 177 Vester Street | | Ferndale | Commercial | $1,050,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210057946'
Array
| 2210057946 | 4029 Old Us Highway 27 | | Gaylord | Commercial | $999,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200021587'
Array
| 2200021587 | 20201 Livernois | | Detroit | Commercial | $995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210023431'
Array
| 2210023431 | 2737 Wixom Road | | Milford Twp | Residential | $980,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210089571'
Array
| 2210089571 | 2985 Lahser Road | | Bloomfield Twp | Residential | $950,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210097556'
Array
| 2210097556 | 4258 Stoneleigh Road | | Bloomfield Twp | Residential | $950,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210070082'
Array
| 2210070082 | 411 S Old Woodward Avenue | | Birmingham | Condominium | $949,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094179'
Array
| 2210094179 | 1261 Lacrosse Trail | | Oxford Twp | Residential | $899,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210087705'
Array
| 2210087705 | 55 Orchard Lane | | Bloomfield Hills | Vacant Land | $899,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210097536'
Array
| 2210097536 | 000 Watkins | | Birmingham | Vacant Land | $899,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200061463'
Array
| 2200061463 | 1720 Braidwood Road | | Riley Twp | Residential | $819,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094949'
Array
| 2210094949 | 1812 S Bates Street | | Birmingham | Residential | $799,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210025108'
Array
| 2210025108 | 28468 Schroeder Street | | Farmington Hills | Residential | $779,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '219054322'
Array
| 219054322 | 6420 Cowell Road | | Hamburg Twp | Residential | $699,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210077030'
Array
| 2210077030 | 1370 S Sashabaw Road | | Brandon Twp | Residential | $675,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210093898'
Array
| 2210093898 | 5888 E Miller Way | | Bloomfield Twp | Residential | $674,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210064158'
Array
| 2210064158 | 1769 Golf Ridge Drive | | Bloomfield Twp | Residential | $649,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096122'
Array
| 2210096122 | 31299 E Rutland Street | | Beverly Hills Vlg | Residential | $625,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210095641'
Array
| 2210095641 | 2242 Brenthaven Drive | | Bloomfield Twp | Residential | $599,985 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084197'
Array
| 2200084197 | 14890-900 Dale Street | | Detroit | Commercial | $599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210084672'
Array
| 2210084672 | 22012-22014 Woodward Avenue | | Ferndale | Commercial | $599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210084689'
Array
| 2210084689 | 22012-22014 Woodward Avenue | | Ferndale | Multifamily | $599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210095494'
Array
| 2210095494 | 2820 Lamplighter Lane | | Bloomfield Twp | Residential | $575,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210093807'
Array
| 2210093807 | 43130 Utica Road | | Sterling Heights | Commercial | $519,330 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210038146'
Array
| 2210038146 | 000 Church Street | | Independence Twp | Vacant Land | $500,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210066453'
Array
| 2210066453 | 14900 Livernois Avenue | | Detroit | Commercial | $499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210063682'
Array
| 2210063682 | 3615 Erie Drive | | Orchard Lake Village | Vacant Land | $449,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210065991'
Array
| 2210065991 | 1700 Cooley Lake Road | | Milford Twp | Residential | $435,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210060914'
Array
| 2210060914 | 4055 Old Us Highway 27 | | Gaylord | Vacant Land | $399,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096155'
Array
| 2210096155 | 29108 Forest Hill Court | | Farmington Hills | Residential | $395,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210023913'
Array
| 2210023913 | 6771 Scotch Lake Drive | | West Bloomfield Twp | Residential | $379,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210093512'
Array
| 2210093512 | 18195 Rainbow Drive | | Lathrup Village | Residential | $360,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200098827'
Array
| 2200098827 | 0 Romeo Plank Road | | Armada Twp | Vacant Land | $350,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094009'
Array
| 2210094009 | 1945 Barclay Avenue | | Shelby Twp | Residential | $350,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210088155'
Array
| 2210088155 | 18940 Quarry | | Riverview | Commercial | $325,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096885'
Array
| 2210096885 | 9431 Cedar Island Road | | White Lake Twp | Residential | $309,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210093836'
Array
| 2210093836 | 2420 Tufts Avenue | | Royal Oak | Residential | $309,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210077299'
Array
| 2210077299 | 89 Vinewood Street | | Wyandotte | Residential | $299,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094002'
Array
| 2210094002 | 1021 S Washington Avenue | | Royal Oak | Condominium | $299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210057683'
Array
| 2210057683 | 44324 Nova Drive | | Sterling Heights | Condominium | $298,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210088565'
Array
| 2210088565 | 975 Baldwin Avenue | | Pontiac | Commercial | $294,570 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210091395'
Array
| 2210091395 | 15150 Park Street | | Oak Park | Residential | $269,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210072130'
Array
| 2210072130 | 8911 Manor Avenue | | Allen Park | Residential | $259,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210089810'
Array
| 2210089810 | 40740 Woodward Avenue | | Bloomfield Hills | Condominium | $259,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210046637'
Array
| 2210046637 | 23451 Ryan Road | | Warren | Vacant Land | $249,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210095894'
Array
| 2210095894 | 9082 Fremont Street | | Livonia | Residential | $242,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096890'
Array
| 2210096890 | 1777 Keats Avenue | | Madison Heights | Residential | $237,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096020'
Array
| 2210096020 | 2659 Ellwood Avenue | | Berkley | Residential | $232,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '219020746'
Array
| 219020746 | 000 Devonwood | | Troy | Vacant Land | $219,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210097337'
Array
| 2210097337 | 473 Orchard Lake Road | | Pontiac | Commercial | $219,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210093507'
Array
| 2210093507 | 7098 Magnolia Lane | | Waterford Twp | Condominium | $214,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210090110'
Array
| 2210090110 | 9355 Mcdougall Street | | Hamtramck | Multifamily | $199,800 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210047989'
Array
| 2210047989 | 3110 Devon Brook Drive | | Bloomfield Twp | Vacant Land | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210082513'
Array
| 2210082513 | 22031 Coolidge Highway | | Oak Park | Commercial | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210050759'
Array
| 2210050759 | 1187 Hendricks Way | | Waterford Twp | Residential | $183,777 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210095933'
Array
| 2210095933 | 42539 Eldon Avenue | | Clinton Twp | Condominium | $179,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094364'
Array
| 2210094364 | 5180 Joangay Blvd | | Waterford Twp | Residential | $164,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210094530'
Array
| 2210094530 | 38 Georgetown Court | | Dearborn | Condominium | $164,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210082482'
Array
| 2210082482 | 8300 E Jefferson Avenue | | Detroit | Condominium | $159,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210081454'
Array
| 2210081454 | 12027 Klinger Street | | Hamtramck | Residential | $155,998 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210097706'
Array
| 2210097706 | 26333 Brush Street | | Madison Heights | Residential | $145,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001252'
Array
| 2210001252 | 5354 Bristol Parke Circle | | Independence Twp | Vacant Land | $129,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210096016'
Array
| 2210096016 | 4460 Mayfair Street | | Dearborn Heights | Residential | $129,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210066136'
Array
| 2210066136 | 24826 Brittany Avenue | | Eastpointe | Residential | $127,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210047582'
Array
| 2210047582 | VACANT "C" Cooley Lake Road | | Milford Twp | Vacant Land | $124,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210066427'
Array
| 2210066427 | VACANT "B" Cooley Lake Road | | Milford Twp | Vacant Land | $124,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210083910'
Array
| 2210083910 | 735 E Madison Avenue | | Pontiac | Residential | $122,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210088575'
Array
| 2210088575 | 981 Baldwin Avenue | | Pontiac | Commercial | $108,936 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210062068'
Array
| 2210062068 | 1300 E Lafayette Street | | Detroit | Condominium | $73,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210044185'
Array
| 2210044185 | 0 Weiman | | Putnam Twp | Vacant Land | $70,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210023506'
Array
| 2210023506 | 32425 Northwestern Highway |
