Skip main navigation
For sale
  • $749,900

    16857 Stardust Rd, Alpena, MI 49707

    2beds
    1,714sqft
    : 
    $4,993/mo
    Get pre-qualified
    Single Family Residence
    Built in 1963
    0.96 Acres Lot
    $710,300 Zestimate®
    $438/sqft
    $-- HOA

    What's special

    Large dockLaundry areaSandy beach areaExcellent storage and workspaceLarge bonus room
    This Long Lake property offers the perfect blend of comfortable living, rental income potential, and space for guests. Property includes a main house and three separate cabins, each featuring 2 BRs and one bathroom. Live year-round in the main home while renting the cabins to guests or using as private retreats for friends or creating a combination that suits your lifestyle. The main home includes a laundry area and a large bonus room that provides excellent storage and workspace for preparing the cabins for new guests. Nearly an acre of land includes a det. garage, sandy beach area, and large dock for enjoying all that lakefront living has to offer. Whether used as a waterfront retreat or an income producing property, this Long Lake opportunity produces flexibility in a beautiful setting.
    18 days
    998
    48

    Zillow last checked:

    Listing updated:

    Listed by:

    Cindy J. Limback 989-657-1171,

    RE/MAX New Horizons 989-358-1144

    Source: WWMLS,MLS#: 201843534MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 2
      • Bathrooms: 1
      • Full bathrooms: 1
      Heating
      • Hot Water, Natural Gas
      Appliances
      • Included: Washer, Range/Oven, Refrigerator, Microwave, Dryer
      • Laundry: Main Level
      Features
      • Ceiling Fan(s)
      • Windows: Blinds
      Interior area
      • Total structure area: 1,714
      • Total interior livable area: 1,714 sqft
      • Finished area above ground: 1,714

      Property

      Parking
      • Parking features: Driveway
      • Has garage: Yes
      • Has uncovered spaces: Yes
      Features
      • Exterior features: Dock
      • On waterfront: Yes
      • Waterfront features: Lake
      • Body of water: Long Lake
      Lot
      • Size: 0.96 Acres
      • Dimensions: 147 x 295 x 106 x 357
      Details
      • Parcel number: 12205300000600

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Ranch
      • Property subtype: Single Family Residence
      Materials
      • Foundation: Crawl, Slab
      Condition
      • Year built: 1963

      Utilities & green energy

      • Sewer: Septic Tank

      Community & HOA

      Community
      • Subdivision: T33N R8E
      Location
      • Region: Alpena

      Financial & listing details

      • Price per square foot: $438/sqft
      • Tax assessed value: $393,000
      • Annual tax amount: $7,165
      • Date on market: 10/27/2026
      • Listing terms: Cash,Conventional Mortgage
      • Ownership: Owner
      • Road surface type: Dirt, Paved

        Estimated market value

        $710,300

        $675,000 - $746,000

        $1,248/mo

        Price history

        DateEventPrice
        10/27/2026Listed for sale$749,900+87.5%$438/sqft
        Source: WWMLS #201843534 Report a problem
        3/11/2024Sold$400,000-27.1%$233/sqft
        Source: WWMLS #201826345 Report a problem
        2/20/2024Pending sale$549,000$320/sqft
        Source: WWMLS #201826345 Report a problem
        2/14/2024Listed for sale$549,000-7.7%$320/sqft
        Source: WWMLS #201826345 Report a problem
        12/2/2023Listing removed$595,000$347/sqft
        Source: RMLS Multi-List #280-23-0076 Report a problem
        9/14/2023Listed for sale$595,000+186.6%$347/sqft
        Source: WWMLS #201826345 Report a problem
        9/25/2008Sold$207,600$121/sqft
        Source: Public Record Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$7,165 +60.9%$196,500 +8.2%
        2025$4,455 +4.8%$181,566 +1.9%
        2024$4,249 +5.1%$178,200 +24.4%
        2023$4,042 +2.7%$143,300 +5.3%
        2022$3,937 +1.3%$136,100 +1.7%
        2021$3,886 +1.9%$133,800 -0.2%
        2020$3,814 $134,100 +12%
        2019-- $119,700 +3.8%
        2018-- $115,300 +14.3%
        2016-- $100,900 +8%
        2014-- $93,400 +6.3%
        2013-- $87,900 -12.5%
        2012-- $100,500 -4.8%
        2011-- $105,600 -6.2%
        2010-- $112,600
        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.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 49707

        Getting around

        0 / 100
        Car-Dependent
        26 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

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

        Browse local experts