24

Days on homefello

1996

Year Built

$269

Price Per Sqft

Loading...

Price vs Median

Could you see yourself in this home?

Patio

Central Air

Waterfront

Garage

Full Home Description

Imagine a lifestyle where the weekend boat parade passes right by your backyard and a 1 min cruise puts you directly onto the open waters of Lake St. Clair. This extraordinary 2,937 sqft. Brick Colonial, sits on 185 feet of pristine deep-water canal frontage, blends luxury living w/ high-performance engineering. Step through the new stained-glass entry door into the grand foyer, your eyes are drawn past the catwalk to a stunning great room where a 20ft natural Virginia stone fireplace competes for attention with floor-to-ceiling windows framing panoramic water views. The chef's kitchen features a Viking 36†gas stovetop, Sub-Zero refrigeration, and granite countertops. The home theater is complete with a 100†screen and acoustic treatments, offering the ultimate indoor retreat. Beyond the aesthetic, this home is built to a superior standard. Constructed with 6" exterior walls for 57% more insulation space and upgraded w/ R-49 attic insulation, providing year-round comfort. The primary en-suite serves as a private sanctuary with custom California Closets and a new Trex balcony where you can watch the sunrise. Even the heated garage is high-tech, featuring an electrically operated 1,000lb lift to store a motorcycle or recreational toys. The outdoor amenities are equally impressive. A massive 14'x40' boat well houses an 18k lb hoist, complemented by a jet ski/kayak lift and a dedicated boat shed with power. With a new roof, a full-house Generac generator, and durable James Hardie siding, the major updates have already been completed. Whether entertaining on the refreshed paver patio or enjoying weekend boat rides, this home offers a rare blend of sophisticated style and “over-built†peace of mind. Now close your eyes and imagine walking to town for a scoop of ice cream, summers spent boating, and winters spent ice fishing or skating on your very own canal ice rink. When you buy a house, you're also buying the community and neighborhood, and this home truly has it all.

Listed by Chantel T Hines · Keller Williams Lakeside · (586) 532-0500

Inside the Home
  • 3 bedrooms

  • 2 full bathrooms

  • 1 half bathroom

  • Includes gas water heater

  • 2,937 sq ft of living space

Comfort & Climate
  • Forced Air, Heat Pump, Natural Gas

  • Ceiling Fan(s), Central Air, Heat Pump

  • Fireplace — gas

Outdoor Features
  • Patio, Porch

  • Balcony

  • Waterfront access

Parking & Storage
  • 2.5-car attached, paved, garage door opener, heated garage, garage faces side

Property Overview
  • Lot size: 0.2000 acres

  • Built in 1996

  • 2 stories

  • Colonial architecture

  • Single Family

  • Annual taxes: $7,395

Utilities
  • Water: Public

Construction
  • Brick

Community
  • Subdivision: Schmid Haven

  • Macomb County

Estimate Your Mortgage Payment
Offer Purchase Price

$

List Price Offer
Down Payment

$

%

No PMI
Loan Type
Loan Term
Zip Code
Interest Rate

%

Default area avg

Property Tax (%)
Home Insurance ($/yr)
HOA ($/mo)

Monthly Mortgage
$4,718
/mo

Principal & Interest:

$3,829

Taxes:

$789

Insurance:

$100

HOA Fees:

$0

Loan Types You May Qualify For
FHA Loans
  • 3.5% down payment
  • Lower credit scores

VA Loans (Veterans)
  • $0 down payment
  • No PMI
  • Often lower rates

Conventional Loans
  • Good for great credit
  • May not require PMI
First-Time Buyer Programs
  • Low down payment
  • Reduced rates
Down Payment Assistance
  • Forgivable loans & grants
  • DPA programs

Rating

School Name

Distance

Loading school ratings...

Data provided by GreatSchools.org © 2026. All rights reserved.GreatSchools Logo

Loading crime statistics...

Crime data provided by Zyla Labs. Comparison vs surrounding zip codes.

Reported Incidents (Last 5 Years)

From: 35809 Schmid Drive, New Baltimore 48047

To:

--

--

--

--

Show nearby attractionspowered byYelp
  • No places found nearby.

Local Real Estate Expert

Licensed Agent · homefello

Helping buyers find their perfect home

Connect with an Agent
By submitting, you agree to homefello's terms and privacy policy.

IDX Logo

IDX provided courtesy of Realcomp II Ltd. via GoodHome Realty and MLS. Copyright 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

The data relating to real estate properties on this website was last updated as recently as .

Listing Information presented by local MLS brokerage: GoodHome Realty and MLS, Inc., REALTOR® - Quinton Lemond - (248) 928-4992.