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 ('4852')) 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 ('BulletinBoardBorders' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+BulletinBoardBorders' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"BulletinBoardBorders"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"BulletinBoardBorders"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"BulletinBoardBorders"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"BulletinBoardBorders"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+BulletinBoardBorders' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='BulletinBoardBorders',`category_4` ='BulletinBoardBorders') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'BulletinBoardBorders,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('BulletinBoardBorders', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Bulletin Board Borders

Refine Search

  GO
Brand

Ashley(16)

Color

Black|000000(5)

Multicolor|FFFFFF(4)

Lime Green|32CD32(2)

Gold|A57C00(1)

Silver|C0C0C0(1)

Magenta|FF00FF(1)

Black/White|000000(1)

Blue|0000FF(1)

Red|FF0000(1)

Height

1"(3)

Width

144"(6)

1"(6)

Country of Origin

China(16)

Shape

Scalloped(13)

12 x Scalloped Border(2)

12 x Scalloped(1)

Skill Learning

Art & Design(2)

Animal(1)

Theme/Subject

Fun(9)

Mount Type

Magnetic(16)

Printed Design/Pattern/Texture

Scribble(7)

Sparkle(2)

White Dots/Black(1)

Scribbled Chalk(1)

Chevron Pattern(1)

Stars(1)

Color Dots(1)

Owl Pattern(1)

Dotted(1)

Product Type

Border(16)

Packaged Quantity

1 Pack(7)

12 Piece(5)

12 / Pack(2)

6 / Pack(2)

Assembly Required

No(16)

Application/Usage

Door(15)

Locker(15)

Window(15)

Whiteboard(15)

Home(3)

Classroom(3)

Decoration(2)

Multipurpose(1)

Features

Long Lasting(16)

Durable(16)

Damage Resistant(16)

Product Name

Scribble Design Magnetic Border(4)

Magnetic Decortative Borders(3)

Sparkle Magnetic Decorative Border(2)

Dotted Magnetic Big Decorative Border(1)

Scribbled Chalk Big Magnetic Border(1)

Black Chevron Pattern Magnetic Border(1)

Colorful Circles Magnetic Border(1)

Colorful Owls Magnetic Border(1)

Stars Design Magnetic Border(1)

Dotted Pattern Magnetic Border(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved