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

4781 E Golfview Drive
Leland, MI 49654
Roger Schaub with Schaub Team Premier Realty, original listing - (231) 674-5950

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1994
Notes: Imagine owning these sunsets while relaxing in your very own Leland waterfront home. This contemporary Glen Arai designed home has been completely renovated within the last two years to incorporate the Arai architectural lines, world-class Lake Michigan views, and natural light to create a shoreside, coastal retreat. The home, located on 2.4-acres is nestled atop a bluff with unobstructed views of the Manitou Passage and private frontage below. The home incorporates four distinct levels in addition to a guest house to accommodate a haven for you and your extended family or friends. An open and welcoming living area includes a well-appointed kitchen and dining area with a sitting room, beautiful wood fireplace clad in river rock while enjoying the stunning Lake Michigan vista. The primary suite is located on the one level up with terrace balconies and an abundance of light to enjoy the views of the Manitou Islands from the bedroom and bathroom. The top floor is a bunk room/loft that provides expansive panorama and additional sleeping for guests and extended family. The lowest floor provides access from the ground level and includes a large family room, two additional bedrooms (one non-conforming) and a shared bathroom. A bonus guest house is set atop a drive-through, detached garage that provides perfect storage for boats and additional recreation vehicles, while the guest house includes a kitchenette, sitting & sleeping area. Located just one mile from the Village of Leland and historic Fishtown where you can enjoy shopping, restaurants, galleries and beaches. A detailed list of improvements can be found in the associated documents. Nearby full-service marina could provide convenient storage and drop-in service to enjoy boating on Lake Leelanau within one mile from your home.
MlsNumber: --
ListingId: 1931529


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