Special Offers
- Metabo 18v Brushless Angle Grinder Cordless ComboSpecial Price $399.00 Regular Price $489.00
- STABILA 250mm Torpedo Magnetic Bridge Level 81SM - 02511Special Price $79.00 Regular Price $89.00
- HOLEMAKER SPECIAL 60 MAGNETIC BASE DRILL, 240V, 2MT, CAP: 60MM DIA X 75MM DEPTH - HMSPECIAL60Special Price $4,299.00 Regular Price $4,479.00
- Wera 35 Piece Kraftform Maintenance Socket & Screwdriver Tool Kit WER135926Special Price $349.00 Regular Price $369.00
- BPRO by BUILDPRO RAPID SQUARE 180MM - "RED BACK"Special Price $159.00 Regular Price $199.00
- SP Tools SP40095G Sumo Series Roller Cabinet-Satin Black & Gloss Green Drawers - Discontinued Replaced By SP40095Special Price $2,899.00 Regular Price $3,299.00
- TOUGHCUT 600mm x 600mm CNC Plasma Cutter with Huayuan Plasma Generator 6060Special Price $15,898.00 Regular Price $17,999.00
- Panasonic EY7552X57 1/2" 18v Lithium high Torque Impact Wrench-Bare UnitSpecial Price $499.00 Regular Price $529.00
- SP TOOLS Ratchet Driver Bit Set - 8pc SP39608Special Price $40.00 Regular Price $45.00
Load more
Loading...
Recently sold
- Eibenstock EDB480.1 480mm Masonary Cutting Dual Blade Sword SawSpecial Price $1,750.00 Regular Price $1,899.00
- Kincrome K8070 Magnetic Parts Tray (Round) - 150mmSpecial Price $19.95 Regular Price $22.94
- IMPACTA CRETE SHIELD Concrete Release Agent & Build Up Reducer 5L With SprayerSpecial Price $79.00 Regular Price $119.00
- IMPACTA CRETE OFF Concrete Dissolver-20L Drum CD20LSpecial Price $215.00 Regular Price $289.00
- SP TOOLS - 888 TOOLS Spanner Set Ring Open End 11pce T810061Special Price $39.00 Regular Price $119.00
- Draper Tools 2 In 1 Lawn Aerator/Scarifier 1500W, 320mm -DRA98931Special Price $269.00 Regular Price $459.00
- DIADORA Utility Nail Bag Pouch GUAS1592Special Price $15.00 Regular Price $25.00
Load more
Loading...
Latest Deals
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IF(at_wtp_bonus_end_date.value_id > 0, at_wtp_bonus_end_date.value, at_wtp_bonus_end_date_default.value) AS `wtp_bonus_end_date`, IF(at_wtp_bonus_start_date.value_id > 0, at_wtp_bonus_start_date.value, at_wtp_bonus_start_date_default.value) AS `wtp_bonus_start_date`, IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) AS `wtp_bonus_type`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=2
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_end_date_default` ON (`at_wtp_bonus_end_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_end_date_default`.`attribute_id` = '192') AND `at_wtp_bonus_end_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_end_date` ON (`at_wtp_bonus_end_date`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_end_date`.`attribute_id` = '192') AND (`at_wtp_bonus_end_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_start_date_default` ON (`at_wtp_bonus_start_date_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_start_date_default`.`attribute_id` = '191') AND `at_wtp_bonus_start_date_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_datetime` AS `at_wtp_bonus_start_date` ON (`at_wtp_bonus_start_date`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_start_date`.`attribute_id` = '191') AND (`at_wtp_bonus_start_date`.`store_id` = 1)
INNER JOIN `catalog_product_entity_int` AS `at_wtp_bonus_type_default` ON (`at_wtp_bonus_type_default`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_type_default`.`attribute_id` = '190') AND `at_wtp_bonus_type_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_int` AS `at_wtp_bonus_type` ON (`at_wtp_bonus_type`.`entity_id` = `e`.`entity_id`) AND (`at_wtp_bonus_type`.`attribute_id` = '190') AND (`at_wtp_bonus_type`.`store_id` = 1)
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) WHERE ((IF(at_wtp_bonus_end_date.value_id > 0, at_wtp_bonus_end_date.value, at_wtp_bonus_end_date_default.value) >= '2024-10-17')) AND ((IF(at_wtp_bonus_start_date.value_id > 0, at_wtp_bonus_start_date.value, at_wtp_bonus_start_date_default.value) <= '2024-10-17')) AND ((IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '4') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '5') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '6') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '7') OR (IF(at_wtp_bonus_type.value_id > 0, at_wtp_bonus_type.value, at_wtp_bonus_type_default.value) LIKE '8')) ORDER BY rand() ASC, `e`.`entity_id` DESC
Count: 16
-
- MAXISAFE Air Hood Face Shield with CleanAIR Powered Air Respiratory PAPR Unit Due To COVID This Line Is Selling Fast!!!...Special Price $1,899.00 Regular Price $2,099.00
- TOPTUL Tools 130Pce 1/4", 3/8" & 1/2" Metric & Imperial Socket Wrench Set Tool Kit -TOPGCAI130B Perfect All In One Boot Kit!!!...Special Price $329.00 Regular Price $349.00
- ALLIANCE Air Extra Duty 3/4" Pneumatic Impact Wrench With Extended Anvil- AL-2475-6 Hot Seller For The Truck & Tyre Industries!!!...Special Price $1,099.00 Regular Price $1,199.00
- TRADEFLAME Map Turbo Blow Gas Twin Pack Combo Kit Tradies Favourite!!..Can Be Used At Any Angle!!!....
- ABBOTT & ASHBY 150MM 6" Bench Grinder & Linishing Attachment-50mm x 915mm (2" x 36") -AA362W6 All In 1 Plug & Play Fully Adjustable Linisher Grinder With 5Year WarrantySpecial Price $429.00 Regular Price $499.00
- Genius 348pce Field Service Tool Kit With Foam Insert Trays in Tool Chest Great Tool Kit With Jumbo Spanners & Sockets For The Field Service & Farm Trade!!!Special Price $4,099.00 Regular Price $4,699.00
- BAR Powerease Electric Start Petrol Generator-8500w With 17hp Motor High Start Up Loads Like Wool Press’ or WeldersSpecial Price $2,159.00 Regular Price $2,499.00
- ARMORGARD Rubble Truck Jobsite Cart-Lid The Perfect Jobsite Secure Solution!!!...Special Price $399.00 Regular Price $459.00
- AUTOGLYM Instant Rapid Ceramic Spray-500mL-ATD Quick & Easy Spray & Buff FormulaSpecial Price $29.00 Regular Price $39.00
- TORMEK T4 Whetstone Sharpening Machine Limited Combo Limited Edition Kit With BONUS Jigs!!!...While Stocks Last!!!...$999.00
- KINCROME DOMINATOR 601 PIECE 13 DRAWER TOOL WORKSHOP - P1572GB Red Hot Deal Limited Edition Kit For A Limited Time!!!...$4,999.00
- Estwing Hammertooth Vinyl Grip Milled Face Hammer-24oz - E6-24TM Hot Seller For Carpenters & Formworkers!!!....Special Price $120.00 Regular Price $149.00
- Milwaukee M12FPP2A2422B 12V 2.0Ah/4.0Ah Li-Ion Cordless Fuel 2pce Combo Kit Power Pack Redeem a M12B4 12V 4.0Ah Battery for FREE! Purchases valid between 01/10/2024 - 31/12/2024$529.10
- BAR Portable Hush Electric Start Inverter Generator - 3.5kva Perfect For Motor Homes, Caravans, Camping & MoreSpecial Price $1,989.00 Regular Price $2,199.00
View All
Loading...