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

Manufacturer

Currently Filtered by

Manufacturer

RDC LORELL FURNITURE

Refine Search

  GO
Category

Contemporary - Laminate(351)

Reception, Side & Guest Chairs(128)

Executive/High Back Chairs(124)

Task Chairs(112)

Meeting & Conference Room Tables(70)

Metal Lateral Files(65)

Training Room Tables(62)

Folding/Stacking Chairs & Carts(59)

Dry-Erase Boards(55)

Utility & Breakroom Tables(53)

Metal Vertical Files(49)

Management/Mid-Back Chairs(43)

Contemporary - Metal(40)

Mobile Pedestals(38)

Lamps(38)

Workstations/Computer Desks(33)

Adjustable Worksurfaces(33)

Stools & Drafting Chairs(32)

Storage Cabinets(31)

Carpet Chair Mats(24)

Industrial & Commercial Shelving(22)

Cork/Fabric Bulletin Boards(21)

Wire Shelving(20)

Legs(19)

Wall Clocks(18)

Wood Veneer Bookcases(17)

Mobile File Carts & Cabinets(16)

Metal Bookcases(15)

Utility/Service Carts(15)

Folding Tables(15)

Educational Seating(15)

Hard Floor Chair Mats(14)

Backrests & Seat Cushions(14)

Book Racks(14)

Desktop Risers(14)

Desktop Organizers(13)

Protectors(13)

Easel Boards(12)

Heaters(12)

Shelf(12)

Panels/Partitions(11)

Fans(11)

Ottomans(11)

Certificate Frames & Holders(11)

Bulletin Boards(11)

Work Surfaces(10)

Reception Area & Accent Tables(9)

Monitor Stands/Risers(8)

Big & Tall Chairs(7)

Casters(7)

Portable Storage Files & Bins(7)

Hand Trucks & Dollies(6)

Wood Lateral Files(6)

Wall Files, Pockets & Accessories(6)

Desk Pads(6)

Power Strips(6)

Board Erasers(6)

Monitor Arms(6)

Keyboard/Mouse Platforms & Trays(6)

Contemporary - Veneer(5)

Letter Trays(5)

Panel System Hardware(5)

Card Files & Holders(5)

Desktop File Sorters(5)

Pencil Holders(5)

Business Card Holders(5)

Laminate Tops(5)

Headrest(5)

Magnets(5)

Foot Rests(4)

Wall Racks(4)

Refrigerators(4)

Arm Sets(4)

Hooks & Hangers(4)

Anti-Static Chair Mats(4)

Loveseat Sofa(4)

Reception Sofa(4)

Bulletin Bars(4)

Exam Tables(3)

Coat/Garment Hooks(3)

Lecterns(3)

Laptop Cases & Bags(3)

Compact & Student Desks(3)

Printer/Fax Stands(3)

Dry Erase Markers(3)

Storage Drawers & Accessories(3)

Open Shelf Files(2)

Paper Clip Holders(2)

Anti-Fatigue Mats(2)

Notes Holders / Dispensers(2)

Magazine Files(2)

Phone Stands(2)

Recycling Bins(2)

Active Seating(2)

TV/VCR Stands & Mounts(2)

Signs & Sign Holders(2)

Combination Bulletin/Dry-Erase Boards(2)

Surge Protectors(2)

Multimedia Carts(2)

Cable Management(2)

Light Bulbs & Tubes(2)

Coat/Garment Hangers(2)

Waste Containers & Accessories(2)

Business Card Refills(1)

Mounting Putty(1)

Paper Clips(1)

Pad Retainers(1)

Indoor Mats(1)

Wall Planners & Organizers(1)

Nameplates(1)

Bookends(1)

Mail Carts(1)

Pads/Sliders(1)

Push Pins(1)

Desktop Shelves(1)

Rulers & Yardsticks(1)

Frames(1)

Sliders(1)

Doorstops(1)

Drawer Organizers(1)

Board Cleaners & Wipes(1)

File Divider Kit(1)

Briefcases(1)

Scratch Pads(1)

Laminate Bookcases(1)

Bulletin Board Sets(1)

Literature Organizers/Sorters(1)

File Rails/Frames(1)

Laptop Stands & Pads(1)

Ice Buckets(1)

Dry-Erase Kits/Holders(1)

Telephone Stands & Holders(1)

Brand

Lorell(2075)

Color

Black(461)

Clear(75)

White(49)

Putty(47)

Silver(37)

Light Gray(36)

Mahogany(36)

Gray(29)

Charcoal(26)

Chrome(22)

Cherry(21)

Walnut(20)

Blue(17)

Brown(17)

Green(16)

Navy(11)

Espresso(10)

Charcoal Gray(9)

Medium Tone(9)

Beige(9)

Red(8)

Pepper(8)

Stratus(7)

Buff(7)

Ocean(7)

Apple Green(7)

Cloud(7)

Periwinkle Blue(7)

Malted(7)

Real Red(7)

Chrome - Handle(5)

Aluminum(5)

Bronze(5)

Natural(4)

Tan(4)

Satin(4)

Platinum(4)

Oxblood(4)

Transparent(3)

Metallic Silver(3)

Green Edge(3)

Laminate(3)

Chambray(3)

Roulette(3)

Graphite(2)

Saddle(2)

White Shade(2)

Dark Blue(2)

Orange(2)

Silver Mist(2)

Burgundy(2)

Matte(2)

Clear Frame(2)

Assorted(2)

Rosewood(2)

Slate(2)

Black Hanger(2)

Champagne Gold(2)

Citronella(1)

Cafe(1)

Brick Beige(1)

Stone(1)

Hook(1)

Dark Gray(1)

Ivory(1)

Blueberry(1)

Sand(1)

Light Blue(1)

Black Cherry(1)

Charcoal Black(1)

Black Mahogany(1)

Chinchilla(1)

Smoke(1)

Midnight Blue(1)

Heat Wave(1)

Lime(1)

Taupe(1)

Stainless Steel(1)

Recycled

No(1137)

Yes(436)

Price Range

$0-$499.99(1824)

$500-$999.99(233)

$1000-$1499.99(9)

To  GO

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

© 2019-2020 Granite Office, LLC, All Rights Reserved