CAD $
  My Account   (0)  
 CAD $
(0)
SEARCH
foreveryourslingerie.ca/categories/?cName=Louisa_Bracq&categoryId=5&shop=Products&brandName=Louisa+Bracq

Louisa Bracq

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(13872,11314,11322,11575,10994,11312,11321,11005,10992,11319,11320,832,14152,11505,13471,11694,12897,14008,14455,768,12936,11323,10998,14042,11316,208,12885,14509,90,2934,6117,14850,12841,13436,12203,12516,13116,13121,13861,13995,13998,13717,14513,10991,11001,10996,11003,13464,10997,14320,14308,14009,14456,940,10145,10542,821,12823,13883,12843,12692,13457,14292,14465,1049,8177,2930,14542,424,1777,3754,12514,12513,14309,11317,13475,11315,11313,554,843,14155,6454,5532,10003,622,12932,13887,12856,12694,14034,14032,13463,13452,14288,14461,255,231,12892,163,14508,140,14512,2925,2924,5386,2926,6118,14853,14506,12867,12202,12522,13118,13117,13852,13701,13711,12792,118,286,14146,12956,13886,12833,12691,14029,13462,14462,425,12884,166,14511,14507,12834,12528,13120,13851,13996,6455,10004,10005,10020,11690,12895,14305,11358,14315,3749,13458,8824,14312,11693,12898,12512,12511,14322,14007,14453,1001,12790,182,8068,567,941,12690,7127,13147,13530,13143,11659,1980,13583,12574,9530,6,5313,533,13012,12983,13051,13042,2133,13036,4472,9370,5317,262,15080,9118,9123,5330,13726,7938,5073,7109,9359,2,9127,5311,7776,7755,13845,11572,12551,5407,13846,13842,10679,3586,21,14602,12662,11626,12665,13259,13100,7887,13265,541,14345,14330,8654,11582,8268,14583,9557,10635,8267,10035,10042,14250,14248,14247,14252,176,397,14251,293,14515,14249,592,1698,915,8,2759,2760,11359,494,7504,10869,8438,14332,14286,13709,5332,420,328,294,512,5307,13722,8283,12788,13444,8204,12782,13445,5321,1781,807,924,7775,890,7746,9640,1127,1854,6234,5302,6400,12234,11470,7769,349,13862,13385,13413,13387,13519,13488,13491,13403,13389,13392,13395,13478,13406,13384,13504,13508,13483,13496,13499,13391,13480,13510,13511,13405,13409,368,14313,14318,14307,13968,13966,14423,14417,14424,14420,5320,5318,14688,6190,6471,6470,6913,10009,8837,9431,9412,11649,1325,295,12491,515,14422,7882,12206,12205,9492,13179,12535,10167,12557,14421,14407,14285,43,3757,12903,14391,14044,14408,14654,10166,14402,12212,12200,14153,13854,14154,13873,14158,13871,12197,14142,13872,10126,10127,10123,12198,14107,10125,14393,14104,14666,13714,13693,14211,13674,13645,1157,14396,10874,15078,7704,7702,14033,7663,12814,12812,7063,14304,12199,228,14083,14122,14116,14124,12243,11778,11787,11777,11783,14222,14223,889,498,36,1237,504,14027,13885,13763,14364,14353,14180,14182,13761,13758,14186,14169,13759,13762,11059,11417,13368,11418,11422,11446,11455,384,9169,9171,9353,292,14026,14725,5126,9988,11956,13900,13004,13056,13039,12997,13048,8655,13011,13377,12505,13520,13481,13495,13967,13965,13962,13972,13971,14671,14670,14183,14178,14174,14195,127,12899,14454,14317,350,14296,14709,13461,13447,14102,14103,14733,14707,13930,14703,14415,6672,6505,14658,117,169,13367,13082,13088,194,227,7434,358,2684,13860,13853,14735,14225,14224,582,597,10111,10114,13756,7820,7822,13752,13755,13753,14637,7821,7823,9537,9542,987,12312,11708,14136,13460,7824,7819,10806,13847,13843,1059,13188,1669,15075,11740,487,881,528,14324,14740,7515,12947,12837,1033,901,879,857,14041,14401,13307,14018,14020,14017,949,601,545,12418,12254,12253,6270,13430,13459,14425,14669,842,816,248,10856,14582,14371,10864,14352,12463,14599,14114,12055,12056,14734,6523,14732,13802,6563,14736,14674,14677,14678,14675,14676,14673,14333,13820,14241,14243,14242,12906,12829,13075,13102,986,13101,14238,12725,13575,13811,13474,12309,13451,12334,13472,12188,14101,14105,14618,14622,14603,14561,14738,188,4669,12340,4659,12306,4635,12368,13876,13981,14598,14568,14629,14619,14565,7625,7583,7596,91,9647,13732,11334,13187,11333,11338,11480,6338,11329,6328,8551,10282,11332,11342,13909,13914,13894,13897,10809,14206,13904,13902,3274,14291,14325,6980,13426,7046,13470,7576,13251,13279,14856,14849,8672,12314,13437,9101,14338,12213,14400,14414,14847,13114,13253,13278,14855,114,13250,13869,12410,13867,12072,1337,8402,14193,14194,14290,7238,10276,8553,14106,14100,14714,14220,14303,14569,13703,13654,725,14581,9283,13639,5628,13640,5627,13577,13715,14556,9274,13659,14239,7500,9757,13831,13837,13835,6348,8560,8545,14712,14719,14720,13274,12074,12067,3301,13108,14236,13882,12494,14235,13576,13870,14237,12499,9566,972,13105,14234,12731,13582,11161,11979,13880,12500,12482,7803,12265,12264,7811,7889,14517,13275,9558,13580,14854,13393,399,860,12744,12741,902,4,10139,14327,48,14335,14331,14336,14329,14323,13661,13631,2828,10138,10140,13629,13705,10913,13638,10918,13696,10929,12913,12931,12949,12953,13455,13431,13456,13429,11341,14604,13849,14579,11601,14956,13731,14612,12929,14955,12909,14628,12955,14463,12902,13700,13840,14610,12944,14585,14576,14596,13182,15074,13189,13439,13272,12945,13720,12952,11715,11721,13268,13270,12857,12827,17,13072,14392,13269,13091,14726,11091,11167,344,11595,11596,14128,14127,14362,14383,154,14426,14404,13104,14160,14157,519,14144,13271,14149,13273,13109,158,14872,14871,14873,13465,13086,12809,13446,12780,14870,9499,13113,13112,912,9488,9485,9450,13257,13716,13614,13718,13686,13721,11025,13642,8686,13660,13626,7336,13888,13889,10124,6519,14265,14258,6555,14264,11421,11424,11462,15018,15019,9427,9414,14560,14567,14558,10946,88,210,12824,12831,12840,13081,14594,13103,14562,13094,14140,14141,14139,13603,13605,13599,13604,13602,13601,12874,14075,10529,10526,14096,14713,14717,14862,14865,14869,14868,14863,14275,14135,14129,14130,8045,11380,12380,12353,12358,12344,12366,8043,11386,9708,9717,9766,8754,10750,14361,13484,10776,14365,13479,10731,14374,13514,14351,14505,10788,14355,10764,14368,12864,12149,14573,14586,12525,14623,14605,12668,12666,12647,11381,13306,13308,13305,14347,14366,14377,14382,14388,3365,13366,13375,12226,12231,15025,9875,13748,13256,4768,14434,14047,14063,11918,11931,14112,205,12417,14672,908,789,692,3009,883,441,423,507,836,1810,1720,7720,212,13757,10884,10882,10890,14198,13527,13526,13974,13975,13598,13593,13597,13595,13591,13592,13742,14661,14663,14143,14662,13740,14256,14457,10849,14458,11964,14257,14660,14665,11974,12248,13379,13376,12233,14887,14641,14644,12600,14647,14878,14888,14885,14884,14639,14889,14876,14890,14640,14642,14877,14879,15024,13374,12229,8181,5114,12219,9115,14151,12273,12274,14066,11099,11102,14442,12011,11980,13918,14551,14550,14150,14553,13908,14159,14549,14545,14547,12362,14003,14013,12394,12752,12332,12396,12343,12336,14004,14014,12384,12304,12759,12367,13258,12748,12378,14011,14006,12382,12311,14015,12750,12302,12363,14012,12749,12395,12393,12290,12370,12299,14002,12355,12291,14010,12757,12387,12324,13737,13941,13935,13938,13934,14298,14301,13956,12402,12406,12405,12403,12404,12407,14649,1064,773,1673,9521,13239,12372,14967,9514,10146,13246,12359,14971,12657,14756,13236,12977,13232,12974,10394,13238,13229,12978,8635,8636,9212,13248,13244,12674,13225,13215,9194,10401,10406,10426,12979,13222,12980,13210,12976,12981,13228,13208,13207,13261,13206,13260,13212,13242,13217,7700,13214,4355,10562,5343,13247,13241,4334,11151,13231,13240,12126,11153,13219,13209,12117,14283,13234,13235,13216,13249,13245,12150,2193,4425,13211,11570,11568,13218,11208,11222,11569,13223,13237,13224,13243,13213,13227,13230,13220,2254,1667,1735,1432,14957,14959,14958,12307,12293,3662,14460,14113,8601,8608,10032,10838,1071,12810,13864,12813,13858,12811,13857,12815,13863,14410,12846,14413,12861,14397,14429,12850,14940,14946,14948,15022,32,813,391,5803,8747,8723,8714,13828,13826,10738,10939,10740,10941,10781,10943,10727,13087,13084,13073,13078,13707,11753,13628,13098,11713,14859,11704,13067,14861,11726,13071,14864,13142,5833,12158,12060,12061,12062,13314,13315,13311,13671,13697,14228,14231,14227,14230,14229,14226,14631,14584,14600,14578,14626,14881,14883,13386,13418,8290,8019,9463,9484,9453,13423,14882,14875,10724,13419,13399,9435,9269,9263,9262,14559,13449,9268,9384,14976,13076,13878,14294,14981,13065,13879,14293,9260,13893,11759,10248,14633,14566,14555,14577,14595,14571,14073,14071,13702,13698,13691,13695,13636,13664,13675,14597,14718,10847,8431,13978,11181,13408,11823,8657,13712,13402,13689,14789,13322,13325,13317,13316,14770,11564,14162,14908,14904,14907,14910,14909,14901,301,578,14699,14701,14698,14705,14700,14437,8889,14097,14998,14411,10598,11835,10631,10623,10612,10691,10681,14145,7088,14469,14168,13589,13590,8606,9997,9995,12804,12786,12778,13096,13089,14244,14245,14246,14253,10047,13525,12063,520,1436,14527,14433,14432,14493,14470,14473,13612,11347,13467,13440,8172,13620,5331,5316,14518,12266,12269,12783,600,1073,8414,11699,9541,7451,11666,13146,7421,7416,11665,7409,13144,12718,11109,12326,12313,5230,14459,10258,10257,10259,14179,14192,14184,14177,14175,14189,14187,7932,13545,5841,9738,13766,9080,11018,13771,13798,2146,10756,13774,13788,13777,12303,14538,13153,14625,14606,13779,13948,3626,12431,8085,14051,14451,14444,14050,14049,14435,14054,14438,14048,14439,14069,14524,11928,10628,10615,10885,11993,3366,11831,13666,13651,13687,13667,13943,13947,13653,13690,8422,11636,13744,11948,11639,14521,4241,4253,12105,12102,11210) AND c.name='Louisa Bracq' 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
  • Louisa Bracq Clematis Full Cup Bra
    E - I Cups
    Checking inventory...
    Louisa Bracq Clematis Full Cup Bra
    $ 179.99
    Louisa Bracq Clematis Full Cup Bra
    • MAIN ITEM
  • Louisa Bracq Clematis Shorty Tanga
    S - 2X
    Checking inventory...
    Louisa Bracq Clematis Shorty Tanga
    $ 104.99
    Louisa Bracq Clematis Shorty Tanga
CUSTOMER SERVICE
QUICK LINKS
Social