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

5925 E Filion Road
Port Hope, MI 48468
Elizabeth Fleckenstein with Berkshire Hathaway HomeServices Tomie Raines, original listing - (517) 351-3617

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $115,900
Beds: 6
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2460 Square Feet
Agency: Berkshire Hathaway HomeServices Tomie Raines
Agency Phone: (517) 351-3617

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1859
Notes: Incredible opportunity to own a beautiful piece of history! This 200-year-old, 1 family-owned farm sits on 2.5 acres in the center of the beautiful Port Hope, located in Michigan's thumb. Just a few miles from Lake Huron and the border to Canada, just imagine the amazing potential for a Bed and Breakfast, destination wedding venue or that hobby farm you have always dreamed of! The 6-bedroom farmhouse used to house the lumberjacks of Port Hope. When it was built, it was designed as a multi-functional home. One half was home to the family and the other half was used as a unique bunkhouse for the local axmen. Can you imagine a more interesting story and history to tell your guests as they make themselves comfortable in one of the 6-8 eclectic bedrooms? The den offers its own secure entrance, original hardwood floors and a hidden staircase that leads to the second floor. The spacious living room leads to the large deck overlooking the beautiful property. The enormous formal dining room opens to the first-floor Primary bedroom suite, office and kitchen. The adorably eclectic, eat-in kitchen is bright and cheery, with a glorious walk-in pantry that leads to a full bathroom and first-floor laundry room.<br /> Through the office, you will find the second hidden staircase. Up the stairs you go to find 4 bedrooms with sizable closets and a half bathroom that looks like it's straight out of a dollhouse. Just when you think the tour is over, there is more! Through one of the bedrooms, you will find the 5th hidden bedroom. One more surprise, another hidden room through a bookcase! You must see it to believe it! Exploring the property offers even more incredible surprises with the barns, garages and outbuildings. The property has been priced aggressively to reflect some significant deferred maintenance and is being sold AS IS. It will need a new roof, some ceiling repairs due to water damage and a new front porch. Don't miss this amazing opportunity to bring this historic beauty back to its original splendor!
MlsNumber: --
ListingId: 279330


Listing Provided By: Berkshire Hathaway HomeServices Tomie Raines, original listing
Phone: (517) 881-6698
Office Phone: (517) 351-3617
Agent Name: Elizabeth Fleckenstein
Disclaimer: Copyright © 2024 Greater Lansing Association of 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