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;

4683 E Water View Drive
Lake Leelanau, MI 49653
Corey Flaska with Leelanau Realty Group, original listing - (231) 499-8729

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 5039 Square Feet
Agency: Leelanau Realty Group
Agency Phone: (231) 499-8729

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Welcome to Bay Hill Subdivision. Very rarely does a house in this neighborhood come up for sale. Located just 3 miles from Leland, 2 miles from Lake Leelanau and 7 miles from Suttons Bay, this home sits on top of a hill overlooking Lake Leelanau and Lake Michigan. The home itself has seasonal views of Lake Leelanau from the first floor and views of Lake Michigan and Lake Leelanau from the second floor. Every time you enter or exit Bay Hill you get elevated unimpeded views of North Lake Leelanau. The house sits on a double lot for extra space and privacy. The house has 2,086 Sq Ft on the first floor with 3Br/2Bth. The great room is absolutely amazing with floor to ceiling window wall and 22-foot-high ceilings. The kitchen has a 16 Ft. island and 2 dishwashers. The second floor has an additional 1,241 Sq Ft with a loft that overlooks the main floor Livingroom. Upstairs also has what could be used as a bedroom/office or whatever your family needs are with a large amount of extra space. The basement is also finished with an additional 1,712 Sq Ft. This space includes an additional bedroom, bathroom, large living room, work out room and a storage room. Current owner uses half of the living room for a golf simulator but that could be transformed into stadium seating for a theatre room or transitioned into a pool. The home has plenty of extras including AC, ROI water treatment, sprinkler system, kitchenAid appliances with 2 dishwashers, stomped concrete with fire pit, large large cedar built kids playground, and a very private back yard. The whole back yard borders Bay Hill common area. Totaling 5,039 Sq Ft. this home has plenty of space for family to stay over, parties, holiday get togethers, you name it. Just 3 minutes outside of Leland, you can enjoy all that Northern Michigan has to offer all summer long.
MlsNumber: --
ListingId: 1929561


Listing Provided By: Leelanau Realty Group, original listing
Phone: (231) 715-9440
Office Phone: (231) 499-8729
Agent Name: Corey Flaska
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