Title Page Background
DEBUG FN args: Array ( [0] => 1270 [1] => [2] => [3] => agent ) BEFORE: Site: 1270 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1270 Igate: njhud LocID: 1270 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1270 AND i.igate IN ('mihud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1270 [1] => [2] => [3] => lender ) BEFORE: Site: 1270 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1270 Igate: njhud LocID: 1270 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1270 AND i.igate IN ('mihud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1270 [1] => [2] => [3] => other ) BEFORE: Site: 1270 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1270 Igate: njhud LocID: 1270 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1270 AND i.igate IN ('mihud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'mihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

382 S Shore
Crystal Falls, MI 49920
KIMBERLY WEBB with LEEDS REAL ESTATE, original listing - (906) 779-5333

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,999
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3075 Square Feet
Agency: LEEDS REAL ESTATE
Agency Phone: (906) 779-5333

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: Welcome to your luxurious lakeside retreat on the pristine shores of Lake Mary, boasting over 1,500 feet of waterfront! Nestled on more than 4 private acres with a gated drive, this extraordinary property offers unmatched privacy and exclusivity — it truly feels like your own private island. This stunning 5-bedroom, 4-bath home spans over 4,000 square feet, blending charm, comfort, and elegance. With furnishings, bedding, kitchenware, and decor. More items available for purchase, to make this a rare turn-key opportunity — move right in and start living the lake life you've dreamed of! At the heart of the home is a chef's kitchen designed to impress, featuring custom hickory cabinets, a walk-in pantry, two refrigerators, and two ovens (one with a cooktop exhaust system). The large island, illuminated by blown glass light fixtures, serves as a beautiful focal point, while the open-concept layout ensures breathtaking lake views from every angle. The living room radiates warmth and grandeur with vaulted ceilings, architectural wood beams, and a stone fireplace for cozy evenings. An adjacent sunroom opens to a deck with panoramic views of the 200+ acre lake - perfect for enjoying tranquil mornings or spectacular sunsets. The expansive master en suite offers a serene retreat, complete with vaulted ceilings framing incredible lake views, a clawfoot soaking tub, and a separate shower. Four additional bedrooms are generously sized with 8-foot six-panel entry doors, the main floor bath features double sinks, and a walk-in tiled shower with a stained glass window. A custom-built art room provides versatile space — perfect as a sixth bedroom, studio, or office. The finished lower level includes a spacious family room, two bedrooms, and a full bath, offering plenty of room for guests or entertaining. This home is thoughtfully designed for efficiency and comfort with a heating system offering three options: wood forced air, propane forced air, and electric backup. A newer Generac generator ensures peace of mind. Enjoy the separate hot tub cabin for cozy winter relaxation. The oversized 4 car garage provides ample space for all your recreational equipment — whether you're boating, fishing, or exploring nearby trails. Historic light posts from the streets of Chicago line the formal entry, adding a touch of vintage charm to your evenings under the stars. Located minutes from George Young Golf Course and just 35 miles from the local airport with Delta flights, this is lakeside living at its finest — a perfect blend of luxury, natural beauty, and adventure with private boat launch and close to ATV trails + snowmobile trails. Don't miss this rare opportunity - schedule your private showing today and experience this one-of-a-kind lakeside oasis!
MlsNumber: --
ListingId: 50175070


Listing Provided By: LEEDS REAL ESTATE, original listing
Phone: (906) 396-9422
Office Phone: (906) 779-5333
Agent Name: KIMBERLY WEBB
Disclaimer: Copyright © 2025 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