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

Currently Filtered by

Category

Signs And Sign Holders

Refine Search
  GO
 
Brand

Lorell(28)

Deflecto(19)

Xstamper(8)

Golite nu-dell(7)

DURABLE(6)

Tatco(5)

Safco(3)

MasterVision(1)

C-Line(1)

Impact(1)

Miller's Creek(1)

Post-it®(1)

Scotch(1)

 
Color

Clear(1)

 
Recycled

No(70)

 
Packaged Quantity

1 Each(71)

2 / Pack(5)

50 / Pack(5)

3 / Pack(1)

 
Assembly Required

No(5)

 
Limited Warranty

Lifetime(3)

 
Weight (Approximate)

0.16 oz(2)

10.72 oz(2)

11 lb(2)

14 lb(1)

12.64 oz(1)

8.74 lb(1)

8.05 lb(1)

11.68 oz(1)

12 oz(1)

10.40 oz(1)

1 lb(1)

3.20 oz(1)

2.16 lb(1)

10 lb(1)

 
Media Size Supported

8.50" x 11"(5)

13" x 8.50"(1)

 
Package Type

Retail(1)

 
Total Number of Compartments

3(1)

 
Language

English(2)

Spanish(1)

 
Mount Type

Surface-mountable(23)

Wall Mountable(15)

Hanging(5)

Door-mountable(2)

Glass-mountable(1)

Window-mountable(1)

Cubicle-mountable(1)

 
Print/Message

Women(5)

Men(5)

Toilette Men(2)

women's restroom/wheelchair accessible(1)

men's restroom/wheelchair accessible(1)

TOILETTE (ladies)(1)

Restroom (Man/Woman/Wheelchair)(1)

Fire Extinguisher(1)

 
Frame Width

9"(1)

 
Frame Height

14"(1)

 
Maximum Adjustable Stand Height

60"(1)

 
Print/Message Color

Red(1)

 
Holding Height

2"(4)

11"(3)

17"(1)

 
Holding Width

10"(4)

8.50"(3)

25"(1)

 
Manufacturer Part Number

SIG01010101(1)

49206(1)

35446(1)

WL854C(1)

EH5592PK(1)

151833(1)

49209(1)

49208(1)

49207(1)

49205(1)

37085Z(1)

02680(1)

02677(1)

02676(1)

02675(1)

02674(1)

02673(1)

02672(1)

35485Z(1)

38017Z(1)

02668(1)

68103(1)

W45(1)

W41(1)

W40(1)

G83(1)

G82(1)

G81(1)

G80(1)

68102(1)

38018Z(1)

68101(1)

21700(1)

21400(1)

4173BL(1)

4118BL(1)

4117BL(1)

38046Z(1)

38020Z(1)

02671(1)

02667(1)

41902(1)

590801(1)

692056(1)

69201(1)

691590(1)

68301(1)

68201(1)

5991890(1)

5991790(1)

590601(1)

693704(1)

590301(1)

590101(1)

558957(1)

497737(1)

497637(1)

491323(1)

481523(1)

476801(1)

69301(1)

69701(1)

02666(1)

02656(1)

02665(1)

02664(1)

02663(1)

02662(1)

02659(1)

02658(1)

02657(1)

02653(1)

69775(1)

02652(1)

02650(1)

02648(1)

26401(1)

899102(1)

879701(1)

879301(1)

799693(1)

W46(1)

 
Country of Origin

China(40)

United States(35)

Poland(3)

Germany(3)

Portugal(1)

 
Height

8.5"(17)

11"(10)

8"(5)

2"(4)

3"(4)

6"(3)

5.5"(2)

65"(2)

6.8"(2)

64.3"(1)

7"(1)

17"(1)

16.8"(1)

10"(1)

50"(1)

4"(1)

8.7"(1)

12.6"(1)

13.31"(1)

56"(1)

12"(1)

5"(1)

60"(1)

5.1"(1)

14"(1)

 
Width

8.5"(11)

6.8"(8)

11"(8)

8"(7)

6.4"(6)

10"(4)

4"(4)

2.8"(3)

18"(2)

4.5"(2)

3.5"(2)

13"(1)

11.24"(1)

11.1"(1)

9.3"(1)

8.6"(1)

12"(1)

7"(1)

17"(1)

5"(1)

22.5"(1)

63"(1)

 
Depth

25"(2)

0.6"(2)

2.5"(2)

18"(2)

11.50"(1)

11"(1)

1.9"(1)

12.9"(1)

6.94"(1)

2.6"(1)

3.4"(1)

3.3"(1)

8"(1)

12"(1)

1"(1)

 
Sheet Size

9" Width x 11" Length(1)

 
Shape

Rectangular(50)

Square(5)

Arrow(2)

Rectangle(2)

Curved(1)

Octagonal(1)

 
Frame Color

Clear(4)

Black(3)

Gold(2)

Silver(2)

 
Length

14"(1)

8.5"(1)

 
Placement

Desktop(7)

Countertop(7)

Floor Standing(1)

Counter(1)

 
Orientation

Vertical(6)

Horizontal(3)

Landscape(1)

Portrait(1)

 
Base Color

Black(3)

 
Number of Tiers

3(1)

 
Insert Width

8.50"(1)

5.50"(1)

 
Insert Height

11"(1)

8.50"(1)

 
 
 

© 2026-2027 Office Hub, All Rights Reserved

Powered by Dealer Commander