Skip main navigation
Contingent
    • Price increase: $540K (7/15)
    $790,000

    15801 Shubert Hwy, Alpena, MI 49707

    3beds
    3,424sqft
    : 
    Loading
    Get pre-qualified
    Single Family Residence
    Built in 1990
    2.44 Acres Lot
    $941,200 Zestimate®
    $231/sqft
    $-- HOA

    What's special

    Tucked beneath a canopy of towering trees and surrounded by 4.16 private acres, this Long Lake retreat captures the heart of true Up North living. With an incredible 578 feet of frontage, mornings begin with peaceful water views and evenings end around the glow of the stone woodburning fireplace. The log-style home blends rustic charm with warm tongue-and-groove interiors, creating the cozy lakefront atmosphere everyone dreams about. Offering 3 bedrooms, 3 bathrooms, and a huge bonus room perfect for guests, game nights, or extra sleeping space, there is room for everyone to gather and unwind. Outside, the spacious deck was designed for entertaining after long lake days, while the powered pole barn provides ideal storage for boats, toys, and outdoor equipment. A Generac generator adds peace of mind so you can enjoy every season comfortably. Whether you are seeking weekend escapes or year-round lake living, this Long Lake property delivers privacy, adventure, and unforgettable memories all in one extraordinary setting.
    39 days
    |
    1,407
    |
    56
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Lori Stephan 989-657-2709,

    Real Estate One of Alpena 989-354-7653

    Source: WWMLS,MLS#: 201840641MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 3
      • Full bathrooms: 2
      • 1/2 bathrooms: 1
      Heating
      • Forced Air, Propane
      Cooling
      • Central Air
      Appliances
      • Included: Water Heater, Water Softener
      • Laundry: Main Level
      Features
      • Ceiling Fan(s), Walk-In Closet(s)
      • Basement: None
      Interior area
      • Total structure area: 3,424
      • Total interior livable area: 3,424 sqft
      • Finished area above ground: 3,424

      Property

      Parking
      • Parking features: Garage
      • Has garage: Yes
      Features
      • Stories: 2
      • On waterfront: Yes
      • Waterfront features: Lake
      • Body of water: Long Lake
      Lot
      • Size: 2.44 Acres
      • Dimensions: 578 x 342 x 387 x 509
      Details
      • Additional structures: Pole Building
      • Parcel number: 06106000000701
      • Special conditions: Trust,Listing Status; Active w/ Contingencies

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family Residence
      Materials
      • Foundation: Crawl
      Condition
      • Year built: 1990

      Utilities & green energy

      • Sewer: Septic Tank

      Community & HOA

      Community
      • Subdivision: Campbell Shores
      Location
      • Region: Alpena

      Financial & listing details

      • Price per square foot: $231/sqft
      • Tax assessed value: $890,000
      • Annual tax amount: $4,701
      • Date on market: 6/8/2026
      • Listing terms: Cash,Conventional Mortgage
      • Road surface type: Paved

        Estimated market value

        $941,200

        $894,000 - $988,000

        $3,930/mo

        Price history

        DateEventPrice
        7/15/2026Contingent$790,000+216%$231/sqft
        Source: WWMLS #201840641 Report a problem
        6/8/2026Price change$250,000-68.4%$73/sqft
        Source: WWMLS #201840661 Report a problem
        6/8/2026Price change$790,000-20.2%$231/sqft
        Source: WWMLS #201840641 Report a problem
        5/22/2026Listed for sale$990,000$289/sqft
        Source: WWMLS #201840281 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$4,701 +4.7%$445,000 +10.5%
        2024$4,490 +5.1%$402,800 +24.8%
        2023$4,270 -6.4%$322,700 +8.3%
        2022$4,562 +1.4%$298,000 -0.4%
        2021$4,499 +2.9%$299,200 +10.2%
        2020$4,374 $271,400 -1.4%
        2019-- $275,200 -4.7%
        2018-- $288,800 +19.5%
        2016-- $241,700 +4.4%
        2014-- $231,600 +0.7%
        2013-- $230,000 -10.8%
        2012-- $257,900 -8.2%
        2011-- $280,900 -7.1%
        2010-- $302,400
        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.
        Get pre-qualified

        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

        Similar homes

            Nearby cities

            Nearby zip codes

            Other Alpena Topics

              Search
              Updates
              Favorites
              Plan
              Inbox