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 '^[a-c]' 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 (17 products)
Product
Model
Price
 
Fitness
Ankle Tube Back to Top
TAT-L
$13.45
Buy Now! Add to Cart
TAT-S
$14.65
Buy Now! Add to Cart
Balance Fit Back to Top
BF-Blue
$19.95
Buy Now! Add to Cart
Body Toning Bars Back to Top
BTB-06
$29.98
Buy Now! Add to Cart
BTB-09
$37.98
Buy Now! Add to Cart
BTB-12
$44.98
Buy Now! Add to Cart
BTB-15
$52.98
Buy Now! Add to Cart
BTB-18
$59.98
Buy Now! Add to Cart
BTB-24
$74.98
Buy Now! Add to Cart
Balance Pod Back to Top
BP-S
$7.95
Buy Now! Add to Cart
BP-2
$14.95
Buy Now! Add to Cart
BP-6
$39.95
Buy Now! Add to Cart
BOSU® Fitness Back to Top
BOSU-Pro
$169.95
Buy Now! Add to Cart
BOSU-BB
$59.95
Buy Now! Add to Cart
Chin Up Bar Back to Top
TCB
$49.98
Buy Now! Add to Cart
TCB-S
$9.98
Buy Now! Add to Cart
Clearance Products
Agility Training Back to Top
AP-6
$69.95
$39.95
Buy Now! Add to Cart