Hunt's Logo

America's Oldest Camera Store since 1889.

Hunt's Photo Specials

Specials

Product Photo

optech Soft Pouch SLR/Manual (5.5" x 3.0" x 3.75", Black)

SKU: #7001112 $27.99

SOFT POUCH™ - SLR provides great protection while conforming snugly to fit a large variety of manual and auto SLR cameras. This easy-access case is made of soft, durable neoprene to provide protection from impact and to repel water in inclement weather. The custom fit and quick release attachment make this an ideal protective case. It offers a unique retaining strap which attaches around the lens and enables the pouch to stay attached to the camera at all times. As the case falls easily away from the field of view, there's no worry of having it interfere with the shot.

Product Photo

Lexar 128GB Professional 2000x UHS-II SDXC Memory Card

SKU: #LSD2000128GBNN $129.99
Save an additional $20 Dollars off.

Quickly capture and transfer high-quality photos and extended lengths of Full-HD and cinema-quality 8K video, with a read transfer speed up to 300MB/s . The card also leverage UHS-II technology (UHS Speed Class 3 (U3)) for high-speed performance, so you’ll power through post-production with super-fast file transfer from card to computer.

Product Photo

Photogenics Supply Photolove Socks / Infrared (Red)

SKU: #SOXPHLVRED $22.00

Made here in the USA, these fancy socks will keep your feet comfy (and stylish) all year long. Custom-knitted using yarn-dyed (not printed) combed cotton, for a premium ultra-soft feel.

Product Photo

Photogenics Supply Photolove Socks / Purple Fringe

SKU: #SOXPHLVPRPL $22.00

With these socks on your feet, you're sure to turn heads (and maybe hearts, too). Made here in the USA, these fancy socks will keep your feet comfy (and stylish) all year long. Custom-knitted with our Aperture design using yarn-dyed (not printed) combed cotton, for a premium ultra-soft feel.

Product Photo

Photogenics Supply Aperture Socks / Night Sky

SKU: #SOXAPRTNSKY $22.00

Made here in the USA - using US-grown cotton - these fancy socks will be sure to keep your feet comfy (and stylish) all year long. These socks are custom-knitted with our Aperture design using yarn-dyed (not printed) combed cotton, for a premium ultra-soft feel.

Bell & Howell 10.1" Smart Photo Frame (White)

SKU: #BHDPF101W $99.99

Receive photos from your family and friends anywhere in the world with the Bell+Howell smart photo frame. A 10.1” crystal clear HD touchscreen makes it easy for anyone to use.

Bell & Howell 10.1" Smart Photo Frame (Black)

SKU: #BHDPF101BK $99.99

Receive photos from your family and friends anywhere in the world with the Bell+Howell smart photo frame. A 10.1” crystal clear HD touchscreen makes it easy for anyone to use.

Product Photo

Delkin 256GB CFExpress Type B G4 Card & Reader Bundle

SKU: #DCFXP256R54 $189.98

This bundle includes a Delkin 256GB CFExpress Type B G4 card (DCFXBP256G4) and a CFExpress B & SD multi-reader (DDREADER56).

Product Photo

Joby Magnetic Compact Qi Wireless Charger

SKU: #JB01811 $34.95

Fast charge your device with the compact magnetic Qi Wireless Charger, ideal for at-home and on-the-go charging. This supercharger is universally compatible, suitable for Android, iPhone and Qi Wireless devices and is powered by a USB-C port with a 1m (3.3ft) cable for advanced charging range, meaning your smartphone content can keep on rollin’.

Product Photo

AngelBird AtomX SSDmini (1TB)

SKU: #ATOMXMINI1000PK $399.99

Angelbird’s AtomX SSDmini was custom made for the new Atomos Ninja V monitor recorder and is perfectly compatible with all the other available recorders. The AtomX SSDmini is 20 percent smaller than the average SSD (to fit the small footprint of the Ninja V), offers 500 GB and 1 TB of storage, has sustained read speeds of 540 MB/s and write speeds of 500 MB/s, captures CDNG up to 4K 30p, ProRes RAW HQ 5.7K up to 30p, plus 4K 60p and 2K 240p, sports a SATA III connector, and supports Stable Stream™ technology to never miss a frame. Boom!


Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.

 
The error occurred in C:/WEB/HPhoto/responsive/listing.cfm: line 915
Called from C:/WEB/HPhoto/responsive/listing.cfm: line 908
Called from C:/WEB/HPhoto/responsive/listing.cfm: line 1
913 :                     <cfquery name="maincategory" datasource="#request.app.retailer#">
914 :                     Select maincategory from 1cat_main_2017
915 :                     where catmainid = <cfqueryparam value="#url.cid#" cfsqltype="CF_SQL_INTEGER" maxlength="4" />
916 :                     </cfquery>
917 : 

Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.117.153.38
Referrer   https://www.huntsphotoandvideo.com/listing.cfm?start=30&hid=1&cid=
Date/Time   24-Apr-24 01:01 AM
Stack Trace
at cflisting2ecfm641092179._factor34(C:/WEB/HPhoto/responsive/listing.cfm:915) at cflisting2ecfm641092179._factor39(C:/WEB/HPhoto/responsive/listing.cfm:908) at cflisting2ecfm641092179.runPage(C:/WEB/HPhoto/responsive/listing.cfm:1)

coldfusion.sql.Parameter$DataTypeMismatchException: Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:121)
	at coldfusion.sql.Parameter.getMappingValue(Parameter.java:70)
	at coldfusion.sql.Parameter.getMappingValues(Parameter.java:63)
	at coldfusion.sql.InParameter.setStatement(InParameter.java:72)
	at coldfusion.sql.ParameterList.setStatement(ParameterList.java:109)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1657)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1384)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1314)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cflisting2ecfm641092179._factor34(C:\WEB\HPhoto\responsive\listing.cfm:915)
	at cflisting2ecfm641092179._factor39(C:\WEB\HPhoto\responsive\listing.cfm:908)
	at cflisting2ecfm641092179.runPage(C:\WEB\HPhoto\responsive\listing.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:256)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:57)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:446)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:833)