Daniel Ericksen

41680 Conger Bay Drive, Harrison Twp Sq. Footage:   6000 Bedrooms:         Baths - Full:        Half:   School District:   Lanse Creuse Tremendous Opportunity. Welcoming Lake St. Clair's Largest Active Waterfront Property to the Market. Family owned for over 75 years and available for the… More...

Listed at:  $ 4,970,000 MLS#:   219090148 Additional Details

2332 Carpenter Street, Hamtramck Sq. Footage:   3000 Bedrooms:         Baths - Full:        Half:   School District:   Hamtramck Check out this INCREDIBLE income producing property! COMPLETELY updated from head to toe....This massive property includes 2 Apartment units and 1 The has… More...

Listed at:  $ 300,000 MLS#:   2200062299 Additional Details

9575 Rutland Street, Detroit Sq. Footage:   1094 Bedrooms:   3      Baths - Full:   1     Half:  1 School District:   Detroit **CURRENTLY OCCUPIED BY A PAST TENANT WHO DISCONTINUED PAYING RENT. SELLER WILL NOT PURSUE EVICTION PROCESS. INSPECTION OR INTERIOR SHOWING MAY NOT BE OF… More...

Listed at:  $ 30,000 MLS#:   219035091 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

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

Array