You can just about make out the platform still, there on the left. There used to be a second line and an eastern platform, too.
Clifton Bridge Railway Station was also known as Rownham Station from 1891 to 1910.
It was part of the Port and Pier railyway (as was Hotwells/Clifton station on the north side, nearer my house), opened in 1867, and closed, inevitably, by Beeching, with passenger services stopping in 1964 and freight a year later.
Wikipedia says "Freight trains continued to pass through the station, but their number decreased over time, with the line falling out of regular use from 30 March 1981. The route however was kept intact by British Rail, with occasional freight trains, and in 2002 a single track was relaid to allow rail access to Royal Portbury Dock", so I suppose even the single line we see here is newish.
Adjacent to the station was the New Inn, Rownham, which you can see a bit of in this photo from the Tarring Collection on KYP (or in this Tweet.
People will know the station site as the place where the local police's mounted and dog sections had their headquarters/stables/kennels, though they moved out a couple of years ago, I think.
Although the line is scheduled to return to passenger service as part of MetroWest, the nearest station will still be Temple Meads, so even though there may be passenger trains heading out to Pill and Portishead through here, ten minutes' walk from my house, I'd have to get all the way into town to come back out again, so it would probably be quicker for me to drive. Shame.
GPS Coordinates:
51.44672, -2.62569
Location: Bower Ashton