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 = 1314 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 = 1314 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 = 1314 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;

500 Blue Star Highway
South Haven, MI 49090
Andrea Crossman with Coldwell Banker Woodland Schmidt, original listing - (616) 396-5221

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $6,600,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Coldwell Banker Woodland Schmidt
Agency Phone: (616) 396-5221

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Land-Acreage
Year Built: --
Notes: Lake Michigan's finest...this rare gem of a property has been in the same family for decades. 21 acres of gorgeous wooded property with trails & a driveway to the beach. City water and sewer available. Person buying this 21 acres may have the first right to purchase the other 20 or so acres and home to the north. No stairs to maneuver as this unique and gorgeous property with pond that has a path to take a vehicle to the beach (and pull watercraft on and off the beach). A former tennis camp that is now private, there are several great building sites. Just north of South Haven and south of Saugatuck and Fennville with 345 feet of Lake Michigan frontage with GREAT BEACH and VIEWS. Very stable bluff. To the south are 3 new Lake Michigan homes. Beautiful variety of trees including shag bark hickory. Road to beach to be shared with seller whose home is to the north on 20+ acres and would be on the north property line. This is a VERY special parcel, the "Hope Diamond" of Lake Michigan beach parcels with great walkable beach, no stairs to the beach, 21 acres of beautiful woods and a picturesque pond in a great location along West Michigan's shoreline. Sunsets, walks on the beach, privacy, quietude, and nature are yours to enjoy. Property not in CDA and setbacks for EGLE HRE (30 year is 60') and 60 year is 105'.
MlsNumber: --
ListingId: 24048950


Listing Provided By: Coldwell Banker Woodland Schmidt, original listing
Phone: (616) 218-0267
Office Phone: (616) 396-5221
Agent Name: Andrea Crossman
Disclaimer: Copyright © 2024 Michigan Regional Information Center, LLC. 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