Refine Your Search
 All Pre-Owned 
 Specials Only 




All Pre-Owned Vehicles

Vehicles Found: 96     Pages: 6
Page 1 - Sorted by: Our Price (Descending) Sort list by clicking on column headers.
2008 Infiniti QX56 55,892  Suv Liquid Onyx Call $41,575
2004 Toyota Land Cruiser 72,355  Land cruise suv Maroon Call $26,950
2007 Toyota Tundra 42,554  Sr5 pickup truck Blue Streak Metallic Call $25,995
2005 BMW X 52,899  3.0i suv Black Sapphire Metallic Call $25,950
2006 Mercedes Benz M Class 72,644  Ml500 suv Desert Silver Metallic Call $25,500
2007 Honda Odyssey 70,746    Nighthawk Black Pearl Call $24,995
2007 Jeep Wrangler 44,528  Unlimited sahara suv Red Rock Crystal Pearlcoat Call $24,995
2008 Ford F-150 21,581  Xlt pickup truck Redfire Clearcoat Metallic Call $23,950
2006 Ford F-350 Super Duty 127,153  Xlt pickup truck Black Clearcoat Call $22,995
2006 Toyota Tundra 46,387  Sr5 pickup truck Silver Sky Metallic Call $22,950
2007 Acura   75,636  Suv Royal Blue Pearl Call $21,950
2007 Honda Odyssey 40,040    Nimbus Gray Metallic Call $21,950
2007 Honda Pilot 53,750  Ex suv Aberdeen Green Metallic Call $21,600
2007 Toyota Highlander 69,758  Limited suv Oasis Green Pearl Call $20,995
2006 Ford F-350 Super Duty 43,961  Super duty pickup truck Oxford White Clearcoat Call $19,995
2006 Toyota RAV4 39,739  Limited suv Classic Silver Metallic Call $19,550
 
Information deemed accurate but not guaranteed.

Queries

qrySpecials (Records=3, Time=31ms)
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 = 2469
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order

qryFeature (Records=3, Time=62ms)
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 = 2469
		AND v.vehix_sales_id = 'F'

qryAutos (Records=96, Time=15ms)
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, vspecial_price
	FROM	qryViewAutosNoModel 
	WHERE	dealership_id = 2469
			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=21, Time=0ms)
SQL = 
spDealerMakes 2469, 'U'

qryMakeModel (Records=57, Time=0ms)
SQL = 
spDealerModels 2469, 'U'

qryTypes (Records=7, Time=16ms)
SQL = 
spDealerTypes 2469, 'U'

Execution Time

297 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\AleksaAuto\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=2179814; CFTOKEN=41588446
HTTP_HOST=www.aleksaonline.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-01
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/inventory.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\AleksaAuto\inventory.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.110
REMOTE_HOST=38.107.191.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/inventory.cfm
SERVER_NAME=www.aleksaonline.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI