ZIPS Local Home
Keyword:  ZipCode:

Automobile Parts Recyclers & Dismantlers in 85251 ZIP Code (Scottsdale, AZ)





All Categories
in 85251
A   B   C   D   E   F   G   H   I
J   K   L   M   N   O   P   Q   R
S   T   U   V   W   X   Y   Z  




Many items that have to do with automobiles are often sold at wholesale and retail prices in many locations around the country. The companies that provide service in respect to various parts, recyclers, and dismantlers, as well as equipment and supplies, often employ educated workers who can give advice about proper automobile maintenance. A lot of automobile recyclers and dismantlers are sold at different specialty shops, stores, outlet centers, and automobile depots where a lot of parts are often also sold. Automobile parts can often include tires, engines, bumpers, and various other parts that help to maintain and repair the life of the automobile. Many people often need to find information regarding automobile parts, recyclers, and dismantlers.


HOME  MAJOR CITIES  CATEGORIES  LINK TO ZIPSLOCAL  ABOUT US 

6


Queries

sitevars (Records=1, Time=0ms)
SQL = 
select *
		from	sitevars where siteid = 4

GetCity (Records=1, Time=0ms)
SQL = 
SELECT	City, StateCode, GeoCityID
	FROM	ZipCoords
	WHERE	iZip=85251

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Automobile Parts Recyclers & Dismantlers' AND Display='Y'

 (Records=0, Time=47ms)
SQL = 
spZipsLocalListings

 (Records=20, Time=15ms)
SQL = 
spGetRelatedCats

getRelatedCats (Records=19, Time=0ms)
SQL = 
SELECT		*
	FROM		getRelatedCats1
	WHERE		MYCatID <> 241574
	ORDER BY	catName

GetNearbyZips1 (Records=50, Time=0ms)
SQL = 
SELECT		TOP 50 a.TargetZip, a.Distance, b.City, b.StateCode
	FROM		ZipDistances a INNER JOIN ZipCoords b ON a.TargetZip=b.iZip
	WHERE		a.BaseZip=85251 AND a.TargetZip<>85251
	ORDER BY	a.Distance

GetNearbyZips (Records=50, Time=0ms)
SQL = 
SELECT		*
	FROM		GetNearbyZips1
	ORDER BY	TargetZip

getArticleLong (Records=0, Time=16ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 241574
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=11)
		ORDER BY createDt desc

getArticleLong (Records=1, Time=31ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 241574
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=12)
		ORDER BY createDt desc


Execution Time

109 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
31 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
16 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSTOP.CFM
0 msD:\WEBSITES\ZIPSLOCAL\CHITIKA.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\GOOGLEADS.CFM
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
47 msD:\WEBSITES\ZIPSLOCAL\LISTINGS.CFM
15 msD:\WEBSITES\ZIPSLOCAL\RELATEDCATS.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
0 msD:\WEBSITES\_CFCUSTOMTAGS\IS_PAGE_OF_ZL.CFM
0 msSTARTUP, PARSING, & SHUTDOWN


Parameters
URL Parameters:

CATNAME=Automobile_Parts_Recyclers_and_Dismantlers
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=85251

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:\Websites\ZipsLocal\listings.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;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=118168423; CFTOKEN=98869437; CFCLIENT_MAGICYELLOW=CATNAME%3DAdult%5FDay%5FCare%5FCenters%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D4%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+15%3A15%3A29%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+15%3A10%3A38%27%7D%23
HTTP_HOST=85251.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Automobile_Parts_Recyclers_and_Dismantlers.html
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/listings.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\listings.cfm
QUERY_STRING=CatName=Automobile_Parts_Recyclers_and_Dismantlers
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=85251.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI