WHERE (active = 1 AND custom_active = -1 OR custom_active = 1) AND last_square_price != 0 AND name NOT LIKE '%damage%' AND category NOT LIKE '%clearance%' AND subcat NOT LIKE '%clearance%' AND raw_table != 'CSV_hrp' AND ((custom_newcat = '' AND newcat = '' AND category LIKE '%R/C Scale Accessories%') OR (newcat = 'R/C Scale Accessories' AND custom_newcat = '') OR custom_newcat = 'R/C Scale Accessories') AND ((custom_subcat = '' AND subcat = 'Light Kits') OR custom_subcat='Light Kits')
R/C Scale Accessories
Traxxas Blazer Led light set, complete with power supply
$86.99
Traxxas Bronco LED light set, complete with power supply
$101.99
Traxxas LED headlight/tail light kit
$28.99
Traxxas LED light harness, rock lights, TRX-6 6X6
$14.99
Traxxas LED light kit, complete with power supply
$86.99
Traxxas LED light set, Maxx, complete
$144.99
Traxxas LED lightbar kit /power supply, TRX-4
$72.99
Traxxas LED lights, power supply , TRX-4/ 3-in-1 wire harness
$28.99
Traxxas LED rock light kit, TRX-4
$31.99
Traxxas Mercedes LED light set, complete with power supply
$101.99
Head & Tail lights - 5mm LEDs with Chrome mounting buckets
$16.99
LED Ground Effects kit - Blue
$19.99
LED Ground Effects kit - Red
$19.99
LED Ground Effects kit - White
$19.99
LED light kit for cars & trucks 12 lights
$44.99
Light strip LED blue
$8.99
Light strip LED green
$8.99
Light strip LED red
$8.99
Light strip LED white
$20.99
Police Emergency Light Kit
$20.99
