Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1248 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1248 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1248 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

57440 M-40
Marcellus, MI 49067
Matthew Miller with Real Broker, LLC, original listing - (517) 200-3245

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: --
Baths: Full: 5
Status: Active
SqFt: 2000 Square Feet
Agency: Real Broker, LLC
Agency Phone: (517) 200-3245

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 9 acre(s)
Property Type: Commercial Sale-Business
Year Built: 2020
Notes: Discover the perfect cabin rental escape at Winding Creek Cabins, where comfort meets natural beauty in the serene landscapes of southwestern Michigan. Located amidst the splendor of this region, our five newly constructed cabins, built in 2020, offer year-round, climate-controlled interiors that provide captivating views and the tranquil sounds of our spring-fed winding creek.<br /> <br /> Each cabin accommodates up to four guests and features a well-equipped kitchenette and a full restroom with a walk-in shower. We provide towels, linens, free Wi-Fi, and two parking spaces for your convenience. Whether you're planning a summer getaway, a fall foliage adventure, or a winter retreat for skiing and snowboarding at nearby Swiss Valley. Winding Creek Cabins offers the ideal base for all your Michigan adventures.<br /> <br /> Surrounded by lakes, wedding venues, walking trails, and ample opportunities for seasonal hunting with access to 250 acres of public hunting land, you'll find endless recreational possibilities just steps from your cabin door. Plus, with the potential to add five more cabins to this fantastic property, you can maximize your revenue with all zoning, site plans, and approvals already in place.<br /> <br /> Don't miss the chance to experience the best of Michigan's wineries, restaurants, and events while enjoying the comfort and convenience of Winding Creek Cabins. Whether you're looking to expand your rental portfolio or join the Airbnb community, this property has it all, making it a perfect investment opportunity in a breathtaking natural setting. Call JR Johnson at 708-280-7017 or Matthew D. Miller at 269-267-7406 to set up a time to view this fantastic property.
MlsNumber: --
ListingId: 24031002


Listing Provided By: Real Broker, LLC, original listing
Phone: (269) 267-7406
Office Phone: (517) 200-3245
Agent Name: Matthew Miller
Disclaimer: Copyright © 2024 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App