Newly renovated 2- bedroom home and four 2- bedroom cottages, known as ''Trails End Resort'' in Michigan's beautiful Upper Peninsula with 174' of pristine frontage on Big Manistique Lake. Several upgrades and finishing touches here makes this a perfect home and resort. Some recent upgrade include all new windows, insulation, heating, new electrical, all new appliances, kitchen and bath renovations, and a new (2023)commercial well, well house, water lines and softener for great water quality. Includes a spacious 2-car garage, storage area, storage shed, and fish cleaning house. The property is located on a year round county road facing west offering awesome sunsets. Nestled right in the desirable Cooks Bay just 3 miles from downtown Curtis. Big Manistique Lake is an all season, all sports lake and offers some of the best walleye, perch and northern pike fishing around. Located just outside of Curtis close to the snowmobile trails and many U. P. attractions. This well known, year round resort has many repeat clients and is fully booked for the 2025 summer season with excellent ratings online. Ready for showings now, so make your appointment today. Don't miss out on this great opportunity for an excellent turnkey operation and home. Purchase price includes: new 2024 roll-in dock system, all furnishings, utensils, cookware, grills, kayaks, and lawn furniture. * Linens belong to Family Pride Laundry.
Single-familyProperty Type
1968Year Built
$643Est. Price/Sq.Ft.
Listed by Woods n Water Real Estate, LLC Streeter• Woods N Water Real Estate
Claim this home to receive a free report every month with insights on the changing estimate.
Earn from this home
Rent
$2,461/mo
Redfin rental estimate
List your home for rent
Market trends in 49836, MI
Last updated September 2026
Sale-to-list price
96.9%
0.0% MoM
Median sale price
$305K
$89 MoM
Avg. days on market
65d
5 days MoM
Recently sold homes
12
0 MoM
Provided by Redfin
Sale history for W18466 Hoffy Rd
Date
Event
Price
EUPBR #25-8
Apr 11, 2025
Sold
—
Apr 2, 2025
Pending
—
Jan 22, 2025
Contingent
—
Jan 5, 2025
Listed
$549,900
$458/sq ft
EUPBR #21-772
Sep 17, 2021
Sold
—
Jul 6, 2021
Listed
$379,000
$316/sq ft
+38
Very well maintained home and resort on Big Manistique Lake in Michigan's Upper Peninsula. This is a great Mom and Pop's Resort offering 4 cottages and a two bedroom home. At this time the resort is opened from May 15th thru Dec. 1 but can be operated year round. The property is located at the end of a county maintained road and faces west offering awesome sunsets. Big Manistique Lake is an all season, all sports lake with some of the best walleye, pike and perch fishing around. This property is a great opportunity for someone to have a successful business or a nice family compound.
As the MLS and public records start to fill up, we'll list the details here.
Public record
Beds
—
Baths
—
Stories
—
Lot width
—
Lot depth
—
Lot size
—
Year renovated
—
Sq. Ft.
—
Year built
—
Style
Single Family Residential
County
Mackinac County
APN
010-109-006-00
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on May 22, 2023.
Property details
Interior
Bathroom Information
# of Three Quarter Bathrooms: 10
Interior Features
Window Features: Double Pane Windows
Exterior
Building Information
Sq. Ft.: 1200.0
Above Grade Finished Area: 1,200
Property Features
On Waterfront
Has View
Other Structures: Shed(s)
Property Information
Property Type: Residential
Property Sub Type: Cabin
Raw Mls Property Sub Type: Cabin
Lot Information
Water Body Name: Big Manistique Lake
Lot Size : 0.0
Zoning: Lakeshore
Financial
Tax Information
Tax Annual Amount: $5,017.61
Utilities
Utility Information
Water Source: Well
Sewer: Septic Tank
Location
Location Information
Directions: From Curtis go to the end of town past the school. Turn right on H-42 and go 3 miles to Hoffy Road. Property is at the end of road on right.
Public facts
Beds: —
Baths: —
Sq. Ft.: —
Stories: —
Lot Size: —
Style: Single Family Residential
Year Built: —
Year Renovated: —
County: Mackinac County
APN: 010-109-006-00
Home facts updated by county records on May 22, 2023
Around this home
Schools
Newberry Area School
Public PreK-12 • Assigned • 16.9mi
4/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Historical weather
Germfask, MI • 49836
Average low and high temperatures (°F)
23
10
28
13
37
21
48
31
62
40
74
52
79
57
75
54
69
50
61
39
43
30
29
18
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9 hours in
June and 2.2 hours in December, placing it below the
U.S. average for solar exposure.