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('679550') 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('679550','1225477','1223139','1222942','1222941','1222940','1222297','1222296','1219221') 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 #679550 | 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 #679550
 VOLVO VNL '04-ON BUMPER TRUCK PARTS #679550-

VOLVO VNL '04-ON Description

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

Similar Units

Call For Price
1996 GMC C7000 BUMPER TRUCK PARTS #1225477
Used 1996 GMC C7000
GMC Bumper
FITCHBURG, MA
$250
0 PETERBILT 379 BUMPER TRUCK PARTS #1223139
Used 0 PETERBILT 379
PETERBILT Bumper
FITCHBURG, MA
$578
0 PETERBILT 389 BUMPER TRUCK PARTS #1222942
Used 0 PETERBILT 389
PETERBILT Bumper
FITCHBURG, MA
$578
0 PETERBILT 379 BUMPER TRUCK PARTS #1222941
Used 0 PETERBILT 379
PETERBILT Bumper
FITCHBURG, MA
$579
0 KENWORTH W900 B/L BUMPER TRUCK PARTS #1222940
Used 0 KENWORTH W900 B/L
KENWORTH Bumper
FITCHBURG, MA
$893
0 PETERBILT 379 BUMPER TRUCK PARTS #1222297
Used 0 PETERBILT 379
PETERBILT Bumper
FITCHBURG, MA
$894
0 KENWORTH W900 B/L BUMPER TRUCK PARTS #1222296
Used 0 KENWORTH W900 B/L
KENWORTH Bumper
FITCHBURG, MA
$150
2000 MACK MR BUMPER TRUCK PARTS #1219221
Used 2000 MACK MR
MACK 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
$150
2004 STERLING ACTERRA BUMPER TRUCK PARTS #1219201
Used 2004 STERLING ACTERRA
STERLING Bumper
FITCHBURG, MA