• Price: $409,000

  • 38372 Huron Pointe Drive
    Harrison, MI 48045

  • MLS #: 213113196

Property Details

Gorgeous custom built canal front home with Lake view! Highest quality throughout. Gourmet kitchen with granite counters, island, walk-in pantry and wet bar. Stainless Steel appliances and recycled glass backsplash. Beautiful Master suite with balcony, walk-in closet, Jacuzzi tub & shower. Hunter Douglas window treatments. Steel seawall - boat slip for 40 boat. Extensive brick pavers and private backyard. Come enjoy one of BoatTowns finest homes! Details »

4 Bedrooms

3.00 Bathrooms

3028 Square Feet

Brandon Schmidt

Real Estate Agent 6501311989
  • 43599 Schoenherr Rd
    Sterling Heights, MI 48313
  • 586-262-5124
  • 586-883-4459

Biography

Raised in a real estate family in Metro Detroit, Brandon Schmidt attended Oakland University’s marketing and communications program. Beginning his career in 2000 at RE/MAX Suburban in Sterling Heights, he served as a buyer’s agent for his father, Russ. Brandon rapidly increased the duos visibility by partnering in the creation of their home renovation company, Gemini Opportunities. Brandon carries on his father’s legacy by being one of the top agents in Southeastern Michigan. After his father’s retirement, Brandon’s brother, Brett, joined which created the next generation focusing on offering clients a collaborative and personalized service they deserve.

Brandon now leads a full time team of professionals and has been recognized by HOUR Detroit magazine as a “Real Estate All Star” and has been inducted into the RE/MAX International Hall of Fame, a designation reserved for elite agents.

Brandon serves territories from his hometown of Macomb County through Oakland County, where he currently resides as well as Northern Wayne, Southern Lapeer & Southern St Clair Counties.. Brandon is an enthusiastic member of the community and enjoys, golfing, the outdoors and showing clients the best that Metro Detroit has to offer!

SimpleXMLElement Object
(
    [0] => disclaimer
)
SimpleXMLElement Object
(
    [0] => contactDisclaimer
)
SimpleXMLElement Object
(
    [0] => Terms acceptance requirement notification
)
SimpleXMLElement Object
(
    [0] => canadaContactDisclaimerNotice
)
SimpleXMLElement Object
(
    [0] => Canadian disclaimer checkbox label
)
SimpleXMLElement Object
(
    [0] => canadaDisclaimerLabel
)
SimpleXMLElement Object
(
    [0] => Canadian disclaimer
)
SimpleXMLElement Object
(
    [0] => canadaContactDisclaimer
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => prevPage_previous
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => prevPage_page
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => nextPage_previous
)
SimpleXMLElement Object
(
    [0] => The prev/next page links on each page
)
SimpleXMLElement Object
(
    [0] => nextPage_page
)
SimpleXMLElement Object
(
    [0] => The title for the agent listings page
)
SimpleXMLElement Object
(
    [0] => agentlistings_h1
)
SimpleXMLElement Object
(
    [0] => The main intro text for the agent listings page
)
SimpleXMLElement Object
(
    [0] => agentlistings_headerText
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_addressColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_sizeColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_priceColumn
)
SimpleXMLElement Object
(
    [0] => The table columns
)
SimpleXMLElement Object
(
    [0] => agentlistings_photoColumn
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_addressLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_sizeLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_bedsLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_priceLabel
)
SimpleXMLElement Object
(
    [0] => The details label on the right page
)
SimpleXMLElement Object
(
    [0] => agentlistings_openTourButton
)
SimpleXMLElement Object
(
    [0] => The title for the Property Details page
)
SimpleXMLElement Object
(
    [0] => propertydetails
)
SimpleXMLElement Object
(
    [0] => See More Listings button text
)
SimpleXMLElement Object
(
    [0] => seeMoreListings
)

Browse through the many properties that I am currently representing. Click the property to view the virtual tour of each listing.

Photo Address Size Price
See More Listings

Property Details

Address:
Size: Size
Bedrooms:
Asking Price:

View this listing

Find out your monthly payments for this listing

Mortgage Calculator

How Much Can I Borrow?

How Much Can I Afford?

To email this brochure, please fill out the appropriate fields below. When done, simply click the "SEND" button.

Email Brochure Form



By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.

Select a school from the list below to view its contact information and statistics.

Type of school

Donald J Yacks Elem School (Grades: PK - 5)
Emma V Lobbestael Elem School (Grades: PK - 5)
LAnse Creuse High School (Grades: 9 - 12)
LAnse Creuse Middle School Central (Grades: 6 - 8)
LAnse Creuse Middle School South (Grades: 6 - 8)
Marie C Graham Elem School (Grades: PK - 5)
South River Elementary School (Grades: KG - 5)
Clinton Valley Elementary School (Grades: PK - 5)
LAnse CreuseMount Clemens Center for Lifelong Learning (Grades: 9 - 12)
Macomb County Juvenile Justice Center School (Grades: KG - 12)
ML King Academy (Grades: PK - 12)
Mount Clemens High School (Grades: 9 - 12)
Mount Clemens Middle School (Grades: 6 - 8)
Mt Clemens Montessori Academy (Grades: KG - 5)
Prevail Academy (Grades: KG - 8)
Seminole Academy (Grades: PK - 5)
Algonquin Middle School (Grades: 6 - 8)
Auxiliary Preschool and Services Center (Grades: UG)
Frederick V Pankow Center (Grades: 9 - 12)
Neil E Reid High School (Grades: 9 - 12)
Ottawa Elementary School (Grades: PK - 5)
Information

Institution Name:
Donald J Yacks Elem School

Phone: (586)493-5630
Type: Regular school
NCES District ID: 2621870

Mailing Address:
34700 Union Lake RdHarrison Township, MI 48045

District: L'anse Creuse Public Schools
County:
NCES School ID: 262187005921

Student/Teacher Ratio
Characteristics
Locale : Suburban, Large (21)
Charter : no
Total Teachers (FTE) : 20.46
Total Students : 310
Student/Teacher Ratio : 15.2
Enrollment by Grade

Students: PK - 05

Grade Students
KG70
1st36
2nd59
3rd43
4th49
5th53

School Data Provided By NCES
This information is provided by a third party provider and may or may not reflect all schools in this area.
  • 90-100
  • 70-89
  • 50-69
  • 25-49
  • 0-24
  • Rider's Paradise World-class public transportation
  • Excellent Transit Transit is convenient for most trips
  • Good Transit Many nearby transportation options
  • Some Transit A few nearby transportation options
  • Minimal Transit It is possible to get on an bus
  • 90-100
  • 70-89
  • 50-69
  • 25-49
  • 0-24
  • Walker's Paradise Daily errands do not require a car
  • Very Walkable Most errands can be accomplished by foot
  • Good Transit Some errands can be accomplished by foot
  • Car-Dependent Most errands require car
  • Car-Dependent Almost all errands require car
  • 90-100
  • 70-89
  • 50-69
  • 0-49
  • Biker's Paradise Daily errands can be accomplished on a bike
  • Very Bikeable Biking is convenient for most trips
  • Bikeable Some bike infrastructure
  • Somewhat Bikeable Minimal bike infrastructure

Want to visit this property? Use this information to plan your trip. Check out local weather data.

High

:

Low

:

Precipitation

:

Humidity

:

Wind

:

Pressure

:

Harrison, MI 48045

There are two ways to get directions to this property. You can print the directions from your computer or have the address texted to your phone which can then be opened in Google maps.

Please enter Cell Numbers with only 10 digits (ex. 5555555555)

By registering, you agree to our terms of use and that real estate professionals and lenders may call/text you about your inquiry, which may involve the use of automated means and prerecorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply.
38372 Huron Pointe Drive Harrison, MI 48045