Martin Jeakle, SRES
Real Estate Advisor
248-283-8186 (d) ext 799
248-895-5002 (c)
mjeakle@signaturesothebys.com
|
|
|
Martin Jeakle
|
20779 Atlantic Avenue, Warren
Sq. Footage: 1091
Bedrooms: 3
Baths - Full: 1
Half:
School District: Fitzgerald
Great, turnkey investment property with recent updates from city's recent rental inspection. Cute 3-bedrooms, 1.1 bath home that features all 1st Floor a… More...
|
|
Branch Listings |
MLS # |
Address |
|
City |
Type |
Price
|
SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230027391' Array 20230027391 | 1100 Orchard Ridge Road | | Bloomfield Hills | Residential | $3,750,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221058264' Array 20221058264 | 7357 Lindenmere Drive | | Bloomfield Twp | Residential | $3,750,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 = '20230036171' Array 20230036171 | 60 Quarton Lane | | Bloomfield Hills | Residential | $2,845,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221062069' Array 20221062069 | 3767 Carrie Lane | | Commerce Twp | Residential | $2,500,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040387' Array 20230040387 | 13123 Log Cabin Point | | Fenton Twp | Residential | $2,499,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230035394' Array 20230035394 | 560 Pierce Street | | Birmingham | Residential | $1,998,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230025949' Array 20230025949 | 2020 Lake Angelus Shores | | Lake Angelus | Residential | $1,650,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230011763' Array 20230011763 | 22495 24 Mile Road | | Macomb Twp | Vacant Land | $1,600,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230011885' Array 20230011885 | 22495 24 Mile Road | | Macomb Twp | Residential | $1,600,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040695' Array 20230040695 | 2834 Shannon Drive | | Oakland Twp | Residential | $1,499,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221022788' Array 20221022788 | 4610 Cimarron Drive | | Bloomfield Twp | Residential | $1,374,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230005538' Array 20230005538 | 700 Parker Street | | Detroit | Residential | $1,200,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230032708' Array 20230032708 | 8162 Jefferson Avenue | | Detroit | Condominium | $924,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230042617' Array 20230042617 | 967 Southfield Road | | Birmingham | 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 = '20230027363' Array 20230027363 | 221 Campbell Road | | Royal Oak | Residential | $760,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230030055' Array 20230030055 | 7350 Oak Hill Road | | Brandon Twp | Residential | $729,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 = '20230038201' Array 20230038201 | 3535 Long Lake Road | | West Bloomfield Twp | Vacant Land | $699,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230037804' Array 20230037804 | 2377 Hickory Glen Drive | | Bloomfield Hills | Condominium | $699,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2220033208' Array 2220033208 | 1769 Golf Ridge Drive | | Bloomfield Twp | Residential | $679,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230024693' Array 20230024693 | 6445 Musquash Trail | | Independence Twp | Residential | $649,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230036284' Array 20230036284 | 0 W Vienna | | Clio | Vacant Land | $640,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230037989' Array 20230037989 | 933 Annie Lang Drive | | Milford Twp | Residential | $639,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040210' Array 20230040210 | 3866 Nutcracker | | Addison Twp | Residential | $600,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221019861' Array 20221019861 | 00 Mohawk Court | | Bloomfield Twp | Vacant Land | $599,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230042638' Array 20230042638 | 4180 Wentworth Drive | | Troy | Residential | $595,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040559' Array 20230040559 | 1731 Atkinson Street | | Detroit | Residential | $549,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221060026' Array 20221060026 | 8735 Lyndon Street | | Detroit | Commercial | $523,500 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230037366' Array 20230037366 | 4717 Heather | | Bloomfield Twp | Residential | $512,500 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221042750' Array 20221042750 | 1700 Cooley Lake Road | | Milford Twp | Residential | $499,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230032713' Array 20230032713 | 8162 Jefferson Avenue | | Detroit | Condominium | $499,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230038001' Array 20230038001 | 611 S Ruffner Avenue | | Birmingham | Vacant Land | $469,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230039745' Array 20230039745 | 28211 Wildwood Trail | | Farmington Hills | Residential | $447,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230032718' Array 20230032718 | 8162 Jefferson Avenue | | Detroit | Condominium | $425,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040746' Array 20230040746 | 615 Hancock Street | | Detroit | Condominium | $425,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230041102' Array 20230041102 | 29773 Trailwood Drive | | Warren | Residential | $379,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230042973' Array 20230042973 | 212 Girard Avenue | | Royal Oak | Residential | $324,990 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040047' Array 20230040047 | 2181 Mapesbury Drive | | West Bloomfield Twp | Residential | $315,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230043610' Array 20230043610 | 26825 Greenleigh Court | | Southfield | Residential | $290,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230043256' Array 20230043256 | 26875 Santa Maria | | Redford Twp | Residential | $289,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230043306' Array 20230043306 | 3303 Normandy Road | | Royal Oak | Residential | $249,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210103219' Array 2210103219 | 18699 Wakenden | | Redford Twp | Residential | $210,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230008350' Array 20230008350 | 731 Virginia Park Street | | Detroit | Residential | $205,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221033186' Array 20221033186 | 274 Oak Ridge Drive | | Pontiac | Condominium | $180,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230042099' Array 20230042099 | 00 Mack | | Addison Twp | Vacant Land | $170,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2220025760' Array 2220025760 | 28215 Nine Mile Road Road | | Farmington Hills | Vacant Land | $159,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230019818' Array 20230019818 | 0 U.S. Highway 2 | | Hudson Twp | Vacant Land | $145,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230019177' Array 20230019177 | 000 U.S. Highway 2 | | Hudson Twp | Vacant Land | $140,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230019814' Array 20230019814 | 00 U.S. Highway 2 | | Hudson Twp | Vacant Land | $135,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040348' Array 20230040348 | 3315 Donley Avenue | | Rochester Hills | Vacant Land | $99,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221063895' Array 20221063895 | 20779 Atlantic Avenue | | Warren | Residential | $99,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210066427' Array 2210066427 | VACANT "B" Cooley Lake Road | | Milford Twp | Vacant Land | $79,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210047582' Array 2210047582 | VACANT "C" Cooley Lake Road | | Milford Twp | Vacant Land | $79,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230036286' Array 20230036286 | 1 Augusta Court | | Metamora Twp | Vacant Land | $75,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230036287' Array 20230036287 | 00 Hilton Drive | | Southfield | Vacant Land | $55,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230021109' Array 20230021109 | 4666 Lake Road | | Columbiaville Vlg | Vacant Land | $32,500 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230021116' Array 20230021116 | 4632 Lake Road | | Columbiaville Vlg | Vacant Land | $32,500 | 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 = '20230039949' Array 20230039949 | 1060 Stratford Place | | Bloomfield Hills | Condominium | $6,500 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230042905' Array 20230042905 | 1825 Long Pointe Drive | | Bloomfield Twp | Residential | $4,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230033592' Array 20230033592 | 411 Old Woodward Avenue | | Birmingham | Condominium | $4,450 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230005503' Array 20230005503 | 912 Heritage Drive | | Bloomfield Twp | Condominium | $4,250 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230029576' Array 20230029576 | 430 Lewis | | Birmingham | Condominium | $3,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230005430' Array 20230005430 | 910 Heritage Drive | | Bloomfield Twp | Condominium | $3,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221059232' Array 20221059232 | 1491 Tribute Drive | | Bloomfield Twp | Condominium | $3,600 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230026939' Array 20230026939 | 411 Old Woodward Avenue | | Birmingham | Condominium | $3,600 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230022821' Array 20230022821 | 1560 Tribute Drive | | Bloomfield Twp | Condominium | $3,600 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230040341' Array 20230040341 | 411 Old Woodward Avenue | | Birmingham | Condominium | $3,450 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230035917' Array 20230035917 | 201 Southfield Road | | Birmingham | Condominium | $3,450 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221068491' Array 20221068491 | 4054 Brookside Drive | | Independence Twp | Condominium | $3,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230032946' Array 20230032946 | 990 Decker Road | | Walled Lake | Commercial | $3,000 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230027275' Array 20230027275 | 6449 Rutledge Park Drive | | West Bloomfield Twp | Residential | $2,900 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230034246' Array 20230034246 | 33242 Slocum Drive | | Farmington | Condominium | $2,890 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221068466' Array 20221068466 | 4041 Brookside Road | | Independence Twp | Condominium | $2,800 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230043555' Array 20230043555 | 32318 12 Mile Road | | Farmington Hills | Condominium | $1,799 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20221026193' Array 20221026193 | 36675 E Jefferson | | Harrison Twp | Commercial | $1,610 | SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '20230017007' Array 20230017007 | 15038 Spring Garden Street | | Detroit | Residential | $1,100 |
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. |
|
|