user warning: 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 ' 0*2 - d.field_carat_value, d.field_carat_value) ASC,
IF(FIELD(d.field_color_' at line 21
query: SELECT d.nid FROM `content_type_diamonds` d
LEFT JOIN uc_product_stock s ON s.nid = d.nid
WHERE
d.nid != 2455692
AND
s.active = 1 AND s.stock > 0
AND
d.field_cut_value = ''
AND
d.field_report_value = ''
AND
d.field_carat_value BETWEEN 0 AND 0
AND
d.field_color_value IN ('')
AND
d.field_clarity_value IN ('')
AND
d.field_make_value IN ('')
ORDER BY
IF(d.field_carat_value < , 0*2 - d.field_carat_value, d.field_carat_value) ASC,
IF(FIELD(d.field_color_value, '') < FIELD('', ''), 1*2 - FIELD(d.field_color_value, ''), FIELD(d.field_color_value, '')) ASC,
IF(FIELD(d.field_clarity_value, '') < FIELD('', ''), 1*2 - FIELD(d.field_clarity_value, ''), FIELD(d.field_clarity_value, '')) ASC,
IF(FIELD(d.field_make_value, '') < FIELD('', ''), 1*2 - FIELD(d.field_make_value, ''), FIELD(d.field_make_value, '')) ASC
LIMIT 0, 20
in /var/www/htdocs/production/related-diamonds/includes/related-diamonds.functions.php on line 247.
Brilliance >
Diamonds >
2.50 Carat Round Loose Diamond, H, SI1, Super Ideal Cut, EGL Certified
Loose Diamond
Carat Cut Diamond
This color, clarity, and make (cut) certified loose diamond comes with a report from the . View Certificate
Stock NumberD12455692
Estimated Shipping Date: Thursday, May 23
Retail Price: $19,002.00
Price: $12,668.00
Print:
Share:
Width:
8.67mm
Length:
8.75mm
Length to Width:
to 1
Table%: %
Culet:
Depth%:
%
Depth:
5.31mm
Girdle:
Note: This is a sample diamond video.
Stock Number: D12455692
Shape:
Carat Weight: ct
Color:
Clarity:
Make (Cut):
Report:
Price: $12,668.00
Bank Wire Price:
Sample Diamond Report
Certificate Request
Stock NumberD12455692
To view this certificate for this diamond, simply click below to submit a request. A certificate will be sent to you within two business days.
Other Sample Diamond Reports
This diamond is expected to be delivered loose on Thursday, May 23 or set in a ring or jewelry on Monday, May 27.
Secure Shipping
Brilliance offers complementary express shipping on every order. Each shipment is securely packaged, fully insured, and shipped using only the most reputable and reliable courier services.
Shipments are sent via FedEx®, UPS®, or USPS®. We also offer several convenient specialty services, including expedited shipping, shipment of gifts to an alternate address, and holding a package for pick-up at a FedEx® location.
Packaging & Gift Orders
Each product is thoughtfully packaged in our exclusive Brilliance presentation box and includes:
Certified loose diamonds, engagement rings, and diamond jewelry products are safley enclosed in a dramatic black lacquered box.
At Brilliance, we want to be your lifelong jeweler. To ensure that our relationship continues long after your first purchase, we offer an array of unique services with every order.
Free Express Shipping
Each Brilliance order is eligible for free express shipping - just one of the ways we strive to provide our customers with optimum service at the best possible value.
30 Day Returns
At Brilliance, we stand behind each of our diamonds, engagement rings, and fine jewelry products with a 30-Day Money-Back Guarantee.
Conflict Free Diamonds
At Brilliance, we work only with the industry's most reputable and regulated suppliers of high-quality diamonds, adhering to a strict zero-tolerance policy against conflict diamonds.
Guaranteed Lowest Prices
Brilliance offers the highest quality products at the lowest prices guaranteed. If you happen to find an item of identical size and quality at a lower price, we will beat it.
Signature Packaging & Gift Options
All jewelry is securely and elegantly packaged in our signature black boxes. We also offer additional options including a gift message and gift receipt.
Gemological Appraisal
Our expert gemologists will perform an examination of your jewelry to determine an accurate market value. You will receive a certified document stating the appraisal amount.
Lifetime Upgrades & Warranty
We subject each of our products to rigorous standards of quality. Each piece is manufactured in our facilities using only the most premium materials and backed by a Lifetime Warranty.
Brilliance Care & Maintenance
When you purchase from Brilliance, you'll be eligible for complimentary cleaning and maintenance services for the life of your engagement ring or fine jewelry.
Secure Shopping
Online security is a top priority at Brilliance. We take measures to ensure that all transactions occur in an encrypted environment, and that your information is kept completely confidential.
Expert Guidance & Advice
At Brilliance, we're more than just a diamond and jewelry retailer- we're your full-service shopping consultant. Our experts are always available to guide you through the jewelry shopping process with courtesy, clarity, and knowledge.
Newsletters & Special Offers
