(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Fantasy&categoryId=5&shop=Lingerie&brandName=Fantasy

Fantasy

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(13475,2926,118,1001,13192,1980,6,5313,13012,12983,12996,13024,13042,12995,12986,12993,13037,2133,13036,5317,5330,2,541,592,1698,915,8,294,512,5307,5321,1781,807,924,193,973,9640,1854,6234,5302,368,5318,12951,13177,14033,7663,11059,9185,9171,5210,62,11956,13900,1112,13004,13056,13046,13039,13048,12994,13020,6672,6505,13367,6423,121,10111,10114,7820,7822,7823,7824,7819,13178,13092,13188,13068,12027,13080,842,248,6563,12188,3031,3033,7625,7583,7608,91,9647,11479,11334,13187,11333,11339,11480,11329,6328,11328,11332,11342,13894,10813,13897,13895,13904,10279,11987,13114,10306,12072,7238,10288,8553,13881,13579,6348,8574,8545,13274,12069,12067,13275,399,860,902,4,738,12949,13469,12959,11601,13182,13189,11593,344,154,7219,13465,13086,12806,13446,12780,9499,13113,13112,4675,9485,13094,13527,13526,13975,13598,13593,13597,13594,13595,13596,13591,13592,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,12748,12378,14011,14006,12382,12383,12311,14015,12750,12302,12363,14012,12749,12395,12393,12290,12370,12299,14002,12355,12291,14010,12757,12387,12390,12324,13941,13992,13935,13938,13934,13957,13956,10394,8601,8608,10032,10838,12844,8723,13827,10727,13090,5833,8606,13525,520,5331,5316,12313) AND c.name='Fantasy' 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:
    MAIN ITEM
  • Fantasy Monroe Teddy
    S - 3X
    Checking inventory...
    Fantasy Monroe Teddy
    $ 69.99
    Fantasy Monroe Teddy
  • MAIN ITEM
  • Fantasy Pola Push Up Lace Teddy
    S - 3X
    Checking inventory...
    Fantasy Pola Push Up Lace Teddy
    $ 59.99
    Fantasy Pola Push Up Lace Teddy
  • MAIN ITEM
  • Fantasy Premier 'Lana' Long Lace Robe
    S - 3X
    Checking inventory...
    Fantasy Premier 'Lana' Long Lace Robe
    $ 89.99
    Fantasy Premier 'Lana' Long Lace Robe
  • MAIN ITEM
  • Fantasy Premiere 'Bella' Lace Striped Robe
    1X - 3X
    Checking inventory...
    Fantasy Premiere 'Bella' Lace Striped Robe
    $ 89.99
    Fantasy Premiere 'Bella' Lace Striped Robe
  • MAIN ITEM
  • Fantasy Courtney Lace Robe & G-String Set
    Checking inventory...
    Fantasy Courtney Lace Robe & G-String Set
    $ 69.99
    Fantasy Courtney Lace Robe & G-String Set