Used Car Search

Bad Credit - No Problem
Click for Details
       

Check Out These Printable Coupons!

Automobile Superstore - Wild Card 15% Off!
Automobile Superstore - Save on Brakes - $50!
Automobile Superstore - NH State Inspection - $20!
Automobile Superstore - Lube Oil & Filter!

Click on the coupons above to print them.

       

Dealer Search

Please choose a Dealer from the list above.

       
       
Advertise with Diesel Land...
...Get your inventory on our portal. → Click for More Info
        Auto Mart
        Tim's Truck Capital
        Automania
        John's Auto Sales
Empire Automotive Group        
        Add your Truck Inventory to Diesel Land > Call to Advertise 603-235-5560 or Click Here
Dealer and/or publisher are not liable for any typographical errors. All terms and conditions are subject to change.

Powered by LocateCentral, Inc.
Terms of Use

jeep

Queries

qryDealerInfo (Records=1, Time=0ms)
SQL = 
spDealerInfo '13841'

qryTestDB (Records=1, Time=0ms)
SQL = 
select @@VERSION

qryResults (Records=0, Time=32ms)
SQL = 
SELECT b.chrCity AS City, b.chrZipCode AS ZipCode, b.chrState AS State, (3956 * (2 * ASIN(SQRT(  POWER(SIN(((a.dblLatitude-b.dblLatitude)*0.017453293)/2),2) +  COS(a.dblLatitude*0.017453293) *  COS(b.dblLatitude*0.017453293) *  POWER(SIN(((a.dblLongitude-b.dblLongitude)*0.017453293)/2),2) )))) AS Distance  
		FROM tblZipCodes a, tblZipCodes b, tblZipCodes c 
		WHERE 
		a.chrZipCode = ? AND 
		a.chrZipCode = c.chrZipCode AND 
		(3956 * (2 * ASIN(SQRT(  POWER(SIN(((a.dblLatitude-b.dblLatitude)*0.017453293)/2),2) +  COS(a.dblLatitude*0.017453293) *  COS(b.dblLatitude*0.017453293) *  POWER(SIN(((a.dblLongitude-b.dblLongitude)*0.017453293)/2),2) )))) <= ?
		ORDER BY Distance

Query Parameter Value(s) -
Parameter #1 = 
Parameter #2 = -1

qryAutos (Records=223, Time=218ms)
SQL = 
spDealerGroupInventory 2,7,0, "All", 0, 0, -1, '-1','', '', -1, -1, -1

qryMakes (Records=22, Time=47ms)
SQL = 
spDealerGroupMakes 2, 'U', -1

qryMakeModel (Records=72, Time=62ms)
SQL = 
spDealerGroupModels 2, 'U', 'ALL', -1

qryTypes (Records=11, Time=47ms)
SQL = 
spDealerGroupTypes 2, 'U', -1

qryDealers (Records=4, Time=0ms)
SQL = 
spGroupDealers 2

qrySpecials (Records=4, Time=16ms)
SQL = 
spGroupQrySpecials 2, 4

Execution Time

484 milliseconds

Parameters
URL Parameters:

ADVANCED=0
CENTER=
DEALER=-1
DEALERID=13841
ENGINE_BRAND_ID=
FUEL_TYPE=
MAKE=
MILEAGE=
MODEL=
MODULE=
O=0
OVERRIDE_DEBUG_MODE=DEBUG
PRICE1=
PRICE2=
RADIUS=-1
REFINE_TYPE=all
RPP=12
S=7
SR=1
ST=0
STOCKNUMBER=
TYPE=
YEAR1=
YEAR2=
ZIP=

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\diesellandPortal\coupons.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=2179488; CFTOKEN=39204304
HTTP_HOST=www.dieselland.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc04-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/coupons.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\diesellandPortal\coupons.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/coupons.cfm
SERVER_NAME=www.dieselland.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI