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 ('20021')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%CastersandGlides' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('CastersandGlides' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+CastersandGlides' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"CastersandGlides"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"CastersandGlides"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"CastersandGlides"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"CastersandGlides"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+CastersandGlides' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='CastersandGlides',`category_4` ='CastersandGlides') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'CastersandGlides,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('CastersandGlides', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Casters And Glides

Refine Search

  GO
 
Brand

Master Caster(11)

Alera(6)

Rubbermaid Commercial(4)

HON(2)

Safco(1)

 
Packaged Quantity

5 / Set(1)

 
Limited Warranty

Lifetime(1)

 
For Use With

Chair Mats; Hard Floors(5)

Alera Wire Shelving Units(3)

Carpeted Floors(3)

All Flooring Types(2)

Alera Height-Adjustable Table Bases: HTPN1B, HTPN1G, HT2SSB, HT2SSG, HT3SAB, HT3SAG(1)

HON Brigade Pedestals(1)

HON Height-Adjustable Tables(1)

Rubbermaid Commercial 5642, 5642-10, 5642-61, 5654-61 Big Wheel Carts(1)

Safco Task Master Industrial Seating Products; Carpeted Floors(1)

Rubbermaid Commercial FG1011 and FG9T13 Tilt Trucks, 2646 BRUTE Tandem Dollies(1)

Rubbermaid Commercial 6120 and 6152 Mop Buckets(1)

Rubbermaid Commercial 7470, 7570-88 WaveBrake Mop Buckets(1)

 
Diameter

2"(1)

 
Recommended Surface

Carpeting(1)

 
Country of Origin

CN(14)

TW(4)

DE(3)

US(2)

 
Color(s)

Matte Black(11)

Black(9)

Black/Gray/Silver(2)

Black/Silver(1)

 
Material(s)

Nylon(8)

Polyurethane(5)

Thermoplastic Rubber(2)

PVC(1)

Rubber; Structural Foam(1)

Plastic(1)

 
Load Capacity

110 lb(1)

 
Caster/Glide/Wheel

Caster(19)

Glide(3)

Wheel(1)

 
Weight Capacity

550 lb (110 lb Per Caster)(6)

600 lb (120 lb Per Caster)(2)

550 lb (110 lb Per Glide)(2)

2,400 lb (600 lb Per Caster)(1)

800 lb (200 lb Per Caster)(1)

500 lb (125 lb Per Caster)(1)

150 lb(1)

250 lb (50 lb Per Caster)(1)

65 lb(1)

 
Wheel Tread

Hard(11)

Soft(6)

1" Soft Non-Marking(2)

1" Soft(1)

 
Caster Quantity

5(13)

4(6)

1(4)

 
Stem Type

Grip Ring Type B Stem(7)

Grip Ring Stem(5)

Grip Ring Type B Stem; Grip Ring Type K Stem(4)

Grip Ring Type C Stem(2)

Grip Ring Type K Stem(1)

Rigid Mount Plate(1)

Swivel Mount Plate(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved