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

8300 Se Campbell
Fife Lake, MI 49633
Tammy Jarvis with Key Realty One-TC, original listing - (517) 827-2120

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $373,000
Beds: 4
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1340 Square Feet
Agency: Key Realty One-TC
Agency Phone: (517) 827-2120

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1920
Notes: Discover the perfect blend of rustic charm and serene country living with this enchanting 1920s farmhouse nestled on 40 acres in the tranquil setting of Fife Lake, MI. Located at 8300 SE Campbell Rd, this property offers a peaceful retreat with the convenience of nearby amenities. Step inside to find 1,340 square feet of living space, featuring four cozy bedrooms and one & a half baths. The home retains its vintage charm, awaiting your personal touch. The upstairs area, spanning 720 square feet, is mostly gutted and presents a blank canvas ready for your creative vision. Additionally, there is an unfinished basement providing ample storage space. Being sold AS-IS The original fieldstone-covered porch welcomes you to this charming farmhouse. The yard is partially shaded, offering a cool retreat during warmer months. The property is predominantly wooded, with trails winding through the picturesque landscape, perfect for nature enthusiasts. A spacious 36x46 barn with a lean-to, an additional pole barn, and multiple other outbuildings provide ample storage and project space for all your needs. Situated in a quiet, country setting, this property is just a few miles from the beautiful Manistee River and surrounded by abundant state-owned land, making it a haven for outdoor enthusiasts. The area is renowned for its excellent hunting opportunities, adding to the appeal for nature lovers and sportsmen alike. Embrace the potential of this character-filled farmhouse and create your dream country home. Schedule a viewing today to experience the tranquility and charm of this unique property in Fife Lake, MI.
MlsNumber: --
ListingId: 1924217


Listing Provided By: Key Realty One-TC, original listing
Phone: (231) 342-9937
Office Phone: (517) 827-2120
Agent Name: Tammy Jarvis
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