Michael Kuligowski

2703 Pointe Tremble Rd, Clay Twp Sq. Footage:   4382 Bedrooms:   6      Baths - Full:   3     Half:  2 School District:   Algonac Massive brick colonial on 1.8 acres south-facing on the river. This property has it all with a newly renovated boat house, indoor and outdoor lifts, a a a… More...

Listed at:  $ 1,748,900 MLS#:   20230026390 Additional Details

6880 Lakeshore Rd, Huron Twp Sq. Footage:   3178 Bedrooms:   5      Baths - Full:   3     Half:  1 School District:   Port Hope WOW, This one has it all! 113 Acres with waterfront access to the lake, immaculate custom Cap Cod Colonial, 2 massive outbuildings, hunting blinds, solar… More...

Listed at:  $ 1,399,900 MLS#:   20230036104 Additional Details

6880 A Lakeshore Rd, Huron Twp Sq. Footage:   3178 Bedrooms:   5      Baths - Full:   3     Half:  1 School District:   Port Hope Immaculate custom Cap Cod Colonial right off Lakeshore near Port Hope Lighthouse. Includes 2 massive outbuildings on a 6 to 8-acre lot to be split from A… More...

Listed at:  $ 989,900 MLS#:   20230036142 Additional Details

7385 S River Rd, Cottrellville Twp Sq. Footage:   3673 Bedrooms:   5      Baths - Full:   3     Half:   School District:   East China Boaters/Fisherman's paradise! This 2-acre waterfront legacy estate features a massive home with 1st-floor primary bedroom and a separate garage full and a… More...

Listed at:  $ 870,000 MLS#:   20230041484 Additional Details

22517 East 10 Mile Road, St. Clair Shores Sq. Footage:   1947 Bedrooms:   4      Baths - Full:   2     Half:  1 School District:   Lakeview Life on the Lake! Perfect for entertaining, this waterfront colonial has canal side frontage (185 ft) and direct lake frontage (64 ft) with exceptional so… More...

Listed at:  $ 795,000 MLS#:   20230003118 Additional Details

409 Main Street, Marine City Sq. Footage:   5569 Bedrooms:   7      Baths - Full:   7     Half:  1 School District:   East China Massive 3-story Victorian Mansion with a basement built in 1885 and converted into a successful bed and breakfast in 1991. This mansion could easily be as… More...

Listed at:  $ 749,900 MLS#:   20221013064 Additional Details

6215 Lakeview Drive, Huron Twp Sq. Footage:   1750 Bedrooms:   4      Baths - Full:   2     Half:  1 School District:   Port Hope Move-in cute cottage on 80 ft of sandy beach right on Lake Huron! This 1 owner property has an open kitchen and living room overlooking the lake from to 3… More...

Listed at:  $ 385,000 MLS#:   20230036180 Additional Details

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array

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

Array