Nicholas Asplund

1731 Seminole Street, Detroit Sq. Footage:   5600 Bedrooms:   4      Baths - Full:   4     Half:  2 School District:   Detroit Beautifully restored and updated historic colonial designed and built by C. Howard Crane. Crane designed the Fox Theater and Detroit Opera House among an… More...

Listed at:  $ 1,099,000 MLS#:   219003065 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

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

Array

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

Array