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 ('113')) 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 '%Telephones' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Telephones' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Telephones' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Telephones"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Telephones"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Telephones"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Telephones"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Telephones' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Telephones',`category_4` ='Telephones') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Telephones,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Telephones', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Telephones

Refine Search

  GO
 
Brand

RCA(15)

AT&T(14)

Vtech(10)

Spracht(3)

Plantronics(1)

Jabra(1)

 
Color(s)

Black/Silver(24)

Black(10)

Silver/Black(4)

White(4)

Charcoal(2)

 
Manufacturer Part Number

U1100(1)

U1200(1)

CP2018(1)

CP3010(1)

U1000SET(1)

U1000(1)

25260(1)

25424RE1(1)

25425RE1(1)

H5401RE1(1)

CP3012(1)

CS6114(1)

DS6101(1)

DS6151(1)

LS6405(1)

LS6425-3(1)

CS6629-3(1)

CS66192(1)

CS6124(1)

CS6609(1)

CS6619(1)

25255RE2(1)

25252(1)

ML17929(1)

ML17939(1)

SB67108(1)

SB67138(1)

CL4940(1)

CL2940(1)

1070(1)

210B(1)

210W(1)

TL86009(1)

TL86109(1)

21623BKGA(1)

25055RE1(1)

25201RE1(1)

25212(1)

21621BKGA(1)

CT14(1)

TL88002(1)

TL88102(1)

7410109(1)

1040(1)

 
Country of Origin

CN(44)

 
For Use With

RCA U1000 and RCA U1100(1)

U1000; U1200(1)

Standard Phone Line; Analog PBX; Bluetooth; VoIP(1)

CS6629; CS6649(1)

LS6425-3 Phone System(1)

DS6151(1)

U10002DS; U10002HS(1)

RCA Unison U1100; RCA Unison U1200(1)

TL88102(1)

TL86109(1)

25250RE1; 25210RE1; 25255RE2(1)

25212; 25252; 25255RE2; 25270RE3; 25055RE1(1)

25423RE1;25424RE1;25425RE1(1)

SynJ System(1)

 
Model Name/Number

Unison U1000 SET(1)

RCA U1100(1)

RCA U1200(1)

Aura SoHo Plus(1)

RCA U1000(1)

H5401RE1(1)

ViSYS 25260(1)

ViSYS 25424RE1(1)

ViSYS 25425RE1(1)

CP3010(1)

CS6114(1)

DS6101(1)

DS6151(1)

LS6405(1)

LS6425-3(1)

CS6629-3(1)

CS6609-2(1)

CS6124(1)

CS6609(1)

CS6619(1)

ViSYS 25255RE2(1)

25252(1)

ML17929(1)

ML17939(1)

SB67108(1)

SB67138(1)

CL4940(1)

CL2940(1)

1070(1)

210B(1)

210W(1)

TL86009(1)

TL86109(1)

RCA 2162-3(1)

25055RE1(1)

RCA 25201RE1(1)

25212(1)

RCA 2162-1(1)

CT14(1)

TL88002(1)

TL88102(1)

SPEAK 410(1)

1040(1)

 
Display Type(s)

LCD(36)

Backlit LCD(2)

LED(1)

 
Frequency

1.9 GHz(25)

DECT 6.0(3)

 
Lines

1(15)

2(14)

4(8)

1-4(3)

 
Speed Dial Memories

10(8)

50(5)

100(4)

30(4)

94(3)

200(2)

20(1)

25(1)

9(1)

3(1)

18(1)

99(1)

 
Maximum Wireless Range

1000 ft(6)

800 ft(2)

Varies depending on location and environment(1)

20 ft x 20 ft(1)

300 ft(1)

 
Speakerphone

Base(13)

Handset(12)

Base; Handset(7)

Deskset(1)

 
Telephone Type

Cordless(23)

Corded(11)

Corded; Cordless(6)

Desktop Conference Phone(1)

Conferencing(1)

Speakerphone(1)

 
Volume Control

Handset(14)

Base(9)

Base; Handset(9)

Speakerphone(3)

Handset; Ringer; Speakerphone(3)

Dialpad(1)

 
Caller ID Features

Name/Number Display(28)

Automatic Date and Time Set; Call Waiting; Dial Back Function; Review and Delete(3)

Caller ID History(1)

Call Waiting; Dial Back Function; Review and Delete(1)

Automatic Date and Time Set; Call Waiting Caller ID; Caller ID Format and Dial-Back Function; Caller ID Handset Memory; Caller ID Review and Delete(1)

Caller ID History; Memory Match(1)

Automatic Date and Time Set; Call Waiting; Caller ID Format; Caller ID Handset Memory; Dial Back Function; Review and Delete(1)

Call Waiting; Dial Back Function; Name/Number Display; Review and Delete(1)

 
Caller ID/Type

Standard Display(14)

Handset(13)

Call Waiting(6)

Handset Display(1)

Base Display(1)

LED Display(1)

Base Display; Handset Display(1)

Deskset(1)

 
Caller ID Locations

Caller Location Displayed(14)

Base; Handset(7)

Base(6)

Handset(5)

10(2)

Dialpad(1)

 
Intercom

Yes(33)

No(5)

 
Memory/Redial

5(8)

10(5)

20(4)

1(3)

3(3)

6(2)

Yes(2)

75(1)

99(1)

 
Conferencing

3-Way(19)

Yes(3)

Conference Between an Outside Line and Up to 2 Handsets(2)

No(2)

6-Way(2)

2-Line(2)

Conference Between an Outside Line and Up to 4 Handsets(2)

Conference Handset to Base(1)

Conference between an outside line and up to 4 cordless handsets(1)

Conference between an outside line and up to 2 cordless Handsets.(1)

 
Paging

Yes(25)

No(3)

 
Multi-Handset Capability

Up to 10(5)

Up to 16(4)

Up to 12(4)

Up to 5(3)

Up to 9(3)

Up to 4(2)

Up to 2(1)

 
Recording Time

14 min(5)

200 min(3)

60 min(3)

15 min(2)

13 min(1)

180 min(1)

24 min(1)

12 min(1)

 
Answering System

Digital(16)

No(1)

 
Optional Additional Handset(s)

25055RE1(3)

U1100; U1200(2)

Yes(2)

H5401RE1(2)

VTECS6609(1)

DS6101(1)

VTELS6405(1)

Expandable up to 9 Units(1)

U1100(1)

SB67108; SB67148(1)

TL86009(1)

ATTTL88002(1)

 
Answering System Features

Call Screening/Intercept; Message Time/Day Stamp; Memo Recording; Remote Access; Voice Prompts(2)

Call Screening; Digital Answering System; Remote Access; Time Stamp; Voice Date(2)

Up to 14 Minutes of Digital Recording Time(1)

Message Time/Day Stamp; Remote Access(1)

10 Message Mailboxes; Digital Receptionist; Message Counter; New Message Indicator; Remote Message Retrieval; Up to 200 Minutes of Recording Time; Voice Prompts; Voice Time/Day Stamp(1)

10 Message Mailboxes; Call Screening; Digital Receptionist; Message Time/Day Stamp; Remote Access; Remote Message Retrieval; Up to 200 Minutes of Recording Time; Voice Menu System; Voice Prompts; Voice Time/Day Stamp(1)

Call Screening; Toll Saver(1)

Auto Attendant; Call Screening/Intercept; Message Time/Day Stamp; Memo Recording; Remote Access; Voice Prompts(1)

Call Screening; Digital Recording; Message Indicator; Toll Saver(1)

 
Additional Handsets Included

1(4)

2(3)

3(1)

 
Wall-Mountable

Yes(19)

No(7)

 
Display

4-Line(12)

Backlit(8)

Backlit Display(5)

Blue Backlit(3)

5-Line(3)

3-Line(2)

2"(1)

Large Tilt Backlit(1)

 
One Touch Presets

10(5)

16(2)

32(2)

20(1)

18(1)

3(1)

9(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved