In my opinion the Roman Bridge gives the most beautiful view of Cordoba. It crosses the Guadalquivir and has connected the two sides of the city for two thousand years. The best time to go is at dusk, when the lights of the mosque/cathedral and the city are blazing in all their glory. Views aside, the ride is very pleasant, there is a bike path on the north bank and a lovely walk under the bridge on the south bank. In the middle of the bridge there is a statues of the archangel Raphael which must not be missed!