Log Out Log Out Log Out Cerrar sesiónopen invoices
Idioma:
EnglishEspañol
Shopping Cart Icon
Mi carrito (0)
Arror Down Icon
Mi carrito de compras
alt"Ajax close button images"
Su cesta está vacía
Necesitas ayuda? Contáctanos en 1800.325.9708 Soporte vital
Inicio » Control de Acceso & Intercomunicador » Dispositivos de Salida » Barra de Empuje

Barra de Empuje

   
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 = '111' and ptpef2.products_extra_fields_value = 'Negro Anodizado') and ptc.categories_id = 356 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 = '102' and ptpef2.products_extra_fields_value = 'Exterior') and ptc.categories_id = 356 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 = '71' and ptpef2.products_extra_fields_value = 'Plata') and ptc.categories_id = 356 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 = '106' and ptpef2.products_extra_fields_value = '12 - 24 VDC') and ptc.categories_id = 356 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")
Marca
Seco-Larm
Securitron
Acabado
Negro Anodizado
Ambiente
Exterior
Color
Plata
Voltaje de Operación
12 - 24 VDC
Pixel Trans
Pixel Trans
 Cuadrícula  List      4 artículos
Barra de Empuje para Puertas de Salida,
Barra de Empuje para Puertas de Salida,
# SD-962AR-36A
Seco-Larm
Inicie sesión para ver precios
 
Barra de Salida Electromecánica (EMB) de 48" - Acabado Anodizado Negro
Barra de Salida Electromecánica (EMB) de 48" - Acabado Ano...
# WEMB-BK-48
Securitron
Inicie sesión para ver precios
 
Barra Empujar-to-Salir para Puertas de 36"
Barra Empujar-to-Salir para Puertas de 36"
# SD-961A-36
Seco-Larm
Inicie sesión para ver precios
 
Barra Iluminada de Presionar para Abrir
Barra Iluminada de Presionar para Abrir
# SD-961A-36SLQ
Seco-Larm
Inicie sesión para ver precios
 
4 artículos