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

Currently Filtered by

Category

Furniture Cleaners

Refine Search

  GO
 
Brand

Pledge(8)

OLD ENGLISH(6)

Diversey(5)

Misty(5)

Boardwalk(4)

Murphy Oil Soap(4)

Method(4)

Claire(2)

WEIMAN(2)

Chase Products(1)

Coastwide Professional(1)

 
Application

Furniture(11)

Dusting Solution(8)

Cabinets; Furniture; Paneling(6)

Floors(4)

Furniture; Appliances; Woodwork(2)

Woodwork(2)

Floors; Furniture(2)

Wood Furniture; Cabinets(2)

Furniture Scratch Cover(2)

Wood Furniture Polish(1)

Dust Mop Treatment(1)

Anywhere Dust Collects(1)

 
Applicable Material

Wood(16)

Granite; Leather; Marble; Vinyl; Wood(8)

Asphalt; Finished/Sealed Wood; Vinyl Composition Tile (VCT); Solid Vinyl Tile (SVT); Linoleum; Sheet Vinyl; Laminates; Rubber; Quarry Tile; Sealed/Engineered Stone; Sealed Cement/Concrete; Ceramic Tile; Terrazzo(4)

Wood; Chrome; Stainless Steel; Brass; Leather; Vinyl; Marble; Glass(2)

Asbestos; Asphalt Tile; Cement/Concrete; Ceramics; Cork; Linoleum; Magnesite; Quarry Tile; Rubber; Sealed/Engineered Stone; Vinyl; Wood(2)

Wood; Chairs; Tables; Laundry Stains; Leather(2)

Finished Hardwood(2)

Light and Dark Finished Wood Furniture; Nonporous Surfaces(1)

Dust Cloths; Dust Mops(1)

Chrome; Plastic; Simulated Wood; Stainless Steel; Vinyl(1)

Asphalt Tile; Cement/Concrete; Ceramics; Cork; Finished/Sealed Wood; Laminates; Linoleum; Sheet Vinyl; Solid Vinyl Tile (SVT); Terrazzo; Vinyl Composition Tile (VCT)(1)

Leather; Stainless Steel; Vinyl; Wood(1)

 
Dirt Types

Dust(6)

Debris; Dust; Soil(6)

Dirt; Dust; Fingerprints; Smudges(5)

Grease; Grime(4)

Scuffs(2)

Scratches(2)

Dust; Fingerprints; Water Marks; Wax(2)

Dirt; Grease; Grime(2)

Dirt; Dust; Grease; Grime; Wax(2)

Dust; Dirt; Smudges; Fingerprints(2)

Dirt;Dust;Fingerprints;Smudges(1)

Dander; Dust; Fingerprints; Mites; Pollen; Smudges(1)

Dirt; Dust(1)

Dust; Fingerprint; Water Mark; Wax(1)

Dust; Fingerprint(1)

Dust; Finger Marks; Smudges; Stains(1)

Dust; Grease(1)

Dust;Fingerprint;Water Mark;Wax(1)

 
Physical Form

Liquid(31)

Aerosol(5)

Spray(2)

 
Volume Capacity

9.7 oz(4)

17 oz(4)

14.2 oz(4)

32 oz(4)

19 oz(3)

25 oz(2)

12.5 oz(2)

28 oz(2)

20 oz(2)

1 gal(2)

145 oz(2)

13.8 oz(1)

14 oz(1)

16 oz(1)

8 oz(1)

18 oz(1)

15 oz(1)

 
Chemical Compound

D-Glucopyranose; Oligomers; Decyl Octyl Glycosides(4)

Distillates (petroleum);light hydrotreated(2)

C13-14 Alkane(2)

2-Bromo-2-Nitropropane-1; 3-Diol; Dimethicone; Glycerin; Isoparrafin; Nitrogen; Sorbitan Oleate(2)

Water based(1)

Aqua; Butane; Propane; Limonene; Ammonium Hydroxide(1)

Distillates; Mineral Oil; Propane; Naphtha; D-Limonene(1)

Butane; d-Limonene; Propane(1)

Isoparaffinic Solvent(1)

Distillates (petroleum)(1)

Ammonia(1)

Petroleum(1)

Mineral Oil(1)

White Mineral Oil(1)

 
Country of Origin

US(40)

CA(2)

 
Packing Type

Bottle(3)

Trigger Spray Bottle(1)

Aerosol(1)

 
Capacity (Volume)

8 oz(2)

1 gal(1)

32 oz(1)

10 oz(1)

 
Scent

Lemon(15)

Almond(4)

Pine(3)

Fresh Lemon(3)

Citronella Oil Scent(2)

Unscented(2)

Citrus(2)

Sweet; Woody(2)

Slight Acrylic(2)

Grapefruit(1)

Slight Fruity(1)

Amine(1)

Orange(1)

Orange Clean(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved