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;

4201 N High Bluffs Drive
Leland, MI 49654
Tim Schaub with Schaub Team Premier Realty, original listing - (231) 674-5950

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,450,000
Beds: 4
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5719 Square Feet
Agency: Schaub Team Premier Realty
Agency Phone: (231) 674-5950

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2015
Notes: Perched 120 feet atop the Manitou Passage is this beautiful craftsman-style home set on 2.14-acres with 225 feet of Lake Michigan frontage, you can watch the eagles soar. The main house features 3 bedrooms and 4.5 bathrooms. The primary bedroom is on the main level with a walk-in closet and heated floors in the bathroom. A large open granite island kitchen, dining area, a spacious living area with gas fireplace, and ash flooring throughout. The second floor has two bedrooms with fantastic lake views and each have tiled ensuites with granite countertops. A spacious finished lower level with gas fireplace, a dry bar and non-conforming bedroom/office space for additional living. More features include a dog shower in the laundry room with cabinets, Generac generator (partial house), heat pump, on demand hot water heaters heater, smart house technology and security system, dry sauna, hardy board siding, 10x10 garden shed, detached 2-car heated garage. Across the private road is an additional 1.55 acres with a guest quarters set above a 3-car heated garage for storing your boat and other toys. It has a full kitchen, living/dining area with LP gas fireplace, one bedroom with a walk-in closet and a large bathroom for a total of 1,070 sq. ft. This provides a great private dwelling and storage for guests or extended family to enjoy amidst the treetops. Hardy board siding & new hot water heater in 2021. Stunning landscaping includes 4 apple trees, strawberry garden, two raised garden beds, rhubarb, and lots of perennials for cut flowers, all with irrigation. Adjacent, on the north side of the property is the shared (with 3 others) 70' wide access to Lake Michigan. This beautiful walk through cedar trees leads to a deck and the stairs down to your private 225’ of Lake Michigan. The sale includes three properties 45-009-134-021-10, 45-009-134-021-00, & 45-009-134-016-01 and the house is being sold mostly furnished, see included list in additional docs "D".
MlsNumber: --
ListingId: 1932884


Listing Provided By: Schaub Team Premier Realty, original listing
Phone: (231) 883-3545
Office Phone: (231) 674-5950
Agent Name: Tim Schaub
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