Log Out Log Out Log Outopen invoices
Language:
EnglishEspañol
My Shopping Cart
Your shopping cart is empty
Need help? Reach us at 1800.325.9708 Live Support

Tampers

   
select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '13' and ptpef2.products_extra_fields_value = 'Brown') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '1' and ptpef2.products_extra_fields_value = 'Wired') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '22' and ptpef2.products_extra_fields_value = '0.38') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '54' and ptpef2.products_extra_fields_value = 'Regular') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '20' and ptpef2.products_extra_fields_value = 'Indoor') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") select count(distinct(p.products_id)) as total from products p left join products_to_categories ptc on p.products_id = ptc.products_id left join products_to_products_extra_fields ptpef2 on ptpef2.products_id = p.products_id left join products_models_to_products p2m on p2m.products_id = p.products_id left join products_models pm on pm.ID = p2m.model_id where (p.products_status = 1) and (ptpef2.products_extra_fields_id = '56' and ptpef2.products_extra_fields_value = 'N/C') and ptc.categories_id = 298 and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G")
Brand
Flair Electronics
Color
Brown
Connectivity
Wired
Diameter (In)
0.38
Duty
Regular
Environment
Indoor
Loop
N/C
 Grid  List      1 items
3/8" Tamper Switch without Flange
Quick View
3/8" Tamper Switch without Flange
# VIP70TBR
Flair Electronics
Log In To View
Prices
 
1 items