Log Out
My Shopping Cart
Your shopping cart is empty
 

Customers Log In

 

Diversitech

   
Type
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 m.manufacturers_id = '17' 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      40 items
Coil Cleaner Acid Base Foaming 1Gal
Quick View
Coil Cleaner Acid Base Foaming 1Gal
# PRO-KLEEN
Log in to see
prices
Coil Cleaner Foaminator 1Gal
Quick View
Coil Cleaner Foaminator 1Gal
# PRO-YELLOW
Log in to see
prices
Coil Cleaner Non-Acid Foaming 1Gal
Quick View
Coil Cleaner Non-Acid Foaming 1Gal
# PRO-BROWN
Log in to see
prices
Coil Evap Cleaner 1Gal Non-Acid
Quick View
Coil Evap Cleaner 1Gal Non-Acid
# PRO-GREEN
Log in to see
prices
Condensate Switch Clip On (10)
Quick View
Condensate Switch Clip On (10)
# CS-3
Log in to see
prices
Foam-Plus Spray 19oz Coil Cleaner
Quick View
Foam-Plus Spray 19oz Coil Cleaner
# 358-20
Log in to see
prices
Pad AC 24x24x3 Elite
Quick View
Pad AC 24x24x3 Elite
# EL24X24-3
Log in to see
prices
Pad AC 30x30x3 Elite
Quick View
Pad AC 30x30x3 Elite
# EL30X30-3
Log in to see
prices
Pad AC 32x32x3 Elite
Quick View
Pad AC 32x32x3 Elite
# EL32X32-3
Log in to see
prices
Pad Heat Pump 32X32X8 Condenser
Quick View
Pad Heat Pump 32X32X8 Condenser
# HP32X32-8
Log in to see
prices
Pad Heatpump 36x36x8
Quick View
Pad Heatpump 36x36x8
# HP36X36-8
Log in to see
prices
Pump Condensate 115V low-profile 20'
Quick View
Pump Condensate 115V low-profile 20'
# CP-22LP
Log in to see
prices
Switch Condensate Drain Pan Overflow Universal
Quick View
Switch Condensate Drain Pan Overflow Universal
# CS1200
Log in to see
prices
Tee 3/4" PVC AC Easy Tee W/Service Port (20)
Quick View
Tee 3/4" PVC AC Easy Tee W/Service Port (20)
# ET75
Log in to see
prices
Ties Assort 5,8,11 450/pk
Quick View
Ties Assort 5,8,11 450/pk
# CAT5811
Log in to see
prices
Wet Switch Flood Detector
Quick View
Wet Switch Flood Detector
# WS-1
Log in to see
prices
Whip #10 1/2" x 4' Liquid tite
Quick View
Whip #10 1/2" x 4' Liquid tite
# 6-12-4NM
Log in to see
prices
Whip #10 1/2"x6'
Quick View
Whip #10 1/2"x6'
# 6-12-6NM
Log in to see
prices
Whip #8 3/4"x4' Non-Metallic
Quick View
Whip #8 3/4"x4' Non-Metallic
# 6-34-4NM
Log in to see
prices
Whip #8 3/4"x6'
Quick View
Whip #8 3/4"x6'
# 6-34-6NM
Log in to see
prices
Pro-Bubble Gas Leak
Quick View
Pro-Bubble Gas Leak
# PRO-BUBBLE-32
Log in to see
prices
Radiant Leak Finder 8oz Fluorescent bubble leak
Quick View
Radiant Leak Finder 8oz Fluorescent bubble leak
# RLF-8
Log in to see
prices
Cool Zone Plus 32oz
Quick View
Cool Zone Plus 32oz
# COOLWELD-32
Log in to see
prices
Leads Compressor 12Ga 3Wire for up to 3tons
Quick View
Leads Compressor 12Ga 3Wire for up to 3tons
# TLC-3-12
Log in to see
prices
Super Seal 1.5 to 5 Tons
Quick View
Super Seal 1.5 to 5 Tons
# 944KIT
Log in to see
prices
Super Seal Advanced up to 1.5 Tons
Quick View
Super Seal Advanced up to 1.5 Tons
# 947KIT
Log in to see
prices
Condensate Drain Gun
Quick View
Condensate Drain Gun
# GG-1
Log in to see
prices
Drain Gun Cartridges Swoosh 12/Pk
Quick View
Drain Gun Cartridges Swoosh 12/Pk
# GGC-12
Log in to see
prices
Pro Flush Kit (3)
Quick View
Pro Flush Kit (3)
# PF-KIT
Log in to see
prices
Pro Flush Solvent 16oz (6)
Quick View
Pro Flush Solvent 16oz (6)
# PF-16
Log in to see
prices
Swoosh Cartridges 20 gram Big Shot
Quick View
Swoosh Cartridges 20 gram Big Shot
# SGC-12
Log in to see
prices
Swoosh Gun Big Shot
Quick View
Swoosh Gun Big Shot
# SG-1
Log in to see
prices
Concentric Vent Kit 2"
Quick View
Concentric Vent Kit 2"
# CVENT-2
Log in to see
prices
Concentric Vent Kit 3"
Quick View
Concentric Vent Kit 3"
# CVENT-3
Log in to see
prices
Pan Drain Tablets 100/Jar (12)
Quick View
Pan Drain Tablets 100/Jar (12)
# PROTREAT-161
Log in to see
prices
Termination Kit Flush 2" Horizontal
Quick View
Termination Kit Flush 2" Horizontal
# HVENT-2
Log in to see
prices
Caulk Duct Sealant Alum 10.5oz Pro-Air
Quick View
Caulk Duct Sealant Alum 10.5oz Pro-Air
# 800-008
Log in to see
prices
Caulk Duct Sealant Alum 1Gal Pro-Air
Quick View
Caulk Duct Sealant Alum 1Gal Pro-Air
# 800-009
Log in to see
prices
A/C Bracket 42" 600lbs Max 2/Pk
Quick View
A/C Bracket 42" 600lbs Max 2/Pk
# ACB-42
Log in to see
prices
A/C Bracket 48" 600lbs Max 2/Pk
Quick View
A/C Bracket 48" 600lbs Max 2/Pk
# ACB-48
Log in to see
prices
40 items