moduler.title as brandname,
product_price.price as prod_price, product_price.offerprice as prod_offerprice,
products, moduler, product_price, product_stock
products.publish='y' and moduler.publish='y' and
products.brand_id=moduler.id and moduler.mod_name='product brands' and
products.id=product_stock.product_id and product_stock.instock > 0 and product_stock.instock <> 0 and
IF(product_price.offerprice>0, CAST(product_price.offerprice AS DECIMAL(10,2)), CAST(product_price.price AS DECIMAL(10,2))) between 1 AND 80000
and (products.brand_id in (398) or products.title like '%kazoo%')
You can ease that purchased product is 100% genuine
Your data is always protected
Free returns on eligible items so you can shop with ease
Cash on Delivery available
Ships with in 2-3 bussiness days
OutdoorGears is an UAE based company Established in 2019 and has presence in India, Saudi Arabia, Oman, and East Africa. We are specialized in Adventure, sports and travel products.We are excited to make your journey a true success. There are different types of people but not everyone dares to choose challenges & differences in the World. Do you think if you are one of them then stop thinking start and chasing?
24/7 Customer Support
OutdoorGears suppport team is hard working 24/7 for our customers.We give high priority to troubleshoot and sort out all the complaints and issue of ourcustomers. We will provide entire support till your face smiles.