(0)
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(14537,15500,16905,13493,13491,13508,13483,13511,13405,16137,16142,16114,16121,16115,16706,16708,16758,14180,16131,16098,16095,16695,16698,13758,16485,16482,16475,16476,16477,16780,16778,16868,16874,16866,16716,16699,16702,16697,16696,16709,16094,16129,16123,16119,16133,16125,13802,14241,14243,15165,14629,14569,14367,14381,14349,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,11935,11931,15732,16453,13918,16619,14150,13908,14767,14159,14547,16883,16882,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,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,16666,16667,16664,16670,15730,14931,13691,16895,13408,13712,13402,16138,16132,16122,16718,16743,16742,16770,16135,16113,16886,16903,16892,16399,15825,15826,16864,16870,16865,16869,14192,14184,14177,14175,14189,14187,16127,16128,16139,16116,16102,16106,16101,16134,15894,15860,15872,15848,11928,14928,14916,14926,11881,13667,13951,16884,16900,11927,12105) AND c.name='Freya' 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:
Items 1-16 of 29
    MAIN ITEM
  • Freya Sundance Rio Tie Side Bikini Brief
    S - XL
    Checking inventory...
    Freya Sundance Rio Tie Side Bikini Brief
    $ 49.99
    Freya Sundance Rio Tie Side Bikini Brief
  • MAIN ITEM
  • Freya Totally Check Halter Bikini Top
    E - H cups
    Checking inventory...
    Freya Totally Check Halter Bikini Top
    $ 39.99
    Reg. $ 74.99
    Freya Totally Check Halter Bikini Top
  • MAIN ITEM
  • Freya Sunset Palm Hi-neck Bikini Top
    E - G Cups
    Checking inventory...
    Freya Sunset Palm Hi-neck Bikini Top
    $ 39.99
    Reg. $ 89.99
    Freya Sunset Palm Hi-neck Bikini Top
  • MAIN ITEM
  • Freya Wild Sun Underwire Halter Top
    E - GG Cups
    Checking inventory...
    Freya Wild Sun Underwire Halter Top
    $ 39.99
    Reg. $ 74.99
    Freya Wild Sun Underwire Halter Top
  • MAIN ITEM
  • Freya Sundance Hi-Neck Bikini Top
    E - G Cups
    Checking inventory...
    Freya Sundance Hi-Neck Bikini Top
    $ 49.99
    Reg. $ 89.99
    Freya Sundance Hi-Neck Bikini Top
  • MAIN ITEM
  • Freya Sundance Moulded Bikini
    E - HH Cups
    Checking inventory...
    Freya Sundance Moulded Bikini
    $ 49.99
    Reg. $ 84.99
    Freya Sundance Moulded Bikini
  • MAIN ITEM
  • Freya Endless Summer Plunge Bikini Top
    E - HH Cups
    Checking inventory...
    Freya Endless Summer Plunge Bikini Top
    $ 49.99
    Reg. $ 79.99
    Freya Endless Summer Plunge Bikini Top
  • MAIN ITEM
  • Freya Endless Summer Side Tie Bottoms
    S - XL
    Checking inventory...
    Freya Endless Summer Side Tie Bottoms
    $ 29.99
    Reg. $ 54.99
    Freya Endless Summer Side Tie Bottoms
  • MAIN ITEM
  • Freya Sundance Moulded Bikini
    F - HH Cups
    Checking inventory...
    Freya Sundance Moulded Bikini
    $ 39.99
    Reg. $ 84.99
    Freya Sundance Moulded Bikini
  • MAIN ITEM
  • Freya Sundance Hi-Neck Top
    DD - FF Cups
    Checking inventory...
    Freya Sundance Hi-Neck Top
    $ 39.99
    Reg. $ 89.99
    Freya Sundance Hi-Neck Top
  • MAIN ITEM
  • Freya Mamba Moulded Bikini Top
    E - HH Cups
    Checking inventory...
    Freya Mamba Moulded Bikini Top
    $ 39.99
    Reg. $ 84.99
    Freya Mamba Moulded Bikini Top
  • MAIN ITEM
  • Freya Mamba Swim Tanga
    S - XL
    Checking inventory...
    Freya Mamba Swim Tanga
    $ 19.99
    Reg. $ 44.99
    Freya Mamba Swim Tanga
  • MAIN ITEM
  • Freya Macrame Bandeau Bikini Top
    DD - G Cup
    Checking inventory...
    Freya Macrame Bandeau Bikini Top
    $ 99.99
    Freya Macrame Bandeau Bikini Top
  • MAIN ITEM
  • Freya Macrame Bikini Brief
    S - XL
    Checking inventory...
    Freya Macrame Bikini Brief
    $ 54.99
    Freya Macrame Bikini Brief
  • MAIN ITEM
  • Freya Back To Black Crop Top
    DD - FF Cups
    Checking inventory...
    Freya Back To Black Crop Top
    $ 89.99
    Freya Back To Black Crop Top
  • MAIN ITEM
  • Freya Back To Black Italini Bikini Bottoms
    S - XL
    Checking inventory...
    Freya Back To Black Italini Bikini Bottoms
    $ 39.99
    Freya Back To Black Italini Bikini Bottoms
Items 1-16 of 29