Nicholas Asplund

My Featured Listings

2832 John R Street, Detroit
Sq. Footage:   1450
Bedrooms:   2      Baths - Full:   2     Half:
School District:   Detroit
Brand New City Modern Condo, Available Now! Price inlcudes private atrium, second-floor balcony, and rooftop! Soaring studio ceilings throughout. Includes… More...

Listed at: $ 569,000
MLS#: 2200048593
Additional Details

300 Riverfront Drive, Detroit
Sq. Footage:   1135
Bedrooms:   2      Baths - Full:   2     Half:
School District:   Detroit
Amazing views and your own private boat slip! Detroit River, Canada, Ambassador Bridge, Downtown, you can see it all from this completely updated 27th New… More...

Listed at: $ 399,000
MLS#: 2200010100
Additional Details

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

Array

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

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

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

Array

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

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

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

Array

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

Array

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

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

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
2200080909	777 Lake Shore Road	Village Of Grosse Pointe Shores	Residential	$1,595,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
2200083030	467 Lakeland Street	Grosse Pointe	Residential	$529,000
2200074395	488 University Pl	Grosse Pointe	Residential	$497,500
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	$399,000
2200080844	710 Freedom Lane	Leonard Vlg	Residential	$325,000
2200084988	482 Allard Avenue	Grosse Pointe Farms	Residential	$315,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
2200085476	473 Chalfonte Avenue	Grosse Pointe Farms	Residential	$264,900
2200032126	0 Church Lot 3 Road	Ira Twp	Vacant Land	$259,900
2200071416	474 Calvin Avenue	Grosse Pointe Farms	Residential	$254,900
2200052821	8965 Petz Road	Imlay Twp	Residential	$249,900
2200078714	19905 Shady Lane Avenue	St. Clair Shores	Residential	$175,000
2200050080	22114 Pleasant Avenue	Eastpointe	Residential	$162,500
2200070151	50628 Woodbury Drive	New Baltimore	Condominium	$149,900
2200086691	21808 Redmond Avenue	Eastpointe	Residential	$109,900
2200087089	20850 Hawthorne Street	Harper Woods	Residential	$104,900
2200050086	17805 10 Mile	Roseville	Vacant Land	$49,999
2200032107	8295 Morrow Road	Clay Twp	Vacant Land	$49,900
2200058989	0 St Clair Parcels 1 & 2 Avenue	Ira Twp	Vacant Land	$45,000
2200081828	17805 10 Mile	Roseville	Vacant Land	$39,995
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.