BOUTIQUE
SEARCH

Freya

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(9382,832,768,10474,10515,208,90,2934,10425,6117,10415,8828,11588,940,821,10501,10412,10464,11406,11110,146,2930,424,1777,6455,10004,10005,11125,10006,10020,11358,3749,5528,6983,8824,10807,11397,11157,182,8068,567,9530,5239,7913,4472,9370,262,9118,5073,7109,9359,7915,9127,7776,7547,10679,7505,9108,10199,3586,21,10851,102,8654,8934,9557,10635,10035,10040,10109,8908,10037,11078,9859,2759,10850,10039,494,7504,10922,11158,650,4312,420,328,8283,414,9820,10204,10216,9208,9006,9846,10944,10196,3747,10862,10881,8407,10215,10164,11198,11182,349,11026,5320,5318,8252,7289,7369,7370,6190,6471,9431,9492,9460,10167,9840,43,9206,3757,3875,9472,8711,9830,9880,10166,11409,10126,11401,10127,1157,10721,8942,8971,7063,11043,228,9353,292,5126,11573,5034,9988,788,10715,11231,127,350,11119,194,9029,582,597,987,10493,7415,1036,1222,1059,487,2819,528,901,857,949,11023,601,9710,545,10947,11438,816,10856,11448,339,750,522,6209,986,7365,9584,463,188,4669,8737,9812,7046,10935,5261,7576,8672,8672,10925,4577,9078,11116,11046,725,9283,11697,5628,10399,10411,8841,11546,7500,9013,9757,5485,10990,9676,9566,972,10419,9549,11037,9461,11161,11162,7803,7811,7889,11325,11413,10139,7039,11405,11415,11399,10741,10643,11030,11411,10913,9122,11034,10511,11035,10180,10225,9986,9418,9994,17,519,8288,8710,10178,10678,11049,11025,230,11425,11051,3178,8099,10124,6519,11142,6555,11124,9427,290,309,10946,88,210,10737,10175,11126,10902,8045,6854,6870,10905,9708,9717,8754,9486,9481,9446,10750,10776,10984,9747,9709,9866,3365,9875,4768,10396,10409,360,205,908,789,692,3009,883,441,1810,1720,7720,212,10884,10848,11641,10849,197,5114,11454,11444,10936,10920,11102,11095,11101,11103,11105,8297,1064,1673,9521,11152,9514,8365,8392,8635,9212,10758,10948,10401,11056,11065,281,310,7700,4355,5577,10562,5343,4334,11151,8056,8763,2193,4425,9758,11208,11222,6466,9827,3662,10792,10421,10239,1071,32,813,391,5819,8747,8723,10901,11144,11139,10738,9863,11147,6201,201,9535,9878,9833,10404,10407,11096,8290,11146,9463,9435,9269,9263,9261,9879,9268,9384,11149,9260,10155,10938,10624,11200,11227,10458,301,10887,10896,10891,8884,10691,10681,7088,7374,6969,7737,7745,7757,8910,8964,9841,9997,9745,4685,11347,11009,8172,11429,10797,11113,10909,600,1073,8030,11698,10744,9541,8849,11109,10763,11173,710,11379,11644,11634,11633) AND c.name='Freya' 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:
Items 1-32 of 37
    MAIN ITEM
  • Freya Fresco Underwire Full Support
    E - J Cups
    Checking inventory...
    Freya Fresco Underwire Full Support
    $ 79.99
    Freya Fresco Underwire Full Support
  • MAIN ITEM
  • Freya Tempo Underwire Balcony Bra
    E - HH Cups
    Checking inventory...
    Freya Tempo Underwire Balcony Bra
    $ 69.99
    Freya Tempo Underwire Balcony Bra
  • MAIN ITEM
  • Freya Deco Vibe Plunge Bra
    E - GG Cups
    Checking inventory...
    Freya Deco Vibe Plunge Bra
    $ 84.99
    Freya Deco Vibe Plunge Bra
  • MAIN ITEM
  • Freya California Dreams Balcony Bra
    E - H Cups
    Checking inventory...
    Freya California Dreams Balcony Bra
    $ 74.99
    Freya California Dreams Balcony Bra
  • Freya Sundance Hi-Neck Top
    E - FF Cups
    Checking inventory...
    Freya Sundance Hi-Neck Top
    $ 89.99
    Freya Sundance Hi-Neck Top
  • MAIN ITEM
  • Freya Sundance Tankini
    E - GG Cups
    Checking inventory...
    Freya Sundance Tankini
    $ 99.99
    Freya Sundance Tankini
  • MAIN ITEM
  • Freya Sundance Molulded Bikini Top
    E - HH Cups
    Checking inventory...
    Freya Sundance Molulded Bikini Top
    $ 84.99
    Freya Sundance Molulded Bikini Top
  • MAIN ITEM
  • Freya Folklore Bandeau Bikini
    E - G Cups
    Checking inventory...
    Freya Folklore Bandeau Bikini
    $ 79.99
    Freya Folklore Bandeau Bikini
  • MAIN ITEM
  • Freya Fancies Underwire Longline Bra
    E - H Cups
    Checking inventory...
    Freya Fancies Underwire Longline Bra
    $ 69.99
    Freya Fancies Underwire Longline Bra
  • MAIN ITEM
  • Freya Retro Bloom Longline Bra
    E - H
    Checking inventory...
    Freya Retro Bloom Longline Bra
    $ 84.99
    Freya Retro Bloom Longline Bra
  • MAIN ITEM
  • Freya Fancies Bralette
    S - XL
    Checking inventory...
    Freya Fancies Bralette
    $ 45.99
    Freya Fancies Bralette
  • MAIN ITEM
  • Freya Epic Underwire Crop Top Sports Bra
    D - F Cups
    Checking inventory...
    Freya Epic Underwire Crop Top Sports Bra
    $ 94.99
    Freya Epic Underwire Crop Top Sports Bra
  • MAIN ITEM
  • Freya Nova Underwire Balcony Bra
    E - J Cups
    Checking inventory...
    Freya Nova Underwire Balcony Bra
    $ 79.99
    Freya Nova Underwire Balcony Bra
  • MAIN ITEM
  • Freya PopArt Underwire Balconette Bra
    E - K Cups
    Checking inventory...
    Freya PopArt Underwire Balconette Bra
    $ 79.99
    Freya PopArt Underwire Balconette Bra
  • MAIN ITEM
  • Freya Club Tropicana Underwire Bandeau Bikini
    E - G Cups
    Checking inventory...
    Freya Club Tropicana Underwire Bandeau Bikini
    $ 84.99
    Freya Club Tropicana Underwire Bandeau Bikini
  • MAIN ITEM
  • Freya Club Tropicana Convertible Bikini Top
    F - J Cups
    Checking inventory...
    Freya Club Tropicana Convertible Bikini Top
    $ 84.99
    Freya Club Tropicana Convertible Bikini Top
  • MAIN ITEM
  • Freya Tempo Underwire Balcony Bra
    E - HH Cups
    Checking inventory...
    Freya Tempo Underwire Balcony Bra
    $ 69.99
    Freya Tempo Underwire Balcony Bra
  • MAIN ITEM
  • Freya In The Navy Underwire Tankini
    E - GG Cups
    Checking inventory...
    Freya In The Navy Underwire Tankini
    $ 119.99
    Freya In The Navy Underwire Tankini
  • MAIN ITEM
  • Freya In The Navy Underwire Bikini
    E - GG Cups
    Checking inventory...
    Freya In The Navy Underwire Bikini
    $ 89.99
    Freya In The Navy Underwire Bikini
  • MAIN ITEM
  • Freya Pure Moulded Nursing Bra
    E - GG Cups
    Checking inventory...
    Freya Pure Moulded Nursing Bra
    $ 89.99
    Freya Pure Moulded Nursing Bra
  • MAIN ITEM
  • Freya Bondi High Waisted Brief
    Small - XL
    Checking inventory...
    Freya Bondi High Waisted Brief
    $ 54.99
    Freya Bondi High Waisted Brief
  • MAIN ITEM
  • Freya Bondi Bandeau Bikini Top
    E - G Cups
    Checking inventory...
    Freya Bondi Bandeau Bikini Top
    $ 79.99
    Freya Bondi Bandeau Bikini Top
  • MAIN ITEM
  • Freya Bondi Underwire Sweetheart Bikini Top
    E - G Cups
    Checking inventory...
    Freya Bondi Underwire Sweetheart Bikini Top
    $ 79.99
    Freya Bondi Underwire Sweetheart Bikini Top
  • MAIN ITEM
  • Freya 'Muse' Spacer Bra
    DD - GG Cups
    Checking inventory...
    Freya 'Muse' Spacer Bra
    $ 84.99
    Freya 'Muse' Spacer Bra
  • MAIN ITEM
  • Freya 'Deco' Moulded Cup Tankini Top
    E - GG Cup
    Checking inventory...
    Freya 'Deco' Moulded Cup Tankini Top
    $ 119.99
    Freya 'Deco' Moulded Cup Tankini Top
  • MAIN ITEM
  • Freya 'Deco Spotlight' Plunge Bra
    E - GG Cup
    Checking inventory...
    Freya 'Deco Spotlight' Plunge Bra
    $ 79.99
    Freya 'Deco Spotlight' Plunge Bra
  • MAIN ITEM
  • Freya 'Deco' Bikini Top
    E - GG Cup
    Checking inventory...
    Freya 'Deco' Bikini Top
    $ 89.99
    Freya 'Deco' Bikini Top
  • MAIN ITEM
  • Freya 'Tootsie' Bikini Top
    E - GG Cup
    Checking inventory...
    Freya 'Tootsie' Bikini Top
    $ 79.99
    Freya 'Tootsie' Bikini Top
  • MAIN ITEM
  • Freya 'Tootsie' Bandeau Tankini Top
    E - GG Cup
    Checking inventory...
    Freya 'Tootsie' Bandeau Tankini Top
    $ 109.99
    Freya 'Tootsie' Bandeau Tankini Top
  • MAIN ITEM
  • Freya 'Deco-Vibe' Plunge Bra
    D - GG Cup
    Checking inventory...
    Freya 'Deco-Vibe' Plunge Bra
    $ 84.99
    Freya 'Deco-Vibe' Plunge Bra
  • Freya 'Deco-Vibe' Brazilian Thong
    E - H Cups
    Checking inventory...
    Freya 'Deco-Vibe' Brazilian Thong
    $ 34.99
    Freya 'Deco-Vibe' Brazilian Thong
  • MAIN ITEM
  • Freya 'Deco Shape' Plunge Bra
    Convertible Version of Our Best-Selling Plunge!
    Checking inventory...
    Freya 'Deco Shape' Plunge Bra
    $ 79.99
    Freya 'Deco Shape' Plunge Bra
Items 1-32 of 37