( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1002' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1004' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1005' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1006' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
( SELECT @r1:=@r1+1 SRNO, t2.position AS pp, t1.add_time as addedTime, t1.product_id,t1.category_id,t1.category_name,t1.category2_id,t1.category2_name,t1.product_name,t1.product_name,t1.product_sku,t1.url_key, t1.gemstone_name_id,t1.gemstone_name,t1.gemstone_name2_id,t1.gemstone_name2,t1.master_cut_id,t1.master_cut_name, t1.product_price as price, t1.discount_percentage as discount_percentage, t1.sort_price as sort_price,t1.product_stock, IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() and ( ip != '' and user_id = 0 and cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ) ), 0) AS available_stock, t1.product_stock AS available_stock FROM tbl_product AS t1 LEFT JOIN tbl_category AS t2 ON t1.category_id = t2.category_id , (SELECT @r1:=0) r1 WHERE t1.category_id = '1007' and t1.status = 'ACTIVE' and t1.product_stock > 0 AND IFNULL((t1.product_stock - (SELECT IFNULL(SUM(quantity), 0) FROM tbl_cart WHERE product_id = t1.product_id AND status= 'ACTIVE' AND erase_time > NOW() AND cart_session_id !='vcspcm80tnnc6dr5ajukorooq4' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Beautiful little 14k yellow gold princess cut reddish-pink Ruby studs at a terrific price.
Matthew Kennedy 26 Nov, 2024
0.45 Carat Blue Sapphire And Diamond Ring In 14k Rose Gold
Truly beautiful 14k rose gold bypass ring setting with 0.09 carats of sparkling natural diamonds. Such a lovely design. And the price was fantastic! You simply can't beat the customer service and prices at Best in gems.
Matthew Kennedy 26 Nov, 2024
Zambian Emerald Oval 5x3mm Matching Pair Approximately 0.44 Carat
Truly incredible pair of 5x3 mm Zambian emeralds. Outstanding color!
Matthew Kennedy 18 Nov, 2024
Emerald Cut 6x4mm Ring Semi Mount In 14k White Gold With White Diamonds (rg0809)
Very pretty 14k white gold ring setting with lovely-- and sparkly--- natural diamond accents. It's going to look great with my 6x4 mm emerald cut pink
sapphire. Thanks!
Matthew Kennedy 18 Nov, 2024
Round 5mm Ring Semi Mount In 14k Gold With White Diamond (rg0795)
Absolutely AMAZING 14k yellow gold 5mm halo ring setting with 0.12 carats of natural diamonds. The diamonds are very clean/clear--- they sparkle like crazy. This ring setting is gonna look fantastic once my jeweler sets it with the loose 0.45 carat round brilliant diamond i already own. My girlfriend is going to be over the moon!
Everyone at BIG were so friendly and helpful. They answered all my questions (and I tend to ask a ZILLION questions 😝). Couldn't be happier with the customer service and the ring setting. Thanks so much!
Matthew Kennedy 18 Nov, 2024
8x6mm Oval Findings In 14k Gold
Beautiful pair of 14k yellow gold 8×6mm oval earring settings. These have a nice solid feel--- NOT thin or cheap looking. Terrific price and lightning fast shipping, as always. Ajay and Shika are wonderful. Fantastic customer service!
Matthew Kennedy 14 Nov, 2024
3mm Round Findings In 14k Gold
Lovely little 14k rose gold earring settings at a great price!
Matthew Kennedy 04 Nov, 2024
20in Curb Chain In 14k White Gold
Beautiful 14k white gold curb chain at a fantastic price. Excellent customer service and very quick shipping, as always. Thanks!
Matthew Kennedy 04 Nov, 2024
Ethiopian Opal Cab Oval 5x3mm Approximately 0.93 Carat
Yes, we can do custom orders for any Semi- Precious stones.
We have our own Lapidary in India.
We can make any custom Semi -Mount in 14K, 18K and Platinum.
Message us for details.
02
Sizing details
+
Our Rings comes in size 6.5.
We can resize all our rings. If Resizing is not possible, we can make a new one in your size.
03
Gift wrapping and packaging
+
All our Rings, Earrings and Pendants comes in a Beautiful perfect box ideal for Gifting Purpose.
If you want to Include a Birthday or Anniversary card, Let us know.
We will be happy to do it.
About Bestingems
Best In Gems, Inc. features a collection of natural gemstones from around the world since March 1999. Our goal is not only to provide gemstones for sale, but also educate and update the buyer about the quality and characteristics of the gemstones. Buying from Best In Gems, Inc. is just not a transaction of gemstones; it is a commitment. Commitment of RELIABILITY, commitment of SERVICE and commitment of DEPENDABILITY.
We do not display or sell any type of artificial, synthetic or simulated gemstones. Our team of qualified workers consistently travel all over the world to find rare and exquisite gemstones. In order to provide the best possible value of money, we buy roughs and get it cut in our Jaipur, India factory, where more than 40 people consistently cut the gemstones round the clock. We not only replace our stones as quickly as we sell but keep on adding more and more stones in order to provide the large variety and options to our customers. We specialize in small custom orders. We at Best In Gems, Inc. do not care about the size of order, but give top priority to each and every request.
Get Instant Update On Discounts, Special Sales & New Arrivals
Email
614-742-7466
