Log Out
My Shopping Cart
Your shopping cart is empty
 

Customers Log In

 

Kissler

   
Group
Energy Rating
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 = '500' 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      214 items    
   1  2  3  4  5   
Faucet Lav 2-handle CP
Quick View
Faucet Lav 2-handle CP
# 77-1105
Log in to see
prices
Faucet Lav 2-handle CP
Quick View
Faucet Lav 2-handle CP
# 77-3293
Log in to see
prices
Faucet Lav 2-handle CP w/pop-up
Quick View
Faucet Lav 2-handle CP w/pop-up
# 77-1006
Log in to see
prices
Faucet Lav 2-handle CP w/pop-up
Quick View
Faucet Lav 2-handle CP w/pop-up
# 77-1106
Log in to see
prices
Faucet Rebuild 3-handle
Quick View
Faucet Rebuild 3-handle
# RBK6346
Log in to see
prices
Faucet Tub&Shower BN
Quick View
Faucet Tub&Shower BN
# 77-3810
Log in to see
prices
Faucet Tub&Shower CP
Quick View
Faucet Tub&Shower CP
# 77-3805
Log in to see
prices
Flange Tub&Shower Fits Central Brass
Quick View
Flange Tub&Shower Fits Central Brass
# 42-0615
Log in to see
prices
Flange Tub&Shower Fits Sayco
Quick View
Flange Tub&Shower Fits Sayco
# 42-4050
Log in to see
prices
Handle Faucet Acrylic Fits Nibco
Quick View
Handle Faucet Acrylic Fits Nibco
# 95-0178
Log in to see
prices
Handle Faucet Hot&Cold
Quick View
Handle Faucet Hot&Cold
# 99-0242
Log in to see
prices
Handle Faucet Single Lever Symmons
Quick View
Handle Faucet Single Lever Symmons
# 46-0215
Log in to see
prices
Handle Hot & Cold Long broach Fits Gerber
Quick View
Handle Hot & Cold Long broach Fits Gerber
# 99-1151
Log in to see
prices
Handle Puller Faucet
Quick View
Handle Puller Faucet
# 08-0421
Log in to see
prices
Handle Tub & Shower Central Brass
Quick View
Handle Tub & Shower Central Brass
# 99-1163
Log in to see
prices
Handle Tub & Shower Diverter Central Brass
Quick View
Handle Tub & Shower Diverter Central Brass
# 99-1163D
Log in to see
prices
Handle Tub & Shower Diverter Indiana Brass
Quick View
Handle Tub & Shower Diverter Indiana Brass
# 99-1170D
Log in to see
prices
Handle Tub & Shower Diverter Pfister
Quick View
Handle Tub & Shower Diverter Pfister
# 99-1217D
Log in to see
prices
Handle Tub & Shower Diverter Pfister
Quick View
Handle Tub & Shower Diverter Pfister
# 99-1215D
Log in to see
prices
Handle Tub & Shower Diverter Union Brass
Quick View
Handle Tub & Shower Diverter Union Brass
# 99-1293D
Log in to see
prices
Handle Tub & Shower Indiana Brass
Quick View
Handle Tub & Shower Indiana Brass
# 99-1170
Log in to see
prices
Handle Tub & Shower Nibco
Quick View
Handle Tub & Shower Nibco
# 99-0209
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 99-0215
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 95-0186
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 95-0180
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 99-1217
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 99-1215
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 95-1186
Log in to see
prices
Handle Tub & Shower Pfister
Quick View
Handle Tub & Shower Pfister
# 95-0181
Log in to see
prices
Handle Tub & Shower Sterling Rep
Quick View
Handle Tub & Shower Sterling Rep
# 99-0282
Log in to see
prices
Handle Tub & Shower Sterling Rep.
Quick View
Handle Tub & Shower Sterling Rep.
# 99-0282D
Log in to see
prices
Handle Tub & Shower Union Brass
Quick View
Handle Tub & Shower Union Brass
# 99-0293
Log in to see
prices
Handle Tub & Shower Union Brass
Quick View
Handle Tub & Shower Union Brass
# 99-1293
Log in to see
prices
Handle Tub&Shower
Quick View
Handle Tub&Shower
# 46-6797
Log in to see
prices
Lift Rod & linkage Popup
Quick View
Lift Rod & linkage Popup
# 08-1112
Log in to see
prices
Nipple Brass 2-3/4" 5/8" Gerber
Quick View
Nipple Brass 2-3/4" 5/8" Gerber
# 43-1828
Log in to see
prices
Nipple Escutcheon Fits Pfister
Quick View
Nipple Escutcheon Fits Pfister
# 43-6346
Log in to see
prices
O-Ring Kit 200Ct
Quick View
O-Ring Kit 200Ct
# 540-0201
Log in to see
prices
Packing Faucet Stem 10/pk Sayco Rep
Quick View
Packing Faucet Stem 10/pk Sayco Rep
# 71-0202
Log in to see
prices
Plastic Nipple Universal
Quick View
Plastic Nipple Universal
# 43-0001
Log in to see
prices
Pop-Up Assy BN Brass
Quick View
Pop-Up Assy BN Brass
# 08-1004BN
Log in to see
prices
Pop-Up Assy CP
Quick View
Pop-Up Assy CP
# 08-1004
Log in to see
prices
Pop-up Ball Crank & Nut
Quick View
Pop-up Ball Crank & Nut
# 61-4884
Log in to see
prices
Rebuild Kit Shower
Quick View
Rebuild Kit Shower
# RBK0326
Log in to see
prices
Ring Escutcheon Fits Sayco
Quick View
Ring Escutcheon Fits Sayco
# 39-3165
Log in to see
prices
Seat Bibb Washers 270pc
Quick View
Seat Bibb Washers 270pc
# 540-5001
Log in to see
prices
Seat Gerber
Quick View
Seat Gerber
# 55-0652
Log in to see
prices
Shower Valve Seal Kit Symmons
Quick View
Shower Valve Seal Kit Symmons
# 55-0004
Log in to see
prices
Showerhead 1.8Gpm CH
Quick View
Showerhead 1.8Gpm CH
# 76-0025
Log in to see
prices
Showerhead 2.0 GPM
Quick View
Showerhead 2.0 GPM
# 76-0010
Log in to see
prices
214 items    1  2  3  4  5