Skip main navigation
For sale
  • $559,900

    17745 Shubert Hwy, Alpena, MI 49707

    3beds
    1,192sqft
    : 
    $3,639/mo
    Get pre-qualified
    Single Family Residence
    Built in 1972
    1.04 Acres Lot
    $528,400 Zestimate®
    $470/sqft
    $-- HOA

    What's special

    Quality upgrades throughoutStunning top-of-the-line kitchenBreathtaking views
    Experience lakefront living at its finest in this beautifully remodeled home on Long Lake! Boasting 175 feet of private frontage, this exceptional property offers breathtaking views, a huge backyard perfect for entertaining, dock, and a 24X32 pole barn for all your storage needs. Inside, you'll find a stunning top-of-the-line kitchen with premium finishes including quartz countertops and backsplash, and quality upgrades throughout. Whether you're looking for a year-round home or the perfect waterfront getaway, this move-in-ready home combines luxury, comfort, and incredible outdoor space in one amazing package. Square footage is approximate and should be verified by the buyer or buyer's agent.
    45 days
    1,101
    37

    Zillow last checked:

    Listing updated:

    Listed by:

    Cody Bellmer 231-838-7958,

    CENTURY 21 NORTHLAND of ALPENA 989-356-2181

    Source: WWMLS,MLS#: 201841645MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 1
      • 1/2 bathrooms: 1
      Heating
      • Baseboard, Propane
      Appliances
      • Included: Water Heater, Washer, Range/Oven, Refrigerator, Dryer, Dishwasher
      • Laundry: Main Level
      Features
      • Ceiling Fan(s)
      • Windows: Blinds, Curtain Rods
      • Basement: None
      Interior area
      • Total structure area: 1,192
      • Total interior livable area: 1,192 sqft
      • Finished area above ground: 1,192

      Property

      Parking
      • Parking features: Garage Door Opener
      • Has garage: Yes
      Features
      • Patio & porch: Patio/Porch
      • Exterior features: Sprinkler System
      • On waterfront: Yes
      • Body of water: Long Lake
      • Frontage type: All-Sport
      Lot
      • Size: 1.04 Acres
      • Dimensions: 175 x 259
      • Features: Landscaped
      Details
      • Additional structures: Pole Building, Shed(s)
      • Parcel number: 12209500001200 & 12209500001201
      • Zoning: Residential

      Construction

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

      Utilities & green energy

      • Sewer: Septic Tank

      Community & HOA

      Community
      • Subdivision: East Bay Sub
      Location
      • Region: Alpena

      Financial & listing details

      • Price per square foot: $470/sqft
      • Tax assessed value: $198,800
      • Annual tax amount: $3,470
      • Date on market: 7/23/2026
      • Listing terms: Cash,Conventional Mortgage
      • Ownership: Owner
      • Road surface type: Paved, Maintained

        Estimated market value

        $528,400

        $502,000 - $555,000

        $2,468/mo

        Price history

        DateEventPrice
        7/23/2026Listed for sale$559,900+49.3%$470/sqft
        Source: WWMLS #201841645 Report a problem
        8/22/2025Sold$375,000-6%$315/sqft
        Source: WWMLS #201835747 Report a problem
        7/24/2025Listed for sale$399,000$335/sqft
        Source: RMLS Multi-List #280-25-0075 Report a problem
        7/10/2025Contingent$399,000$335/sqft
        Source: WWMLS #201835747 Report a problem
        7/7/2025Listed for sale$399,000+173.3%$335/sqft
        Source: WWMLS #201835747 Report a problem
        7/1/2016Sold$146,000+0.8%$122/sqft
        Source: WWMLS #302405 Report a problem
        5/13/2016Price change$144,900-9.4%$122/sqft
        Source: RE/MAX New Horizons #302405 Report a problem
        9/23/2015Price change$159,900-5.9%$134/sqft
        Source: Banner Realty #298228 Report a problem
        9/1/2015Price change$169,900-5.3%$143/sqft
        Source: Banner Realty #298228 Report a problem
        7/16/2015Listed for sale$179,500$151/sqft
        Source: Banner Realty #298228 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2025$3,470 +1%$99,400 +13%
        2024$3,436 +4.9%$88,000 +1.1%
        2023$3,276 +2.7%$87,000
        2022$3,192 +1.3%$87,000 +4.3%
        2021$3,150 +0.5%$83,400 +5.2%
        2020$3,135 $79,300 +0.5%
        2019-- $78,900 +1%
        2018-- $78,100 +5%
        2016-- $74,400 +9.7%
        2014-- $67,800 +0.6%
        2013-- $67,400 -20.6%
        2012-- $84,900 -3.7%
        2011-- $88,200 -5%
        2010-- $92,800
        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
        Schools provided by the listing agent
        • Elementary: Alpena
        • High: Alpena

        Source: WWMLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

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

        Browse local experts