Search
Waterfront Short-Term Rental Property
For Sale
$550,000
Pending

226 N 176th Avenue, Walkerville, MI 49459

Commercial Sale, Walkerville, MI

Property Size3,000 SF
Lot Size2.90 Acres
Days on Market368

Property Features for 226 N 176th Avenue

General Information

Property type Commercial Sale
Property subtype Other
Zoning description no zoning
Bathrooms 3
Full bathrooms 3
Rooms Bathroom 1, Bathroom 2, Bathroom 3
Elementary school district Hesperia
Middle school district Hesperia
High school district Hesperia
Directions From Hesperia Head West on M20 to 192nd North to E. Scout Rd West Curve around onto N. 184th Ave North to Curve around onto E. Fillmore Rd. West to 176th Ave to Home/Resort.
Subdivision MasonOceanaManistee - O
Standard status Pending
APN 009-032-400-04
Size 3,000 SF
Lot size 2.90 Acres

Taxes and HOA fees

Tax Year 2025
Tax Description Long Legal on file. New legal coming. See proposed split Parcel B
Tax Annual Amount 6545
Legal Description Long Legal on file. New legal coming. See proposed split Parcel B

Utilities

Utilities Propane
Sewer type Septic Tank
Heating system Baseboard, Hot Water(Heating), Radiant
Water source Well
Water front features Lake
Water front 1

Amenities

sandy beach
dock
fishing
swimming
kayaking
green house
outdoor wood burner
garden shed
covered woodshed

Building Details

Year built 1958
Number of units 3
Building materials Vinyl Siding, Stone
Roof type Composition, Metal
Listing Agency: Five Star Real Estate GH
Listed By: Patti Styburski · License #6501280679
Added: Sep 9, 2025 Changed: Sep 7 Last Checked: Sep 11 at 6:06AM
MLS# 25046185

Copyright © 2026 Michigan Regional Information Center, LLC. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Investment Insights

Based on property information with market context.

This waterfront short-term rental property combines a 2,904-square-foot primary home with two furnished cottages and three RV campsites on 2.9 acres along Little Campbell Lake. The main residence includes six bedrooms, three full bathrooms, a home office, gym, and a 23-by-12-foot bonus room above the garage that can serve as additional sleeping space or recreation area.

Outdoor amenities include a sandy beach, dock, and lake access for fishing, swimming, and kayaking. The property also features a 24-by-16-foot, two-story garden shed with electric, a 12-by-16-foot covered woodshed, greenhouse, and outdoor wood burner for backup heat. Two RV sites have full hookups, while a third includes site electric. The cottages have repeat rental customers. Built in 1958, the property is served by a well, septic tank, and propane utilities.

Key Highlights

  • 2.9‑acre waterfront property on Little Campbell Lake
  • 2,904‑square‑foot primary home with 6 bedrooms and 3 full bathrooms
  • Two furnished cottages with repeat rental customers

Property Analytics

Unlock full access to Insights Subscribe to Realmo Intelligence
Open Analytics

Current Use

Last Resort Hotel & Motel

Suggested Use

Top Pick Pet Store & Service 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

3
Residential units

Location Intelligence

Trade Area within ½ mile

5
Businesses Nearby

Demographics for 49459, MI

1,451
Population
940
Households
1.5
Avg Household Size
40
Median Age
14%
College-Educated
87%
High-School Grad
79.3 sq mi
ZIP Area
18
Density / Sq Mi
$57,773
Median Household Income
$35,179
Median Earnings
$1,037
Median Rent
$98,300
Median Home Value
Check the figures for this property Cap Rate, Value Estimation, Potential NOI and more
View Realmo Analytics

Market

Vacancy Rate% for Multifamily in Midwest region

6.5% 2022
7.5% 2023
7.8% 2024
8% 2025
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?
Short term rental property - Lakefront property with a primary residence, two furnished cottages, and RV camping accommodations.
Where is this short term rental property located?
The property is located at 226 N 176th Avenue Walkerville, MI.
What is the asking price?
The asking price for this property is $550,000.
What are key features of this property?
This property features: 2.9‑acre waterfront property on Little Campbell Lake; 2,904‑square‑foot primary home with 6 bedrooms and 3 full bathrooms; Two furnished cottages with repeat rental customers
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