select ProductID,ProductName,ImagePath,Designer,SalePrice,Price, GRoupID,PreOrder,0 as LC,(select top 1 TypeID from mss_Types where TypeID in (select typeid from mss_types where [sign]='DESIGNERS') and TypeID in (select TypeID from mss_Index where ProductID=cache_products.ProductID)) AS DesignerID from cache_Products where (publishdate < getdate() or publishdate is null) and 1=1 and exists (select top 1 1 from mss_index where typeid=2 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=26 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=272 and productid=cache_Products.productid) order by PublishDate desc
-
Encrusted Cortina Ring
$90.00
-
Victory Chain Earrings
$95.00
-
Victory Cab Bracelet
$180.00
-
Double-Cortina Bracelet
$95.00
-
Hippolyta Textured Bangle
$60.00
-
Hippolyta Stone Bangle
$110.00
-
-
Encrusted Circle Choker
$230.00
Giles & Brother News:
5
-
Tue, February 7, 2012
Before moving to their current location in New York's Fashion District, Philip and Courtney Crangi, the siblings behind Giles & Brother , worked from a tiny space in the Meatpacking District, making the most of the McDonald's dollar menu. ...
MORE
-
Mon, January 23, 2012
Philip Crangi and his sister Courtney were born and raised in Palm Beach, a place where priceless estate jewelry and miles of sand combine, so it's no wonder they grew up with fantasies of finding buried treasure. ...
MORE
-
Tue, August 3, 2010
Philip Crangi and his sister Courtney are the jeweling duo behind Giles & Brother , a diffusion line of African-influenced, antique-driven, yet distinctly modern accessories. ...
MORE
Tue, February 7, 2012Before moving to their current location in New York's Fashion District, Philip and Courtney Crangi, the siblings behind Giles & Brother , worked from a tiny space in the Meatpacking District, making the most of the McDonald's dollar menu. ... MORE
Mon, January 23, 2012Philip Crangi and his sister Courtney were born and raised in Palm Beach, a place where priceless estate jewelry and miles of sand combine, so it's no wonder they grew up with fantasies of finding buried treasure. ... MORE
Tue, August 3, 2010Philip Crangi and his sister Courtney are the jeweling duo behind Giles & Brother , a diffusion line of African-influenced, antique-driven, yet distinctly modern accessories. ... MORE