Coldwell Banker Home Page
Skip to main contentColdwell Banker Home Page

Local Realty Service Provided By: Coldwell Banker Schmidt Realtors

Property view
Listing view 2
Listing view 3

16857 Stardust Road, 
Alpena, MI 49707

$749,900

2

Beds

1

Bath

1,714

Sq Ft

Single Family

Active

Listed by

Cindy J. Limback

RE/MAX New Horizons

989-358-1144

Last updated:

November 4, 2026, 05:53 PM

MLS#

201843534

Source:

MI WWBR

About This Home

16857 Stardust Road

This Long Lake property offers the perfect blend of comfortable living, rental income potential, and space for guests. Property includes a main house and three separate cabins, each featuring 2 BRs and one bathroom. Live year-round in the main home while renting the cabins to guests or using as private retreats for friends or creating a combination that suits your lifestyle. The main home includes a laundry area and a large bonus room that provides excellent storage and workspace for preparing the cabins for new guests. Nearly an acre of land includes a det. garage, sandy beach area, and large dock for enjoying all that lakefront living has to offer. Whether used as a waterfront retreat or an income producing property, this Long Lake opportunity produces flexibility in a beautiful setting.

Home Facts

Single Family

1 Bath

2 Bedrooms

Built in 1963

Subdivision & Development:

T33N R8E

Price Summary

749,900

$437 per Sq. Ft.

MLS #:

201843534

Last Updated:

November 4, 2026, 05:53 PM

Added:

13 day(s) ago

Rooms & Interior

Bedrooms

Total Bedrooms:

2

Bathrooms

Total Bathrooms:

1

Full Bathrooms:

1

Interior

Living Area:

1,714 Sq. Ft.

Structure

Structure

Architectural Style:

Ranch

Building Area:

1,714 Sq. Ft.

Year Built:

1963

Lot

Lot Size (Sq. Ft):

41,817

Finances & Disclosures

Finances

Price:

$749,900

Price per Sq. Ft:

$437 per Sq. Ft.

Source:MI WWBR
All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. Neither the listing broker(s) nor Water Wonderland Mls, Inc. shall be responsible for any typographical errors, misinformation, misprints, and shall be held totally harmless. Water Wonderland MLS, Inc © 2026 All rights reserved

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.