212.869.8000
Sign In or Register


SINCE 1981
2023 AGTA SPECTRUM & CUTTING EDGE AWARD WINNER! CLICK HERE FOR DETAILS
Sort by Single/Pair
  Single Stones
  Matched Pairs
  clear single/pairs
Sort by Type
  Emerald
   Ruby
  Sapphire
  clear stone type
Sort by Color
  Imperial Red
  Intense Red
  Pigeon Blood
  Pinkish Red
  Purplish-Red
  Red
  Vivid Red
  clear color
Sort by Shape
  Baguette
  C-Rd
  Cabochon Cushion
  Cabochon Oval
  Cushion
  Diamond Cut
  Emerald Cut
  Emerald-Cut Square
  Half Moon
  Heart Shape
  Kite Shape
  Marquise
  Mixed
  Oval
  Princess Cut
  Pear Shape
  Round
  Square
  Star
  Tappered Baguette
  Trillion
  Trapazoid
  clear shape
Sort by Enhancement
  Heated
  Heated (Residues Insignificant)
  Heated (Minor Residues Are Present)
  No Heat
  clear enhancement
Sort by Origin
  Burma
  Sri Lanka
  Madagascar
  Mozambique
  Tajikistan
  Tanzania
  Thailand
  clear origin
Sort by Lab
  AGL
  AIGS
  BELL
  CDC
  GIT
  GRL
   GRS
  GUBL
  ICA
  LAB
  clear lab
Sort by Carat Weight
  Up to 1.00ct
  1.00ct - 1.50ct
  1.50ct - 2.00ct
  2.00ct - 3.00ct
  3.00ct - 5.00ct
  5.00ct - 8.00ct
  8.00ct - 10.00ct
  10.00ct - 15.00ct
  15.00ct - 20.00ct
  20.00ct - 25.00ct
  25.00ct and up
  clear carat weight
Sort by Price Range
  $500 - $750
  $750 - $1,000
  $1,000 - $1,500
  $1,500 - $2,000
  $2,000 - $3,000
  $3,000 - $5,000
  $5,000 and up
  clear price range

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND stonelab = 'GRS' order by wt DESC,number DESC' at line 3
 
Resources:
  • Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debug Output Settings, and select the Robust Exception Information option.
  • Check the ColdFusion documentation to verify that you are using the correct syntax.
  • Search the Knowledge Base to find a solution to your problem.

Browser   claudebot
Remote Address   172.31.45.122
Referrer   http://saragem.com/?page=search&stype=Ruby&scolor=&sshape=&subcat=&enhancement=&origin=&sweight=0%257C1.00&prange=&lab=GRS
Date/Time   28-Mar-24 05:18 PM