Availability Filter:
 Show Ready to Ship

FeedBack
Price  Processing time: 1503286105.9977 secondsSELECT "srh_rslt", grp, comgrp, comcat, comsub, mfg, sale_price, mfg_mod_part,mfg_part, mfg, tb_id, vend_part,descr, qty, img_path FROM products WHERE `condition` like 'OPEN BOX' and mfg = "hpi ops supplies" and sale_price > 0 and display = 1 order by qty DESC