Home |  Log In
Latin Dance fashions

Men custom costumes

Flowing fabrics, sparkling sequins, beads and rhinestones- just what you need to shine on the dance floor! Do you need a ready-made Latin dance costume for an upcoming dance performance, dance competition or showcase? Dance team members, are you looking for sparkly, sexy dance costumes that will set you apart from all the rest?

Our expanding collection of affordable, custom-made embellished latin dance wear costumes will command that all eyes be on you! They can be used for a Salsa dance costume, Latin ballroom dance costume, Samba dance costume, Cha cha dance costume, Rhumba dance costume, Mambo dance costume, Tango dance costume, and more...

1030 Got error 122 from storage engine
in:
[select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '119' order by p.products_sort_order, pd.products_name]