Log Out
My Shopping Cart
Your shopping cart is empty
 

Customers Log In

 

Tools Do it Best

   
Sort by
select p.products_image, p.products_model, p.products_quantity, p.products_date_available, p.products_date_order_due, pm.ID, m.manufacturers_id, p.products_parent_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, p.vendors_prod_id, 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 p left join specials s on (s.products_id = p.products_id and s.status = 1)) left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_models_to_products p2m on p.products_id=p2m.products_id left join products_models pm on pm.ID = p2m.model_id left join products_to_products_extra_fields p2pef on p.products_id = p2pef.products_id , products_description pd, categories c, products_to_categories p2c where (p.products_status = 1) and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id = p.products_id and p2c.products_id = pd.products_id and (p2c.categories_id = '36' or p2c.categories_id = '31' or p2c.categories_id = '40' or p2c.categories_id = '62' or p2c.categories_id = '63' or p2c.categories_id = '83' or p2c.categories_id = '84' or p2c.categories_id = '98' or p2c.categories_id = '125' or p2c.categories_id = '152' or p2c.categories_id = '195' or p2c.categories_id = '340' or p2c.categories_id = '341' or p2c.categories_id = '394') and m.manufacturers_id = '480' and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") group by p.products_id order by p.products_sort_order, p.products_date_available desc, p.products_last_views desc, pd.products_name
 Grid  List      59 items    
 1  2   
Basin Wrench 11" Adj
Quick View
Basin Wrench 11" Adj
# 408295
Log in to see
prices
Blade Circular Saw 7-1/4"
Quick View
Blade Circular Saw 7-1/4"
# 416881DB
Log in to see
prices
Blade Circular Saw 7-1/4"
Quick View
Blade Circular Saw 7-1/4"
# 409321DB
Log in to see
prices
Bolt Cutter 14"
Quick View
Bolt Cutter 14"
# 310951
Log in to see
prices
Burnguard 9" x12" Heat
Quick View
Burnguard 9" x12" Heat
# 455458
Log in to see
prices
Chisel Set 3/pc Wood
Quick View
Chisel Set 3/pc Wood
# 307769
Log in to see
prices
Hacksaw Hd W/12" Blade
Quick View
Hacksaw Hd W/12" Blade
# 386464
Log in to see
prices
Hedge Shear 9" shrub trimmer
Quick View
Hedge Shear 9" shrub trimmer
# 708844
Log in to see
prices
Prybar 15"
Quick View
Prybar 15"
# 317730
Log in to see
prices
Screwdriver Phillips #1 3" blade length
Quick View
Screwdriver Phillips #1 3" blade length
# 376418
Log in to see
prices
Screwdriver Phillips #2 4" length
Quick View
Screwdriver Phillips #2 4" length
# 376426
Log in to see
prices
Screwdrvr Blade 1/4x4
Quick View
Screwdrvr Blade 1/4x4
# 376361
Log in to see
prices
Screwdrvr Blade 1/8x2.5
Quick View
Screwdrvr Blade 1/8x2.5
# 376191
Log in to see
prices
Screwdrvr Blade 3/16x3 (12)
Quick View
Screwdrvr Blade 3/16x3 (12)
# 376345
Log in to see
prices
Test Plug Drain 1-1/2"IP
Quick View
Test Plug Drain 1-1/2"IP
# 408611
Log in to see
prices
Wrench Pipe  8"
Quick View
Wrench Pipe 8"
# 307947
Log in to see
prices
Wrench Pipe 10"
Quick View
Wrench Pipe 10"
# 308307
Log in to see
prices
Wrench Pipe 14"
Quick View
Wrench Pipe 14"
# 308331
Log in to see
prices
Tarp  9x12 Blue
Quick View
Tarp 9x12 Blue
# 700533
Log in to see
prices
Tarp 16x20 Blue
Quick View
Tarp 16x20 Blue
# 700517
Log in to see
prices
Tarp 30x40 Blue
Quick View
Tarp 30x40 Blue
# 767922
Log in to see
prices
Blade Razor Sgl Edge 100/pk
Quick View
Blade Razor Sgl Edge 100/pk
# 301694
Log in to see
prices
Blade Utility 100/Pk
Quick View
Blade Utility 100/Pk
# 301299
Log in to see
prices
Post Hole Digger 48" Fiberglass Handle
Quick View
Post Hole Digger 48" Fiberglass Handle
# 768138
Log in to see
prices
Rake Garden 14" Wood Handle
Quick View
Rake Garden 14" Wood Handle
# 710662
Log in to see
prices
Shovel Round Point Fiberglass handle
Quick View
Shovel Round Point Fiberglass handle
# 736287
Log in to see
prices
Shovel Round Point Wood handle (6)
Quick View
Shovel Round Point Wood handle (6)
# 710608
Log in to see
prices
Shovel Scoop Aluminum
Quick View
Shovel Scoop Aluminum
# 708880
Log in to see
prices
Shovel Square Point Fiberglass handle
Quick View
Shovel Square Point Fiberglass handle
# 736295
Log in to see
prices
Shovel Square Point Wood handle
Quick View
Shovel Square Point Wood handle
# 710537
Log in to see
prices
Broom Push Outdoor 18"
Quick View
Broom Push Outdoor 18"
# 89210
Log in to see
prices
Box Storage Plastic
Quick View
Box Storage Plastic
# ORG81532
Log in to see
prices
Sawhorse 2 Piece Set Folding
Quick View
Sawhorse 2 Piece Set Folding
# 355380
Log in to see
prices
Shelving 5-Tier 34x72x14
Quick View
Shelving 5-Tier 34x72x14
# 341472
Log in to see
prices
Shelving 5-Tier 34x72x14
Quick View
Shelving 5-Tier 34x72x14
# SHF-01442
Log in to see
prices
Brush Tubing 4-in-1 1/2 & 3/4
Quick View
Brush Tubing 4-in-1 1/2 & 3/4
# 413852
Log in to see
prices
Joint Knife 6" Full Flex
Quick View
Joint Knife 6" Full Flex
# 787291
Log in to see
prices
Putty Knife 1-1/2" Flex Blade Scraper
Quick View
Putty Knife 1-1/2" Flex Blade Scraper
# 772415
Log in to see
prices
Putty Knife 3" Flex Blade
Quick View
Putty Knife 3" Flex Blade
# 772423
Log in to see
prices
Putty Knife 3" Full Flex
Quick View
Putty Knife 3" Full Flex
# 787284
Log in to see
prices
Scraper 1-1/2" Stiff Blade
Quick View
Scraper 1-1/2" Stiff Blade
# 772421
Log in to see
prices
Scraper 3" Stiff Blade
Quick View
Scraper 3" Stiff Blade
# 772425
Log in to see
prices
Trowel Square & V 1/4" Notched 4"x8.5"
Quick View
Trowel Square & V 1/4" Notched 4"x8.5"
# 311375
Log in to see
prices
Drywall Hand Sander 1/2 sheet
Quick View
Drywall Hand Sander 1/2 sheet
# 306751
Log in to see
prices
Pan Mud 12" Galvanized
Quick View
Pan Mud 12" Galvanized
# 307215
Log in to see
prices
Pan Mud 12" Plastic
Quick View
Pan Mud 12" Plastic
# 307211
Log in to see
prices
Trowel 5" Square
Quick View
Trowel 5" Square
# 322234
Log in to see
prices
Trowel 5-1/2" Pointing
Quick View
Trowel 5-1/2" Pointing
# 322252
Log in to see
prices
Sander Pole W/48" Handle
Quick View
Sander Pole W/48" Handle
# 306779
Log in to see
prices
Sanding Block 2-1/2"x5" Cut sheet
Quick View
Sanding Block 2-1/2"x5" Cut sheet
# 334154
Log in to see
prices
59 items  1  2