Nicholas Asplund

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:  $ 449,000 MLS#:   2200010100 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

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

Array

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

Array

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

Array