Cart Contents (2)
Checkout
My Account
Top
»
Catalog
»
PRECOR Precore
»
PC942-FR
$573.36
$349.99
Precor C942 C944 C 942 944 Front Drive Head Roller Refurbished
[PC942-FR]
FREE DELIVERY !
Local Area
TEXT or CALL ... (972) 488-3222
or LOCAL STORE PICKUP for a Discount !
Order Online and choose "Check" at checkout then pay only for the goods upon receiving them.
Warranty: 365 days
Fits the following models:
Precor Precore
C942 (2M, 5L)
C944 - 120 VAC, version 1 (E5)
C944 - 120 VAC, version 2 (1U, 5J)
C944 - 240 VAC, version 1 (E6)
C944 - 240 VAC, version 2 (1V, 5K)
Add to Cart
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'fitness_osc23.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 = '2403' and opa.orders_id = opb.orders_id and opb.products_id != '2403' 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 15
[TEP STOP]