Warning: fread(): Length parameter must be greater than 0 in /hostdata/public_html/sites/hashposh_com/store/system/library/cache/file.php on line 32Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '101' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '102' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '104' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '106' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '105' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '103' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '107' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '108' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name) in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/catalog/model/catalog/category.php on line 12Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_controller_journal2_menu.php on line 792Warning: fread(): Length parameter must be greater than 0 in /hostdata/public_html/sites/hashposh_com/store/system/library/cache/file.php on line 32Warning: fread(): Length parameter must be greater than 0 in /hostdata/public_html/sites/hashposh_com/store/system/library/cache/file.php on line 32Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '10' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '11' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '12' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '13' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '14' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: mysqli::query(): (HY000/1030): Got error 28 from storage engine in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 19Notice: Error: Got error 28 from storage engine
Error No: 1030
SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '476' AND a.attribute_group_id = '15' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name in /hostdata/public_html/sites/hashposh_com/store/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: Invalid argument supplied for foreach() in /hostdata/public_html/sites/hashposh_com/store/vqmod/vqcache/vq2-catalog_model_catalog_product.php on line 317Warning: fread(): Length parameter must be greater than 0 in /hostdata/public_html/sites/hashposh_com/store/system/library/cache/file.php on line 32Warning: fread(): Length parameter must be greater than 0 in /hostdata/public_html/sites/hashposh_com/store/system/library/cache/file.php on line 32 LG G3 32GB Shine Gold LTE Price in Dubai UAE - Buy LG G3 32GB Shine Gold LTE Online in Dubai UAE Sharjah Abudhabi Ajman | Hashposh.com

LG G3 32GB Shine Gold LTE

LG G3 32GB Shine Gold LTE

Features:

  • 5.5-inch Quad HD IPS touchscreen display with 2560 X 1440 resolution offers vibrant colours and ultra-sharp images
  • Bezel-free, edge-to-edge screen offers a more immersive viewing experience
  • 2.5GHz quad core processor for snappy performance when browsing the internet and running apps
  • 3GB of internal memory, expandable up to 128GB with microSD (sold separately), for storing your contacts as well as various multimedia files with the optional external memory
  • 13MP OIS+ (optical image stabilization) camera with flash and laser auto focus helps reduce blur and shaking so you can quickly and easily capture high-quality photos
  • Lightweight metallic design for portability and easy one-hand control
  • WiFi 802.11a/b/g/n/ac (dual-band) and Bluetooth 4.0 + LTE capability makes it easy to connect to the internet wherever there's a WiFi hotspot and bridge Bluetooth-enabled devices like wireless headphones or another smartphone
  • 3,000mAh lithium ion battery lasts up to 21 hours of talk time and up to 600 hours on standby
  • Runs on Android 4.4 (KitKat) operating system for a simple and easy interface with intuitive controls, Google Voice capabilities, smarter keyboard and access to a huge variety of apps on Google Play
DESIGN
DISPLAY
CAMERA
HARDWARE
BATTERY
MULTIMEDIA
TECHNOLOGY
CONNECTIVITY
OTHER FEATURES

Write a review

Please login or register to review
  • Brand: LG
  • Product Code: D855
  • Availability: Out Of Stock
  • AED 1,029

Free shipping on orders above 100$

100% Genuine Products

Cash On Delivery available across Dubai & Sharjah city limits

1 Year Warranty

Loading...
Loading...
Loading...
Loading...

Fatal error: Call to a member function get() on null in /hostdata/public_html/sites/hashposh_com/store/index.php on line 104