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

Currently Filtered by

Category

Mobile Phone Headsets And Accessories

Refine Search

  GO
 
Brand

Maxell(8)

Plantronics(6)

Califone(5)

AFH(4)

Spracht(4)

Verbatim(3)

Midland(1)

VTech(1)

 
Color

Black(13)

White(3)

Gold(2)

Blue(1)

Gray(1)

Silver(1)

Graphite Black(1)

Red(1)

Green(1)

 
Packaged Quantity

1(27)

 
Limited Warranty

1 Year(10)

Lifetime(6)

2 Year(2)

3 Year(1)

90 Day(1)

 
Weight (Approximate)

1.34 oz(3)

10 oz(2)

14 oz(2)

3.53 oz(2)

12 oz(1)

0.96 oz(1)

0.71 oz(1)

0.50 oz(1)

 
Compatibility

  • Smartphone
  • Tablet PC
(2)

  • PC
  • Mac
(1)

All Midland Extra-Talk & G-Series Radios

(1)

  • Supports bluetooth (v2.0) devices supporting headset profile
  • Supports Adaptive Frequency Hopping (AFH)
  • USB adapter supports Bluetooth headset profile
  • PC softphones
  • mobile phones
(1)

  • PC 
  • Mobile phone
  • Advanced Audio Distribution Profile (A2DP)
(1)

 
Package Type

Retail(2)

 
Form Factor

In-ear(8)

Outer-ear(5)

Circumaural(3)

Ear-cup(3)

Semi-open(1)

 
Host Interface

Mini-phone(6)

USB(1)

 
Connectivity Technology

Wired(16)

Wireless(9)

True Wireless(4)

 
Earpiece Design

Earbud(19)

Over-the-head(8)

Over-the-ear(6)

Behind-the-neck(2)

 
Sound Mode

Stereo(19)

Mono(5)

 
Microphone Design

Boom(11)

On-cable(11)

Cheek(1)

 
Maximum Frequency Response

20 kHz(11)

23 kHz(2)

 
Minimum Frequency Response

20 Hz(11)

30 Hz(1)

140 Hz(1)

 
Impedance

32 Ohm(3)

25 Ohm(2)

16 Ohm(2)

300 Ohm(1)

32(1)

 
Driver Size

1.57"(5)

0.53"(2)

0.35"(2)

1.06"(1)

0.31"(1)

0.54"(1)

 
Connector Plating

Nickel Plated(4)

 
Wireless Operating Distance

98.4 ft(1)

33 ft(1)

 
Manufacturer Part Number

14091(1)

AVP1(1)

99776(1)

99775(1)

99774(1)

ZUM3500(1)

ANC-3012G(1)

ANC-3011R(1)

ANC-3010(1)

VPROB235M(1)

72830-01(1)

203500-101(1)

SAVI740(1)

ELARA60FOCUS(1)

201852-01(1)

199793(1)

14092(1)

199771(1)

199728(1)

199723(1)

199621(1)

198018(1)

191569(1)

191568(1)

4100AVT(1)

3066-USB(1)

3066AVT(1)

3066av(1)

3064av(1)

14172(1)

14161(1)

IS6200(1)

 
Country of Origin

China(25)

Mexico(3)

 
Height

0.8"(2)

1.5"(1)

1"(1)

4"(1)

 
Width

1.3"(2)

1.5"(1)

2.1"(1)

6"(1)

 
Length

4"(1)

 
Cable Length

3 ft(4)

7 ft(2)

8 ft(1)

3.08 ft(1)

5 ft(1)

 
Earpiece Type

Binaural(19)

Monaural(6)

 
Wireless Technology

Bluetooth(8)

DECT 6.0(1)

 
 
 
 
 

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