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 = '20250025718'

Array

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

Array

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

Array

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

Array

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

Array

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

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 = '20250030214'

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
20251009924	18101 Sheldon Road	Northville	Residential	$7,999,900
20250025718	82 Chateaux Du Lac	Fenton Twp	Residential	$4,750,000
20250020558	590A Dubuar Street	Northville	Vacant Land	$3,900,000
20251006968	6956 Cooley Lake Road	White Lake Twp	Residential	$2,990,000
20251013994	8641 Brettonwood Shores Road	Milton Twp	Residential	$2,099,000
20250031226	14625 A Edgewater Drive	Lyndon Twp	Residential	$1,890,000
20250010444	6705 College Park	Springfield Twp	Residential	$1,499,900
20251025217	1745 Ridge Road	White Lake Twp	Residential	$1,199,900
20251031383	4329 Winterview	Brighton Twp	Residential	$789,999
20250030214	549 Dubuar Street	Northville	Vacant Land	$649,500
20250030213	551 Dubuar Street	Northville	Vacant Land	$649,500
20230096824	9485 Lakeview Drive	Dexter Twp	Vacant Land	$649,000
20251027191	44843 S Broadmoor Circle	Northville	Condominium	$629,900
20251031291	6300 Hazard Road	Fenton	Residential	$599,900
20240079810	22804 & 22806 Dequindre Road	Warren	Commercial	$475,000
20251025812	416 Beal Street	Northville	Residential	$425,000
20251030888	5274 Simpson Lake Road	West Bloomfield Twp	Condominium	$395,000
20251030999	3806 Rolling Hills Dr	Holly Twp	Residential	$389,000
20251005075	1716 Hughes Road	Genoa Twp	Vacant Land	$299,900
20250031217	1717 Hughes Road	Genoa Twp	Residential	$250,000
20251027453	18400 Kentucky Street	Detroit	Residential	$209,000
20251031281	12761 Saratoga Street	Oak Park	Residential	$150,000
20251027927	20447 Strathmoor Street	Detroit	Residential	$110,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.