SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (46) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 2623) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (46) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 2623 ) ORDER BY position ASC LIMIT 1

Item #: PL230

ANODIZED TIT CUT-OUT SPINNING STAR PLUGS

YOU'LL RECEIVE A 12 PIECE PACK OF BLACK ANODIZED TITANIUM CUT-OUT SPINNING STAR PLUGS IN AN ASSORTMENT OF GAUGES INCLUDING 0G,00G,1/2",9/16",5/8",AND 3/4"


1 PACK