WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '02-on' AND TNT_vShared.did = '1623' AND TNT_vShared.list != 'Private' at line 15]
SELECT TNT_vShared.*, TNT_vShared.iid AS vid, TNT_vShared.vscseo as scseo, TNT_vShared.vscweb as scweb, TNT_vShared.vpl as pl, DATEDIFF(CURDATE(), TNT_vShared.edate) AS ddif,dpcity,dpstate FROM (TNT_vShared) LEFT JOIN TNT_dealers ON TNT_dealers.did = TNT_vShared.did WHERE LOWER(make) = 'international navistar' AND LOWER(model) = 'durastar/ transtar '02-on' AND TNT_vShared.did = '1623' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679401') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND CURDATE() <= TNT_vShared.endate ORDER BY TNT_vShared.iid DESC LIMIT 0,8

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '02-on' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT' at line 15]
SELECT TNT_vShared.*, TNT_vShared.iid AS vid, TNT_vShared.vscseo as scseo, TNT_vShared.vscweb as scweb, TNT_vShared.vpl as pl, DATEDIFF(CURDATE(), TNT_vShared.edate) AS ddif,dpcity,dpstate FROM (TNT_vShared) LEFT JOIN TNT_dealers ON TNT_dealers.did = TNT_vShared.did WHERE LOWER(make) = 'international navistar' AND LOWER(model) = 'durastar/ transtar '02-on' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679401','701159','679682','679681','679478','679403','679400','679399','622735') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND CURDATE() <= TNT_vShared.endate ORDER BY TNT_vShared.iid DESC LIMIT 0,8

INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER FOR SALE #679401 | MA
TRUCK 'N TRAILER MAGAZINE
SERVING THE TRUCKING, CONSTRUCTION AND RELATED INDUSTRIES SINCE 1966

New INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON Bumper for sale in FITCHBURG, MA

 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #679401

INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON Description

FRONT BUMPER (E.D.P ARGENT) W/ LARGE TOWHOOK HOLE
Specifications
Price$120
Stock #56552
VINVIN not Provided

Similar Units

$100
2011 INTERNATIONAL NAVISTAR 4400 BUMPER TRUCK PARTS #701159
Used 2011 INTERNATIONAL NAVISTAR 4400
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$50
0 INTERNATIONAL NAVISTAR PROSTAR BUMPER TRUCK PARTS #679682
New 0 INTERNATIONAL NAVISTAR PROSTAR
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$50
0 INTERNATIONAL NAVISTAR PROSTAR BUMPER TRUCK PARTS #679681
New 0 INTERNATIONAL NAVISTAR PROSTAR
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$67
0 INTERNATIONAL NAVISTAR 4700 BUMPER TRUCK PARTS #679478
Used 0 INTERNATIONAL NAVISTAR 4700
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$265
0 INTERNATIONAL NAVISTAR 4700 BUMPER TRUCK PARTS #679403
New 0 INTERNATIONAL NAVISTAR 4700
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$144
0 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #679400
New 0 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$110
0 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #679399
New 0 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$147
 INTERNATIONAL NAVISTAR 4700 BUMPER TRUCK PARTS #622735
New INTERNATIONAL NAVISTAR 4700
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$200
 INTERNATIONAL NAVISTAR 4700 BUMPER TRUCK PARTS #622734
New INTERNATIONAL NAVISTAR 4700
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$66
 INTERNATIONAL NAVISTAR PROSTAR BUMPER TRUCK PARTS #439772
New INTERNATIONAL NAVISTAR PROSTAR
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$66
 INTERNATIONAL NAVISTAR PROSTAR BUMPER TRUCK PARTS #439771
New INTERNATIONAL NAVISTAR PROSTAR
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$229
 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #439770
New INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$229
 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #439769
New INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$229
 INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON BUMPER TRUCK PARTS #439767
New INTERNATIONAL NAVISTAR DURASTAR/ TRANSTAR '02-ON
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$335
 INTERNATIONAL NAVISTAR 4300 BUMPER TRUCK PARTS #429255
New INTERNATIONAL NAVISTAR 4300
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$410
0 INTERNATIONAL NAVISTAR 4300 BUMPER TRUCK PARTS #398403
Used 0 INTERNATIONAL NAVISTAR 4300
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA