SELECT * FROM cars_listings WHERE code != '' AND code IS NOT NULL AND images IS NOT NULL AND images != '' AND dtc_inventory='Y' AND abm='Y' ORDER BY year ASC LIMIT 0, 100
Basic Model Description: The Dodge Grand Caravan is a family minivan passenger caravan manufactured by Chrysler and sold under its Dodge brand. The Caravan was introduced for the 1984 model year along with its variant, the Pl. . .
Basic Model Description: The Ford Transit is a range of light commercial vehicles produced by Ford Motor Company. It includes vans, minibusses, and pickup trucks. The Transit has been in production since 1965 and is currently. . .
Basic Model Description: The Honda Civic is a car manufactured by Honda that is available as a 2 door Coupe, a 5 door Hatchback and a 4 door Sedan. From its introduction in 1972 through 2000, the Civic was a Subcompact Car, b. . .
Basic Model Description: The GMC Sierra is a line of full-size pickup trucks manufactured by General Motors under the GMC brand. It has been a prominent vehicle in the truck market for several decades, offering a range of cap. . .
Basic Model Description: The Jeep Grand Cherokee is a line of SUVs manufactured and marketed by Jeep over five generations. Originally marketed as a variant of the Jeep Wagoneer, the Cherokee has evolved from a full-size SUV . . .
Basic Model Description: The Ford Edge is a mid-size crossover SUV that has been in production since 2006. It is known for its spacious interior, comfortable ride, and advanced safety features. The Edge has received positive . . .
Basic Model Description: The Ford Mustang is an iconic sports car that has been in production since 1964. It is primarily offered as a two-door coupe or convertible, embodying the classic pony car design ethos. Over the years. . .
Basic Model Description: The Chevy Equinox is a Mid Size Crossover SUV from the Chevy division of General Motors. The Equinox is the first Crossover SUV from Chevrolet marketed by GM as a Compact SUV. Riding on GMs Theta plat. . .
Basic Model Description: The Honda Civic is a car manufactured by Honda that is available as a 2 door Coupe, a 5 door Hatchback and a 4 door Sedan. From its introduction in 1972 through 2000, the Civic was a Subcompact Car, b. . .
Basic Model Description: The Chrysler 300 is a Full Size Sedan which first hit the U.S. market in April 2004 as an early 2005 model year car. The new 300 was built as a High End Luxury Sedan on the Chrysler LX Platform. The C. . .
Basic Model Description: The Chrysler 300 is a Full Size Sedan which first hit the U.S. market in April 2004 as an early 2005 model year car. The new 300 was built as a High End Luxury Sedan on the Chrysler LX Platform. The C. . .
Basic Model Description: The Kia Sorento is a mid size crossover SUV produced since 2002 by the South Korean automaker Kia. Sorento is the first Kia model to be manufactured in the United States, in the manufacturers West Po. . .
Basic Model Description: The Chevy Cruze is a compact car produced by the Chevrolet division of General Motors since 2009. The Chevy Cruze received the highest possible rating in front, side, rear and rollover crash protectio. . .
Basic Model Description: The Chevy Silverado is a range of trucks manufactured by General Motors under the Chevrolet brand. Introduced in 1999, the Silverado is offered as a series of full-size pickup trucks, chassis cab truc. . .
Basic Model Description: The Jeep Grand Cherokee is a line of SUVs manufactured and marketed by Jeep over five generations. Originally marketed as a variant of the Jeep Wagoneer, the Cherokee has evolved from a full-size SUV . . .
Basic Model Description: The Honda CR-V, or Comfortable Runabout Vehicle, CRV, is a compact SUV that has been in production since 1995. It has been well-received for its reliability, practicality, and safety. The most recent . . .
Basic Model Description: The Honda CR-V, or Comfortable Runabout Vehicle, CRV, is a compact SUV that has been in production since 1995. It has been well-received for its reliability, practicality, and safety. The most recent . . .
Basic Model Description: Toyota Prius is a hybrid electric mid-size hatchback, formerly a compact sedan developed and manufactured by Toyota. It beats nearly all other hybrid cars in fuel efficiency and boasts a huge cargo ho. . .
Basic Model Description: The Jeep Renegade is a subcompact crossover SUV produced by Jeep. It was first introduced for the 2015 model year and has since become one of Jeep's most popular vehicles. It is known for its distinct. . .
Basic Model Description: The Hyundai Tucson is a Compact Crossover SUV produced by South Korean manufacturer Hyundai since 2004. Tucson fits below both the Santa Fe and Veracruz and above the Kona and Creta. It is named after. . .