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 Cars & Trucks%') OR (newcat = 'R/C Cars & Trucks' AND custom_newcat = '') OR custom_newcat = 'R/C Cars & Trucks') AND ((custom_subcat = '' AND subcat = 'R/C Crawler RTR Vehicles') OR custom_subcat='R/C Crawler RTR Vehicles')
R/C Cars & Trucks
Element RC Enduro Trail Truck, Trailwalker 4x4 RTR

$399.99
Element RC Enduro24 Sendero Trail Truck RTR, black and yellow

$159.99
Element RC Enduro24 Sendero Trail Truck RTR, red and blue

$159.99
RC4WD Gelande II RTR Truck Kit w/Cruiser Body Set

$993.99
Team Associated CR12 Tioga Trail Truck RTR

$289.99
Traxxas Mercedes-Benz G 63 AMG TRX6 6x6 1/10 Crawler, XL-5 HV...

$899.99
Traxxas Mercedes-Benz G 63 AMG TRX6 6x6 1/10 Crawler, XL-5 HV...

$899.99
Traxxas TRX-4 Sport 1/10 Scale 4X4 Trail Truck - Blue...

$495.99
Traxxas TRX-4 Sport 1/10 Scale 4X4 Trail Truck - Tan...

$495.99
Traxxas TRX4 1979 Chevy Blazer 1/10 Crawler, XL-5 HV, Titan 12T Orange

$715.99
Traxxas TRX4 1979 Ford Bronco 1/10 Crawler, XL-5 HV, Titan 12T Sunset

$669.99
Traxxas TRX4 Land Rover Defender 1/10 Crawler, XL-5 HV, Titan 12T Red

$669.99
Traxxas TRX4 Land Rover Defender 1/10 Crawler, XL-5 HV...

$669.99
Traxxas TRX4 Mercedes G 500 4X4 1/10 Crawler, XL-5 HV, Titan 12T Blue

$579.99
Traxxas TRX4 Mercedes G 500 4X4 1/10 Crawler, XL-5 HV, Titan 12T Red

$579.99
Element RC Enduro Gatekeeper Rock Crawler Buggy RTR

$550.99
Element RC Enduro Gatekeeper Rock Crawler Buggy RTR LiPo Combo

$606.99
Element RC Enduro Trail Truck, Sendero RTR

$478.99
Element RC Enduro Trail Truck...

$565.99
Element RC Enduro Trail Truck, Trailwalker 4x4 RTR Combo

$565.99