Nicholas Asplund

320 Tamarack Street, Laurium Vlg Sq. Footage:   22000 Bedrooms:   24      Baths - Full:   22     Half:  6 School District:   Calumet A once-in-a-lifetime package of historic mansions! Imagine owning your own successful bed and breakfast portfolio in copper country. These homes were the… More...

Listed at:  $ 2,900,000 MLS#:   20221020413 Additional Details

24 Osmun Street, Pontiac Sq. Footage:   48259 Bedrooms:         Baths - Full:        Half:   School District:   Pontiac The Standard Vehicle company building was built in 1901 and was the most state-of-the-art carriage manufacturing plant of it’s day.  Later it became of… More...

Listed at:  $ 1,700,000 MLS#:   20221008567 Additional Details

429 N Washington Avenue, Royal Oak Sq. Footage:   3275 Bedrooms:         Baths - Full:   3     Half:  2 School District:   Royal Oak Work and Live investment property near Downtown Royal Oak. The building includes two completely updated storefronts/studios, a 2Bed/2Bath house, a large 8… More...

Listed at:  $ 999,000 MLS#:   20221026948 Additional Details

4484 Middle Channel Drive, Clay Twp Sq. Footage:   3012 Bedrooms:   4      Baths - Full:   2     Half:   School District:   Algonac Boaters Paradise!! Huge lot with 94 feet of water frontage and dock! Massive covered front patio for entertaining and a beautiful sunroom and back patio… More...

Listed at:  $ 699,000 MLS#:   20221029429 Additional Details

408 Barclay Street, Grosse Pointe Farms Sq. Footage:   2000 Bedrooms:   3      Baths - Full:   2     Half:  2 School District:   Grosse Pointe Completely updated with mid-century inspiration and open layout. Beautiful first-floor master bedroom with luxury ensuite and heated floor. Modern kitchen… More...

Listed at:  $ 529,000 MLS#:   20221023752 Additional Details

2650 John R Street, Detroit Sq. Footage:   1450 Bedrooms:   2      Baths - Full:   2     Half:   School District:   Detroit Located in the heart of Brush Park, this 3-story condo comes equipped with a private garage, atrium, and rooftop! Modern design and an open layout. Steps… More...

Listed at:  $ 4,000 MLS#:   20221029609 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array