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;

511 W Sharon Road, Sw
Fife Lake, MI 49633

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 3
Baths: 2
Status: Active
SqFt: 2700
Agency: Real Estate One, Inc.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1904
Notes: Welcome to this charming 2-story home nestled on a private .60-acre wooded lot, just 10 miles from the charming Village of Fife Lake! Enjoy the best of both worlds - the tranquility of a rural setting and the convenience of nearby amenities. This spacious home boasts over 2,700 square feet of living space, with 3 bedrooms and 2 bathrooms. The interior hardwood flooring in the oversized living room and dining room, as well as a cozy new gas fireplace to warm up on chilly evenings. The kitchen has all the necessary appliances, including a range, oven, refrigerator, new dishwasher, and new microwave. The heating system is only two years old! The large laundry room is on the main level. Outside, you'll find a large 30x40 pole barn, perfect for storing outdoor gear or hobbies. The home's exterior features low-maintenance vinyl siding and a new metal roof. A spacious deck offers the ideal relaxing spot for taking in the serene surroundings. The property is situated on a publically maintained road, and the village of Fife Lake is just a 10-minute drive away, offering a variety of shops, restaurants, and services. The plethora of nearby state forest land provides endless recreational opportunities, from hunting and ice fishing to swimming and hiking. The Fife Lake boat launch is just 10 miles from home, giving you access to this 617-acre, all-sports lake with two islands and plenty of boating, fishing, and water sports opportunities. Additional features of this home include a private well, a private septic system, and propane gas. The Point-of-Sale Inspection has been ordered. Immediate possession is available. This affordable opportunity to own a piece of paradise in Northern Michigan is here! Conveniently situated 25 miles from Traverse City and 30 miles from Cadillac. This home is priced to sell quickly. Sold "as is."
MlsNumber: 1921398


Listing Provided By: Real Estate One, Inc., original listing
Name: Real Estate One, Inc.
Phone: (231) 946-4040
Office Name: REO-TCFront-233021
Office Phone: (231) 947-9800
Agent Name: Erica Marshall
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