Short Term Polyurethane 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`, '2' AS `lumens`, IF(`description` LIKE '%Curved%', 'Curved', '') AS `curved` FROM `product` WHERE `category` LIKE '%Short Term Polyurethane%Catheters' AND `part_number` NOT LIKE 'fake%' ORDER BY FIELD(`thumbnail_photo`, 'st_polyurethane_14f_double_lumen.jpg', 'st_polyurethane_14f_double_lumen_curved.jpg', 'st_polyurethane_12f_double_lumen.jpg', 'st_polyurethane_9f_double_lumen.jpg', 'st_polyurethane_triple_lumen.jpg'), `size` DESC ${data}
IMG
PART NUMBER DESCRIPTION
${curved} ${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