UAE
Oman
KSA
QATAR
BAHRAIN
KUWAIT
INTERNATIONAL
CALL: 052 610 3509
Login / Register
|
Emirati Dirhams
US Dollar
Kuwaiti Dinar
Omani Riyal
Saudi Riyal
Qatari Riyal
Bahrain Dinar
0
0
Smart Fitness
Sports and Fitness Watches
Smart Scales
Glucose Monitors
Blood Pressure Monitors
Oximeters
Smart Pain Reducers
Proteins and Supplements
Proteins
Carbohydrates
Mass Gainers
Whey Proteins
Sleep Enhancers
Protein Bars
Energy Bars
Creatine
Pre Workout
Post-Workout
Amino Acids & BCAA
Weight Gainer
Vitamins Health & Herbs
Protein Foods
Libido or Stamina Enhancers
Muscle Gainer
Weight Loss
Vegan and Organic Products
Support Nutrition & Workout Support
Health Drinks
Nutrition
Herbal Tea
Diet & Weight Management
Kids Nutrition
Women Nutrition
Gym Equipments
Treadmills
Spinning Bikes
Magnetic Bikes
Elliptical Bikes
Recumbent and Upright Bikes
Home Workouts
Benches
Bars and Plates
Dumbbells and Weights
GYM Accessories
Yoga Accessories
Gym Machine
Slimming Belts
Portable Sauna
Rowing Machines
Home and Lifestyle
Air Purifiers
Air Humidifiers
Fans and Air Filters
Home Massagers
Aroma Diffusers
Health Check
Thermometers
Blood Pressure Monitors
Glucose Monitors
Stimulators
Nebulizer
Beauty and Wellness
Grooming Products For Men
Grooming Products For Women
Fragrance Oils
Massage Oils
Bath Essentials
Face Shop
Skin Care
Dental Care
Body Creams
Lip Care
Hand and Foot Care
Hair Care
Combo Packs
Essential Oils
Personal Care
Pet Care
Aromatherapy
Sports and Outdoor
Diving Products
GPS - Global Positioning Systems
Athletic and Outdoor
Sports Headphones
Sports Speakers
Travel & Camping
Binoculars
Sports Camera
Water Sports & Fishing
Sport Accessories
Cycling Products
Solar Chargers and Lights
Hunting and Tactical
Golf Accessories
Indoor Games
Diving Products - Inflators
Pet Nutrition
Adult Cat Food
Kittens Food
Adult Dog Food
Puppies or Small Dog Food
Brands
0
Home
»
Smart Fitness
»
Fitness Trackers
Our Brands
FitBit
Garmin
Bewell
CardioCycle
GYMWATCH
Huawei
iHealth
Mio Fitness
Omron
Polar
Xiaomi
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 331
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Elegant Edition White 42mm
AED 999.00
AED 749.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Elegant Black 42mm
AED 999.00
AED 749.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Sport Black 46mm
AED 799.00
AED 499.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Classic Brown 46mm
AED 799.00
AED 599.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Active Green 46mm
AED 799.00
AED 599.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Watch GT Active Orange 46mm
AED 799.00
AED 599.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Band 3 Pro Built in GPS and Touch Screen Black
AED 299.00
AED 269.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B5 Smart Band and Bluetooth Headset Gold
AED 599.00
AED 499.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B5 Smart Band and Bluetooth Headset Black
AED 599.00
AED 499.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B3 Lite Smart Band and Bluetooth Headset Black
AED 389.00
AED 319.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B3 Lite Smart Band and Bluetooth Headset Blue
AED 389.00
AED 319.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Band 2 Pro Fitness Tracker Black
AED 349.00
AED 299.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Talkband B3 Smartband with Bluetooth Headset Titanium
AED 899.00
AED 799.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Talkband B3 Smartband with Bluetooth Headset Beige
AED 799.00
AED 639.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Talkband B3 Smartband with Bluetooth Headset Brown
AED 799.00
AED 639.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Talkband B3 Smartband with Bluetooth Headset White
AED 799.00
AED 639.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Talkband B3 Smartband with Bluetooth Headset Black
AED 799.00
AED 639.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Fit Fitness Watch Orange
AED 589.00
AED 499.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Fit Fitness Watch Black
AED 589.00
AED 499.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei Color Band A1 Black
AED 299.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B2 Rose Gold / Brown
AED 699.00
AED 449.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B2 Black
AED 699.00
AED 449.00
Out Of Stock
select * from nproducts where publish='y' and id in (0,588,733,734,735,738,739,802,897,898,987,1042,1043,1044,1045,1046,1047,1048,1104,1105,1328,1502,1503,1525,1526,2372,1959,1960,2173,2174,2175,2176,2177,2371,2485,2486,2487,2534,2550,2582,2620,2622,2623,2626,2627,2628,2629,2633,2655,2682,2683,2684,2685,2686,2687,2688,2689,2690,2707,2714,2733,2734,2735,2746,2747,2748,2749,4459,4128,4129,4241,4242,4243,4244,4245,4286,4290,4287,4294,4295,4300,4301,4302,4331,4332,4391,4393,4394,4396,4397,4399,4400,4424,4444,4454,4455,4456,4468,4481,4482,4507,4508,4512,4513,4514,4515,4516,4599,4828,5028,5029,5030,5031,5032,5033,8653) and brand_id=24 order by nproducts.id desc LIMIT 0, 33
Huawei TalkBand B2 White
AED 699.00
AED 449.00
Out Of Stock
