Contact Diesel Land

what goes here

Build a Custom Truck

Your Contact Information

* Required Fields

What are You Looking For? Specifically.

* Required Fields
General Information

Be as specific or as general as you wish to be. Of course the more specific, the more difficult an exact match may be.









Installed Options

Please check any installed options you prefer to have in your new vehicle.

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


Execution Time

547 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=
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\buildATruck.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=/buildATruck.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\diesellandPortal\buildATruck.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/buildATruck.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