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 ('90191')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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

AT&T(15)

Vtech(13)

poly(5)

Motorola(1)

Spracht(1)

 
Packaged Quantity

1(1)

 
Assembly Required

No(1)

 
Limited Warranty

1 Year(1)

 
For Use With

Mobile Phones(3)

AT&T SynJ System(1)

AT&T TL86109(1)

AT&T TL88102(1)

Motorola ML25254, ML25255, ML25260(1)

Mobile Phones; poly Voyager 5200(1)

Vtech CM18445(1)

Vtech IS6200(1)

Vtech CS6629, CS6649(1)

Vtech DS6151(1)

 
Model Name/Number

210B(1)

60WFOCUS(1)

80-2151-02(1)

DS6151(1)

DS6101(1)

CS6629-3(1)

CS6609-2(1)

CS6619(1)

CS6609(1)

CS6124(1)

CS5129-2(1)

CM18445(1)

CM18245(1)

DS6151-2(1)

60WSFOCUS(1)

60WSB5200(1)

60WB5200(1)

210W(1)

TRIO C60(1)

ML25055(1)

TL88102(1)

TL88002(1)

TL86109(1)

TL86009(1)

SB67138(1)

SB67108(1)

ML17939(1)

ML17929(1)

ML17928(1)

CL84207(1)

CL4940(1)

CL2940(1)

LS6425-3(1)

 
Answering Machine

Yes(1)

 
Country of Origin

CN(33)

US(1)

 
Color(s)

Black/Silver(15)

Black(9)

Silver/Black(7)

White(3)

 
Frequency

1.9 GHz(15)

DECT 6.0(6)

Wideband(4)

 
Wireless Technology

DECT 6.0(1)

 
Speed Dial Memories

10(6)

50(6)

100(4)

18(2)

25(1)

94(1)

9(1)

 
Lines

1(12)

2(12)

4(4)

Up to 3(1)

 
Speakerphone

Base(12)

Handset(12)

Base; Handset(6)

Deskset(1)

Yes(1)

 
Maximum Wireless Range

30 ft(4)

800 ft(1)

 
Wall-Mountable

Yes(19)

No(7)

 
One Touch Presets

9(2)

32(2)

18(1)

10(1)

 
Telephone Type

Cordless(19)

Corded(10)

Corded; Cordless(3)

Conference(1)

 
Volume Control

Handset(13)

Base; Handset(7)

Base(7)

Handset; Ringer; Speakerphone(4)

Speakerphone(2)

 
Caller ID/Type

Handset(14)

Base(9)

Base; Handset(5)

Deskset(1)

 
Caller ID Features

Name/Number Display(21)

Name(4)

Name/Number Display; Time/Date Display(3)

Caller ID History; Memory Match(1)

Caller ID History(1)

 
Memory/Redial

5(6)

10(6)

20(4)

1(3)

50(2)

3(1)

 
Caller ID Locations

Caller Location Displayed(31)

 
Intercom

Yes(20)

No(8)

 
Conferencing

3-Way(15)

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

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

4-Way(2)

Local Five-Way Audio Conferencing(1)

 
Paging

Yes(11)

No(7)

 
Multi-Handset Capability

Up to 12(7)

Up to 5(4)

Up to 10(1)

 
Answering System

Digital(20)

 
Recording Time

14 min(5)

Unlimited(4)

22 min(2)

12 min(2)

180 min(2)

13 min(2)

24 min(1)

23 min(1)

 
Display Type

LCD(30)

Color LCD(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved