CBS Dichroic Coating Mixture Reptilian Pattern on Clear Fipple Glass COE96

SKU Size Price Quantity
173056 Size 2"x4" $9.96 

173055 Size 4"x4" $16.96 

173054 Size Quarter Sheet $54.96 

 Add to Wishlist

 Add to Wishlist
select p.products_id, p.manufacturers_id, p.products_image, p.products_price, pd.products_name, pd.products_blurb, pd.products_grp_permission, pd.video_types, pd.video_embeded_code, p.products_date_available, pd.min_buy_qty, pd.purchase_in, pd.first_purchase_price, pd.min_case_pack, if(pd.products_quantity > 0, pd.products_quantity, p.products_quantity) AS products_quantity, p.products_model, p.products_weight from orders_products opa, orders_products opb, orders o, products p, products_description pd where (p.products_id=pd.products_id and pd.web_id='1' AND pd.language_id=1 AND pd.enable_in_site=1) AND opa.products_id = '173052' and opa.orders_id = opb.orders_id and opb.products_id != '173052' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' and p.passover_only != 1 and p.products_carrot != 1 and p.products_id != 168269 group by p.products_id order by o.date_purchased desc limit 6

Do you love saving Money? We love helping you.
Sign up for our newsletter to find out about our weekly specials.
We will send you fusing tips and useful industry information too.