Dean Hamm

My Featured Listings

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
20251009924	18101 Sheldon Road	Northville	Residential	$7,999,900
20251033102	82 Chateaux Du Lac	Fenton Twp	Residential	$4,499,000
20251006968	6956 Cooley Lake Road	White Lake Twp	Residential	$2,990,000
20251043847	6705 College Park	Springfield Twp	Residential	$1,399,900
20251025217	1745 Ridge Road	White Lake Twp	Residential	$1,099,900
20251031383	4329 Winterview	Brighton Twp	Residential	$789,999
20251037423	44843 S Broadmoor Circle	Northville	Condominium	$613,500
20251044107	551 Dubuar Street	Northville	Vacant Land	$599,000
20251044100	549 Dubuar Street	Northville	Vacant Land	$599,000
20251042874	6300 Hazard Road	Fenton	Residential	$579,900
20240079810	22804 & 22806 Dequindre Road	Warren	Commercial	$475,000
20251046279	11275 Coon Lake Road	Iosco Twp	Residential	$429,000
20251044924	250 Spencer Street	Ferndale	Multifamily	$310,000
20251005075	1716 Hughes Road	Genoa Twp	Vacant Land	$299,900
20251044003	21769 Ulrich Street	Clinton Twp	Residential	$260,000
20250031217	1717 Hughes Road	Genoa Twp	Residential	$250,000
20251031281	12761 Saratoga Street	Oak Park	Residential	$150,000

Search All On-Market Properties

Market Area		Property Type

Preferred City

Price Range	to

Preferences	Bedrooms Bathrooms

Search by Keyword Enter street name or zip

Or, Search Directly by MLS#:

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.