Skip main navigation
For sale
  • $650,000

    5150 Cheyenne Ave, Waterford, MI 48327

    3beds
    1,800sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1947
    2,178 Square Feet Lot
    $633,900 Zestimate®
    $361/sqft
    $-- HOA

    What's special

    **OPEN HOUSE: SATURDAY, JULY 18th FROM 11:00AM - 1:00PM** Beautifully updated in 2023 with stylish finishes throughout, this move-in-ready canal-front home offers an incredible opportunity to enjoy the all-sports Cass Lake lifestyle without the premium price of direct lakefront living. Situated on a desirable canal with private dock access, this home provides the perfect balance of modern comfort, waterfront living, and everyday convenience. A charming covered front porch and attractive curb appeal welcome you inside, where an open-concept layout creates an inviting atmosphere for both relaxing and entertaining. The living room flows seamlessly into the updated island kitchen, featuring granite countertops, stainless steel appliances, a coffee bar, and ample cabinet space. An adjacent dining area provides additional gathering space for family and guests. The main level includes a spacious bedroom with sliding glass doors leading to the backyard, along with a full bathroom for added convenience. Upstairs, the primary suite serves as a private retreat, complete with a walk-in closet and beautifully updated ensuite bathroom featuring dual vanities and a Euro-glass shower. A third bedroom and third full bathroom complete the second floor, along with a convenient second-floor laundry hookup. The unfinished basement offers abundant storage and excellent potential for future finished living space. Additional highlights include an attached two-car garage with direct access and an EV charger. Step outside to enjoy the large back deck overlooking the canal, providing the perfect setting for morning coffee, summer entertaining, or simply taking in the water views. With a private dock ready for your boat and direct access to Cass Lake, this property is an ideal opportunity to embrace lake living at an exceptional value.
    23 days
    |
    1,702
    |
    109
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Christina Gennari 248-550-4788,

    KW Domain 248-590-0800

    Source: Realcomp II,MLS#: 20261048228MLS Logo

    Loading...

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 3
      Primary bedroom
      • Level: Second
      • Area: 238
      • Dimensions: 14 X 17
      Bedroom
      • Level: Entry
      • Area: 180
      • Dimensions: 12 X 15
      Bedroom
      • Level: Second
      • Area: 135
      • Dimensions: 9 X 15
      Primary bathroom
      • Level: Second
      • Area: 99
      • Dimensions: 11 X 9
      Other
      • Level: Second
      • Area: 50
      • Dimensions: 10 X 5
      Other
      • Level: Entry
      • Area: 132
      • Dimensions: 11 X 12
      Dining room
      • Level: Entry
      • Area: 110
      • Dimensions: 10 X 11
      Kitchen
      • Level: Entry
      • Area: 150
      • Dimensions: 10 X 15
      Living room
      • Level: Entry
      • Area: 242
      • Dimensions: 11 X 22
      Mud room
      • Level: Entry
      • Area: 156
      • Dimensions: 26 X 6
      Heating
      • Forced Air, Natural Gas
      Cooling
      • Central Air
      Appliances
      • Included: Dishwasher, Free Standing Electric Range, Free Standing Refrigerator, Stainless Steel Appliances, Wine Cooler
      Features
      • Basement: Unfinished
      • Has fireplace: No
      Interior area
      • Total interior livable area: 1,800 sqft
      • Finished area above ground: 1,800

      Property

      Parking
      • Total spaces: 2
      • Parking features: Two Car Garage, Attached, Electric Vehicle Charging Stations, Direct Access, Garage Door Opener
      • Attached garage spaces: 2
      Features
      • Levels: Two
      • Stories: 2
      • Entry location: GroundLevelwSteps
      • Patio & porch: Covered, Deck, Porch
      • Pool features: None
      • On waterfront: Yes
      • Waterfront features: All Sports Lake, Boat Facilities, Canal Access, Canal Front, Direct Water Frontage, Waterfront
      • Body of water: Cass Lake
      Lot
      • Size: 2,178 Square Feet
      • Dimensions: 31 x 70
      Details
      • Parcel number: 1333434003
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Colonial
      • Property subtype: Single Family Residence
      Materials
      • Other
      • Foundation: Basement, Poured
      Condition
      • New construction: No
      • Year built: 1947
      • Major remodel year: 2023

      Utilities & green energy

      • Sewer: Public Sewer
      • Water: Public

      Community & HOA

      Community
      • Subdivision: CHETOLAH SHORES
      HOA
      • Has HOA: No
      Location
      • Region: Waterford

      Financial & listing details

      • Price per square foot: $361/sqft
      • Tax assessed value: $23,500
      • Annual tax amount: $1,298
      • Date on market: 6/26/2026
      • Cumulative days on market: 24 days
      • Listing agreement: Exclusive Right To Sell
      • Listing terms: Cash,Conventional,FHA,Va Loan
      • Exclusions: Exclusion(s) Do Not Exist

        Estimated market value

        $633,900

        $602,000 - $666,000

        $2,432/mo

        Price history

        DateEventPrice
        6/26/2026Listed for sale$650,000+17.6%$361/sqft
        Source: Realcomp II #20261048228 Report a problem
        9/24/2024Sold$552,500+3.3%$307/sqft
        Source: Realcomp II #20240015194 Report a problem
        9/23/2024Pending sale$535,000$297/sqft
        Source: Realcomp II #20240015194 Report a problem
        8/24/2024Price change$535,000-2.7%$297/sqft
        Source: Realcomp II #20240015194 Report a problem
        8/1/2024Price change$550,000-1.8%$306/sqft
        Source: Realcomp II #20240015194 Report a problem
        7/14/2024Price change$559,900-0.9%$311/sqft
        Source: Realcomp II #20240015194 Report a problem
        6/26/2024Price change$565,000-1.7%$314/sqft
        Source: Realcomp II #20240015194 Report a problem
        6/9/2024Price change$575,000-2.4%$319/sqft
        Source: Realcomp II #20240015194 Report a problem
        6/2/2024Price change$589,000-1%$327/sqft
        Source: Realcomp II #20240015194 Report a problem
        5/24/2024Price change$595,000-0.8%$331/sqft
        Source: Realcomp II #20240015194 Report a problem
        5/6/2024Price change$599,900-2.4%$333/sqft
        Source: Realcomp II #20240015194 Report a problem
        4/23/2024Price change$614,900-1.6%$342/sqft
        Source: Realcomp II #20240015194 Report a problem
        3/14/2024Listed for sale$624,900$347/sqft
        Source: Realcomp II #20240015194 Report a problem
        11/27/2023Listing removed--
        Source: Realcomp II #20230074031 Report a problem
        9/29/2023Price change$624,900-2.3%$347/sqft
        Source: Realcomp II #20230074031 Report a problem
        9/21/2023Price change$639,888-1.4%$355/sqft
        Source: Realcomp II #20230074031 Report a problem
        9/11/2023Price change$648,822-3.9%$360/sqft
        Source: Realcomp II #20230074031 Report a problem
        9/2/2023Price change$675,000+200%$375/sqft
        Source: Realcomp II #20230074031 Report a problem
        2/4/2022Pending sale$225,000$125/sqft
        Source: Realcomp II #2220004224 Report a problem
        1/4/2022Price change$225,000-10%$125/sqft
        Source: Realcomp II #2220000329 Report a problem
        11/30/2021Listed for sale$250,000$139/sqft
        Source: Realcomp II #2210098311 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2024$6,731 $232,450 +104.3%
        2023-- $113,800
        2022-- --
        2021$1,497 $85,410 +41.4%
        2020-- $60,390 +13%
        2019$1,479 +10.4%$53,450 +6.4%
        2018$1,340 $50,250
        2017-- $50,250 +11.4%
        2016-- $45,090 +6.9%
        2015-- $42,160 +5.4%
        2014-- $40,010 +5.6%
        2011-- $37,900 -8.1%
        2010$1,315 -10.7%$41,260 -22%
        2009$1,473 +2614.9%$52,910 +2585.8%
        2000$54 $1,970
        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.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 48327

        Getting around

        23 / 100
        Car-Dependent
        20 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes