BOUTIQUE
SEARCH

Chantelle

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(349,832,768,10474,10515,208,90,2934,10425,6117,10415,8828,940,9636,821,9396,9400,10501,10412,10464,11110,1049,146,2930,424,1777,6455,10004,10005,10006,10020,3749,5528,6983,8824,10807,11157,182,10122,8068,567,941,5,9530,5239,7913,533,4472,9370,262,9118,5073,7109,9359,7915,9127,7776,7547,9054,10679,7505,9108,10199,3586,21,10851,102,7886,8654,9557,10635,10035,10040,10109,8908,10037,11078,10460,9859,2759,10850,10039,494,11331,7504,8437,10922,11158,650,4312,420,328,8283,414,9820,10204,10216,7818,9208,9006,9846,8812,10196,3747,8407,10215,10164,349,11026,8252,7289,7777,7369,6190,6471,6946,9431,515,9492,9460,10167,11041,9070,9050,8929,9857,9687,9840,43,198,9206,3757,3875,7744,9472,8711,9830,9880,10166,10126,10127,1157,10721,9189,8942,8971,7063,228,1237,9353,292,9697,5126,5034,9988,10907,9828,788,127,350,11119,9005,9528,194,9029,582,597,987,10493,7415,1036,1222,1059,1669,487,2819,528,524,1033,901,857,949,11023,601,9710,545,10947,816,10856,5813,339,750,522,6209,986,7365,9584,9473,463,188,4669,8737,10476,9812,7046,10935,7576,8672,10925,11,4577,114,11116,10174,11046,9883,725,9283,5628,10399,10411,8841,10988,7500,9013,9757,10990,10162,10398,11044,10646,9692,11163,9566,972,10419,9549,11037,9461,11161,11162,7803,9823,7811,7889,10436,11325,3183,10139,7039,48,10741,10643,11030,10189,9122,11034,11118,11341,10511,9982,11035,10180,10225,9986,9418,9994,17,519,9488,8288,8710,8958,10178,9854,10678,11049,11025,230,11051,3178,8099,10124,6519,8863,9427,290,309,10946,88,210,5713,10737,10175,10902,9866,3365,9875,4768,10396,10409,360,205,908,789,692,3009,883,441,1810,1720,7720,212,10884,10607,10603,11303,10848,10849,197,5114,10414,8297,1064,1673,9053,9852,8359,8365,8635,9212,10758,10948,10401,11056,11065,281,310,7700,4355,5577,10230,10562,5343,4334,9736,6466,9827,3662,10792,10421,10239,1071,32,813,391,5819,8747,10901,11144,11139,10738,9863,6201,201,8290,9463,9435,9269,9263,9261,9879,9268,9384,9260,10155,10938,10624,10458,301,10887,10896,10891,8884,10691,10681,7088,7374,6969,7737,7745,7757,8910,8964,9841,9997,10053,10048,9745,4685,11009,8172,10797,11113,10909,600,1073,8030,10744,8849,11109,10763,710,10615) AND c.name='Chantelle' AND p.visible=1 AND vo.visible=1 GROUP BY vo.samefldALU ORDER BY p.addedDate desc limit 0,32
Shop By       
Shop By Colour:
    MAIN ITEM
  • Chantelle Festivite Lace Plunge Bra
    C - G Cups
    Checking inventory...
    Chantelle Festivite Lace Plunge Bra
    $ 119.99
    Chantelle Festivite Lace Plunge Bra
  • Chantelle C Magnifique Bra
    E - H Cup
    Checking inventory...
    Chantelle C Magnifique Bra
    $ 94.99
    Chantelle C Magnifique Bra
  • MAIN ITEM
  • Chantelle Parisienne Four Part Plunge Bra
    E - I Cups
    Checking inventory...
    Chantelle Parisienne Four Part Plunge Bra
    $ 89.99
    Chantelle Parisienne Four Part Plunge Bra
  • MAIN ITEM
  • Chantelle Basic Invisible Moulded Cup T-Shirt Bra
    D - G Cups
    Checking inventory...
    Chantelle Basic Invisible Moulded Cup T-Shirt Bra
    $ 94.99
    Chantelle Basic Invisible Moulded Cup T-Shirt Bra
  • MAIN ITEM
  • Chantelle Presage Demi Cup Balcony Bra
    D - F Cups
    Checking inventory...
    Chantelle Presage Demi Cup Balcony Bra
    $ 144.99
    Chantelle Presage Demi Cup Balcony Bra
  • MAIN ITEM
  • Chantelle Aeria Spacer Underwire Bra
    E - G Cups
    Checking inventory...
    Chantelle Aeria Spacer Underwire Bra
    $ 104.99
    Chantelle Aeria Spacer Underwire Bra
  • MAIN ITEM
  • Chantelle Festivite TShirt Bra
    C - F Cups
    Checking inventory...
    Chantelle Festivite TShirt Bra
    $ 119.99
    Chantelle Festivite TShirt Bra
  • MAIN ITEM
  • Chantelle Rive Gauche Lace Bra
    C - I Cups
    Checking inventory...
    Chantelle Rive Gauche Lace Bra
    $ 119.99
    Chantelle Rive Gauche Lace Bra
  • MAIN ITEM
  • Chantelle 'Eclatante' Underwire Bra
    C- G Cups
    Checking inventory...
    Chantelle 'Eclatante' Underwire Bra
    $ 134.99
    Chantelle 'Eclatante' Underwire Bra
  • MAIN ITEM
  • Chantelle 'Eclatante' Push-Up Bra
    B - G Cups
    Checking inventory...
    Chantelle 'Eclatante' Push-Up Bra
    $ 134.99
    Chantelle 'Eclatante' Push-Up Bra
  • MAIN ITEM
  • Chantelle 'Roselia' Underwire Bra
    D - H Cups
    Checking inventory...
    Chantelle 'Roselia' Underwire Bra
    $ 119.99
    Chantelle 'Roselia' Underwire Bra
  • MAIN ITEM
  • Chantelle 'Irresistable' Multiway Push-Up Bra
    C - F Cups
    Checking inventory...
    Chantelle 'Irresistable' Multiway Push-Up Bra
    $ 92.99
    Chantelle 'Irresistable' Multiway Push-Up Bra
  • MAIN ITEM
  • Chantelle 'Satine' Push-Up Bra
    B - E Cup
    Checking inventory...
    Chantelle 'Satine' Push-Up Bra
    $ 20.00
    Reg. $ 129.99
    Chantelle 'Satine' Push-Up Bra
  • MAIN ITEM
  • Chantelle 'Intuition' Balconette Bra
    D - F Cup
    Checking inventory...
    Chantelle 'Intuition' Balconette Bra
    $ 114.99
    Chantelle 'Intuition' Balconette Bra
  • MAIN ITEM
  • Chantelle 'Revelation' Full Support Bra
    D - H Cup
    Checking inventory...
    Chantelle 'Revelation' Full Support Bra
    $ 104.99
    Chantelle 'Revelation' Full Support Bra
  • MAIN ITEM
  • Chantelle 'Mademoiselle' Memory Foam Bra
    B - G Cup
    Checking inventory...
    Chantelle 'Mademoiselle' Memory Foam Bra
    $ 99.99
    Chantelle 'Mademoiselle' Memory Foam Bra
  • MAIN ITEM
  • Chantelle 'Opera' Demi Bra
    B - F Cup
    Checking inventory...
    Chantelle 'Opera' Demi Bra
    $ 20.00
    Reg. $ 134.99
    Chantelle 'Opera' Demi Bra
  • MAIN ITEM
  • Chantelle 'Illusion' Spacer Bra
    B - G Cup
    Checking inventory...
    Chantelle 'Illusion' Spacer Bra
    $ 20.00
    Reg. $ 99.99
    Chantelle 'Illusion' Spacer Bra
  • MAIN ITEM
  • Chantelle High Impact Convertible Sports Bra
    C - H Cup
    Checking inventory...
    Chantelle High Impact Convertible Sports Bra
    $ 94.99
    Chantelle High Impact Convertible Sports Bra
  • MAIN ITEM
  • Chantelle 'Vous et Moi' Memory Foam Bra
    B - G Cup
    Checking inventory...
    Chantelle 'Vous et Moi' Memory Foam Bra
    $ 99.99
    Chantelle 'Vous et Moi' Memory Foam Bra
  • MAIN ITEM
  • Chantelle 'Vous et Moi' Softcup Bra
    B - E Cup
    Checking inventory...
    Chantelle 'Vous et Moi' Softcup Bra
    $ 89.99
    Chantelle 'Vous et Moi' Softcup Bra
  • MAIN ITEM
  • Chantelle 'C Chic Sexy' Spacer Bra
    C - G Cup
    Checking inventory...
    Chantelle 'C Chic Sexy' Spacer Bra
    $ 92.99
    Chantelle 'C Chic Sexy' Spacer Bra
  • MAIN ITEM
  • Chantelle Merci Balcony Bra
    D - G Cup
    Checking inventory...
    Chantelle Merci Balcony Bra
    $ 99.99
    Chantelle Merci Balcony Bra
  • MAIN ITEM
  • Chantelle Pont Neuf Underwire Bra
    D - H Cup
    Checking inventory...
    Chantelle Pont Neuf Underwire Bra
    $ 114.99
    Chantelle Pont Neuf Underwire Bra
  • MAIN ITEM
  • Chantelle Memory Foam T-Shirt Bra
    B - E Cup
    Checking inventory...
    Chantelle Memory Foam T-Shirt Bra
    $ 89.99
    Chantelle Memory Foam T-Shirt Bra
  • MAIN ITEM
  • Chantelle 'Rive Gauche' Underwire Bra
    C - H Cup
    Checking inventory...
    Chantelle 'Rive Gauche' Underwire Bra
    $ 119.99
    Chantelle 'Rive Gauche' Underwire Bra
  • MAIN ITEM
  • Chantelle 'C Magnifique' Bra
    E - H Cup
    Checking inventory...
    Chantelle 'C Magnifique' Bra
    $ 92.99
    Chantelle 'C Magnifique' Bra
  • MAIN ITEM
  • Chantelle 'C Magnifique' Bra
    E - H Cup
    Checking inventory...
    Chantelle 'C Magnifique' Bra
    $ 54.99
    Reg. $ 92.99
    Chantelle 'C Magnifique' Bra