Contact Sales l Support l or Call us today at (866) 446-3595 Remote Technical Support

Accessories,SPOT Monitoring Module

Compare up to 4 models
Sort By:
Showing: 21 - 40 of 76 Matching
Filter Your Results

No option to filter

DWC-BLJUNC
Junction Box, Bullet, Panoramic, DWC-BLJUNC
Add to quote builder
DWC-MCAM
Micro Dome Angle Mount Bracket
Add to quote builder
DWC-MCSM
Micro Dome Surface Mount Bracket
Add to quote builder
DWC-MCBLK
Micro Dome Trim Rim, Black Color
Add to quote builder
DWC-MCRED
Micro Dome Trim Rim, Red Color
Add to quote builder
DWC-MCBLU
Micro Dome Trim Ring, Blue Color
Add to quote builder
DWC-MCGRN
Micro Dome Trim Ring, Green Color
Add to quote builder
DWC-IRRMT-OMNI
Omni Plus IR Remote Controller
Add to quote builder
DWC-V1CM
Outdoor Dome Ceiling Mount Bracket
Add to quote builder
DWC-VFZCM
Outdoor Dome Ceiling Mount Bracket
Add to quote builder
DWC-V7CM
Outdoor Dome Ceiling Mount Bracket
Add to quote builder
DWC-PZCM
Outdoor Dome Ceiling Mount Bracket
Add to quote builder
DWC-V1JUNC
Outdoor Dome Junction Box
Add to quote builder
DWC-VFZJUNC
Outdoor Dome Junction Box
Add to quote builder
DWC-V7JUNC
Outdoor Dome Junction Box
Add to quote builder
DWC-V1WM
Outdoor Dome Wall Mount Bracket
Add to quote builder
DWC-VVLWM
Outdoor Dome Wall Mount Bracket
Add to quote builder
DWC-V9WM
Outdoor Dome Wall Mount Bracket
Add to quote builder
DWC-VFZWM
Outdoor Dome Wall Mount Bracket
Add to quote builder
DWC-PZWM
Outdoor Dome Wall Mount Bracket
Add to quote builder

SELECT p.*, a.attribute_id, IFNULL(a.attribute_name,' ') as resolution, CASE WHEN p.product_comingsoon = 1 THEN 1 WHEN p.product_new = 1 THEN 2 WHEN p.product_clearance = 1 THEN 4 WHEN p.product_discontinued = 1 THEN 5 WHEN p.product_outofstock = 1 THEN 6 ELSE 3 END AS sort FROM products as p left join m_product_attribute m ON m.product_id = p.product_id and m.attribute_id in (select attribute_id from attribute where attribute_type_id = 489) left join attribute a on m.attribute_id = a.attribute_id inner join m_product_category as mapC on mapC.product_id = p.product_id INNER JOIN category as c on c.category_id = mapC.category_id WHERE p.product_status = 1 AND show_product_list = 1 AND show_on_outlet_store = 0 and ( c.category_name in ( "Accessories","SPOT Monitoring Module" ) ) and product_discontinued <> 1 group by p.product_id ORDER BY sort, p.product_order, resolution DESC, p.product_name ASC

Sort By:
Showing: 21 - 40 of 76 Matching