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 = '910' and language_id = '1'

Resource id #209

select specials_new_products_price from specials where products_id = '910' 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

Coolpix S570 BLUE
$184.99

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

About Us

Mission Statement

At Hit Camera, we are proud to present a huge range of camera products, accessories and equipment. Our friendly and expert advice to help find the right camera is our commitment to our customers. Plus with a full range of film, memory cards, printers and camera accessories we can offer a complete photographic solution that can turn your special moments into lasting memories.

Not sure what to get? No problem! Our friendly staff can give you all the help and advice to find the perfect gift that your special someone will love! Or why not make their wishes come true with a Hit Camera gift voucher and let them choose their own unique gift! The choice is yours... welcome to our website and we look forward to servicing you.

-- Hit Camera and Video Ltd Management

Contact Information

1923 Avenue Road
Toronto, Ontario
Canada M5M 4A2
Telephone: 416.783.1740 / 416.783.1967
Toll Free: 1.866.509.4665
Fax: 416.783.4497

Store Hours

Monday to Thursday - 10am to 6pm
Friday - 10am to 8pm
Saturday - 10am to 6pm

Store Map

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 #242

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 #245

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 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 = '904' and pd.products_id = p.products_id and pd.language_id = '1'

Resource id #226

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

Resource id #227

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 = '911' and pd.products_id = p.products_id and pd.language_id = '1'

Resource id #228

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

Resource id #229

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

Resource id #230

Resource id #231

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

Resource id #232

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

Resource id #233

Resource id #234

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

Resource id #235

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

Resource id #236

Resource id #237

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

Resource id #238

1 x	Coolpix S4000 RED
1 x	Toshiba USB Flash Memory 4GB
1 x	Coolpix S570 BLACK

$383.98

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 #249

There are currently no product reviews

Languages

Currencies