OUR STORE
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(11485,10695,11505,10704,146,10860,10861,10862,10881,11223,11212,10952,11688,12116,12156,12084,10715,10716,10714,12186,12161,12106,11231,11226,11234,11203,11224,11209,11368,11393,11362,2677,11679,11689,11687,10785,10729,10752,1408,11494,11550,11549,11514,11585,11911,11916,11584,11913,11915,8045,11380,6854,6870,6853,6890,8043,11386,10905,10898,9708,9717,9726,9766,8754,11391,9486,9481,9446,10750,10776,10731,10961,10788,10955,9747,9709,9707,9763,11381,11378,11389,11388,11216,11237,11873,11825,11839,12037,12031,11918,11931,11215,11221,10936,10920,10928,11099,11102,11095,11100,12011,12015,12022,11101,11103,11097,11105,11098,11968,11980,11963,11092,8056,8051,11844,8763,8790,2193,4425,9758,9782,9716,11570,11568,11208,11222,11569,2254,1735,1432,11089,11816,11090,11814,11904,11088,9535,9540,11229,11214,11205,11984,11970,9878,9833,10404,10407,10397,10402,11096,11104,10722,10782,10754,10724,10720,10766,10762,10755,11250,11269,6380,10772,10732,8729,6402,11184,11181,10892,10895,11896,11859,11857,11902,11170,11200,11227,10258,11379,11644,11392,11372,12020,11960,12000,12019,12017,10257,10259,11838,11883,11879,11919,11920,11842,11894,11853,11831,11846,11891,11840,11933,11929,11951,11936,11204,11217,11210,11233,11895,11849) 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 40
    MAIN ITEM
  • Freya Sundance Rio Tie Side
    S - XL
    Checking inventory...
    Freya Sundance Rio Tie Side
    $ 49.99
    Freya Sundance Rio Tie Side
  • MAIN ITEM
  • Freya Summer Tide Maxi Dress
    S - L
    Checking inventory...
    Freya Summer Tide Maxi Dress
    $ 114.99
    Freya Summer Tide Maxi Dress
  • MAIN ITEM
  • Freya Summer Tide Bikini Top
    E - GG Cup
    Checking inventory...
    Freya Summer Tide Bikini Top
    $ 89.99
    Freya Summer Tide Bikini Top
  • MAIN ITEM
  • Freya Summer Tide Bikini Bottom
    S - XL
    Checking inventory...
    Freya Summer Tide Bikini Bottom
    $ 44.99
    Freya Summer Tide Bikini Bottom
  • MAIN ITEM
  • Freya Evolve Hi-Neck Crop Top Bikini
    DD - FF Cup
    Checking inventory...
    Freya Evolve Hi-Neck Crop Top Bikini
    $ 89.99
    Freya Evolve Hi-Neck Crop Top Bikini
  • MAIN ITEM
  • Freya Evolve Rio Cut Bikini Bottom
    S - XL
    Checking inventory...
    Freya Evolve Rio Cut Bikini Bottom
    $ 49.99
    Freya Evolve Rio Cut Bikini Bottom
  • MAIN ITEM
  • Freya Zeta Tankini Top
    E - GG Cup
    Checking inventory...
    Freya Zeta Tankini Top
    $ 104.99
    Freya Zeta Tankini Top
  • MAIN ITEM
  • Freya Zeta Bikini Brief
    S - 2X
    Checking inventory...
    Freya Zeta Bikini Brief
    $ 44.99
    Freya Zeta Bikini Brief
  • MAIN ITEM
  • Freya Viper Bikini Top
    E - HH Cup
    Checking inventory...
    Freya Viper Bikini Top
    $ 84.99
    Freya Viper Bikini Top
  • MAIN ITEM
  • Freya Viper Halter Tankini Top
    E - G Cup
    Checking inventory...
    Freya Viper Halter Tankini Top
    $ 119.99
    Freya Viper Halter Tankini Top
  • MAIN ITEM
  • Freya Viper Bikini Bottom
    S - 2X
    Checking inventory...
    Freya Viper Bikini Bottom
    $ 44.99
    Freya Viper Bikini Bottom
  • MAIN ITEM
  • Freya Viper Tanga Bikini Bottom
    S - XL
    Checking inventory...
    Freya Viper Tanga Bikini Bottom
    $ 49.99
    Freya Viper Tanga Bikini Bottom
  • MAIN ITEM
  • Freya Deco Swim Bikini Top
    E - GG Cups
    Checking inventory...
    Freya Deco Swim Bikini Top
    $ 89.99
    Freya Deco Swim Bikini Top
  • MAIN ITEM
  • Freya Deco Swim Bikini Brief
    S - L
    Checking inventory...
    Freya Deco Swim Bikini Brief
    $ 39.99
    Freya Deco Swim Bikini Brief
  • MAIN ITEM
  • Freya Deco Swim Side Tie Brief
    S - XL
    Checking inventory...
    Freya Deco Swim Side Tie Brief
    $ 44.99
    Freya Deco Swim Side Tie Brief
  • MAIN ITEM
  • Freya Sundance Hi-Neck Top
    DD - FF Cups
    Checking inventory...
    Freya Sundance Hi-Neck Top
    $ 89.99
    Freya Sundance Hi-Neck Top
Items 1-16 of 40