(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Dita_Von_Teese&categoryId=5&shop=Lingerie&brandName=Dita+Von+Teese

Dita Von Teese

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,16633,5317,16636,15959,16627,16626,15977,16622,15080,15967,2,16631,16629,16632,16634,16637,16630,16639,16620,5311,5412,14250,14248,14247,14252,14515,14249,592,204,5332,5307,5321,1781,807,924,193,890,9651,1854,5302,6400,5318,15946,16799,15953,16005,15964,15978,14033,7663,11059,15992,15988,15999,9169,5210,13903,16346,16350,16319,14733,14707,6505,10111,10114,7820,7822,14637,7821,7823,7824,7819,13188,248,6523,6549,12188,7625,7596,9647,11334,13187,11333,11480,8551,11328,11332,13909,13914,13894,15579,15576,13897,15571,13904,13902,15573,15574,15572,16807,16801,16815,16805,16809,16825,16812,16808,16811,16813,16800,16806,16798,16804,10805,7238,16028,16017,16016,16014,15372,16268,16019,6348,15206,8560,8545,15200,16043,15199,15205,16018,15213,16015,16030,16022,16037,399,860,902,1025,16239,16241,15076,16235,15074,191,154,16382,16391,14872,14871,14873,15712,14874,13465,16224,13094,13527,13526,13592,12362,15512,14013,12394,12752,12332,15850,12396,12343,14014,12384,12304,12759,12367,14011,12382,12311,14015,12750,15895,12302,14012,12749,12395,12290,15332,12299,15507,15852,12355,12291,14010,12757,12387,12324,13941,13935,13938,14298,13956,15147,15142,10839,8723,10727,5833,15178,15187,16609,16607,16602,16614,16605,16598,8606,14246,15670,13525,5331,14914) AND c.name='Dita Von Teese' 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 34
    MAIN ITEM
  • Dita Von Teese Marlene Plunge
    B - DD Cups
    Checking inventory...
    Dita Von Teese Marlene Plunge
    $ 104.99
    Dita Von Teese Marlene Plunge
  • MAIN ITEM
  • Dita Von Teese Marlene G-String
    S - XL
    Checking inventory...
    Dita Von Teese Marlene G-String
    $ 54.99
    Dita Von Teese Marlene G-String
  • MAIN ITEM
  • Dita Von Teese Lurex Non Padded Bra
    B - F Cups
    Checking inventory...
    Dita Von Teese Lurex Non Padded Bra
    $ 79.99
    Reg. $ 119.99
    Dita Von Teese Lurex Non Padded Bra
  • MAIN ITEM
  • Dita Von Teese Bijoux Demi Bra
    B - E Cups
    Checking inventory...
    Dita Von Teese Bijoux Demi Bra
    $ 69.99
    Reg. $ 99.99
    Dita Von Teese Bijoux Demi Bra
  • MAIN ITEM
  • Dita Von Teese Bijoux Bikini Brief
    S - XL
    Checking inventory...
    Dita Von Teese Bijoux Bikini Brief
    $ 24.99
    Reg. $ 54.99
    Dita Von Teese Bijoux Bikini Brief
  • MAIN ITEM
  • Dita Von Teese Madame X Lace Underwire Bra
    C - F Cups
    Checking inventory...
    Dita Von Teese Madame X Lace Underwire Bra
    $ 69.99
    Reg. $ 99.99
    Dita Von Teese Madame X Lace Underwire Bra
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Balconnette Bra
    B - F Cups
    Checking inventory...
    Dita Von Teese Sheer Witchery Balconnette Bra
    $ 119.99
    Dita Von Teese Sheer Witchery Balconnette Bra
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Full Figure Balconette Bra
    D - F Cups
    Checking inventory...
    Dita Von Teese Sheer Witchery Full Figure Balconette Bra
    $ 119.99
    Dita Von Teese Sheer Witchery Full Figure Balconette Bra
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Brief
    S - 2X
    Checking inventory...
    Dita Von Teese Sheer Witchery Brief
    $ 64.99
    Dita Von Teese Sheer Witchery Brief
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Bikini
    S - XL
    Checking inventory...
    Dita Von Teese Sheer Witchery Bikini
    $ 64.99
    Dita Von Teese Sheer Witchery Bikini
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Garter Belt
    S - XL
    Checking inventory...
    Dita Von Teese Sheer Witchery Garter Belt
    $ 79.99
    Dita Von Teese Sheer Witchery Garter Belt
  • MAIN ITEM
  • Dita Von Teese Sheer Witchery Corselette
    B - E Cups
    Checking inventory...
    Dita Von Teese Sheer Witchery Corselette
    $ 169.99
    Dita Von Teese Sheer Witchery Corselette
  • MAIN ITEM
  • Dita Von Teese Dahlia Balcony Bra
    B - F Cups
    Checking inventory...
    Dita Von Teese Dahlia Balcony Bra
    $ 119.99
    Dita Von Teese Dahlia Balcony Bra
  • MAIN ITEM
  • Dita Von Teese Dahlia Full Figure Bra
    C - F Cups
    Checking inventory...
    Dita Von Teese Dahlia Full Figure Bra
    $ 139.99
    Dita Von Teese Dahlia Full Figure Bra
  • MAIN ITEM
  • Dita Von Teese Dahlia Garter Belt
    S - 2X
    Checking inventory...
    Dita Von Teese Dahlia Garter Belt
    $ 84.99
    Dita Von Teese Dahlia Garter Belt
  • MAIN ITEM
  • Dita Von Teese Dahlia Brief
    S - 2X
    Checking inventory...
    Dita Von Teese Dahlia Brief
    $ 79.99
    Dita Von Teese Dahlia Brief
Items 1-16 of 34