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(375)

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)

Utility & Breakroom Tables(46)

Dry-Erase Boards(46)

Lamps(39)

Adjustable Worksurfaces(38)

Contemporary - Metal(38)

Panels/Partitions(37)

Mobile Pedestals(36)

Storage Cabinets(34)

Stools & Drafting Chairs(27)

Folding/Stacking Chairs & Carts(25)

Carpet Chair Mats(24)

Legs(22)

Laminate Tops(22)

Wire Shelving(17)

Metal Bookcases(15)

Wall Clocks(15)

Book Racks(14)

Protectors(14)

Wood Veneer Bookcases(14)

Folding Tables(14)

Desktop Organizers(14)

Cork/Fabric Bulletin Boards(13)

Shelf(12)

Educational Seating(12)

Casters(11)

Bulletin Boards(11)

Desktop Risers(11)

Hard Floor Chair Mats(11)

Mobile File Carts & Cabinets(11)

Work Surfaces(10)

Heaters(10)

Ottomans(10)

Easel Boards(9)

Utility/Service Carts(9)

Desk Pads(9)

TV/VCR Stands & Mounts(8)

Fans(8)

Panel System Hardware(8)

Letter Trays(7)

Backrests & Seat Cushions(7)

Industrial & Commercial Shelving(7)

Workstations/Computer Desks(7)

Monitor Arms(6)

Business Card Holders(6)

Pencil Holders(6)

Traditional - Laminate(6)

Laminate Bookcases(6)

Wood Lateral Files(6)

Headrest(5)

Frames(5)

Magnets(5)

Portable Storage Files & Bins(5)

Monitor Stands/Risers(5)

Card Files & Holders(5)

Board Erasers(5)

Coat/Garment Hooks(5)

Desktop File Sorters(5)

Wall Racks(5)

Foot Rests(4)

Refrigerators(4)

Reception Area & Accent Tables(4)

Base(4)

Bulletin Bars(4)

Laptop Cases & Bags(4)

Hooks & Hangers(4)

Hand Trucks & Dollies(4)

Anti-Static Chair Mats(4)

Keyboard/Mouse Platforms & Trays(4)

Printer/Fax Stands(3)

Power Strips(3)

Dry Erase Markers(3)

Wall Files, Pockets & Accessories(3)

Desk Center Drawers(3)

Storage Drawers & Accessories(3)

Compact & Student Desks(3)

Notes Holders / Dispensers(2)

Loveseat Sofa(2)

Paper Clip Holders(2)

Lecterns(2)

Paper Clips(2)

Reception Sofa(2)

Phone Stands(2)

Signs & Sign Holders(2)

Projector Mounts(2)

Light Bulbs & Tubes(2)

Combination Bulletin/Dry-Erase Boards(2)

Multimedia Carts(2)

Big & Tall Chairs(2)

Waste Containers & Accessories(2)

Open Shelf Files(2)

Coat/Garment Hangers(2)

Anti-Fatigue Mats(1)

Surge Protectors(1)

Mounting Putty(1)

Wall Planners & Organizers(1)

Pad Retainers(1)

Business Card Refills(1)

Desktop Shelves(1)

Push Pins(1)

Mirrors(1)

Mail Carts(1)

Bookends(1)

Magazine Files(1)

Literature Organizers/Sorters(1)

Ice Buckets(1)

Traditional - Veneer(1)

File Divider Kit(1)

File Rails/Frames(1)

Briefcases(1)

Desk Clocks(1)

Sliders(1)

Doorstops(1)

Board Cleaners & Wipes(1)

Bulletin/Map Rails(1)

Telephone Stands & Holders(1)

Bulletin Board Sets(1)

Laptop Stands & Pads(1)

Rulers & Yardsticks(1)

Nameplates(1)

Brand

Lorell(1990)

Color

Black(419)

Clear(72)

Mahogany(56)

Putty(51)

Silver(46)

Light Gray(43)

Cherry(39)

White(36)

Charcoal(28)

Gray(24)

Chrome(23)

Walnut(21)

Brown(17)

Green(17)

Blue(16)

Beige(11)

Medium Tone(9)

Espresso(9)

Ocean(7)

Navy(7)

Buff(7)

Apple Green(7)

Stratus(7)

Cloud(7)

Red(6)

Charcoal Gray(6)

Latte(5)

Bronze(5)

Satin(5)

Aluminum(5)

Roulette(5)

Pepper(5)

Chambray(5)

Tan(4)

Oxblood(4)

Natural(4)

Periwinkle Blue(4)

Malted(4)

Real Red(4)

Matte(3)

Green Edge(3)

Transparent(3)

Laminate(3)

Espresso Laminate(2)

Saddle(2)

Platinum(2)

- Frame(2)

White Shade(2)

Black Hanger(2)

Slate(2)

Wine(2)

Clear Frame(2)

Assorted(2)

Frosted(2)

Silver Mist(2)

Brick Beige(1)

Light Blue(1)

Stainless Steel(1)

Lime(1)

Citronella(1)

Blueberry(1)

Black Cherry(1)

Cafe(1)

Sand(1)

Black Base(1)

Hook(1)

Black Mahogany(1)

Heat Wave(1)

Taupe(1)

Mahogany - Frame(1)

Cherry - Frame(1)

Midnight Blue(1)

Gray Black(1)

Chinchilla(1)

Charcoal Black(1)

Multi(1)

Size

8.50" Width x 11" Length(2)

72.50" Width x 59.25" Height(1)

30.50" Width x 71" Height(1)

60.75" Width x 59.25" Height(1)

48.75" Width x 59.25" Height(1)

30.50" Width x 59.25" Height(1)

36.38" Width x 59.25" Height(1)

36.38" Width x 71" Height(1)

60.38" Width x 71" Height(1)

11" Width x 8.50" Length(1)

8" Width x 10" Length(1)

Large (L)(1)

1.20" Diameter(1)

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

1" Height x 1" Width(1)

48.38" Width x 71" Height(1)

Size Supported

Lateral File(1)

Recycled

No(1087)

Yes(355)

Price Range

$0-$499.99(1826)

$500-$999.99(155)

$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