Hunt's Logo

America's Oldest Camera Store since 1889.

Hunt's Photo Specials

Specials

USED Nikon NIKKOR Z 50mm f/1.2 S Lens

SKU: #N20006117 $1,799.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

USED Sony FE 100-400mm f/4.5-5.6 GM OSS Lens

SKU: #1865294 $1,799.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Product Photo

USED Nikon AF-S NIKKOR 500mm f/5.6E PF ED VR

SKU: #222198 $1,999.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

USED Sony FE 135mm F1.8 GM Lens

SKU: #1849129 $1,599.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Used Sony FE 35mm F1.4 GM Full-frame Large-aperture Wide Angle G Master Lens

SKU: #S1808043 $999.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Product Photo

Used Nikon NIKKOR Z 85mm F/1.8 S Lens (Z Mount)

SKU: #20013897 $599.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

USED Nikon NIKKOR Z 24-70mm f/2.8 S Lens

SKU: #20062881 $1,899.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Used OM System OM-5 Mirrorless Camera (Body Only, Black)

SKU: #BJ0A09354 $749.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Product Photo

Used OM System M.Zuiko Digital ED 40-150mm F4.0 PRO Lens (Micro Four-Thirds)

SKU: #A0BA11414 $599.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.

Product Photo

Used OM System M.Zuiko Digital ED 12-45mm F4.0 PRO Lens (Black, Micro Four-Thirds)

SKU: #34CA34014 $399.00

(EX) Excellent : Slight evidence of wear and tear. No Dents or dings or cracks. Glass is very clean and clear. (Photo is not of actual product.) Used equipment from Hunt's Photo & Video has a 90 day warranty.


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   3.144.42.196
Referrer   https://www.huntsphotoandvideo.com/listing.cfm?start=30&hid=8&cid=&sortby=New2Old
Date/Time   19-Apr-24 05:37 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)