Doug Hardy

My Featured Listings

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
2200029456	15530 Windmill Pointe Drive	Grosse Pointe Park	Residential	$4,750,000
2200055500	460 Lakeland Street	Grosse Pointe	Residential	$995,000
2200051320	1825 S Channel Drive	Clay Twp	Residential	$899,900
2200042383	8103 County 503 Cc	Ensign Twp	Residential	$850,000
2200032119	9769 Dixie Highway	Ira Twp	Vacant Land	$750,000
2200055026	9769 Dixie Highway	Ira Twp	Commercial	$750,000
2200055037	9769 Dixie Highway	Ira Twp	Residential	$750,000
2200070057	7911 Bouvier Bay	Ira Twp	Residential	$639,900
2200077606	201 Beers Street	Port Huron	Condominium	$591,000
2200048593	2832 John R Street	Detroit	Condominium	$569,000
2200073543	85 Adelaide Street	Detroit	Condominium	$549,000
219036835	201 Beers Street	Port Huron	Condominium	$540,000
2200074395	488 University Pl	Grosse Pointe	Residential	$524,900
2200072529	200 River Place	Detroit	Condominium	$449,000
2200078243	99 Shoreham Road	Village Of Grosse Pointe Shores	Residential	$425,000
2200010100	300 Riverfront Drive	Detroit	Condominium	$424,000
2200077265	482 Allard Avenue	Grosse Pointe Farms	Residential	$340,000
2200062299	2332 Carpenter Street	Hamtramck	Commercial	$299,000
2200015301	2764 Florian Street	Hamtramck	Commercial	$295,000
2200062755	635 W Federal Highway	Roscommon Twp	Commercial	$295,000
2200069290	266 Moran Road	Grosse Pointe Farms	Residential	$275,000
2200032126	0 Church Lot 3 Road	Ira Township	Vacant Land	$259,900
2200071416	474 Calvin Avenue	Grosse Pointe Farms	Residential	$256,000
2200052821	8965 Petz Road	Imlay Twp	Residential	$249,900
2200078714	19905 Shady Lane Avenue	St. Clair Shores	Residential	$185,000
2200050080	22114 Pleasant Avenue	Eastpointe	Residential	$162,500
2200050086	17805 10 Mile	Roseville	Vacant Land	$49,999
2200032107	8295 Morrow Road	Clay Township	Vacant Land	$49,900
2200058989	0 St Clair Parcels 1 & 2 Avenue	Ira Twp	Vacant Land	$45,000
2200058977	0 St. Clair Parcel 1 Avenue	Ira Twp	Vacant Land	$35,000
219027544	2095 Pingree	Detroit	Vacant Land	$15,499
2200001642	3028 Beals Street	Detroit	Vacant Land	$15,000
2200001698	3914 Van Dyke	Detroit	Vacant Land	$15,000
2200001785	9301 E Forest	Detroit	Vacant Land	$15,000
219027564	2073 Pingree	Detroit	Vacant Land	$14,499
2200032105	0 St. Clair Parcel 2	Ira Twp	Vacant Land	$10,000
2200070499	768 Trombley Rd # 770	Grosse Pointe Park	Residential	$2,200

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.