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

44232 Paradise
Chassell, MI 49916

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $580,000
Beds: 3
Baths: 2
Status: Pending
SqFt: 2050
Agency: Douglass Real Estate, Inc DBA RE/MAX Douglass Real

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential
Year Built: 2015
Notes: PARADISE ON PARADISE,This is an incredible, custom built 3 bedroom, 2 bath home on 10 acres, built in 2015. The exterior walls are constructed with insulated concrete forms (ICF) and has triple pane H windows making this home extremely energy efficient and quiet. The home features a modern, open concept with gorgeous polished concrete floors. The kitchen features stainless steel appliances, a walk in pantry, and a large kitchen island, set up perfectly for entertaining. The master suit is the perfect blend of luxury and comfort, with a large master bath, floor to ceiling tiled walk in shower, and custom built-in master closet. A unique L-shaped 3 car garage offers a 1 car heated space with utility sink, plus the utility room behind. An additional 2 car space is also attached to the utility/entry room. The guest house with wood fired sauna, provides a Murphy bed, separate shower and toilet plus an exterior covered storage area. The outdoor area is beautiful, with a concrete patio that is perfect for relaxing plus a fenced garden, fire pit and large storage container. Eight minutes from Houghton and 5 minutes from 4 hiking, biking and skiing trails makes this convenient for all your needs. The classic stone pillared entry gate has not been used by the seller. An interesting TV holder for over the master bed is behind the picture above the bed. Seller prefers occupancy after July 15th. Security cameras are installed and present on property and buyers and agents consent to being recorded by entering property. All information believed accurate but not warranted. Buyer recommended to inspect all aspects of the property & bears all risks for any inaccuracies. Buyer to verify all information including but not limited to the estimated acreage, lot size, square footage, utilities (availability & costs associated). Taxes may change upon sale. 72 hour response time on all offers. Pre-qualification letter or proof of funds to accompany all offers. Seller reserves the right to change response time with or without notification.
MlsNumber: 50141623


Listing Provided By: Douglass Real Estate, Inc DBA RE/MAX Douglass Real, original listing
Name: Douglass Real Estate, Inc DBA RE/MAX Douglass Real
Phone: (906) 482-1000
Office Name: RE/MAX DOUGLASS R.E.-H
Office Phone: (906) 482-1000
Agent Name: GINGER STROUBE
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