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','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 = 1286 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 = 1286 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;

16100 Co Rd 510
Marquette, MI 49855

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $740,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1160
Agency: WHITE WATER REALTY

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 80 acre(s)
Property Type: Residential
Year Built: 1998
Notes: Contractor says: if rebuilt new price would be 1.2 to 1.8 million for the cabin only. Earth House is incomplete but interesting. It needs painting, vines, whatever. Land is simpler too price, mountain views running length of property. Comparable sale is 40 acre mountain view, cut over timber, $152,000, so 80 acres I have is more views and not cut timber therefore +$300,000 for land only. This is easy. Earth House is 30' x 40'. unknown price below $100,000 Cabin is so difficult to price due to hand crafted and artistry. You'll see if looked at. Career long realtor friend says; "5 different appraisers would have 5 different prices". What a problem? Yet seller is willing to look at offers. Opportunity to continue a legacy, some say. Sometimes, here on data, counts include both structures. example room combined is 11 - 19. Mostly data is cabin, very little data on earth house, because I cannot figure out this format, so ask . +7 rooms in earth house. Earth House: 8 to 14 exterior walls are insulated with sand and pink board, the remainder is mixed insulation. The sand is a heat sink, acting as thermo mass for the benefit of heating the structure for the winter. It is toasty warm inside. Heat source is a wood stove with endless firewood from the 80 acres. The sand is about 7 inches thick on those given entire outside walls, and then insulated outside the sand, trapping it somewhat in order to hold the heat. And it does. Not only is the structure the principles of the earth house, but and additional heat sink. The cabin is endless to talk about, so ask if interested. I like to talk about it. On monies, another high perspective or view is: cabin 1.2 to 1.8, average cabin 1.5 million timber 100,000 land 300,000 earth house 100,000 total 2 million plus if at a high price which some people developers would pursue. A low might or may be $500,000 (who knows). The asking price is $740,000 Seller is looking for offers.
MlsNumber: 50085291


Listing Provided By: WHITE WATER REALTY, original listing
Name: WHITE WATER REALTY
Phone: (810) 476-3246
Office Name: WHITE WATER REALTY
Office Phone: (906) 360-1637
Agent Name: RICHARD HENDRICKSEN
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