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

8051 Glade Valley Road
Rapid City, MI 49676
Johnny Crane with Berkshire Hathaway Homeservices Michigan - TC, original listing - (231) 498-2004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $17,000,000
Beds: 6
Baths: Full: 6, ½: 1
Status: Active
SqFt: 9663 Square Feet
Agency: Berkshire Hathaway Homeservices Michigan - TC
Agency Phone: (231) 947-7777

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 466 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Indulge in the epitome of luxury living with this Adirondack-inspired estate, including 466 acres of diverse landscapes and nearly a mile on the Rapid River. Offered fully furnished with custom and antique Adirondack furnishings, the main lodge and guest house/entertainment barn provide nearly 9,700 sq ft of space, 6 bedrooms and 6.5 baths. Crafted in '17, the main lodge boasts design elements of the Lake Placid Lodge, with premium and custom wood surfaces throughout. Modern amenities such as in-floor radiant heat and Crestron Home technology make for a comfortable stay. The lodge's centerpiece is a stunning Adirondack stone fireplace, complemented by hand-hewn beams. The Scandinavian-inspired primary suite features cathedral ceilings, custom cabinetry, and a soaking tub. The chef's kitchen is equipped with superior appliances and custom cabinetry. The main lodge patio has a built-in gas grill, Argentinian grill, custom built smoker, and a wood-fired pizza oven, perfect for entertaining under the open skies. The guest house/entertainment barn, completed in '21, includes in-floor radiant heat and cedar walls, ideal for large gatherings or functional use. Inside the guest house, the main living area showcases 4-inch thick, hand-hewn walnut slab wall coverings, full kitchen, cocktail lounge, spa, and a screened porch. The irrigated 4-acre grounds include a 2-acre, spring-fed pond. The Rapid River is recognized for its exceptional quality and wealth of rainbow, brook, and brown trout. Hunters can hone their skills at the sporting clays course and find a high population of whitetail deer, grouse, as well as black bear. A myriad of trails exist for horseback riding, hiking, mountain biking, snowshoeing, cross country skiing and UTV/snowmobiling. Just 30 min to Traverse City and its airport, 5 min to Torch Lake, 20 min to the TC Horse Show, and 25 min to the Bellaire ski hills, this private retreat offers proximity to many of Northern Michigan's most coveted destinations.
MlsNumber: --
ListingId: 1923417


Listing Provided By: Berkshire Hathaway Homeservices Michigan - TC, original listing
Phone: (231) 350-8039
Office Phone: (231) 498-2004
Agent Name: Johnny Crane
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