Bad query: ###SELECT J.*,C.colname,B.bname,G.*
FROM JeffStore J,Brands B,GraphicsItem G,Collections C
WHERE
J.attr_titanium=1 AND
J.bid!=28 AND J.bid!=357 AND
J.isactive_wwPrice=1 AND
G.id=J.id AND
J.colid=C.colid AND
J.isactive=1 AND
J.retailPrice>0 AND
J.bid=B.bid AND
J.bid=104
ORDER BY J.quantity DESC, J.age_since_sold### Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/watchwear/cubecart/includes/content/viewEntireBrand.inc.php on line 363 Titanium Rip Curl Watches
For a limited time only, GET FREE OVERNIGHT SHIPPING
on Select RIP CURL Watches during checkout. (Continental U.S. only)
Buy Rip Curl Watches
Rip Curl originally started out as a legendary surf company that made the best in clothes and boards. But in recent years, Rip Curl's time piece division has unveiled some stunning watches that range from the practical sports watch to the decadent dress watch and everything in between. The one thing that remains the same from sports watch to dress watch is the innovative design and original use of color that is apparent in all Rip Curl models. From the beautiful blue of the Royale to the bronze of the Vegas, Rip Curl is a watch company you can trust.
Pink [2]
Aqua [20]
Red [12]
Orange [4]
Yellow [6]
Grey [101]
Blue [20]
Khaki [19]
Charcoalgrey [101]