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

288 W Johnson Road
Scottville, MI 49454
Lucas Haltenhoff with Schmidt Realtors, original listing - (616) 844-9000

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $339,900
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1100 Square Feet
Agency: Schmidt Realtors
Agency Phone: (616) 844-9000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Welcome to your new up north get away. 11.5 wooded acres with wildlife galore! The property offers a beautifully updated and renovated three bedroom 1 bath home. The updates include, but is not limited too, all new electrical with 200amp service, all new plumbing, new luxury vinyl planking throughout the house, completely new kitchen, and bathroom. The kitchen update has so many upgraded improvements; Black stainless steel appliances to match, granite countertops, soft close cabinets and drawers, pullout drawers, built-in spice rack and cooking sheet cupboard. With all of the new, the home keeps some awesome old character pieces. The original wood and glass porch door, the bead board front 4 season porch, and the kitchen counter 4x4's are the original white oak posts from the house. The lower level offers you a nice laundry space as well as ample storage. If the basement doesn't have enough storage, then you can visit the 30'w x 52' l x 10'h pole barn. This barn is only a year old, equipped with electrical and prepped for insulation. Three large overhead doors to fit plenty of toys and equipment. Two of the doors have chain drives openers for easy use. The property has 2 other old sheds on the property for additional storage. The home sits just off of US-10 and US-31 allowing for easy access north, south, east, and west to allow access to all the northern Michigan amenities. Do not miss this great opportunity to own an amazingly updated home with acreage. Call today to schedule your private tour.
MlsNumber: --
ListingId: 24062071


Listing Provided By: Schmidt Realtors, original listing
Phone: (616) 502-2869
Office Phone: (616) 844-9000
Agent Name: Lucas Haltenhoff
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. 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