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.
For sale
$559,900
17745 Shubert Hwy, Alpena, MI 49707
3beds
1,192sqft
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
- 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#: 201841645
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
| Date | Event | Price |
|---|---|---|
| 7/23/2026 | Listed for sale | $559,900+49.3%$470/sqft |
Source: | ||
| 8/22/2025 | Sold | $375,000-6%$315/sqft |
Source: | ||
| 7/24/2025 | Listed for sale | $399,000$335/sqft |
Source: | ||
| 7/10/2025 | Contingent | $399,000$335/sqft |
Source: | ||
| 7/7/2025 | Listed for sale | $399,000+173.3%$335/sqft |
Source: | ||
| 7/1/2016 | Sold | $146,000+0.8%$122/sqft |
Source: | ||
| 5/13/2016 | Price change | $144,900-9.4%$122/sqft |
Source: RE/MAX New Horizons #302405 Report a problem | ||
| 9/23/2015 | Price change | $159,900-5.9%$134/sqft |
Source: Banner Realty #298228 Report a problem | ||
| 9/1/2015 | Price change | $169,900-5.3%$143/sqft |
Source: Banner Realty #298228 Report a problem | ||
| 7/16/2015 | Listed for sale | $179,500$151/sqft |
Source: Banner Realty #298228 Report a problem | ||
Public tax history
| Year | Property taxes | Tax 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.Climate risks
Neighborhood: 49707
Nearby schools
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.





