Show Schedule | Testimonials | bestingems@gmail.comEmail | Phone614-742-7466| Login| Signup
FREE SHIPPING (NO MINIMUM)
Cart   Icon
Collections


( 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ) ), 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Gemstones
View All
( 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ) ), 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Drops & Beads
View All
( 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ) ), 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Jewelry
View All
( 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ) ), 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Semi-Mounts
View All
( 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ) ), 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 !='us8j7lhg4nffmnhqckppr86gu0' ) ), 0) > 0 ORDER BY t1.add_time DESC limit 30 )
Findings
View All
Gemstone Jewelry

testimonial


Happy Clients
Why Choose Us?

Free Delivery
Free Shipping
(U.S.A Only)
Easy Returns
Easy Returns
Happy Customers
2.5k Happy Customers
Secured Payments
Secured Payment
Huge Variety
Huge Variety
Transparent Pricing
Transparent Pricing
Free Delivery
Free Shipping
(U.S.A Only)
Easy Returns
Easy Returns
Happy Customers
2.5k Happy Customers
Secured Payments
Secured Payment
Huge Variety
Huge Variety
Transparent Pricing
Transparent Pricing
Free Delivery Easy Returns
Free Shipping
Easy Returns
Happy Customers Secure Payment
Happy Customers
Secured Payment
Huge Variety Transparent Pricing
Huge Variety
Transparent Pricing
Birthstone of the Month

Frequently Asked Questions

01
Do You do Custom Orders on Gemstones and Jewelry?
+
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