Banner1 Banner1
 
SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('114051')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%LCDTelevisions' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('LCDTelevisions' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+LCDTelevisions' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"LCDTelevisions"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"LCDTelevisions"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"LCDTelevisions"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"LCDTelevisions"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+LCDTelevisions' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='LCDTelevisions',`category_4` ='LCDTelevisions') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'LCDTelevisions,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('LCDTelevisions', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

LCD Televisions

Refine Search

  GO
 
Brand

Samsung(23)

 
Color

Titan Gray(12)

Black(10)

Charcoal Black(5)

Glossy Black(1)

 
Limited Warranty

1 Year(13)

12 Month(10)

 
Weight (Approximate)

45.40 lb(3)

25.10 lb(2)

17.90 lb(2)

30.60 lb(2)

35.70 lb(1)

79.40 lb(1)

9.26 lb(1)

21.20 lb(1)

30 lb(1)

38.10 lb(1)

42.10 lb(1)

44.50 lb(1)

55.10 lb(1)

56.40 lb(1)

67 lb(1)

 
Input Voltage

120 V AC(23)

 
USB

Yes(23)

 
Wireless LAN

Yes(23)

 
Ethernet

Yes(23)

 
HDMI

Yes(23)

 
Operating Power Consumption

120 W(4)

135 W(3)

125 W(2)

105 W(2)

140 W(2)

190 W(2)

230 W(2)

110 W(1)

155 W(1)

200 W(1)

48 W(1)

160 W(1)

170 W(1)

 
RMS Output Power

20 W(22)

10 W(1)

 
Maximum Resolution

3840 x 2160(22)

1366 x 768(1)

 
Streaming Service

Amazon Prime(22)

Google Play Movies & TV(22)

YouTube(22)

Netflix(21)

Hulu(17)

VUDU(16)

ESPN(15)

Disney+(10)

Spotify(5)

Deezer(5)

AirPlay(5)

Airplay 2(5)

HBO NOW(2)

 
Energy Consumption per Year

120 kWh(3)

129 kWh(3)

94 kWh(2)

102 kWh(2)

147 kWh(2)

105 kWh(1)

125 kWh(1)

53 kWh(1)

111 kWh(1)

131 kWh(1)

116 kWh(1)

138 kWh(1)

156 kWh(1)

144 kWh(1)

182 kWh(1)

189 kWh(1)

 
Weight with Stand (Approximate)

46.10 lb(3)

25.60 lb(2)

18.30 lb(2)

31.30 lb(2)

36.20 lb(1)

80 lb(1)

9.48 lb(1)

21.60 lb(1)

30.60 lb(1)

39 lb(1)

43 lb(1)

45.20 lb(1)

56.20 lb(1)

57.50 lb(1)

67.90 lb(1)

 
Width with Stand

37.90"(3)

44"(3)

48.40"(3)

57.10"(3)

44.30"(2)

48.70"(2)

66"(1)

28.85"(1)

38.20"(1)

51.20"(1)

57.30"(1)

65.90"(1)

41.30"(1)

 
Backlight Technology

LED(11)

Quantum Dot LED(5)

Edge LED(5)

Ultra Slim Array(2)

 
Depth with Stand

10.30"(4)

9.60"(2)

9.80"(2)

9.90"(2)

13.40"(2)

7.70"(1)

11.40"(1)

13.90"(1)

6.44"(1)

8.30"(1)

7.90"(1)

7.60"(1)

9.30"(1)

13.10"(1)

11.20"(1)

11.10"(1)

 
Height with Stand

24.80"(2)

35.70"(2)

28.70"(2)

30.60"(2)

31.20"(1)

41.10"(1)

35.60"(1)

35.40"(1)

32.90"(1)

30.80"(1)

28.10"(1)

28.30"(1)

28.40"(1)

24.70"(1)

25.10"(1)

18.22"(1)

41.30"(1)

30.90"(1)

65.90"(1)

 
Scan Format

2160p(22)

720p(1)

 
Manufacturer Part Number

QN43Q60TAFXZA(1)

UN55RU7100FXZA(1)

UN75TU7000FXZA(1)

UN65TU8000FXZA(1)

UN65TU7000FXZA(1)

UN65RU8000FXZA(1)

UN65RU7100FXZA(1)

UN58RU7100FXZA(1)

UN55TU8000FXZA(1)

UN55TU7000FXZA(1)

UN55RU8000FXZA(1)

UN50TU8000FXZA(1)

QN50Q60TAFXZA(1)

UN50TU7000FXZA(1)

UN50RU7100FXZA(1)

UN43TU8000FXZA(1)

UN43TU7000FXZA(1)

UN43RU7100FXZA(1)

UN32M4500BFXZA(1)

QN75Q60TAFXZA(1)

QN65Q60TAFXZA(1)

QN55Q60TAFXZA(1)

UN75TU8000FXZA(1)

 
Country of Origin

Mexico(10)

 
Height

22"(3)

27.8"(3)

25.4"(2)

28.1"(2)

32.7"(2)

25.3"(1)

32.6"(1)

37.8"(1)

17.3"(1)

22.2"(1)

25.6"(1)

29.8"(1)

33"(1)

32.9"(1)

37.7"(1)

65.9"(1)

 
Width

37.9"(3)

44"(3)

48.4"(3)

57.1"(3)

48.7"(2)

66"(1)

28.9"(1)

38.2"(1)

44.3"(1)

51.2"(1)

57.4"(1)

57.3"(1)

65.9"(1)

37.7"(1)

 
Depth

2.3"(11)

2.4"(11)

3.1"(1)

 
Aspect Ratio

16:9(23)

 
Sound System

Dolby(12)

Dolby Audio(10)

Dolby Digital(7)

Dolby Digital Plus(1)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved