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;

6340 104th Avenue
South Haven, MI 49090

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,900,000
Beds: 6
Baths: 8
Status: Active
SqFt: 6450
Agency: Coldwell Banker Schmidt Family Of Companies

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 23 acre(s)
Property Type: Residential
Year Built: 2004
Notes: Welcome to this picturesque riverside estate nestled along the tranquil banks of South Haven's Black River, on 23 wooded acres. Recently remodeled to perfection, this enchanting property includes a main home, two adjacent guest apartments, and a spacious 1200 sqft heated pole barn. From every corner of the estate, revel in the serene views of the Black River, whether lounging on the riverside deck, unwinding in the enclosed and screened gazebo, or gathering around the inviting firepit area. Step inside the main home and discover a dedicated master suite complete with heated floors and a private balcony, offering a sanctuary of comfort and luxury. Experience high-end finishes throughout including thoughtful lighting, custom built-ins, hardwood floors, and a metal roof on the main home. The main home, lovingly renovated from its original log cottage roots, boasts 3 bedrooms and 4 full baths over 3792 finished square feet. The gourmet European kitchen was thoughtfully designed from a custom island and column to the granite accent windowsills. Accompanying the main residence are two inviting guest apartments: an in-law suite with 2 bedrooms, 2 baths, and its own deck for peaceful retreats, and a spacious 1-bedroom, 1-bath apartment on the lower level, accessed via a private entrance through the garage. Above, a bonus finished level bathes in natural light, offering versatile space to suit your lifestyle needs.<br /> Additional amenities such as a gated entry, security system, heated garage, and updates including a newer drain field and wood siding ensure convenience and peace of mind. With thoughtful touches like an invisible fence surrounding one acre, dual-zoned HVAC, and ongoing updates such as a paved road on 104th and fiber optic internet soon to be completed, this riverside retreat offers an unparalleled blend of comfort, convenience, and natural beauty. Welcome home to your oasis along the Black River.
MlsNumber: 24018279


Listing Provided By: Coldwell Banker Schmidt Family Of Companies, original listing
Name: Coldwell Banker Schmidt Family Of Companies
Office Name: Schmidt Realtors
Office Phone: (616) 396-5221
Agent Name: Andrea Crossman
Disclaimer: Copyright © 2024 Coldwell Banker Schmidt REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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;
Real Estate Expert Photo for Emma Bertrand
Emma Bertrand
ASCIIeXp Realty
Call Today!: (269) 779-1950

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App