Waterfront Resort With
New
For Sale
$749,900
16857 Stardust Road, Alpena, MI 49707
Commercial Sale, Alpena, MI
Property Size3,586 SF
Lot Size0.96 Acres
Price / SF$209.12
Days on Market4
Property Features for 16857 Stardust Road
General Information
Property type
Commercial Sale
Property subtype
Other
Zoning
Res
Parking features
Parking Lot
Subdivision
T33N R8E
Directions
US23 then West on Long Lake Hwy; North on Morrow Rd; Rt on Stardust Rd
Standard status
Active
APN
122-053-000-006-00
Size
3,586 SF
Lot size
0.96 Acres
Tenancy & Operations
Currently Operating
Yes
Business Included
Yes
Taxes and HOA fees
Tax Description
Lot 6 ASSESSORS PLAT OF SHANGRI-LA Sec 31 T33N R8E
Legal Description
Lot 6 ASSESSORS PLAT OF SHANGRI-LA Sec 31 T33N R8E
Utilities
Sewer type
Septic Tank
Water source
Well
Water front
1
Amenities
sandy beach area
grassy area for games
paved driveway
large dock
Building Details
Building materials
Block
Listing Agency:
RE/MAX New Horizons
(989) 358-1144
Listed By:
Cindy J. Limback
(989) 657-1171
Added: Oct 26
Changed: Oct 27
Last Checked: Oct 29 at 2:06AM
MLS# 201843530
Copyright © 2026 Water Wonderland Board of Realtors®. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Ask AI about this property
Review the available facts, identify missing information and prepare questions for the agent.
Investment Insights
Based on property information with market context.
This Long Lake resort property spans 0.96 acres and contains 3,586 square feet. Its lodging consists of a main house and three individual cabins; each building has two bedrooms and one bathroom. The main house also provides a laundry area and a bonus room, while a detached garage adds storage or service space. Block construction, a paved driveway, and a parking lot are among the site features.
The waterfront grounds include a sandy beach, a large dock, and a grassy area. Water service is provided by a well, with septic tank service for wastewater. The property is zoned Res and is configured for resort use.
The waterfront grounds include a sandy beach, a large dock, and a grassy area. Water service is provided by a well, with septic tank service for wastewater. The property is zoned Res and is configured for resort use.
Key Highlights
- Four lodging buildings: a main house and three separate cabins
- Each building has 2 bedrooms and 1 bathroom
- 3,586 square feet on 0.96 acres
Property Analytics
Who owns this building?
See the owner, sales and loan history
Open Analytics
Current Use
Lease Details
Turnkey business
Opportunity
Location Intelligence
Trade Area within ½ mile
9
Businesses Nearby
Explore this area
Business Placement
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
Check the figures for this property
Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics
Frequently Asked Questions
What type of property is this?
Resort - Four guest buildings, a dock, and a sandy beach support lodging operations along Long Lake.
Where is this resort located?
The property is located at 16857 Stardust Road Alpena, MI.
What is the asking price?
The asking price for this property is $749,900.
What are key features of this property?
This property features: Four lodging buildings: a main house and three separate cabins; Each building has 2 bedrooms and 1 bathroom; 3,586 square feet on 0.96 acres
