Log Out
My Cart (0)
My Shopping Cart
Your shopping cart is empty
 
Show Only Items Ordered Previously

Customers Log In

 
Home/ Brands/ Jones Stephens

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 
Flush Arm 8" CP Fit-All Heavy Duty
Quick View
Flush Arm 8" CP Fit-All Heavy Duty
# T01005
Log in to see
prices
Flush Arm 8" CP Universal
Quick View
Flush Arm 8" CP Universal
# T01420
Log in to see
prices
Flush Arm 8" MB
Quick View
Flush Arm 8" MB
# T0105WB
Log in to see
prices
Flush Arm 8" ORB
Quick View
Flush Arm 8" ORB
# T0105RB
Log in to see
prices
Flush Arm 8-1/2 BN
Quick View
Flush Arm 8-1/2 BN
# T01007
Log in to see
prices
Flush Arm 8-1/2" CP Universal
Quick View
Flush Arm 8-1/2" CP Universal
# T01000
Log in to see
prices
Flush Arm 9" CP Eljer
Quick View
Flush Arm 9" CP Eljer
# T01020
Log in to see
prices
P-Trap 1-1/2" 17Ga
Quick View
P-Trap 1-1/2" 17Ga
# P38006
Log in to see
prices
P-Trap 1-1/2" 22Ga CP
Quick View
P-Trap 1-1/2" 22Ga CP
# P38004
Log in to see
prices
P-Trap 1-1/4" 17Ga
Quick View
P-Trap 1-1/4" 17Ga
# P38003
Log in to see
prices
P-Trap 1-1/4" 22Ga CP
Quick View
P-Trap 1-1/4" 22Ga CP
# P38001
Log in to see
prices
Tailpiece 1-1/2x6 Chrome
Quick View
Tailpiece 1-1/2x6 Chrome
# P38055
Log in to see
prices
Wall Bend 1-1/4x7 22Ga
Quick View
Wall Bend 1-1/4x7 22Ga
# P38041
Log in to see
prices
Waste Arm 1-1/2x15" 22Ga
Quick View
Waste Arm 1-1/2x15" 22Ga
# P38117
Log in to see
prices
Waste Arm 1-1/2x16 S/J
Quick View
Waste Arm 1-1/2x16 S/J
# P38040
Log in to see
prices
Fill Valve Integral Float Adjustable
Quick View
Fill Valve Integral Float Adjustable
# T02070
Log in to see
prices
Flush Valve 2" w/Flapper
Quick View
Flush Valve 2" w/Flapper
# C05070
Log in to see
prices
End Cap Hose 3/4" brass
Quick View
End Cap Hose 3/4" brass
# G20155
Log in to see
prices
Flange 5/8"OD 1/2"Nom
Quick View
Flange 5/8"OD 1/2"Nom
# E01050
Log in to see
prices
Strainer Floor Drain 3"
Quick View
Strainer Floor Drain 3"
# D59001
Log in to see
prices
Strainer Floor Drain 4"
Quick View
Strainer Floor Drain 4"
# D59002
Log in to see
prices
121 items ◀   1  2  3