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

2280 E Haskell Lake Road
Harrison, MI 48625

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1555 Square Feet
Agency: 43 NORTH REALTY
Agency Phone: (989) 463-1219

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: WELCOME TO YOUR PERFECT NORTHERN HIDEAWAY!! Sprawling over 10 acres and coming in at 1555 sq ft and boasting 3 bedrooms and 2 bathrooms, this totally remodeled home resting on a poured cement foundation is the perfect "Up North" property with an elegant backdrop for the nature enthusiasts or the person that just wants to get away from it all! The exterior of home features new Amish shiplap siding with cedar trim, all sealed with a double coat of 8 year Behr premium waterproofing/sealant! The interior is finished with Amish tongue and groove walls and Bruce brand 3/4 x 2.24 oak hardwood flooring in the kitchen and dining spaces. Stay cool or warm in whatever season with Goodman central air and furnace! The home is also accented nicely with Amish hand hewn and rough cut cedar support beams. Enjoy the peaceful setting while on the outside deck with almost 200 sq ft to rest and relax. The property boasts several out-buildings, including a detached 2-car 40x24 pole barn style garage on a poured cement pad with a workshop, electric garage door opener on small door, plus second door with 10' clearance, 240v panel, and workbench for completing projects! There are two Amish outbuildings: 1) 32x12 with electricity and shelving 2) 30 x 12 with electricity and heat (insulated) Also for those with a green thumb will enjoy the 12 x 16 garden shed perfect for all the planting and lawn maintenance items. Heating in the wintertime is economical with the 7x18 wood shed, when full lasts though the season, owners heated primarily with wood and home furnace was used as back up only, Jacuzzi brand wood stove with triple wall stainless exterior pipe. Feel secure at your new home with Zosi Home security system 24 hr audio/video Web/DVR, vinyl fencing with solar-powered light caps, and gated drive entrance. Be one with nature as you enjoy many mature trees on the property including Beech, Maple, Hickory and more, on the densely wooded walking trails. Owner is accepting cash only!
MlsNumber: --
ListingId: 1924342


Listing Provided By: 43 NORTH REALTY, original listing
Phone: (989) 330-4037
Office Phone: (989) 463-1219
Agent Name: Micah Kemler
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