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','679424','679423','679260','622733','622732','622647','609427','701159') 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

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

 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #679381

HINO 238/258/268/338 '05-ON Description

FRONT BUMPER, CHROMED
Specifications
Price$381
Stock #66742
VINVIN not Provided

Similar Units

$246
0 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #679424
New 0 HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$246
0 HINO 238/258/268/338 '05-ON BUMPER TRUCK PARTS #679423
New 0 HINO 238/258/268/338 '05-ON
HINO Bumper
FITCHBURG, MA
$584
0 HINO 268 BUMPER TRUCK PARTS #679260
New 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
$100
2011 INTERNATIONAL NAVISTAR 4400 BUMPER TRUCK PARTS #701159
Used 2011 INTERNATIONAL NAVISTAR 4400
INTERNATIONAL NAVISTAR Bumper
FITCHBURG, MA
Call For Price
2007 INTERNATIONAL PC015 BUMPER TRUCK PARTS #699092
Used 2007 International PC015
International Bumper
ELKTON, MD
Call For Price
2012 INTERNATIONAL DURASTAR 4300 BUMPER TRUCK PARTS #694784
Used 2012 INTL DuraStar 4300
International Bumper
ELKTON, MD
Call For Price
2003 ISUZU NPR-HD BUMPER TRUCK PARTS #694754
Used 2003 Isuzu NPR-HD
Isuzu Bumper
ELKTON, MD
Call For Price
2000 OTHER OTHER BUMPER TRUCK PARTS #694471
Used 2000 Other Other
Other Bumper
ELKTON, MD
$250
2016 FREIGHTLINER CASCADIA 125 BUMPER TRUCK PARTS #694386
Used 2016 Freightliner Cascadia 125
Freightliner Bumper
ELKTON, MD
$63
0 FREIGHTLINER CASCADIA BUMPER TRUCK PARTS #694327
New 0 FREIGHTLINER CASCADIA
FREIGHTLINER Bumper
FITCHBURG, MA
$583
0 FREIGHTLINER CASCADIA BUMPER TRUCK PARTS #694225
New 0 FREIGHTLINER CASCADIA
FREIGHTLINER Bumper
FITCHBURG, MA
Call For Price
2006 GMC W4500 BUMPER TRUCK PARTS #690524
Used 2006 GMC W4500
GMC Bumper
ELKTON, MD