Hit Camera and Video LTD

select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name

Resource id #205

select products_id, products_image, products_tax_class_id, products_price from products where products_status = '1' order by products_date_added desc limit 10

Resource id #208

Categories

select c.categories_id, cd.categories_name, c.parent_id from categories c, categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='1' order by sort_order, cd.categories_name

Resource id #46

select count(*) as count from categories where parent_id = '24'

Resource id #47

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '24'

Resource id #48

select categories_id from categories where parent_id = '24'

Resource id #49

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '34'

Resource id #50

select categories_id from categories where parent_id = '34'

Resource id #51

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '47'

Resource id #52

select categories_id from categories where parent_id = '47'

Resource id #53

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '46'

Resource id #54

select categories_id from categories where parent_id = '46'

Resource id #55

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '48'

Resource id #56

select categories_id from categories where parent_id = '48'

Resource id #57

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '49'

Resource id #58

select categories_id from categories where parent_id = '49'

Resource id #59

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '114'

Resource id #60

select categories_id from categories where parent_id = '114'

Resource id #61

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '142'

Resource id #62

select categories_id from categories where parent_id = '142'

Resource id #63

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '91'

Resource id #64

select categories_id from categories where parent_id = '91'

Resource id #65

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '92'

Resource id #66

select categories_id from categories where parent_id = '92'

Resource id #67

select count(*) as count from categories where parent_id = '74'

Resource id #68

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '74'

Resource id #69

select categories_id from categories where parent_id = '74'

Resource id #70

select count(*) as count from categories where parent_id = '112'

Resource id #71

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '112'

Resource id #72

select categories_id from categories where parent_id = '112'

Resource id #73

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '86'

Resource id #74

select categories_id from categories where parent_id = '86'

Resource id #75

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '115'

Resource id #76

select categories_id from categories where parent_id = '115'

Resource id #77

select count(*) as count from categories where parent_id = '60'

Resource id #78

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '60'

Resource id #79

select categories_id from categories where parent_id = '60'

Resource id #80

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '61'

Resource id #81

select categories_id from categories where parent_id = '61'

Resource id #82

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '62'

Resource id #83

select categories_id from categories where parent_id = '62'

Resource id #84

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '63'

Resource id #85

select categories_id from categories where parent_id = '63'

Resource id #86

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '64'

Resource id #87

select categories_id from categories where parent_id = '64'

Resource id #88

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '65'

Resource id #89

select categories_id from categories where parent_id = '65'

Resource id #90

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '70'

Resource id #91

select categories_id from categories where parent_id = '70'

Resource id #92

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '71'

Resource id #93

select categories_id from categories where parent_id = '71'

Resource id #94

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '72'

Resource id #95

select categories_id from categories where parent_id = '72'

Resource id #96

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '73'

Resource id #97

select categories_id from categories where parent_id = '73'

Resource id #98

select count(*) as count from categories where parent_id = '99'

Resource id #99

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '99'

Resource id #100

select categories_id from categories where parent_id = '99'

Resource id #101

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '38'

Resource id #102

select categories_id from categories where parent_id = '38'

Resource id #103

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '82'

Resource id #104

select categories_id from categories where parent_id = '82'

Resource id #105

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '83'

Resource id #106

select categories_id from categories where parent_id = '83'

Resource id #107

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '84'

Resource id #108

select categories_id from categories where parent_id = '84'

Resource id #109

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '85'

Resource id #110

select categories_id from categories where parent_id = '85'

Resource id #111

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '88'

Resource id #112

select categories_id from categories where parent_id = '88'

Resource id #113

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '89'

Resource id #114

select categories_id from categories where parent_id = '89'

Resource id #115

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '35'

Resource id #116

select categories_id from categories where parent_id = '35'

Resource id #117

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '93'

Resource id #118

select categories_id from categories where parent_id = '93'

Resource id #119

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '100'

Resource id #120

select categories_id from categories where parent_id = '100'

Resource id #121

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '102'

Resource id #122

select categories_id from categories where parent_id = '102'

Resource id #123

select count(*) as count from categories where parent_id = '131'

Resource id #124

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '131'

Resource id #125

select categories_id from categories where parent_id = '131'

Resource id #126

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '132'

Resource id #127

select categories_id from categories where parent_id = '132'

Resource id #128

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '133'

Resource id #129

select categories_id from categories where parent_id = '133'

Resource id #130

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '134'

Resource id #131

select categories_id from categories where parent_id = '134'

Resource id #132

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '135'

Resource id #133

select categories_id from categories where parent_id = '135'

Resource id #134

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '136'

Resource id #135

select categories_id from categories where parent_id = '136'

Resource id #136

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '138'

Resource id #137

select categories_id from categories where parent_id = '138'

Resource id #138

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '139'

Resource id #139

select categories_id from categories where parent_id = '139'

Resource id #140

select count(*) as count from categories where parent_id = '21'

Resource id #141

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '21'

Resource id #142

select categories_id from categories where parent_id = '21'

Resource id #143

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '40'

Resource id #144

select categories_id from categories where parent_id = '40'

Resource id #145

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '51'

Resource id #146

select categories_id from categories where parent_id = '51'

Resource id #147

select count(*) as count from categories where parent_id = '103'

Resource id #148

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '103'

Resource id #149

select categories_id from categories where parent_id = '103'

Resource id #150

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '104'

Resource id #151

select categories_id from categories where parent_id = '104'

Resource id #152

select count(*) as count from categories where parent_id = '22'

Resource id #153

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '22'

Resource id #154

select categories_id from categories where parent_id = '22'

Resource id #155

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '52'

Resource id #156

select categories_id from categories where parent_id = '52'

Resource id #157

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '53'

Resource id #158

select categories_id from categories where parent_id = '53'

Resource id #159

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '54'

Resource id #160

select categories_id from categories where parent_id = '54'

Resource id #161

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '55'

Resource id #162

select categories_id from categories where parent_id = '55'

Resource id #163

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '56'

Resource id #164

select categories_id from categories where parent_id = '56'

Resource id #165

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '57'

Resource id #166

select categories_id from categories where parent_id = '57'

Resource id #167

select count(*) as count from categories where parent_id = '33'

Resource id #168

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '33'

Resource id #169

select categories_id from categories where parent_id = '33'

Resource id #170

select count(*) as count from categories where parent_id = '143'

Resource id #171

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '143'

Resource id #172

select categories_id from categories where parent_id = '143'

Resource id #173

select count(*) as count from categories where parent_id = '90'

Resource id #174

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '90'

Resource id #175

select categories_id from categories where parent_id = '90'

Resource id #176

select count(*) as count from categories where parent_id = '26'

Resource id #177

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '26'

Resource id #178

select categories_id from categories where parent_id = '26'

Resource id #179

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '94'

Resource id #180

select categories_id from categories where parent_id = '94'

Resource id #181

select count(*) as count from categories where parent_id = '121'

Resource id #182

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '121'

Resource id #183

select categories_id from categories where parent_id = '121'

Resource id #184

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '122'

Resource id #185

select categories_id from categories where parent_id = '122'

Resource id #186

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '123'

Resource id #187

select categories_id from categories where parent_id = '123'

Resource id #188

select count(*) as count from categories where parent_id = '96'

Resource id #189

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '96'

Resource id #190

select categories_id from categories where parent_id = '96'

Resource id #191

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '129'

Resource id #192

select categories_id from categories where parent_id = '129'

Resource id #193

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '124'

Resource id #194

select categories_id from categories where parent_id = '124'

Resource id #195

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '125'

Resource id #196

select categories_id from categories where parent_id = '125'

Resource id #197

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '126'

Resource id #198

select categories_id from categories where parent_id = '126'

Resource id #199

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '127'

Resource id #200

select categories_id from categories where parent_id = '127'

Resource id #201

select count(*) as total from products p, products_to_categories p2c where p.products_id = p2c.products_id and p.products_status = '1' and p2c.categories_id = '128'

Resource id #202

select categories_id from categories where parent_id = '128'

Resource id #203

Accessories-> (59)
Binoculars
Camera Filters-> (32)
Camera Lenses-> (157)
Digital Camera Accessories-> (37)
Digital Memory Cards-> (18)
Digital P&S Cameras-> (10)
Digital Photo Paper->
Digital SLR Systems-> (10)
Digital Viewers
Film Scanner
Lens to Camera Body Adapter (5)
Photo Printers->
Tripods-> (8)
Used and Collectables-> (23)

Manufacturers

select products_name from products_description where products_id = '904' and language_id = '1'

Resource id #209

select specials_new_products_price from specials where products_id = '904' and status

Resource id #210

What's New?

select sum(tax_rate) as tax_rate from tax_rates tr left join zones_to_geo_zones za on (tr.tax_zone_id = za.geo_zone_id) left join geo_zones tz on (tz.geo_zone_id = tr.tax_zone_id) where (za.zone_country_id is null or za.zone_country_id = '0' or za.zone_country_id = '38') and (za.zone_id is null or za.zone_id = '0' or za.zone_id = '74') and tr.tax_class_id = '12' group by tr.tax_priority

Resource id #213

Toshiba USB Flash Memory 4GB
$24.00

Quick Find

Use keywords to find the product you are looking for.
Advanced Search

Information

Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Warranty Information
About us

Warranty Information

New Camera Warranties

All new cameras come with their respective manufacturers warranty, please view your warranty cards for more detailed information.

http://www.usa.canon.com/consumer/controller?act=PgComSmModDisplayAct&key code=2113&fcategoryid=215&modelid=12929
Canon - 1 year manufacturer's warranty.
Pentax - 1 year manufacturer's warranty .
Nikon - 2 year manufacturer's warranty on camera bodies and 5 year warranty on lens.
Konica-Minolta - 1 year manufacturer's warranty on camera bodies and lens.

Our store offers additional warranty on top of what the manufacturer includes for a small fee.
Please refer to the table below for the rates:

0 to $1,499.99 $1,500.00 - $2,500.00

1 year $30.00 $60.00

2 years $70.00 $140.00

3 years $110.00 $220.00

All Hit Camera and Video warranties are voided in the absence of an official receipt

select distinct p.products_id, pd.products_name from products p, products_description pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by p.products_ordered desc, pd.products_name limit 10

Resource id #232

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added desc limit 10

Resource id #235

Shopping Cart

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '908' and pd.products_id = p.products_id and pd.language_id = '1'

Resource id #224

select specials_new_products_price from specials where products_id = '908' and status = '1'

Resource id #225

select products_id, products_price, products_tax_class_id, products_weight from products where products_id = '908'

Resource id #226

Resource id #227

select specials_new_products_price from specials where products_id = '908' and status = '1'

Resource id #228

1 x	Coolpix S4000 RED

$174.99

We are eBayers!

Bestsellers

01.	72mm
02.	AF-S DX Nikkor 18-200mm f/3.5-5.6G ED VR II
03.	Compact AW
04.	Hoya 52mm CPL
05.	SP AF 28-75mm F/2.8 XR Di LD Aspherical (IF)

Reviews

select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from reviews r, reviews_description rd, products p, products_description pd where p.products_status = '1' and p.products_id = r.products_id and r.reviews_id = rd.reviews_id and rd.languages_id = '1' and p.products_id = pd.products_id and pd.language_id = '1' order by r.reviews_id desc limit 10

Resource id #239

There are currently no product reviews

Languages

Currencies