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 = '2200049715'
Array
2200049715 | 800 Cranbrook Road | | Bloomfield Hills | Residential | $4,950,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200099925'
Array
2200099925 | 1333 Fairfax Street | | Birmingham | Residential | $3,850,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 = '2200020490'
Array
2200020490 | 2915 Turtle Pond Court | | Bloomfield Twp | Residential | $3,250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001655'
Array
2210001655 | 00 S Saginaw Road | | Grand Blanc Twp | Vacant Land | $3,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200078161'
Array
2200078161 | 6956 Cooley Lake Road | | White Lake Twp | Residential | $2,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200009277'
Array
2200009277 | 1586 Redding Road | | Birmingham | Residential | $2,895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200020487'
Array
2200020487 | 2718 Turtle Lake Drive | | Bloomfield Twp | Residential | $2,750,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200087217'
Array
2200087217 | 3201 Conger Street | | Port Huron | Residential | $2,750,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084214'
Array
2200084214 | 2681 Turtle Shores Drive | | Bloomfield Twp | Residential | $2,466,888 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088028'
Array
2200088028 | 9000 Hidden Lake Drive | | Howell | Residential | $2,300,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001262'
Array
2210001262 | 920 Lake Angelus Shrs Drive | | Lake Angelus | Residential | $2,199,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200095955'
Array
2200095955 | 625 Brown Street | | Birmingham | Condominium | $2,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005846'
Array
2210005846 | 1800 Rathmor Road | | Bloomfield Hills | Residential | $1,999,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089317'
Array
2200089317 | 635 Brown Street | | Birmingham | Condominium | $1,999,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200085571'
Array
2200085571 | 6340/6350 Wolf Road | | Brown City | Residential | $1,995,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200069658'
Array
2200069658 | 3521 Bluff Road | | Port Austin Twp | Residential | $1,799,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200091274'
Array
2200091274 | 733 Wimbleton Drive | | Birmingham | Residential | $1,749,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001506'
Array
2210001506 | 4390 Rayco Drive | | Metamora Twp | Residential | $1,699,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200031554'
Array
2200031554 | 745 Wallace Street | | Birmingham | Residential | $1,699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200068243'
Array
2200068243 | 909 Southfield Road | | Birmingham | Residential | $1,699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001247'
Array
2210001247 | 2020 Lake Angelus Shores | | Lake Angelus | Residential | $1,680,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200076684'
Array
2200076684 | 3990 Shallow Brook Drive | | Bloomfield Twp | Residential | $1,650,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200053085'
Array
2200053085 | 4029 Old Us Highway 27 | | Gaylord | Commercial | $1,590,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004258'
Array
2210004258 | 544 Wallace Street | | Birmingham | Residential | $1,579,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200031013'
Array
2200031013 | 12104 Indian Oak Drive | | Fenton | Residential | $1,550,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004263'
Array
2210004263 | 955 Larchlea Drive | | Birmingham | Residential | $1,499,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200099552'
Array
2200099552 | 5941 E Miller Way | | Bloomfield Twp | Residential | $1,299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200061463'
Array
2200061463 | 1720 Braidwood Road | | Riley Twp | Residential | $1,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200093645'
Array
2200093645 | 4880 Old Orchard Trail | | Orchard Lake Village | Vacant Land | $1,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086900'
Array
2200086900 | 111 Willits Street | | Birmingham | Condominium | $1,199,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017075'
Array
2200017075 | 177 Vester Street | | Ferndale | Commercial | $1,175,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 = '2200096674'
Array
2200096674 | 600 W Brown Street | | Birmingham | Condominium | $1,124,900 |
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 = '2200021587'
Array
2200021587 | 20201 Livernois | | Detroit | Commercial | $1,000,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000666'
Array
2210000666 | 3423 Chickering Lane | | Bloomfield Twp | Residential | $990,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200061962'
Array
2200061962 | 55 Orchard Lane | | Bloomfield Hills | Vacant Land | $985,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200072759'
Array
2200072759 | 000 Watkins | | Birmingham | Vacant Land | $899,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200051713'
Array
2200051713 | 100 Linda Lane | | Bloomfield Hills | Residential | $849,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003293'
Array
2210003293 | 878 Henrietta Street | | Birmingham | Residential | $799,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003299'
Array
2210003299 | 878 Henrietta Street | | Birmingham | Multifamily | $799,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210002971'
Array
2210002971 | 4612 W Maple Road | | Bloomfield Twp | Residential | $795,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210002973'
Array
2210002973 | 4612 W Maple Road | | Bloomfield Twp | Vacant Land | $795,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000008'
Array
2210000008 | 1323 Bennaville Avenue | | Birmingham | Residential | $749,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200046035'
Array
2200046035 | 2681 Turtle Shores Drive | | Bloomfield Twp | Vacant Land | $739,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001097'
Array
2210001097 | 1140 Lone Pine Woods Drive | | Bloomfield Twp | Condominium | $724,900 |
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 = '2200064058'
Array
2200064058 | 4455 Charing Cross Road | | Bloomfield Twp | Residential | $699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200096237'
Array
2200096237 | 535 Wallace Street | | Birmingham | Residential | $699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005298'
Array
2210005298 | 3879 Carriage Road | | Bloomfield Twp | Residential | $649,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084197'
Array
2200084197 | 14890-900 Dale Street | | Detroit | Commercial | $629,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200092336'
Array
2200092336 | 7477 Groveland Road | | Holly Twp | Residential | $624,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200060287'
Array
2200060287 | 8911 Clubwood Drive | | Walled Lake | Residential | $599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005542'
Array
2210005542 | 1021 Washington Avenue | | Royal Oak | Condominium | $579,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086053'
Array
2200086053 | 41 W 11 Mile Road | | Madison Heights | Commercial | $550,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081929'
Array
2200081929 | 646 W Eleven Mile Road | | Royal Oak | Condominium | $549,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200030709'
Array
2200030709 | 291 Erskine | | Detroit | Vacant Land | $499,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089802'
Array
2200089802 | 314 W Hickory Grove Road | | Bloomfield Twp | Vacant Land | $499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200074782'
Array
2200074782 | 634 W Eleven Mile Road | | Royal Oak | Condominium | $449,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200029389'
Array
2200029389 | 32820 Wing Lake Road | | Franklin Vlg | Vacant Land | $399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004253'
Array
2210004253 | 4003 Auburn Drive | | Royal Oak | Residential | $388,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005130'
Array
2210005130 | 17591 Eider Drive | | Clinton Twp | Residential | $375,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 = '2210003192'
Array
2210003192 | 502 E Lincoln Avenue | | Royal Oak | Multifamily | $350,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200093555'
Array
2200093555 | 1409 Anne Drive | | Royal Oak | Condominium | $320,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086928'
Array
2200086928 | 975 Baldwin Avenue | | Pontiac | Commercial | $294,570 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200079913'
Array
2200079913 | 37,39,39.5 N.Roslyn Avenue | | Waterford Twp | Residential | $289,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017145'
Array
2200017145 | 22730 Woodward Avenue | | Ferndale | Commercial | $275,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000680'
Array
2210000680 | 5603 Northcrest Crossing | | Independence Twp | Condominium | $264,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003652'
Array
2210003652 | 1949 Warwick Street | | Sylvan Lake | Residential | $243,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 = '2200092547'
Array
2200092547 | 0000 Elizabeth Lake Road | | Waterford Twp | Residential | $199,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200092555'
Array
2200092555 | 5570 Elizabeth Lake Road | | Waterford Twp | Commercial | $199,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200064135'
Array
2200064135 | 3110 Devon Brook Drive | | Bloomfield Twp | Vacant Land | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200101527'
Array
2200101527 | 0 Rush | | Oakland Twp | Vacant Land | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200037365'
Array
2200037365 | 4005 Elmhurst Road | | Waterford Twp | Residential | $189,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089197'
Array
2200089197 | 532 E Fox Hills | | Bloomfield Twp | Condominium | $129,900 |
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 = '2200096753'
Array
2200096753 | VACANT "C" Cooley Lake Road | | Milford Twp | Vacant Land | $124,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086920'
Array
2200086920 | 981 Baldwin Ave Avenue | | Pontiac | Commercial | $108,936 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005659'
Array
2210005659 | 28 S Anderson Avenue | | Pontiac | Residential | $99,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004452'
Array
2210004452 | 34896 Mercer | | Fraser | Condominium | $99,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200047170'
Array
2200047170 | 14641 Tireman Ave Avenue | | Dearborn | Vacant Land | $98,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000150'
Array
2210000150 | 265 Hughes Avenue | | Pontiac | Residential | $84,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200067182'
Array
2200067182 | 0000 Bluff Road | | Port Austin Twp | Vacant Land | $79,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200029376'
Array
2200029376 | 0000 Oregon | | Waterford Twp | Vacant Land | $69,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200051670'
Array
2200051670 | 8900 E Jefferson Avenue | | Detroit | Condominium | $69,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084079'
Array
2200084079 | 15312 Dixie Hwy | | Groveland Twp | Vacant Land | $64,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200067356'
Array
2200067356 | F1 Kathy Lynn | | Brandon Twp | Vacant Land | $49,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200071785'
Array
2200071785 | LOT E Kathy Lynn | | Brandon Twp | Vacant Land | $29,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088951'
Array
2200088951 | 1745 E George Avenue | | Hazel Park | Vacant Land | $27,950 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200069552'
Array
2200069552 | F 2 Kathy Lynn | | Brandon Twp | Vacant Land | $24,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088954'
Array
2200088954 | 1743 E Milton Avenue | | Hazel Park | Vacant Land | $24,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088958'
Array
2200088958 | 160 W Hayes Avenue | | Hazel Park | Vacant Land | $24,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088953'
Array
2200088953 | 582 E Mahan Avenue | | Hazel Park | Vacant Land | $22,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088950'
Array
2200088950 | 110 E Coy Avenue | | Hazel Park | Vacant Land | $21,950 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200010174'
Array
2200010174 | VAC Massena Drive | | Commerce Twp | Vacant Land | $19,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088957'
Array
2200088957 | 333 W Hayes Avenue | | Hazel Park | Vacant Land | $17,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088956'
Array
2200088956 | 445 W George Avenue | | Hazel Park | Vacant Land | $14,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088952'
Array
2200088952 | 998 E Hayes Avenue | | Hazel Park | Vacant Land | $12,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200097278'
Array
2200097278 | 503 Arlington Street | | Birmingham | Residential | $7,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '218065537'
Array
218065537 | 00 Sparrow Hawk | | Bellaire Vlg | Vacant Land | $5,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001348'
Array
2210001348 | 411 S Old Woodward Avenue | | Birmingham | Condominium | $4,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200093607'
Array
2200093607 | 411 S Old Woodward Avenue | | Birmingham | Condominium | $4,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089501'
Array
2200089501 | 411 S Old Woodward Ave Unit 1024 | | Birmingham | Condominium | $3,300 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200053450'
Array
2200053450 | 634 W Eleven Mile Road | | Royal Oak | Condominium | $3,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200053457'
Array
2200053457 | 626 W Eleven Road | | Royal Oak | Condominium | $3,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003206'
Array
2210003206 | 203 Curry Avenue | | Royal Oak | Residential | $3,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200097319'
Array
2200097319 | 542 Bloomfield Court | | Birmingham | Condominium | $2,800 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003302'
Array
2210003302 | 878 Henrietta Street | | Birmingham | Residential | $2,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005901'
Array
2210005901 | 6449 Rutledge Park Drive | | West Bloomfield Twp | Residential | $2,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081921'
Array
2200081921 | 644 W Eleven Mile Road | | Royal Oak | Condominium | $2,300 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000032'
Array
2210000032 | 1965 Rosedale Street | | West Bloomfield Twp | Residential | $2,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000416'
Array
2210000416 | 411 S Old Woodward Avenue | | Birmingham | Condominium | $1,850 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003330'
Array
2210003330 | 701 Park Avenue | | Royal Oak | Residential | $1,650 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004898'
Array
2210004898 | 1584 Silman | | Ferndale | Residential | $1,550 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200078073'
Array
2200078073 | 516 N Pontiac Trail | | Walled Lake | Commercial | $1,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200055589'
Array
2200055589 | 8322A Cooley Lake Road | | Commerce Twp | Commercial | $1,400 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089209'
Array
2200089209 | 532 E Fox Hills | | Bloomfield Twp | Condominium | $1,350 |
Signature Sotheby's International Realty is a member of Realcomp, the consolidated multiple listings service Throughout Southeast Michigan. Let me and my associates help you find the home of your dreams. Signature Sotheby's International Realty also specializes in worldwide relocation. Contact me for all of your Real Estate needs. |