CAD $
  My Account   (0)  
 CAD $
(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Fantasy&categoryId=5&shop=Products&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(14537,11314,11322,11575,11312,11321,16433,16434,11319,11320,832,15536,16694,11694,12897,14008,14455,15729,15324,15399,16407,768,15511,11323,16291,11316,208,90,2934,15861,6117,14513,12203,15365,15859,16690,16293,14514,10991,10997,16688,15356,16120,14308,14009,14456,15728,16409,940,10145,10147,10542,10543,821,15887,15508,16260,1049,2930,14542,15323,15500,16424,424,1777,3754,16130,12514,14309,15329,15398,16222,11317,11315,11313,554,843,6454,10003,15214,622,15532,15885,15857,12694,16262,14032,16276,15518,16287,16274,255,231,163,140,2925,2924,5386,2926,6118,15862,14506,12867,12202,15089,15390,15346,15380,15884,16686,16266,12792,118,286,15524,12691,14031,13462,15516,425,166,14969,14507,12528,15392,15371,15854,16678,16292,6455,10004,10005,16673,15333,16107,10020,11690,16406,11358,3749,11693,12512,14322,14007,14453,15203,15727,15326,15400,16408,1001,12790,182,14751,14750,15976,15261,567,941,12690,7127,13147,13532,13530,13143,11659,1980,13583,15614,9530,5336,533,16554,16550,13042,2133,16633,4472,5317,16636,15959,16627,16626,15977,16622,262,15080,13727,7938,7109,15967,15563,15706,2,16631,16629,16632,16634,16637,16630,16639,16620,9127,5311,5412,13846,10679,3586,14602,11626,16428,14345,14330,11582,8268,14583,10635,8267,10035,10042,14250,14248,14247,14252,176,14515,14249,15809,16526,592,15385,14608,915,204,11359,494,7504,10869,8438,14346,14286,16557,16549,15073,15527,5332,5307,16905,8283,12788,8204,12782,5321,1781,807,924,193,890,9651,1127,15341,1854,5302,6400,16353,7769,349,15505,13862,13493,13491,13508,13483,13511,13405,9576,5318,16137,16142,16114,16121,16115,14688,16852,15946,10009,15526,16081,15523,16080,16799,15952,11649,295,12491,16278,15948,15531,15520,7882,12207,16223,15737,10167,14285,43,3757,15055,15035,15046,15949,15953,15947,15736,14654,10166,12212,16005,15964,14153,14154,14158,14142,10127,16520,10125,15955,15664,16285,14211,16295,16281,15978,1157,15401,10874,15430,7704,7702,14033,16677,16683,7663,7063,14987,12199,228,11786,11778,12243,889,498,36,504,16706,16708,16758,14180,16131,16098,16095,16695,16698,13758,16485,16482,11059,11417,15992,13368,15988,15999,11418,11422,11446,11439,384,9169,9353,5210,292,14725,9988,16499,16506,13903,16346,16350,16319,13377,15445,16475,16476,16477,16780,16778,16868,16874,16866,127,12899,14317,350,15197,13461,13447,14733,14707,16423,6505,117,169,194,16524,12661,13807,15898,358,11271,14224,582,597,10111,10114,13756,7820,7822,13752,13755,13753,14637,7821,7823,9537,9542,987,15051,16414,12312,7824,7819,10806,13847,13188,1669,11740,487,528,14589,14324,7515,15058,15060,15039,15064,901,857,601,16716,16699,16702,16697,16696,16709,16094,16129,16123,16119,545,16133,16125,14985,12418,12254,12253,6270,15072,14425,14669,16496,842,816,16503,248,10856,16284,10864,16258,14599,12055,16367,12056,6523,13802,6549,16876,15908,16877,14333,14241,14243,15050,986,16277,3304,15165,12309,12334,12188,16501,14101,14105,16497,15264,188,4669,12340,4659,12306,4635,12368,15867,15864,14629,7625,7596,9647,11334,13187,11333,11480,8551,10282,11328,11332,13909,13914,13894,15579,15576,13897,10809,15571,13904,13902,15573,3274,15574,15572,16807,16801,16815,16805,16809,16825,16812,16808,16811,16813,16800,16806,16798,16804,10805,6980,16504,7046,16513,15513,7576,16561,8672,12314,15841,13437,9101,15354,14592,14338,12213,114,16498,12410,16511,2260,8402,14193,14194,7238,16028,16020,16047,16021,16024,16017,16033,16016,16014,14303,16523,14569,14367,9283,14381,14349,5628,16211,5627,13577,15372,16212,16268,7500,9757,13837,16019,6348,15206,8560,8545,15200,16043,15199,3301,15205,16261,15121,15394,13576,8059,12499,9566,14580,15366,972,16267,15567,15375,12500,15122,12482,7803,12265,15393,16265,12264,16018,15213,16015,16030,7889,13580,16022,16037,399,860,902,16372,16386,16390,16376,16392,16384,15699,15673,15758,15759,48,14563,16234,16240,16242,16239,16241,13629,10913,16412,10918,16411,10929,16417,15076,11341,15447,14604,15617,16231,15448,14579,15621,15449,16230,15623,13731,16236,12955,16512,14463,12902,16505,14585,16232,16229,16493,16235,16494,15074,15619,13439,16508,16510,11715,11721,15042,13268,15851,12857,12827,17,13269,191,15558,14362,14383,154,15870,14160,14157,519,15858,16382,16391,14872,14871,14873,15712,14874,13465,16224,912,6262,16893,11025,16658,8686,16659,7336,10124,6519,6555,16091,16419,16418,11421,11424,11462,15866,15871,15881,15379,15353,16466,16467,16468,14935,16296,14939,16264,14944,16290,10946,11561,210,13081,13103,13069,13099,13094,14140,14139,15873,15865,15888,15853,15878,16500,14096,14717,14862,14865,14869,14868,14863,14275,15271,15486,15753,14135,14130,15144,15148,8045,12380,12353,12358,12344,12366,9708,9717,9766,8754,10750,15225,14361,10776,10731,15226,14374,16843,10788,10764,12668,12666,13366,4768,15293,16901,14434,15877,11935,11931,14112,205,12417,14672,789,692,3009,883,441,423,507,836,212,13757,10884,16795,10882,10890,16847,15732,16570,16430,16980,16787,13527,13526,13592,15250,15769,16225,16227,16792,14663,15251,14143,16572,15253,13740,15395,14204,15378,16204,16665,14256,14457,16587,10849,14458,11964,16213,15249,15254,15255,16668,12248,16070,16472,16483,16071,16473,16067,16140,16066,16118,14693,16453,16162,9132,15233,15016,15014,15021,15017,12273,12274,16056,15691,15684,15704,16053,13918,16619,14150,13908,14767,14159,14547,12362,16883,15631,15512,14013,12394,12752,12332,15850,12396,12343,14014,12384,12304,12759,12367,14011,12382,12311,14015,12750,15895,15633,12302,15634,14012,12749,12395,12290,15332,12299,15507,15852,12355,12291,14010,12757,12387,15279,12324,16054,13941,13935,13938,14298,13956,15147,15142,16882,12402,12406,12405,12403,12404,12407,16851,16484,16491,1673,16451,16415,9514,10146,16413,8635,8636,9212,16689,15765,12674,16680,15766,12979,12980,16085,16086,15335,15338,13212,13242,13217,16271,16282,16272,15327,15343,16957,15328,16919,7700,16410,4355,10562,5343,4334,11151,14980,16662,11153,16663,15731,14913,13234,13216,13249,13245,16772,16773,16774,16771,2193,4425,13211,15939,16643,11570,11568,13218,11208,11222,11569,15216,13223,13237,13224,15220,13243,13230,2254,1735,1432,15217,11871,14957,14959,14958,15228,15229,3662,15767,16450,14113,16226,16205,10839,1071,15541,15522,15519,12810,16088,12813,12811,12815,16084,14410,14413,14397,16908,16907,16471,16470,16469,15022,32,391,8747,8723,8714,13828,13826,10738,10939,10740,10941,10781,10943,10727,16416,13707,13628,16404,15276,15280,15807,13142,5833,7165,16955,12060,16929,12061,16920,13314,13315,13671,14951,14938,15552,16618,15553,16617,15550,16615,15549,16616,15498,15496,15497,15494,15495,15837,15828,15840,15829,16589,16590,16591,16790,16789,16791,14578,15322,8290,9269,9263,15886,9262,15517,9268,9384,16661,14976,13878,14294,16660,14981,14293,9260,13893,11759,10248,15582,16666,16667,16664,16670,11310,16431,15730,14931,16705,16354,13691,16885,16895,10847,15232,13408,8657,13712,13402,16138,16132,16122,16718,16743,16742,16770,16135,16113,16853,16854,16388,16394,13586,13361,16370,13316,14770,16886,7185,16903,16892,301,16579,16583,14445,16460,14998,14411,15178,15187,15586,10613,10691,14145,7088,14469,13589,13590,13588,16609,16607,16602,16614,16605,16598,8606,9997,9995,14244,14245,14246,15690,15670,15542,15528,13525,16586,12063,1436,15194,14527,15689,14493,15788,15791,13612,11347,13440,8172,16243,16246,16247,16248,16244,2146,15821,5331,14914,12266,12269,15584,600,1073,16317,16302,16342,16303,16343,15836,8414,11699,9541,16399,7451,13146,7421,7416,7409,12718,15583,16432,5230,15768,14459,15252,16228,15585,15825,15826,16864,16870,16865,16869,14192,14184,14177,14175,14189,14187,16127,16128,16139,16116,16102,16106,16101,16134,15894,15860,15872,15848,15632,16840,5841,15815,16647,16652,15404,15822,16797,16651,13798,16650,13774,13788,13777,12303,14538,13153,16648,16655,16515,16891,16875,15256,3626,8085,14058,14048,14439,14069,15707,15702,15655,15657,15652,15896,14524,11928,10885,11993,14928,14916,14926,11881,13667,16488,15193,13951,15451,16884,16860,16900,8422,16794,13744,13741,14521,11927,15259,12105) 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 Bahama Mama Chiffon Kimono & Panty
    S/M - 3X/4X
    Checking inventory...
    Fantasy Bahama Mama Chiffon Kimono & Panty
    $ 69.99
    Fantasy Bahama Mama Chiffon Kimono & Panty
    • MAIN ITEM
  • Fantasy Marilyn Halter & Panty
    S - 3X
    Checking inventory...
    Fantasy Marilyn Halter & Panty
    $ 69.99
    Fantasy Marilyn Halter & Panty
    • MAIN ITEM
  • Fantasy Courtney Lace Robe & G-String Set
    Plus Sized
    Checking inventory...
    Fantasy Courtney Lace Robe & G-String Set
    $ 69.99
    Fantasy Courtney Lace Robe & G-String Set
CUSTOMER SERVICE
QUICK LINKS
Social