Kentucky Route 1974, also known as Tates Creek Road, Euclid Avenue, and Avenue of Champions, stretches from the University of Kentucky campus near its northern terminus and proceeds southeast towards Spears. It has become a popular commuting route from points south, especially with recent housing development south of Man o' War Boulevard that stretches to Kentucky Route 1980. KY 1974 was widened from two to four lanes south of Man o' War Boulevard to KY 1980 in the late 1990s. It becomes a rural two-lane road with very light traffic to its southern terminus with KY 169, which leads to the Valley View Ferry.
KY 1974 begins at an intersection with KY 169 in Lexington, Fayette County, heading north on two-lane undivided Tates Creek Road. Immediately after beginning, the route intersects the southern terminus of KY 1975. The road continues through farmland with some woods and residences. curving to the north-northwest. KY 1974 continues past more farms and intersects the northern terminus of KY 1980 before passing to the east of a residential neighborhood. Farther north, the route widens into a five-lane road with a center left-turn lane and heads through suburban areas of homes. The road passes near more residential areas with some businesses, intersecting Man o' War Boulevard. KY 1974 heads north through more suburban development and ends at an interchange with KY 4 (New Circle Road).
On March 16, 2018, the section of KY 1974 from KY 4 to US 27 was decommissioned.