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

Currently Filtered by

Category

Clocks

Refine Search

  GO
 
Brand

Howard Miller(14)

Universal(14)

Chicago Lighthouse(10)

Bulova(4)

 
Height

13.5"(4)

12"(4)

14"(3)

12.75"(3)

14.5"(2)

12.63"(2)

3"(2)

13"(2)

13 1/2"(2)

13.75"(1)

14 1/2"(1)

13 3/4"(1)

16.5"(1)

9.25"(1)

15.25"(1)

15.75"(1)

16 1/2"(1)

15 3/4"(1)

12 3/4"(1)

7 1/2"(1)

45"(1)

9.75"(1)

18"(1)

16"(1)

 
Depth

2"(7)

1.75"(7)

1 3/4"(4)

1.5"(4)

1 4/5"(3)

1"(3)

1.63"(3)

1.8"(2)

2 3/5"(1)

2.6"(1)

1 1/2"(1)

2.5"(1)

3 3/8"(1)

 
Manufacturer Part Number

C4228(1)

10425(1)

625-561(1)

625607(1)

625608(1)

645-358(1)

10414(1)

10417(1)

10421(1)

10431(1)

625-485(1)

10441(1)

10450(1)

10451(1)

10454(1)

10455(1)

10456(1)

10461(1)

11381(1)

625-509(1)

625-450(1)

C4646(1)

67700002(1)

C4813(1)

C4821(1)

67300002(1)

67300302(1)

67300402(1)

67400603(1)

67403302(1)

67700000(1)

67800613(1)

625-417(1)

67801103(1)

67818003(1)

625-166(1)

625-195(1)

625-214(1)

625-236(1)

625-320(1)

625-323(1)

11641(1)

 
Country of Origin

CN(29)

US(8)

HK(5)

 
Width

13.5"(4)

12"(4)

14"(3)

12.75"(3)

13 1/2"(2)

12.63"(2)

14.5"(2)

13"(2)

15.75"(1)

9.75"(1)

2 1/4"(1)

8 1/2"(1)

15 3/4"(1)

16"(1)

15.25"(1)

8.75"(1)

14 1/2"(1)

13.75"(1)

13 3/4"(1)

16.5"(1)

16 1/2"(1)

12 3/4"(1)

45"(1)

18"(1)

7"(1)

 
Shape

Round(39)

Rectangular(3)

 
Power Source(s)

1 AA (sold separately)(20)

Requires one AA battery (sold separately)(15)

1 AA battery (sold separately)(4)

Requires four D batteries (sold separately)(1)

AC(1)

Requres one AAA battery (included)(1)

 
Display Type(s)

Analog(39)

Digital(3)

 
Lens Material

Glass(10)

General Purpose Polystyrene(2)

High Impact Polystyrene(2)

 
Case Color(s)

Black(23)

Silver(6)

Cherry(3)

White(2)

Walnut(1)

Oil Rubbed Bronze(1)

Rustic Brown(1)

Gray(1)

Silver/Titanium(1)

Faux Cherry Wood(1)

Satin Silver(1)

Brushed Nickel/Dark Cappuccino(1)

 
Model

Reedham(1)

Silhouette(1)

Weather Master(1)

Gabriel(1)

Slimline(1)

Gallery(1)

Chronicle(1)

TechTime II(1)

Alton(1)

Talon(1)

Spokane(1)

Kenwick(1)

625-509(1)

Hamilton(1)

625-607 Rosewood Wall(1)

625-608 Solar Tech(1)

 
Case Material

Plastic(15)

Metal(7)

High Impact Polystyrene(4)

High-Impact Polystyrene(2)

Wood(2)

Injection-Molded Plastic(2)

Injection Molded(2)

Solid Wood(1)

Iron Steel(1)

High-Impact Plastic(1)

Aluminum(1)

Wood/Aluminum(1)

 
Time Format

Standard (12-Hour)(24)

Analog(9)

Standard(5)

Military; Standard(2)

Military (24-Hour); Standard (12-Hour)(1)

12 Hour(1)

 
Movement Type

Quartz(37)

Fuda Brand Quartz Movement(3)

Radio-Controlled (RCC)(1)

Mechanical(1)

 
Second Hand

Yes(13)

No(4)

 
Dial Diameter

12"(10)

14"(2)

11 1/2"(2)

9.5"(2)

11.5"(2)

14.5"(2)

12 3/4"(2)

12.25"(2)

9"(2)

10.75"(1)

10.5"(1)

7.75"(1)

10"(1)

11.25"(1)

11.75"(1)

13"(1)

9.75"(1)

12.5"(1)

14 1/2"(1)

45"(1)

18"(1)

3"(1)

 
Second Hand Color(s)

Red(19)

Black(12)

Silver(2)

Gold(2)

Charcoal Gray(1)

White(1)

 
Minute Track

Yes(14)

 
Face Color(s)

White(34)

Gray(2)

Silver(1)

Light Cream(1)

Brown(1)

Off-White(1)

Black(1)

 
Clock Type

Wall(14)

Desk; Wall(1)

Alarm(1)

Desk(1)

 
Overall Diameter

13.5"(4)

12"(4)

13"(4)

14"(3)

12.75"(3)

12.63"(2)

12 3/4"(2)

14.5"(2)

15.75"(1)

9.75"(1)

2 1/4"(1)

11 3/4"(1)

15 3/4"(1)

16"(1)

15.25"(1)

12 1/4"(1)

14 1/2"(1)

13.75"(1)

13 3/4"(1)

16.5"(1)

16 1/2"(1)

45"(1)

18"(1)

3"(1)

 
Hand Color(s)

Black(11)

Silver(1)

Black/Light Green Luminous(1)

Brown(1)

White(1)

 
 
 

© 2020-2021 NBJ Form & Function Inc. , All Rights Reserved