Our Shop


Filter Items


Filter By Price

Sort
  • Low to High Price
  • High to Low Price
  • By Date

Fixed Price
  • All
  • 0 LBP - 300,000 LBP
  • 300,000 LBP - 500,000 LBP
  • 500,000 LBP - 750,000 LBP
  • 750,000 LBP - 1,000,000 LBP
  • 1,000,000 LBP - 2,000,000 LBP
  • 2,000,000 LBP +

Custom Price

Brands


Products

Showing 1–28 of 28 results

select p.ID, p.Title,p.out_of_stock,p.is_new,p.is_best_seller, p.code, p.image_path, p.price, p.price_2, b.rate, b.title as brand_title, b.ID as brand_id, ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-08-04')* b.rate) as offer_price,((p.price_2)*b.rate ) as lbp_price, ROUND(IF(((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-08-04') * b.rate) is null, ((p.price_2)*b.rate ), ((select o.price from offer o where o.product_id=p.ID and o.status=1 and o.end_date>='2021-08-04') * b.rate))) as final_price from products p, brands b where b.ID=p.brands_id and p.status=1 and p.ID IN (select offer.product_id from offer where offer.status=1 and offer.end_date >='2021-08-04' ) order by p.date DESC LIMIT 0, 16
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
NEW
Image
Image
Image
Image
Image