BEDS4
BATHS4 full 1 partial
SQUARE FEET3,031
MLS#26028264
STATUSActive
PROPERTY TYPEResidential - Single Family
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: Residential - Single Family
Basement: Crawl Space, Partial
Cooling: Window Unit(s)
Fenced: Yes
Fireplaces: 1
Garage: 5
Heating: Forced Air, Hot Water
Home Style: Ranch
Lot Size: 3.38 Acres
Roof Type: Shingle
Taxes: $7,982
Year Built: 2021
Feature Descriptions
Appliances: Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer
Days on Site: 2
Exterior: Vinyl Siding
Fencing: Fenced Back, Front Yard
Fireplace: Living Room
Fireplace Y/N: Yes
Flooring: Carpet, Wood
Interior: Ceiling Fan(s), Broadband, Garage Door Opener, Eat-in Kitchen
Lake Name: Mud Lake
Laundry: Main Level
Lot Dimensions: 430x545
Parcel Number: 000-20-25-302-005-00
Parking: Garage Faces Front, Garage Door Opener, Detached
Patio/Porch: Covered, Deck, Porch(es)
Road Surface: Unimproved
Rooms Total: 16
Sewer: Septic Tank
Structures: Second Garage, Shed(s), Guest House, Pole Barn
Sub Type: Single Family Residence
Utilities: Phone Available
Water: Well
Waterfront: Lake
Window: Screens, Insulated Windows, Window Treatments
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: Darrell Blausey
Agent Phone: (419) 351-1525
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/13/2026. |
Estimate Your Payment
Estimated Payment
$ 4,784.93 per month $3,915.60 Principal & Interest $665.17 Property Tax $204.17 Homeowner's Insurance
11808 Beech Road, Unit 11822 | MLS# 26028264
This single family home located at 11808 Beech Road, Unit 11822, Brooklyn, MI 49230 is currently listed for sale with an asking price of $700,000. This property was built in 2021 and has 4 bedrooms and 4 full and 1 partial baths with 3031 sq. ft. Beech Road, Unit 11822 is located within the Columbia school district. Search Brooklyn real estate on www.darrellrealestate.com today.