Hunt's Logo

America's Oldest Camera Store since 1889.

Hunt's Photo Specials

Specials

Product Photo

USED LEICA 30-90 VARIO-ELMAR-S f/3.5-5.6 ASPH

SKU: #4291449 $12,000.00
Save an additional $6000 Dollars off.

35mm focal length equivalency of 24-72mm. In very good overall cosmetic condition. Shows moderately light signs of use. Focus and zoom are smooth. The lens has a speck behind the front element (see photos).

Used Sony FE 16-35mm f/2.8 GM Lens

SKU: #1963396 $1,249.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 16-35mm f/2.8 GM Lens

SKU: #1930271 $1,199.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 Alpha 7S III Mirrorless Camera (Body)

SKU: #3372403 $2,499.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 Zeiss Loxia 35mm F/2.0 Biogen T* Lens (Sony E-Mount)

SKU: #51736012 $349.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 Zeiss Loxia 85mm f/2.4 Lens (Sony E Mount)

SKU: #51710036 $649.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 Zeiss Loxia 21mm F/2.8 Prime Lens (Sony E-Mount)

SKU: #51690153 $449.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 50 mm F2.8 Macro Lens

SKU: #1822984 $299.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 24-105mm F4 Full-frame E-mount G lens

SKU: #1871102 $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 Tamron 70-180mm F/2.8 Di III VXD (Sony E Mount)

SKU: #099953 $699.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   claudebot
Remote Address   54.166.223.204
Referrer   https://www.huntsphotoandvideo.com/listing.cfm?start=30&hid=8&cid=&sortby=MFG_A2Z
Date/Time   28-Mar-24 12:42 PM
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)