$559,900

17745 Shubert Hwy Alpena, MI 49707

Alpena Area

Estimated payment $3,373/month

Total Views 8,996
3 Beds
1.5 Baths
1,192 Sq Ft
$470 Price per Sq Ft

Highlights

  • Waterfront
  • Pole Barn
  • 2 Car Attached Garage
  • Ranch Style House
  • Fireplace
  • Patio

About This Home

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.

Listing Agent

Cody Bellmer

CENTURY 21 NORTHLAND of ALPENA License #6501435021 Listed on: 07/23/2026

CENTURY 21 NORTHLAND of ALPENA

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1972

Lot Details

  • 1.04 Acre Lot
  • Lot Dimensions are 175x259
  • Waterfront
  • Landscaped
  • Sprinkler System

Home Design

  • Ranch Style House
  • Brick Exterior Construction
  • Frame Construction

Interior Spaces

  • 1,192 Sq Ft Home
  • Fireplace
  • Living Room
  • Dining Room
  • Crawl Space

Kitchen

  • Oven or Range
  • Dishwasher

Bedrooms and Bathrooms

  • 3 Bedrooms

Laundry

  • Laundry on main level
  • Dryer
  • Washer

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Outdoor Features

  • Patio
  • Pole Barn
  • Shed

Schools

  • Alpena Elementary School
  • Alpena High School

Utilities

  • Heating System Uses Propane
  • Baseboard Heating
  • Well

Community Details

  • East Bay Sub Subdivision

Listing and Financial Details

  • Assessor Parcel Number 122-095-000-012-00 & 122-095-000-012-01
  • Tax Block Section 29

Home Details

Home Type

Single Family

Year Built

Built in 1972

Lot Details

1.04 Acres

Listing Details

  • Directions: From Alpena, north on US 23, left on Shubert Highway
  • Garage Yn: Yes
  • Lot Size: 175x259
  • Prop. Type: Residential
  • Bedroom 1 Level: 1st
  • Bedroom 2 Level: 1st
  • Dining Room Level: 1st
  • Kitchen Level: 1st
  • Living Room Level: 1st
  • Year Built: 1972
  • PropertySubType: Residential Water
  • Road Frontage Type: All-Sport
  • ResoLaundryFeatures: Main Level
  • Lot Size Acres: 1.04
  • Road Surface Type: Paved, Maintained
  • Water Body Name: Long Lake
  • NAV29_Unit_1_Appliances: Dishwasher, Dryer, Refrigerator, Range/Oven, Washer
  • Co List Office Phone: 989-356-2181
  • MLS Status: Active
  • Subdivision Name: East Bay Sub
  • Above Grade Finished Sq Ft: 1192.0
  • Architectural Style: Ranch
  • ResoBuildingAreaSource: Old MLS
  • Property Information Total Bathrooms2: 2.0
  • Property Information:Style2: Ranch
  • Property Information Construction: Frame
  • Mineral Rights:Mineral Rights: Unknown
  • Road:Road: Paved, Maintained
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Has Basement: None
  • Interior Amenities: Blinds, Ceiling Fan, Curtain Rods, 1st Flr Primary Bdrm
  • Bedroom 3 Level: 1st
  • Full Bathrooms: 1
  • Half Bathrooms: 1
  • Total Bedrooms: 3
  • Interior Features:Interior Features: Fireplace, 1st Flr Primary Bdrm

Exterior Features

  • Exterior Features: Landscaped, Patio/Porch, Pole Building, Shed, Sprinkler System
  • Waterfront Features: Yes
  • Waterfront: Yes
  • Foundation Details: Crawl
  • Exterior:Exterior: Brick

Garage/Parking

  • Attached Garage: No
  • Parking Features: Garage Door Opener
  • Property Information:Garage Stall2: 2
  • Property Information:Garage Type2: Attached/UN

Utilities

  • Sewer: Septic Tank
  • Heating: Baseboard, Propane
  • HeatingYN: Yes
  • Water Source: Well

Association/Amenities

  • TaxesAndPossessionAssociationDues: No

Schools

  • Elementary School: Alpena
  • Junior High Dist: Alpena
  • High School: Alpena

Lot Info

  • Zoning: Residential
  • Lot Size Sq Ft: 45302.4
  • Parcel Number: 122-095-000-012-00 & 122-095-000-012-01

Tax Info

  • Tax Block: Section 29

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2026 $3,618 $129,300 $0 $0
2025 $1,068 $99,400 $0 $0
2024 $1,041 $88,000 $0 $0
2023 $1,032 $87,000 $0 $0
2022 $3,518 $87,000 $0 $0
2021 $3,426 $83,400 $0 $0
2020 $3,381 $79,300 $0 $0
2019 $3,365 $78,900 $0 $0
2018 $3,330 $78,100 $0 $0
2016 -- $74,400 $0 $0
2014 -- $67,800 $0 $0
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/23/2026 07/23/26 For Sale $559,900 +49.3% $470 / Sq Ft
08/22/2025 08/22/25 Sold $375,000 -6.0% $315 / Sq Ft View Prior Sale
07/07/2025 07/07/25 For Sale $399,000 +173.3% $335 / Sq Ft
07/01/2016 07/01/16 Sold $146,000 -- $122 / Sq Ft View Prior Sale
05/21/2016 05/21/16 Pending -- -- --
Source: Water Wonderland Board of REALTORS®

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Warranty Deed $146,000 None Available
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Closed $131,400 Purchase Money Mortgage
Source: Public Records

Source: Water Wonderland Board of REALTORS®

MLS Number: 201841645

Water Wonderland Board of REALTORS®

APN: 122-095-000-012-00

Your Personal Tour Guide

Ask me questions while you tour the home.