Polyurethane Central Vein Catheters  
SELECT `part_number`, `type`, `description`, `material`, `thumbnail_photo`, `thumbnail_photo` AS `thumbnail_outlines`, CONCAT(`size`, `size_unit`) AS `size`, CONCAT(`length`, `length_unit`) AS `catheter_length`, IF(`type` LIKE 'Single%', 1, IF(`type` LIKE 'Double%', 2, IF(`type` LIKE 'Triple%', 3, 4) ) ) AS `lumens`, IF(`size` < 6, 'Small Bore', '') AS `small_bore` FROM `product` WHERE `category` LIKE '%Polyurethane Central Vein Catheters' AND `part_number` NOT LIKE 'fake%' ORDER BY `small_bore`, `lumens`, `size`, `catheter_length` ${data}
IMG
PART NUMBER DESCRIPTION
${small_bore} ${type}
  ${part_number}  ${description} 
« Click a Product to Begin
LEAVE AS-IS CUSTOMIZE
Part Number:
Description:
Size:
Length:
Lumens:
Material:

Other Specs:
ADD TO SAMPLES REQUEST

ADD TO QUOTE REQUEST