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') 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(13)

 
Color

Charcoal Black(9)

Titan Gray(2)

Glossy Black(1)

Black(1)

Dark Titan(1)

 
Limited Warranty

12 Month(2)

Lifetime(1)

 
Weight (Approximate)

9.26 lb(1)

17 lb(1)

18.96 lb(1)

21.20 lb(1)

29.98 lb(1)

30 lb(1)

38.14 lb(1)

38.10 lb(1)

42.10 lb(1)

44.50 lb(1)

55.12 lb(1)

55.10 lb(1)

56.40 lb(1)

 
Input Voltage

120 V AC(13)

 
USB

Yes(13)

 
Wireless LAN

Yes(13)

 
Ethernet

Yes(13)

 
HDMI

Yes(13)

 
Operating Power Consumption

135 W(2)

120 W(2)

140 W(2)

48 W(1)

115 W(1)

90 W(1)

105 W(1)

180 W(1)

160 W(1)

170 W(1)

 
RMS Output Power

20 W(12)

10 W(1)

 
Maximum Resolution

3840 x 2160(12)

1366 x 768(1)

 
Streaming Service

YouTube(12)

Google Play Movies & TV(12)

Netflix(11)

Amazon Prime(11)

Spotify(9)

Deezer(5)

Hulu(3)

HBO NOW(3)

Amazon Instant Video(1)

VUDU(1)

 
Energy Consumption per Year

129 kWh(2)

53 kWh(1)

84 kWh(1)

102 kWh(1)

111 kWh(1)

138 kWh(1)

147 kWh(1)

156 kWh(1)

 
Weight with Stand (Approximate)

9.48 lb(1)

19.20 lb(1)

19.40 lb(1)

21.60 lb(1)

30.64 lb(1)

30.60 lb(1)

39.02 lb(1)

39 lb(1)

43 lb(1)

45.20 lb(1)

56.22 lb(1)

56.20 lb(1)

57.50 lb(1)

 
Width with Stand

44.30"(2)

48.70"(2)

28.85"(1)

36.10"(1)

35.97"(1)

38.20"(1)

44.28"(1)

48.76"(1)

51.20"(1)

57.38"(1)

57.30"(1)

 
Backlight Technology

LED(6)

Edge LED(5)

Ultra Slim Array(2)

 
Depth with Stand

10.30"(4)

10.29"(2)

6.44"(1)

11.30"(1)

8.28"(1)

8.30"(1)

9.30"(1)

12.31"(1)

13.10"(1)

 
Height with Stand

28.70"(2)

18.22"(1)

23.50"(1)

23.79"(1)

25.10"(1)

28.69"(1)

31.21"(1)

31.20"(1)

30.60"(1)

32.90"(1)

36.11"(1)

35.40"(1)

 
Scan Format

2160p(12)

720p(1)

 
Manufacturer Part Number

UN32M4500BFXZA(1)

UN40MU6300FXZA(1)

UN40NU7100FXZC(1)

UN43RU7100FXZA(1)

UN50NU7100FXZC(1)

UN50RU7100FXZA(1)

UN55NU7100FXZC(1)

UN55RU7100FXZA(1)

UN55RU8000FXZA(1)

UN58RU7100FXZA(1)

UN65NU7100FXZC(1)

UN65RU7100FXZA(1)

UN65RU8000FXZA(1)

 
Country of Origin

Mexico(5)

 
Height

28.1"(3)

25.6"(2)

33"(2)

17.3"(1)

21.1"(1)

20.9"(1)

22.2"(1)

29.8"(1)

32.9"(1)

 
Width

48.7"(2)

44.3"(2)

57.4"(2)

28.9"(1)

36.1"(1)

36"(1)

38.2"(1)

48.8"(1)

51.2"(1)

57.3"(1)

 
Depth

2.3"(9)

2.4"(2)

3.1"(1)

2.5"(1)

 
Aspect Ratio

16:9(13)

 
Sound System

Dolby(7)

Dolby Digital(7)

Dolby Digital Plus(6)

DTS Premium Sound 5.1(1)

 
 
 
 
 

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