NEW ITEMS > LED SHOWER HEADS

SELECT listing.*, (SELECT file.name FROM file WHERE file.source='listing' AND file.record_id=listing.id AND file.type='image' AND file.status='enabled' ORDER BY file.sequence ASC LIMIT 1 ) AS image FROM listing WHERE listing.listing_category_id=7 AND listing.listing_subcategory_id=19 AND listing.status='enabled' ORDER BY listing.sequence ASC, listing.name ASC LIMIT 0, 50

Filter by Product Sub-Category

No results found...

Go Back

ON-LINE SHOPPING

PS! You only need to Register Once!

Special "Trade Specific" discounts apply to Contractors and Resellers.

Free Deliveries for orders over R1000.00, to Major Cities in South Africa.

We never ask for your Bank Details.

All Prices Exclude VAT.

Prices may change without prior notice.

© LEDZ - LED Lights and Lighting Systems - 2014 | led shower heads new items | Info & Terms | Contact | Links

Website Design, Search Engine Optimisation (SEO) by ZAWebs Designs | Web Hosting by ZAWebs Hosting