Dean Hamm

My Featured Listings

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
20230013150	14625 Edgewater Drive	Lyndon Twp	Residential	$4,900,000
20230049369	590A Dubuar Street	Northville	Vacant Land	$3,900,000
20230022714	6956 Cooley Lake Road	White Lake Twp	Residential	$3,199,000
20230010962	14625 A Edgewater Drive	Lyndon Twp	Residential	$2,950,000
20240008416	2009 Victoria Hill	Oakland Twp	Residential	$2,200,000
20240016052	6340/6350 Wolf Drive	Burnside Twp	Residential	$1,550,000
20240025981	2350 Crane Road	Fenton Twp	Residential	$1,325,000
20230010946	14600 Edgewater Dr Lot 3	Lyndon Twp	Vacant Land	$995,000
20230010935	14600 Edgewater Lot 4 Drive	Lyndon Twp	Vacant Land	$990,000
20240024049	51 Chateaux Du Lac	Fenton Twp	Residential	$949,900
20230096824	9485 Lakeview Drive	Dexter Twp	Vacant Land	$685,000
2210046336	551 Dubuar Street	Northville	Vacant Land	$649,500
2210046328	549 Dubuar Street	Northville	Vacant Land	$649,500
20230010951	14600 Edgewater Lot 2 Drive	Lyndon Twp	Vacant Land	$649,000
20240018278	56191 8 Mile Road	Salem Twp	Residential	$645,000
20230010945	14600 Edgewater Lot 5	Lyndon Twp	Vacant Land	$599,000
20240027832	7655 Danbury Circle	West Bloomfield Twp	Condominium	$345,000
20240021849	49965 Blackberry Trail	Novi	Condominium	$3,800

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.