The area LE searched is/was owned by Petroleum Specialties, Inc., 26361 Peters Rd, Flat Rock. It's around 60 acres. The largest bodies of water nearby are the Huron to the east and the Detroit river to west. A little closer are Smith Creek to the east and Brownstown Creek to the west but I don't know how big/deep either are.
Petroleum Specialties has a nasty history in terms of the environment:
Located on Peters Road south of Van Horn, PSI was a small petroleum processing and storage facility, one of three located Downriver back then (Marathon in Melvindale and Socony in Woodhaven the other major producers). Given the type of damages eventually found on site, the facility was not in production for that long; having opened in the 1930s and closed by sometime in 1964. With a storage capacity of 17 million gallons, the property lay abandoned for nearly twenty-five years, all its contaminating fluids still in place, seeping into the groundwater and making for a hazardous situation.
http://downriver-things.blogspot.com/2012/08/petroleum-specialties-inc.html
https://www.google.com/maps/place/2...2!3m1!1s0x883b40b2f0015141:0x7eeea719d16b2be7
ETA: It appears most of the outbuildings are gone which probably includes the storage containers. Still, not a good place to be.