(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Shirley_of_Hollywood&categoryId=5&shop=Lingerie&brandName=Shirley+of+Hollywood

Shirley of Hollywood

SELECT p.*, vo.Item_Price1,vo.Item_Price2 ,vo.samefldALU FROM qc_products as p, qc_productInCategories as pc,qc_categories as c, qc_variantOptions AS vo, qc_variants AS v WHERE p.productId = pc.productId AND v.productId = p.productId and pc.categoryId=c.categoryId AND v.variantId = vo.variantId AND c.parentCategoryId = 5 AND p.productId IN(2926,118,1001,15976,1980,5336,13042,2133,5317,15959,15977,15080,15970,15972,15997,15971,15967,15984,2,5311,5412,541,14250,14248,14247,14252,14251,14515,14249,592,915,204,5307,5321,1781,807,924,193,890,9651,1854,6234,1981,5302,6400,368,5318,15958,15969,16005,15964,15978,14033,7663,11059,15992,15988,15999,8494,9169,5210,16008,16007,13900,16009,16010,15963,16310,16304,16346,16350,16319,16316,16313,16344,15979,15981,14733,14707,6505,13367,10111,10114,7820,7822,14637,7821,7823,7824,7819,13188,15075,248,6523,6549,12188,7625,7596,9647,11334,13187,11333,11480,11329,8551,11328,11332,13909,13914,13894,15579,15576,13897,15571,13904,13902,15573,15574,15572,10805,8326,16025,16040,7238,16028,16016,16014,15120,15372,15565,16019,6348,15206,15198,8560,8545,16041,15200,12074,12067,16043,15199,15205,16018,15213,16013,16015,16030,13275,9585,14857,16029,16022,16037,399,860,902,1025,16237,16239,16241,15076,15074,13189,191,154,16382,16391,14872,14871,14873,15712,14874,13465,13086,12805,13113,16224,13094,13527,13526,13598,13592,12362,15512,15876,14013,12394,12752,12332,15533,16397,15850,12396,12343,12336,14014,12384,12304,12759,12367,15340,14011,15538,15893,12382,12311,15344,14015,12750,15895,12302,14012,12749,12395,12290,15332,12299,15507,15852,14002,12355,12291,14010,12757,12387,12324,13941,13935,13938,14298,13956,15147,15142,10839,10838,8723,10727,5833,15178,15187,8606,14924,14246,15670,13525,5331,11499,14914,6291) AND c.name='Shirley of Hollywood' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,16
Shop By       
Shop By Colour:
Items 1-16 of 17
    MAIN ITEMNEW ITEM
  • Shirley of Hollywood Velvet & Lace Chemise
    S - XL
    Checking inventory...
    Shirley of Hollywood Velvet & Lace Chemise
    $ 89.99
    Shirley of Hollywood Velvet & Lace Chemise
  • MAIN ITEM
  • Shirley of Hollywood Lace & Tassel Chemise
    S - XL
    Checking inventory...
    Shirley of Hollywood Lace & Tassel Chemise
    $ 74.99
    Shirley of Hollywood Lace & Tassel Chemise
  • MAIN ITEM
  • Shirley of Hollywood Two Tone Lace Corset
    32" - 38"
    Checking inventory...
    Shirley of Hollywood Two Tone Lace Corset
    $ 119.99
    Shirley of Hollywood Two Tone Lace Corset
  • MAIN ITEM
  • Shirley of Hollywood Glisnette Babydoll
    ONE SIZE
    Checking inventory...
    Shirley of Hollywood Glisnette Babydoll
    $ 44.99
    Shirley of Hollywood Glisnette Babydoll
  • MAIN ITEM
  • Shirley of Hollywood Lace & Tassel Robe
    S/M - L/XL
    Checking inventory...
    Shirley of Hollywood Lace & Tassel Robe
    $ 114.99
    Shirley of Hollywood Lace & Tassel Robe
  • MAIN ITEM
  • Shirley of Hollywood Lace Overlay Corset
    32" - 44"
    Checking inventory...
    Shirley of Hollywood Lace Overlay Corset
    $ 129.99
    Shirley of Hollywood Lace Overlay Corset
  • MAIN ITEM
  • Shirley of Hollywood Sheer & Marabou Robe
    S/M - L/XL
    Checking inventory...
    Shirley of Hollywood Sheer & Marabou Robe
    $ 199.99
    Shirley of Hollywood Sheer & Marabou Robe
  • MAIN ITEM
  • Shirley of Hollywood Lace Overlay Waist Cincher
    S - 3X
    Checking inventory...
    Shirley of Hollywood Lace Overlay Waist Cincher
    $ 69.99
    Shirley of Hollywood Lace Overlay Waist Cincher
  • MAIN ITEM
  • Shirley of Hollywood Ruffle Trimmed Waist Cincher
    Waist Cincher
    Checking inventory...
    Shirley of Hollywood Ruffle Trimmed Waist Cincher
    $ 119.99
    Shirley of Hollywood Ruffle Trimmed Waist Cincher
  • MAIN ITEM
  • Shirley of Hollywood Ruffle Shorts
    Plus Sizing
    Checking inventory...
    Shirley of Hollywood Ruffle Shorts
    $ 34.99
    Shirley of Hollywood Ruffle Shorts
  • MAIN ITEM
  • Shirley of Hollywood Knit Sleepshirt
    S - 3X
    Checking inventory...
    Shirley of Hollywood Knit Sleepshirt
    $ 79.99
    Shirley of Hollywood Knit Sleepshirt
  • MAIN ITEM
  • HOT Fine Fishnet Dress
    Regular & Plus Sizing
    Checking inventory...
    HOT Fine Fishnet Dress
    $ 49.99
    HOT Fine Fishnet Dress
  • MAIN ITEM
  • HOT Mesh & Lace Babydoll
    Regular & Plus Sizing
    Checking inventory...
    HOT Mesh & Lace Babydoll
    $ 54.99
    HOT Mesh & Lace Babydoll
  • MAIN ITEM
  • HOT Stretch Fishnet Pantyhose
    Regular & Plus Sizing
    Checking inventory...
    HOT Stretch Fishnet Pantyhose
    $ 14.99
    HOT Stretch Fishnet Pantyhose
  • MAIN ITEM
  • HOT Fishnet Backseam Thigh Highs
    Regular & Plus Sizing
    Checking inventory...
    HOT Fishnet Backseam Thigh Highs
    $ 24.99
    HOT Fishnet Backseam Thigh Highs
  • MAIN ITEMCHEAPER ITEM
  • HOT Lace Top Thigh Highs
    Regular & Plus Sizing
    Checking inventory...
    HOT Lace Top Thigh Highs
    $ 7.99
    Reg. $ 19.99
    HOT Lace Top Thigh Highs
Items 1-16 of 17