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

ARDEN MAKEUP
BASSAM FATTOUH
BENEFIT
CHANEL MAKEUP
CLARINS MAKEUP
CLINIQUE MAKEUP
DIOR MAKEUP
ESTEE LAUDER MAKEUP
GIVENCHY MAKEUP
LANCOME MAKEUP
MAKEUP FOR EVER
PUPA
YSL MAKEUP

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.brands_id IN (112) order by p.date DESC LIMIT 0, 16
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image
Image