Beautiful Custom Waterfront Home with stunning views of Lake St.Clair! On unique bay with sandy bottom,200'STEEL DOCK,10,000lb electric hoist,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
$1,650,000
26918 Koerber St, Saint Clair Shores, MI 48081
4beds
5,200sqft
Est.:
Single Family Residence
Built in 2011
0.78 Acres Lot
$1,559,200 Zestimate®
$317/sqft
$-- HOA
What's special
Atv rampLarge great roomOpen floor planPrivate low traffic streetWalk-in pantryCustom kitchenLarge bonus room
- 8 days
- on Zillow |
- 1,877 |
- 90 |
Zillow last checked: 7 hours ago
Listing updated: April 20, 2025 at 03:58am
Listed by:
Shelly Mueller 586-557-1339,
RE/MAX Advisors 586-725-1900
Source: MiRealSource,MLS#: 50171855
Originating MLS: MiRealSource
Originating MLS: MiRealSourceTravel times
Tour with a buyer’s agent
Tour with a buyer’s agent
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
Video & virtual tour
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.
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
- Foundation: Pillar/Post/Pier
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: $317/sqft
- Tax assessed value: $980,200
- Annual tax amount: $16,543
- Date on market: 4/18/2025
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA,VA Loan
- Loading
- Loading
