SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('10003')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%DisposableandSingleUseGloves' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('DisposableandSingleUseGloves' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+DisposableandSingleUseGloves' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"DisposableandSingleUseGloves"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"DisposableandSingleUseGloves"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"DisposableandSingleUseGloves"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"DisposableandSingleUseGloves"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+DisposableandSingleUseGloves' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='DisposableandSingleUseGloves',`category_4` ='DisposableandSingleUseGloves') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'DisposableandSingleUseGloves,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('DisposableandSingleUseGloves', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Disposable And Single Use Gloves

Refine Search

  GO
 
Brand

Medline(19)

Kimberly-Clark Professional*(18)

KleenGuard(12)

Curad(8)

First Aid Only(1)

KleenGuard*(1)

Conform(1)

 
Color

Off White(1)

 
Packaged Quantity

250 / Box(1)

 
Description

KleenGuard* G10 Nitrile Gloves(7)

Blue Disposable Gloves Nitrile(4)

Medline Pro Latex Gloves,100/BX, Medium(1)

Medline Pro Latex Gloves w/ Aloe, 100/BX, Large(1)

Medline Pro Nitrile Glove w/Aloe, 100/BX, XL(1)

Medline Pro Latex Gloves, 90/BX, X Large(1)

Medline Pro Nitrile Glove w/Aloe, 100/BX, Medium(1)

Blue Disposable Gloves, Nitrile(1)

Medline Pro Latex Gloves w/ Aloe, 100/BX, SM(1)

Medline Pro Nitrile Gloves w/Aloe, 100/BX, Large(1)

 
Glove Length

242 mm(26)

310 mm(4)

9.50"(1)

 
CE Score

EN420(7)

 
Manufacturer Part Number

CUR8107(1)

CUR8106(1)

MDS195284(1)

MDS195285(1)

MDS195287(1)

MDS195286(1)

CUR8105(1)

CUR8104(1)

90099CT(1)

90099(1)

6CUR9224(1)

6CUR9225(1)

6CUR9227(1)

6CUR9226(1)

MDS6801(1)

MDS6802(1)

PRO31763(1)

PRO31762(1)

PRO31764(1)

PRO31792(1)

PRO31794(1)

PRO31793(1)

PRO31761(1)

OAT6801(1)

MDS6804(1)

MDS6803(1)

MG6112(1)

MG6113(1)

MG6114(1)

90098CT(1)

90098(1)

50709(1)

50708(1)

55080(1)

55080CT(1)

55081CT(1)

55081(1)

50707(1)

50706(1)

50601(1)

FAE6018(1)

50602(1)

50603(1)

50604(1)

55082(1)

55082CT(1)

57374CT(1)

57374(1)

90096(1)

90096CT(1)

90097CT(1)

90097(1)

57373(1)

57372(1)

55083CT(1)

55083(1)

55084(1)

55084CT(1)

57371(1)

69318L(1)

 
Country of Origin

MY(28)

TH(15)

CN(8)

ID(4)

US(3)

Malaysia(1)

ML(1)

 
Material

Nitrile(1)

 
Color(s)

Purple(14)

Green(11)

Blue(10)

Beige(8)

Arctic Blue(7)

Sterling Gray(4)

Black(3)

White(1)

Clear(1)

 
Material(s)

Nitrile(47)

Latex(8)

Stretch Vinyl(4)

 
Length

9 1/2"(39)

9"(11)

 
Quantity

200 per box(1)

 
Style

Disposable(55)

Exam, Latex(3)

All Purpose(1)

 
Weight

0.016 lbs(4)

 
Thickness

6 mil(19)

2 mil(9)

5.5 mil; 5.9 mil(4)

3.6 mil(4)

6.7 mil(4)

3.5 mil(4)

5.9 mil(4)

6.3 mil; 6.7 mil(3)

2.8 mil(3)

3 mil(3)

5 mil(1)

 
Size Group

Large(15)

X-Large(14)

Medium(14)

Small(12)

X-Small(2)

X-Large (Size 10)(1)

One Size(1)

 
Hand Specific

Ambidextrous(54)

Amidextrous(4)

 
Wrist Style

Beaded Cuff(49)

Rolled Beaded Cuff(1)

 
Thumb Style

Straight(29)

 
Powdering

Powder-Free(53)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved