John Jay

My Featured Listings

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081018'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200099925'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004487'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210002058'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200020490'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001655'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200078161'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200009277'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200087217'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084214'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001262'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200095955'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200085571'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210008958'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200091274'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001506'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200069658'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210008968'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001247'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200076684'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210008376'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200053085'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004258'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004263'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200099552'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200093645'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086900'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017075'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017114'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210010292'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200096674'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017743'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200021587'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200061463'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210010926'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000666'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200061962'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210010911'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009363'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200072759'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200051713'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011720'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200046035'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001097'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '219054322'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009384'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200064058'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011790'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084197'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200092336'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011896'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200060287'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005542'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086053'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081929'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011073'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200030709'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200089802'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011929'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009895'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200029389'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200094751'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200098827'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200093555'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011485'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009255'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086928'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200079913'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200017145'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210010407'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '219020746'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200092547'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200092555'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200064135'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200037365'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210001252'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200096753'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200086920'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200047170'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210005659'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210006215'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200067182'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200029376'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200084079'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200067356'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200071785'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088951'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200069552'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088954'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088958'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088953'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088950'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200010174'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088957'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088956'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200088952'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210008970'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '218065537'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009253'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210011900'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210006858'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210009656'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200053457'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210003206'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200097319'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200081921'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210000416'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210010356'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2200055589'

Array

SELECT property_type FROM `mi_realcomp_properties` WHERE property_id = '2210004898'

Array

Branch Listings
MLS #	Address	City	Type	Price
2200081018	220 Lake Park Drive	Birmingham	Residential	$6,199,000
2200099925	1333 Fairfax Street	Birmingham	Residential	$3,850,000
2210004487	1525 Chesterfield Avenue	Birmingham	Residential	$3,650,000
2210002058	00 Mccandlish Road	Grand Blanc Twp	Vacant Land	$3,400,000
2200020490	2915 Turtle Pond Court	Bloomfield Twp	Residential	$3,250,000
2210001655	00 S Saginaw Road	Grand Blanc Twp	Vacant Land	$3,000,000
2200078161	6956 Cooley Lake Road	White Lake Twp	Residential	$2,995,000
2200009277	1586 Redding Road	Birmingham	Residential	$2,895,000
2200087217	3201 Conger Street	Port Huron	Residential	$2,750,000
2200084214	2681 Turtle Shores Drive	Bloomfield Twp	Residential	$2,466,888
2210001262	920 Lake Angelus Shrs Drive	Lake Angelus	Residential	$2,199,999
2200095955	625 Brown Street	Birmingham	Condominium	$2,199,000
2200085571	6340/6350 Wolf Road	Brown City	Residential	$1,995,000
2210008958	9000 Hidden Lake Drive	Howell	Residential	$1,850,000
2200091274	733 Wimbleton Drive	Birmingham	Residential	$1,749,900
2210001506	4390 Rayco Drive	Metamora Twp	Residential	$1,699,900
2200069658	3521 Bluff Road	Port Austin Twp	Residential	$1,699,000
2210008968	745 Wallace Street	Birmingham	Residential	$1,699,000
2210001247	2020 Lake Angelus Shores	Lake Angelus	Residential	$1,680,000
2200076684	3990 Shallow Brook Drive	Bloomfield Twp	Residential	$1,650,000
2210008376	909 Southfield Road	Birmingham	Residential	$1,649,000
2200053085	4029 Old Us Highway 27	Gaylord	Commercial	$1,590,000
2210004258	544 Wallace Street	Birmingham	Residential	$1,579,999
2210004263	955 Larchlea Drive	Birmingham	Residential	$1,499,900
2200099552	5941 E Miller Way	Bloomfield Twp	Residential	$1,299,000
2200093645	4880 Old Orchard Trail	Orchard Lake Village	Vacant Land	$1,200,000
2200086900	111 Willits Street	Birmingham	Condominium	$1,199,999
2200017075	177 Vester Street	Ferndale	Commercial	$1,175,000
2200017114	22736 Woodward Avenue	Ferndale	Commercial	$1,150,000
2210010292	411 S Old Woodward Ave Unit 628	Birmingham	Condominium	$1,149,000
2200096674	600 W Brown Street	Birmingham	Condominium	$1,124,900
2200017743	000 Devonwood	Troy	Residential	$1,099,000
2200021587	20201 Livernois	Detroit	Commercial	$1,000,000
2200061463	1720 Braidwood Road	Riley Twp	Residential	$998,500
2210010926	469 Goodhue Road	Bloomfield Hills	Residential	$995,000
2210000666	3423 Chickering Lane	Bloomfield Twp	Residential	$990,000
2200061962	55 Orchard Lane	Bloomfield Hills	Vacant Land	$985,000
2210010911	1606 Humphrey Avenue	Birmingham	Residential	$949,900
2210009363	2021 Hazel Street	Birmingham	Condominium	$925,000
2200072759	000 Watkins	Birmingham	Vacant Land	$899,000
2200051713	100 Linda Lane	Bloomfield Hills	Residential	$849,000
2210011720	1323 Bennaville Avenue	Birmingham	Residential	$745,000
2200046035	2681 Turtle Shores Drive	Bloomfield Twp	Vacant Land	$739,000
2210001097	1140 Lone Pine Woods Drive	Bloomfield Twp	Condominium	$724,900
219054322	6420 Cowell Road	Hamburg Twp	Residential	$699,999
2210009384	683 Kimberley Road	Birmingham	Residential	$699,900
2200064058	4455 Charing Cross Road	Bloomfield Twp	Residential	$699,000
2210011790	535 Wallace Street	Birmingham	Residential	$697,000
2200084197	14890-900 Dale Street	Detroit	Commercial	$629,000
2200092336	7477 Groveland Road	Holly Twp	Residential	$624,900
2210011896	3879 Carriage Road	Bloomfield Twp	Residential	$599,900
2200060287	8911 Clubwood Drive	Walled Lake	Residential	$599,000
2210005542	1021 Washington Avenue	Royal Oak	Condominium	$579,000
2200086053	41 W 11 Mile Road	Madison Heights	Commercial	$550,000
2200081929	646 W Eleven Mile Road	Royal Oak	Condominium	$549,000
2210011073	1383 E 14 Mile Road	Birmingham	Residential	$525,000
2200030709	291 Erskine	Detroit	Vacant Land	$499,900
2200089802	314 W Hickory Grove Road	Bloomfield Twp	Vacant Land	$499,000
2210011929	932 W 11 Mile Road	Royal Oak	Condominium	$489,000
2210009895	600 W Brown Street	Birmingham	Condominium	$449,900
2200029389	32820 Wing Lake Road	Franklin Vlg	Vacant Land	$399,000
2200094751	100 N Center Street	Royal Oak	Condominium	$360,000
2200098827	0 Romeo Plank Road	Armada Twp	Vacant Land	$350,000
2200093555	1409 Anne Drive	Royal Oak	Condominium	$320,000
2210011485	220 N Altadena Avenue	Royal Oak	Residential	$311,000
2210009255	1436 Predmore Road	Oakland Twp	Vacant Land	$295,000
2200086928	975 Baldwin Avenue	Pontiac	Commercial	$294,570
2200079913	37,39,39.5 N.Roslyn Avenue	Waterford Twp	Residential	$284,900
2200017145	22730 Woodward Avenue	Ferndale	Commercial	$275,000
2210010407	42843 Richmond Drive	Sterling Heights	Condominium	$265,000
219020746	000 Devonwood	Troy	Vacant Land	$219,000
2200092547	0000 Elizabeth Lake Road	Waterford Twp	Residential	$199,900
2200092555	5570 Elizabeth Lake Road	Waterford Twp	Commercial	$199,900
2200064135	3110 Devon Brook Drive	Bloomfield Twp	Vacant Land	$199,000
2200037365	4005 Elmhurst Road	Waterford Twp	Residential	$189,900
2210001252	5354 Bristol Parke Circle	Independence Twp	Vacant Land	$129,900
2200096753	VACANT "C" Cooley Lake Road	Milford Twp	Vacant Land	$124,900
2200086920	981 Baldwin Ave Avenue	Pontiac	Commercial	$108,936
2200047170	14641 Tireman Ave Avenue	Dearborn	Vacant Land	$98,000
2210005659	28 S Anderson Avenue	Pontiac	Residential	$84,900
2210006215	473 Orchard Lake Road	Pontiac	Commercial	$79,900
2200067182	0000 Bluff Road	Port Austin Twp	Vacant Land	$79,000
2200029376	0000 Oregon	Waterford Twp	Vacant Land	$69,900
2200084079	15312 Dixie Hwy	Groveland Twp	Vacant Land	$64,900
2200067356	F1 Kathy Lynn	Brandon Twp	Vacant Land	$49,900
2200071785	LOT E Kathy Lynn	Brandon Twp	Vacant Land	$29,900
2200088951	1745 E George Avenue	Hazel Park	Vacant Land	$27,950
2200069552	F 2 Kathy Lynn	Brandon Twp	Vacant Land	$24,900
2200088954	1743 E Milton Avenue	Hazel Park	Vacant Land	$24,900
2200088958	160 W Hayes Avenue	Hazel Park	Vacant Land	$24,900
2200088953	582 E Mahan Avenue	Hazel Park	Vacant Land	$22,500
2200088950	110 E Coy Avenue	Hazel Park	Vacant Land	$21,950
2200010174	VAC Massena Drive	Commerce Twp	Vacant Land	$19,900
2200088957	333 W Hayes Avenue	Hazel Park	Vacant Land	$17,900
2200088956	445 W George Avenue	Hazel Park	Vacant Land	$14,900
2200088952	998 E Hayes Avenue	Hazel Park	Vacant Land	$12,900
2210008970	745 Wallace Street	Birmingham	Residential	$9,750
218065537	00 Sparrow Hawk	Bellaire Vlg	Vacant Land	$5,000
2210009253	2021 Hazel Street	Birmingham	Condominium	$5,000
2210011900	1586 Redding Road	Birmingham	Residential	$4,250
2210006858	932 W 11 Mile Road	Royal Oak	Condominium	$4,200
2210009656	22309 Acadia Way	Farmington Hills	Residential	$3,500
2200053457	626 W Eleven Road	Royal Oak	Condominium	$3,200
2210003206	203 Curry Avenue	Royal Oak	Residential	$3,200
2200097319	542 Bloomfield Court	Birmingham	Condominium	$2,600
2200081921	644 W Eleven Mile Road	Royal Oak	Condominium	$2,300
2210000416	411 S Old Woodward Avenue	Birmingham	Condominium	$1,850
2210010356	475 S Adams Rd Apt 9	Birmingham	Condominium	$1,500
2200055589	8322A Cooley Lake Road	Commerce Twp	Commercial	$1,400
2210004898	1584 Silman	Ferndale	Residential	$1,400

Search All On-Market Properties

Market Area	Realcomp	Property Type

Preferred City

Price Range	to

Preferences	Bedrooms Bathrooms

Search by Keyword Enter street name or zip

Realcomp

Or, Search Directly by MLS#: Realcomp

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.

Sotheby's International Realty® is a registered trademark licensed to Sotheby's International Realty Affiliates, Inc.
Each Office is Independently Owned and Operated. Equal Housing Opportunity.

Listings with the IDX logo are provided through Realcomp exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. Contact agent for more information and most current market data. Copyright 2012 Realcomp.

© 2012 Signature Sotheby's International Realty LLC, Inc. All rights reserved worldwide.