If you are parking on the Farmington side, get ready to get creative with your parking although, if you intend on riding it, it's probably the safer bet since you do need to cross a MAJOR roadway about 1 mi from the trail head.
As the only person riding the route with a full suspension fat bike, I found it tolerable but the rest of my group were not as fortunate. The sand was soft, or rocky, or a combination of the two. There were parts of our bodies forever damaged (kidding... kind of) as we literally pounded our way down this viewless trail. Of the six miles we rode, probably 1.5 was "doable" on a regular bike otherwise it was just extremely difficult to navigate.
There is no river..... but there is a bit of a cess pool looking pond. We went in the middle of a drought which probably worked to our advantage as any water on this trail would make it nearly impassible.
After six miles, we decided enough was enough so we chose to take the road back. Mind you... riding along Route 11 was our only choice (think massive commercial district with significant traffic)... and yet.. it was still better than trying our hand at that return on that trail. Thank goodness we were all relatively adult... at least numerically... taking a kid on this would be a HARD no.
Unfortunately, we see a real opportunity to for rail trails but if the funding isn't there to maintain it then it's not going to get much use. That was the case with this strip.... and, hopefully with some resources, it can meet its potential of being a fun day of recreating.