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 = 1249 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 = 1249 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 = 1249 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;

27996 N Barney's Lake
Beaver Island, MI 49782

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: 5
Baths: 4
Status: Active
SqFt: 2894
Agency: Real Estate One - Charlevoix

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 60 acre(s)
Property Type: Residential
Year Built: --
Notes: Offering a picturesque farmhouse plus a 2226 sq ft. barn with 2 apartments over commercial space on 60 acres of fields and woodlands. This incredible property is located on Barney's Lake Rd, just 5 minutes from town. The Big House has 6 bedrooms and 4 full bathrooms. It was once run as a bed and breakfast called Lazy K Farms. Built with craftsmanship throughout, this home has many amenities - wood floors, wood burning stove, in floor heat (electric boiler installed in 2023, and wood boiler as an additional option), multiple outbuildings, wrap around deck, coral fencing, and an outbuilding for horses. The barn has 2 studio apartments upstairs. New windows installed 2024. The main floor of this building was used as a grooming/kennel at one time. It is still set up like a commercial space. In floor heating is also available in the barn with a wood boiler. There is a stall and storage on the West side of the building that was once used for a horse. The potential for this property is really limitless. The 40 acres to the east could be easily sold for 95k. Sandhill cranes, deer, turkeys and other wildlife are seen daily. Clear open fields would also provide an exceptional view of the starry skies. This is a special property. Don't miss your opportunity to see this one. Please note - this home is an active rental. Showings need to be requested 24 hours in advance. Buyer to honor rental agreements that have been established with long term renters. Contact agent for more details. *Buyer to verify measurements. Floor plans are attached to the listing with seller's docs. If you are interested in the floor plans, please reach out.
MlsNumber: 473560


Listing Provided By: Real Estate One - Charlevoix, original listing
Name: Real Estate One - Charlevoix
Phone: (231) 547-5100
Office Name: Real Estate One - Charlevoix
Office Phone: (231) 547-5100
Agent Name: Sheri Richards
Disclaimer: Copyright © 2024 Northern Michigan MLS. 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