Refine Your Search
 All Pre-Owned 
 Specials Only 




All Pre-Owned Vehicles

Vehicles Found: 47     Pages: 3
Page 1 - Sorted by: Price (Descending) Sort list by clicking on column headers.
2004 Dodge Ram 1500 96,915  Quad cab BLUE $12,900  
2003 Honda Pilot 133,736  Suv 4x4 SILVER $10,900  
2007 Ford Freestyle 107,184  Suv awd GREY $10,900  
2003 Gmc Envoy 87,397  Utility vehicle 4wd GREY $9,695  
1998 BMW   83,952  4 dr sedan MAROON $9,495  
2006 Saturn Vue 96,664  Suv fwd GREEN $8,995  
2001 Lexus ES 300 115,429  4 dr sedan SILVER $8,495  
2000 Mercedes Benz   144,676  4 dr sedan SILVER $7,995  
2004 Chrysler Pacifica 101,071  Suv fwd BLUE $7,900  
2000 Ford Expedition 96,526  Suv 4wd BLUE $6,995  
2006 Chevrolet G2500 142,862  Cargo van WHITE $6,995  
2002 Nissan Altima 105,174  4 dr sedan MAROON $6,895  
1999 Subaru Legacy 67,067  4 dr wagon awd BLUE $6,595  
2001 Subaru Outback 138,209  4 dr wagon awd GREEN $5,895  
2005 Pontiac Sunfire 69,364  2 dr convertible RED $5,895  
2001 Nissan Maxima 108,902  4 dr sedan BLACK $5,895  
 
Information deemed accurate but not guaranteed.

Queries

qrySpecials (Records=1, Time=32ms)
SQL = 
SELECT	TOP 3 V.vin, V.cstocknum, V.cmileage, V.cyear, V.deleted, M.make_descr, V.cmodel, VS.special_price,
			VS.special_price, O.model_descr, VS.special_id, VSS.special_status_descr, V.cmodel, VS.special_status_id
	FROM	vehix V INNER JOIN vehix_specials VS ON V.vin = VS.vin
			INNER JOIN vehix_special_status VSS ON VS.special_status_id = VSS.special_status_id
			INNER JOIN vehix_make M ON V.make_id = M.make_id
			INNER JOIN vehix_model O ON V.model_id = O.model_id
	WHERE	V.dealership_id = 13860
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order

qryFeature (Records=0, Time=78ms)
SQL = 
SELECT    	 V.vin, V.cyear, M.make_descr, V.cmodel, V.cprice, V.cmileage, isNull(B.body_descr,V.body) as body_descr, V.ccolor, V.transmission, V.engine, V.cenginesiz, D.dealership_id, 
                      M.make_id, O.model_descr, V.model_id, V.active, T.vehix_type_descr, dbo.monthlyPrice(V.cprice, D.default_rate, D.default_terms) AS payment, 
                      V.vehix_sales_id, V.vehix_status_id, V.certified, V.option_list, V.msr_price, V.body, MT.vehix_model_type_descr, V.invoice_price, S.special_price, 
                      S.deleted AS special_deleted,V.trim_level,V.mfg_model_number,V.cstocknum, V.dealer_location_id, 
		v.engine_brand_id, eb.engine_brand,v.engine_fuel_id,ef.engine_fuel,v.dual_wheel_drive,bd.bed_length,c.cab,c.cab_id,dateDiff(second,getDate(),S.ltEndDate) as timeLeft,
		S.ltprice,S.ltActive,v.date_in,vehix_comments
FROM         	dbo.vehix_dealership D
		INNER JOIN dbo.vehix V ON D.dealership_id = V.dealership_id 
INNER JOIN dbo.vehix_make M ON V.make_id = M.make_id 
LEFT OUTER JOIN dbo.vehix_model O ON V.model_id = O.model_id 
LEFT OUTER JOIN dbo.vehix_model_type MT ON O.vehix_model_type_id = MT.vehix_model_type_id 
LEFT OUTER JOIN dbo.vehix_specials S ON V.vin = S.vin AND V.dealership_id = S.dealership_id AND S.deleted = 0 
LEFT OUTER JOIN dbo.vehix_body B ON V.body_id = B.body_id 
LEFT OUTER JOIN dbo.vehix_type T ON B.vehix_type_id = T.vehix_type_id
LEFT join vehix_engine_brand eb on eb.engine_brand_id = v.engine_brand_id
LEFT join vehix_engine_fuel ef on ef.engine_fuel_id = v.engine_fuel_id
LEFT join vehix_bed_length bd on bd.bed_length_id = v.bed_length_id
LEFT join vehix_cab c on c.cab_id = v.cab_id
WHERE   (V.active = 1)
		and v.dealership_id = 13860
		AND v.vehix_sales_id = 'F'

qryAutos (Records=47, Time=94ms)
SQL = 
SELECT	vin, cyear, make_descr, model_descr AS cmodel, IsNull(special_price, cprice) AS cprice, cmileage,
			dbo.properCaps(body_descr) AS body_descr, ccolor, transmission, engine, cenginesiz, make_id,
			special_deleted, certified, cstocknum, model_id
	FROM	qryViewAutosNoModel 
	WHERE	dealership_id = 13860
			AND active = 1
			AND (vehix_status_id <> 'S' OR vehix_status_id IS NULL)
			
				
				
				
				
				
				
					
					
					
					
					
				
				AND (vehix_sales_id = 'U' OR vehix_sales_id = 'P' OR vehix_sales_id = 'F')
						
			
	ORDER BY 5 DESC

qryMakes (Records=22, Time=0ms)
SQL = 
spDealerMakes 13860, 'U'

qryMakeModel (Records=39, Time=0ms)
SQL = 
spDealerModels 13860, 'U'

qryTypes (Records=9, Time=0ms)
SQL = 
spDealerTypes 13860, 'U'

Execution Time

359 milliseconds

Parameters
URL Parameters:

ADVANCED=false
CENTER=
MAKE=
MILEAGE=
MODEL=
MODULE=
O=0
PRICE1=
PRICE2=
REFINE_TYPE=all
RPP=16
S=5
SR=1
ST=
STOCKNUMBER=
TYPE=
YEAR1=
YEAR2=

CGI Variables:

AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\www\locatecentral.com\clients\steveking\inventory.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=2179663; CFTOKEN=947784
HTTP_HOST=www.stevekingauto.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc02-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/inventory.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\steveking\inventory.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.85
REMOTE_HOST=38.107.191.85
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/inventory.cfm
SERVER_NAME=www.stevekingauto.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI