Hunt's Logo

America's Oldest Camera Store since 1889.

Hunt's Photo Specials

Specials

Product Photo

Canon EOS R50 Video Creator Kit

SKU: #5811C109 $999.00

Whether for vlogging, shooting a video, or simply recording the sights and sounds that inspire you, you'll have everything you need with the EOS R50 Vlogging Creator Kit. A host of video functions such as 6K oversampled 4K 30p capture and Dual Pixel CMOS AF II makes the EOS R50 a great camera for movie recording and vlogging. The EOS R50 camera makes photography fun, simple, and convenient with intuitive photo functions that capture beautiful images automatically, just as you imagine them. The 24.2 Megapixel APS-C size CMOS Image sensor and DIGIC X image processor ensure high image quality in a compact and lightweight form factor.

Product Photo

Sony Alpha 9 III Full-Frame Mirrorless Camera with Global Shutter (Body Only Outfit)

SKU: #ILCE9M3B $5,999.99

Sony Alpha Full-frame Mirrorless Interchangeable Lens Camera – unprecedented imagery from the world's first camera with global shutter full-frame image sensor. The global shutter gives the a9 III the ability to sync at up to 1/80,000 sec and eliminates the need for High Speed Sync, and also allows this feature with third-party flashes. It also means there's no risk of banding from artificial lights, and it also eliminates distortion of moving objects in the frame.

Product Photo

Fujifilm Superia 400 135-36 3-pack

SKU: #600022183 $24.99

3-pack of Fuji Superia 400 35mm 36-exposure

Product Photo

Ricoh GR IIIx HDF Compact Camera with 40mm Equivalent Lens (F/2.8 - F/16)

SKU: #01283 $1,149.95

The RICOH GR IIIx HDF was designed using the acclaimed RICOH GR IIIx as the base models, these premium compact cameras feature a newly developed Highlight Diffusion Filter (HDF). With the exceptional image quality, flawless point-and-shoot operation, and outstanding portability that the GR series is known for,The GR IIIx HDF allow the user to instantly engage the newly developed, built-in HDF (Highlight Diffusion Filter) with a single action. This special-effect filter diffuses highlight areas and creates a blurred effect along the image's edges, making it possible to capture somewhat nostalgic images resembling those captured in film photography or vintage movies.

Product Photo

Ricoh GR III HDF Compact Camera with built-in Highlight Diffusion Filter

SKU: #01272 $1,069.95

The RICOH GR III HDF was designed using the acclaimed RICOH GR III as the base models, these premium compact cameras feature a newly developed Highlight Diffusion Filter (HDF). With the exceptional image quality, flawless point-and-shoot operation, and outstanding portability that the GR series is known for,The GR III HDF allow the user to instantly engage the newly developed, built-in HDF (Highlight Diffusion Filter) with a single action. This special-effect filter diffuses highlight areas and creates a blurred effect along the image’s edges, making it possible to capture somewhat nostalgic images resembling those captured in film photography or vintage movies.

Product Photo

Nikon Nikkor Z 28-400mm f/4-8 VR Lens (Nikon Z Mount)

SKU: #20125 $1,299.95

Incredible zoom range, rock-steady image stabilization, fast, accurate autofocus, and convenient handling. Wherever you are and whatever you’re shooting, enjoy the versatility of a lens that can cover it all, from landscapes at 28mm to capturing distant details and athletes at 400mm. All in a perfectly balanced, travel-friendly package for photos and video.

Product Photo

Sigma Lens Hood for 50mm F/1.2 DG DN | Art Lens

SKU: #LH78203 $35.00

The LH782-03 lens hood helps protect your Sigma 50mm F/1.2 DG DN | Art lens from accidentqal bumps, scratches and damage. The hood also reduces lens glare and ghosting from light sources and its locking mechanism ensures that the lens hood will stay in place.

Sigma Lens Case for 50mm f/1.2 DG DN | Art Lens (LS-316SEL)

SKU: #316X01 $31.00

The Sigma lens case for the 50mm F/1.2 DG DN | Art Lens will help protect your new lens from dings, scratches, dust and dirt. The zippered top allows for easy acces while keeping your lens secure during transport.

Product Photo

Sigma 50mm F1.2 DG DN | Art Lens (Leica L Mount)

SKU: #316969 $1,399.00

The Sigma 50mm F1.2 DG DN | Art Lens for Sony E-mount cameras is a high-performance lens with a fast maximum aperture of f/1.2. It delivers exceptional sharpness, color accuracy, and minimal distortion across the entire image frame. Its wide aperture provides superb low-light performance and stunning bokeh, making it ideal for portraits, weddings, and event photography.

Product Photo

Sigma 50mm F1.2 DG DN | Art Lens (Sony E Mount)

SKU: #316965 $1,399.00

The Sigma 50mm F1.2 DG DN | Art Lens for Sony E-mount cameras is a high-performance lens with a fast maximum aperture of f/1.2. It delivers exceptional sharpness, color accuracy, and minimal distortion across the entire image frame. Its wide aperture provides superb low-light performance and stunning bokeh, making it ideal for portraits, weddings, and event photography.


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   claudebot
Remote Address   18.222.205.211
Referrer   https://www.huntsphotoandvideo.com/listing.cfm?start=30&hid=6&cid=&sortby=HTL
Date/Time   16-Apr-24 03:25 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)