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 '05-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) = 'hino' AND LOWER(model) = '238/258/268/338 '05-on' AND TNT_vShared.did = '1623' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679381') 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 '05-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) = 'hino' AND LOWER(model) = '238/258/268/338 '05-on' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679381','726917','679423','679260','622733','622732','622647','609427','727069') 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

HINO 238/258/268/338 '05-ON BUMPER FOR SALE #679381 | MA
TRUCK 'N TRAILER MAGAZINE
SERVING THE TRUCKING, CONSTRUCTION AND RELATED INDUSTRIES SINCE 1966

HINO 238/258/268/338 '05-ON Bumper in FITCHBURG, MA

We're Sorry, This HINO 238/258/268/338 '05-ON has been Sold
Please explore similar units below that are still available and looking for new owners.

Similar Units

$226
0 HINO 268 BUMPER TRUCK PARTS #726917
Used 0 HINO 268
HINO Bumper
FITCHBURG, MA
$143
0 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #679423
Used 0 HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$339
0 HINO 268 BUMPER TRUCK PARTS #679260
Used 0 HINO 268
HINO Bumper
FITCHBURG, MA
$205
 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #622733
New HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$205
 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #622732
New HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$381
 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #622647
New HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$395
 HINO 268 BUMPER TRUCK PARTS #609427
New HINO 268
HINO Bumper
FITCHBURG, MA
$150
2004 STERLING 9500 BUMPER TRUCK PARTS #727069
Used 2004 STERLING 9500
STERLING Bumper
FITCHBURG, MA
Call For Price
0 OTHER NEW CHROME BUMPER TRUCK PARTS #738458
New 0 OTHER NEW CHROME
OTHER Bumper
MARIETTA, PA
Call For Price
0 OTHER NEW CHROME BUMPER TRUCK PARTS #738127
New 0 OTHER NEW CHROME
OTHER Bumper
MARIETTA, PA
Call For Price
0 OTHER NEW CHROME BUMPER TRUCK PARTS #734615
New 0 OTHER NEW CHROME
OTHER Bumper
MARIETTA, PA
$150
2006 STERLING 9500 BUMPER TRUCK PARTS #727053
Used 2006 STERLING 9500
STERLING Bumper
FITCHBURG, MA
$150
2011 INTERNATIONAL NAVISTAR 4300 BUMPER TRUCK PARTS #727039
Used 2011 INTERNATIONAL NAVISTAR 4300
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$150
2003 FREIGHTLINER FL70 BUMPER TRUCK PARTS #727027
Used 2003 FREIGHTLINER FL70
FREIGHTLINER Bumper
FITCHBURG, MA
$150
2005 INTERNATIONAL NAVISTAR 4400 BUMPER TRUCK PARTS #727009
Used 2005 INTERNATIONAL NAVISTAR 4400
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
$150
2000 INTERNATIONAL NAVISTAR 4900 BUMPER TRUCK PARTS #726999
Used 2000 INTERNATIONAL NAVISTAR 4900
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA