Log Out
My Shopping Cart
Your shopping cart is empty
 

Customers Log In

 

Jones Stephens

   
Family
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 = '94' 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      121 items    
   1  2  3   
Closet Gasket Sponge 6-3/4"OD
Quick View
Closet Gasket Sponge 6-3/4"OD
# G13601
Log in to see
prices
Closet Gasket Sponge 6-3/4"OD
Quick View
Closet Gasket Sponge 6-3/4"OD
# G13616
Log in to see
prices
Closet Gasket Sponge 6-3/4"OD
Quick View
Closet Gasket Sponge 6-3/4"OD
# G13634
Log in to see
prices
Flange Shower Rod Adj CH
Quick View
Flange Shower Rod Adj CH
# S02151
Log in to see
prices
Gasket Tank-to-Bowl Fits Alamo
Quick View
Gasket Tank-to-Bowl Fits Alamo
# C03301
Log in to see
prices
Gasket Tank-to-Bowl Fits American Standard
Quick View
Gasket Tank-to-Bowl Fits American Standard
# C03303
Log in to see
prices
Gasket Tank-to-Bowl Fits Crane
Quick View
Gasket Tank-to-Bowl Fits Crane
# C03304
Log in to see
prices
Gasket Tank-to-Bowl Fits Eljer
Quick View
Gasket Tank-to-Bowl Fits Eljer
# C03302
Log in to see
prices
Gasket Tank-to-Bowl Fits Gerber
Quick View
Gasket Tank-to-Bowl Fits Gerber
# C03305
Log in to see
prices
Gasket Tank-to-Bowl Fits Mansfield
Quick View
Gasket Tank-to-Bowl Fits Mansfield
# C03306
Log in to see
prices
Gasket Tank-to-Bowl Universal Fits-All
Quick View
Gasket Tank-to-Bowl Universal Fits-All
# C03300
Log in to see
prices
Laundry Outlet Box 1/2"Pex
Quick View
Laundry Outlet Box 1/2"Pex
# B05948
Log in to see
prices
Laundry Outlet Box 1/2"Sweat
Quick View
Laundry Outlet Box 1/2"Sweat
# B05740
Log in to see
prices
Sink Strainer 1-5/8"
Quick View
Sink Strainer 1-5/8"
# D18062
Log in to see
prices
Sink Strainer 1-7/8"
Quick View
Sink Strainer 1-7/8"
# D18063
Log in to see
prices
Closet Bolt Set 1/4x2-1/4 Break-off
Quick View
Closet Bolt Set 1/4x2-1/4 Break-off
# C02040
Log in to see
prices
Closet Bolt Set 1/4x2-1/4 Plated
Quick View
Closet Bolt Set 1/4x2-1/4 Plated
# C02011
Log in to see
prices
Closet Bolt Set 5/16x3-1/2
Quick View
Closet Bolt Set 5/16x3-1/2
# C02025
Log in to see
prices
Closet Bolt Set Brass
Quick View
Closet Bolt Set Brass
# C02046
Log in to see
prices
Tip Toe Bath Drain 1-1/2
Quick View
Tip Toe Bath Drain 1-1/2
# P35062
Log in to see
prices
Tip Toe Bath Drain 1-3/8
Quick View
Tip Toe Bath Drain 1-3/8
# P35063
Log in to see
prices
Flange Toilet Brass 4"
Quick View
Flange Toilet Brass 4"
# C49441
Log in to see
prices
Linkage Assy Brass 1-1/4
Quick View
Linkage Assy Brass 1-1/4
# B51041
Log in to see
prices
Drain Shower 2"
Quick View
Drain Shower 2"
# D41007
Log in to see
prices
Flange Toilet Metal
Quick View
Flange Toilet Metal
# C85000
Log in to see
prices
J-Bend 1-1/2 Slip-Joint
Quick View
J-Bend 1-1/2 Slip-Joint
# P37015
Log in to see
prices
Marvel 1-1/2" PVC
Quick View
Marvel 1-1/2" PVC
# P37000
Log in to see
prices
Nut Slip-joint 1-1/4" WH PVC
Quick View
Nut Slip-joint 1-1/4" WH PVC
# T85125
Log in to see
prices
Nut Slipjoint 1-1/2" WH
Quick View
Nut Slipjoint 1-1/2" WH
# T85150
Log in to see
prices
Tailpiece 1-1/2x12 PVC
Quick View
Tailpiece 1-1/2x12 PVC
# P37028
Log in to see
prices
Tailpiece 1-1/2x16 PVC
Quick View
Tailpiece 1-1/2x16 PVC
# P37019
Log in to see
prices
Tee Branch 1-1/2 Pvc
Quick View
Tee Branch 1-1/2 Pvc
# P37009
Log in to see
prices
Toilet Flange 4"Pipe 3"depth
Quick View
Toilet Flange 4"Pipe 3"depth
# C40420
Log in to see
prices
Tube Ext 1-1/2X12" Slip
Quick View
Tube Ext 1-1/2X12" Slip
# P37022
Log in to see
prices
Washer Slip-joint 1-1/2 Beveled Poly 100/pk
Quick View
Washer Slip-joint 1-1/2 Beveled Poly 100/pk
# T80150
Log in to see
prices
Washer Slip-joint 1-1/2 Rubber 100/pk
Quick View
Washer Slip-joint 1-1/2 Rubber 100/pk
# T79150
Log in to see
prices
Washer Slip-joint 1-1/2 x 1-1/4 Poly 100/pk
Quick View
Washer Slip-joint 1-1/2 x 1-1/4 Poly 100/pk
# T80151
Log in to see
prices
Washer Slip-joint 1-1/2" Poly 100/pk
Quick View
Washer Slip-joint 1-1/2" Poly 100/pk
# T81150
Log in to see
prices
Washer Slip-joint 1-1/4 Beveled Poly 100/pk
Quick View
Washer Slip-joint 1-1/4 Beveled Poly 100/pk
# T80125
Log in to see
prices
Washer Slip-joint 1-1/4 Rubber 100/pk
Quick View
Washer Slip-joint 1-1/4 Rubber 100/pk
# T79125
Log in to see
prices
Waste Arm 1-1/2x16 PVC
Quick View
Waste Arm 1-1/2x16 PVC
# P37017
Log in to see
prices
Waste Arm 1-1/2x16" PVC
Quick View
Waste Arm 1-1/2x16" PVC
# P37016
Log in to see
prices
Extension Tube 1-1/2x12 Slip-Joint 22Ga
Quick View
Extension Tube 1-1/2x12 Slip-Joint 22Ga
# P38071
Log in to see
prices
Extension Tube 1-1/2x12 Threaded 20GA
Quick View
Extension Tube 1-1/2x12 Threaded 20GA
# P38083
Log in to see
prices
Extension Tube 1-1/2x6 Slip-Joint 20GA
Quick View
Extension Tube 1-1/2x6 Slip-Joint 20GA
# P38069
Log in to see
prices
Extension Tube 1-1/4x12 Threaded 20GA
Quick View
Extension Tube 1-1/4x12 Threaded 20GA
# P38080
Log in to see
prices
Flush Arm 10" CP handle
Quick View
Flush Arm 10" CP handle
# T01028
Log in to see
prices
Flush Arm 8" BN Universal
Quick View
Flush Arm 8" BN Universal
# T01422
Log in to see
prices
Flush Arm 8" CP Fit-All
Quick View
Flush Arm 8" CP Fit-All
# T01001
Log in to see
prices
Flush Arm 8" CP Fit-All
Quick View
Flush Arm 8" CP Fit-All
# T01002
Log in to see
prices
121 items    1  2  3