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

6519 Schuss Mountain Lane
Mancelona, MI 49659
Sarah Burlingame with Up North Properties, original listing - (231) 498-2498

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $274,900
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 850 Square Feet
Agency: Up North Properties
Agency Phone: (231) 498-2498

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 1972
Notes: Welcome to an exceptional retreat at Schuss Mountain! This rare slope-side corner unit has been renovated, blending style and comfort in a prime location just steps from Schuss Village. With breathtaking views of the ski area from your front door, you are perfectly situated to enjoy year-round outdoor activities. The ski lifts, golf course, walking path, pool, and hot tub are all within walking distance of the condo, making this the ideal getaway for both skiing and golfing enthusiasts. This turn-key condo is offered fully furnished and spread over two levels; the interior is bright and airy, with tall ceilings and ample windows. It features a brand-new couch and thoughtfully selected seasonal artwork from a local artist. Each bedroom has its own private updated bathroom, complete with a shower over tub, ensuring comfort and privacy for all guests. The kitchenette and living room share an open concept for gathering with friends and family. The property allows for short-term rentals and comes with some pre-booked rentals that will transfer to the new owner. Rental history is available for review. The freshly maintained front deck welcomes you with a two-step entry from the convenient parking. It's an inviting space to enjoy morning coffee in the sun or relax in the evening after golf. The vibrant town of Bellaire is just a short drive away, offering a local brewery, shopping, and dining. Additionally, the nearby Lake Bellaire and chain of lakes provide endless boating adventures, allowing you to explore Clam Lake, Torch Lake, and more. Traverse City, Gaylord, and Petoskey are an easy commute. This slope-side retreat at Schuss Mountain is not just a condo; it’s an opportunity to embrace a lifestyle of adventure and relaxation throughout the year in beautiful Northern Michigan. Don’t miss this unique chance to own a piece of paradise.
MlsNumber: --
ListingId: 1928726


Listing Provided By: Up North Properties, original listing
Phone: (231) 883-4509
Office Phone: (231) 498-2498
Agent Name: Sarah Burlingame
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