Gloria Pearson
Cell: (734) 330-6744
Cell: (734) 330-6744
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
Stories: 1.0
Taxes: $7,982
Year Built: 2021
Feature Descriptions
Appliances: Dishwasher, Dryer, Microwave, Oven, Range, Refrigerator, Washer
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: Gloria Pearson
Agent Phone: Cell: (734) 330-6744
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/10/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
Agent License Information: Brokerage/Company License Number: MI-65-05366134
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.gpknowrealestate.com today.