(850) 893-4171

Turquoise

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='64' INNER JOIN `magento_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 ORDER BY `cat_index`.`position` DESC LIMIT 15

Items 1 to 15 of 29 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2

Items 1 to 15 of 29 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2
Categories
Shop By

Shopping Options

Price
  1. $0.00 - $999.99 (27)
  2. $1,000.00 - $1,999.99 (1)
  3. $2,000.00 and above (1)
Gemstones
  1. Diamond (2)
  2. Pearl (12)
  3. Topaz (16)
  4. Turquoise (28)
  5. Other Gemstones (4)
Availability
  1. In Stock (7)
  2. Out of Stock (Available for Reorder) (21)
FashionColor
  1. Green (4)
  2. Blue (27)
  3. White (6)
  4. Silver (2)
Metal Type
  1. Yellow Gold (4)
  2. Silver (26)
  3. Gold Vermeil (18)
Jewelry Type
  1. Rings (3)
  2. Earrings (10)
  3. Necklaces (10)
  4. Bracelets (5)
About Gem Collection

We are truly passionate about two things - Beautiful Jewelry and our Customers! We search the world to bring you beautiful Diamonds, Engagement Rings, Wedding Rings, Estate, Colored Stone, Fashion, and Designer Jewelry. Our Jewelry experts are always happy to assist you. We want you to be delighted with your beautiful Jewelry purchase!

Read More
Services
Free Shipping on Most Items
Easy Returns
Most Major Credit Cards Accepted
Free Gift Wrapping
Free Ring Sizing on Most Rings
Call for Lay-A-Way Options
Company Info

The Gem Collection
3501 Thomasville Rd.
Tallahassee, FL 32309

(850) 893-4171: Local
(877) 727-3595: Toll-Free

Hours of Operation:
Tuesday – Saturday:
10am-6pm

Directions to our Store

american gem soceity
ijo jeweler

Copyright © Gem Collection. All rights reserved.
Powered by GEMFIND

To top