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

7403 S River
Cottrellville, MI 48039
Sara Hillier with Sine & Monaghan Realtors LLC St Clair, original listing - (810) 329-9001

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,695,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4000 Square Feet
Agency: Sine & Monaghan Realtors LLC St Clair
Agency Phone: (810) 329-9001

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: Experience the unparalleled beauty of this extraordinary 4,000 sqft. custom-built estate. Set on 1.12 acres with 85 feet of prime water frontage on the St. Clair River, this luxurious home offers a blend of tranquility and ultimate functionality. Truly perfect for those seeking an exceptional living experience. Every detail of this home reflects high end craftsmanship and sophisticated design. As soon as you walk through the front door you take in the warmth of the wood floors being met with the unobstructed views of the crystal blue water. The open concept floor plan features sleek lines and an abundance of natural light, with spacious living spaces and several seating areas in each room. Opening up to a chef’s dream, the expansive kitchen boasts top-of-the-line Thermador appliances, custom cabinetry, two sinks, two dishwashers and a gorgeous large center island which will be everyones favorite spot to congregate. There’s also a fantastic walk-in pantry with quartz counter tops, shelving for organized storage, as well as a wine rack. Every detail of this home reflects high end craftsmanship and sophisticated design shown in each space with custom light installations and Hansgrhoe plumbing fixtures in the kitchen and bathrooms. With 5 spacious bedrooms, including 2 beautiful primary suites— one on each floor— this home provides ultimate in privacy and comfort. Waking up to breathtaking sunrises over the water from your second-floor primary bedroom will be something you look forward to each morning. There are 3 full bathrooms, one in each primary suite and a Jack and Jill up stairs, beautifully designed with high-end finishes, heated floors and custom tile; offering both style and function. Additionally, on the main floor you’ll find an office space or play room and half bath conveniently located off of the kitchen. First floor mudroom fitted with extraordinary Poggen Pohl cabinetry, tons of counter space, a utility sink, and washer and dryer. For boating and water activities the property comes equipped with 2 boat hoists and a jet ski lift, newer decking on dock & seawall ensuring easy access to the river whenever you desire. Enjoy your luxe outdoor pizza oven and grill, perfect for hosting gatherings while taking in the river views. Or jump in the hot tub and soak the day away. A massive 3+ car attached garage with heating ensures convenience, while the 3+ car detached, climate-controlled garage with a 10 foot bay door includes a full bathroom and work room perfect for additional storage, a man cave or a private workspace. The home features 2 furnaces with zoned heating, and a separate furnace for the detached garage. Easy care exterior with composite siding, premium architectural shingles, large format paver patio and new low maintenance landscaping. A whole-house generator guarantees peace of mind, and 2 hot water heaters—one tankless and one traditional—ensure ample hot water. Property under video & audio surveillance at all times.
MlsNumber: --
ListingId: 50170614


Listing Provided By: Sine & Monaghan Realtors LLC St Clair, original listing
Phone: (810) 887-8119
Office Phone: (810) 329-9001
Agent Name: Sara Hillier
Disclaimer: Copyright © 2025 Multiple Listing Service MiRealSource. 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