NOT LISTED FOR SALE

542 E Sugar Bay Ln Cedar, MI 49621

Estimated Value: $870,000 - $1,053,000

3 Beds
2 Baths
1,400 Sq Ft
$676/Sq Ft Est. Value

Sale Details

Date Sold: June 29, 2023

Last sale price $778,750 $556 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $5,977 / mo

3 Days on Market

Highlights

  • Private Waterfront
  • Deeded Waterfront Access Rights
  • Deck
  • Leland Public School Rated A-
  • Sandy Beach
  • Wooded Lot

About This Home

As of June 2023

Enjoy lake living in this three-bedroom, two-bathroom home tucked into a beautiful cove on the north side of Lime Lake. This home provides open concept living and dining areas with vaulted ceilings and island kitchen. Private master suite with screened-in porch overlooking the lake. The outdoor lakeside deck is perfect for al fresco dining and sunset happy hours. A walking path through the tree-lined yard leads to the 125 ft of private beach and firepit. Also includes an oversized two-car attached garage and asphalt driveway. Additional storage under the deck with pea-stone gravel. House is being sold turn-key with most furnishings, linens, and kitchenware included in the sale.

Last Agent to Sell the Property

Tim Schaub

Schaub Team Premier Realty Listed on: 05/26/2023

Last Buyer's Agent

Roger Schaub

Schaub Team Premier Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1993

Lot Details

  • 36,155 Sq Ft Lot
  • Lot Dimensions are 125x385
  • Private Waterfront
  • 125 Feet of Waterfront
  • Sandy Beach
  • Level Lot
  • Wooded Lot
  • The community has rules related to zoning restrictions

HOA Fees

  • $17 Monthly HOA Fees

Home Design

  • Ranch Style House
  • Block Foundation
  • Frame Construction
  • Asphalt Roof
  • Wood Siding

Interior Spaces

  • 1,400 Sq Ft Home
  • Crawl Space

Kitchen

  • Dishwasher
  • Kitchen Island

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Laundry

  • Dryer
  • Washer

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Private Driveway

Outdoor Features

  • Deeded Waterfront Access Rights
  • Property is near a lake
  • Deck

Schools

  • Leland Public Elementary And Middle School
  • Leland Public High School

Utilities

  • Forced Air Heating and Cooling System
  • Well

Community Details

Overview

  • Lime Lake Shores Community

Recreation

  • Water Sports

Home Details

Home Type

Single Family

Year Built

Built in 1993

Lot Details

0.83 Acres

HOA Fees

$17 per month

Listing Details

  • Class: Single Family
  • Type: Residential
  • Style: Ranch, 1 Story
  • Estimated Year Built: 1993
  • Construction: Frame
  • Private Shared: Private
  • Special Features: None
  • Property Sub Type: Detached
  • Stories: 1
  • Year Built: 1993

Interior Features

  • Appliances Equipment: Refrigerator, Dishwasher, Washer, Dryer
  • Interior Amenities: Island Kitchen
  • Bedrooms: 3
  • Bedroom 1: Dimensions: 13.00x21.00, On Level: Main Floor, Flooring: Carpet
  • Bedroom 2: Dimensions: 9.00x10.00, On Level: Main Floor, Flooring: Carpet
  • Bedroom 3: Dimensions: 9.00x11.00, On Level: Main Floor, Flooring: Carpet
  • Total Bathrooms: 2
  • Primary Bathroom: Private
  • Number of Main Level Bathrooms: 3
  • Full Bathrooms: 2
  • Main Floor Primary: Yes
  • Dining Room: Dimensions: 10.00x12.00, On Level: Main Floor, Flooring: Vinyl
  • Kitchen: Dimensions: 9.00x14.00, On Level: Main Floor, Flooring: Vinyl
  • Living Room: Dimensions: 18.00x12.00, On Level: Main Floor, Flooring: Carpet
  • Range: R 29W
  • Total Finished Sf Apx: 1400

Exterior Features

  • Body Of Water: Lime Lake
  • Exterior Features: Deck
  • Exterior Finish: Wood
  • Foundation: Crawl Space, Block
  • Number Of Acres: 0.83
  • Road: Blacktop, Public Maintained
  • Roof: Asphalt
  • Water Features: Priv Frontage (Wtr Side), Inland Lake, All Sports, Sandy Bottom, Public Lake
  • Waterfront Frontage: 125

Garage/Parking

  • Driveway: Blacktop, Concrete, Private
  • Garage Capacity: 2
  • Primary Garage: Attached, Concrete Floors, Door Opener

Utilities

  • Heating Cooling Types: Forced Air
  • Laundry: On Level: Main Floor, Flooring: Vinyl
  • Sewer: Private Septic
  • Tv Service Internet Avail: Unknown
  • Water: Private Well

Condo/Co-op/Association

  • Annual Association Fees: 200
  • Association Fees: Annual

Association/Amenities

  • Development Name: Lime Lake Shores

Lot Info

  • Deeded Waterfront: Yes
  • Land Features: Evergreens, Wooded-Hardwoods, Level, Wooded
  • Lot Dimensions: 125x385
  • Mineral Rights: Unknown
  • Parcel Description: Metes and Bounds
  • Zoning Use Restrictions: Residential

Rental Info

  • Rent Spree Y N: No

MLS Schools

  • Elementary School: Leland Public School
  • HighSchool: Leland Public School
  • School District: Leland Public School District
  • Middle School: Leland Public School

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 26, 2023
Closed on
Jun 25, 2023
Sold by
Maclean Thomas
Bought by
Lorenz Owen and Lorenz Keri Keri
Seller's Agent
Tim Schaub
Schaub Team Premier Realty
Buyer's Agent
Roger Schaub
Schaub Team Premier Realty
List Price
$745,000
Sold Price
$778,750
Premium/Discount to List
$33,750
4.53%
Views
13
Current Estimated Value
$927,144

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$148,394
Avg. Annual Appreciation
6.90%

Purchase Details

Closed on
Aug 31, 1992
Sold by
Rakocy
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
Lorenz Owen $778,750 --
-- $57,000 --
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
06/29/2023 06/29/23 Sold $778,750 +4.5% $556 / Sq Ft
05/26/2023 05/26/23 For Sale $745,000 -- $532 / Sq Ft
Source: Northern Great Lakes REALTORS® MLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $11,185 $345,900 $0 $0
2024 $9,012 $355,000 $0 $0
2023 $4,349 $374,200 $0 $0
2022 $4,852 $249,600 $0 $0
2020 $4,598 $243,600 $0 $0
2019 $3,865 $235,500 $0 $0
2018 -- $232,400 $0 $0
2017 -- $233,000 $0 $0
2016 -- $232,400 $0 $0
2015 -- $214,000 $0 $0
2014 -- $233,200 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Tim Schaub

    Seller's Agent in 2023

    Tim Schaub

    Schaub Team Premier Realty

    (231) 883-3545

    127 Total Sales

    Tim Schaub
    Section Image
  • Roger Schaub

    Buyer's Agent in 2023

    Roger Schaub

    Schaub Team Premier Realty

    (231) 883-4644

    150 Total Sales

    Roger Schaub
    Section Image
See All Agents

Map

Source: Northern Great Lakes REALTORS® MLS

MLS Number: 1911499

Northern Great Lakes REALTORS® MLS

APN: 003-190-024-00

Michigan Leelanau County Cedar 49621

542 E Sugar Bay Ln, Cedar, MI

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Northern Great Lakes REALTORS® MLS The information in this listing was gathered from third-party sources including the seller. Northern Great Lakes REALTORS® MLS and its subscribers disclaim any and all representations or warranties as to the accuracy of this information.

Copyright 2026 Northern Great Lakes REALTORS® MLS. All Rights Reserved.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.