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_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 ('748')) 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 '%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

Headline Sign(33)

deflecto(31)

COSCO(26)

NuDell(11)

Durable(10)

Quartet(9)

Advantus(7)

Rubbermaid Commercial(6)

Identity Group(6)

DAX(5)

C-Line(4)

Newon(2)

LabelMaster(1)

Safco(1)

Tatco(1)

ZOLL(1)

 
Height

9"(21)

11"(12)

3"(11)

2"(6)

4"(6)

8 1/2"(6)

10"(5)

7"(4)

19"(4)

12"(3)

2 1/2"(3)

6"(3)

13"(3)

23 1/2"(2)

2 ft(2)

25 1/2"(2)

17"(2)

5 1/4(2)

8"(2)

14"(1)

26"(1)

42"(1)

20.8"(1)

54"(1)

26 1/10"(1)

4 3/8"(1)

38"(1)

64"(1)

5"(1)

8 3/4"(1)

44" - 73"(1)

4 1/2"(1)

12 3/8"(1)

3'(1)

1 7/8"(1)

18"(1)

11 1/4"(1)

52"(1)

59"(1)

10 2/5"(1)

20 1/2"(1)

6 1/4"(1)

7 1/4"(1)

5 1/4"(1)

12 3/10"(1)

46"(1)

44 1/2"(1)

17 9/10"(1)

56"(1)

4 1/4"(1)

6 7/8"(1)

40"(1)

2 3/8"(1)

1/2"(1)

3 1/2"(1)

11 3/5"(1)

5 1/8"(1)

 
Depth

1/2"(11)

6/100"(5)

5/8"(4)

3/4"(3)

1/8"(3)

1"(3)

3/100"(2)

1/1000"(2)

9"(2)

4"(2)

1 1/2"(2)

1 1/4"(2)

5"(1)

3"(1)

13 1/4"(1)

15"(1)

2 1/2"(1)

1 7/8"(1)

1/4"(1)

3 1/2"(1)

 
Quantity

1 each(132)

2 per pack(4)

25 per box(2)

6 per pack(1)

10 per pack(1)

40 per box(1)

60 per pack(1)

48 per pack(1)

1(1)

25 per pack(1)

 
Size

8 1/2 x 11(20)

6 x 9(14)

3 x 9(8)

9 x 3(8)

11 x 8 1/2(6)

10 x 14(5)

15 x 19(4)

5 x 7(4)

4 x 6(4)

5 1/4 x 5 1/4(3)

8 x 12(2)

15 x 23 1/2(2)

24 x 18(2)

9 x 2(2)

9 x 2 1/2(2)

4 dia(2)

10 1/2 x 25 1/2(2)

28 1/2 x 42(1)

14 4/5 x 20 4/5(1)

13 x 13 1/4 x 26(1)

44 to 73(1)

8 1/2 x 11; 11 x 17(1)

10 9/10 x 26 1/10(1)

14 x 11(1)

11 x 17(1)

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

11 9/10 x 38(1)

12 1/4 x 2 1/2 x 8 3/4(1)

50 x 1 x 13(1)

15 x 15 x 64(1)

3/4 x 1/8 x 6(1)

8 3/4 x 11 1/4(1)

2 x 10(1)

39 1/2 x 1 7/8 x 4 1/2(1)

14 3/8 x 12 3/8(1)

72 x 24(1)

96 x 36(1)

24 x 12(1)

13 x 5(1)

13 x 14(1)

13 x 21(1)

7 1/2 x 9(1)

8 1/2 x 2(1)

1 1/2 x 1 x 2(1)

1 1/4 x 1 1/4 x 7(1)

15 x 20 1/2(1)

8 3/4 x 4(1)

9 3/8 x 1 7/8(1)

4 3/8 x 4 3/8(1)

8 1/2" x 11"(1)

4 1/4" x 11"(1)

2" x 3 1/2"(1)

2 1/2" x 8 1/2"(1)

5 x 6(1)

12 x 8(1)

6 x 17(1)

4 x 13(1)

10 1/2 x 20 1/8(1)

8" x 30 ft(1)

2 x 4(1)

11 x 3 1/2 x 4(1)

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

6 3/4 x 5/8 x 6 7/8(1)

3 x 1 x 4(1)

3 x 1 1/2 x 4(1)

2 x 1 1/2 x 3(1)

1 x 1/2 x 1/2(1)

1 5/8 x 1/8 x 2 3/8(1)

40 to 60(1)

6 3/4 x 1/2 x 5 1/8(1)

9 1/2 x 12 3/10(1)

6 3/4 x 5/8 x 3(1)

11 x 17 9/10(1)

5 1/2 x 10 2/5(1)

17 x 11(1)

15 x 44 1/2(1)

15 x 46(1)

8 x 11(1)

 
Manufacturer Part Number

75318(1)

1867507(1)

CF1711(1)

CF8511(1)

LCF2418(1)

VSPAED96(1)

VSPEX96(1)

1867505(1)

1867508(1)

7923(1)

1867509(1)

9S0900YEL(1)

9S1600YL(1)

4174GR(1)

07230(1)

10801(1)

10807(1)

AF32(1)

7922(1)

3727(1)

35485Z(1)

69701(1)

799693(1)

899102(1)

GHISTRNWC1(1)

34085LED(1)

35446(1)

37085Z(1)

3655(1)

38008Z(1)

38011Z(1)

38017Z(1)

38018Z(1)

38020(1)

38020Z(1)

38046Z(1)

3527(1)

3768(1)

692056(1)

5492(1)

4817(1)

5400(1)

5401(1)

5402(1)

5484(1)

5491(1)

5494(1)

4815(1)

5498(1)

5583(1)

5693(1)

5694(1)

9382(1)

9385(1)

9394(1)

4816(1)

4814(1)

3769(1)

4758(1)

3794(1)

3795(1)

4246(1)

4247(1)

4725(1)

4726(1)

4757(1)

4759(1)

4813(1)

4760(1)

4761(1)

4762(1)

4763(1)

4782(1)

4811(1)

4812(1)

69301(1)

692045(1)

75329(1)

098207(1)

098072(1)

098099(1)

098182(1)

098183(1)

098205(1)

098206(1)

098208(1)

098063(1)

098209(1)

098210(1)

098211(1)

098212(1)

098221(1)

098226(1)

098227(1)

098068(1)

098056(1)

N1620H1T(1)

87537(1)

75334(1)

75390(1)

83700(1)

83701(1)

83708(1)

36911(1)

87507(1)

87597(1)

098055(1)

090244(1)

090249(1)

090252(1)

098010(1)

098032(1)

098033(1)

098052(1)

N1620G1T(1)

N270985HT(1)

69201(1)

5991790(1)

587501(1)

588601(1)

590101(1)

590301(1)

590401(1)

590801(1)

5991890(1)

20009(1)

66701(1)

68201(1)

68301(1)

690175(1)

690275(1)

69101(1)

691590(1)

20014(1)

20008(1)

N270985VT(1)

4976-37(1)

N2709N4T(1)

476801(1)

4814-23(1)

4815-23(1)

488801(1)

4890-01(1)

4892-01(1)

4977-37(1)

20007(1)

4978-37(1)

558957(1)

20001(1)

20002(1)

20004(1)

20005(1)

20006(1)

80000825(1)

 
Country of Origin

CN(97)

US(37)

TW(10)

DE(5)

PL(5)

 
Width

6"(15)

8 1/2"(14)

9"(12)

3"(10)

15"(10)

11"(9)

14"(5)

4"(3)

13"(3)

6 3/4"(3)

5"(3)

1"(2)

8 3/4"(2)

9 1/2"(2)

8"(2)

5 1/4(2)

5 1/4"(2)

3 1/2"(2)

24"(2)

10 1/2"(2)

14 7/8"(1)

14 3/8"(1)

39 1/2"(1)

6 ft(1)

10"(1)

12 1/4"(1)

8 ft(1)

50"(1)

11 9/10"(1)

10 9/10"(1)

5 1/2"(1)

28 1/2"(1)

3/4"(1)

1 1/4"(1)

2"(1)

1 1/2"(1)

1 5/8"(1)

21 7/8"(1)

4 1/4"(1)

4 ft(1)

30 ft(1)

12"(1)

11 1/6"(1)

9 1/5"(1)

4 3/8"(1)

9 3/8"(1)

7 1/2"(1)

 
Material(s)

Plastic(59)

Molded Plastic(20)

Metal(11)

Acrylic(8)

Aluminum(5)

Styrene(5)

Die-Cut Paper(5)

Plastic/Metal(5)

Heavy-Duty Plastic(4)

Rigid Heavyweight Plastic(3)

PVC(3)

ABS Plastic(3)

Steel(2)

Acrylic/Cast Iron Base(2)

Flexible Magnetic(2)

Thick Plastic(2)

Fabric(1)

10 oz Reinforced Nylon(1)

10 oz. Reinforced Nylon(1)

Rugged Polycarbonate(1)

Aluminum/Steel(1)

Stainless Steel/Wood/Rubber(1)

Brass/Wood/Rubber(1)

Plastic/Metal/Wiring(1)

Laminated Cardstock(1)

Plastic; Metal; Magnet(1)

Acrylic/Metal(1)

Vinyl(1)

Polypropylene(1)

Lightweight Aluminum(1)

Poly Resin(1)

 
Shape

Rectangular(54)

Radius Corner Rectangular(12)

Rectangle(7)

Triangular(2)

Banner(2)

Square(1)

Round(1)

Star; Callout; Flower(1)

Round Burst(1)

Square Burst(1)

Oval(1)

Pennant(1)

Rectangular;Triangular(1)

 
For Use With

C-Line Tent Cards(3)

N/A(2)

ZOLL AED Plus(1)

 
Base Material

Plastic(35)

Styrene(5)

Metal(4)

PVC(3)

Cast Iron(2)

ABS Plastic(2)

Aluminum(2)

Steel(2)

Rubber(2)

Lightweight Aluminum(1)

Plastic; Metal; Magnet(1)

Plastic/Metal(1)

Acrylic(1)

 
Orientation

Landscape(23)

Portrait(21)

Vertical(13)

Horizontal(9)

Landscape;Portrait(8)

Vertical/Horizontal(2)

Landscape; Portrait(2)

3-Way(2)

All-Purpose(1)

Portrait; Landscape(1)

 
Placement

Desktop(25)

Floor(16)

Wall(10)

Countertop; Desktop(5)

Desktop; Wall(4)

Flat Surface(4)

Wall; Flat Surface; Glass(4)

Door;Wall(3)

Cubicle(3)

Door; Fabric Panel; Flat Surface; Wall(3)

Fabric Panel(2)

Desktop;Wall(2)

Cubicle Panel Top(1)

Door;Wall;Window(1)

Counter; Table; Reception Desk(1)

Countertop;Desktop;Table(1)

Magnetic Surfaces;Wall(1)

 
Mounting

Double-Sided Adhesive Tape(20)

Adhesive Pads(8)

Predrilled Holes(5)

Stake(4)

Self-Adhesive(4)

Adhesive Tabs; Screws(3)

Clips;Double Stick Foam Tape(3)

Free Standing(3)

Clips; Magnets; Velcro(3)

Desktop(2)

Suction Cups(2)

Double-Sided Adhesive Tape; Predrilled Holes(2)

NO(2)

Adjustable Clamp(1)

Torsion Action Pole(1)

Ceiling Hardware;Wall Hardware(1)

Suction Cups for Glass or Acrylic(1)

Punched Hole(1)

Floor(1)

Adhesive Tab(1)

Velcro;Velcro Backed Magnet(1)

Magnetic; Clips(1)

Double Clips(1)

Clips(1)

Permanent Adhesive Backing(1)

Grommets(1)

Mounting Chain(1)

Adhesive Tape(1)

Hanging Chain(1)

 
Message(s)

Customizable(10)

Caution(5)

Exit(3)

Business Hours(3)

No Smoking(3)

Closed; Open(2)

Turn Off Cell Phone(2)

Private(2)

Office(2)

Visitors Must Sign In(2)

Employees Only(2)

Employees Must Wash Hands(2)

Open(2)

No Soliciting(2)

Danger No Smoking(1)

Danger Keep Out(1)

Stairs(1)

In Case of Fire Use Stairs(1)

Will Return Later(1)

Notice Authorized Personnel Only(1)

Caution Slippery When Wet(1)

Warning Biohazard(1)

Women(1)

Come In; Open; Will Return(1)

Closed; Open; Will Return; Thank You(1)

Men(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Men (with Wheelchair)(1)

Women (with Wheelchair)(1)

Restroom (Man/Woman)(1)

Restroom (Man/Woman/Wheelchair)(1)

Employees Must Wash Hands Before Returning to Work(1)

Accessible (Wheelchair)(1)

EXIT(1)

A.E.D.(1)

Customizable; Business Hours(1)

No Smoking/No Fumar(1)

Fire Extinguisher(1)

AED(1)

 
Maximum Height

11"(4)

4"(3)

N/A(2)

13"(1)

64 in(1)

26 in(1)

40 in(1)

50.20 in(1)

73"(1)

59"(1)

52 in(1)

6 3/4 in(1)

56 in(1)

6 1/4"(1)

2"(1)

60 in(1)

49 3/8 in(1)

46 in(1)

8 1/2"(1)

7 1/4"(1)

45"(1)

 
Write-On/Wipe Off Surface

No(61)

Yes(2)

 
Graphics Color(s)

White(12)

Silver(10)

Assorted(5)

Red(4)

Black(3)

N/A(2)

White/Red/Black(2)

Blue; Red(1)

16-Color(1)

Bold Orange; Bold White(1)

White/Blue/Black(1)

Yellow/Black(1)

Orange/Black(1)

Black; Red; White(1)

Black; White(1)

 
Loading

Top(11)

Side(11)

Hinged Front(10)

Front(3)

Bottom; Sides(3)

Bottom(3)

Bottom;Side(2)

Top;Side(1)

Top/Sides(1)

 
Graphics

International Symbol(17)

OPEN(2)

Red AED Image(1)

Red EXIT Image(1)

Snap-Out Directionals(1)

n/a(1)

NO(1)

Clock with Movable Hands(1)

 
Lettering

Block(13)

Red(2)

N/A(1)

NO(1)

 
Frame Color

Clear(52)

Black(19)

Gray(15)

Silver(13)

Black/Silver(9)

White(9)

Yellow(5)

Red(4)

Silver/Red(3)

Assorted(3)

Green/Orange/Pink/Yellow(2)

Blue(2)

Silvertone(2)

Brown(2)

Red/Yellow/Blue/Purple/Green(1)

White/Red(1)

Black/Red(1)

White/Blue(1)

Graphite(1)

Orange(1)

Blue/White(1)

Blue/Red/White(1)

Red/White(1)

 
Frame Material

Plastic(42)

Acrylic(8)

Aluminum(4)

Rigid Heavyweight Plastic(3)

PVC(3)

ABS Plastic(2)

Steel(2)

Wood(2)

Polypropylene(1)

Metal(1)

 
Insert Size

8 1/2 x 11(23)

5 x 7(11)

11 x 8 1/2(6)

11 x 17(5)

4 x 6(4)

8 1/2" x 11"(1)

3 x 4(1)

8 3/4 x 11 1/4(1)

24 x 18(1)

24 x 36(1)

8 1/2 x 11 - 40(1)

8 1/2 x 11;11 x 17(1)

14 x 11(1)

Letter(1)

8 1/2 x 2(1)

5 7/8 x 4 1/8(1)

2 x 3(1)

1 1/2 x 2(1)

5 7/8 x 5 3/4(1)

4 1/4" x 11"(1)

5 7/8 x 2(1)

5 1/2 x 8 1/2(1)

17 x 11(1)

4 x 11(1)

2 1/2" x 8 1/2"(1)

2" x 3 1/2"(1)

2 x 10(1)

 
Face Color(s)

Clear(56)

Black(12)

Translucent(5)

White(3)

Yellow(2)

Assorted(1)

Crystal Clear(1)

Brown/Brass(1)

Brown/Steel(1)

 
Display

Easel(8)

LED(4)

2-Sides(3)

3-Sides(2)

N/A(1)

NO(1)

24-Character Scrolling LED;7 x 120 Pixels(1)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved