HUFFY DELIRIUM 16" BOYS SIDEWALK BICYCLE

Rating:

No Reviews | Write a review
Price:
List Price: TT$899.99
Our Price: TT$872.75 ( US$136.32 - Details)
You Save: TT$27.24
OUT OF STOCK:
Ships from and sold by TriniTrolley.com
Eligible for FREE Super TriniTrolley Shipping on orders over TT$499.99

Product Details

Colour: Matte Midnight Blue Frame: Steel straight Y Fork: Steel unicrown Brakes: Front and rear handbrakes with rear coaster Seat: Glossy Jr. padded seat with graphics Tyres: 16" x 1.95" Knobby Steel Rims: 20-spoke, Acid Yellow    ....

1021 - Disk full (/tmp/#sql-temptable-290bdb-e8c78b-d3ff8.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

SELECT p.products_model, pd.products_name, p.products_image, pd.products_description, p.products_id, p.products_price, p.products_tax_class_id, p.products_quantity FROM orders_products opb, orders o, products p , products_description pd WHERE opb.products_id != '0' AND opb.products_id = p.products_id AND opb.orders_id = o.orders_id AND p.products_status = '1' AND pd.products_id = p.products_id GROUP BY p.products_id ORDER BY rand(), o.date_purchased DESC LIMIT 50

[TEP STOP]