SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 ('741')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_cost`=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 MATCH(`desc_short`) AGAINST ('Frames' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Frames' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Frames"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Frames"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Frames"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Frames"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Frames' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Frames',`category_4` ='Frames') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Frames,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Frames', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Frames

Refine Search

  GO
Brand

DAX(58)

NuDell(28)

HYGLOSS PRODUCTS,INC.(16)

AbilityOne(15)

Universal(14)

deflecto(2)

Pacon(1)

Scotch(1)

Advantus(1)

Moon Products(1)

Height

11"(16)

13"(7)

14"(5)

12"(4)

10"(3)

16"(2)

10.5"(2)

14 1/2"(2)

13 1/2"(2)

13.13"(2)

8.5"(2)

12.5"(2)

24"(2)

36"(2)

12 63/100"(1)

11 63/100"(1)

15 5/8"(1)

9 3/4"(1)

1/2"(1)

16 19/50"(1)

11.2"(1)

8 1/2"(1)

15 19/100"(1)

12 19/100"(1)

10 1/4"(1)

8"(1)

15 7/20"(1)

6"(1)

11 1/4"(1)

20 1/2"(1)

24 3/8"(1)

36 1/2"(1)

7"(1)

9"(1)

13 13/100"(1)

9 11/16"(1)

11.8"(1)

10 1/2"(1)

9 1/2"(1)

15 1/4"(1)

16.5"(1)

10.38"(1)

15"(1)

12.63"(1)

10.63"(1)

9.4"(1)

37.5"(1)

20.5"(1)

26"(1)

38"(1)

11 1/8"(1)

25.5"(1)

11.9"(1)

12.9"(1)

13.63"(1)

10.88"(1)

13 5/8"(1)

16 5/8"(1)

22"(1)

15.5"(1)

2"(1)

11.88"(1)

11 7/8"(1)

15.38"(1)

38 3/4"(1)

12.1"(1)

Color(s)

Assorted(1)

Width

8 1/2"(20)

11"(18)

13"(14)

10 1/2"(10)

10"(8)

8.5"(8)

8"(6)

12"(6)

18"(6)

14"(4)

9"(4)

11.22"(4)

0.6"(4)

6 1/4"(4)

10.5"(4)

24"(4)

11 1/4"(4)

10.75"(4)

13 19/50"(2)

12 1/2"(2)

9 63/100"(2)

10 13/100"(2)

12 5/8"(2)

10 3/4"(2)

12 1/4"(2)

24 3/8"(2)

5"(2)

8 3/4"(2)

4"(2)

16 3/8"(2)

11 3/4"(2)

9 1/2"(2)

18 3/8"(2)

10 63/100"(2)

9.3"(2)

9 3/4"(2)

12.5"(2)

17.5"(2)

19.5"(2)

26"(2)

20"(2)

25.5"(2)

12.38"(2)

6"(2)

9.78"(2)

11 1/2"(2)

8 5/8"(2)

18.9"(2)

13.5"(2)

15.1"(2)

8.8 "(2)

13 5/8"(2)

11.25"(2)

9.25"(2)

9 1/4"(2)

26 3/4"(2)

12 19/100"(2)

Country of Origin

CN(101)

US(20)

Material(s)

Polyurethane(1)

Length

3/4"(1)

Orientation

Horizontal; Vertical(90)

Horizontal/Vertical(13)

Horizontal(13)

Horizontal Or Vertical(1)

Vertical or Horizontal(1)

Vertical(1)

Mounting

Wall(58)

Desktop Easel Back; Wall(33)

Desktop; Wall(11)

Desktop Easel Back(8)

Desktop(3)

Hangers(3)

Fabric Panel; Metal Surface(1)

Panel/Partition; Wall(1)

Mat Color

White(9)

Black; White(7)

Black(5)

Off-White(3)

Charcoal with Gold inner border(2)

Brown(1)

Charcoal over Gray(1)

Off-White over Black(1)

Taupe over Black(1)

Silver Metal(1)

White w/Black Outline(1)

Black over Rosewood(1)

Frame Color

Black(37)

Clear(11)

Walnut(10)

Black/Gold(6)

Mahogany(6)

Rosewood(4)

Cherry(3)

Black/Mahogany(3)

Rosewood/Black(3)

Black/Walnut(2)

Black/Clear(2)

Walnut Vinyl(2)

Black/Silver(2)

Mahogany/Gold(2)

Metallic Silver(2)

Charcoal/Nickel Tone(2)

Brushed Charcoal(2)

Mahogany/Silver(2)

Gray/Gold(2)

Gold(2)

Black Marble(1)

White(1)

Black/Gold Accent(1)

Brown(1)

Blue(1)

Burgundy(1)

Bronze(1)

Maple(1)

Silver(1)

Oak(1)

Walnut/Black(1)

Walnut with Gold Metallic Inlay(1)

Black with Gold Embossed Braid(1)

Walnut Stained(1)

Pewter/Black(1)

Frame Material

Plastic(55)

Wood(38)

Polystyrene(4)

Solid Wood(4)

Metal(3)

Bamboo(3)

Leatherette(3)

Wood/Acrylic(2)

Acrylic(2)

Solid Oak(2)

Aluminum(1)

Vinyl(1)

Plastic Face(1)

Paperboard(1)

Insert Size

8 1/2 x 11(34)

8.5 x 11(24)

8 x 10(9)

11 x 14(7)

11 x 14 matted to 8.5 x 11(7)

24 x 36(6)

18 x 24(5)

5 x 7(4)

Up to 8.5 x 11(3)

16 x 20(3)

11 x 14 matted to 8 1/2 x 11(2)

Assorted(1)

9" x 12"(1)

10 x 14(1)

8/12 x 11(1)

4 x 6(1)

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

8 1/2 x 10(1)

8 1/2 x 14(1)

2 x 6 1/4(1)

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

11 x 17(1)

12 x 18(1)

8" x 10"(1)

11 x 8 1/2(1)

8 1/2" x 11"(1)

Frame Type

Certificate/Document(72)

Photo(15)

Poster/Print(14)

Certificate/Document; Photo(8)

Certificate/Photo(5)

Digital(3)

Multipurpose(2)

Mat(1)

Color Family

Black(49)

Walnut(13)

Mahogany(12)

Clear(7)

Gray(4)

Cherry(3)

Silver(2)

Blue(1)

Red(1)

Oak(1)

Special Features

With Gold Accent and Plastic Face(3)

Includes a Two-Way Easel(2)

Value Pack-Stock up and save!(2)

Two-Way Easel Backs(2)

Includes Hangers for Wall Display and Usable Certificate(1)

Army(1)

Reversible Mat-Mats down to 8 x 10.(1)

Includes Off-White Over Black Double-Beveled Mat(1)

Value Pack-Stock up and save! Gold Accent and plastic face.(1)

Narrow-Profile Black Frames with Gold Trim-Value Pack - Stock up and save!(1)

Wall-Mount-Includes hardware and white mat.(1)

Easel Back(1)

Wide-Profile Black Frames-Value Pack - Stock up and save!(1)

Includes Taupe Over Black Double-Beveled Mat(1)

Perfect for Phone Lists!(1)

For Wall Display Only(1)

Includes Black Mat(1)

Double Die-Cut Mat; Usable Certificate(1)

Double Beveled Mat (Gray over Charcoal)(1)

11 x 14-Features black matting.(1)

Includes Off-White Die-Cut Mat and Hangers for Wall Display(1)

Includes Hangers for Wall Display(1)

11 x 14-Features white matting with a black outline.(1)

Usable Certificate(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved