Yogi Direct Special Offers

Sort By: Price Manufacturer Part #

select p.Product_Id,p.maincat,p.subcat,p.Product_Name,p.Product_Code,p.Product_MSRP,p.Product_Sale_Price,p.Product_Weight,p.Price_Call,p.Product_Stock,p.Product_LargeImage,m.Manufacturer_Name from products p,manufacturers m where p.subcat='174' and p.Product_Manufacturer=m.Manufacturer_Id AND p.Product_Status='Active' order by

Manufacturer/ Product Image Description / Part No. Your Price Buy Now