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!
For sale
Price cut: $60K (7/10)
$1,369,000
26918 Koerber St, Saint Clair Shores, MI 48081
4beds
5,200sqft
:
Get pre-qualified$9,789/mo
Single Family Residence
Built in 2011
0.78 Acres Lot
$1,314,200 Zestimate®
$263/sqft
$-- HOA
What's special
Atv rampLarge great roomOpen floor planPrivate low traffic streetWalk-in pantryCustom kitchenLarge bonus room
- 46 days |
- 1,199 |
- 39 |
Zillow last checked:
Listing updated:
Listed by:
Shelly Mueller 586-557-1339,
RE/MAX Advisors 586-725-1900
Source: MiRealSource,MLS#: 50212927
Originating MLS: MiRealSource
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 5
- Full bathrooms: 4
- 1/2 bathrooms: 1
Rooms
- Room types: Den/Study/Lib, Entry, Bedroom, Laundry, Master Bedroom, Great Room, Loft, Utility/Laundry Room, Office, Bonus Room, First Flr Lavatory, Bathroom, Master Bathroom, Other-See Remarks, Second Flr Full Bathroom, Breakfast Nook/Room
Primary bedroom
- Level: First
Bedroom 1
- Features: Laminate
- Level: Entry
- Area: 289
- Dimensions: 17 x 17
Bedroom 2
- Features: Carpet
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 3
- Features: Carpet
- Level: Second
- Area: 180
- Dimensions: 15 x 12
Bedroom 4
- Features: Carpet
- Level: Second
- Area: 169
- Dimensions: 13 x 13
Bathroom 1
- Features: Ceramic
- Level: Entry
- Area: 112
- Dimensions: 14 x 8
Bathroom 2
- Features: Ceramic
- Level: Second
- Area: 40
- Dimensions: 8 x 5
Bathroom 3
- Features: Ceramic
- Level: Second
- Area: 40
- Dimensions: 8 x 5
Bathroom 4
- Features: Ceramic
- Level: Second
- Area: 88
- Dimensions: 11 x 8
Dining room
- Features: Ceramic
- Level: Entry
- Area: 168
- Dimensions: 14 x 12
Great room
- Level: Entry
- Area: 494
- Dimensions: 19 x 26
Kitchen
- Features: Ceramic
- Level: Entry
- Area: 204
- Dimensions: 17 x 12
Office
- Level: Entry
- Area: 180
- Dimensions: 15 x 12
Heating
- Boiler, Forced Air, Natural Gas, Other
Cooling
- Ceiling Fan(s), Central Air
Appliances
- Included: Bar Fridge, Dishwasher, Humidifier, Microwave, Other, Range/Oven, Refrigerator, Electric Water Heater
- Laundry: First Floor Laundry, Second Floor Laundry, Laundry Room, Entry
Features
- High Ceilings, Cathedral/Vaulted Ceiling, Sound System, Sump Pump, Walk-In Closet(s), Bar, Other, Pantry
- Flooring: Ceramic Tile, Hardwood, Laminate, Carpet, Wood
- Windows: Window Treatments
- Basement: Crawl Space
- Number of fireplaces: 1
- Fireplace features: Gas, Great Room
Interior area
- Total structure area: 5,200
- Total interior livable area: 5,200 sqft
- Finished area above ground: 5,200
- Finished area below ground: 0
Property
Parking
- Total spaces: 7
- Parking features: Garage, Driveway, Attached, Detached, Electric in Garage, Garage Door Opener, Heated Garage, Garage Faces Side, Workshop in Garage
- Attached garage spaces: 7
Accessibility
- Accessibility features: Main Floor Laundry
Features
- Levels: Two
- Stories: 2
- Patio & porch: Deck, Patio, Porch
- Exterior features: Lawn Sprinkler, Street Lights
- Fencing: Fenced
- Has view: Yes
- View description: Water, Lake
- Has water view: Yes
- Water view: Water,Lake
- Waterfront features: All Sports Lake, Boat Facility, Dock/Pier Facility, Lake Front, Seawall, Waterfront, Sandy Bottom
- Body of water: Lake St. Clair
- Frontage length: 50
Lot
- Size: 0.78 Acres
- Dimensions: 50 x 677
- Features: Deep Lot - 150+ Ft., Dead End
Details
- Additional structures: Barn(s)
- Parcel number: 091423303017
- Zoning description: Residential
- Special conditions: Private
- Other equipment: Air Cleaner
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Contemporary
- Property subtype: Single Family Residence
Materials
- Brick, Stone, Cement Siding
Condition
- Year built: 2011
Utilities & green energy
- Sewer: Public Sanitary
- Water: Public
Community & HOA
Community
- Security: Security System
- Subdivision: Peter Bayers Sub
HOA
- Has HOA: No
Location
- Region: Saint Clair Shores
Financial & listing details
- Price per square foot: $263/sqft
- Tax assessed value: $945,200
- Annual tax amount: $16,543
- Date on market: 6/26/2026
- Cumulative days on market: 481 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,VA Loan
Estimated market value
Zestimate®
$1,314,200
Estimated sales range
$1.25M - $1.38M
Rent Zestimate®
$4,444/mo
Price history
| Date | Event | Price |
|---|---|---|
| 7/10/2026 | Price change | $1,369,000-4.2%$263/sqft |
Source: | ||
| 6/26/2026 | Listed for sale | $1,429,000-1.4%$275/sqft |
Source: | ||
| 6/26/2026 | Listing removed | $1,449,000$279/sqft |
Source: | ||
| 5/18/2026 | Price change | $1,449,000-3.3%$279/sqft |
Source: | ||
| 11/7/2025 | Price change | $1,499,000-3.2%$288/sqft |
Source: | ||
| 6/6/2025 | Price change | $1,549,000-3.2%$298/sqft |
Source: | ||
| 5/1/2025 | Price change | $1,599,900-3%$308/sqft |
Source: | ||
| 4/18/2025 | Listed for sale | $1,650,000+450%$317/sqft |
Source: | ||
| 1/15/2004 | Sold | $300,000+14.3%$58/sqft |
Source: Public Record Report a problem | ||
| 7/11/2002 | Sold | $262,500$50/sqft |
Source: Public Record Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $16,974 +2.6% | $472,600 -3.6% |
| 2024 | $16,543 +5.5% | $490,100 +6% |
| 2023 | $15,685 +1.9% | $462,400 +6.5% |
| 2022 | $15,396 -0.6% | $434,200 +4% |
| 2021 | $15,486 | $417,600 +14% |
| 2020 | $15,486 +4.4% | $366,300 -6.8% |
| 2019 | $14,835 -46.4% | $393,000 +9.4% |
| 2018 | $27,679 +117.8% | $359,100 +7.4% |
| 2017 | $12,710 | $334,400 |
| 2016 | $12,710 | $334,400 +6.6% |
| 2015 | $12,710 | $313,800 +10.7% |
| 2012 | -- | $283,400 +207.7% |
| 2011 | -- | $92,100 |
Find assessor info on the county website
Monthly payment
Est. payment
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.Climate risks
Neighborhood: 48081
Nearby schools
GreatSchools rating
- 8/10Ardmore Elementary SchoolGrades: K-5Distance: 0.5 mi
- 7/10Jefferson Middle SchoolGrades: 6-8Distance: 1.4 mi
- 7/10Lakeview High SchoolGrades: 9-12Distance: 1.1 mi
Schools provided by the listing agent
- District: Lakeview Public Schools (St.Clair Shores)
Source: MiRealSource. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- $460,3003 bd1 ba-- sqft26910 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $561,3002 bd2 ba1.6k sqft26920 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $497,3003 bd1 ba1.3k sqft26908 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $298,6002 bd1 ba1.4k sqft26922 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $930,0003 bd2 ba2.7k sqft26926 Koerber St, Saint Clair Shores, MI 48081Sold
Save - $734,6003 bd3 ba2.8k sqft26830 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $794,7003 bd2 ba1.7k sqft26906 Koerber St, Saint Clair Shores, MI 48081Off Market
Save - $597,6003 bd2 ba1.9k sqft26824 Koerber St, Saint Clair Shores, MI 48081Off Market
Save
A local agent can set up tours, give advice and negotiate with sellers.





