NEW 9 HRS AGO

For sale

$749,900

Est. $4,477/mo —

•

1,714

sq ft

16857 Stardust Rd, Alpena, MI 49707

About this home

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.

Single-familyProperty Type

1963Year Built

0.96 acresLot Size

$438Price/Sq.Ft.

1 car garageParking

Listed by Cindy Limback • RE/MAX New Horizons

Listing updated: Oct 27, 2026 at 03:34pm

Redfin checked: 2 minutes ago

•Source:WWMLS #201843534

Payment calculator

$4,477 per month

Principal and interest$4,093

Property taxes

$178

HOA dues

Home insurance

$206

Utilities

Add

5 minutes to get started. No credit impact.

Affordability tools

Open houses

No upcoming open houses.

Around this home

Schools

K - 12
Preschool & daycare

Hinks Elementary

Public K-5 • Assigned • 5.5mi

6/10

Alpena High School

Public 8-12 • Assigned • 11.3mi

8/10

Provided by GreatSchools

Lifestyle

Provided by Walk Score and Local Logic

Market insights

16857 Stardust Rd · $749,900

DAYS ON MARKET

The average home goes pending in 33 days.

SALE-TO-LIST

Most homes are selling 3% below list price.

LIST PRICE

Median sale price in this area is $224,536. (70% lower than this home)

PRICE DROP

25% of homes in this area have had a price drop in the past month.

Property details

Interior
Exterior
Finance

Kitchen

Bathroom

Bedroom

Living

Dining

Interior features
Blinds
Crawl space

Bathrooms
1 full bathroom

Kitchen
Microwave, refrigerator, oven, range

Laundry & utility
Washer and dryer
Main-level laundry

Heating & cooling
Hot water and natural gas heating
Ceiling fan

Sale and tax history for 16857 Stardust Rd

Sale History
Tax History

Date

Event

Price

WWMLS #201843534

Oct 26, 2026

Listed

$749,900

$438/sq ft

WWMLS #201826345

Mar 11, 2024

Sold

$400,000

$233/sq ft

Feb 20, 2024

Pending

—

Feb 14, 2024

Relisted

—

Feb 14, 2024

Price Changed

$549,000

$320/sq ft

Sep 14, 2023

Listed

$595,000

$347/sq ft

+35

Falcon Cove Resort is a well established resort on beautiful all sports Long Lake offering a two-bedroom ranch style home as well as 3 two-bedroom cabins, all situated on a . 96 acre lot with 147 feet of frontage. An amazing commercial opportunity or perfect situation for a family compound! All buildings in excellent condition showing pride of ownership throughout! Call for further details and your personal tour of this special property. Square footage is approximate and should be verified by the buyer or buyer's agent

Public Records

Nov 23, 2004

Sold

$215,000

$125/sq ft

Public record

Beds

Baths

Stories

—

Lot width

—

Lot depth

—

Lot size

0.96 Acres

Year renovated

—

Finished Sq. Ft.

2,951

Unfinished Sq. Ft.

—

Total Sq. Ft.

2,951

Year built

1963

Style

Single Family Residential

County

Presque Isle County

APN

122-053-000-006-00

Parking Spaces

—

Basement

—

Accessible

—

HOA Dues

—

Garage

—

Features

—

Last updated by owner on Oct 22, 2026.

Climate risks

1/10 Flood Factor

Minimal risk of a flood reaching the building in the next 30 years

1/10 Fire Factor

Unlikely to be in a wildfire in next 30 years

1/10 Heat Factor

7 days above 92° expected this year, 13 days in 30 years

1/10 Wind Factor

Minimal risk of severe winds over next 30 years

1/10 Air Factor

0 unhealthy days expected this year, 0 days in 30 years

Provided by First Street

Historical weather

Alpena, MI • 49707

Average low and high temperatures (°F)

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Sun exposure

86/ 100

Very good sunlight

Sunscore

This home receives average direct sun exposure in Alpena. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.

11.6 hrs

5.1 hrs

JuneDecember

Provided by Shadowmap

Redfin Estimate for 16857 Stardust Rd

$743,680

$6,220 under list price of $750K

Nearby comparable homes

The Redfin Estimate uses 6 recent nearby sales, priced between $200K to $465K.

SOLD OCT 9, 2026
$460,000 Last sold price
3 beds2 baths1,816 sq ft
1634 Gitchi Manitou Rd, Alpena, MI 49707
$185/sq ft
smaller lot
35 years newer
SOLD OCT 8, 2026
$455,000 Last sold price
3 beds2 baths2,620 sq ft
7154 Wessel Rd, Alpena, MI 49707
$264/sq ft
larger lot
25 years newer
SOLD AUG 21, 2026
$465,000 Last sold price
3 beds1 bath1,404 sq ft
2340 Maple Grove Rd, Alpena, MI 49707
$107/sq ft
smaller lot
23 years older
SOLD OCT 7, 2026
$200,000 Last sold price
3 beds2 baths1,936 sq ft
1157 W Hamilton Rd, Alpena, MI 49707
$335/sq ft
20 years older
basement
SOLD JUL 14, 2026
$208,000 Last sold price
3 beds2 baths1,624 sq ft
8515 U.s. 23, Alpena, MI 49707
$310/sq ft
SOLD SEP 28, 2026
$282,000 Last sold price
2 beds1 bath780 sq ft
10350 White Birch St, Presque Isle, MI 49777
$76/sq ft
smaller lot

Rental earnings

Est. $869 per month, based on comparable rentals

Contact listing agent

Cindy Limback

RE/MAX New Horizons

989-657-1171

cindy@remaxalpena.com

At this time, Redfin doesn't have an agent available to help you with this home.

Early Access listings

EARLY ACCESSREDFIN COMING SOON

$559,000

3 beds2 baths1,528 sq ft

428 W Lincoln St, Birmingham, MI 48009

EARLY ACCESSREDFIN COMING SOON

$340,000

3 beds2.5 baths1,898 sq ft

1992 Oxford Rd, Grosse Pointe Woods, MI 48236

EARLY ACCESS403753 COMING SOON

$425,000

3 beds2.5 baths3,490 sq ft

17567 Merryweather St, Clinton Twp, MI 48038

EARLY ACCESSREDFIN COMING SOON

$470,000

4 beds3 baths2,322 sq ft

7979 Everett Dr, Westland, MI 48185

Nearby similar homes

$9,500

Land— sq ft

939 W Lake St, Tawas City, MI 48763

30 dock slip • Dedicated dock slip • Waterfront lifestyle

$20,000

Land— sq ft

109 Arbor Ln, Alpena, MI 49707

Listed 372 days

FOR SALE BY OWNER

$229,500

3 beds2 baths— sq ft

51 Sherry St, Au Gres, MI 48703

Wooded lot property • Large front porch • New floors

$429,000

2 beds2 baths1,399 sq ft

6994 Black Bass Bay Rd, Presque Isle, MI 49777

Updated kitchen • Vaulted room • Propane fireplace

$239,467

3 beds2 baths2,335 sq ft

235 Monument Rd, East Tawas, MI 48730

1.12 acre lot • Built 1985 • Listed 404 days

$299,900

3 beds2 baths2,100 sq ft

2410 S State St, Greenbush, MI 48738

Restored • Updated plumbing • Updated electrical

New listings for sale in 49707

NEW 9 HRS AGO

$749,900

2 beds1 bath1,714 sq ft

16857 Stardust Rd, Alpena, MI 49707

Laundry area • Large bonus room • Det garage

NEW 16 HRS AGO

$174,900

3 beds1 bath1,131 sq ft

1115 Lake Winyah Rd, Alpena, MI 49707

0.39 acre lot • Garage • Built 1955

NEW 33 HRS AGO

$174,900

4 beds2 baths1,652 sq ft

329 W Miller St, Alpena, MI 49707

Detached garage • Large back yard • Convenient location

3D WALKTHROUGH

$624,900

3 beds2 baths2,178 sq ft

13956 Parallel Ave, Alpena, MI 49707

Lakefront living • Two lot property • 100 feet of frontage

FOR SALE BY OWNER

$799,000

3 beds2 baths1,806 sq ft

8662 Maple St, Alpena, MI 49707

Lake house • Additional cottage • Boathouse

$193,500

4 beds2 baths1,650 sq ft

321 Fair Ave, Alpena, MI 49707

New roof • New gutters • Remodeled bathroom

$239,850

3 beds2 baths2,088 sq ft

101 Island View Dr, Alpena, MI 49707

Landscaped backyard • Fenced backyard • Automatic generator

$137,500

2 beds1 bath708 sq ft

529 Sable St, Alpena, MI 49707

Fenced-in backyard • Private space • 4,791 sq ft lot

3D WALKTHROUGH

$245,000

3 beds2 baths2,520 sq ft

1460 Long Rapids Rd, Alpena, MI 49707

Spacious kitchen • Expansive backyard • Rear deck

Details provided by WWMLS and may not match the public record. Learn more.

Download the Redfin App on the Apple App Store

Download the Redfin App from the Google Play Store

Join us

Become an Agent

Get referrals

Careers

Find homes faster

About us

Find us

Subsidiaries

Affiliated Business

Countries

United States

Canada

Updated September 2025: By searching, you agree to the Terms of Use, and Privacy Policy.

Do not sell or share my personal information.

REDFIN and all REDFIN variants, WALK SCORE, and the R logos, are trademarks of Redfin Corporation, registered or pending in the USPTO.

California DRE #01521930

Redfin is licensed to do business in New York as Redfin Real Estate. NY Standard Operating Procedures

New Mexico Real Estate Licenses

TREC: Info About Brokerage Services, Consumer Protection Notice

All mortgage lending products and information are provided by Rocket Mortgage, LLC | NMLS #3030; www.NMLSConsumerAccess.org. Licensed in 50 states. This site is not authorized by the New York State Department of Financial Services for mortgage solicitation or loan applications activities related to properties located in the State of New York.

Redfin Corporation is an affiliated business of Rocket Limited Partnership. Each company, and their subsidiaries, are separate legal entities operated and managed through its own management and governance structures.

If you are using a screen reader, or having trouble reading this website, please call Redfin Customer Support for help at 1-844-759-7732.

REDFIN IS COMMITTED TO AND ABIDES BY THE FAIR HOUSING ACT AND EQUAL OPPORTUNITY ACT. READ REDFIN'S FAIR HOUSING POLICY AND THE NEW YORK STATE FAIR HOUSING NOTICE.

GreatSchools Ratings provided by GreatSchools.org.

Houses for rent in Alpena	Agents near me	Livonia, MI homes for sale	Alpena Housing Market
Houses for sale near me	Detroit, MI homes for sale	Royal Oak, MI homes for sale
Land for sale near me	Ann Arbor, MI homes for sale	Novi, MI homes for sale
Open Houses near me	Grand Rapids, MI homes for sale	Alpena Property Records
Condos for sale near me	Troy, MI homes for sale	MI New Listings

Hubbard Lake homes for sale
Posen homes for sale
Lost Lake Woods homes for sale

About this home

Payment calculator

Affordability tools

Open houses

Around this home

Schools

Lifestyle

Market insights

Property details

Sale and tax history for 16857 Stardust Rd

Public record

Climate risks

Historical weather

Sun exposure

Redfin Estimate for 16857 Stardust Rd

Contact listing agent

Early Access listings

Nearby similar homes

New listings for sale in 49707

More real estate resources