DB Explorer · sqlite3_cli
Table used · 68 rows · Page 2 of 2
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
1FTER4FH0KLA67473 2019 XLT 2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT Truck KLA67473 Ford Ranger Chili Pepper Red Ebony 60,588 miles $25,492 20/ 10-Speed Automatic Gasoline Used 0 03/09/2026 403634 R4F FX4 Off-Road Package,Trailer Tow Package,Radio: AM/FM Stereo w/6 Speakers,SYNC {"price_internetPrice":"$25,492","attr_engine":"2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Chili Pepper Red","attr_fuelEconomy":"20/","attr_interiorColor":"Ebony","attr_odometer":"60,588 miles","attr_stockNumber":"KLA67473","attr_transmission":"10-Speed Automatic","attr_vin":"1FTER4FH0KLA67473"} {"lat":38.240741,"long":-122.087766,"ts":"2026-04-02T09:20:55-07:00"} 2026-04-04T10:00:12.249518+00:00 https://www.carfax.com/vehiclehistory/ar20/b1SN7CTTBvD06jemcD3XgYVlHVB-SQQW_XdgHAa_P9HkPkc5Wx4xx31lGRs3jmK8SEPv8CUWJuQoCWjOV80cd3-_vVcjKjz0E04 https://www.fordfairfield.com/used/Ford/2019-Ford-Ranger-deeb0c0aac183da746fed083176697ad.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1889/db19651ddc9c6daf52ce5d9f1625a97ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0052/34590665d8ed905f8af60738f43517a0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0386/47d383f4812e14dca9e70ecee39d9194x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0450/b237e24d17edd9b18d20ba41c52d41abx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0136/4a4b4717f7bce5386828f15c175a25d7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1142/c056a49483d14e79502dfcb2f17a740dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1665/b164db9a8622c1d3e4cdcd35492466c6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0648/c2e5bbabe245cfc119d8395f00e6b6c7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0144/d00bae0dce63f42822a945e17cd97678x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0842/fefa33c4f8eeade15891af931de4eeaax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0045/7efe27b0afa34691ee4892f6b308cc3cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1865/3146fe4b143a040d539527798e197552x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1286/5568887695dfc54bfe7f9e13d923655cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0806/2ead33a7d876133d3a3b72600b4fde35x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0244/39dd1087f07b13283a02bcc1437408c0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1777/76889cb6b800ff2fd4c1129ad53fab3ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0344/341ebf7132db77a185cc808211c9f230x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1642/08a526fe2998a39867c94e462121f6bbx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1368/57897aade5a4941aa67d5fdda4bb66c9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0912/8b66dfed2d46b9a8900878c8d53aab06x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1211/f97df76bc663afb85d2867f638162f0dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0380/bc6b8eb3e1bd1564391dd14d1171614dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1402/1c62fbd05b0616a234cbe5d670a682b8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0703/718a3476706b323344824bf220b7838cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1553/ac64d4ac5f8d0ffce33db45e10e0052dx.jpg 2026-03-12T02:00:07.774051+00:00 2026-04-04T10:00:12.249518+00:00 2026-04-04T14:00:10.818895+00:00 0
1FTER4EH7LLA83026 2020 XL 2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT Truck LLA83026 Ford Ranger Shadow Black Ebony 28,578 miles $24,994 21/ 10-Speed Automatic Gasoline Used 0 02/25/2026 410589 R4E Equipment Group 101A Mid,STX Appearance Package {"price_internetPrice":"$24,994","attr_engine":"2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Shadow Black","attr_fuelEconomy":"21/","attr_interiorColor":"Ebony","attr_odometer":"28,578 miles","attr_stockNumber":"LLA83026","attr_transmission":"10-Speed Automatic","attr_vin":"1FTER4EH7LLA83026"} {"lat":38.240858,"long":-122.087407,"ts":"2026-04-02T09:24:12-07:00"} 2026-04-06T10:00:10.736581+00:00 https://www.carfax.com/vehiclehistory/ar20/HXTNAZx_5EKykcNaclZQAGLI0prfhlN7Yn1xXXkTk-zIVUBcXR8pTYfR4B0rTBy_rW9EmrkZaHgHYyPKlFcF7bv9YpzOT70R13o https://www.fordfairfield.com/used/Ford/2020-Ford-Ranger-73a3a290ac18134bb681876803e73cf3.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1795/b5bd60e15e27d4eb4203a1cb0418c9bdx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1310/e277e9562b438c8034f266e4d3d1a9d0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0997/83153db1ac6b93aa029bb8d2281b21b9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0490/4f06a2e3d5c21037e980c9ec4562328bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1416/234861ee9c7e0f59319021bdcdbaa218x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0816/31f39914d50a61f270763dc9e4a9bd40x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1691/9ba3d92242d58cab94600e1f7a479d40x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1377/5bda12027be3919f1867233dab997a21x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1572/85c7c57ef54e043b69cb7ceb2c9df4e6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1854/070fadd4659092f69ff7cd2b66b9f713x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0979/240bd5d34714d85e1ce3b21fffd8744dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0666/dae9978c02c0b7e5825943c8b437cbaax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0796/0d3515271b1647f9f4bec28af5148743x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1641/3ff08537c9fc30560fd25f621eadf578x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0154/c69dbec07d7fa043a25a98e408a181cdx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0222/2be857e3305b83fcf8e75ce7cbc78aa1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1712/b944b96fb87c434a9407ded9d09a8c87x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1378/b6f670e5025057aa4319eff936f8f0f6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1486/4344d0fe4da9a61bc6d05eff7a9a7da2x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1687/874bb950d2a221fe373e15c801a32119x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1727/f77ba2b00c854666218302cc9b662e65x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1703/6f595dbdaf977b95fc85a6733d01e3b0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1928/4b69c591a29b79749a0b9606d34c3bd0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1744/2e77a004de9aec9922bf883466993acfx.jpg 2026-02-19T06:00:09.413195+00:00 2026-04-06T10:00:10.736581+00:00 2026-04-06T14:00:11.365559+00:00 0
1FTER4EH6MLD38900 2021 XLT 2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT Truck MLD38900 Ford Ranger Shadow Black Ebony 56,575 miles $25,591 21/ 10-Speed Automatic Gasoline Used 0 04/03/2026 417835 R4E Trailer Tow Package,SYNC 3 {"price_internetPrice":"$25,591","attr_engine":"2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Shadow Black","attr_fuelEconomy":"21/","attr_interiorColor":"Ebony","attr_odometer":"56,575 miles","attr_stockNumber":"MLD38900","attr_transmission":"10-Speed Automatic","attr_vin":"1FTER4EH6MLD38900"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/A_1yOFAjyxpjCCOlhczZ3bIPaoiDZMBdDTiyBlFMOy-UpxlBvPUrlRH2IKM8WCRxYqRhi8qnLXWsBEcMK356dOT8-g-psRRo6cc https://www.fordfairfield.com/used/Ford/2021-Ford-Ranger-56a6d4b5ac185bde9151771ac71191e5.htm https://images.dealer.com/autodata/us/color/2021/USD10FOT143A0/G1.jpg 2026-04-04T06:00:19.974827+00:00 2026-04-07T06:00:11.040496+00:00 1
1FTER4BH6RLE59986 2024 XL 2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT Truck RLE59986 Ford Ranger Silver Metallic Ebony 11,499 miles $30,791 21/ 10-Speed Automatic Gasoline Used 0 04/02/2026 441582 R4B Trailer Tow Package,Equipment Group 100A Standard,STX Appearance Package {"price_internetPrice":"$30,791","attr_engine":"2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Silver Metallic","attr_fuelEconomy":"21/","attr_interiorColor":"Ebony","attr_odometer":"11,499 miles","attr_stockNumber":"RLE59986","attr_transmission":"10-Speed Automatic","attr_vin":"1FTER4BH6RLE59986"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/UukIvAn17U0HAsyIWbHHtE92KC5DIjEXmwb9ElLO7HXm2gGyca_bvzWhDgVor7A4szuvHUKL_0DlT5F1sB15n2WTWARJKTdcrX8 https://www.fordfairfield.com/used/Ford/2024-Ford-Ranger-4c5b4cd3ac182ff5053b2af111d7e71c.htm https://images.dealer.com/ddc/vehicles/2024/Ford/Ranger/Truck/trim_XL_c4fb71/color/Iconic%20Silver%20Metallic-JS-136%2C136%2C132-640-en_US.jpg 2026-04-02T06:00:15.659094+00:00 2026-04-07T06:00:11.040496+00:00 1
1FTER1FH8MLD04180 2021 XLT 2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT Truck MLD04180 Ford Ranger Silver Ebony 16,464 miles $30,591 20/ 10-Speed Automatic Gasoline Used 0 03/24/2026 417832 R1F Trailer Tow Package,SYNC 3 {"price_internetPrice":"$30,591","attr_engine":"2.3L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Silver","attr_fuelEconomy":"20/","attr_interiorColor":"Ebony","attr_odometer":"16,464 miles","attr_stockNumber":"MLD04180","attr_transmission":"10-Speed Automatic","attr_vin":"1FTER1FH8MLD04180"} {"lat":38.240906,"long":-122.087448,"ts":"2026-04-02T09:24:21-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/mX-F5pQx0S7Akok_hZvErZ4jzDvGLdlggJ5SKGjFQJPjPuiOpEo5rM_V3KQNonoPo7pwtmmW44c3aSLytLSb626Okkf3Gl6Nd1c https://www.fordfairfield.com/used/Ford/2021-Ford-Ranger-2d735209ac18168a1686c879786834a2.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0828/df23e87f67052e902bffdf11cf419233x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1068/27c0ba53092840a9b8da2d0f81023ae6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0051/d1eb0c44c9d84d03aa1bbc97e69770b9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1677/66dbddc612a65e32f0629d993eec8f15x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0922/5be33c6a66695b7f0e3901bcd83bf8a9x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0741/900a0b53ddc8282bcffb35892bf23da6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0973/f71667a00440774ecab4a103d31c5b25x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1357/b0221da3fb2d8cecf0e6ee079be9819ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1612/f5769f781f39466dbb59bd2f45637d13x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0980/3aa89fb210c2243f674c75c442c24646x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0318/05187322128429987d9b1f7c2db79a7cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0697/eb143ec02957664eedb7ee8fb9667d75x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0541/8b0ebac2b47e13cfc1a6e64cce074bbax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1700/c764476aa951d4c515a9cfaa8fd7e16cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0905/8ea5ee90d9e03f15efa35487579bbe24x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0563/c0afe78c0d902cc300e26bd9e4f8e3b7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1687/e936abc066ff7450466902b9d924afafx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0336/4ad879f5c51e999dd55391bea0edbdbfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1902/3d1ba1a7e001f01f3fc1d75044047df0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1885/3cacb22bbe83b511ab3f41aecf6147eex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0130/5469ce409b579f28c5c80404b6c180a4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0381/27cdc876ab1b519d0289e2b40cae409cx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0841/374624aac2ac9a6ae830a01585457dd4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0138/925c422a4f3544fafe8c1b2477863df7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1114/09eee77d55664e32f4728b490db9a313x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0693/b49d204e0062e68c876c61ef91748654x.jpg 2026-03-27T06:00:12.444644+00:00 2026-04-07T06:00:11.040496+00:00 1
1FT7W2BT1HED42510 2017 Lariat 6.7L Power Stroke V8 DI 32V OHV Turbodiesel Truck HED42510 Ford F-250SD White Platinum Black 129,496 miles $42,591 TorqShift 6-Speed Automatic Diesel Used 0 03/25/2026 385461 W2B FX4 Off-Road Package,Rear CHMSL Camera,SYNC 3 Communications & Entertainment System {"price_internetPrice":"$42,591","attr_engine":"6.7L Power Stroke V8 DI 32V OHV Turbodiesel","attr_exteriorColor":"White Platinum","attr_interiorColor":"Black","attr_odometer":"129,496 miles","attr_stockNumber":"HED42510","attr_transmission":"TorqShift 6-Speed Automatic","attr_vin":"1FT7W2BT1HED42510"} {"lat":38.240242,"long":-122.088776,"ts":"2026-04-02T09:17:07-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/7ghyYY8cQZDzsdjrMww6Bu5Ha46ICZPRZHZVtbvKg-2PgtU5oaCSOZw5HXXFdbd0yYNNcGa6vUBXn_4u5q7Azdacgr8m5SCCnFk https://www.fordfairfield.com/used/Ford/2017-Ford-F-250SD-284d5f1fac1823e7f450582958a99e24.htm https://images.dealer.com/autodata/us/large_stockphoto-color/2017/USC70FOT128A0/Z1.jpg 2026-03-26T06:00:07.189694+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMUK7DH2SGB42389 2025 Active 2.3L EcoBoost I-4 SUV SGB42389DL Ford Explorer Gray Metallic Dark Gray/Onyx 3,529 miles $37,591 20/ 10-Speed Automatic Gasoline Used 0 01/26/2026 454033 K7D Equipment Group 200A Standard Package fairfieldfairfieldfordfd_fd0747d2ac185b650b3935dc9d2ce047 {"price_internetPrice":"$37,591","attr_engine":"2.3L EcoBoost I-4","attr_exteriorColor":"Gray Metallic","attr_fuelEconomy":"20/","attr_interiorColor":"Dark Gray/Onyx","attr_odometer":"3,529 miles","attr_stockNumber":"SGB42389DL","attr_transmission":"10-Speed Automatic","attr_vin":"1FMUK7DH2SGB42389"} {"lat":38.240805,"long":-122.087872,"ts":"2026-04-02T09:07:16-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/CzKeDUJN174FgQpLqr5r6ENw-oqjBLnouIXxfQlL9RURXbyvsA3_A5nt8rjNzpW3z9aI_qJxMR3VO7hapOm4ucEa4qMyeWDdpbo https://www.fordfairfield.com/used/Ford/2025-Ford-Explorer-6fdeb072ac185816baf808016951825d.htm https://images.dealer.com/ddc/vehicles/2025/Ford/Explorer/SUV/trim_Active_f85b7b/color/Carbonized%20Gray%20Metallic-M7-80%2C90%2C91-640-en_US.jpg 2026-01-27T22:00:07.208171+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMUK7DH0TGA59495 2026 Active 2.3L EcoBoost I-4 SUV TGA59495 Ford Explorer Carbonized Gray Dark Space Gray 4,948 miles $34,687 20/29 10-Speed Automatic Gasoline Used 0 04/03/2026 479010 K7D Equipment Group 100A fairfieldfairfieldfordfd_53762649ac18105916468f95865dbc16,fairfieldfairfieldfordfd_4abf6adcac184c401dc8fa9ceecc6d44,fairfieldfairfieldfordfd_4abf6a7dac184c401dc8fa9c7b901574 {"price_internetPrice":"$34,687","attr_engine":"2.3L EcoBoost I-4","attr_exteriorColor":"Carbonized Gray","attr_fuelEconomy":"20/29","attr_interiorColor":"Dark Space Gray","attr_odometer":"4,948 miles","attr_stockNumber":"TGA59495","attr_transmission":"10-Speed Automatic","attr_vin":"1FMUK7DH0TGA59495"} {"lat":38.241159,"long":-122.086429,"ts":"2026-01-15T09:49:37-08:00"} 2026-04-06T18:00:11.775249+00:00 https://www.carfax.com/vehiclehistory/ar20/UHhWkgshpbJPQkgXCcTnJmvBwn4bAAdIKVlWWo3Z7KbMVh5RAmzvlNaOPH3yQD5viNrRP43bGELbu3VrCFBLBaIK9rEOWb2yj-E https://www.fordfairfield.com/used/Ford/2026-Ford-Explorer-141f9748ac18580583ea646d309175cd.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1008/52a9ac5df778d4f3b4abe1fb3d405467x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0873/f90675b57928da97d3299e0e67b75519x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1581/48112a1aa31eda4d8e037bc3be0818a8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1980/b0e72bad6fcc7dbe2166a58effaf4ee1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1380/4aa9b3356ba0b66933c84a341d0634a1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1703/b00574b49ac64b61ce722409fb3c8885x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0079/5862c5fdaa3734f6fbf30e46a41d0886x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1136/942cc8448100a5efa9ee0484bad07ce4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0685/4d6f53839621a9674cade139ae7a49fcx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1236/886140371afda6ec934474d92936f093x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0873/7ec2d68315e425e57f7c71f46fa760d1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0397/accf7e5cfb59bd11bbbb1a5047fa55f1x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0597/0f809444a40f182e24b2664b5bad9c43x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0402/6e43458b9726dc210867767a1aae7d96x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1323/ff2cc212bbe70c80e8fb157e539cc554x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1168/a19bdbfa76f32e1f91f472ce14426c99x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0782/a0678d2e36593fb5acbd8c3b63ea8d66x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1628/f461f16f8e0e5f0d97ddf9d8fd395469x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0353/5d2b26e2e3effbe298672e9e1fb1a2afx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0303/26a795e8f8ef10b67d3ee8a2daa7fda4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1464/8ea14c21b86a81d1bd08fe8ac8741921x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1548/f619a048a968e324973422ae754fb0cfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1409/2f590ff1f0847f1c8c9f106f6b8021ddx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0535/b9d1b0cada2e082540c7ca47e891c175x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1267/eed294e6790147faf64ae74bddcb8810x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0797/474ce35ce3caf08c1ff0d4468810fd6bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1403/c15453f4d1f30bc79ab44714581445d3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1086/0bc23071e469901aa84b87c4e172b8b3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0237/a33912419a183b4d5621d18f208703f0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1267/0f31c7550368b676184c0cd2422955b7x.jpg 2026-04-03T22:00:12.146251+00:00 2026-04-06T18:00:11.775249+00:00 2026-04-06T22:00:13.695332+00:00 0
1FMSK7DH3NGB35480 2022 XLT 2.3L EcoBoost I-4 SUV NGB35480 Ford Explorer Star White Metallic Tri-Coat Light Slate 55,227 miles $26,491 21/ 10-Speed Automatic Gasoline Used 0 03/25/2026 423541 K7D Equipment Group 202A,XLT Sport Appearance Package,Ford Co-Pilot360 Assist+,Unique Cloth Captain's Chairs,ActiveX Captain's Chairs {"price_internetPrice":"$26,491","attr_engine":"2.3L EcoBoost I-4","attr_exteriorColor":"Star White Metallic Tri-Coat","attr_fuelEconomy":"21/","attr_interiorColor":"Light Slate","attr_odometer":"55,227 miles","attr_stockNumber":"NGB35480","attr_transmission":"10-Speed Automatic","attr_vin":"1FMSK7DH3NGB35480"} {"lat":38.240665,"long":-122.088881,"ts":"2026-04-02T09:13:51-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/fqHfXsoxYfhG2fXA3h9SSIT77tc3VlUfuhR8AVG8BFuYnJsn6UjbTQozgc5x0qrQl1czcb0t0AGygZlJkQ4Lr-zy3sw7xrDQLU4 https://www.fordfairfield.com/used/Ford/2022-Ford-Explorer-2705951dac1826fc4220aec5e5935111.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1340/8b02c589ee51add627d779848caf9846x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1110/4a0da24d16a301f5f3e07dd8f2040c58x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0760/0bb854037e0656e806320884b5410e55x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0411/3a10de71929efdce3179b69de1e9564dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0255/2e984a567f54a9c9cb3f9ed8c403e624x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0655/139c7f6d5dcd0b2c6eeadca260879b2bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0087/55a7a13885fab384c9888b7615f06adfx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0226/59c87bde5313bb03a376412cf9bf8326x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0653/9d13ae4f83a6c7f019c77e83082388f3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0475/7e03e1581160a32f6d5735b8a555e6b8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1294/76c1bd82d8e553318d4ba7abccdff983x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1454/c40bbb1066548a43feaa3a5573db1d49x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0763/ce155c2e084bd757652205849e76208dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0148/c46fe90ccd8b31c939aba210ba5619d7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0578/a17ce1e3fa36db7048a94477e5655ec0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0899/d331d60c69e1eff0f72c36bf593f1243x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0693/063764f4b5d9d23f582d70fe8389fd83x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0356/50aa76e73c7fd5aa353b02121b5fad5bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1846/ac2d9308f6db3599baaf02026201735dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0123/015495e1c0237c7ddcc9ba76b666fc30x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0717/e2745d0d2c02b9b6bb1004f7c5f16992x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0435/efbc68e241f27f2b8a91239ad1743d6ex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1637/335f1e45dc1085162759c210b8a3ac8fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1430/7f4d544d2901a10f810bd1b3caed972dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1705/58070e6dd2467300c99a3dc2f663ed50x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0429/3c65ccd5b1b7e44f7a4ee631a60982d8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0042/5bf4858e4a664feeacbcb41b103a8028x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1789/eb9b6b7d817d8e376baa2ab3f8d3ccf3x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1560/8e4bd85cd80d9983d74bab79c25c366bx.jpg 2026-03-26T02:00:07.807374+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMDE8BHXSLA62779 2025 Outer Banks 2.3L EcoBoost I-4 SUV SLA62779 Ford Bronco Azure Gray Metallic Black Onyx 12,656 miles $46,991 18/ 10-Speed Automatic Gasoline Used 0 04/02/2026 466696 E8B Painted Hard Top,Equipment Group 312A Mid Package {"price_internetPrice":"$46,991","attr_engine":"2.3L EcoBoost I-4","attr_exteriorColor":"Azure Gray Metallic","attr_fuelEconomy":"18/","attr_interiorColor":"Black Onyx","attr_odometer":"12,656 miles","attr_stockNumber":"SLA62779","attr_transmission":"10-Speed Automatic","attr_vin":"1FMDE8BHXSLA62779"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/xTpl48t471DdvfA2tnVYd3uCkTzjBTrImID9wdud5XEiAIXBhS2_jd5wbRSwMFPzofwPbV6IVBRb0G2oSm9g9nuKmJP7MX_6SIY https://www.fordfairfield.com/used/Ford/2025-Ford-Bronco-4c5b4e67ac1857715e05f4fd25a7d542.htm https://images.dealer.com/autodata/us/color/2025/USD50FOS092C0/G4.jpg 2026-04-02T06:00:15.659094+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMDE5BH7MLA82781 2021 Big Bend 2.3L EcoBoost I-4 SUV MLA82781 Ford Bronco Race Red Black 40,010 miles $33,591 20/ 10-Speed Automatic Gasoline Used 0 03/18/2026 419518 E5B {"price_internetPrice":"$33,591","attr_engine":"2.3L EcoBoost I-4","attr_exteriorColor":"Race Red","attr_fuelEconomy":"20/","attr_interiorColor":"Black","attr_odometer":"40,010 miles","attr_stockNumber":"MLA82781","attr_transmission":"10-Speed Automatic","attr_vin":"1FMDE5BH7MLA82781"} {"lat":38.240495,"long":-122.087305,"ts":"2026-04-02T09:23:03-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/cwMfDLfUGHHL8__ueIhMjOHLTdqo8TGsLlpQgJsfSaTNX_9u526DkmmjnH16GKyWfz4oVRlaqVt03Dqd0cKZn_lnkR-XGlikUDc https://www.fordfairfield.com/used/Ford/2021-Ford-Bronco-0441b6edac18168a1686c87990bcf091.htm https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1095/8e4f6afaf7d5723bf797bbe49ac143cax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0058/f27a1bf8f2bcdd106aacfd88dc3db324x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1505/8c7eeee71cab3de0003605e674c10c8bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0957/e0716a0bc6a5c8411548f1dc76c8f6c0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1943/cefae0f09b68f2fbb20a123548e60f2dx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1834/136ebcd7dfa64c83955f0ad3fc0fdf61x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0213/74c20294376f70ebe67e3862910139a4x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0374/b967afb469155d845b3a029229f7dcdcx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1199/b8a88a2cde1e26764382001d75a65d92x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1451/a7d13446f003d91c50c84e0fc38a49a6x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0057/a97e31c5efd837a690413bab84352932x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1726/d6e192c5cc7a3f60a91bed29ab9912a0x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0782/60155bf93fb9ebeb31bdfb65af45daf7x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1749/a96b997c577c19c9f5231d88f770146bx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1019/cf61b34a33d67627e616795c5b8b7a61x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1740/c6ce7b97bef2105ce4ae50ce22562d44x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1022/1e9ce75f9079f8451ad84e8029d45461x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0674/f59cd640876f6a0acf1633fcac10034fx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0826/f598979937518999d0b3eac89c7d7965x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1980/e82b226d7feb93ad3aea092be966f6b8x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1348/7c5d59eccb17f71c8ad988c0be38aa45x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0448/80b31993455448b474f0cc412603f4dcx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1100/c5bdd0f4ef923de32699644937c16752x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0270/e178224a5b569212be5c09e9fae4cfdcx.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/1343/106e875bc369c39d081dd19f081f9995x.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0798/90fd0f106f0e0e2a37e4e0b09480f0dax.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0336/1fd6afcf28b3a5558e282d2d481b2cdex.jpg,https://pictures.dealer.com/f/fairfieldfairfieldfordfd/0483/16087dbc3a6af23ca0aceb8ed0ad19b5x.jpg 2026-03-19T06:00:08.600971+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMCU0GX6GUB83505 2016 SE 1.6L EcoBoost I4 GTDi DOHC Turbocharged VCT SUV GUB83505 Ford Escape Electric Spice Metallic Black 108,035 miles PLEASE_CALL 23/ 6-Speed Automatic Gasoline Used 0 04/04/2026 376507 U0G {"price_internetPrice":"PLEASE_CALL","attr_engine":"1.6L EcoBoost I4 GTDi DOHC Turbocharged VCT","attr_exteriorColor":"Electric Spice Metallic","attr_fuelEconomy":"23/","attr_interiorColor":"Black","attr_odometer":"108,035 miles","attr_stockNumber":"GUB83505","attr_transmission":"6-Speed Automatic","attr_vin":"1FMCU0GX6GUB83505"} 2026-04-07T06:00:11.040496+00:00 https://www.fordfairfield.com/used/Ford/2016-Ford-Escape-64cfd61eac185bdeff10c7b19dac02e4.htm https://images.dealer.com/ddc/vehicles/2016/Ford/Escape/SUV/trim_SE_b03c25/color/Electric%20Spice-H8-159%2C94%2C15-640-en_US.jpg 2026-04-07T02:00:12.228519+00:00 2026-04-07T06:00:11.040496+00:00 1
1FMCU0G66NUB97375 2022 SE 1.5L EcoBoost SUV NUB97375 Ford Escape Iconic Silver Metallic Dark Earth Gray 43,136 miles $19,591 28/ 8-Speed Automatic Gasoline Used 0 04/02/2026 421853 U0G Convenience Package,Equipment Group 200A {"price_internetPrice":"$19,591","attr_engine":"1.5L EcoBoost","attr_exteriorColor":"Iconic Silver Metallic","attr_fuelEconomy":"28/","attr_interiorColor":"Dark Earth Gray","attr_odometer":"43,136 miles","attr_stockNumber":"NUB97375","attr_transmission":"8-Speed Automatic","attr_vin":"1FMCU0G66NUB97375"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/-KTEtAPBKLtUEGWbrSw6RES_F_vlUzOx_xHvDmmrgRXh6vGArajlTE8y10jGosuqU-myDhByZq3qhC_FJ9zWBy91VaZIXkHgMoU https://www.fordfairfield.com/used/Ford/2022-Ford-Escape-4c5b4910ac1854f2f2f86bcb8c7eab89.htm https://images.dealer.com/autodata/us/color/2022/USD20FOS131B0/JS.jpg 2026-04-02T06:00:15.659094+00:00 2026-04-07T06:00:11.040496+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.241081,"long":-122.087664,"ts":"2026-04-02T09:22:01-07:00"} 2026-04-07T06:00:11.040496+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-07T06:00:11.040496+00:00 1
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.240495,"long":-122.088912,"ts":"2026-04-02T09:14:58-07:00"} 2026-04-07T06:00:11.040496+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-07T06:00:11.040496+00:00 1
1C4RJGAG2RC708075 2024 Laredo 3.6L V6 24V VVT SUV RC708075 Jeep Grand Cherokee Bright White Clearcoat Black 62,975 miles $23,691 19/ 8-Speed Automatic Gasoline Used 0 03/19/2026 443622 WLTH74 {"price_internetPrice":"$23,691","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.240496,"long":-122.087267,"ts":"2026-04-02T09:23:08-07:00"} 2026-04-07T06:00:11.040496+00:00 https://www.carfax.com/vehiclehistory/ar20/keC8MHAtqz_io-sATuEElo7wjCM41h1Y8IF-RUZ4kAZePKvYdM0b7BI3hUsmTHR6eaGxvQ0rTNZzF60hP_YZqPQYKAefuabd_JA 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-04-07T06:00:11.040496+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.240738,"long":-122.08872,"ts":"2026-03-26T09:15:58-07:00"} 2026-04-07T06:00:11.040496+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-07T06:00:11.040496+00:00 1
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.240673,"long":-122.087522,"ts":"2026-04-02T09:20:20-07:00"} 2026-04-07T06:00:11.040496+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-07T06:00:11.040496+00:00 1

SQL Query (read-only)

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