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 '04-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) = 'volvo' AND LOWER(model) = 'vnl '04-on' AND TNT_vShared.did = '1623' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679549') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND TNT_vShared.status = 'Live' AND TNT_vShared.list = 'Public' 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 '04-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) = 'volvo' AND LOWER(model) = 'vnl '04-on' AND TNT_vShared.list != 'Private' AND TNT_vShared.iid NOT IN('679549','866688','679550','1209295','1199149','1196399','1196369','1196146','1196094') AND TNT_vShared.photo = 1 AND dstatus='On' AND dplock!='Yes' AND dphide!='Yes' AND TNT_vShared.status = 'Live' AND TNT_vShared.list = 'Public' AND CURDATE() <= TNT_vShared.endate ORDER BY TNT_vShared.iid DESC LIMIT 0,8

VOLVO VNL '04-ON BUMPER FOR SALE #679549 | MA
TRUCK 'N TRAILER MAGAZINE
SERVING THE TRUCKING, CONSTRUCTION AND RELATED INDUSTRIES SINCE 1966

VOLVO VNL '04-ON Bumper for sale in FITCHBURG, MA

 VOLVO VNL '04-ON BUMPER TRUCK PARTS #679549
 VOLVO VNL '04-ON BUMPER TRUCK PARTS #679549-

VOLVO VNL '04-ON Description

CORNER BUMPER W/O FOG LAMP HOLE, RH (OLD STYLE)
Specifications
Price$93
Stock #66724
VIN/SerialVIN not Provided

Similar Units

$150
2014 VOLVO VNM BUMPER TRUCK PARTS #866688
Used 2014 VOLVO VNM
VOLVO Bumper
FITCHBURG, MA
$93
0 VOLVO VNL '04-ON BUMPER TRUCK PARTS #679550
Used 0 VOLVO VNL '04-ON
VOLVO Bumper
FITCHBURG, MA
$150
2013 MACK CXU613 BUMPER TRUCK PARTS #1209295
Used 2013 MACK CXU613
MACK Bumper
FITCHBURG, MA
$150
2007 INTERNATIONAL 4300 BUMPER TRUCK PARTS #1199149
Used 2007 INTERNATIONAL 4300
INTERNATIONAL Bumper
FITCHBURG, MA
$150
2012 INTERNATIONAL TERRASTAR BUMPER TRUCK PARTS #1196399
Used 2012 INTERNATIONAL TERRASTAR
INTERNATIONAL Bumper
FITCHBURG, MA
$150
1988 MACK RD BUMPER TRUCK PARTS #1196369
Used 1988 MACK RD
MACK Bumper
FITCHBURG, MA
$150
0 INTERNATIONAL TERRASTAR BUMPER TRUCK PARTS #1196146
Used 0 INTERNATIONAL TERRASTAR
INTERNATIONAL Bumper
FITCHBURG, MA
$150
2011 FREIGHTLINER MT55 BUMPER TRUCK PARTS #1196094
Used 2011 FREIGHTLINER MT55
FREIGHTLINER Bumper
FITCHBURG, MA
Call For Price
1987 VOLVO FE BUMPER TRUCK PARTS #721563
Used 1987 Volvo FE
Volvo Bumper
ELKTON, MD
$1,000
2006 VOLVO OTHER BUMPER TRUCK PARTS #690478
Used 2006 Volvo Other
Volvo Bumper
ELKTON, MD
$190
2003 VOLVO VNM BUMPER TRUCK PARTS #686264
Used 2003 Volvo VNM
Volvo Bumper
ELKTON, MD
$190
2006 VOLVO VNM BUMPER TRUCK PARTS #686113
Used 2006 Volvo VNM
Volvo Bumper
ELKTON, MD
$190
2003 VOLVO VNM BUMPER TRUCK PARTS #681050
Used 2003 Volvo VNM
Volvo Bumper
ELKTON, MD
$190
2005 VOLVO VNM BUMPER TRUCK PARTS #681049
Used 2005 Volvo VNM
Volvo Bumper
ELKTON, MD
$190
2003 VOLVO VNM BUMPER TRUCK PARTS #680897
Used 2003 Volvo VNM
Volvo Bumper
ELKTON, MD
Call For Price
0 FREIGHTLINER STAINLESS BUMPER TRUCK PARTS #1193771
Used 0 FREIGHTLINER STAINLESS
FREIGHTLINER Bumper
MARIETTA, PA