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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`category_name` IN ('Frames','Hooks & Hangers')) 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 MATCH(`desc_short`) AGAINST ('WallArtandDecoration' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+WallArtandDecoration' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"WallArtandDecoration"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"WallArtandDecoration"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"WallArtandDecoration"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"WallArtandDecoration"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+WallArtandDecoration' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='WallArtandDecoration',`category_4` ='WallArtandDecoration') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'WallArtandDecoration,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('WallArtandDecoration', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Wall Art And Decoration

Refine Search

  GO
Brand

DAX(37)

Command(32)

Dax(25)

Nu-Dell(13)

SKILCRAFT(9)

Lorell(7)

Safco(7)

DURABLE(5)

deflecto(5)

Glolite Nu-dell(2)

OIC(2)

Pacon(2)

Learning Resources(2)

Advantus(2)

Alba(2)

C-Line(1)

Quartet(1)

Adams(1)

Teacher Created Resources(1)

Avery(1)

Scotch(1)

Burnes(1)

Creativity Street(1)

Baumgartens(1)

Color

Black(58)

White(20)

Silver(19)

Clear(15)

Walnut(8)

Rosewood(7)

Mahogany(6)

Gold(6)

Clear Faceplate(5)

Black Frame(5)

Nickel(4)

Trim(4)

Black Mat(3)

Clear Hook(3)

Blue(3)

Black Strip(2)

Cherry(2)

Gold Trim(2)

Gold Mat(2)

Gold Strip(2)

Silver Trim(2)

Metallic Silver(2)

Charcoal(2)

Yellow(2)

Clear Strip(2)

Clear Frame(2)

Mahogany Frame(2)

Honey(1)

Black Trim(1)

Gray(1)

Bronze(1)

Antique Silver Frame(1)

Gold Lip(1)

Burgundy(1)

Cream Mat(1)

Assorted(1)

Antique Gold Frame(1)

Black Hanger(1)

Red(1)

Taupe Mat(1)

Off White Mat(1)

Antique Bronze Frame(1)

Green(1)

Size

8.50" Width x 11" Length(2)

Recycled

No(116)

Yes(39)

Manufacturer Part Number

170812VPES(1)

17081BLKES(1)

17081CABPK(1)

17081ES(1)

17068ES(1)

17067CLR-VP(1)

17053BNES(1)

17066ES(1)

170679ES(1)

17083ES(1)

17089Q8ES(1)

17202ES(1)

FC12BNES(1)

FC13BNES(1)

17093CLRES(1)

17092CLRES(1)

17091CLR6ES(1)

17091CLRCABP(1)

17091CLRES(1)

17051BNES(1)

17048ES(1)

69879(1)

80674(1)

LER2694(1)

69878(1)

55642(1)

31880(1)

31887(1)

32119(1)

LER2698(1)

170016ES(1)

17006CLRES(1)

17006CLR-VP(1)

17047ES(1)

17006(1)

17004(1)

170016ESBG(1)

17002(1)

170033ES(1)

FC13ORBES(1)

MR03BNES(1)

22005(1)

30190(1)

72500(1)

38020(1)

38011(1)

21202(1)

31242(1)

38008(1)

74440(1)

85378(1)

4603GR(1)

6403BL(1)

20787(1)

4241BL(1)

4227BL(1)

4223BL(1)

4224BL(1)

4225BL(1)

21201(1)

17081(1)

7105-01-282-0630(1)

7105-01-282-0631(1)

7105013579978(1)

7105000615834(1)

7105000528690(1)

R100(1)

7105000528686(1)

7105000528689(1)

7105013579979(1)

7105-00-903-1843(1)

13880(1)

13980(1)

15815(1)

11888(1)

11880(1)

10570(1)

11800(1)

11818(1)

690005(1)

690004(1)

N118818T(1)

N1188N5(1)

N140246MT(1)

N140257MT(1)

3404W1T(1)

3404U1T(1)

2863U2X(1)

2863V2X(1)

2863W2X(1)

N140285M(1)

N15783NT(1)

N15788ST(1)

N1581GWT(1)

N1581MT(1)

N15787NT(1)

N15787HT(1)

N15783ST(1)

N15786NT(1)

N15786ST(1)

286322X(1)

2860W2X(1)

54510(1)

4379(1)

38991(1)

75370(1)

75318(1)

PMTRIA2N(1)

1900993241(1)

16150(1)

1511TB(1)

1511TM(1)

2811W5T(1)

286036X(1)

2860V2X(1)

2703S2RX(1)

1826S3T(1)

1826H3T(1)

1826L3T(1)

1826N3T(1)

N15832(1)

N15907B(1)

N3245N2T(1)

N3246N1T(1)

N3246S1T(1)

N3192NB(1)

N3191NB(1)

N3028N1T(1)

N3028N2T(1)

N3028S2T(1)

N4100N3T(1)

N4100S3T(1)

690001(1)

690002(1)

690003(1)

496923(1)

496901(1)

476823(1)

476901(1)

491301(1)

N2709S6T(1)

N2709N7T(1)

N17081AT(1)

N17981BT(1)

N1818N1T(1)

N16024BT(1)

N16018BT(1)

N15989LT(1)

N15989ST(1)

N16016BT(1)

N1818N2T(1)

N1818N3T(1)

N2704N1T(1)

N2704S1T(1)

N2709N6T(1)

N2702N2T(1)

N19881BT(1)

N1858N4T(1)

N1894U1T(1)

N1894W1T(1)

PMCINHANG12A(1)

Material

Plastic(26)

Plastic Frame(16)

Wood Frame(13)

Metal(10)

Glass Front(8)

Wood(8)

Plastic Face(7)

Plastic Faceplate(5)

Aluminum Frame(5)

Glass Face(5)

Plastic Hook(5)

Styrene Front(4)

Steel Plate(4)

Solid Wood Frame(4)

Acrylic(4)

Solid Wood(3)

Plastic Cover(3)

Leather Frame(2)

Leatherette(2)

Fiberboard Back(2)

Metal Wire(2)

Plastic Base(2)

Hardboard Back(2)

Steel(2)

Metal Frame(2)

Acrylic Frame(2)

Paper Mat(2)

Magnetic(1)

Vinyl(1)

Oak Frame(1)

ABS Plastic(1)

Metal Hook(1)

Tubular Steel(1)

Steel Base(1)

Polypropylene(1)

Styrene(1)

Plastic Hanger(1)

Metal Mat(1)

Tempered Glass(1)

Metal Hanger(1)

Hardwood(1)

Foam(1)

Width

1.8"(4)

4.7"(1)

1.4"(1)

1"(1)

1.1"(1)

17.5"(1)

26.8"(1)

0.8"(1)

4.3"(1)

0.3"(1)

9"(1)

0.9"(1)

1.3"(1)

6.1"(1)

Height

4"(3)

7.8"(2)

67"(1)

5"(1)

5.5"(1)

8"(1)

3.1"(1)

1.4"(1)

11"(1)

2"(1)

1.1"(1)

25.4"(1)

Depth

1.3"(2)

0.8"(2)

5.3"(2)

3.8"(1)

3"(1)

6.5"(1)

1"(1)

0.4"(1)

1.5"(1)

1.9"(1)

13"(1)

Shape

Rectangle(39)

Length

3.1"(2)

3.4"(1)

1.6"(1)

1.1"(1)

Style

Traditional(6)

Contemporary(3)

Thickness

46 mil(1)

Orientation

Vertical(80)

Horizontal(77)

Insert Width

8.50"(19)

11"(13)

18"(6)

8"(4)

24"(4)

5"(3)

7"(2)

16"(2)

12"(1)

9"(1)

4"(1)

22"(1)

Insert Height

11"(19)

8.50"(12)

24"(6)

36"(4)

10"(3)

7"(3)

20"(2)

6"(1)

12"(1)

18"(1)

9"(1)

5"(1)

10.50"(1)

17"(1)

28"(1)

Placement

Wall Mountable(78)

Desktop(33)

Surface(4)

Tabletop(1)

Door-mountable(1)

Weight Capacity

3 lb (1.36 kg)(8)

8 oz (226.8 g)(7)

5 lb (2.27 kg)(7)

10 lb (4.54 kg)(4)

1 lb (453.6 g)(3)

2 lb (907.2 g)(3)

4 lb (1.81 kg)(1)

20 lb (9.07 kg)(1)

7.50 lb (3.40 kg)(1)

13 lb (5.90 kg)(1)

30 lb (13.61 kg)(1)

8 lb (3.63 kg)(1)

Tape Width

1"(1)

Tape Length

1"(1)

Dispenser Included

No(1)

Country of Origin

China(113)

United States(21)

Mexico(15)

Taiwan(6)

Poland(5)

Malaysia(1)

Price Range

$0-$99.99(189)

$100-$199.99(8)

To  GO

 
 
1%
Searching for your Best Results.....
 

© 2018-2019 Shop Our Solutions is a Division of American Office Solutions,Inc., All Rights Reserved