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.
For sale
$740,000
15763 Shubert Hwy, Alpena, MI 49707
3beds
2,012sqft
Single Family Residence
Built in 1996
1.49 Acres Lot
$700,300 Zestimate®
$368/sqft
$-- HOA
What's special
- 48 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#: 20261077385
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
| Date | Event | Price |
|---|---|---|
| 9/25/2026 | Listed for sale | $740,000$368/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax 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






