In this section you will find all the great bargains.  We offer used products, obsoleted parts, over stock items, traded in and other special deals. These items are sold on a first come basis and carry no warranty.  Most of these are good for getting parts for your own stuff. Some of the hardware may be just fine but we have not tested them. We put these products here in order to liquidate them and make more room in our warehouse.  Feel free to make a reasonable offer.

select DISTINCTROW top 20 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 1493 and p.hide = 0 and (p.customermatch is null or p.customermatch = '') and (p.loggedin = false or p.loggedin is null) and (c.customermatch is null or c.customermatch = '') and (c.loggedin = false or c.loggedin is null) AND (higherCatalogId is null) order by p.ccode