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

1691 N Manitou Trail
Leland, MI 49654

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,200,000
Beds: 3
Baths: 2
Status: Active
SqFt: 1498
Agency: Key Realty One-TC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 1900
Notes: Sitting on nearly two acres, this classic cottage is high and dry and boasts 100 ft of private (across the road) frontage on North Lake Leelanau, just one mile south of Leland! The lakefront is easily deep enough for a 24ft boat and offers wonderful recreation opportunities on the one of the most beautiful and coveted lakes in all of Northern Michigan. Property on North Lake Leelanau is becoming harder and harder to come by, and this unique parcel offers a chance to wade in at a more reasonable price point than most you will find. The cottage has a main level primary bedroom, 2 baths, a kitchen with attached laundry room and 2 upstairs bedrooms. There is a main level sunroom that is the perfect spot to enjoy the sunrise over the lake. A two car detached garage with a separate workshop room, as well as a shed, sit behind the home. Three decks, two of them with water views, offer a great place to grill out or sit back and relax with your favorite beverage. With 1.8 acres behind the home & garage, there is plenty of room to roam in the woods, collect firewood, hunt for morels, or enjoy the proximity to the Leelanau Conservancy's "Whaleback Natural Area" which is just a short jaunt away and offers a fantastic hiking trail complete with a viewing platform overlooking Lake Michigan. Frequent visits from area wildlife including deer, owl, fox, and hawks complete the up north experience. Ride your bike into Fishtown, motor your boat up the Leland River for lunch or a cocktail, or launch your kayak or paddle board for a day of sun filled adventure in this vacation oasis. Home is in need of a new well and septic. Point of Sale Inspection report is available. Permits and contractor quotes are in process. Home is in a trust and being sold As Is.
MlsNumber: 1922046


Listing Provided By: Key Realty One-TC, original listing
Name: Key Realty One-TC
Phone: (517) 827-2120
Office Name: Key Realty One-TC
Office Phone: (517) 827-2120
Agent Name: Drew Warner
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