Waste Centre
670 Umgeni Road
Durban
031 312 6223
Log In  |   Register  |   Checkout  |   Contact Us  |  
  Home » Products » Fur
PRODUCTS
SEARCH BY DESIGN
SEARCH BY COLOUR
DETAILED SEARCH

enter your keywords above

  

Fur

PLEASE BE ADVISED PRICES ON THE WEBSITE ARE SUBJECT TO STOCK AVAILABILITY AND TO CHANGE 

Priced to go!! We have a variety in colours and textures. Visit one of our branches to view the entire range,

Displaying 1 to 16 (of 16) Result Pages:  1 
1317 - Query execution was interrupted

select p.products_image, pd.products_name, p.products_date_added, p.products_id, pd.short_desc, p.manufacturers_id, p.products_price, 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 s on p.products_id = s.products_id, products_to_categories p2c left join categories c on c.categories_id = p2c.categories_id where c.categories_status = '1' and 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 = '471' order by pd.products_name limit 0, 30

[TEP STOP]