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

Currently Filtered by


Boardwalk

Refine Search

  GO
 
Category Filter

Mop Heads(165)

Gloves(107)

Cleaners & Detergents(89)

Floor Pads(74)

Utensils(73)

Towels & Wipes(70)

Bags(62)

Cups(43)

Brooms(27)

Straws/Stems/Sticks(27)

Toilet Tissues(25)

Personal Soaps(24)

Mop & Broom Handles(23)

Mops(23)

Air Fresheners/Odor Eliminators(22)

Toilet & Urinal Deodorizers(22)

Broom Heads(21)

Food Containers(19)

Dusters(18)

Cleaning Brushes(16)

Apparel(15)

Food Wrap(14)

Dinnerware(14)

Scouring Pads/Sticks(10)

Cup Lids(9)

Dust Mop Frames(9)

Sponges(8)

Mats(6)

Water/Solvent/Fuel Pumps(6)

Trigger Sprayer(6)

Waste Receptacles(6)

Cleaning/Waxing Floor Machine Parts(5)

Toilet Brushes(5)

Empty Bottles(4)

Toilet Paper Dispensers(4)

Towel Dispensers(4)

Toilet Seat Cover Dispensers(3)

Dustpans(3)

Toilet Seat Covers(3)

Safety Glasses(3)

Carts(3)

Knives(3)

Buckets/Wringers(3)

Soap Dispensers(3)

Air Freshener Dispensers(2)

Respirators(2)

Condiment Organizers(2)

Scrub Pad Holders(2)

Napkins(2)

Waste Receptacle Lids(2)

Mounting Brackets(2)

Hand Sanitizers(2)

Squeegees(2)

Toilet Plungers(2)

Dollies(1)

Lotions(1)

Tape Measures(1)

Eye Wash Stations(1)

Safety Cones(1)

Cup Sleeves(1)

Cup Trays(1)

Blood Cleanup Kits(1)

Sprayers, Hoses and Nozzles(1)

Cup Dispensers(1)

 
Brand

Boardwalk(1129)

 
Color

Gray(3)

 
Height

1"(63)

58"(14)

46"(14)

47"(11)

39"(6)

12"(5)

15"(4)

4 3/5"(3)

11 1/2"(3)

3/4"(3)

8"(3)

26"(2)

42 1/2"(2)

6 1/10"(2)

32"(2)

36"(2)

12 1/4"(2)

33"(2)

23"(2)

11"(2)

7 4/5"(1)

7 7/8"(1)

13.88"(1)

9 2/3"(1)

6 2/25"(1)

5 1/8"(1)

6 1/2"(1)

3"(1)

1 15/32"(1)

20 3/4"(1)

12 3/4"(1)

11 3/4"(1)

5.89"(1)

1 21/32"(1)

20 13/16"(1)

12 13/16"(1)

9.5"(1)

10"(1)

2"(1)

38 3/5"(1)

1 5/64"(1)

38"(1)

24"(1)

30"(1)

27.4"(1)

22"(1)

8 3/4"(1)

16 1/4"(1)

48"(1)

17 1/2"(1)

5"(1)

17"(1)

31.63"(1)

20"(1)

12.1"(1)

5.1"(1)

 
Color(s)

White(203)

Black(116)

Natural(61)

Clear(55)

Blue(46)

Red(26)

Green(19)

Translucent(18)

Gray(17)

Yellow(16)

Cream(14)

Pink(11)

Red/White(10)

Tan(9)

Silver(6)

White/Yellow/Green/Purple(5)

White/Green/Brown(5)

Natural White(5)

White/Green/Orange/Gray(4)

Salt & Pepper/Black(4)

Aqua(4)

Black/Silver(3)

Grayish Black(3)

Black/Yellow(3)

Gray/Blue(3)

Orange(3)

Smoke Black(3)

Gray/Natural(2)

Gray/White(2)

Black/White(2)

Red Handle(2)

Natural/Black(2)

Peach Amber(2)

Steel Gray(2)

Light Yellow(2)

Black Pearl(2)

Kraft(2)

White w/Red Stripe(2)

Red w/White Stripe(2)

Beige(2)

Brown(2)

Blue;White(1)

Salmon(1)

Black/Black(1)

Red;White(1)

Chrome(1)

Pink/White(1)

Natural/Champagne(1)

Lacquered Wood(1)

Yellow/White(1)

Natural Wood(1)

Clear/Red(1)

Orange/Silver(1)

Lime Green/Silver(1)

Yellow/Green(1)

Dark Blue(1)

Black/Natural(1)

Straw/Red(1)

Light Amber(1)

Beige/Black(1)

Yellow/Silver(1)

Clear/Green(1)

Blue; Green; Pink; Purple(1)

 
Depth

5"(7)

8"(4)

16 1/2"(3)

4"(3)

3 1/4"(3)

3"(3)

11"(2)

16"(2)

4 1/4"(2)

5/8"(2)

3 3/16"(1)

2 9/16"(1)

10 1/2"(1)

3 1/8"(1)

1 21/32"(1)

21"(1)

1 15/32"(1)

12.38"(1)

11 1/8"(1)

10.6"(1)

3 3/4"(1)

6 1/4"(1)

6"(1)

6 3/4"(1)

10 1/4"(1)

9 1/4"(1)

8.3"(1)

22 2/5"(1)

2"(1)

8.85"(1)

20"(1)

11.6"(1)

4 19/64"(1)

14.38"(1)

11 1/2"(1)

 
Quantity

1 each(67)

1000 per carton(26)

1 kit(9)

1 roll(8)

2500 per carton(8)

500 per carton(6)

100 per box(6)

6 per pack(5)

12 per case(5)

Dozen(3)

261 per carton(2)

225 per carton(2)

135 per carton(2)

600 per carton(2)

306 per carton(2)

6 per case(2)

180 per carton(2)

1 per box(2)

6 per carton(2)

12 per carton(2)

100 per pack(2)

10 per carton(1)

50 per pack(1)

2 per box(1)

1 dozen(1)

1 per Carton(1)

1200 per carton(1)

3000 per carton(1)

500 per box(1)

2400 per carton(1)

6000 per carton(1)

 
Size

7 3/4"(14)

5 1/4"(4)

10 1/4"(3)

7 3/4" x 1/4"(2)

One Size Fits All(2)

4" x 9"(2)

6"(2)

20"(1)

8"(1)

17"(1)

8 1/2"(1)

13"(1)

18"(1)

19"(1)

 
Packing Type

Bottle(46)

Box(40)

Aerosol(25)

Roll(15)

Spray Bottle(12)

Drum(8)

Pump Bottle(6)

Wrapped Roll(6)

Bar(5)

Refill(5)

Pail(2)

Carton(2)

Canister(1)

Kit(1)

Case(1)

 
Refillable

No(1)

 
Overall Width

22"(1)

24"(1)

16"(1)

 
Overall Depth

44"(1)

40"(1)

34"(1)

 
Closure

Tie(24)

Zipper Seal(6)

Drawstring(1)

 
Diameter

20"(14)

17"(11)

19"(11)

21"(7)

18"(6)

13"(5)

16"(5)

10"(4)

24"(4)

5"(4)

14"(4)

9"(4)

2"(3)

7.6"(3)

15"(3)

12"(3)

6"(3)

6.8"(2)

8"(2)

1 1/4"(2)

5 5/8"(2)

7"(1)

11 1/2"(1)

11 1/4"(1)

11"(1)

22"(1)

23.75"(1)

21.75"(1)

5.3"(1)

5.51"(1)

4.3"(1)

4.6"(1)

4.75"(1)

 
 
 

© 2019-2020 Hi Tech Office Products, All Rights Reserved