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

Manufacturer

Currently Filtered by

Manufacturer

Lorell

Refine Search

  GO
Category

Contemporary - Laminate(302)

Executive/High Back Chairs(129)

Reception, Side & Guest Chairs(103)

Task Chairs(71)

Meeting & Conference Room Tables(70)

Metal Lateral Files(65)

Training Room Tables(57)

Contemporary - Veneer(56)

Metal Vertical Files(54)

Management/Mid-Back Chairs(51)

Dry-Erase Boards(46)

Utility & Breakroom Tables(46)

Contemporary - Metal(38)

Panels/Partitions(37)

Adjustable Worksurfaces(37)

Mobile Pedestals(36)

Storage Cabinets(34)

Stools & Drafting Chairs(27)

Folding/Stacking Chairs & Carts(25)

Carpet Chair Mats(24)

Laminate Tops(22)

Lamps(18)

Wire Shelving(17)

Wall Clocks(15)

Metal Bookcases(15)

Protectors(14)

Wood Veneer Bookcases(14)

Desktop Organizers(14)

Folding Tables(14)

Cork/Fabric Bulletin Boards(13)

Book Racks(13)

Shelf(12)

Educational Seating(12)

Mobile File Carts & Cabinets(11)

Bulletin Boards(11)

Hard Floor Chair Mats(11)

Casters(11)

Ottomans(10)

Heaters(10)

Legs(10)

Desk Pads(9)

Easel Boards(9)

Fans(8)

TV/VCR Stands & Mounts(8)

Panel System Hardware(8)

Desktop Risers(7)

Industrial & Commercial Shelving(7)

Workstations/Computer Desks(7)

Letter Trays(7)

Backrests & Seat Cushions(7)

Business Card Holders(6)

Traditional - Laminate(6)

Wood Lateral Files(6)

Laminate Bookcases(6)

Pencil Holders(6)

Desktop File Sorters(6)

Portable Storage Files & Bins(5)

Monitor Stands/Risers(5)

Wall Racks(5)

Card Files & Holders(5)

Utility/Service Carts(5)

Frames(5)

Board Erasers(5)

Coat/Garment Hooks(5)

Headrest(5)

Magnets(5)

Reception Area & Accent Tables(4)

Laptop Cases & Bags(4)

Base(4)

Hand Trucks & Dollies(4)

Refrigerators(4)

Hooks & Hangers(4)

Anti-Static Chair Mats(4)

Bulletin Bars(4)

Keyboard/Mouse Platforms & Trays(4)

Power Strips(3)

Storage Drawers & Accessories(3)

Printer/Fax Stands(3)

Dry Erase Markers(3)

Compact & Student Desks(3)

Wall Files, Pockets & Accessories(3)

Desk Center Drawers(3)

Waste Containers & Accessories(2)

Projector Mounts(2)

Lecterns(2)

Combination Bulletin/Dry-Erase Boards(2)

Foot Rests(2)

Paper Clip Holders(2)

Light Bulbs & Tubes(2)

Paper Clips(2)

Phone Stands(2)

Big & Tall Chairs(2)

Reception Sofa(2)

Signs & Sign Holders(2)

Loveseat Sofa(2)

Coat/Garment Hangers(2)

Notes Holders / Dispensers(2)

Open Shelf Files(2)

Monitor Arms(2)

Multimedia Carts(2)

Desktop Shelves(1)

Bulletin/Map Rails(1)

Nameplates(1)

Mirrors(1)

Business Card Refills(1)

Bookends(1)

Magazine Files(1)

Wall Planners & Organizers(1)

Push Pins(1)

Mail Carts(1)

Ice Buckets(1)

Literature Organizers/Sorters(1)

Pad Retainers(1)

File Rails/Frames(1)

File Divider Kit(1)

Rulers & Yardsticks(1)

Bulletin Board Sets(1)

Desk Clocks(1)

Briefcases(1)

Sliders(1)

Laptop Stands & Pads(1)

Traditional - Veneer(1)

Doorstops(1)

Board Cleaners & Wipes(1)

Mounting Putty(1)

Telephone Stands & Holders(1)

Brand

Lorell(1857)

Color

Black(393)

Clear(72)

Mahogany(56)

Putty(51)

Light Gray(43)

Silver(40)

Cherry(39)

White(32)

Charcoal(28)

Gray(24)

Walnut(21)

Chrome(21)

Brown(17)

Green(17)

Blue(15)

Beige(11)

Medium Tone(9)

Espresso(9)

Buff(7)

Navy(7)

Ocean(7)

Apple Green(7)

Cloud(7)

Stratus(7)

Red(6)

Satin(5)

Bronze(5)

Latte(5)

Chambray(5)

Aluminum(5)

Pepper(5)

Roulette(5)

Tan(4)

Oxblood(4)

Real Red(4)

Malted(4)

Periwinkle Blue(4)

Transparent(3)

Green Edge(3)

Laminate(3)

Matte(3)

Platinum(2)

Saddle(2)

Espresso Laminate(2)

- Frame(2)

Black Hanger(2)

Assorted(2)

Slate(2)

Natural(2)

Silver Mist(2)

Clear Frame(2)

Frosted(2)

Wine(2)

Brick Beige(1)

Stainless Steel(1)

Light Blue(1)

Cherry - Frame(1)

Citronella(1)

Blueberry(1)

Black Cherry(1)

Cafe(1)

Sand(1)

Black Base(1)

Lime(1)

Black Mahogany(1)

Hook(1)

Taupe(1)

Mahogany - Frame(1)

Midnight Blue(1)

Charcoal Black(1)

Heat Wave(1)

Chinchilla(1)

Multi(1)

Size

38" x 12"(2)

8.50" Width x 11" Length(2)

30.50" Width x 71" Height(1)

48.38" Width x 71" Height(1)

36.38" Width x 71" Height(1)

72.50" Width x 59.25" Height(1)

30.50" Width x 59.25" Height(1)

36.38" Width x 59.25" Height(1)

48.75" Width x 59.25" Height(1)

60.75" Width x 59.25" Height(1)

60.38" Width x 71" Height(1)

23.62" x 17.75"(1)

Large (L)(1)

11" Width x 8.50" Length(1)

8" Width x 10" Length(1)

1.20" Diameter(1)

1" Height x 1" Width(1)

23.63" x 17.75"(1)

15"(1)

15" x 19.88"(1)

35.38" Width x 7.63" Depth x 12.63" Height(1)

Size Supported

Lateral File(1)

Recycled

No(1076)

Yes(286)

Price Range

$0-$499.99(1715)

$500-$999.99(140)

$1000-$1499.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2017-2018 Granite Office, LLC, All Rights Reserved