Warning Warning: I am able to write to the configuration file: /home/to1chir/public_html/catalog/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.
1to1Chiropractic.com My Account  Cart Contents  Checkout  
  Top » Catalog » Weight Training Equipment » My Account  |  Cart Contents  |  Checkout   
Categories
Balance & Core Training (7)
Body Toning Bars (6)
Books (5)
Ergonomic Sitting Products (3)
Exercise Balls (10)
Exercise Bands, Tubing & Accesso (40)
Heat/Cold Therapy Products (2)
Ionized Water (4)
Massage Chairs (6)
Massage Products (4)
Medicine Balls (10)
Pilates Mats & Accessories (8)
Pillows & Supports (6)
Topical Applications (2)
Weight Training Equipment (27)
Manufacturers
What's New? more
The Great Dumbbell Handbook
The Great Dumbbell Handbook
$10.95
Quick Find
 
Use keywords to find the product you are looking for.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Vinyl Dumbbell, 7 lbs. Red $10.79

Versatile exercise equipment

Perfect for aerobics or light lifting at home, heavier lifting or bodybuilding and toning, strenghtening, relieving stress and reducing common aches and pains. With fast weight changes (ProBell & VersaBell), and our TheraGearô vinyl coated dumbbells provide effective cross training, promote increased calorie burn... and enhance cardiovascular fitness.

Dumbbells are sold as singles

7 lb. Vinyl dumbbell, Red

This product was added to our catalog on Wednesday 13 October, 2004.
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'to1chir_db1.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '202' and opa.orders_id = opb.orders_id and opb.products_id != '202' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]