Click here to make the following queries
CHECK STOCK + PRICE of items where price is not confirmed
PAY ON PICKUP request where this product can be paid for and collected for serious purchsers who do not want online delivery ( these are not showrooms just to view ) Kirstenhof , paarden eiland . diep rivier -
Repair - warranty
Stock that can be viewed in Capetown
Other categories On each product you will either see either :
CLICK HERE for all stock enquiries to check available stock and current price before purchase as this price might have changed.
OR
if this item is in stock and the stock is confirmed.on the product page you can place an order or request a manual eft invoice here
TELEPHONE ( for tracking after we have sent you the tracking number within 12 hours of the order -if any queies)
1327 - Undeclared variable: MAX_DISPLAY_ARTICLES_XSELL
select distinct p.products_id, p.products_image, pd.products_name from articles_xsell ax left join products p on ax.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id where ax.articles_id = '7' and pd.language_id = '1' and p.products_status = '1' order by ax.sort_order asc limit MAX_DISPLAY_ARTICLES_XSELL
[TEP STOP]
select distinct p.products_id, p.products_image, pd.products_name from articles_xsell ax left join products p on ax.xsell_id = p.products_id left join products_description pd on p.products_id = pd.products_id where ax.articles_id = '7' and pd.language_id = '1' and p.products_status = '1' order by ax.sort_order asc limit MAX_DISPLAY_ARTICLES_XSELL
[TEP STOP]