DB Explorer · sqlite3_cli
Table used · 109 rows · Page 3 of 3
vin year trim engine body_style stock_number make model exterior_color interior_color odometer price fuel_economy transmission fuel_type condition certified inventory_date chrome_id model_code packages incentive_ids option_codes extras_json vinpoint updated_at carfax_link vehicle_link photo_urls created_at last_seen_at removed_at is_active
1FM5K8HT0HGC77470 2017 Platinum 3.5L V6 SUV HGC77470 Ford Explorer Magnetic Black 89,065 miles $19,392 16/ 6-Speed Automatic with Select-Shift Gasoline Used 0 04/20/2026 384612 K8H Equipment Group 600A,Radio: Premium Sound from Sony {"price_internetPrice":"$19,392","attr_engine":"3.5L V6","attr_exteriorColor":"Magnetic","attr_fuelEconomy":"16/","attr_interiorColor":"Black","attr_odometer":"89,065 miles","attr_stockNumber":"HGC77470","attr_transmission":"6-Speed Automatic with Select-Shift","attr_vin":"1FM5K8HT0HGC77470"} {"lat":38.240894,"long":-122.087601,"ts":"2026-05-07T09:14:49-07:00"} 2026-05-14T06:00:12.195027+00:00 https://www.carfax.com/vehiclehistory/ar20/nYnqYZl7aDpuwno1-UxNJXHkAqbn9raAiAlAl_0cv3-acO7VUyZyCHGs2h_iIGqA2bCH0Qpu_xIHz22OmveK2xHWNWXSdCITVaw https://www.fordfairfield.com/used/Ford/2017-Ford-Explorer-b3577e41ac184438c39004d6d8806a23.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0095/8e043d64d29fb76d61b3b0f4f316ed59x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0339/321f1ee63f2d084a768ee465364ad3bex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1848/ef94e83434a3dd1ba4a230110aa0e445x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0612/bff5d2f45817a2297ab5662cb78fc263x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1818/5e007fa36965fdeb27b86c986317a6bfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0376/c1128a766864c503c0a28e62f5d4d3b2x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0175/b42f0e01b01c73974b8ad8b0f5e7f5aex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1157/1b1f3ea55641f3eaf46c0f427b3c7cd8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1955/9158e640206c2f321de42a7c362c2275x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1544/11b224fdd24de668ec31b8c42db6e2e5x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0155/3d9505ac3fae58c32d0d0676503f1ab6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1196/f6939f39e9813e49418fe76754bbc76bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0881/621d79d6656b919c49412626c4424191x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1381/20c9e6b8bdc500cd2520d730a903df43x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1916/b7a0e888a72548ba30e1a4cb492bb9dfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1368/be40e6cbc1343c77ff8a49494946d3cex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1889/da645eab8a9dc5210e83a974c9bbe8f7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0543/d7d6b1c2b2ab2168ae874e4c0db89d74x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1561/a508eb252911a6ecc84da9441f039b2fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0514/160435af4910b152cdd1325a9b4d9a6cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1468/7122971e8c9c561ef3cb1846287f5e22x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0990/cb40678814826bd685f4d696c0fb9bbbx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0436/dfa266818fd1a7a4306fc0d65e0b458bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0797/e75505eb0ad639a260b54ef8ce10fe8bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1130/693d2915ecafb8699fe237932049379bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0576/a48db1753e42f8aee20159db4027e4e6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0497/61b7207fd969ac268c0374bc774573cdx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1964/f9ce5a42919e177b1885403e9aca8f38x.jpg 2026-05-14T02:14:04.194544+00:00 2026-05-14T06:00:12.195027+00:00 1
1FM5K8GC2PGB39459 2023 ST 3L EcoBoost V6 SUV PGB39459 Ford Explorer Black Metallic Ebony 42,675 miles $40,991 18/ 10-Speed Automatic Gasoline Used 0 05/11/2026 431901 K8G {"price_internetPrice":"$40,991","attr_engine":"3L EcoBoost V6","attr_exteriorColor":"Black Metallic","attr_fuelEconomy":"18/","attr_interiorColor":"Ebony","attr_odometer":"42,675 miles","attr_stockNumber":"PGB39459","attr_transmission":"10-Speed Automatic","attr_vin":"1FM5K8GC2PGB39459"} {"lat":38.240788,"long":-122.089232,"ts":"2023-12-01T12:18:08-08:00"} 2026-05-14T06:00:12.195027+00:00 https://www.fordfairfield.com/used/Ford/2023-Ford-Explorer-246c8d96ac18535f2fef472b90bfe4a6.htm https://images.dealer.com/autodata/us/color/2023/USD30FOS102F0/UM.jpg 2026-05-14T06:00:12.195027+00:00 2026-05-14T06:00:12.195027+00:00 1
1FM5K7D82JGB45120 2018 XLT 3.5L 6-Cylinder SMPI DOHC SUV JGB45120 Ford Explorer Platinum Black 76,500 miles $17,992 17/ 6-Speed Automatic with Select-Shift Gasoline Used 0 03/04/2026 396002 K7D Equipment Group 202A,Driver Connect Package,Comfort Package {"price_internetPrice":"$17,992","attr_engine":"3.5L 6-Cylinder SMPI DOHC","attr_exteriorColor":"Platinum","attr_fuelEconomy":"17/","attr_interiorColor":"Black","attr_odometer":"76,500 miles","attr_stockNumber":"JGB45120","attr_transmission":"6-Speed Automatic with Select-Shift","attr_vin":"1FM5K7D82JGB45120"} {"lat":38.240854,"long":-122.087618,"ts":"2026-04-09T09:22:53-07:00"} 2026-04-07T14:00:12.177132+00:00 https://www.carfax.com/vehiclehistory/ar20/uoDxAzPeSX_dzyLhP5qW0u8GHHQlLHO5SYDeMvply1llFuCoZ_RKAQ0M1kUS9-ZmGj-Gry5lEC1kKDP6KQt2L2Xgo4tl2w8so0Q https://www.fordfairfield.com/used/Ford/2018-Ford-Explorer-ba6ff1b6ac1852eb1ff181ccd14a5ebd.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1715/6c3b4e754580940b8a4e322ef1fbd13cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1904/75708006af81d356eee995679ad60887x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1711/6bc284a4f32441a776c02a84cd0e13cax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0323/d918f81bfc9b38e631e082e5db33d664x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1881/3d7a1d08bbd1210e7621c4cf7eb44bcex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1378/bdbe3b0f4f0d950d8fdef82fab211066x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0225/04d32bc8f2cb8d4eadad41606142825ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0478/cd6ae0d436fcf2de53735586f8383b63x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1994/3c98de5ac16d6eed79465027be39fc37x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0376/65a0f850be23fb8174c82e14225047f7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1896/d85215a11dbf7c03b1d035fc9dfde59ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1323/37e0a9d4493ba5b34de25d9d393a99c1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0108/b97a963c90547eec48ae0b21802c4343x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1994/51ce963a39b093d1933057df4cb8e09fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0742/54c6522b1ad014a22d05cafbe9383ac6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1728/52dfc63d36e236ed3e59808c9f96bf35x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1450/4ca24ca8eb7820891a285b45983c5941x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0978/f1a526ac21dbfc82ec219a5199a21069x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0863/a43df66e5eb53d897ba56e6bf0269655x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1685/92becf0f48afc739c1522bc186e5a36fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1176/271ed8f70c9b727d268f59e6367c87b3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0114/96c0b6b80b9437254a726e0e6c8f3cf3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0505/4a028dcbee97a30ffd934894ac94a7dex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0346/be96adb1079274cf739f90a86b30cae9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1462/25ece8d37c867e99f76a2a3b128310cbx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0354/4661a8408c048afce213c49f362efce5x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1037/5d564fa71dcc96bda9a86754d2b882a6x.jpg 2026-03-04T22:00:07.459376+00:00 2026-04-07T14:00:12.177132+00:00 2026-05-14T02:14:04.194544+00:00 0
1FBAX2Y86MKA52110 2021 XLT 3.5L V6 Wagon MKA52110T Ford Transit-350 Oxford White Gray 91,068 miles $29,991 10-Speed Automatic with Overdrive Flexible Used 0 03/31/2026 415117 X2Y Side Sensing System,Radio: AM/FM Stereo w/HD/SiriusXM & 8" Screen,Radio: AM/FM Stereo w/SYNC 3 {"price_internetPrice":"$29,991","attr_engine":"3.5L V6","attr_exteriorColor":"Oxford White","attr_interiorColor":"Gray","attr_odometer":"91,068 miles","attr_stockNumber":"MKA52110T","attr_transmission":"10-Speed Automatic with Overdrive","attr_vin":"1FBAX2Y86MKA52110"} {"lat":38.240633,"long":-122.087355,"ts":"2026-04-09T09:24:46-07:00"} 2026-04-07T14:00:12.177132+00:00 https://www.carfax.com/vehiclehistory/ar20/BuuL61d9RBNxwTZnZtzVrTgGry688LS4vIhf4LTCaJVMhiL0CRWUlVWhUxm4MBS9j-u1_gR-LHcZzXJq_SrX3AbXHhcJUUdxiuo https://www.fordfairfield.com/used/Ford/2021-Ford-Transit-350-fd753d5bac181b91072054cb8edffdde.htm https://images.dealer.com/ddc/vehicles/2021/Ford/Transit-350%20Passenger/Wagon/trim_XL_f589c5/color/Oxford%20White-YZ-231%2C231%2C231-640-en_US.jpg 2026-03-25T06:00:07.330799+00:00 2026-04-07T14:00:12.177132+00:00 2026-05-14T02:14:04.194544+00:00 0
1C6RREFG6LN333722 2020 Big Horn/Lone Star 3.6L V6 24V VVT Truck LN333722 Ram 1500 Billet Silver Metallic Clearcoat Black 47,475 miles $26,991 20/ 8-Speed Automatic Gasoline Used 0 04/24/2026 407710 DT1H98 Quick Order Package 23Z Big Horn {"price_internetPrice":"$26,991","attr_engine":"3.6L V6 24V VVT","attr_exteriorColor":"Billet Silver Metallic Clearcoat","attr_fuelEconomy":"20/","attr_interiorColor":"Black","attr_odometer":"47,475 miles","attr_stockNumber":"LN333722","attr_transmission":"8-Speed Automatic","attr_vin":"1C6RREFG6LN333722"} {"lat":38.241052,"long":-122.087897,"ts":"2026-05-07T09:51:46-07:00"} 2026-05-14T06:00:12.195027+00:00 https://www.carfax.com/vehiclehistory/ar20/1XzZbx-9nXm8Y4C8Y3b-AFPaLNMWOiizJtl1UazrS0m20-hxUbiI87zh0xFZZ0tMoJRx9UjkgRtBXO2LzWteYSE9nR2Qm-M-7Uc https://www.fordfairfield.com/used/Ram/2020-Ram-1500-da38520eac184438c39004d682b89f76.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0632/b05bbf735bd86c64f518ea8b2d6f241fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1480/470d5d19b4542528d6f41c8e1e256accx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1268/a435304fe2b30b2262a3b82d5e9ce12bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1733/72089eb0b349fe0d9132dc15215392c2x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1796/3e7587c0219e4cf31e5522be13edab40x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1325/3ff35f3c89ab3fb995114cb5fcb98af3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1314/a75115009e1f526dcea8030a6f25e484x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0019/6aafde29231cf65f8dab80b6e17d3ffcx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0178/173de977c4b25994ba4441f7a6bc7346x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0548/075a1cc8bebc97688dfffc4b1fa0cc82x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0615/d9697b65c15ce4590849dd0c9a952406x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0268/2f7687a9fae6746ea038325a7bf6873bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1841/6f41fd23a9df658ab08ab81b0647de71x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1097/2daaf2a8e6f2c22b53659367522dec6bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1478/56a2c1393224c6dbe506a2f8f60f3a03x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0257/789d4e577126d180bdc37268f4a11f11x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0374/852e5d4073616f03116335cad9080ac4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1354/661545a7aab7f19ba9ab87212f19b86fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0315/d56f81e2553ff6f0fa88fb2fd0cae79ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0289/93ab7ef15def8731bdeb2fde8b00ec12x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0634/d28b583acdf1fa936aa3e993e038840ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1018/0f6068143845207232b0886a102b5cfax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0787/c31dd9a7c37dca66f94d8ee24b7ae0d4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1640/c9d552a0476287ea1291896de6d5c5cdx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0958/4848378f7cea2435565475ce7cfb700ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0929/805e530dc629dc0b9c167119a1bc1b6fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0316/132c19b9c305a98a6850d90573082dc6x.jpg 2026-05-14T02:14:04.194544+00:00 2026-05-14T06:00:12.195027+00:00 1
1C4RJKBG4M8107473 2021 Limited 3.6L V6 24V VVT SUV M8107473 Jeep Grand Cherokee L Bright White Clearcoat Global Black 55,796 miles $28,492 18/ 8-Speed Automatic Gasoline Used 0 04/16/2026 418882 WLJP75 Radio: Uconnect 5 Nav w/10.1" Display {"price_internetPrice":"$28,492","attr_engine":"3.6L V6 24V VVT","attr_exteriorColor":"Bright White Clearcoat","attr_fuelEconomy":"18/","attr_interiorColor":"Global Black","attr_odometer":"55,796 miles","attr_stockNumber":"M8107473","attr_transmission":"8-Speed Automatic","attr_vin":"1C4RJKBG4M8107473"} {"lat":38.240927,"long":-122.087564,"ts":"2026-05-07T09:16:10-07:00"} 2026-05-14T06:00:12.195027+00:00 https://www.carfax.com/vehiclehistory/ar20/asShO6p1lnKtBJCXds8WIqmLVuDg-CTzq_HGNaMFpBBse9bRO8KNrevDZiWpmPZv9kQeIcu287bQFvGIuniVAfuYZjVKtLBLX-I https://www.fordfairfield.com/used/Jeep/2021-Jeep-Grand-Cherokee-L-932a8b1aac180cb6fbf5ec4971af3164.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1484/130ec3388cdcc7e88e49e83c2b2caf21x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0030/1e773f30030c65179f9cd818e147dba9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0453/0bb603b15b7afe2947ea75c4411a865ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0054/9aa0ded4fdc7c32e6172494edb6f3c4dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1515/4672b82584ce89a59fdaccfa60077411x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0123/637f2e1e388147b43bb59421395375a6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0593/0bb757022c7ee00d749a1a15b6138bcax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1527/acb2cfb92af551962ed418bb2725acb8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1344/daad31153f024f622cef7921d87a2bf8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0136/b97478d51b6821f1f358562fe20a111dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1510/12add291198fc222f0aed82a68314ab1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0508/3739e48212103ed0b52c874c7347d672x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1706/cc27ff5e9ffa17cd294a1d68f12537b7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0530/a9cfae866080c1c5d402acd7328a173dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1551/858e9ac41bc65e00dcc8aacb64dda19ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1178/44688969e72cc01aa0506126262a66f0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0437/5c8bb8542b58ab462aeaef284ce05d41x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0155/2ba5f53585aa6fc10fe4d55203fe3941x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0100/91089ef9a1b781930dc2f710dba789eex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0768/177989bf92e9ec17790c6b447a734684x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1266/e1ec63c2e995581234cf7e4509119696x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1891/5acc0d07af828f9caccc69e34ac73d99x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1246/094bd60781b0e4766b63feadf69513abx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1577/cf8dfa63e410f03f4f8648bc484d301fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0608/13cae91fee23143600697b06ee1f7803x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0724/d031a728e8b804419880070eb15cf627x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0194/1348ed0bb1e3b97d44369fde735a6d4ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1803/e654fadcb995715be1254e85d82094e0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1894/9fb3495f603c7e4751244a16847d6cfex.jpg 2026-05-14T02:14:04.194544+00:00 2026-05-14T06:00:12.195027+00:00 1
1C4RJGAG2RC708075 2024 Laredo 3.6L V6 24V VVT SUV RC708075 Jeep Grand Cherokee Bright White Clearcoat Black 62,975 miles $21,994 19/ 8-Speed Automatic Gasoline Used 0 03/19/2026 443622 WLTH74 {"price_internetPrice":"$21,994","attr_engine":"3.6L V6 24V VVT","attr_exteriorColor":"Bright White Clearcoat","attr_fuelEconomy":"19/","attr_interiorColor":"Black","attr_odometer":"62,975 miles","attr_stockNumber":"RC708075","attr_transmission":"8-Speed Automatic","attr_vin":"1C4RJGAG2RC708075"} {"lat":38.240909,"long":-122.087659,"ts":"2026-05-07T09:14:55-07:00"} 2026-05-14T06:00:12.195027+00:00 https://www.carfax.com/vehiclehistory/ar20/lH2loo1QKxwaqRuEoLWh6JVBtNnWh4s5mLH0MfjhUNcSQWAZHvcv1U4AzX0s1Dx0pcV8Q8ZySU-k8ncOt55gJ4URKUuWm45-9Yk https://www.fordfairfield.com/used/Jeep/2024-Jeep-Grand-Cherokee-088bcac1ac183eb725aa528aaabb5c17.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1269/312e7cc4ccda5388f71c4aa1923aa364x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0133/2b1df0d8b96868c532e7c4746e363e53x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0223/77cb42b55d23818b30cf664259f8772ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1948/67e7a5b6e3e86b95fbfdad52b0c5e6a9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0032/dad177c599c486f48f83e887f74153ebx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0641/82eecc05d5302fb760467cdd75a5512ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0549/2d6d734d2651924d0f2936eb7b7db98dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1846/e0f9274b99bc71f277c8e1f2815e92efx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1514/c5e6a349910ef3753c1db4c4d599884dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1328/00597f1de0b990f5fc892f5122291301x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0331/e19239b58ff7028b55900abc7b9015bax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1513/4263e830a9ae3511a31c05d82bfd6fc2x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1107/aa134c0f17cc6f7accfad939c98430efx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0949/ac5bdadffb394484baac26668f38ed29x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1904/fdc45998314275564e9b7ba1603d43f6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1710/fad314d7a6956fe11a5675d902b341cex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0887/211f6c6d49fa91d74b052467bd0d163bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1903/af4cac02238059cdce53349e21d2117ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1545/d107691e34de14886b0f02f140ce70a5x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0158/56e40bb3faab477c70f08c646d5604bfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0084/b4378fdb98df434f5dd249fad53b705ax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0509/b19c6fa146608ecbcd8a870adbb938d1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0542/a07bbe49d73ddf93506b8d5b29176173x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1786/4780ff876fe7219d252a00dec078cb0ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1799/b452c07047179fd0908f18b713f6735bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0433/817ae2862e369311e9fba51ef5a17547x.jpg 2026-03-20T02:00:08.942303+00:00 2026-05-14T06:00:12.195027+00:00 1
1C4JJXP69PW651042 2023 Sahara 4xe 2L I4 DOHC SUV PW651042 Jeep Wrangler Firecracker Red Clearcoat Black 19,548 miles $30,591 8-Speed Automatic Hybrid Used 0 03/18/2026 428361 JLXP74 Black 3-Piece Hard Top {"price_internetPrice":"$30,591","attr_engine":"2L I4 DOHC","attr_exteriorColor":"Firecracker Red Clearcoat","attr_interiorColor":"Black","attr_odometer":"19,548 miles","attr_stockNumber":"PW651042","attr_transmission":"8-Speed Automatic","attr_vin":"1C4JJXP69PW651042"} {"lat":38.241108,"long":-122.087618,"ts":"2026-05-07T09:15:49-07:00"} 2026-04-07T14:00:12.177132+00:00 https://www.carfax.com/vehiclehistory/ar20/XKdCCnNYG6oJhvkHrz2QW9PWo-Nnpw18xPOsRm35MPaCziSV1Aqyhb6HGL3LP8nbf0eeeHpZrwqwDeLqbB53rlRYq8Y6cRukfns https://www.fordfairfield.com/used/Jeep/2023-Jeep-Wrangler-0441b597ac183eb725aa528a1b090375.htm https://images.dealer.com/ddc/vehicles/2023/Jeep/Wrangler%204xe/SUV/trim_Sahara_f3e79e/color/Firecracker%20Red%20Clearcoat-PRC-188%2C39%2C45-640-en_US.jpg 2026-03-19T06:00:08.600971+00:00 2026-04-07T14:00:12.177132+00:00 2026-05-14T02:14:04.194544+00:00 0
19UDE2F72HA002598 2017 Premium Package 2.4L I4 DOHC i-VTEC 16V Sedan HA002598 Acura ILX 95,219 miles $14,891 25/ 8-Speed Dual-Clutch Gasoline Used 0 03/25/2026 384304 DE2F7HJNW {"price_internetPrice":"$14,891","attr_engine":"2.4L I4 DOHC i-VTEC 16V","attr_fuelEconomy":"25/","attr_odometer":"95,219 miles","attr_stockNumber":"HA002598","attr_transmission":"8-Speed Dual-Clutch","attr_vin":"19UDE2F72HA002598"} {"lat":38.240648,"long":-122.087526,"ts":"2026-04-23T09:30:34-07:00"} 2026-04-07T14:00:12.177132+00:00 https://www.carfax.com/vehiclehistory/ar20/KZz5QuzvKvvj-86Y6Plos5jZ-lB1z2mQKi4mxFbOTRy0maBkxSxXjSZRNSSCu_hZRIES42fmvIuGFqEptIwKKNBRQxwL1vIXV0M https://www.fordfairfield.com/used/Acura/2017-Acura-ILX-284d5cf6ac1841976aff9505f1fc6aae.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1585/518b5c859f1ccf6f20a02ba8b5b094dfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1897/067d83e0f0838f25d27797e627b6eb3cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0407/9e32b055f241a5fc8a00cadd2daf64d5x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0775/f2e159407a7b9d6f3c7914c9314393b6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0184/0295b0ce2e7144a62a8bb5097b1bcedax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0054/5a6fa0c0a1748b79bae96f50644cbf5dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1820/980951e995a2512b2871eeaa371c02bax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0192/1903ac36fed2fba7930b2560ebc0760bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0845/ae2ab9ed26188347931607b87763b6e4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1049/a3dcfa849fb502f9606419a1d35113cbx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0920/8879c7deb9e166bb4c6cf5613d7d3ee9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0993/f68035604157986e87f06f451b89272bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1413/7e08cfb8393ffe4c16aee0a7caa80ffax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1634/1a917c44ef07150c20633e584a7cde5bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1079/938dcff98ff893a60ca3a921c96fb988x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1736/936b3bebbb7dff02232b9cacd11ddf7cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0653/6403569604890abb1c04571adddb0c2cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1517/f83dc0effb151da10ea177b71f05ec1cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1453/d13ed96c0949eddf083d0987b1e0505bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0277/f5c7dcb1fd68408471bac940daf418f1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1370/ef5250ac192ee15831e0accf62ae7fc1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0325/a99f211a9ebe74cb6712f9f8cf08abd8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1886/88ce3550de7c42cfbe61c56f59e718d7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1099/e5e151c36abcf64596e6f640fd6c4b26x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1089/ce52043656199e7c4d546fdaf898a947x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1779/ba11ef2bb3d57bd4cb372d4d120fb3ddx.jpg 2026-03-26T06:00:07.189694+00:00 2026-04-07T14:00:12.177132+00:00 2026-05-14T02:14:04.194544+00:00 0

SQL Query (read-only)

Only single SELECT/CTE statements are allowed. Results capped at 200 rows.