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

6368 County Road 441
Newberry, MI 49868
Jilane Fenner with ERA Greater North Properties, original listing - (231) 779-8088

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,900
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1800 Square Feet
Agency: ERA Greater North Properties
Agency Phone: (231) 779-8088

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1973
Notes: Large 4 bedroom, 2 bath home with oversize 2 car garage that has a nice work bench area. Home is located just outside of town with nice country feel. Main floor has Living room, kitchen, bathroom & 2 bedrooms. Living room is huge! With brick wood burning fireplace & lots of windows w/blinds. Very large & spacious kitchen with many Schrock Cabinets that go all the way to the ceiling & space enough for a big dining room table, too! There's a pantry plus many cabinets that have pull out shelves & there are solid surface counter tops. 2 nice size wood floor bedrooms on main floor with a large remodeled bathroom that has a 5' walk-in shower with grab bars & large pantry style cabinet. Home has lots of storage & closet space. There's even a spacious breezeway between the kitchen & garage. Upstairs has 2 more bedrooms & full bath with tub. Bedrooms have closets & dormers with ample storage available. 1 bedroom has a single bed built with cubby hole space below to store sheets & linens. Nice .85 acre lot that has garden/storage shed out back & 2 raised garden beds. Plus there are 3 Apple trees & a Pear tree! Home setting is rather secluded. There's a 16 X 24 deck & a ramp for handicap access plus Seamless rain gutters with 1 side that has leaf filter where pine needles like to fall. Also included is a hot tub & a full house generator! Come & enjoy this roomy home. It's great for some solitude as well as a great place for a large gathering of friends & family!! NO showings from Sundown Friday to Sundown Saturday.
MlsNumber: --
ListingId: 1927012


Listing Provided By: ERA Greater North Properties, original listing
Phone: (231) 920-8888
Office Phone: (231) 779-8088
Agent Name: Jilane Fenner
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