Sign up to get new listings emailed daily! JOIN SIGN IN
Karla Humm
REALTOR®
Facebook Icon 

16857 Stardust Road, Alpena, MI 49707

$749,900
  • 16857 Stardust Road, Alpena, MI 49707 Main Photo

80 Photos

New to the Market Active
SQUARE FEET3,586 MLS#201843530
STATUSActive PROPERTY TYPECommercial - Business SUBDIVISIONT33N R8E

Property Description

This unique Long Lake resort offers an exceptional opportunity to own and operate a turnkey waterfront business on nearly an acre of land. The property includes a main house and three separate cabins, with each building featuring 2 BRs and 1 bathroom, providing comfortable accommodations for guests. The main home is large and includes a laundry area and a spacious bonus room ideal for storage, supplies, and preparing for new arrivals. Additional amenities include a det, garage, a sandy beach area, grassy area for games, paved driveway and a large dock perfect for enjoying the lake. With its desirable waterfront setting, multiple guest accommodations, and established business use, this property is well suited for continued resort operations or a variety of investment possibilities.

16857 Stardust Road | MLS# 201843530

This commercial property located at 16857 Stardust Road, Alpena, MI 49707 is currently listed for sale with an asking price of $749,900. Search Alpena real estate on www.karlahummrealtor.com today.

Property Features

Property Type: Commercial - Business
Lot Size: 0.96 Acres

Feature Descriptions

Body of Water: Long Lake
Date active: 2026-10-26
Days on Site: 1
Exterior: Block
Extras: Living Quarters
Financing Available: Cash, Conventional Mort
Lot Dimensions: 147x295x106x357
Parcel Number: 122-053-000-006-00
Parking Features: Parking Lot
Road Surface: Dirt, Paved
Sewer: Septic Tank
Water: Well, Separate

Listed By / Shown By

Listed By

Agency Name: RE/MAX New Horizons
Agency Phone: 989-358-1144

Shown By

Agent Name: Karla Humm
Agent Phone: (231) 629-1042
Agency Title: Key Realty

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 10/29/2026. The listing information on this page last changed on 10/29/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 10/29/2026 12:14:12 AM EST) or MichRic (Michigan Regional Information Center) (last updated Wed 10/28/2026 6:49:00 AM EST) or Metrolist - RECOLORADO by MLSGRID (last updated Wed 10/28/2026 11:34:29 PM EST) or MRED MLS (last updated Thu 10/29/2026 12:09:01 AM EST) or NIRA MLS (last updated Wed 10/28/2026 11:05:12 PM EST) or RealComp MLS (last updated Thu 10/29/2026 12:05:17 AM EST) or Dayton MLS (last updated Wed 10/28/2026 11:46:52 PM EST) or NORIS MLS (last updated Wed 10/28/2026 11:16:05 PM EST) or Colorado Real Estate Network IDX (last updated Wed 10/28/2026 7:06:14 PM EST) or CBRMLS (last updated Thu 10/29/2026 12:09:46 AM EST) or Multiple Listing Service of Greater Cincinnati (last updated Wed 10/28/2026 11:53:38 PM EST) or Terrehaute MLS (last updated Thu 10/29/2026 12:11:20 AM EST) or elevate MLS (last updated Wed 10/28/2026 11:59:57 PM EST) or Stellar MLS (last updated Thu 10/29/2026 12:09:54 AM EST) or NKY MLS (last updated Wed 10/28/2026 11:29:50 PM EST) or Wrist MLS (last updated Wed 10/28/2026 11:26:55 PM EST) or Firelands MLS (last updated Wed 10/28/2026 11:13:03 PM EST) or LCAR MLS (last updated Wed 10/28/2026 10:51:50 AM EST) or West Central MLS (last updated Wed 10/28/2026 9:57:32 PM EST) or Fort Myers (last updated Wed 10/28/2026 11:04:58 PM EST) or Aspen/Glenwood Springs MLS (last updated Wed 10/28/2026 9:31:00 PM EST) or Northern Nevada Regional MLS (last updated Thu 10/29/2026 12:11:46 AM EST) or MLS NOW (last updated Thu 10/29/2026 12:12:37 AM EST) or Northern Great Lakes Association of Realtors (last updated Thu 10/29/2026 12:04:27 AM EST) or Mansfield MLS (last updated Wed 10/28/2026 11:47:26 PM EST) or Metropolitan Indianapolis Board of Realtors (last updated Thu 10/29/2026 12:06:39 AM EST) or Grand Junction MLS (last updated Wed 10/28/2026 11:37:12 PM EST) or Knox County MLS (last updated Wed 10/28/2026 11:10:07 PM EST) or IRMLS (last updated Wed 10/28/2026 11:13:08 PM EST) or Upper Peninsula MLS (last updated Wed 10/28/2026 11:14:52 PM EST) or Greater Lansing MLS (last updated Wed 10/28/2026 10:41:13 PM EST) or SEBAR MLS (last updated Wed 10/28/2026 11:39:19 PM EST) or Water Wonderland MLS (last updated Wed 10/28/2026 10:54:55 PM EST) or Eastern Upper Peninsula MLS (last updated Thu 10/29/2026 12:01:08 AM EST) or Scioto Valley MLS (last updated Wed 10/28/2026 10:02:40 PM EST) or Northern Michigan MLS (last updated Wed 10/28/2026 9:34:10 PM EST). Real estate listings held by brokerage firms other than Key Realty may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Agency License Information: 1-877-539-7589 | Ohio Lic# REC.2010002888 6800 W Central Ave #B, Toledo, OH 43617 | Michigan Lic# 6505366134 8040 Summerfield Rd, Lambertville, MI 48144 | Indiana Lic# RC52400106 3029 W Smith Valley Rd #211, Greenwood, IN 46142 | West Virginia LIC# 010306 Erin Rickman, Broker. 410 Market St #3, Parkersburg, WV, 26101 | Colorado LIC# EC.100108419 603 Rood Ave, Grand Junction, CO 81501 | Nevada LIC# B.0146350.LLC 9190 Double Diamond Pwky, Reno, NV 89521 | Florida LIC# CQ1073507 16638 Mooner Plank Cir, Wimauma, FL 33598 | Illinois LIC# 481014661 640 S Washington St. Suite 212, Naperville, IL 60540



Agent License Information:  Brokerage/Company License Number: MI-65-05366134

Login to My Homefinder