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

5707 S Lake Street
Glen Arbor, MI 49636
Kari King with Century 21 Northland-Frankfort, original listing - (231) 352-7123

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $395,000
Beds: 2
Baths: Full: 3
Status: Active
SqFt: 2330 Square Feet
Agency: Century 21 Northland-Frankfort
Agency Phone: (231) 352-7123

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Condominium
Year Built: 2022
Notes: Welcome to the LeBear Luxury Residential Club located on the sandy shores of Lake Michigan, in downtown Glen Arbor. This exquisite turnkey property offers 1/8 fractional ownership of worry-free vacation enjoyment 6 weeks a year. This top floor unit was one of six condos completely rebuilt in 2023, and features breathtaking views of the Manitou Islands and Lake Michigan Shoreline. The modern kitchen has Wolf/SubZero appliances, granite countertops, breakfast nook, island and flows nicely into the dining room with a gas fireplace creating an elegant ambiance. The living room boasts beautifully beamed ceilings, large lake facing windows bringing the beauty and light into your living space and a second gas fireplace providing a cozy space to relax and unwind. Step outside onto the large private patio ideal for outdoor dining and relishing the evening sunset. The luxurious primary bedroom is complete with access to the patio overlooking the lake, walk-in closet, workspace and en-suite bathroom featuring a tiled steam shower, radiant floor heat, double vanity and air jetted tub. A guest bedroom, plus an office/den with a sleeper sofa and two additional full bathrooms provide privacy and space for your guests to be comfortable. For your convenience, each owner has a locked storage cabinet and 4 large storage bins that are brought in during your stay so you have exactly what you want. As an owner you'll have access to a wide range of amenities including 242 feet of pristine shared frontage on Lake Michigan, an indoor and outdoor swimming pool and spa, fitness center, sauna, clubhouse, private garage and beautifully landscaped common areas. Can’t make it for one of your weeks? No problem, you can easily rent out your week or trade weeks with other owners. Located on the scenic M-22 drive and surrounded by the Sleeping Bear Dunes National Lakeshore, this beautiful condo on Lake Michigan is more than just a property; it's a lifestyle you will long for between visits.
MlsNumber: --
ListingId: 1924395


Listing Provided By: Century 21 Northland-Frankfort, original listing
Phone: (231) 651-0923
Office Phone: (231) 352-7123
Agent Name: Kari King
Disclaimer: Copyright © 2025 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