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_36` 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(25)

deflecto(14)

NuDell(11)

Advantus(11)

Quartet(9)

Durable(9)

DAX(5)

C-Line(3)

Newon(2)

Identity Group(2)

Tatco(1)

Artistic(1)

TOLCO(1)

 
Height

9"(18)

11"(8)

3"(5)

2"(5)

10"(5)

4"(4)

8 1/2"(3)

9 1/2"(2)

2 1/2"(2)

42"(1)

20.8"(1)

44" - 73"(1)

7"(1)

13 5/16"(1)

52"(1)

59"(1)

20"(1)

12 3/8"(1)

14"(1)

8"(1)

4 1/2"(1)

11 1/4"(1)

8 3/4"(1)

12 5/8"(1)

54"(1)

7 5/16"(1)

7 1/4"(1)

12 3/10"(1)

18"(1)

6 1/4"(1)

4 1/4"(1)

4 3/8"(1)

11 3/5"(1)

46"(1)

44 1/2"(1)

6 5/16"(1)

12"(1)

12 1/8"(1)

10 7/8"(1)

40"(1)

5 1/8"(1)

6 7/8"(1)

56"(1)

 
Depth

1/2"(11)

1/8"(6)

6/100"(5)

5/8"(4)

1/4"(3)

3 1/2"(2)

9"(2)

2 1/16"(2)

3 3/8"(2)

2 1/2"(2)

3"(1)

1 1/4"(1)

1/16"(1)

1 7/8"(1)

4 1/2"(1)

4"(1)

5"(1)

3/8"(1)

13"(1)

2 5/8"(1)

 
Size

6 x 9(19)

8 1/2 x 11(9)

10 x 14(5)

11 x 8 1/2(4)

3 x 9(4)

4 x 6(2)

11 x 17(2)

9 x 2(2)

14 x 11(1)

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

28 1/2 x 42(1)

44 to 73(1)

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

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

13" x 13" x 56"(1)

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

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

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

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

13 x 14(1)

13 x 21(1)

7 1/2 x 9(1)

8 x 11(1)

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

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

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

17 x 20(1)

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

2 x 10(1)

24 x 18(1)

4 7/16" x 2 1/16" x 6 5/16"(1)

5 x 7(1)

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

11 x 3 1/2 x 4(1)

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

15 x 46(1)

4 1/4" x 11"(1)

8 1/2" x 11"(1)

9 x 2 1/2(1)

8 3/4 x 4(1)

9 3/8 x 2(1)

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

15 x 44 1/2(1)

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

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

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

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

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

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

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

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

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

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

40 to 60(1)

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

 
Manufacturer Part Number

07230(1)

VSPEX96(1)

VSPAED96(1)

LCF2418(1)

522247(1)

10801(1)

4247(1)

3727(1)

3527(1)

10807(1)

CF8511(1)

CF1711(1)

38011Z(1)

38008Z(1)

37085Z(1)

37085SFG(1)

38017Z(1)

38020Z(1)

AF32(1)

7923(1)

7922(1)

3655(1)

4725(1)

4726(1)

5491(1)

5484(1)

5402(1)

5401(1)

5492(1)

5494(1)

9385(1)

9382(1)

5583(1)

5498(1)

5400(1)

4817(1)

4782(1)

4760(1)

4758(1)

4757(1)

4811(1)

4812(1)

4816(1)

4815(1)

4814(1)

4813(1)

37085DR(1)

35485Z(1)

N1620H1T(1)

N1620G1T(1)

87597(1)

87507(1)

N270985HT(1)

N270985VT(1)

4814-23(1)

476901(1)

476801(1)

N2709N4T(1)

36911(1)

91100(1)

75390(1)

75334(1)

75329(1)

75318(1)

83700(1)

83701(1)

91099(1)

91098(1)

91097(1)

91096(1)

4815-23(1)

491301(1)

692056(1)

69201(1)

691590(1)

68301(1)

69701(1)

799693(1)

35485SFG(1)

35485DR(1)

35446(1)

899102(1)

68201(1)

590801(1)

558957(1)

4978-37(1)

4977-37(1)

4976-37(1)

587501(1)

588601(1)

590401(1)

590301(1)

590101(1)

34100(1)

 
Country of Origin

CN(53)

US(24)

TW(7)

DE(5)

PL(4)

MX(1)

 
Width

6"(19)

8 1/2"(10)

9"(7)

11"(6)

14"(5)

6 3/4"(3)

15"(2)

13"(2)

8 3/4"(2)

28 1/2"(1)

4"(1)

10 1/16"(1)

10 7/8"(1)

14 7/8"(1)

14 3/8"(1)

7 1/2"(1)

39 1/2"(1)

10"(1)

8 9/16"(1)

17"(1)

12 1/4"(1)

8.938(1)

11 1/6"(1)

4 1/4"(1)

9 1/5"(1)

4 3/8"(1)

9 3/8"(1)

5 1/4"(1)

9 1/2"(1)

4 7/16"(1)

5.438(1)

6 1/2"(1)

12"(1)

8 5/8"(1)

 
Material(s)

Plastic(31)

Molded Plastic(16)

Styrene Plastic/PS(7)

Aluminum(5)

Styrene(5)

Acrylic(4)

ABS Plastic(3)

PVC(3)

Thick Plastic(2)

Styrene Plastic(2)

Rigid Heavyweight Plastic(2)

Acrylic/Cast Iron Base(2)

Heavy-Duty Plastic(1)

Spunbonded Polypropylene(1)

Acrylic/Metal(1)

Polypropylene(1)

Lightweight Aluminum(1)

Rugged Polycarbonate(1)

Metal(1)

PMMA/Iron(1)

PMMA/Metal(1)

Plastic/Metal(1)

PS/Plastic(1)

PMMA/ABS(1)

 
Shape

Rectangular(45)

Radius Corner Rectangular(12)

Rectangle(5)

Triangular(2)

Oblong(1)

 
For Use With

C-Line Tent Cards(2)

N/A(2)

Urinals; Toilets; Drinking Fountains(1)

 
Base Material

Plastic(28)

Styrene(5)

Metal(4)

PVC(3)

Aluminum(2)

ABS Plastic(2)

Cast Iron(2)

Lightweight Aluminum(1)

Iron(1)

ABS(1)

Acrylic(1)

 
Orientation

Portrait(19)

Landscape(15)

Landscape; Portrait(9)

Horizontal(7)

Vertical(7)

3-Way(2)

Landscape;Portrait(2)

Vertical/Horizontal(2)

Portrait; Landscape(1)

 
Placement

Wall(16)

Desktop(9)

Floor(9)

Countertop; Desktop(5)

Door;Wall(3)

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

Wall; Flat Surface; Glass(3)

Flat Surface(3)

Fabric Panel(2)

Countertop; Desktop; Table(2)

Desktop; Wall(2)

Cubicle; Wall(2)

Cubicle Panel Top(1)

Cover Up(1)

Magnetic Surfaces;Wall(1)

Tabletop; Countertop; Desktop(1)

Countertop;Desktop;Table(1)

Glass or Other Non-porous Materials(1)

 
Mounting

Double-Sided Adhesive Tape(16)

Adhesive Backing(5)

Predrilled Holes(4)

Clips;Double Stick Foam Tape(3)

Adhesive Tabs; Screws(3)

Self-Adhesive(3)

Double-Sided Adhesive Tape; Predrilled Holes(2)

NO(2)

Suction Cups(2)

Free Standing(2)

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

Adjustable Clamp(1)

Hanging Chain(1)

Punched Hole(1)

Suction Cups for Glass or Acrylic(1)

Ceiling Hardware;Wall Hardware(1)

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

Velcro;Velcro Backed Magnet(1)

Stand Base(1)

Adhesive Tape(1)

 
Message(s)

Customizable(15)

Safety First(2)

Custom(2)

Exit(2)

No Smoking(2)

Women(2)

Men(2)

In Case of Fire Use Stairs(1)

Stairs(1)

Men (with Wheelchair)(1)

Restroom (Man/Woman)(1)

Women (with Wheelchair)(1)

Danger No Smoking(1)

Notice Authorized Personnel Only(1)

Come In; Open; Will Return(1)

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

Open(1)

Warning Biohazard(1)

Restroom (Man/Woman/Wheelchair)(1)

Caution Slippery When Wet(1)

Danger Keep Out(1)

Employees Only(1)

A.E.D.(1)

EXIT(1)

Danger(1)

Restroom(1)

Wheelchair(1)

Out of Service; Fuera de Servicio(1)

Closed; Open(1)

No Soliciting(1)

Wash Hands(1)

Employees Must Wash Hands Before Returning to Work(1)

Accessible (Wheelchair)(1)

Business Hours(1)

Employees Must Wash Hands(1)

 
Maximum Height

11"(5)

4"(3)

N/A(2)

52 in(1)

13 5/16"(1)

12 5/8"(1)

56 in(1)

59"(1)

50.20 in(1)

20"(1)

40 in(1)

12 1/8"(1)

73"(1)

7"(1)

46 in(1)

8 1/2"(1)

7 1/4"(1)

6 1/4"(1)

49 3/8 in(1)

60 in(1)

12"(1)

10 7/8"(1)

2"(1)

6"(1)

 
Write-On/Wipe Off Surface

No(44)

Yes(14)

 
Graphics Color(s)

White(12)

Gray/White(5)

Silver(5)

Red(3)

N/A(2)

White/Red/Black(2)

Black(2)

Green/White(2)

Black; Red; White(1)

Orange/Black(1)

Yellow/Black(1)

White/Blue/Black(1)

16-Color(1)

Red/Black(1)

Black/Red(1)

Bold Orange; Bold White(1)

 
Loading

Side(12)

Top(11)

Hinged Front(8)

Front(3)

Bottom; Side(1)

Bottom(1)

Top; Side(1)

Top/Sides(1)

Front Loading(1)

Top;Side(1)

 
Graphics

International Symbol(12)

Green/White(2)

NO(1)

Clock with Movable Hands(1)

n/a(1)

OPEN(1)

Snap-Out Directionals(1)

Red/Black/White(1)

Red AED Image(1)

Red EXIT Image(1)

Red/Black(1)

 
Lettering

Block(10)

Red(2)

Green/White(2)

NO(1)

N/A(1)

White/Red(1)

Red/Black(1)

 
Frame Color

Clear(31)

Gray(14)

Black(13)

White(6)

Silver(5)

Gray/White(5)

Black/Silver(5)

Green/Blue/Clear(2)

Red/Black/Clear(2)

Orange(2)

Silvertone(2)

Blue/Red/White(1)

Yellow(1)

Blue/White(1)

Clear w/Green Tinted Edges(1)

Graphite(1)

Black Stand / Clear Panels(1)

Blue(1)

 
Frame Material

Plastic(32)

PS(8)

Acrylic(6)

Aluminum(5)

PMMA(3)

PVC(3)

ABS Plastic(2)

Rigid Heavyweight Plastic(2)

Metal(1)

Polypropylene(1)

Styrene Plastic(1)

 
Insert Size

8 1/2 x 11(22)

11 x 8 1/2(5)

11 x 17(4)

4 x 6(3)

5 x 7(2)

14 x 11(1)

2 x 10(1)

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

8 1/2 x 11 - 40(1)

24 x 36(1)

24 x 18(1)

8 1/2 x 2(1)

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

5 7/8 x 2(1)

4 1/4" x 11"(1)

8 1/2" x 11"(1)

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

4 x 11(1)

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

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

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

 
Face Color(s)

Clear(47)

Black(6)

Gray(5)

Translucent(4)

White(2)

Orange(1)

Clear; Frosted(1)

 
Display

Easel(4)

LED(3)

2-Sides(3)

3-Sides(2)

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

N/A(1)

NO(1)

 
 
 

© 2017-2018 Gateway Business Products, All Rights Reserved