Agent profile image in chat bubble
Agent profile image in chat header

Jenn Smart

| SEO pages, v2 chat

Agent profile image in message

By proceeding you are providing with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from . Messages and data rates may apply. Message frequency varies. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms & Conditions and Privacy Policy.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
main property photo 47
main property photo 48
main property photo 49
main property photo 50
main property photo 51
main property photo 52
main property photo 53
main property photo 54
main property photo 55
main property photo 56
main property photo 57
main property photo 58
main property photo 59
main property photo 60
main property photo 61
main property photo 62
main property photo 63
main property photo 64
main property photo 65
main property photo 66
main property photo 67
main property photo 68
main property photo 69
main property photo 70
main property photo 71
main property photo 72
main property photo 73
main property photo 74
main property photo 75
main property photo 76
main property photo 77
main property photo 78
main property photo 79
main property photo 80
main property photo 81
main property photo 82
main property photo 83
main property photo 84
main property photo 85
main property photo 86
View All (87)
property photo 1
property photo 2
property photo 3
26918 Koerber , Saint Clair Shores, MI 48081
$1,369,000
Est. Payment: $7,134.05/mo
4 Bed
5 Bath
5200 Sqft
Status: pending | Days on site: 57
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275
By proceeding you are providing Jenn Smart with your express written consent to send you marketing and promotional communications via calls or prerecorded messages dialed by a natural person or by using an artificial or automated telephone dialing system.

By checking the box, you consent to receive marketing text messages. If checked, you consent to receiving texts including marketing and promotional communications, from Jenn Smart. Messages and data rates may apply. Message frequency varies. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms & Conditions and Privacy Policy.
Agent profile image
Jenn Smart
View agent profile
Email
Call

House Description

Ready to live on the Water? Custom Waterfront Home with stunning views of Lake St.Clair! On unique bay with sandy bottom,200'STEEL DOCK,10,000lb electric hoist,7 car heated Garage, ATV ramp and on a private low traffic street!! Open Floor Plan,19'Ceiling,Custom Kitchen,walk-in pantry,ice-maker,island & dining area overlooking the lake.Large great room,2 story stone gas fireplace,Main Floor Primary Bedrm with En-Suite and his & her closests,3 more Bedrms each with full bathrms.Office has custom tiger wood floor.Upstairs entertainment area with Wet Bar.Large bonus room.Main Floor & Upstairs Laundry.Heated Tile Flooring including all 4.5 bathrms,kitchen,dining rm,hallways & wet bar area.Upstairs mechanical room containing boiler system & upstairs furnace.Storage Galore in the 3.5 attached car garage with heated floors & the 1700sf detached heated 4 car garage/barn.Heavy duty 400' long driveway constructed of 8" & 6"concrete.Fenced in lake side yard! And SO MUCH MORE,Ask for the Detailed Custom List!*NO Flood Insurance Needed!
Show more

Highlights

Listed by Shelly Mueller , 586-557-1339 RE/MAX Advisors , 586-725-1900. MiRealSource, Inc. mls logo

Property Type

Residential
Lot/Acreage
0.78

Year Built

2011

County

Macomb

Area

St Clair Shores (50027)

 Neighborhood

Peter Bayers Sub

 School District

Lakeview Public Schools (St.Clair Shores)

Listing ID

50212927

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:4
  • ▪ Bathrooms:5
  • ▪ Full Bathrooms:4
  • ▪ 1/2 Bathrooms:1
Appliances:Air Cleaner, Bar-Refrigerator, Dishwasher, Humidifier, Microwave, Other-See Remarks, Range/Oven, Refrigerator
Air Cond:Ceiling Fan(s),Central A/C
Fireplaces:Gas Fireplace,Grt Rm Fireplace
Above Ground Sq Ft:5200
Below Ground Sq Ft:0
Other:
  • ▪ Additional:9 ft + Ceilings, Cathedral/Vaulted Ceiling, Ceramic Floors, Hardwood Floors, Security System, Sound System, Sump Pump, Walk-In Closet, Wet Bar/Bar, Window Treatment(s), Other (InteriorFeatures)
Water:Public Water

Exterior Features

Lot:Deep Lot - 150+ Ft.
Lot Dimensions:50x677
Zoning:Residential
Others:
  • ▪ Additional:Deck, Fenced Yard, Lawn Sprinkler, Patio, Porch, Street Lights
Sewer:Public Sanitary
Parking Features:Additional Garage(s),Attached Garage,Detached Garage,Electric in Garage,Gar Door Opener,Heated Garage,Side Loading Garage,Workshop,Garage,Paved Driveway
Principal Interest
$7,134
Taxes
$1,379

Home Price

$1,369,000

Loan Details

30 yrs
6.792%

Down Payment

20%
$273,800
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$7,134.05

Principal

Taxes

Principal Taxes HOA Total
Monthly $7,134.05 $1,378.58 $0.00 $8,512.63
Yearly $85,608.59 $16,543.00 $0.00 $102,151.59
Total $2,568,257.79 $496,290.00 $0.00 $3,064,547.79
Lender profile image
So-Crates Johnson
Dust, Wind, Dude
Email
Call
Visit
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Sep 2026

Average Price

All Price Ranges
N/A
Sep 2026

Average Days on Market

All Price Ranges
N/A
Sep 2026
Market insight data is pulled from the same city as the listing being viewed (Saint Clair Shores, MI).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

The information published and disseminated by MiRealSource is communicated verbatim, without change by MiRealSource, as filed with MiRealSource by its members. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified.

Copyright 2026 MiRealSource. All rights reserved. The information provided hereby constitutes proprietary information of MiRealSource, Inc. and its shareholders, affiliates and licensees and may not be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopy, recording, scanning or any information storage and retrieval system, without written permission from MiRealSource, Inc.

Provided through IDX via MiRealSource. Courtesy of MiRealSource Shareholder. Copyright MiRealSource.

IDX service by Blueroof 360

Data last updated: 2026-09-02T04:57:55.100Z

© 2026 MiRealSource, Inc.

MLS Logo - MiRealSource, Inc.