Hunt's Logo

America's Oldest Camera Store since 1889.

Hunt's Photo Specials

Specials

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.

Product Photo

Sirui SNIPER 23mm F1.2 Autofocus Lens (Sony E Mount, Black)

SKU: #23AS12EB $349.00

The Sniper 23mm f/1.2 Autofocus Lens is an ultrafast prime with shallow depth of field and high-quality bokeh that produces sharp, in-focus imagery with clear subject isolation. The quick and accurate autofocus supports eye and object tracking, even when the subject is in motion, benefiting photographers and videographers alike.

Product Photo

Sirui SNIPER 23mm F1.2 Autofocus Lens (Nikon Z Mount, Black)

SKU: #23AS12ZB $349.00

The Sniper 23mm f/1.2 Autofocus Lens is an ultrafast prime with shallow depth of field and high-quality bokeh that produces sharp, in-focus imagery with clear subject isolation. The quick and accurate autofocus supports eye and object tracking, even when the subject is in motion, benefiting photographers and videographers alike.

Product Photo

Sirui SNIPER 23mm F1.2 Autofocus Lens (Fujifilm X Mount, Black)

SKU: #23AS12XB $349.00

The Sniper 23mm f/1.2 Autofocus Lens is an ultrafast prime with shallow depth of field and high-quality bokeh that produces sharp, in-focus imagery with clear subject isolation. The quick and accurate autofocus supports eye and object tracking, even when the subject is in motion, benefiting photographers and videographers alike.

Product Photo

Tom & Lisa Cuchara Macro Bundle (Focusing Rail, Diffusion Disc, LED Light , Articulating Arm, Close Up Lens Kit)

SKU: #TLCMACRO1 $429.99

• Promaster ReflectaDisc 12'' Portable Translucent Diffusion Disc MFR# PRO4326 • Lume Cube Panel Go RGB LED Light MFR# LCPANELGORGB • Wimberley The Plamp II Articulating Arm SKU: #PP200 • NISI Macro Focusing Rail NM-180 with 360 Degree Rotating Clamp SKU: #NM180 • Nisi Close Up Lens Kit NC 77mm II (with 67 and 72mm adaptors) SKU: #NIRCLOSEUP77II

Leica V-Lux 5 Digital Camera OPEN BOX DEMO

SKU: #19121DEMO $1,595.00
Save an additional 15% off.

Whether traversing the globe, capturing family memories, or catching a summer music festival, the V-Lux 5 is the perfect companion to take everywhere and capture subjects both near and far in amazing quality. Its high-speed autofocus and burst shooting capabilities are quick enough to keep up with any subject or fleeting moment, and the long 25-400mm equivalent zoom range will get you close to everything you want to see and record – with both still-pictures and 4K video.


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.234.232.228
Referrer   https://www.huntsphotoandvideo.com/listing.cfm?start=0&hid=6&cid=&sortby=New2Old
Date/Time   28-Mar-24 09:27 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)