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:  $ 899,999 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,900 MLS#:   219084373 Additional Details

323 E Liberty Street, South Lyon Sq. Footage:   1621 Bedrooms:   3      Baths - Full:   2     Half:   School District:   South Lyon Fully Updated Historic Home on a double lot in downtown South Lyon! Next door to parks, biking/running paths and downtown stores and restaurants. backyard… More...

Listed at:  $ 279,900 MLS#:   219088163 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 = '219088163'

Array

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

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

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

Array

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

Array