JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

AKA   


Adds all kente to cart
98530
$32.95
AKA BABY PINK

AKA BABY PINK

98531
$32.95
AKA HOT PINK

AKA HOT PINK

98532
$32.95
AKA GREEN

OUT OF STOCK
AKA GREEN

OUT OF STOCK
98534
$32.95
AKA BLACK

OUT OF STOCK
AKA BLACK

OUT OF STOCK
98535
$34.00
AKA WHITE

OUT OF STOCK
AKA WHITE

OUT OF STOCK
98536
$32.95
AKA BABY PINK IVY LEAF

AKA BABY PINK IVY LEAF

select p.products_image, pd.products_name, p.products_id, p.products_model, p.products_type, p.products_kente, p.products_type, p.products_recent_sales, p.products_nla, p.products_drop_ship, p.products_kente, p.products_sold_out, p.products_show_only, p.products_quantity, p.products_qty_kente, p.manufacturers_id, p.vendor_id, p.products_price, p.products_master, p.products_master_status, p.products_listing_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials_retail_prices s on p.products_id = s.products_id, categories c, products_to_categories p2c WHERE c.categories_status and !p.products_jostens and p.TYPE <> 'Hybrid' and p.products_status and p.products_listing_status and (p.products_kente or p.products_type = 'custom' or p.products_quantity > 0 or (p.products_master_status and p.products_master_listing_status) or (p.products_drop_ship and false)) and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '107' order by p.products_model asc