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=1 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=23 and productid=cache_Products.productid) and exists (select top 1 1 from mss_index where typeid=1379 and productid=cache_Products.productid) order by PublishDate desc

JIMMY'Z : Bottoms

PREVIOUS NEXT : 1~5 OF 5 ITEMS

JIMMY''Z News:

5
  • Fri, June 14, 2013
    No other word awakens the senses quite like the word sale , but the combination of the words  sample and sale  can cause heart palpitations! The Opening Ceremony sample sale opens today! We dropped by the space (located just under the ... MORE

  • Wed, June 12, 2013
    We're ringing in Father's Day by celebrating the dashing daddys to our mega Movie Moms . We've brainstormed the best fathers on film from Forrest ( Forrest Gump ), Furious ( Boyz n the Hood ), and Finch ( To Kill a Mockingbird ) to ... MORE

  • Mon, March 11, 2013
    Only after dropping out of school at age 15 and exploring the New York nightclub scene, did David LaChapelle enroll in a North Carolinian arts school and discover his passion for photography. ... MORE

  • Fri, February 1, 2013
    Last weekend I took a spiritual walkabout around the island of Barbados. I spent four days hiking most of the island's perimeter, sleeping on the beach, and eating snow cones and fresh marlin. ... MORE

  • Tue, November 27, 2012
    Mokoli'i is a small island off the east coast of Kualoa Point of Oahu, Hawaii. Over 10 years ago, I swam out to this island so it seemed only appropriate that I do it again when visiting last month. ... MORE

  • Tue, October 16, 2012
    Make It Snappy is a photo series showcasing quick snaps from OC & friends Who:  Legendary skateboarder Steven Caballero, me, and pro-skateboarder Daniel Cuervo (both wearing  Jimmy'Z )! Where: Outside of   OC at Ace Hotel ... MORE
  • Tue, September 18, 2012
    We admire anyone who has a look, and whose approach to fashion is as obsessive as ours. In this new column we ask OC friends and family to let us rifle through their collections and celebrate their hoarding situations. ... MORE

  • Tue, June 19, 2012
    On a not-so-sunny spring weekend, photographer Kevin Amato and I headed to the Jersey Shore to appreciate the seaside during the final days of the off-season. ... MORE

  • Wed, June 6, 2012
    To call Warriors of Radness founder Rick Klotz an over-sharer is a major understatement. To be honest, he has no filter. And after spending two hours touring his downtown-LA warehouse, Adrian, Charlie, and I wonder if he’s ever had one. ... MORE

  • Tue, April 24, 2012
    Jim “Jimmy'Z” Ganzer and his wife couldn’t wait to show us their tucked-away Malibu house filled with artwork, surfboards, photographs, and original sample pieces from JIMMY'Z  collections of the 80s. ... MORE

  • Thu, April 12, 2012
    Jim Ganzer, the founder of reborn cult 80s skate and surf brand Jimmy'Z , has been likened to The Dude. He lives in Malibu, speaks in a slow California baritone, and when I asked him if he wears Jimmy'Z shorts every day, he said, "Pretty much. ... MORE

  • Thu, April 5, 2012
    This spring, cult Venice Beach surf label Jimmy'Z is relaunching, almost exclusively at OC! And so, If you haven't heard it already, here's a little story for you... ... MORE

  • Fri, March 30, 2012
    I hate to be the bearer of bad news but tomorrow is going to be rainy in New York and much of the country. Oh, so you have to stay inside all day and catch up on 30 Rock and Parks and Rec ? And eat snacks all day? Oh? What a ... MORE

  • Thu, March 29, 2012
    Make It Snappy is a photo series showcasing quick snaps from OC & friends Who: Surf, skate, and art legend, Jimmy'Z Where: At OCNY for this morning's information clinic Why:   Jimmy'Z SS12 is in stores now and coming soon to OC ... MORE

ecommerce web design web development