new_car_make_x_new_car.id,new_car_make.id,new_car_make.ts,new_car_make.make,new_car.id,new_car.ts,new_car.title,new_car.model,new_car.price,new_car.color,new_car.body_style,new_car.fuel_type,new_car.engine,new_car.drive,new_car.transmission,new_car.stock,new_car.vin,new_car.miles,new_car.quick_search,new_car.mpg_city,new_car.mpg_hwy,new_car.feature_slug 835,1,"2017-11-16 22:51:31",hyundai,20785,"2017-11-20 06:03:14","2017 Hyundai Accent Value Edition",accent,"Call for Price",Red,Sedan,Gasoline,"1.6L I4 DGI DOHC 16V","Front Wheel Drive","6-Speed Automatic with Shiftronic",A336195,KMHCT4AE1HU336195,50,1nzxh7,26,36,/details/new/2017/Hyundai/Accent-Value-Edition/features-equipment/76168269/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT00OA~~ 836,1,"2017-11-16 22:51:31",hyundai,20786,"2017-11-20 06:03:40","2017 Hyundai Accent SE",accent,"Call for Price",Other,Hatchback,Gasoline,"1.6L I4 DGI DOHC 16V","Front Wheel Drive","6-Speed Automatic with Shiftronic",A345980,KMHCT5AE2HU345980,20,1nzxh8,26,36,/details/new/2017/Hyundai/Accent-SE/features-equipment/76168270/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT00OA~~ 923,1,"2017-11-16 22:51:31",hyundai,20955,"2017-11-20 06:16:53","2018 Hyundai Santa Fe Sport 2.0T Ultimate",santafesport,"$35,315",Silver,SUV,Gasoline,"2.00L I4","All Wheel Drive",A,24835,5XYZWDLA3JG537295,2,1nu9y5,19,24,/details/new/2018/Hyundai/Santa-Fe-Sport-20T-Ultimate/features-equipment/75946825/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02MQ~~ 924,1,"2017-11-16 22:51:31",hyundai,20956,"2017-11-20 06:17:04","2018 Hyundai Santa Fe Sport 2.0T Ultimate",santafesport,"$34,575",Black,Crossover,Gasoline,"2.00L I4","All Wheel Drive",A,24839,5NMZWDLA3JH085726,2,1nw2ms,19,24,/details/new/2018/Hyundai/Santa-Fe-Sport-20T-Ultimate/features-equipment/76016988/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02MQ~~ 925,1,"2017-11-16 22:51:31",hyundai,20957,"2017-11-20 06:17:13","2018 Hyundai Sonata Limited 2.0T",sonata,"$29,075",White,Sedan,Gasoline,,"Front Wheel Drive",A,24838,5NPE34AB3JH664432,2,1nw2mz,,,/details/new/2018/Hyundai/Sonata-Limited-20T/features-equipment/76016995/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02MQ~~ 926,1,"2017-11-16 22:51:31",hyundai,20958,"2017-11-20 06:17:18","2018 Hyundai Sonata Sport 2.0T",sonata,"$25,725",Black,Sedan,Gasoline,,"Front Wheel Drive",A,24841,5NPE34ABXJH659874,2,1p1fge,,,/details/new/2018/Hyundai/Sonata-Sport-20T/features-equipment/76228354/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02MQ~~ 927,1,"2017-11-16 22:51:31",hyundai,20959,"2017-11-20 06:17:51","2017 Hyundai Elantra SE",elantra,"$15,260","Phantom Black",Sedan,Gasoline,"2.00L I4","Front Wheel Drive",A,1654220994,KMHD74LF1HU406101,12,1p1zkk,29,38,/details/new/2017/Hyundai/Elantra-SE/features-equipment/76249304/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02MQ~~ 930,1,"2017-11-16 22:51:31",hyundai,20985,"2017-11-20 06:18:27","2018 Hyundai Sonata Sport 2.0T",sonata,"$26,845",Blue,Sedan,Gasoline,,"Front Wheel Drive",A,24847,5NPE34AB2JH659920,2,1p6s9d,,,/details/new/2018/Hyundai/Sonata-Sport-20T/features-equipment/76437351/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 931,1,"2017-11-16 22:51:31",hyundai,20986,"2017-11-20 06:18:32","2018 Hyundai Sonata Sport",sonata,"$24,500",Black,Sedan,Gasoline,,"Front Wheel Drive",A,24848,5NPE34AF1JH627804,2,1p6s9e,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/76437352/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 932,1,"2017-11-16 22:51:31",hyundai,20987,"2017-11-20 06:18:43","2018 Hyundai Sonata Sport",sonata,"$24,475",White,Sedan,Gasoline,,"Front Wheel Drive",A,24850,5NPE34AF1JH635644,2,1p6s9f,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/76437353/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 933,1,"2017-11-16 22:51:31",hyundai,20988,"2017-11-20 06:18:49","2018 Hyundai Sonata Sport",sonata,"$24,500",Blue,Sedan,Gasoline,,"Front Wheel Drive",A,24851,5NPE34AF3JH659444,2,1p6s9i,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/76437356/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 934,1,"2017-11-16 22:51:31",hyundai,20989,"2017-11-20 06:18:54","2018 Hyundai Sonata Sport",sonata,"$24,480",Red,Sedan,Gasoline,,"Front Wheel Drive",A,24849,5NPE34AF6JH623814,2,1p6s9m,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/76437359/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 935,1,"2017-11-16 22:51:31",hyundai,20990,"2017-11-20 06:18:56","2018 Hyundai Sonata Limited",sonata,"$26,695",Blue,Sedan,Gasoline,,"Front Wheel Drive",A,24845,5NPE34AFXJH652605,2,1p6s9r,,,/details/new/2018/Hyundai/Sonata-Limited/features-equipment/76437363/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 936,1,"2017-11-16 22:51:31",hyundai,20991,"2017-11-20 06:18:58","2018 Hyundai Santa Fe Sport 2.4L",santafesport,"$31,820",Gray,SUV,Gasoline,"2.40L I4","Front Wheel Drive",A,24902,5XYZU3LB7JG518354,2,1p6s9u,21,27,/details/new/2018/Hyundai/Santa-Fe-Sport-24L/features-equipment/76437366/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 937,1,"2017-11-16 22:51:31",hyundai,20992,"2017-11-20 06:19:03","2018 Hyundai Santa Fe Sport 2.0T",santafesport,"$29,880",Gray,SUV,Gasoline,"2.00L I4","All Wheel Drive",A,24895,5XYZUDLA6JG550340,2,1p6s9w,19,26,/details/new/2018/Hyundai/Santa-Fe-Sport-20T/features-equipment/76437368/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 938,1,"2017-11-16 22:51:31",hyundai,20993,"2017-11-20 06:19:14","2018 Hyundai Santa Fe Sport 2.0T Ultimate",santafesport,"$34,890",Copper,SUV,Gasoline,"2.00L I4","All Wheel Drive",A,24893,5XYZWDLA3JG522909,2,1p6s9x,19,24,/details/new/2018/Hyundai/Santa-Fe-Sport-20T-Ultimate/features-equipment/76437369/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 939,1,"2017-11-16 22:51:31",hyundai,20994,"2017-11-20 06:19:27","2017 Hyundai Tucson SE",tucson,"$23,835",Grey,SUV,Gasoline,,"All Wheel Drive",A,24888,KM8J3CA41HU448696,2,1p6s9z,,,/details/new/2017/Hyundai/Tucson-SE/features-equipment/76437371/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 940,1,"2017-11-16 22:51:31",hyundai,20995,"2017-11-20 06:19:35","2017 Hyundai Tucson SE",tucson,"$23,355",Blue,SUV,Gasoline,,"All Wheel Drive",A,24891,KM8J3CA43HU448649,2,1p6sa0,,,/details/new/2017/Hyundai/Tucson-SE/features-equipment/76437372/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 941,1,"2017-11-16 22:51:31",hyundai,20996,"2017-11-20 06:20:05","2017 Hyundai Tucson SE",tucson,"$23,105",Wine,SUV,Gasoline,,"All Wheel Drive",A,24885,KM8J3CA44HU448787,2,1p6sa1,,,/details/new/2017/Hyundai/Tucson-SE/features-equipment/76437373/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 942,1,"2017-11-16 22:51:31",hyundai,20997,"2017-11-20 06:20:16","2017 Hyundai Tucson SE",tucson,"$23,835",Wine,SUV,Gasoline,,"All Wheel Drive",A,24886,KM8J3CA49HU447893,2,1p6sa2,,,/details/new/2017/Hyundai/Tucson-SE/features-equipment/76437374/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 943,1,"2017-11-16 22:51:31",hyundai,20998,"2017-11-20 06:20:25","2017 Hyundai Tucson SE",tucson,"$23,075",Blue,SUV,Gasoline,,"All Wheel Drive",A,24892,KM8J3CA49HU448543,2,1p6sa3,,,/details/new/2017/Hyundai/Tucson-SE/features-equipment/76437375/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT02Mw~~ 944,1,"2017-11-16 22:51:31",hyundai,20999,"2017-11-20 06:20:30","2018 Hyundai Santa Fe SE",santafe,,,,,,,,,,,,,, 1473,1,"2017-11-16 22:51:31",hyundai,21587,"2017-11-20 08:05:41","2018 Hyundai Elantra SE",elantra,"$20,085","Quartz White Pearl",Sedan,Gasoline,,"Front Wheel Drive",A,JH230911,5NPD84LF8JH230911,75,1mw5dk,,,/details/new/2018/Hyundai/Elantra-SE/features-equipment/74683842/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMDg~ 1474,1,"2017-11-16 22:51:31",hyundai,21588,"2017-11-20 08:05:54","2018 Hyundai Sonata SE",sonata,"$23,195","Lakeside Blue",Sedan,Gasoline,,"Front Wheel Drive",A,JH628544,5NPE24AF2JH628544,7,1mw5dp,,,/details/new/2018/Hyundai/Sonata-SE/features-equipment/74683845/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMDg~ 1475,1,"2017-11-16 22:51:31",hyundai,21589,"2017-11-20 08:06:05","2018 Hyundai Elantra SE",elantra,"$19,065","Black Diamond",Sedan,Gasoline,,"Front Wheel Drive",A,JU468893,KMHD74LFXJU468893,10,1mw5e0,,,/details/new/2018/Hyundai/Elantra-SE/features-equipment/74683856/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMDg~ 1476,1,"2017-11-16 22:51:31",hyundai,21590,"2017-11-20 08:06:09","2018 Hyundai Elantra Value Edition",elantra,"$20,965","Black Diamond",Sedan,Gasoline,,"Front Wheel Drive",A,JU468705,KMHD84LF9JU468705,10,1mw5e2,,,/details/new/2018/Hyundai/Elantra-Value-Edition/features-equipment/74683858/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMDg~ 1632,1,"2017-11-16 22:51:31",hyundai,21782,"2017-11-20 08:28:47","2018 Hyundai Santa Fe Sport 2.0T Ultimate",santafesport,"$33,440",White,Crossover,Gasoline,"2.00L I4","Front Wheel Drive",A,H12660,5NMZW4LA7JH076060,5,1nabms,20,27,/details/new/2018/Hyundai/Santa-Fe-Sport-20T-Ultimate/features-equipment/75241312/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMjE~ 1633,1,"2017-11-16 22:51:31",hyundai,21783,"2017-11-20 08:28:56","2018 Hyundai Sonata SE",sonata,"$18,968",Black,Sedan,Gasoline,,"Front Wheel Drive",A,H12662,5NPE24AF8JH627138,5,1nabmv,,,/details/new/2018/Hyundai/Sonata-SE/features-equipment/75241315/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMjE~ 1634,1,"2017-11-16 22:51:31",hyundai,21784,"2017-11-20 08:28:59","2018 Hyundai Sonata Sport",sonata,"$19,647",Black,Sedan,Gasoline,,"Front Wheel Drive",A,H12656,5NPE34AF0JH640916,5,1nabmw,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/75241316/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMjE~ 1635,1,"2017-11-16 22:51:31",hyundai,21785,"2017-11-20 08:29:02","2018 Hyundai Sonata Sport",sonata,"$21,410",Silver,Sedan,Gasoline,,"Front Wheel Drive",A,H12657,5NPE34AF0JH641080,5,1nabmx,,,/details/new/2018/Hyundai/Sonata-Sport/features-equipment/75241317/?returl=L3ZlaGljbGUvcmVzdWx0cy5hc3B4P3ZlaGljbGV0eXBlaWQ9MSZpbnZ0eXBlaWQ9MSZyYWRpdXM9NTAmZG9zb3J0PXN0ZHNscl9hc2MmcGFnZW51bT0xMjE~