In an effort to reach accident-free milestones or drastically reduce/eliminate road fatalities rates and traffic congestion and to create disruptive, transformational mobility systems and services, different parties (e.g., automakers, universities, governments, and road traffic regulators) have collaborated to research, develop, and test connected vehicle (CV) technologies. CVs create new data-rich environments and are considered key enablers for many applications and services that will make our roads safer, less congested, and more eco-friendly. A deeper understanding of the CV technologies will pave the way to avoid setbacks and will help in developing more innovative applications and breakthroughs. In the CV paradigm, vehicles become smarter by communicating with nearby vehicles, connected infrastructure, and the surroundings. This connectivity will be substantial to support different features and systems, such as adaptive routing, real-time navigation, and slow and near real-time infrastructure. Further examples include environmental sensing, advanced driver-assistance systems, automated driving systems, mobility on demand, and mobility as a service. This article provides a comprehensive review on CV technologies including fundamental challenges, state-of-the-art enabling technologies, innovative applications, and potential opportunities that can benefit automakers, customers, and businesses. The current standardization efforts of the forefront enabling technologies, such as Wi-Fi 6 and 5G-cellular technologies are also reviewed. Different challenges in terms of cooperative computation, privacy/security, and over-the-air updates are discussed. Safety and non-safety applications are described and possible future opportunities that CV technology brings to our life are also highlighted.