Search
Long Lake Resort Compound
For Sale
Contact for pricing

16857 Stardust Rd, Alpena, MI 49707

Established Long Lake resort offering a ranch-style home and three two-bedroom cabins on a nearly one-acre lot.

Property Size3,432 SF
Lot Size0.96 Acres
Days on Market121

Property Features for 16857 Stardust Rd

General Information

Standard status Active
Size 3,432 SF
Lot size 0.96 Acres
Property subtype Hospitality

Additional Details

Business Included Yes
Listing Agency: Century 21 Northland
Listed By: Mari Crow · License #MI
Source: Crexi
Added: Apr 11 Changed: Aug 8 Last Checked: Jul 20 at 6:06PM

Displayed information is deemed reliable but is not guaranteed and should be independently verified. All listing content including descriptions, pricing, images are the copyrighted material of Century 21 Northland

Investment Insights

Based on property information with market context.

Falcon Cove Resort is a well-established hospitality property on all-sports Long Lake. The offering includes a two-bedroom, 1,560-square-foot ranch-style home and three separate two-bedroom cabins, each approximately 624 square feet. All buildings are described as being in excellent condition, with pride of ownership reflected throughout the property.

The property sits on a .96-acre lot with 147 feet of frontage on Long Lake, providing direct water access for the resort configuration.

For buyers seeking a single compound setup, the combination of one ranch-style home and three additional two-bedroom cabins provides multiple overnight accommodations within the same resort footprint.

Key Highlights

  • Falcon Cove Resort on all‑sports Long Lake
  • Includes a 2‑bedroom, 1,560 SF ranch‑style home
  • Also includes three 2‑bedroom cabins, each 624 SF

Property Analytics

Current Use

Falcon Cove Hotel & Motel

Suggested Use

Top Pick Accounting Firm Travel Agency Real Estate Agency Bed & Breakfast Hotel & Motel

Score = modeled unmet demand for each use within ~1 mi (higher = bigger opportunity). Zoning and permitted uses should be independently verified with local authorities.

Lease Details

Turnkey business
Opportunity

Location Intelligence

Trade Area within ½ mile

9
Businesses Nearby

Demographics for 49707, MI

22,243
Population
11,974
Households
1.9
Avg Household Size
48
Median Age
19%
College-Educated
94%
High-School Grad
215.4 sq mi
ZIP Area
103
Density / Sq Mi
$50,699
Median Household Income
$32,208
Median Earnings
$642
Median Rent
$134,900
Median Home Value
Rey
Questions? Ask Rey
Realmo’s AI knows this listing — price, zoning, demand, history. Ask anything.

Frequently Asked Questions

What type of property is this?
Resort - Established Long Lake resort offering a ranch-style home and three two-bedroom cabins on a nearly one-acre lot.
Where is this resort located?
The property is located at 16857 Stardust Rd Alpena, MI.
What are key features of this property?
This property features: Falcon Cove Resort on all‑sports Long Lake; Includes a 2‑bedroom, 1,560 SF ranch‑style home; Also includes three 2‑bedroom cabins, each 624 SF
More about this property
Thanks! Your message was sent.
Error! Your message wasn't sent.
Please enter your name
Please enter email
Please enter the email in the correct format
Please enter phone
Please enter the number in the correct format
Please enter message