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 '^[r-t]' 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 (15 products)
Product
Model
Price
 
Fitness
Swiss Exercise Ball Back to Top
EB-65
$44.95
Buy Now! Add to Cart
EB-75
$49.95
Buy Now! Add to Cart
P-MP
$5.99
Buy Now! Add to Cart
Swiss Pro Ball Back to Top
PB-55
$48.95
$39.15
Buy Now! Add to Cart
PB-65
$53.95
$43.15
Buy Now! Add to Cart
PB-65S
$53.95
$43.15
Buy Now! Add to Cart
PB-75
$55.95
$44.75
Buy Now! Add to Cart
P-MP
$5.99
Buy Now! Add to Cart
Step Tube Back to Top
TST-L
$9.95
Buy Now! Add to Cart
Super Bands Back to Top
TSB-L
$22.95
Buy Now! Add to Cart
TSB-M
$27.95
Buy Now! Add to Cart
TSB-S
$34.95
Buy Now! Add to Cart
Therastickô Back to Top
TS-M
$79.95
Buy Now! Add to Cart
Videos & Books
Resistance Tubing DVD Back to Top
E-DVDRT
$17.95
Buy Now! Add to Cart
Clearance Products
Thermal Sand Bed Back to Top
SND-500D
$1,499.00
Buy Now! Add to Cart