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(27)

deflecto(21)

Durable(15)

COSCO(11)

Advantus(9)

NuDell(8)

Rubbermaid Commercial(7)

Quartet(7)

Universal(6)

People Pointer(4)

C-Line(3)

DAX(2)

Identity Group(2)

Newon(1)

TOLCO(1)

Safco(1)

Tatco(1)

 
Height

9"(18)

12"(12)

3"(8)

11"(8)

2"(7)

10"(5)

9 1/2"(3)

8 1/2"(3)

23 1/2"(2)

7"(2)

11 1/4"(2)

13"(2)

4"(2)

25 1/2"(2)

8 3/4"(2)

6"(2)

19"(2)

20.8"(1)

59"(1)

44" - 73"(1)

54"(1)

42"(1)

26 1/10"(1)

64"(1)

12 3/8"(1)

5"(1)

14"(1)

20"(1)

52"(1)

26"(1)

13 in(1)

38"(1)

11 3/16"(1)

5 1/4(1)

18"(1)

40 1/2" - 46 1/2"(1)

4 1/4"(1)

11 3/4"(1)

2 1/2"(1)

4 3/8"(1)

8"(1)

43" - 50"(1)

5 1/8"(1)

9 7/16"(1)

3 7/8"(1)

13 5/16"(1)

12 5/8"(1)

56"(1)

Adjustable 40-60"(1)

10 7/8"(1)

8 1/2(1)

 
Depth

1/2"(13)

3 1/2"(5)

1/8"(5)

6/100"(4)

3"(3)

1 1/8"(3)

1/4"(3)

5/8"(3)

2 5/8"(2)

3 3/8"(2)

13 1/4"(1)

1 in(1)

1"(1)

1 1/4"(1)

1/16"(1)

2 1/2"(1)

15"(1)

13"(1)

3 11/32"(1)

3 13/16"(1)

4 1/2"(1)

0.22"(1)

3/8"(1)

3 7/16"(1)

3 11/16"(1)

0.31"(1)

2 3/8"(1)

 
Size

8 1/2" x 11"(14)

6 x 9(12)

3 x 9(8)

8 1/2 x 11(7)

9 x 3(4)

10 x 14(4)

50 x 1 x 13(2)

8 x 12(2)

11 x 8 1/2(2)

11 x 17(2)

15 x 19(2)

15 x 23 1/2(2)

4 x 13(2)

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

9 x 2(2)

11" x 8 1/2"(2)

10 7/8" x 1/16" x 13 5/16"(1)

24 x 18(1)

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

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

4 x 6(1)

28 1/2 x 42(1)

11 9/10 x 38(1)

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

14 x 11(1)

44 to 73(1)

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

4" x 6"(1)

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

2 x 10(1)

13 x 5(1)

7 1/2 x 9(1)

13 x 21(1)

13 x 14(1)

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

8" x 10"(1)

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

15 x 15 x 64(1)

17 x 20(1)

10 3/8" x 3 7/16" x 9 7/16"(1)

1 1/2" x 2"(1)

13 x 13 1/4 x 26(1)

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

4 dia(1)

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

5 x 6(1)

11 x 3 1/2 x 4(1)

15 x 50(1)

15 x 46 1/2(1)

2" x 3 1/2"(1)

4 1/4" x 11"(1)

8.5 x 3.75(1)

8.5 x 2(1)

9 3/8 x 2(1)

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

8" x 9"(1)

8" x 8"(1)

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

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

11" x 3/8" x 9 1/2"(1)

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

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

13" x 13" x 56"(1)

8 9/16" x 2 5/8" x 11"(1)

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

11 1/16" x 3 11/32" x 8 3/4"(1)

8 1/2" x 3 13/16" x 11 1/4"(1)

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

40" to 60"(1)

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

8 15/16" x 3 3/8" x 10 7/8"(1)

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

10 1/16" x 3 3/8" x 12 5/8"(1)

 
Manufacturer Part Number

9S0900YEL(1)

9S15 YEL(1)

1867509(1)

1867508(1)

1867505(1)

1867507(1)

9S1600YL(1)

4174GR(1)

76863(1)

76864(1)

76861(1)

76859(1)

07230(1)

522247(1)

LCF2418(1)

CF8511(1)

38008Z(1)

38011Z(1)

37085Z(1)

35485Z(1)

899102(1)

35446(1)

38017Z(1)

38020(1)

AF32(1)

CF1711(1)

7923(1)

7922(1)

38020Z(1)

3655(1)

76882(1)

76883(1)

4816(1)

4817(1)

4815(1)

4814(1)

4811(1)

4812(1)

5484(1)

5492(1)

5694(1)

9382(1)

5693(1)

5583(1)

5494(1)

5498(1)

4793(1)

4792(1)

4247(1)

4726(1)

4246(1)

3727(1)

10801(1)

10807(1)

4757(1)

4758(1)

4763(1)

4782(1)

4762(1)

4761(1)

4759(1)

4760(1)

89105(1)

89102(1)

098068(1)

098072(1)

098063(1)

098055(1)

090249(1)

098010(1)

098205(1)

098206(1)

476801(1)

476803(1)

N2709N4T(1)

N270985HT(1)

098207(1)

098208(1)

090244(1)

87537(1)

83701(1)

91096(1)

83700(1)

75390(1)

75329(1)

75334(1)

91097(1)

91098(1)

36911(1)

87507(1)

97080(1)

97079(1)

91099(1)

91100(1)

476823(1)

476901(1)

68301(1)

68301VP(1)

68201VP(1)

68201(1)

5991790(1)

5991890(1)

69101(1)

69201(1)

69701VP(1)

799693(1)

69701(1)

69301(1)

69201VP(1)

692056(1)

590801(1)

590101(1)

4772132(1)

477323(1)

4772131(1)

4772130(1)

477101(1)

477123(1)

4814-23(1)

4815-23(1)

587501(1)

588601(1)

558957(1)

4977-37(1)

491301(1)

75318(1)

 
Country of Origin

CN(78)

US(24)

PL(12)

TW(8)

DE(3)

MX(1)

 
Width

8 1/2"(13)

6"(12)

9"(11)

9 1/2"(10)

15"(7)

11"(7)

3"(4)

8"(4)

13"(4)

14"(4)

4"(3)

8 3/4"(2)

5"(2)

10 1/2"(2)

50 in(1)

28 1/2"(1)

11 9/10"(1)

10 9/10"(1)

14 7/8"(1)

50"(1)

7 1/2"(1)

1 1/2"(1)

17"(1)

12 1/4"(1)

10"(1)

14 3/8"(1)

8.938(1)

3 1/2"(1)

5 1/4(1)

11 1/6"(1)

4 3/8"(1)

9 3/8"(1)

12"(1)

6 1/2"(1)

10 1/16"(1)

10 3/8"(1)

8 9/16"(1)

11 1/16"(1)

6 3/4"(1)

10 7/8"(1)

 
Material(s)

Plastic(42)

Molded Plastic(15)

PVC(11)

Styrene Plastic/PS(6)

Metal(5)

Aluminum(5)

Styrene(4)

Heavy-Duty Plastic(4)

Acrylic(3)

PMMA(2)

ABS/PETG/Acrylic/Plastic(2)

Durable Plastic(2)

PS/Plastic(2)

Styrene Plastic(2)

Rigid Heavyweight Plastic(2)

Die-Cut Paper(2)

Plastic/Metal(2)

Alumnium/Acrylic/Cast Iron Base(2)

Spunbonded Polypropylene(1)

Thick Plastic(1)

Lightweight Aluminum(1)

Polypropylene(1)

Rugged Polycarbonate(1)

Fabric(1)

PMMA/Iron(1)

ABS Plastic(1)

PMMA/Metal(1)

Brass/Wood/Rubber(1)

Acrylic/Metal(1)

Stainless Steel/Wood/Rubber(1)

Steel(1)

 
Shape

Rectangular(78)

Radius Corner Rectangular(7)

Rectangle(5)

Square(2)

Oblong(1)

Round(1)

Rectangular;Triangular(1)

 
For Use With

Letter-Size Inserts(11)

N/A(2)

Tabloid-Size Inserts(2)

C-Line Tent Cards(2)

Urinals; Toilets; Drinking Fountains(1)

Half-Letter Size Inserts(1)

 
Base Material

Plastic(30)

PVC(11)

Metal(4)

Styrene(4)

Aluminum(2)

Acrylic/Plastic(2)

Rubber(2)

PMMA(2)

Cast Iron(2)

Steel(1)

ABS Plastic(1)

Lightweight Aluminum(1)

Acrylic(1)

Iron(1)

 
Orientation

Portrait(19)

Vertical(19)

Landscape(17)

Landscape; Portrait(11)

Horizontal(8)

Horizontal/Vertical(8)

Portrait; Landscape(1)

Vertical/Horizontal(1)

Horizontal; Vertical(1)

Landscape;Portrait(1)

 
Placement

Desktop(16)

Wall(16)

Floor(15)

Flat Surface(8)

Wall; Flat Surface; Glass(3)

Door;Wall(3)

Door; Wall(3)

Desktop; Wall; Cubicle(2)

Desktop; Wall(2)

Wall;Flat Surface(2)

Cubicle; Wall(2)

Metal Surface(2)

Countertop; Desktop(2)

Restroom Door(2)

Fabric Panel(2)

Door;Hallway(1)

Cover Up(1)

Countertop;Desktop;Table(1)

Cubicle Panel Top(1)

Glass or Other Non-porous Materials(1)

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

Magnetic Surfaces;Wall(1)

 
Mounting

Double-Sided Adhesive Tape(15)

Predrilled Holes(6)

Adhesive Backing(5)

Adhesive Pads(4)

Free Standing(4)

Adhesive Tape(4)

Suction Cups(3)

Self-Adhesive(3)

Clips;Double Stick Foam Tape(3)

Screws; Cubicle Clips; Tabletop Support(2)

Double Stick Foam Tape(2)

Magnetic(2)

Screws(2)

NO(2)

Clips; Magnets; Hook and Loop; Adhesive Pads(2)

Ceiling Hardware;Wall Hardware(1)

Punched Hole(1)

Torsion Action Pole(1)

Suction Cups for Glass or Acrylic(1)

Predrilled Holes (8 1/4" from center of hole to next)(1)

Adhesive Tabs; Screws; Panel Pin(1)

Stake(1)

Adjustable Clamp(1)

Magnetic; Self-stick Hook & Loop Tape(1)

Floor(1)

Door(1)

 
Message(s)

Customizable(18)

Caution(5)

No Smoking(2)

Employees Must Wash Hands(2)

No Soliciting(2)

Closed; Open(2)

Men(2)

Business Hours(2)

Exit(2)

Employees Only(2)

Gender Neutral(2)

Women(2)

Fire Extinguisher(2)

Men (with Wheelchair)(1)

Women (with Wheelchair)(1)

Restroom (Man/Woman)(1)

Restroom (Man/Woman/Wheelchair)(1)

Come In; Open; Will Return(1)

Danger No Smoking(1)

Visitors Must Sign In(1)

Caution Slippery When Wet(1)

Warning Biohazard(1)

Notice Authorized Personnel Only(1)

Open(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Will Return Later(1)

Wash Hands(1)

Wheelchair(1)

Restroom(1)

No Smoking/No Fumar(1)

Closed For Cleaning(1)

Private(1)

Turn Off Cell Phone(1)

Employees Must Wash Hands Before Returning to Work(1)

Out of Service; Fuera de Servicio(1)

Office(1)

 
Maximum Height

12"(8)

11"(8)

8 1/2"(4)

2"(2)

N/A(2)

73"(1)

59"(1)

13 5/16"(1)

3 7/8"(1)

50.20 in(1)

52 in(1)

40 in(1)

20"(1)

64 in(1)

13 in(1)

26 in(1)

9 7/16"(1)

7"(1)

50"(1)

6 3/4"(1)

46 1/2"(1)

4"(1)

9(1)

60"(1)

10 7/8"(1)

56 in(1)

8(1)

8 3/4"(1)

11 1/4"(1)

12 5/8"(1)

 
Write-On/Wipe Off Surface

No(57)

Yes(19)

 
Graphics Color(s)

Silver(10)

White(9)

Gray/White(5)

Black(4)

Red Glow(2)

N/A(2)

Orange/Black(1)

Black; Red; White(1)

Yellow/Black(1)

White/Red/Black(1)

Red(1)

Bold Orange; Bold White(1)

White/Blue/Black(1)

 
Loading

Side(15)

Top(15)

Front(11)

Hinged Front(6)

Bottom; Side(5)

Bottom(1)

Front Loading(1)

 
Graphics

International Symbol(12)

Arrow(1)

OPEN(1)

NO(1)

Clock with Movable Hands(1)

n/a(1)

Man & Woman(1)

Snap-Out Directionals(1)

Man, Woman & Wheelchair(1)

 
Lettering

Block(20)

Braille(2)

NO(1)

N/A(1)

 
Frame Color

Clear(40)

Black(17)

Gray(10)

Black/Silver(9)

Silver(9)

Red(6)

Gray/White(5)

Yellow(5)

White(4)

Brown(2)

Silvertone(2)

Assorted(2)

Silver/Black(2)

Silver/Red(2)

Orange(2)

Blue/White(1)

Yellow/Black(1)

Blue(1)

Green/White(1)

Red/White(1)

Black Stand / Clear Panels(1)

Clear w/Green Tinted Edges(1)

 
Frame Material

Plastic(38)

PVC(11)

PS(8)

Aluminum(5)

Acrylic(4)

PMMA(4)

Wood(2)

Rigid Heavyweight Plastic(2)

ABS/PETG(2)

Aluminum; Acrylic(2)

Steel(1)

Metal(1)

Polypropylene(1)

ABS Plastic(1)

Styrene Plastic(1)

 
Insert Size

8 1/2 x 11(21)

8 1/2" x 11"(12)

11 x 8 1/2(6)

11 x 17(5)

9" x 2"(2)

4 x 6(2)

8 1/2 x 2(2)

24 x 36(1)

8 1/2 x 11 - 40(1)

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

24 x 18(1)

1 1/2 x 2(1)

2 x 10(1)

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

8 x 10(1)

14 x 11(1)

8.5" x 2"(1)

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

4 1/4" x 11"(1)

2" x 3 1/2"(1)

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

8.5" x 3.75"(1)

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

5 x 7(1)

11" x 8 1/2"(1)

4 x 11(1)

 
Face Color(s)

Clear(53)

Black(14)

Gray(5)

Translucent(4)

Yellow(3)

Silver(3)

Blue(2)

White(2)

Brown/Steel(1)

Orange(1)

Brown/Brass(1)

Green/White(1)

Red(1)

Yellow/Black(1)

Red/White(1)

Crystal Clear(1)

Clear; Frosted(1)

 
Display

Easel(8)

2-Sides(2)

LED(2)

N/A(1)

NO(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved