- 6 beds
- 3 baths
- 2,064 sqft
- ~50 acre lot
- $569 per sqft
- 1958 build
- – on site
Welcome to the Last Resort! 50 acres on Little Campbell Lake. The main home has 6 bedrooms and 3 full baths. The open floorplan with gas fireplace and cathedral ceiling is great for entertaining guests. Custom wood trim. The attached garage is insulated with a bonus room above it for additional storage or a hobby room.. Two rustic cabins that are currently rented in the Summer weekly for extra income. The waters edge has small sandy beach area, dock and a swimming raft. There is a large barn with a woodshop above. There is a big shred plus a greenhouse and a garden. The rolling mix of woods in the ''Back 40'' acres has walking trails, 2 ponds/wetland areas and food plots making it abundant with wildlife. This would be a great family retreat spot or a possible campground.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 15, 2025
•
MLS# 25027008 —
This home is listed in more than one place. See it here.
The Building
-
Year Built:1958
-
New Construction:false
-
Construction Materials:Vinyl Siding
-
Building Features:None
-
Building Area Total:2064.0
-
Architectural Style:A-Frame
-
Roof:Composition
-
Foundation Details:None
-
Stories:2
-
Basement:No
-
Basement:Full
-
Basement:Yes
-
Common Walls:None
-
Window Features:Insulated Windows
-
Patio And Porch Features:Deck
-
Accessibility Features:No
-
Direction Faces:None
-
Exterior Material -Vinyl Siding:true
-
Roofing -Composition:true
Interior
-
Interior Features:Center Island
-
Flooring:Tile, Wood
-
Rooms Total:8
-
Total Fireplaces:1.0
-
Fireplaces Total:1
-
Fireplace:true
-
Fireplace Features:Gas Log
-
Fireplace -Gas Log:true
-
Furnished:None
Room Dimensions
-
Living Area:2904.0
-
Total Lower SqFt:840.0
-
Main Level SqFt:1632.0
-
Upper Level SqFt:432.0
Financial & Terms
-
Ownership:Private Owned
-
Listing Terms:Cash, Conventional
Location
-
Directions:East Filmore Rd South on 176th to home on right (West ) Side. Look for the Last Resort on google Maps.
-
Cross Street:N Beech Ave
-
Latitude:43.646377
-
Longitude:-86.120265
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:No
-
Current Use:None
-
Parcel Number:00903240004
-
Zoning:None
-
Exterior Features:Balcony
-
Lot Features:Adj to Public Land
-
Lot Size SqFt:2178000.0
-
Lot Size Acres:50.0
-
Lot Size Area:50.0
-
Lot Size Units:Acres
-
Topography:None
-
Waterfront:true
-
View:None
-
View:No
-
Inclusions:None
-
Possible Use:None
-
Frontage Type:None
-
Water Access:Yes
-
Water Body Name:Little Campbell Lake
-
Waterfront:Yes
-
Waterfront Features:Lake
-
Road Surface Type:Paved
-
Road Frontage:399.0
Listing Agent
- Contact info:
- Agent phone:
- (231) 510-2072
- Office phone:
- (877) 820-1194
Taxes
-
Tax Year:2022
-
Tax Year:2022.0
-
Tax Legal Description:226 N 176TH AVE MLC832324 WD8715426 SPL FR 400-03 IN 83 SEC 32 T15N R15W. 10 A AND . TD-L2003P22420 COMBINED WITH 400-02 IN 1981 SEC 32 T15N R15W-- N 660 FT OF W 1/2 OF SE 1/4 & N 660 FT OF GOVT LOT 1. 40 A
-
Tax Annual Amount:6146.0
-
Annual Property Taxes:6146.0
-
Tax Assessed Value:190442
-
Taxable Value:190442.0
Beds
-
Bedrooms Total:6
-
Main Bedrooms:2
-
Main Level Bedrooms:2
Baths
-
Total Baths:3
-
Total Baths:3.0
-
Partial Baths:None
-
Full Baths:1
-
Full Baths:1
-
Full Baths:3
-
Full Baths:1
-
Three Quarter Baths:None
-
Quarter Baths:None
The Listing
-
Virtual Tour URL Branded:None
Heating & Cooling
-
Cooling:No
-
Heating:true
-
Heating:Baseboard, Hot Water, Outdoor Furnace
-
Heat Type -Baseboard:true
Utilities
-
Utilities:Electricity Available, High-Speed Internet
-
Sewer:Septic Tank
-
Sewer/Septic System:true
-
Water Source:Well
-
Well:true
Appliances
-
Appliances:Cooktop, Dryer, Microwave, Oven, Refrigerator, Washer
-
Refrigerator:true
-
Oven:true
-
Cook Top:true
-
Microwave:true
-
Washer:true
-
Dryer:true
-
Laundry Features:In Basement
Schools
-
Elementary School District:None
-
Middle Or Junior School District:None
-
High School District:Walkerville
The Community
-
Association:No
-
Pool Private:No
-
Senior Community:No
Parking
-
Parking Total:None
-
Parking Features:Garage Faces Side, Garage Door Opener
-
Garage:true
-
Garage Spaces:2.0
-
Attached Garage:false
-
Carport Spaces:None
Monthly cost estimate

Asking price
$1,175,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$6,291
|
Taxes | $512 |
Insurance | $323 |
Utilities | $204 See report |
Total | $7,330/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.