Electronics Castle Contact MethodsElectronics Castle Payment MethodsCOMODO Secured Seal
Shopping Cart:

now in your cart 0 items
Categories
Heading LeftHeading Right
Spacer

HP Consumer Refurbished

HP Consumer Refurbished
Spacer

HP Consumer Refurbished manufacturer section added on Saturday 25 September, 2010 with products in our discontinued, desktop pcs, desktops all-in-one, and notebooks a total of 5 categories.

Heading LeftHeading Right
SpacerElectronics Castle » HP Consumer Refurbished
Show: 
Content Wrapper BL
Displaying 1 to 99 (of 179 products)Result Pages:  1  2  [Next >>] 
1030 - Got error 122 from storage engine

select p.products_image, pd.products_name, c.parent_id, cd.categories_name, cd.categories_id, p2c.categories_id as catid, p2c.products_id, p.products_id, m.manufacturers_name, pd.products_description_short, pd.products_description, p.manufacturers_id, products_weight, p.products_quantity, p.products_dandh, p.products_msrp, products_weight, p.products_quantity, p.products_dandh, p.products_model, p.products_upc, p.products_vnd_num, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join specials s on p.products_id = s.products_id, products_description pd, manufacturers m, products_to_categories p2c, categories c, categories_description cd where p.products_status = '1' and p.products_id = p2c.products_id and cd.categories_id = p2c.categories_id and c.categories_id = cd.categories_id and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '671' order by pd.products_name limit 0, 99

[TEP STOP]