Lamp

Lamp

Product Image Qty. Item Name Price+
UX25951 OEM Equivalent Hitachi Lamp 0

UX25951 OEM Equivalent Hitachi Lamp

Repalcement TV Lamp for Hitachi models 50VS69A, 55VS69, 55VS69A, 62VS69, 62VS69A. Fits with compatible part number: UX25951 Lamp Life -...
Price Unavailable



A-1085-447-A-ER Compatible Sony Lamp 12

A-1085-447-A-ER Compatible Sony Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models ]KDF55WF655, KDF55XS955, KDF60WF655, KDF60XS955, KDFE55A20, KDFE60A20,...
Price Unavailable



A-1606-034-B-ER Compatible Sony Lamp 12

A-1606-034-B-ER Compatible Sony Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models KF-42WE610, KF-50WE610, KF-60WE610, KDF-60XBR950, KDF-70XBR950, KDF-50WE655...
Price Unavailable



BP96-00826A-ER Compatible Samsung Lamp 6

BP96-00826A-ER Compatible Samsung Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Samsung TV models: HLP4663W, HLP4667W, HLP5067W, HLP5663W, HLP5667W, HLP6163W, HLP6167W,...
Price Unavailable



BP96-01073A-ER Compatible Samsung Lamp 17

BP96-01073A-ER Compatible Samsung Lamp

Compatible Replacement TV Lamp for Samsung models : HLR4264W, HLR4266W, HLR4266WX/XAA, HLR1331WX/XAC HLR4HLR4667W, HLR5056WX/XAA, HLR5064W,...
Price Unavailable



F-9308-750-0-ER Compatible Sony Lamp 18

F-9308-750-0-ER Compatible Sony Lamp

Compatible Replacement TV Lamp for Sony KDF42E2000, KDF46E2000, KDF50E2000, KDF50E2010, KDF50EA11, KDF55E2000, KDFE42A10, KDFE42A11, KDFE42A11E,...
Price Unavailable



F-9308-760-0-ER Compatible Sony Lamp 0

F-9308-760-0-ER Compatible Sony Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Sony models KDSR50XBR1, KDSR60XBR1, KDS60R2000. This lamp comes with complete outer...
Price Unavailable



TS-CL110UAA-ER Compatible JVC Lamp 12

TS-CL110UAA-ER Compatible JVC Lamp

Replacementy TV Lamp made with high quality UHR bulb for JVC models HD-52G456, HD-52G587, HD-52G657, HD-52G786, HD-52G787, HD-52G886, HD-52G887,...
Price Unavailable



TY-LA1000-ER Compatible Panasonic Lamp 11

TY-LA1000-ER Compatible Panasonic Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for Panasonic models PT43LC14, PT43LCX64, PT44LCX65, PT50LC13, PT50LC14, PT50LCX63,...
Price Unavailable



TY-LA1500-ER Compatible Panasonic Lamp 6

TY-LA1500-ER Compatible Panasonic Lamp

Replacement TV Lamp made with an OEM compatible UHR bulb for models PT40LC12, PT40LC13, PT45LC12. This lamp comes with complete outer housing unit...
Price Unavailable




1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'p.products_image NOT IN('no_picture.gif','none.gif')' at line 9
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_date_added, p.products_price from e_products p left join e_specials s on p.products_id = s.products_id, e_products_to_categories p2c, e_categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '11694' and p.products_status = 1 and p.products_image p.products_image NOT IN('no_picture.gif','none.gif') ]