Dylan Tent

3201 Conger Street, Port Huron Sq. Footage:   5295 Bedrooms:   4      Baths - Full:   5     Half:  3 School District:   Port Huron Your first showing is online please search the property address in YouTube for a virtual tour. Architecturally stunning fully custom French manor home of… More...

Listed at:  $ 2,400,000 MLS#:   2210080543 Additional Details

47845 Milan Court, Novi Sq. Footage:   5831 Bedrooms:   4      Baths - Full:   5     Half:  2 School District:   Northville Beautiful brick/stone colonial in prestigious Bellagio Estates. This palatial 8800+ SQFT home leaves nothing to be desired. Resting on the most private in… More...

Listed at:  $ 1,950,000 MLS#:   2210078831 Additional Details

21127 Maybury Park Drive, Novi Sq. Footage:   4407 Bedrooms:   5      Baths - Full:   4     Half:  2 School District:   Northville Fabulous recently updated Maybury Park Estate Home with stunning pool, entry level master, finished lower level, and 4 car garage. This fully custom cape… More...

Listed at:  $ 1,850,000 MLS#:   2210076562 Additional Details

201 Beers Street, Port Huron Sq. Footage:   1760 Bedrooms:   2      Baths - Full:   2     Half:   School District:   Port Huron Discover new construction waterfront living on the St. Clair River at Bluewater View. This luxury model condo is complete and available for tour. The open… More...

Listed at:  $ 590,000 MLS#:   2210058152 Additional Details

00 Clintonville Road, Independence Twp Sq. Footage:    Bedrooms:         Baths - Full:        Half:   School District:   Clarkston : Great opportunity to build in Clarkston. Prime wooded, vacant land that borders a million dollar homesite. The seller, who is a luxury home architect a… More...

Listed at:  $ 90,000 MLS#:   2210015776 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array