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 ('20092')) 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

deflecto(16)

Headline Sign(12)

Durable(7)

NuDell(5)

Tarifold, Inc.(4)

People Pointer(3)

Quartet(3)

DAX(2)

Rubbermaid Commercial(2)

C-Line(2)

Advantus(2)

Newon(1)

COSCO(1)

Tatco(1)

Safco(1)

 
Size

8 1/2 x 11(6)

10 1/4 x 14 1/2(4)

3 x 9(3)

6 x 9(2)

9 x 2(2)

11 x 17(2)

8 1/2" x 11"(2)

15 x 23 1/2(1)

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

50 x 1 x 13(1)

44 to 73(1)

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

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

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

14 x 11(1)

15 x 15 x 64(1)

13 x 5(1)

13 x 21(1)

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

7 1/2 x 9(1)

4 x 13(1)

8 x 12(1)

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

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

13 x 14(1)

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

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

11 x 8 1/2(1)

15 x 46 1/2(1)

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

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

9 x 3(1)

4 1/4" x 11"(1)

8.5 x 2(1)

8.5 x 3.75(1)

9 3/8 x 2(1)

40" to 60"(1)

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

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

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

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

8 1/2" x 3 1/2" x 11"(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)

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 3 13/16" x 11 1/4"(1)

13" x 13" x 56"(1)

 
Warranty

Manufacturer's limited one-year warranty.(2)

Manufacturer's limited three-year warranty.(1)

Manufacturer's limited lifetime warranty.(1)

Manufacturer's 10-year warranty.(1)

 
Special Features

Classic Image-Loads from the bottom.(3)

Magnetic Back(3)

Classic Image-Literature slides in from the side.(2)

Slanted Sign Holder(2)

T-Frame Base(1)

Stand-Up Vertical-Free-standing, bottom-load design. Viewable from both directions, front and back.(1)

Adhesive Back(1)

Multi-Lingual-Imprinted with "Closed for Cleaning" in English and Spanish.(1)

Portrait Wall Mount-Pre-drilled holes make mounting easy. Change inserts without removing from wall.(1)

Stand-Up Slanted-Side-loading. Ideal for retailers, restaurants, trade shows and hospitals.(1)

Includes pin connector for fabric walls(1)

Superior Image-Loads from the top. Polished rounded edges for safety in handling. Sealed on three sides to protect inserts.(1)

Superior Image(1)

Superior Image-Loads from the top. Rounded, polished edges and sealed on three sides to prevent slipping.(1)

Multi-Surface Wall Mount-Self-stick hook & loop piece mounts to fabric wall; Optional magnet back for mounting to metal surfaces.(1)

 
For Use With

Letter-Size Inserts(4)

Half-Letter Size Inserts(1)

Tabloid-Size Inserts(1)

C-Line Tent Cards(1)

 
Message(s)

Customizable(16)

Employees Only(2)

Closed; Open(2)

Exit(2)

Fire Extinguisher(1)

Restroom (Man/Woman/Wheelchair)(1)

Come In; Open; Will Return(1)

Open(1)

Visitors Must Sign In(1)

Business Hours(1)

Caution(1)

Closed For Cleaning;Cerrado Por Limpieza(1)

Employees Must Wash Hands Before Returning to Work(1)

No Soliciting(1)

 
Manufacturer Part Number

1867507(1)

7923(1)

9S1600YL(1)

4174GR(1)

P194943(1)

07230(1)

7922(1)

3655(1)

35485Z(1)

899102(1)

37085Z(1)

38017Z(1)

38020Z(1)

38020(1)

P194944(1)

P194945(1)

4793(1)

4792(1)

4811(1)

5583(1)

9382(1)

5694(1)

4763(1)

4760(1)

3727(1)

P194993(1)

4246(1)

4247(1)

4758(1)

4726(1)

799693(1)

69701(1)

476801(1)

N270985VT(1)

476803(1)

476901(1)

491301(1)

4814-23(1)

N270985HT(1)

098206(1)

75334(1)

75329(1)

75390(1)

83700(1)

87507(1)

36911(1)

4977-37(1)

558957(1)

69101(1)

68301(1)

691590(1)

69201(1)

69301(1)

692056(1)

68201(1)

66701(1)

590301(1)

590101(1)

590801(1)

5991790(1)

5991890(1)

75318(1)

 
Country of Origin

CN(39)

US(7)

TW(5)

PL(5)

DK(4)

DE(2)

 
Height

11"(5)

0.12"(4)

9"(4)

12"(3)

2"(3)

3"(3)

9 1/2"(2)

8 3/4"(2)

8 1/2"(2)

23 1/2"(1)

13"(1)

44" - 73"(1)

59"(1)

52"(1)

64"(1)

4"(1)

2 1/2"(1)

25 1/2"(1)

14"(1)

5"(1)

12 3/8"(1)

13 5/16"(1)

56"(1)

5 1/8"(1)

Adjustable 40-60"(1)

4 1/4"(1)

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

18"(1)

10 7/8"(1)

7 5/16"(1)

7"(1)

12 1/8"(1)

8 7/16"(1)

11 3/4"(1)

11 1/4"(1)

12 5/8"(1)

 
Width

9"(6)

8 1/2"(6)

10 1/4"(4)

9 1/2"(3)

13"(3)

11"(3)

15"(3)

6"(2)

10 1/16"(1)

7 1/2"(1)

8 9/16"(1)

10 7/8"(1)

50"(1)

8 5/8"(1)

14 3/8"(1)

12 1/4"(1)

10 1/2"(1)

11 1/16"(1)

3"(1)

11 1/6"(1)

9 3/8"(1)

8 3/4"(1)

12"(1)

6 1/2"(1)

11 1/8"(1)

5.438(1)

8.938(1)

6 3/4"(1)

5"(1)

 
Depth

14 1/2"(4)

1/8"(3)

1/2"(3)

3 1/2"(3)

2 5/8"(2)

2 1/2"(2)

3 3/8"(2)

1/16"(1)

15"(1)

1 1/4"(1)

13"(1)

1"(1)

3/8"(1)

2 1/16"(1)

5/8"(1)

4 1/2"(1)

3 13/16"(1)

3 11/32"(1)

1/4"(1)

 
Material(s)

Plastic(11)

Styrene Plastic/PS(6)

Molded Plastic(5)

PVC(5)

Acrylic(3)

Heavy-Duty Plastic(3)

PVC/Magnetic Material(3)

PS/Plastic(2)

Durable Plastic(2)

PMMA(2)

Styrene Plastic(2)

Metal(2)

Rugged Polycarbonate(1)

Steel(1)

Rigid Heavyweight Plastic(1)

Polypropylene(1)

Thick Plastic(1)

Lightweight Aluminum(1)

Fabric(1)

Brass/Wood/Rubber(1)

PMMA/ABS(1)

Alumnium/Acrylic/Cast Iron Base(1)

ABS Plastic(1)

PMMA/Iron(1)

PMMA/Metal(1)

Aluminum(1)

Plastic/Metal(1)

Acrylic/Metal(1)

 
Shape

Rectangular(42)

Radius Corner Rectangular(2)

Rectangle(2)

 
Frame Color

Clear(26)

Black(11)

Gray(5)

Black/Silver(4)

Red(3)

Silver(3)

Red/White(2)

Yellow/Black(1)

Green/White(1)

Blue/White(1)

Clear w/Green Tinted Edges(1)

Black Stand / Clear Panels(1)

Brown(1)

Yellow(1)

White(1)

 
Frame Material

Plastic(12)

PS(8)

PMMA(5)

Acrylic(4)

PVC(4)

Steel(1)

Wood(1)

Aluminum(1)

Metal(1)

ABS Plastic(1)

Polypropylene(1)

Rigid Heavyweight Plastic(1)

Aluminum; Acrylic(1)

Styrene Plastic(1)

 
Base Material

Plastic(12)

PVC(4)

Metal(4)

PMMA(2)

Aluminum(1)

Rubber(1)

Steel(1)

Acrylic(1)

Iron(1)

Cast Iron(1)

Lightweight Aluminum(1)

ABS(1)

ABS Plastic(1)

 
Placement

Desktop(14)

Floor(8)

Wall; Flat Surface; Glass(3)

Wall(3)

Any Metal Surface(3)

Door;Wall(2)

Fabric Panel(2)

Wall;Flat Surface(2)

Flat Surface(2)

Countertop; Desktop(2)

Non Porous Clean Surface(1)

Magnetic Surfaces;Wall(1)

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

Door; Wall(1)

Cubicle Panel Top(1)

Glass or Other Non-porous Materials(1)

 
Orientation

Portrait(16)

Landscape(9)

Landscape; Portrait(7)

Portrait; Landscape(4)

Horizontal(3)

Vertical(2)

Landscape;Portrait(1)

Horizontal/Vertical(1)

Horizontal; Vertical(1)

 
Mounting

Double-Sided Adhesive Tape(5)

Suction Cups(3)

Any Metal Surface(3)

Self-Adhesive(3)

Clips;Double Stick Foam Tape(2)

Adhesive Tape(2)

Predrilled Holes(2)

Ceiling Hardware;Wall Hardware(1)

Suction Cups for Glass or Acrylic(1)

Non Porous Clean Surface(1)

Punched Hole(1)

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

Adhesive Pads(1)

Free Standing(1)

Adhesive Tabs; Screws; Panel Pin(1)

Adjustable Clamp(1)

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

Torsion Action Pole(1)

 
Insert Size

8 1/2 x 11(22)

11 x 8 1/2(5)

11 x 17(3)

9" x 2"(2)

5 x 7(2)

8 1/2" x 11"(2)

14 x 11(1)

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

8 1/2 x 11 - 40(1)

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

4 1/4" x 11"(1)

8.5" x 3.75"(1)

8.5" x 2"(1)

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

 
Display

Easel(3)

LED(2)

2-Sides(2)

 
Maximum Height

11"(4)

8 1/2"(2)

7"(2)

12 5/8"(1)

56 in(1)

13 5/16"(1)

52 in(1)

64 in(1)

73"(1)

59"(1)

12 1/8"(1)

8 3/4"(1)

46 1/2"(1)

12"(1)

6 3/4"(1)

60"(1)

11 1/4"(1)

10 7/8"(1)

8 7/16"(1)

 
Face Color(s)

Clear(36)

Black(6)

Translucent(3)

White(2)

Brown/Brass(1)

Crystal Clear(1)

Red(1)

 
Write-On/Wipe Off Surface

No(25)

Yes(16)

 
Graphics Color(s)

Silver(5)

White(2)

Red Glow(2)

Red/White Striped Border(2)

Black; Red; White(1)

Green/White Striped Border(1)

Red(1)

Yellow/Black Striped Border(1)

Black(1)

Bold Orange; Bold White(1)

 
Graphics

Bi-Color Frame(4)

International Symbol(3)

Clock with Movable Hands(1)

OPEN(1)

Arrow(1)

Snap-Out Directionals(1)

 
Lettering

Block(4)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved