Back

SELECT o.options_id AS oid, o.model, o.description, o.us_out_of_stock AS stock, p.name, p.category, p.sh_desc, p.products_id AS pid, lower(p.title) AS title, us_ret AS price, us_ret_s AS special, DATE_FORMAT(c.ETA,'%b. %e/%y') AS ETA FROM products p, options o, prices_us c, categories cat WHERE o.product_id = p.products_id AND full_display = 'yes' AND lower(p.name) REGEXP '^[d-g]' AND p.us_active='yes' AND o.us_active = 'yes' AND c.prices_us_id = o.options_id AND cat.category = p.category ORDER BY cat.order_val, p.category, p.display_order, p.name, o.display_order
PRODUCT LISTING (77 products)
Product
Model
Price
 
Fitness
Fit Tube Back to Top
TFT-L
$12.45
Sold Out : Email Me
ETA: N/A
TFT-M
$13.45
Sold Out : Email Me
ETA: N/A
TFT-S
$14.45
Sold Out : Email Me
ETA: N/A
TFT-XS
$15.45
Sold Out : Email Me
ETA: N/A
TFT-PL
$17.95
Sold Out : Email Me
ETA: N/A
TFT-PM
$16.95
Buy Now! Add to Cart
TFT-PS
$19.95
Buy Now! Add to Cart
TFT-PXS
$20.95
Sold Out : Email Me
ETA: N/A
TFT-PXXS
$21.95
Buy Now! Add to Cart
TDA-100
$4.95
Buy Now! Add to Cart
Dumbbells Back to Top
VD-01
$3.45
Sold Out : Email Me
ETA: N/A
VD-02
$3.99
Buy Now! Add to Cart
VD-03
$5.65
Buy Now! Add to Cart
VD-04
$6.98
Buy Now! Add to Cart
VD-05
$8.49
Buy Now! Add to Cart
VD-06
$9.49
Buy Now! Add to Cart
VD-08
$12.99
Sold Out : Email Me
ETA: N/A
VD-10
$14.99
Sold Out : Email Me
ETA: N/A
VD-12
$18.99
Sold Out : Email Me
ETA: N/A
VD-15
$20.99
Sold Out : Email Me
ETA: N/A
Exercise Ball Accessories Back to Top
P-MP
$5.99
Buy Now! Add to Cart
B-SR
$17.95
Sold Out : Email Me
ETA: N/A
B-SS
$29.95
Buy Now! Add to Cart
Fit Band Back to Top
TFB-XL
$1.95
Buy Now! Add to Cart
TFB-L
$2.45
Buy Now! Add to Cart
TFB-M
$2.95
Buy Now! Add to Cart
TFB-S
$3.45
Buy Now! Add to Cart
TFB-XS
$3.95
Buy Now! Add to Cart
PRS-L
$6.99
Buy Now! Add to Cart
PRS-M
$7.99
Buy Now! Add to Cart
PRS-H
$9.45
Buy Now! Add to Cart
TFB-5XL
$6.95
Buy Now! Add to Cart
TFB-5L
$8.95
Buy Now! Add to Cart
TFB-5M
$9.95
Buy Now! Add to Cart
TFB-5S
$11.95
Buy Now! Add to Cart
TFB-5XS
$13.95
Buy Now! Add to Cart
TFB-25XL
$29.95
Buy Now! Add to Cart
TFB-25L
$39.95
Buy Now! Add to Cart
TFB-25M
$44.95
Buy Now! Add to Cart
TFB-25S
$54.95
Buy Now! Add to Cart
TFB-25XS
$64.95
Buy Now! Add to Cart
TDA-100
$4.95
Buy Now! Add to Cart
Fit Loops Back to Top
TFL-L
$3.95
Buy Now! Add to Cart
TFL-M
$4.95
Buy Now! Add to Cart
TFL-S
$5.45
Buy Now! Add to Cart
TFL-XS
$5.95
Buy Now! Add to Cart
Foam Roller Back to Top
FR-3F
$14.95
Buy Now! Add to Cart
FR-6H
$14.95
Sold Out : Email Me
ETA: N/A
FR-6F
$19.95
Buy Now! Add to Cart
Wellness
Ergo Sit™ Back to Top
ES-SILVER
$38.95
Buy Now! Add to Cart
ES-BLUE
$38.95
Sold Out : Email Me
ETA: N/A
Dynamint Muscle Balm Back to Top
DMB-100
$17.95
Buy Now! Add to Cart
EDR-100
$29.95
Buy Now! Add to Cart
Grip Fit Back to Top
GF-S
$5.95
Buy Now! Add to Cart
GF-F
$5.95
Buy Now! Add to Cart
GF-X
$5.95
Buy Now! Add to Cart
Videos & Books
Exercise books and posters Back to Top
E-HGD
$10.95
Buy Now! Add to Cart
E-HGM
$10.95
Buy Now! Add to Cart
E-HGS
$10.95
Buy Now! Add to Cart
E-HBB
$10.95
Buy Now! Add to Cart
E-HGY
$10.95
Buy Now! Add to Cart
E-HFR
$10.95
Buy Now! Add to Cart
E-HGK
$10.95
Buy Now! Add to Cart
E-DT-L
$25.95
Buy Now! Add to Cart
E-FM-L
$22.95
Buy Now! Add to Cart
E-FM-P
$10.95
Buy Now! Add to Cart
E-MM-L
$22.95
Buy Now! Add to Cart
E-MM-P
$10.95
Buy Now! Add to Cart
E-FH-L
$22.95
Buy Now! Add to Cart
E-FH-P
$10.95
Buy Now! Add to Cart
E-PE-L
$22.95
Buy Now! Add to Cart
E-PE-P
$10.95
Buy Now! Add to Cart
E-SL-L
$22.95
Buy Now! Add to Cart
E-SL-P
$10.95
Buy Now! Add to Cart
E-SU-L
$22.95
Buy Now! Add to Cart
E-SU-P
$10.95
Buy Now! Add to Cart
Exercise Ball DVD Back to Top
E-DVDBB
$17.95
Buy Now! Add to Cart