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

2224 Chicago Boulevard, Detroit Sq. Footage:   4362 Bedrooms:   5      Baths - Full:   3     Half:  1 School District:   Detroit State-of-the-Art Historical Home in Boston Edison! Unlike anything on the market today. 5-Star Energy Efficient. Completely Updated and Designed. New Air… More...

Listed at:  $ 559,000 MLS#:   219102327 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 = '219075426'

Array

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

Array

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

Array

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

Array

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

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

Array

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

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

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

Array

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

Array