Nicholas Asplund

1731 Seminole Street, Detroit Sq. Footage:   5600 Bedrooms:   4      Baths - Full:   4     Half:  2 School District:   Detroit Entertain friends and family on this beautifully landscaped estate. Private and gated both front and back, your children and pets have plenty of room to a… More...

Listed at:  $ 999,900 MLS#:   219068180 Additional Details

85 Adelaide Street, Detroit Sq. Footage:   2700 Bedrooms:   3      Baths - Full:   2     Half:  1 School District:   Detroit In the heart of the city with everything you need in a home. Live the downtown lifestyle without compromise. This Historic Brush Park Mansion has been a a… More...

Listed at:  $ 749,999 MLS#:   219084373 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array