Jeff Smith

My Featured Listings

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

Array

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

Array

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

Array

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

Array

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

Array

Branch Listings
MLS #	Address	City	Type	Price
20251046660	2104 Roslyn Road	Grosse Pointe Woods	Residential	$169,900
20251058719	3031 Trowbridge Street	Hamtramck	Residential	$150,000
20261005448	20870 Wildwood	Harper Woods	Condominium	$47,500
20261001648	1029 Maryland Street	Grosse Pointe Park	Residential	$1,500
20261002258	1031 Maryland Street	Grosse Pointe Park	Residential	$1,500

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.