Cristiano Ronaldo was on the verge of a spectacular move to MLS side Sporting Kansas City prior to joining Al-Nassr, according to reports.