Brands Vehicles
Lowest Prices
Free Returns
Online Since 2009
JOIN GEARS TO SAVE 5%
Shop All Brands
Shopping for

1992 Honda Prelude

X
  2. Auto Parts
  3. Lighting and Electrical
  4. Lighting - Exterior
  5. Turn Signal Light Bulb
  6. Philips 3497LLB2 for 1992 Honda Prelude

Philips 3497LLB2 Turn Signal Light Bulb
for 1992 Honda Prelude

Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 1
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 2
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 3
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 4
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 5
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 6
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 7
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 8
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 9
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude Image 10
Philips 3497LLB2 Turn Signal Light Bulb - 1992 Honda Prelude

Philips
Brand:Philips
Part Number: 3497LLB2
UPC: 046677714413
Weight: 0.02 lbs
Condition:New



On Sale:

$9.28

Availability:
78 in Stock
Warehouse: US-7
Quantity:
1146 - Table 'ckd_cnslt_par.pies_data' doesn't exist

SELECT (CASE WHEN `data_1` = 'Product Description' THEN 100 WHEN `data_1` = 'Marketing Statement - Product Line' THEN 110 WHEN `data_1` = 'Marketing Statement - Sub Brand' THEN 120 WHEN `type` = 'Mktcp' THEN 200 WHEN `type` = 'Fab' OR `data_1` LIKE '%Feature%' OR `data_1` LIKE '%Benefit%' THEN 300 WHEN `data_1` LIKE 'Good Maintenance Practices%S1%H' THEN 310 WHEN `data_1` LIKE 'Good Maintenance Practices%S1%' THEN 315 WHEN `data_1` LIKE 'Good Maintenance Practices%S2%H' THEN 320 WHEN `data_1` LIKE 'Good Maintenance Practices%S2%' THEN 325 WHEN `data_1` LIKE 'Good Maintenance Practices%S3%H' THEN 330 WHEN `data_1` LIKE 'Good Maintenance Practices%S3%' THEN 335 WHEN `data_1` LIKE 'Good Maintenance Practices%S4%H' THEN 340 WHEN `data_1` LIKE 'Good Maintenance Practices%S4%' THEN 345 WHEN `data_1` LIKE 'Good Maintenance Practices%S5%H' THEN 350 WHEN `data_1` LIKE 'Good Maintenance Practices%S5%' THEN 355 WHEN `type` = 'Atrib' AND `data_1` NOT LIKE '%Warranty%' AND `data_1` NOT LIKE '%Prop%65%' THEN 400 WHEN `type` = 'Itchg' THEN 410 WHEN `type` = 'Atrib' AND `data_1` LIKE '%Prop%65%' THEN 490 WHEN `type` = 'Info' AND `data_10` NOT LIKE '' THEN 500 WHEN `type` = 'Wrt' THEN 600 WHEN `type` = 'Atrib' AND `data_1` LIKE '%Warranty%' THEN 600 ELSE 0 END) as 'product_features_sort', (CASE WHEN `data_1` = 'Product Description' THEN 'desc' WHEN `data_1` = 'Marketing Statement - Product Line' THEN 'desc' WHEN `data_1` = 'Marketing Statement - Sub Brand' THEN 'desc' WHEN `type` = 'Mktcp' THEN 'description' WHEN `type` = 'Fab' OR `data_1` LIKE '%Feature%' OR `data_1` LIKE '%Benefit%' THEN 'fab' WHEN `data_1` LIKE 'Good Maintenance Practices%' THEN 'fab' WHEN `type` = 'Atrib' AND `data_1` NOT LIKE '%Warranty%' THEN 'attr' WHEN `type` = 'Itchg' THEN 'attr' WHEN `type` = 'Info' AND `data_10` NOT LIKE '' THEN 'attr' WHEN `type` = 'Wrt' THEN 'warr' WHEN `type` = 'Atrib' AND `data_1` LIKE '%Warranty%' THEN 'warr' ELSE '' END) as 'product_features_name', (CASE WHEN `data_1` = 'Product Description' THEN `data_3` WHEN `data_1` = 'Marketing Statement - Product Line' THEN `data_3` WHEN `data_1` = 'Marketing Statement - Sub Brand' THEN `data_3` WHEN `type` = 'Mktcp' AND `data_3` NOT LIKE '' THEN `data_3` WHEN `type` = 'Mktcp' AND `data_2` NOT LIKE '' THEN `data_2` WHEN (`type` = 'Fab' OR `data_1` LIKE '%Feature%' OR `data_1` LIKE '%Benefit%') AND `data_3` NOT LIKE '' THEN `data_3` WHEN (`type` = 'Fab' OR `data_1` LIKE '%Feature%' OR `data_1` LIKE '%Benefit%') AND `data_2` NOT LIKE '' THEN `data_2` WHEN `data_1` LIKE 'Good Maintenance Practices%S%H' THEN `data_3` WHEN `data_1` LIKE 'Good Maintenance Practices%S%B%' THEN CONCAT('', `data_3`, '') WHEN `data_1` LIKE 'Good Maintenance Practices%' THEN `data_3` WHEN `type` = 'Atrib' AND `data_1` NOT LIKE '%Warranty%' THEN CONCAT(`data_1`, ': ', TRIM(CONCAT(`data_3`, ' ', `data_2`))) WHEN `type` = 'Itchg' AND `data_1` NOT LIKE '' AND `data_2` NOT LIKE '' THEN CONCAT(`data_2`, ' #: ', `data_1`) WHEN `type` = 'Itchg' AND `data_1` NOT LIKE '' THEN CONCAT('Interchange #: ', `data_1`) WHEN `type` = 'Info' AND `data_10` NOT LIKE '' THEN CONCAT('Country of Origin: ', `data_10`) WHEN `type` = 'Wrt' AND `data_2` NOT LIKE '' THEN CONCAT(`data_1`, ' ', `data_2`) WHEN `type` = 'Wrt' THEN `data_1` WHEN `type` = 'Atrib' AND `data_1` LIKE '%Warranty%' THEN `data_3` ELSE '' END) as 'product_features_value' FROM `ckd_cnslt_par`.`pies_data` WHERE `blacklisted` = 0 AND `data_1` NOT LIKE 'FAQ%' AND `data_1` NOT LIKE 'Signs of Wear%' AND `data_1` NOT LIKE 'PLNumberName' AND `data_1` NOT LIKE 'Mkt_Brand_Name' AND `data_1` NOT LIKE 'Mkt_State_Warranty_CA' AND `data_1` NOT LIKE 'Mkt_State_Warranty_DLR_US' AND `data_1` NOT LIKE 'Update Date' AND `data_1` NOT LIKE 'Web Content Update Date' AND `data_1` NOT LIKE 'ACD_RemanDes' AND `data_1` NOT LIKE 'Mkt_SubBrand_Name' AND `data_1` NOT LIKE 'Meets or Exceeds Original Equipment Manufacture Specifications' AND `product_id`= '2396003' ORDER BY product_features_sort ASC, product_features_name ASC, product_features_value ASC

[TEP STOP]