connect(); echo ""; echo ""; echo ""; echo $name; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $qStr = "SELECT distinct(ProductID), ProductType, RetailPrice, WebComments, LinkType, LinkURI, ImageFlag, ImageHeight, ImageWidth, SoldFlag, NewCreationFlag, NewCreationDate, DateCreated FROM products "; $qStr = $qStr . " WHERE ProductType = 'Estate Jewelry' AND SoldFlag = 0 " ; $qStr = $qStr . " Order by DateCreated DESC "; // LIMIT 25 $objDB->querystr = $qStr; // echo $objDB->querystr; $rows = $objDB->select(); foreach ($rows as $row) { echo ""; echo ""; echo ""; if ($row["ImageFlag"]) { echo ""; } echo ""; } else { echo ""; } echo ""; echo ""; echo ""; } echo "
".$name."
Product NumberDescriptionClickable ImageRetail Price
"; if ($row["ImageFlag"]) { echo ""; } echo $row["ProductID"]; echo "
"; echo ""; echo $row["WebComments"]; echo "

"; echo "Contact us to order or for more information."; echo "

"; echo ""; if ($row["LinkType"]!="") { echo $row["LinkType"]; } else { // echo " "; } echo ""; echo ""; if ($row["ImageFlag"]) { $height = $row["ImageHeight"]+185; $width = $row["ImageWidth"]+33; $producttype = strtolower($row["ProductType"]); echo ""; $src = "http://www.raru.com/products/images/".$producttype."/".$row["ProductID"]."TN.jpg"; echo "

"; echo ""; echo ""; echo ""; echo "
Camera Shy
"; $price = $row["RetailPrice"]; if (is_numeric($price)) { echo "$".number_format($price); } else { echo "$".number_format("call for price"); } echo "
"; $objDB->close(); } catch (Exception $ex) { echo "caught an exception."; echo $ex->getMessage(); exit(1); } } ?> deSigent International's Estate Jewelry

Hours
Monday - Friday 8AM-5PM
Saturday 9AM-2PM EST
Closed Sunday



Estate Jewelry Sale

Currently Updating this page 11/6/2017