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','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 '%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(16)

AT&T(14)

Vtech(10)

Motorola(4)

Spracht(2)

Jabra(1)

poly(1)

 
Color(s)

Black/Silver(28)

Black(10)

White(4)

Silver/Black(4)

Charcoal(2)

 
Manufacturer Part Number

1040(1)

CP3010(1)

25424RE1(1)

25425RE1(1)

H5401RE1(1)

U1000(1)

U10002DS(1)

U10002HS(1)

U1000SET(1)

U1100(1)

U1200(1)

CP3012(1)

25255RE2(1)

CS6114(1)

CS6124(1)

CS6609(1)

CS6619(1)

CS66192(1)

CS6629-3(1)

DS6101(1)

DS6151(1)

LS6405(1)

25260(1)

25254(1)

1070(1)

TL86109(1)

210B(1)

210W(1)

CL2940(1)

CL4940(1)

ML17929(1)

ML17939(1)

SB67108(1)

SB67138(1)

TL86009(1)

TL88002(1)

25252(1)

TL88102(1)

7410109(1)

CD4011(1)

CD4012(1)

O211(1)

O212(1)

CT14(1)

25055RE1(1)

25201RE1(1)

25212(1)

LS6425-3(1)

 
Country of Origin

CN(48)

 
For Use With

SynJ System(1)

U10002DS; U1000SET(1)

DS6151(1)

Vtech CS6629, CS6649(1)

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

RCA U1000 and RCA U1100(1)

U1000; U1200(1)

U10002DS; U10002HS(1)

U10002HS; U1000SET(1)

TL86109(1)

RCA Unison U1100; RCA Unison U1200(1)

25423RE1;25424RE1;25425RE1(1)

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

RCA25055RE1; RCA25260(1)

25250RE1; 25210RE1; 25255RE2(1)

AT&T TL88102(1)

LS6425-3 Phone System(1)

 
Model Name/Number

1040(1)

RCA U1200(1)

ViSYS 25260(1)

ViSYS 25424RE1(1)

ViSYS 25425RE1(1)

H5401RE1(1)

RCA U1000(1)

Unison U1000 2DS(1)

Unison U1000 2HS(1)

Unison U1000 SET(1)

RCA U1100(1)

CP3010(1)

RCA 25254RE1(1)

CS6114(1)

CS6124(1)

CS6609(1)

CS6619(1)

CS6609-2(1)

CS6629-3(1)

DS6101(1)

DS6151(1)

LS6405(1)

ViSYS 25255RE2(1)

25252(1)

1070(1)

TL86109(1)

210B(1)

210W(1)

CL2940(1)

CL4940(1)

ML17929(1)

ML17939(1)

SB67108(1)

SB67138(1)

TL86009(1)

TL88002(1)

25212(1)

TL88102(1)

SPEAK 410(1)

MTRCD4011(1)

MTRCD4012(1)

MTR0211(1)

MTR0212(1)

CT14(1)

25055RE1(1)

RCA 25201RE1(1)

LS6425-3(1)

 
Display Type(s)

LCD(43)

LED(1)

 
Frequency

1.9 GHz(25)

DECT 6.0(8)

 
Lines

1(17)

2(15)

4(10)

1-4(3)

 
Speed Dial Memories

10(9)

30(6)

50(5)

100(4)

3(3)

9(3)

94(3)

200(2)

25(1)

18(1)

99(1)

20(1)

 
Maximum Wireless Range

1000 ft(6)

Up to 1000 ft(2)

Outdoors: 2000 ft; Indoors: 650 ft(2)

800 ft(2)

300 ft(1)

Varies depending on location and environment(1)

 
Speakerphone

Handset(16)

Base(15)

Base; Handset(7)

Deskset(1)

 
Telephone Type

Cordless(25)

Corded(14)

Corded; Cordless(6)

Speakerphone(1)

Desktop Conference Phone(1)

 
Volume Control

Handset(18)

Base; Handset(11)

Base(10)

Handset; Ringer; Speakerphone(3)

Speakerphone(2)

Dialpad(1)

 
Caller ID Features

Name/Number Display(29)

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

Name/Number; Time/Date(4)

Caller ID History; Memory Match(1)

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

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

Caller ID History(1)

 
Caller ID/Type

Handset(17)

Standard Display(14)

Call Waiting(4)

Base Display; Handset Display(3)

Deskset(1)

Base(1)

LED Display(1)

Base Display(1)

Handset Display(1)

 
Caller ID Locations

Caller Location Displayed(14)

Handset(9)

Base; Handset(9)

Base(7)

Dialpad(1)

 
Intercom

Yes(37)

No(5)

 
Memory/Redial

5(8)

10(7)

20(6)

99(4)

1(3)

3(3)

6(2)

75(1)

Yes(1)

 
Conferencing

3-Way(23)

6-Way(4)

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

2-Line(2)

Yes(2)

No(2)

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

4-Way(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)

Conference Handset to Base(1)

 
Paging

Yes(30)

No(3)

 
Multi-Handset Capability

Up to 10(6)

Up to 9(5)

Up to 16(4)

Up to 12(4)

Up to 5(3)

Up to 2(1)

 
Recording Time

200 min(5)

14 min(5)

60 min(4)

12 min(3)

25 min(2)

24 min(1)

180 min(1)

13 min(1)

 
Answering System

Digital(21)

No(1)

 
Optional Additional Handset(s)

U1100; U1200(4)

25055RE1(3)

H5401RE1(2)

SB67108; SB67148(1)

TL86009(1)

ATTTL88002(1)

RCA25055RE1; RCA25260(1)

U1100(1)

Expandable up to 9 Units(1)

VTECS6609(1)

DS6101(1)

VTELS6405(1)

 
Answering System Features

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

Call Screening; Call Intercept; Up to 12 Minutes Record Time; Remote Message Retrieval; Private Playback Via Handset(2)

Up to 25 Minutes Record Time; Call Screening; Call Intercept; Remote Access Retrieval; Message Counter; Private Playback Via Handset(2)

Call Screening; Digital Recording; Message Indicator(2)

2 Message Mailboxes; Call Screening; Digital Recording; Message Counter; New Message Indicator; Up to 60 Minutes Recording Time; Remote Message Retrieval: Voice Menu System: 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)

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; Digital Recording; Message Indicator; Toll Saver(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)

Up to 14 Minutes of Digital Recording Time(1)

Message Time/Day Stamp; Remote Access(1)

 
Additional Handsets Included

1(6)

2(4)

3(1)

 
Wall-Mountable

Yes(24)

No(7)

 
Display

4-Line(12)

Backlit(8)

Backlit Display(5)

5-Line(3)

Blue Backlit(3)

2"(3)

1.6" Blue Backlit(2)

1.8" Color Backlit(2)

3-Line(2)

Large Tilt Backlit(1)

2" Backlit(1)

 
One Touch Presets

10(6)

9(3)

32(2)

2(2)

16(2)

18(1)

3(1)

20(1)

 
 
 

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