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

deflecto(23)

COSCO(15)

Durable(15)

NuDell(10)

Advantus(9)

Quartet(7)

Rubbermaid Commercial(7)

Universal(6)

People Pointer(4)

Identity Group(4)

C-Line(3)

DAX(2)

Newon(2)

Safco(1)

Tatco(1)

 
Height

9"(19)

12"(13)

11"(9)

3"(8)

2"(7)

10"(6)

8 1/2"(4)

4"(3)

23 1/2"(3)

9 1/2"(3)

8 3/4"(2)

11 1/4"(2)

18"(2)

7"(2)

13"(2)

6"(2)

8"(2)

25 1/2"(2)

19"(2)

44" - 73"(1)

4 3/8"(1)

14"(1)

5"(1)

12 3/8"(1)

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

64"(1)

13 in(1)

26"(1)

38"(1)

11 3/4"(1)

26 1/10"(1)

54"(1)

20.8"(1)

42"(1)

59"(1)

5 1/8"(1)

2 1/2"(1)

Adjustable 40-60"(1)

43" - 50"(1)

10 7/8"(1)

5 1/4(1)

4 1/4"(1)

8 7/16"(1)

11 3/16"(1)

52"(1)

56"(1)

12 5/8"(1)

9 7/16"(1)

3 7/8"(1)

13 5/16"(1)

17"(1)

8 1/2(1)

 
Depth

1/2"(13)

1/8"(7)

6/100"(7)

3 1/2"(5)

5/8"(3)

1/4"(3)

1 1/8"(3)

2 5/8"(3)

3"(3)

3 3/8"(2)

1 1/4"(2)

1"(2)

1/16"(1)

2 1/2"(1)

15"(1)

1 in(1)

13 1/4"(1)

13"(1)

2 3/8"(1)

3 7/16"(1)

3 11/16"(1)

3/8"(1)

0.22"(1)

3 11/32"(1)

3 13/16"(1)

4 1/2"(1)

0.31"(1)

 
Size

8 1/2" x 11"(14)

6 x 9(12)

8 1/2 x 11(8)

3 x 9(8)

10 x 14(5)

9 x 3(5)

11 x 8 1/2(3)

9 x 2(2)

15 x 19(2)

15 x 23 1/2(2)

11 x 17(2)

24 x 18(2)

8 x 12(2)

4 x 13(2)

50 x 1 x 13(2)

11" x 8 1/2"(2)

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

11 9/10 x 38(1)

28 1/2 x 42(1)

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

14 x 11(1)

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

4 x 6(1)

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

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

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

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

44 to 73(1)

4" x 6"(1)

13 x 13 1/4 x 26(1)

15 x 15 x 64(1)

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

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

1 1/2" x 2"(1)

8" x 10"(1)

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

2 x 10(1)

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

18 x 12(1)

13 x 5(1)

13 x 14(1)

13 x 21(1)

20 1/2 x 1 1/4 x 23 1/2(1)

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

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

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

15 x 46 1/2(1)

8 3/4 x 4(1)

9 3/8 x 2(1)

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

8" x 8"(1)

8" x 9"(1)

4 1/4" x 11"(1)

2" x 3 1/2"(1)

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

4 dia(1)

5 x 6(1)

12 x 8(1)

6 x 17(1)

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

11 x 3 1/2 x 4(1)

15 x 50(1)

13" x 13" x 56"(1)

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

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

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

9 x 2 1/2(1)

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

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

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

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

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

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

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

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

3" x 1" x 4"(1)

40" to 60"(1)

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

7 1/2 x 9(1)

 
Manufacturer Part Number

75318(1)

CF8511(1)

76864(1)

76863(1)

76861(1)

76859(1)

07230(1)

4174GR(1)

9S1600YL(1)

9S15 YEL(1)

9S0900YEL(1)

1867509(1)

1867508(1)

1867507(1)

1867505(1)

LCF2418(1)

CF1711(1)

76883(1)

AF32(1)

7923(1)

7922(1)

3655(1)

38020Z(1)

38020(1)

38017Z(1)

38011Z(1)

38008Z(1)

37085Z(1)

35485Z(1)

35485SFG(1)

35485DR(1)

35446(1)

76882(1)

10801(1)

89105(1)

4811(1)

6093(1)

5694(1)

5693(1)

5583(1)

5498(1)

5494(1)

5492(1)

5491(1)

5484(1)

4817(1)

4816(1)

4815(1)

4814(1)

4812(1)

4793(1)

10807(1)

4757(1)

3727(1)

3849(1)

3850(1)

4246(1)

4247(1)

4726(1)

4758(1)

4792(1)

4759(1)

4760(1)

4761(1)

4762(1)

4763(1)

4782(1)

899102(1)

89102(1)

75329(1)

090249(1)

N270985HT(1)

098211(1)

098208(1)

098207(1)

098206(1)

098205(1)

098099(1)

098072(1)

098068(1)

098063(1)

098056(1)

098055(1)

098052(1)

098010(1)

090244(1)

476801(1)

87537(1)

87507(1)

36911(1)

97080(1)

97079(1)

91100(1)

91099(1)

91098(1)

91097(1)

91096(1)

83701(1)

83700(1)

75390(1)

75334(1)

N2709N4T(1)

476803(1)

799693(1)

590801(1)

69701VP(1)

69701(1)

69301(1)

692056(1)

69201VP(1)

69201(1)

69101(1)

68301VP(1)

68301(1)

68201VP(1)

68201(1)

66701(1)

5991890(1)

5991790(1)

590101(1)

476823(1)

477323(1)

476901(1)

477101(1)

477123(1)

4772130(1)

4772131(1)

4772132(1)

4814-23(1)

588601(1)

4815-23(1)

491301(1)

4977-37(1)

558957(1)

20007(1)

587501(1)

9382(1)

 
Country of Origin

CN(89)

US(25)

PL(12)

TW(8)

DE(3)

 
Width

8 1/2"(14)

6"(13)

9"(11)

9 1/2"(10)

11"(8)

15"(7)

3"(6)

14"(5)

13"(4)

8"(4)

4"(3)

12"(2)

5"(2)

10 1/2"(2)

8 3/4"(2)

14 7/8"(1)

18"(1)

24"(1)

14 3/8"(1)

10"(1)

1 1/2"(1)

12 1/4"(1)

20 1/2"(1)

50"(1)

50 in(1)

11 9/10"(1)

10 9/10"(1)

11 1/8"(1)

28 1/2"(1)

10 7/8"(1)

10 3/8"(1)

10 1/16"(1)

8 9/16"(1)

11 1/16"(1)

8.938(1)

6 3/4"(1)

6 1/2"(1)

5 1/4(1)

3 1/2"(1)

11 1/6"(1)

4 3/8"(1)

9 3/8"(1)

7 1/2"(1)

 
Material(s)

Plastic(45)

Molded Plastic(15)

PVC(11)

Styrene Plastic/PS(7)

Metal(6)

Acrylic(5)

Styrene(5)

Aluminum(5)

Heavy-Duty Plastic(4)

Plastic/Metal(3)

PMMA(2)

Durable Plastic(2)

4mm Corrugated Plastic(2)

ABS/PETG/Acrylic/Plastic(2)

Styrene Plastic(2)

PS/Plastic(2)

Rigid Heavyweight Plastic(2)

Die-Cut Paper(2)

Alumnium/Acrylic/Cast Iron Base(2)

Steel(1)

Lightweight Aluminum(1)

Polypropylene(1)

Rugged Polycarbonate(1)

Fabric(1)

Plastic/Steel(1)

Stainless Steel/Wood/Rubber(1)

Brass/Wood/Rubber(1)

ABS Plastic(1)

Acrylic/Metal(1)

PMMA/Metal(1)

PMMA/Iron(1)

Thick Plastic(1)

 
Shape

Rectangular(86)

Radius Corner Rectangular(7)

Rectangle(5)

Square(2)

Round(1)

Oval(1)

Rectangular;Triangular(1)

 
For Use With

Letter-Size Inserts(11)

C-Line Tent Cards(2)

Tabloid-Size Inserts(2)

N/A(2)

Half-Letter Size Inserts(1)

 
Base Material

Plastic(33)

PVC(11)

Styrene(5)

Metal(4)

Acrylic(3)

Cast Iron(2)

PMMA(2)

Acrylic/Plastic(2)

Aluminum(2)

Rubber(2)

Lightweight Aluminum(1)

ABS Plastic(1)

Iron(1)

Steel(1)

 
Orientation

Landscape(24)

Portrait(20)

Vertical(19)

Landscape; Portrait(12)

Horizontal(8)

Horizontal/Vertical(8)

Horizontal; Vertical(1)

Landscape;Portrait(1)

Vertical/Horizontal(1)

Portrait; Landscape(1)

 
Placement

Desktop(17)

Wall(16)

Floor(15)

Flat Surface(10)

Wall; Flat Surface; Glass(3)

Door;Wall(3)

Desktop; Wall(3)

Door; Wall(3)

Desktop; Wall; Cubicle(2)

Cubicle; Wall(2)

Fabric Panel(2)

Countertop; Desktop; Table(2)

Countertop; Desktop(2)

Wall;Flat Surface(2)

Restroom Door(2)

Door;Hallway(1)

Magnetic Surfaces;Wall(1)

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

Countertop;Desktop;Table(1)

Glass or Other Non-porous Materials(1)

Cubicle Panel Top(1)

Door;Wall;Window(1)

Window; Wall(1)

 
Mounting

Double-Sided Adhesive Tape(15)

Predrilled Holes(6)

Adhesive Backing(5)

Adhesive Pads(5)

Adhesive Tape(4)

Free Standing(4)

Self-Adhesive(3)

Suction Cups(3)

Clips;Double Stick Foam Tape(3)

Screws; Cubicle Clips; Tabletop Support(2)

Double Stick Foam Tape(2)

Stake(2)

Screws(2)

NO(2)

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

Adjustable Clamp(1)

Suction Cups for Glass or Acrylic(1)

Torsion Action Pole(1)

Hanging Hardware(1)

Ceiling Hardware;Wall Hardware(1)

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

Door(1)

Floor(1)

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

Self-Standing L-Shaped(1)

Clips(1)

Adhesive Tabs; Screws; Panel Pin(1)

Mounting Chain(1)

Punched Hole(1)

 
Message(s)

Customizable(20)

Caution(5)

Exit(3)

Men(2)

Employees Must Wash Hands(2)

Closed; Open(2)

Women(2)

Turn Off Cell Phone(2)

No Soliciting(2)

No Smoking(2)

Employees Only(2)

Open(2)

Business Hours(2)

Fire Extinguisher(2)

Gender Neutral(2)

Visitors Must Sign In(1)

Danger Keep Out(1)

Notice Authorized Personnel Only(1)

Danger No Smoking(1)

Caution Slippery When Wet(1)

Warning Biohazard(1)

Men (with Wheelchair)(1)

Women (with Wheelchair)(1)

OPEN with Business Hours(1)

Restroom (Man/Woman)(1)

Restroom (Man/Woman/Wheelchair)(1)

Safety First; Be Safe. Be Careful. Be Aware(1)

Office(1)

Private(1)

Employees Must Wash Hands Before Returning to Work(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Closed For Cleaning(1)

Danger(1)

No Smoking/No Fumar(1)

Will Return Later(1)

Wash Hands(1)

Wheelchair(1)

Restroom(1)

Come In; Open; Will Return(1)

 
Maximum Height

11"(8)

12"(8)

8 1/2"(4)

N/A(2)

2"(2)

9 7/16"(1)

64 in(1)

13 in(1)

26 in(1)

40 in(1)

50.20 in(1)

73"(1)

59"(1)

52 in(1)

13 5/16"(1)

3 7/8"(1)

8(1)

12 5/8"(1)

56 in(1)

9(1)

8 7/16"(1)

8 3/4"(1)

11 1/4"(1)

10 7/8"(1)

60"(1)

6 3/4"(1)

50"(1)

46 1/2"(1)

4"(1)

7"(1)

 
Write-On/Wipe Off Surface

No(62)

Yes(20)

 
Graphics Color(s)

Silver(10)

White(9)

Gray/White(5)

Black(3)

White/Red/Black(2)

Red(2)

N/A(2)

Assorted(2)

Red Glow(2)

Orange/Black(1)

Yellow/Black(1)

White/Blue/Black(1)

Bold Orange; Bold White(1)

Green/White(1)

Red/Black/White(1)

Blue; Red(1)

Black; Red; White(1)

 
Loading

Side(18)

Top(16)

Front(11)

Hinged Front(6)

Bottom; Side(5)

Front Loading(1)

 
Graphics

International Symbol(12)

OPEN(2)

Man, Woman & Wheelchair(1)

Man & Woman(1)

Danger(1)

Safety First; Be Safe. Be Careful. Be Aware(1)

Snap-Out Directionals(1)

n/a(1)

NO(1)

Arrow(1)

OPEN; Digital Business Hours(1)

Clock with Movable Hands(1)

 
Lettering

Block(19)

Braille(2)

Black(1)

Green/White(1)

N/A(1)

NO(1)

 
Frame Color

Clear(42)

Black(18)

Gray(10)

Black/Silver(9)

Silver(9)

Red(7)

Gray/White(5)

White(5)

Yellow(5)

Silver/Red(3)

Assorted(2)

Silvertone(2)

Silver/Black(2)

Brown(2)

Orange(1)

Black/Red/Blue(1)

Green/White/Clear(1)

Red/White(1)

Red/Black/Clear(1)

Clear w/Green Tinted Edges(1)

Black Stand / Clear Panels(1)

Green/White(1)

Yellow/Black(1)

White/Red(1)

Blue(1)

Blue/White(1)

 
Frame Material

Plastic(40)

PVC(11)

PS(9)

Acrylic(6)

Aluminum(5)

PMMA(4)

Rigid Heavyweight Plastic(2)

Aluminum; Acrylic(2)

ABS/PETG(2)

Metal(2)

Wood(2)

Polypropylene(1)

ABS Plastic(1)

Styrene Plastic(1)

Steel(1)

 
Insert Size

8 1/2 x 11(22)

8 1/2" x 11"(12)

11 x 8 1/2(8)

11 x 17(5)

5 x 7(2)

8 1/2 x 2(2)

4 x 6(2)

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

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

8 x 10(1)

1 1/2 x 2(1)

24 x 18(1)

24 x 36(1)

8 1/2 x 11 - 40(1)

11" x 8 1/2"(1)

14 x 11(1)

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

4 1/4" x 11"(1)

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

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

4 x 11(1)

2" x 3 1/2"(1)

2 x 10(1)

 
Face Color(s)

Clear(56)

Black(15)

Gray(5)

Translucent(4)

Silver(3)

Yellow(3)

Blue(2)

White(2)

Brown/Brass(1)

Brown/Steel(1)

Green/White(1)

Clear; Frosted(1)

Crystal Clear(1)

Red/White(1)

Yellow/Black(1)

Red(1)

Black/Red/Blue(1)

 
Display

Easel(8)

LED(4)

2-Sides(2)

N/A(1)

NO(1)

 
 
 

© 2019-2020 Desert West Office Supply, All Rights Reserved