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.

Others Groups' Kente   


Adds all kente to cart
90440
$32.95
NABSW KENTE

NABSW KENTE

90444
$32.95
NSBE KENTE

NSBE KENTE

90500
$32.95
100 BLACK MEN KENTE

100 BLACK MEN KENTE

98549
$32.95
PHILO GOLD

OUT OF STOCK
PHILO GOLD

OUT OF STOCK
98576
$32.95
PHI SIGMA SIGMA

PHI SIGMA SIGMA

98599
$32.95
NPHC KENTE STOLE

NPHC KENTE STOLE

98613
$32.95
PHI DELTA KAPPA INTL

OUT OF STOCK
PHI DELTA KAPPA INTL

OUT OF STOCK
98614
$32.95
PHI DELTA KAPPA GOLD

PHI DELTA KAPPA GOLD

98615
$32.95
PHI DELTA KAPPA RED

PHI DELTA KAPPA RED

98619
$32.95
OMEGA PHI ALPHA

OMEGA PHI ALPHA

98621
$32.95
ALPHA PHI OMEGA TORCH

ALPHA PHI OMEGA TORCH

98626
$32.95
DELTA EPSILON PSI

DELTA EPSILON PSI

98659
$32.95
NAACP KENTE STOLE

NAACP KENTE STOLE

98672
$32.95
MOD KENTE STOLE

MOD KENTE STOLE

98673
$32.95
ZETA ALPHA DELTA

ZETA ALPHA DELTA

98674
$32.95
TAS KENTE

TAS KENTE

98680
$32.95
LGBT KENTE STOLE

LGBT KENTE STOLE

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 = '12' order by p.products_model asc