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

Currently Filtered by

Category

Floor Plants

Refine Search

  GO
 
Brand

Hoover Commercial(22)

Janitized(15)

Sanitaire(15)

Green Klean(11)

DataVac(3)

Oreck Commercial(3)

VacFX(1)

ProTeam(1)

 
For Use With

Sanitaire SC600 & SC800 Series(2)

Oreck U2000R-1, U2000RB-1, XL2100RHS(2)

Standard S-Bend Wand(2)

Sanitaire Style Z Series(2)

Hoover CH54013, CH54113, CH54015, CH54115(2)

Sanitaire SC5700, SC5800(2)

Advance VU500, Triple S Triumph; OEM #107407587(1)

Advance VU500 12" and 15" Uprights(1)

Windsor Chariot iVac 34, Nuwave, Wave 28(1)

Hoover CH95519(1)

Hoover CH93619(1)

Hoover Commercial Backpack Vacuum C2401(1)

Hoover C1703900(1)

Hoover Commercial C1660900(1)

Hoover Commercial CH54015, CH54115, CH54013, CH54113(1)

Hoover Commercial CH53005, UH30301(1)

Hoover CH34006, CH93406(1)

Hoover CH50100, CH50102(1)

NSS Pacer 30(1)

Hoover AH10270(1)

Hoover CH34006(1)

Hoover CH32008(1)

Hoover Commercial C1431, C1431-010, C1433, C1433-010, C1631, C1633(1)

Hoover Commercial CH50100, CH50102(1)

Hoover Commercial C1703-900(1)

Hoover CH30000(1)

Hoover CH90040, CH93406(1)

DataVac Pro MDV-3TCA, 3ESD1, 2TCA, 2TA(1)

DataVac MDV-1BA(1)

DataVac MDV-3TCA, DV3ESD1, MDV-2TCA, MDV-2TA(1)

NSS Outlaw; ProTeam QuarterVac; Sandia; Sanitaire SC408(1)

Advance Spectrum S12, D12, S15, D15, GUl; Clarke CarpetMaster(1)

NSS M1 PIG(1)

Sanitaire 785(1)

Windsor Sensor XP/S Micro Filter; OEM #5301ER(1)

Windsor Sensor S Exhaust Filter; OEM #2846(1)

Karcher/Tornado CV30/1, CV38/2 & CV48/2 Paper Bag; OEM #6.904-294.0(1)

Nilfisk CarpeTwin Upright 16XP/20XP Paper Bag; OEM #323153(1)

Panasonic Upright Type U Paper Bag; OEM #MC-115PT(1)

ProTeam 10 Qt. Super Coach, MegaVac Paper Bag; OEM #100331(1)

ProTeam 100331; Sanitaire SC530; Advance Agility 10 Qt & Clarke Comfort 1471097500; Mosquito 10-1041; Perfect Vac PB1001(1)

ProTeam 6 Qt. QuarterVac Paper Bag; OEM #100431(1)

ProTeam Super Coach Pro 10 Qt.; OEM #107313(1)

ProTeam Super Coach Pro 6, GoFree Pro & ProVac FS 6 Qt.; OEM #107314(1)

Windsor Sensor S, S2, XP, Versamatic Plus; OEM #5300(1)

Allstar Javelin 12'' Series Upright Vacuums; Windsor Sensor S/S2 & XP, Versamatic Plus; Karcher Prochem PV12 & U-Vac UPV12; Sanitaire EON; Kenmore 50015; Triple S Prosense; OEM #5300(1)

Sanitaire SC412(1)

Hoover C1703-900, CH53005, U6485900, U5140900; Pacific Steamex Scholar; Royal CR50005(1)

Sanitaire SC3683A, SC3683B(1)

Sanitaire SC9100 Series(1)

Sanitaire EC880, EC890, S630, S640, S650, S660, S670, S9020, SC670, SC680, SC690, SC880, SC890, SC9050(1)

Sanitaire SC5713B, SC5745B, SC5815D, SC5845SB(1)

Sanitaire SC5745, SC5815, SC5845, SC5713(1)

Sanitaire SC3700A(1)

Sanitaire SC5745, SC5845, SC5713, SC5815(1)

AllStar Javelin 14/18; Triple S Prosense II; Windsor Versamatic(1)

Windsor Sensor SR12, SR15, SR18, XP12, XP15(1)

Windsor Sensor, Triple S ProSense, ProChem PV12, Uvac UPV12, CVU and Hillyard Trident V12XP, V12S Uprights(1)

Advac; Lindhaus CH Pro, Dynamic 300/380/450, Healthcare Pro, RX HEPA; Minuteman Phenom 15, 18; Nilfisk Carpetwin Upright 14, 18(1)

Advance Spectrum CarpetMaster Paper Bag; OEM #1471058500(1)

ProTeam ProGen 12, 15(1)

 
Diameter

15.4"(1)

 
Country of Origin

CN(67)

US(4)

 
Color(s)

Black(4)

 
Material(s)

Micro Fiber(1)

Foam; Plastic(1)

Fabric(1)

Plastic(1)

 
OEM/Compatible

OEM(40)

Compatible(27)

 
Style

Upright Vacuum(1)

S; SP(1)

XP; S(1)

MM(1)

0.3 Micron Filter(1)

 
Size Group

Standard(2)

Style LS(2)

Allergen SB(2)

XL Standard Filtration(2)

Allergen CB1(1)

Standard CU2(1)

Standard B(1)

One Size Fits All(1)

Allergen C1(1)

HEPA CC1(1)

XL Advanced Filtration(1)

 
Type

Upright(1)

Premium Allergen Bag(1)

Exhaust Filt(1)

Micron Filter(1)

Open Mouth(1)

 
Capacity Range (Volume)

10 qt(1)

6 qt(1)

9.5 qt(1)

4 qt(1)

8.95 qt(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved