SELECT p_model, p_gtin, CONCAT(p_title_es,'
(', p_title ,')') as p_titlang, p_title, p_descrip_es as p_descrip, p_longDescrip, p_sellBy, p_sell, p_listPrc, p_mapPrc, p_sku, prc_bustCart, prc_bustSite, prc_bustEmail, prc_bustFeed, v_id, v_name, v_code, sp_price, sp_height, sp_width, sp_depth, sp_cube, sp_weight, sp_zip, sp_freightClass, sp_fco, '' as wlmodel, MAX(IF(m_type = "Image", m_value, NULL)) AS image, MAX(IF(m_type = "Spec Sheet", m_value, NULL)) AS sheet, MAX(IF(m_type = "Video", m_value, NULL)) as video, CONCAT(sf_name, ":", sf_title) AS plug, c_id, c_name, c_site, c_desc FROM products JOIN pricing ON p_prc_id = prc_id JOIN vendor ON prc_v_id = v_id LEFT JOIN ship_prod ON sp_p_id = p_id JOIN media ON m_p_id = p_id LEFT JOIN special_features ON p_descrip LIKE CONCAT("% ", sf_name,"%") AND sf_class = "Plug Type" LEFT JOIN prod_cat ON pc_p_id = p_id LEFT JOIN category ON pc_c_id = c_id WHERE p_id=:p_id GROUP BY p_id Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can (Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can)
Llamanos gratis



Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can
(Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can)



Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can
Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can (Magnified)
Witt Industries M3601-ATL-BN Cover Garbage Waste Receptacle Can
Precio:
Precio de Lista: $268.00
$147.40
Envio:
×
Agrega al Carrito
You have 0 in your cart


Send to my wish list

Se el primero en dar una opinión




Información del Producto

Especificaciones

Fabricante Witt Industries
Modelo # WTI-M3601-ATL-BN
Empacado Each

Dimensiones del Producto

  • Ancho: 23.75"
  • Peso: 11.00 lbs
Share this result using
     

Opiniones

Se el primero en opinar!

Entre o regístrese para opinar

Productos Similares

Witt Industries M3601-ATL-BK Cover Garbage Waste Receptacle Can
Witt Industries M3601-ATL-BK Cover Garbage Waste Receptacle Can
(Witt Industries M3601-ATL-BK Cover Garbage Waste Receptacle Can)

Oakley Collection Ash Top Lid, 23-3/4" diameter, black finish, steel construction, for outdoor use, for M3601

Witt Industries M3601-RC-BN Waste Receptacle Outdoor
Witt Industries M3601-RC-BN Waste Receptacle Outdoor
(Witt Industries M3601-RC-BN Waste Receptacle Outdoor)

Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, rain cap top lid, brown finish, steel construction, for outdoor use

Witt Industries M3601-DT-GN Waste Receptacle Outdoor
Witt Industries M3601-DT-GN Waste Receptacle Outdoor
(Witt Industries M3601-DT-GN Waste Receptacle Outdoor)

Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, dome top lid, green finish, steel construction, for outdoor use

Witt Industries M3601-RC-BK Waste Receptacle Outdoor
Witt Industries M3601-RC-BK Waste Receptacle Outdoor
(Witt Industries M3601-RC-BK Waste Receptacle Outdoor)

Oakley Collection Trash Receptacle, 28" diameter, 36"H, 36 gallon capacity, rain cap top lid, black finish, steel construction, for outdoor use



Page generated in 0.0418 sec.