BHD - Bahrain Dinar 
KWD - Kuwaiti Dinar 
OMR - Omani Rial 
QAR - Qatari Riyal 
AED - Emirati Dirham 
SAR - Saudi Riyal 
USD - United States Dollar Categories
Search:
Household Care
Oasis Pikchee Wonder
USD 8.80
Oasis Lively Green Mosquito Killer
USD 8.80
SELECT `n_products`.*, `stock_id`, `mrp`, `selling_price`, `quantity`, `off`.`sale_id` as `offer_id`, `off`.`sale_status` as `offer_status`, `off`.`discount_type` as `off_discount_type`, `off`.`discount_value` as `offer_discount`, `off`.`start_date` as `off_start_date`, `off`.`end_date` as `off_end_date` FROM `n_product_category` LEFT JOIN `n_products` ON `n_products`.`product_id` = `n_product_category`.`product_id` LEFT JOIN `n_stock_products` ON `n_stock_products`.`product_id` = `n_products`.`product_id` LEFT JOIN `n_flash_sale` as `off` ON `off`.`sale_id` = `n_products`.`offer_id` WHERE `n_product_category`.`category_id` = '163' AND `product_status` = 1 GROUP BY `n_products`.`product_id` ORDER BY `product_id` DESC LIMIT 24Array ( )
SELECT `n_products`.*, `stock_id`, `mrp`, `selling_price`, `quantity`, `off`.`sale_id` as `offer_id`, `off`.`sale_status` as `offer_status`, `off`.`discount_type` as `off_discount_type`, `off`.`discount_value` as `offer_discount`, `off`.`start_date` as `off_start_date`, `off`.`end_date` as `off_end_date`, `varient_name` FROM `n_product_subcategory` LEFT JOIN `n_products` ON `n_products`.`product_id` = `n_product_subcategory`.`product_id` LEFT JOIN `n_stock_products` ON `n_stock_products`.`product_id` = `n_products`.`product_id` LEFT JOIN `n_product_varients_name` ON `n_product_varients_name`.`product_varient_id` = `n_stock_products`.`varient_id` AND `n_product_varients_name`.`product_id` = `n_stock_products`.`product_id` LEFT JOIN `n_flash_sale` as `off` ON `off`.`sale_id` = `n_products`.`offer_id` WHERE `n_product_subcategory`.`subcategory_id` = '163' AND `product_status` = 1 GROUP BY `n_products`.`product_id` ORDER BY `product_id` DESC LIMIT 24Array ( [0] => Array ( [product_id] => 997 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Soffell Mosquito Repellent Fresh Fragrance 80ml (Green) [brand_id] => 302 [product_description] => Soffell Mosquito Repellent Fresh Fragrance (Green) offers effective mosquito protection with a crisp, refreshing scent. Its light, non-sticky formula ensures comfort and long-lasting defense for everyday outdoor activities. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8992772065207 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => صوفيل طارد البعوض برائحة منعشة 80 مل (أخضر) [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => home-care/soffell-mosquito-repellent-fresh-fragrance-80ml-green [url_name] => soffell-mosquito-repellent-fresh-fragrance-80ml-green [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => 10 [updated_on] => [updated_by] => 0 [created_on] => 1750683917 [stock_id] => 997 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [1] => Array ( [product_id] => 754 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Oasis Pink Blossom Mosquito Repellent Gel [brand_id] => 0 [product_description] =>
Oasis Pink Blossom Mosquito Repellent Gel is a lightweight, fragrant gel that protects the skin against mosquitoes while leaving a soft floral scent. Ideal for daily outdoor use.
[product_tags] => [refundable] => 1 [skucode] => [barcode] => 8850273180112 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => جل طارد للبعوض برائحة زهرة بينك من أواسيس [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => household-care/-oasis-pink-blossom-mosquito-repellent-gel [url_name] => -oasis-pink-blossom-mosquito-repellent-gel [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => 10 [updated_on] => 1751872907 [updated_by] => 1 [created_on] => 1750683907 [stock_id] => 754 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [2] => Array ( [product_id] => 753 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Oasis Pikchee Wonder [brand_id] => 320 [product_description] => Oasis Pikchee Wonder is a traditional herbal ointment designed to relieve muscle aches, joint pain, and minor skin irritations. It provides a soothing effect and supports natural healing. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8850273180617 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => أواسيس بيكتشي وندر [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => household-care/oasis-pikchee-wonder [url_name] => oasis-pikchee-wonder [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => 10 [updated_on] => [updated_by] => 0 [created_on] => 1750683907 [stock_id] => 753 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [3] => Array ( [product_id] => 743 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => Oasis Lively Green Mosquito Killer [brand_id] => 320 [product_description] => Oasis Lively Green Mosquito Killer effectively repels and kills mosquitoes, providing a safer and more comfortable environment. Features a refreshing green scent for added freshness. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8850273180518 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => أواسيز مبيد البعوض لايفلي جرين [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => household-care/oasis-lively-green-mosquito-killer [url_name] => oasis-lively-green-mosquito-killer [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => 10 [updated_on] => [updated_by] => 0 [created_on] => 1750683907 [stock_id] => 743 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [4] => Array ( [product_id] => 385 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => SOFFELL MOSQUITO FRESH FRAGNACE 80ML ORANGE [brand_id] => 0 [product_description] =>Soffell Mosquito Repellent Fresh Fragrance (Orange) protects against mosquito bites while offering a fresh, citrusy scent. Its non-greasy formula is comfortable for daily use, keeping the skin protected and pleasantly scented.
[product_tags] => [refundable] => 1 [skucode] => [barcode] => 8992772065184 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => صوفيل طارد البعوض برائحة منعشة 80 مل (برتقالي) [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => home-care/soffell-mosquito-fresh-fragnace-80ml-orange [url_name] => soffell-mosquito-fresh-fragnace-80ml-orange [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => [updated_on] => 1751820247 [updated_by] => 1 [created_on] => 1750683895 [stock_id] => 385 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) [5] => Array ( [product_id] => 384 [category_id] => 0 [subcategory_id] => 0 [product_unit] => [product_name] => SOFFELL MOSQUITO FRESH FRAGNACE 80ML PINK [brand_id] => 302 [product_description] => Soffell Mosquito Repellent Fresh Fragrance offers effective protection against mosquito bites with a pleasant, light floral scent. It is easy to apply, non-greasy, and suitable for daily use, providing long-lasting protection while keeping the skin feeling fresh. [product_tags] => 1 [refundable] => 1 [skucode] => [barcode] => 8992772065177 [tax_type] => 0 [tax_percent] => 0 [product_status] => 1 [features] => [meta_title] => [meta_description] => [product_name_arabic] => صوفيل طارد البعوض برائحة منعشة 80 مل (وردي) [product_description_arabic] => [how_to_use] => [how_to_use_arabic] => [meta_keywords] => [meta_image] => [url_slug] => home-care/soffell-mosquito-fresh-fragnace-80ml-pink [url_name] => soffell-mosquito-fresh-fragnace-80ml-pink [colour] => 0 [created_by] => 1 [featured_status] => 0 [todays_deal] => 0 [offer_id] => [best_seller] => 0 [on_seller] => 0 [top_products] => 0 [shipping_time] => 0 [discount_type] => 0 [vat] => [updated_on] => [updated_by] => 0 [created_on] => 1750683895 [stock_id] => 384 [mrp] => 0.000 [selling_price] => 3.300 [quantity] => 100 [offer_status] => [off_discount_type] => [offer_discount] => [off_start_date] => [off_end_date] => [varient_name] => ) )