Sar Arms SAR K2P 9mm 15-Round Used Trade-in Pistol with Adjustable Rear Sight

  • Item Number: T110215C00663
  • /
  • View More Items by Sar Arms
  • /
  • Condition: USED
No Longer Available
    $249.99
Share this
  • SMITH AND WESSON MODEL 5906 9MM DA/SA USED PISTOLS

    Smith & Wesson Model 5906 9mm DA/SA Used Pistols
    $379.99

  • SMITH AND WESSON 5906 9MM POLICE TRADE-INS (GOOD)

    Smith & Wesson 5906 9mm Police Trade-ins (Good Condition)
    $489.00 $459.99

  • SMITH AND WESSON MP9 M2.0 FULL-SIZE 9MM POLICE TRADE-IN PISTOLS W/ 3 MAGS (NEW IN BOX)

    Smith & Wesson MP9 M2.0 Full-Size 9mm Police Trade-in Pistols w/ 3 Mags (New In Box)
    $449.99

  • SMITH AND WESSON 5943 9MM POLICE TRADE

    Smith & Wesson Model 5943 9mm Police Trade-In Pistols
    $499.99

  • SMITH AND WESSON MODEL 669 9MM 12-ROUND USED TRADE-IN PISTOL

    Smith & Wesson Model 669 9mm 12-Round Used Trade-in Pistol
    $499.99

  • INTERARMS FIRESTAR PLUS 9MM USED

    Interarms Firestar Plus 9mm Used Trade-in Pistol
    $299.99

  • NORINCO MODEL 320 9X19 USED

    Norinco Model 320 9mm Used Trade-in Carbine with Wood Stock
    $999.99

  • EIBAR MODEL B 9MM 1911 USED

    Eibar Model B 9mm 1911 8-Round Used Trade-in Pistol
    $349.99

  • RUGER LC9 9MM USED PISTOL

    Ruger LC9 9mm Used Pistol
    $169.99

  • Federal 9mm Luger 115 gr FMJ Aluminum Case Champion 100/Box

    Federal 9mm Luger 115 gr FMJ Aluminum Case Champion 100/Box
    $15.99
    ($0.16 / round)

  • CCI 9mm 115 gr FMJ Blazer Brass 50/Box

    CCI 9mm 115 gr FMJ Blazer Brass 50/Box
    $16.95 $8.99
    ($0.18 / round)

  • CCI 9mm 124 gr FMJ Blazer Brass 50/Box

    CCI 9mm 124 gr FMJ Blazer Brass 50/Box
    $16.95 $8.99
    ($0.18 / round)

  • Federal 9mm Luger 115 gr TSJ American Eagle Syntech

    Federal 9mm Luger 115 gr TSJ American Eagle Syntech
    $19.95 $9.99
    ($0.20 / round)

  • Magtech 9mm Luger 115 gr FMJ Centerfire Ammo 50/Box

    Magtech 9mm Luger 115 gr FMJ Centerfire Ammo 50/Box
    $8.98
    ($0.18 / round)

  • Federal 9mm Luger 115 gr  FMJ Black Pack 250/Box

    Federal 9mm Luger 115 gr FMJ Black Pack 250/Box
    $47.99
    ($0.19 / round)

  • Remington 9mm Luger 115 gr FMJ MIL/LE Training Ammo 50/Box

    Remington 9mm Luger 115 gr FMJ MIL/LE Training Ammo 50/Box
    $8.99
    ($0.18 / round)

  • Federal 9mm Luger 124 gr FMJ American Eagle 50/Box

    Federal 9mm Luger 124 gr FMJ American Eagle 50/Box
    $17.95 $10.99
    ($0.22 / round)

  • Hornady 9mm Luger+P 135 gr FlexLock Critical Duty 25/Box

    Hornady 9mm Luger+P 135 gr FlexLock Critical Duty 25/Box
    $30.71 $19.55
    ($0.78 / round)

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

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 242) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
 
The error occurred in C:/inetpub/wwwroot/products2_similaritems_firearms.cfm: line 117
Called from C:/inetpub/wwwroot/products2_similaritems.cfm: line 8
Called from C:/inetpub/wwwroot/products2.cfm: line 967
Called from C:/inetpub/wwwroot/products2.cfm: line 75
Called from C:/inetpub/wwwroot/products2.cfm: line 1
Called from C:/inetpub/wwwroot/products2_similaritems_firearms.cfm: line 117
Called from C:/inetpub/wwwroot/products2_similaritems.cfm: line 8
Called from C:/inetpub/wwwroot/products2.cfm: line 967
Called from C:/inetpub/wwwroot/products2.cfm: line 75
Called from C:/inetpub/wwwroot/products2.cfm: line 1
115 : 								from tb_skus a 
116 : 								left join tb_sku_buckets e on (e.sku_id = a.sku_id) 
117 : 								where a.style_id = #getproducts.style_id# and e.store_id = #application.qoh_store# 
118 : 								group by a.style_id, e.qc
119 : 								</cfquery>

SQLSTATE   40001
DATASOURCE   celerantsql
VENDORERRORCODE   1205
SQL    select sum(e.qoh + e.qc) as qoh ,sum(e.qc) as qc,sum(e.qs - e.qc) as sold from tb_skus a left join tb_sku_buckets e on (e.sku_id = a.sku_id) where a.style_id = 222683 and e.store_id = 10 group by a.style_id, e.qc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   18.204.227.250
Referrer  
Date/Time   17-Oct-19 11:34 AM
Stack Trace
at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:/inetpub/wwwroot/products2_similaritems_firearms.cfm:117) at cfproducts2_similaritems2ecfm788571315.runPage(C:/inetpub/wwwroot/products2_similaritems.cfm:8) at cfproducts22ecfm199348766._factor15(C:/inetpub/wwwroot/products2.cfm:967) at cfproducts22ecfm199348766._factor19(C:/inetpub/wwwroot/products2.cfm:75) at cfproducts22ecfm199348766.runPage(C:/inetpub/wwwroot/products2.cfm:1) at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:/inetpub/wwwroot/products2_similaritems_firearms.cfm:117) at cfproducts2_similaritems2ecfm788571315.runPage(C:/inetpub/wwwroot/products2_similaritems.cfm:8) at cfproducts22ecfm199348766._factor15(C:/inetpub/wwwroot/products2.cfm:967) at cfproducts22ecfm199348766._factor19(C:/inetpub/wwwroot/products2.cfm:75) at cfproducts22ecfm199348766.runPage(C:/inetpub/wwwroot/products2.cfm:1)

java.sql.SQLTransactionRollbackException: [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 242) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.$fr$execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1537)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1287)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1217)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1181)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768)
	at cfproducts2_similaritems_firearms2ecfm160404233.runPage(C:\inetpub\wwwroot\products2_similaritems_firearms.cfm:117)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfproducts2_similaritems2ecfm788571315.runPage(C:\inetpub\wwwroot\products2_similaritems.cfm:8)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3707)
	at cfproducts22ecfm199348766._factor15(C:\inetpub\wwwroot\products2.cfm:967)
	at cfproducts22ecfm199348766._factor19(C:\inetpub\wwwroot\products2.cfm:75)
	at cfproducts22ecfm199348766.runPage(C:\inetpub\wwwroot\products2.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:254)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:737)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:573)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:505)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	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:223)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:764)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:801)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at sun.reflect.GeneratedMethodAccessor53.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:510)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)