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 = 1286 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1286 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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 = 1286 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 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;

1851 Wagon Wheel
Negaunee, MI 49866

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $415,000
Beds: 2
Baths: 1
Status: Active
SqFt: 1012
Agency: Call Terry Huffman Co DBA RE/MAX 1st Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 38 acre(s)
Property Type: Residential
Year Built: 2001
Notes: 38 Acres of privacy, great location, two bedrooms with large walkin closets, beautiful wood floors, tile bathroom with nice finishes and skylight, full walkout basement ready for finishing! The home is very bright, big windows, nice decking with views all around. A large extension of your living space really. The photos depict the living space layout - open floorplan. Nice, spotless kitchen with stainless appliances, dishwasher, oak cabinets, slate floor, lots of storage. Washer/Dryer on living level. Let's talk about the pole building- barn, with heated office, 5 stables, loft, washing area, indoor arena. The barn features #5 stalls with drop down doors, outlets for each, fans. Wash rack area with hot/cold water and drain, feeding room, loft up. If you are looking for horse use kind, you will enjoy the legal size area with custom designed footing for traction, water resistance and control dust. Do you want this for yourself? Teach classes? Storage? Machinery? Lumber work? Hunting? Construction equipment? Hobby Farm? Storage for your friends or family? Gardens? Llamas, goats, horses, or ducks? Sledding -Mushing type? Do you need pastures, outdoor riding arena, exercise spaces, individual paddocks with run ins. Don't wait! Schedule your showing and start living here for summer! The diagrams are Cubicasa measured. Note they are excluding areas on the diagram in square footage on barn. There are additional structures too. Directly off M35 with Negaunee mailing, however Forsyth Township property. North South East West...neutral location. Down the road to the Middle Branch Escanaba River and the launch/parking areas. Wagon Wheel is off M35 and is a County Seasonal road that is maintained by the residents, sharing condition (sand/grading/snow). It's very nice. It's a peaceful property, nicely taken care of! The appliances are included in sale. This home and parcel will appeal to different housing and use options. Depends on your need. You must schedule a showing with 24 hour notice if possible, and supply a prequalification letter with any offer from your lender, or if cash offer, proof of funds required. Schedule your showing, because you cannot just pop out there and walk around.
MlsNumber: 50139970


Listing Provided By: Call Terry Huffman Co DBA RE/MAX 1st Realty, original listing
Name: Call Terry Huffman Co DBA RE/MAX 1st Realty
Phone: (906) 225-1136
Office Name: RE/MAX 1ST REALTY
Office Phone: (906) 225-1136
Agent Name: SUZANNE PETSCHKE
Disclaimer: Copyright © 2024 Upper Peninsula 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