Skip main navigation
For sale
  • $740,000

    15763 Shubert Hwy, Alpena, MI 49707

    3beds
    2,012sqft
    : 
    $5,006/mo
    Get pre-qualified
    Single Family Residence
    Built in 1996
    1.49 Acres Lot
    $700,300 Zestimate®
    $368/sqft
    $-- HOA

    What's special

    Charming, character-filled 2,012 sq ft genuine full-kentucky log home on 1.49 acres, tucked on an all-sports lake that is till quiet and private. A rare 180 feet of truly usable Long Lake frontage — clear, walkable shoreline right to your own dock, not overgrown brush like many "waterfront" listings actually deliver. A sprawling wraparound porch and deck run the full length of the home, framed by lush perennial gardens and a huge, manicured lawn perfect for entertaining or relaxing by the water. Inside: 3 bedrooms, a cozy loft, and a bright sunroom overlooking the lake, plus a stone fireplace in the main living area. Outside: a private dock, 2-car attached garage, and a 30x60 detached pole barn/garage. A true Northern Michigan waterfront retreat.
    47 days
    590
    39

    Zillow last checked:

    Listing updated:

    Listed by:

    Scott Rubin 248-278-8995,

    Andover Real Estate 248-206-5622

    Source: Realcomp II,MLS#: 20261077385MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 1
      • 1/2 bathrooms: 1
      Primary bedroom
      • Level: Entry
      • Area: 192
      • Dimensions: 16 X 12
      Bedroom
      • Level: Second
      • Area: 216
      • Dimensions: 12 X 18
      Bedroom
      • Level: Second
      • Area: 150
      • Dimensions: 10 X 15
      Primary bathroom
      • Level: Entry
      • Area: 100
      • Dimensions: 10 X 10
      Other
      • Level: Second
      • Area: 48
      • Dimensions: 8 X 6
      Dining room
      • Level: Entry
      • Area: 96
      • Dimensions: 8 X 12
      Kitchen
      • Level: Entry
      • Area: 140
      • Dimensions: 10 X 14
      Living room
      • Level: Entry
      • Area: 238
      • Dimensions: 14 X 17
      Loft
      • Level: Second
      • Area: 192
      • Dimensions: 12 X 16
      Heating
      • Baseboard, Hot Water, Propane
      Cooling
      • Ceiling Fans
      Appliances
      • Included: Built In Electric Oven, Down Draft, Dishwasher, Electric Cooktop, Microwave, Self Cleaning Oven, Washer Dryer Stacked, Water Softener Owned
      Features
      • High Speed Internet
      • Has basement: No
      • Has fireplace: Yes
      • Fireplace features: Wood Burning
      Interior area
      • Total interior livable area: 2,012 sqft
      • Finished area above ground: 2,012

      Property

      Parking
      • Total spaces: 8
      • Parking features: Two Car Garage, Sixor More Car Garage, Attached
      • Attached garage spaces: 8
      Features
      • Levels: Two
      • Stories: 2
      • Entry location: GroundLevelwSteps
      • Pool features: None
      • On waterfront: Yes
      • Waterfront features: All Sports Lake, Lake Front
      • Body of water: Long Lake Bay
      Lot
      • Size: 1.49 Acres
      • Dimensions: 150 x 343 x 180 x 443
      • Features: Vacation Home
      Details
      • Parcel number: 06106000000900
      • Special conditions: Short Sale No,Standard

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Log Home
      • Property subtype: Single Family Residence
      Materials
      • Log
      • Foundation: Crawl Space, Sump Pump
      • Roof: E NE RG YS TA RShingles
      Condition
      • New construction: No
      • Year built: 1996

      Utilities & green energy

      • Sewer: Septic Tank
      • Water: Public, Well
      • Utilities for property: Above Ground Utilities

      Community & HOA

      Community
      • Subdivision: CAMPBELL SHORES
      HOA
      • Has HOA: No
      Location
      • Region: Alpena

      Financial & listing details

      • Price per square foot: $368/sqft
      • Tax assessed value: $160,404
      • Annual tax amount: $1,918
      • Date on market: 9/25/2026
      • Cumulative days on market: 48 days
      • Listing agreement: Exclusive Agency
      • Listing terms: Cash,Contract,Conventional

        Estimated market value

        $700,300

        $665,000 - $735,000

        $2,510/mo

        Price history

        DateEventPrice
        9/25/2026Listed for sale$740,000$368/sqft
        Source: Realcomp II #20261077385 Report a problem

        Public tax history

        YearProperty taxesTax assessment
        2026$3,019 $318,900 +9.2%
        2025-- $291,900 +11.4%
        2024$2,811 +5.1%$262,100 +27.7%
        2023$2,673 -6.4%$205,200 +8%
        2022$2,857 $190,000 -3.1%
        2021-- $196,000
        2020-- --
        2019-- --
        2018-- --
        2016-- --
        2014-- --
        2013-- $143,300 -9.2%
        2012-- $157,800 -8%
        2011-- $171,500 -10.8%
        2010-- $192,300
        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