TammyJarvis
BEDS0
BATHS
MLS#26028272
STATUSActive
PROPERTY TYPEMulti Unit - Multiple
SCHOOLColumbia
Property Description
This lakefront investment opportunity offers immediate and diversified income across three parcels, making it ideal for owner-occupied investors or general investors alike seeking both cash flow and long-term appreciation.Parcel 1 includes a three-bedroom, one-bath primary residence along with a large pole barn featuring a party loft and hot tub--an attractive amenity for short-term or seasonal rental potential. Parcel 2 provides a one-bedroom, one-bath guest house with a garage, creating an additional standalone income stream. Parcel 3 is a licensed State of Michigan campground with 15 rentable sites, each equipped with individually metered electric service, plus bathhouses and a dock, supporting consistent and scalable rental revenue.With a total of 17 income-producing units and strong appeal for vacationers, campers, and short-term renters, this property is well-positioned for steady cash flow and future growth. A rare chance to acquire a multi-use waterfront asset.
Property Features
Property Type: Multi Unit - Multiple
Basement: Crawl Space, Partial
Cooling: Window Unit(s)
Heating: Forced Air, Hot Water
Lot Size: 3.38 Acres
Roof Type: Other
Taxes: $7,982
Year Built: 2021
Feature Descriptions
Days on Site: 1
Exterior: Vinyl Siding
Lake Name: Mud Lake
Laundry: Main Level
Lot Dimensions: 430x545
Owner Pays: Trash Collection, Electricity, Gas
Parcel Number: 000-20-25-302-005-00
Parking: Aggregate, Driveway
Parking Total: 34
Road Surface: Unimproved
Sewer: Septic Tank
Sub Type: 5+ Units
Tenant Pays: Electric, Gas
Units: 16
Utilities: Phone Available, Electricity Connected
Water: Well
Waterfront: Lake
Local Schools
School District: Columbia
Listed By / Shown By
Listed By
Agency Name: Coldwell Banker Beiswanger Realty Group
Agent Name: Doug Beiswanger
Agency Phone: 517-435-1500
Shown By
Agent Name: Tammy Jarvis
Agent Phone: Cell: (231) 342-9937
Agency Title: Key Realty
 | The property comes from the Member MLS's of the Michigan Regional Information Center, LLC (MichRIC). Copyright 2026 Michigan Regional Information Center, LLC (MichRIC). All rights reserved. Information deemed reliable, but not guaranteed. Data Last Updated 06/11/2026. |
Estimate Your Payment
Estimated Payment
$ 4,784.93 per month $3,915.60 Principal & Interest $665.17 Property Tax $204.17 Homeowner's InsuranceChange Payment Information
Privacy Policy / DMCA Notice / ADA Accessibility
This site is hosted, designed and copyright
© 1994 - 2026 by
Delta Media Group, Inc. -- Patent Pending --
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
11808 Beech Road, Unit 11822 | MLS# 26028272
This multi-family property located at 11808 Beech Road, Unit 11822, Brooklyn, MI 49230 is currently listed for sale with an asking price of $700,000. Beech Road, Unit 11822 is located within the Columbia school district. Search Brooklyn real estate on tammyjarvis.ikeyrealty.com today.