| Branch Listings |
| MLS # |
Address |
|
City |
Type |
Price
|
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 = '20261017613'
Array
| 20261017613 | 2475 W Lake Angelus Road | | Lake Angelus | Residential | $6,499,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 = '20261071563'
Array
| 20261071563 | 1042 Brookwood Street | | Birmingham | Residential | $4,899,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261064193'
Array
| 20261064193 | 840 Lakeside Drive | | Birmingham | Residential | $3,989,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261049375'
Array
| 20261049375 | 1120 Lyonhurst Street | | Birmingham | Residential | $3,895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063353'
Array
| 20261063353 | 1094 Lincoln Court | | Birmingham | Residential | $3,599,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261014418'
Array
| 20261014418 | 7357 Lindenmere Drive | | Bloomfield Twp | Residential | $3,490,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 = '20261052038'
Array
| 20261052038 | 572 Stanley Boulevard | | Birmingham | Residential | $3,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261043676'
Array
| 20261043676 | 12700 Shaffer Road | | Springfield Twp | Residential | $2,999,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261071185'
Array
| 20261071185 | 1622 Stanley Boulevard | | Birmingham | Residential | $2,895,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073022'
Array
| 20261073022 | 4911 Pinnacle Boulevard | | Oakland Twp | Residential | $2,800,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261021761'
Array
| 20261021761 | 10611 Lighthouse Point | | Green Oak Twp | 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 = '20261065164'
Array
| 20261065164 | 5001 Forest Valley | | Independence Twp | Residential | $2,299,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261059393'
Array
| 20261059393 | 907 Ann Street | | Birmingham | Residential | $2,249,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 = '20261048294'
Array
| 20261048294 | 3915 Mcginnis Road | | Groveland Twp | Vacant Land | $2,200,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261022087'
Array
| 20261022087 | 4650 Lahser Road | | Bloomfield Twp | Residential | $1,700,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063257'
Array
| 20261063257 | 6 Mccandlish Road | | Grand Blanc Twp | Vacant Land | $1,653,750 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261058933'
Array
| 20261058933 | 17862 Parkshore Drive | | Northville Twp | Residential | $1,649,600 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261065256'
Array
| 20261065256 | 751 Bates Street | | Birmingham | Residential | $1,549,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261054488'
Array
| 20261054488 | 30650 Lahser Road | | Beverly Hills Vlg | Residential | $1,509,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063535'
Array
| 20261063535 | 28575 Danvers Court | | Farmington Hills | Residential | $1,499,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261058248'
Array
| 20261058248 | 2532 Cedar Brook Court | | Rochester Hills | Residential | $1,399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055913'
Array
| 20261055913 | 16324 Brook Trout Lane | | Northville Twp | Residential | $1,299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261036248'
Array
| 20261036248 | 608 Purdy Street | | Birmingham | Residential | $1,289,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067768'
Array
| 20261067768 | 251 Woodwind Drive | | Bloomfield Hills | Residential | $1,199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261061948'
Array
| 20261061948 | 7699 Minnick Road | | Rubicon Twp | Residential | $1,198,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 = '20261025241'
Array
| 20261025241 | 2131 Birchwood Way | | West Bloomfield Twp | Residential | $1,100,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261044260'
Array
| 20261044260 | 45 Maywood Avenue | | Bloomfield Hills | Residential | $1,099,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261049955'
Array
| 20261049955 | 6925 Elm Park Drive | | Troy | Residential | $1,050,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055047'
Array
| 20261055047 | 4866 Riverchase Drive | | Troy | Residential | $999,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 = '20261031805'
Array
| 20261031805 | 1136 Michigan Avenue | | Ann Arbor | Residential | $805,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261031812'
Array
| 20261031812 | 1136 Michigan Avenue | | Ann Arbor | Multifamily | $805,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261066067'
Array
| 20261066067 | 411 Old Woodward Avenue | | Birmingham | Condominium | $799,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261065386'
Array
| 20261065386 | 55744 Lancewood Drive | | Shelby Twp | Residential | $749,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261022569'
Array
| 20261022569 | 6543 Hastings Street | | Detroit | Commercial | $700,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261028895'
Array
| 20261028895 | 6543 Hastings Street | | Detroit | Residential | $700,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261069105'
Array
| 20261069105 | 2855 Cranbrook Ridge Court | | Oakland Twp | Residential | $699,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261056515'
Array
| 20261056515 | 5133 Allison Drive | | Troy | Residential | $675,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261065369'
Array
| 20261065369 | 1444 Holland Street | | Birmingham | Residential | $624,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261058714'
Array
| 20261058714 | 2509 Liberty Street | | Ann Arbor | Residential | $620,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067454'
Array
| 20261067454 | 871 S Wynstone Circle | | Oakland Twp | Residential | $615,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261035789'
Array
| 20261035789 | 42280 Locklin Drive | | Sterling Heights | Residential | $599,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261044453'
Array
| 20261044453 | 6608 Enclave Drive | | Independence Twp | Condominium | $574,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072454'
Array
| 20261072454 | 0 SW Brigham Road | | Hadley Twp | Vacant Land | $550,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261069796'
Array
| 20261069796 | 5303 Woodrun Drive | | West Bloomfield Twp | Residential | $549,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261045018'
Array
| 20261045018 | 319 Strawberry Drive | | Rochester Hills | Condominium | $529,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261019472'
Array
| 20261019472 | 13850 Grand River Avenue | | Detroit | Commercial | $495,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251061915'
Array
| 20251061915 | VL Lahser Road Lot 76 | | Bloomfield Hills | Vacant Land | $450,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261061535'
Array
| 20261061535 | 6164 Willits Road | | Deerfield Twp | Residential | $449,999 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072946'
Array
| 20261072946 | 233 Farnum Avenue | | Royal Oak | Residential | $449,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261031899'
Array
| 20261031899 | 2546 Townsend Street | | Detroit | Residential | $445,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261032144'
Array
| 20261032144 | 2510 Townsend Street | | Detroit | Residential | $445,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261032491'
Array
| 20261032491 | 2534 Townsend Street | | Detroit | Residential | $445,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261057956'
Array
| 20261057956 | 7939 Caberfae Trail | | Independence Twp | Residential | $439,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073278'
Array
| 20261073278 | 3332 Woodruff Meadows Court | | Highland Twp | Residential | $439,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261031977'
Array
| 20261031977 | 2524A Townsend Street | | Detroit | Condominium | $435,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261032013'
Array
| 20261032013 | 2516B Townsend Street | | Detroit | Condominium | $435,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251018627'
Array
| 20251018627 | 8735 Lyndon Street | | Detroit | Commercial | $410,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20240087029'
Array
| 20240087029 | Lot 5 Tindall Road | | Groveland Twp | Vacant Land | $400,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055906'
Array
| 20261055906 | 2611 Mcclellan Street | | Detroit | Residential | $399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055921'
Array
| 20261055921 | 2701 Mcclellan Street | | Detroit | Residential | $399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063759'
Array
| 20261063759 | 19005 Silver Parkway | | Fenton Twp | Commercial | $399,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072956'
Array
| 20261072956 | 2219 Royal Avenue | | Berkley | Residential | $395,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261031922'
Array
| 20261031922 | 2542 Townsend Street | | Detroit | Residential | $390,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261032480'
Array
| 20261032480 | 2504 Townsend Street | | Detroit | Residential | $390,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063723'
Array
| 20261063723 | 116 Kenwood Avenue | | Royal Oak | Residential | $389,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251051857'
Array
| 20251051857 | 1991 Calvert Street | | Detroit | Residential | $380,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261031961'
Array
| 20261031961 | 2524B Townsend Street | | Detroit | Condominium | $380,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261032098'
Array
| 20261032098 | 2516A Townsend Street | | Detroit | Condominium | $380,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261044762'
Array
| 20261044762 | 997 River Rock Drive | | Holly Twp | Residential | $379,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067352'
Array
| 20261067352 | 487 Woodvale Drive | | Commerce Twp | Condominium | $379,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261053485'
Array
| 20261053485 | 28300 Oakley Street | | Livonia | Residential | $375,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261059540'
Array
| 20261059540 | 8871 Morrison Avenue | | Plymouth Twp | Residential | $375,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070642'
Array
| 20261070642 | 111 Main Street | | Royal Oak | Condominium | $369,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261039261'
Array
| 20261039261 | 2571 Townsend Street | | Detroit | Residential | $365,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261039315'
Array
| 20261039315 | 2571 Townsend Street | | Detroit | Multifamily | $365,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055812'
Array
| 20261055812 | 2603 Mcclellan Street | | Detroit | Residential | $359,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055830'
Array
| 20261055830 | 2709 Mcclellan Street | | Detroit | Residential | $359,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055872'
Array
| 20261055872 | 2619 Mcclellan Street | | Detroit | Residential | $359,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261055886'
Array
| 20261055886 | 2713 Mcclellan Street | | Detroit | Residential | $359,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261057493'
Array
| 20261057493 | 4821 Shelbyshire Drive | | Shelby Twp | Residential | $335,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073525'
Array
| 20261073525 | 1410 Bauman Avenue | | Royal Oak | Residential | $335,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261047364'
Array
| 20261047364 | 3760 Chicago | | Detroit | Multifamily | $325,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073481'
Array
| 20261073481 | 1268 Brys Drive | | Grosse Pointe Woods | Residential | $325,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072445'
Array
| 20261072445 | 00 Brigham Road | | Hadley Twp | Vacant Land | $299,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261059384'
Array
| 20261059384 | 41614 Hamlet Lane | | Novi | Condominium | $295,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261069023'
Array
| 20261069023 | 388 Channing Street | | Ferndale | Residential | $279,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072444'
Array
| 20261072444 | 3310 N Baldwin Road | | Hadley Twp | Residential | $260,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070553'
Array
| 20261070553 | 605 S Amelia Avenue | | Royal Oak | Residential | $259,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261022112'
Array
| 20261022112 | 4650 Lahser Road | | Bloomfield Hills | Vacant Land | $250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067510'
Array
| 20261067510 | 310 12 Mile Road | | Royal Oak | Residential | $250,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067023'
Array
| 20261067023 | 797 N Beverly Avenue | | Pontiac | Residential | $249,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261071017'
Array
| 20261071017 | 390 Hilton Road | | Ferndale | Condominium | $245,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261072383'
Array
| 20261072383 | 1505 Wilmot Street | | West Bloomfield Twp | Residential | $229,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261042501'
Array
| 20261042501 | 229 Forest Trail | | Rose Lake Twp | Residential | $223,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063725'
Array
| 20261063725 | 36702 Park Place Drive | | Sterling Heights | Condominium | $215,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261063593'
Array
| 20261063593 | 24715 Powers Avenue | | Dearborn Heights | Residential | $214,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261067177'
Array
| 20261067177 | 28448 Universal | | Warren | Condominium | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073395'
Array
| 20261073395 | 7348 N Helen Road | | Center Line | Residential | $199,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261051956'
Array
| 20261051956 | 15801 Schaefer Highway | | Detroit | Commercial | $195,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251028341'
Array
| 20251028341 | 1389 Cass Lake Road | | Waterford Twp | Vacant Land | $175,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261051062'
Array
| 20261051062 | 6246 Dorr | | Clam Union Twp | Residential | $169,950 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251047628'
Array
| 20251047628 | 75 Mathews Street | | Pontiac | Residential | $165,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261073097'
Array
| 20261073097 | 24364 N Us-23 | | Bearinger Twp | Vacant Land | $165,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261065279'
Array
| 20261065279 | 875 Pontiac Trail | | Walled Lake | Condominium | $159,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261037647'
Array
| 20261037647 | 29850 12 Mile Road | | Farmington Hills | Condominium | $140,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261062262'
Array
| 20261062262 | 11104 Cloverlawn Street | | Detroit | Residential | $123,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261058617'
Array
| 20261058617 | 241 Yale Avenue | | Pontiac | Residential | $120,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261057115'
Array
| 20261057115 | 2820 Woodslee Drive | | Royal Oak | Condominium | $109,900 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261062230'
Array
| 20261062230 | 8171 Denwood Drive | | Sterling Heights | Condominium | $79,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261033238'
Array
| 20261033238 | 9214 Hayes Street | | Detroit | Residential | $40,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251057377'
Array
| 20251057377 | 16615 Walcliff Drive | | Clinton Twp | Residential | $7,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20251057340'
Array
| 20251057340 | 2002 Ridgemont Road | | Grosse Pointe Woods | Residential | $6,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070595'
Array
| 20261070595 | 5968 Willow Grove Drive | | Troy | Residential | $4,300 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261049083'
Array
| 20261049083 | 22309 Acadia Way | | Farmington Hills | Residential | $4,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261069960'
Array
| 20261069960 | 748 Ruffner Avenue | | Birmingham | Residential | $4,000 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261034546'
Array
| 20261034546 | 3150 Hilton Road | | Ferndale | Commercial | $3,500 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261074166'
Array
| 20261074166 | 2420 Harwood Avenue | | Royal Oak | Residential | $2,700 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070546'
Array
| 20261070546 | 3128 Harvard Road | | Royal Oak | Residential | $2,600 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070258'
Array
| 20261070258 | 111 Main Street | | Royal Oak | Condominium | $2,200 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261071459'
Array
| 20261071459 | 2350 14 Mile Road | | Royal Oak | Condominium | $1,800 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070200'
Array
| 20261070200 | 3222 Coolidge Highway | | Royal Oak | Condominium | $1,700 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261068679'
Array
| 20261068679 | 463 Eton Street | | Birmingham | Condominium | $1,600 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261070203'
Array
| 20261070203 | 1407 14 Mile Rd Unit #2 | | Birmingham | Residential | $1,550 |
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20261064813'
Array
| 20261064813 | 141 Ardmore Drive | | Ferndale | Residential | $1,200 |
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. |