BeetleBugz Activewear
  Top » Catalog » Lycra Swimwear » BB-BARCELONA My Account  |  Cart Contents  |  Checkout   
Categories
Adult Sun Protection
Kids Sun Protection
Lycra Swimwear
Activewear Products
Polyester/PBT Swimwear
"MATT" Racing Swimskins
Information
Shipping & Returns
Privacy Notice
About Us
Our Clothing
UV Video
Team Orders
FAQ
Payment Options
Contact Us
Today's weather

Ladies Barcelona Swimsuit
[BB-BARCELONA]

$35.99 $28.00

A conservative cut swimsuit with excellent range of motion. This suit comes fully lined in Black, Red, Royal Blue and Navy Blue.
Available Options:
Colour, Size: Black (Full Front Lining) (+$2.00), 32 (Small)
Navy (Chest Lined), 32 (Small)
Navy (Chest Lined), 34 (Medium)
Navy (Full Front Lining) (+$2.00), 32 (Small)
Red (Chest Lined), 34 (Medium)
Royal Blue (Chest Lined), 34 (Medium)
Royal Blue (Full Front Lining) (+$2.00), 32 (Small)
Royal Blue (Full Front Lining) (+$2.00), 34 (Medium)
Royal Blue (Full Front Lining) (+$2.00), 36 (Large)
Royal Blue (Full Front Lining) (+$2.00), 38 (X-Large)
  
Reviews
1054 - Unknown column 'p.products_id' in 'on clause'

SELECT distinct p.products_id, pd.products_name, p.products_image, p.products_tax_class_id, pd.products_description, pd.products_short, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (p2c.categories_id = '2') and p.products_status = '1' and p.products_featured = '1' order by rand() DESC limit 3

[TEP STOP]