Diesel Land will be sending this Correspondance to Diesel Land Portal on your behalf...

Diesel Land Portal - Contact Us

Your Contact Information

* Required Fields

Correspondance

* Required Fields
Thank you for taking the time to contact us. We appreciate your business.


       
       
Advertise with Diesel Land...
...Get your inventory on our portal. → Click Here for Details
        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=16ms)
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=234ms)
SQL = 
spDealerGroupInventory 2,7,0, "All", 0, 0, -1, '-1','', '', -1, -1, -1

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

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

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

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

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

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

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
SEC=
SID=5
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\contactUs.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=/contactUs.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\diesellandPortal\contactUs.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.108
REMOTE_HOST=38.107.191.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/contactUs.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