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

694 W Esmond Road
Rose City, MI 48654

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,490,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3573
Agency: Benjamin Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 208 acre(s)
Property Type: Residential
Year Built: 1980
Notes: 4 BEDROOM 4 BATH HOME ON 208 ACRES WITH GUEST LOG CABIN! Been searching for the property that checks your boxes? 208 prime acres with streams (trout present), several artesian springs, a perfect mix of hardwoods, cedar (some thick!) & conifers, small marsh areas, trail system throughout, food plots, several Shadow Hunter blinds (some elevated) and ladder stands, dozens of fruit trees scattered throughout, and bordering agriculture land ... check. An approx. 1.5 acre aerated pond with a bridge to an island, a fountain, and completely encompassed with a steel seawall ... check. A 40x50 barn on a concrete slab with its own water well, stables, electric, and an approx. 1.2 acre fenced in pasture area .... check. Three other large (30x40, 18x24, 32x47) outbuildings for equipment storage .... check. A cement slab with electric and water hookup for a camper ... check. Root cellar ... check. A dyed concrete driveway leads up to the 3573 sq. ft. home (aka, "The Lodge") that has been meticulously remodeled and sits within a large, park like yard (with an in ground sprinkler system), overlooks the pond, and there are large windows throughout the home offering fantastic views. There are four wood burning fireplaces, three of them located in bedrooms, and two of the bedrooms have their own entertainment/lounging area within them. The home also boasts an almost 2200 sq. foot attached garage with a coated concrete floor that has been finished into the ultimate "man cave", with its own wood burning stove, full bathroom and workshop. Also included is an adorable 768 square foot full log 2 bedroom 1 bath cabin with a wood burning stove and steel roof. This property is as unique as they come and would make an incredible place to retire or to have the ultimate hunting camp, and the property is conveniently located on a dead-end road about half way between West Branch and Rose City and very close to ORV and Snowmobile trail systems. Once you're there, you won't want to leave!
MlsNumber: 1919892


Listing Provided By: Benjamin Realty, original listing
Name: Benjamin Realty
Phone: (989) 685-2414
Office Name: BENJAMIN REALTY
Office Phone: (989) 685-2414
Agent Name: CHRIS DACK
Disclaimer: Copyright © 2024 Northern Great Lakes Realtors 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