ZIPS Local Home
 Keyword:  ZipCode:

Automobile Mfrs Equip & Supls (whol) in 06880 ZIP Code (Westport, CT)





All Categories
in 06880
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  



WILLIAMS ADVANCED MATERIALS  845-279-0916
42 Mount Ebo Rd S
Brewster, NY 10509 (~22.3mi. from 06880)
P K R AUTO PARTS INCORPORATED  914-248-7166
Forest Ln
Shenorock, NY 10587 (~23.6mi. from 06880)
JOHNSON CONTROLS INC  631-434-4555
100 Motor Pkwy Ste 136
Hauppauge, NY 11788 (~23.7mi. from 06880)
AUTO SALON  203-789-8062
43 Howe St
New Haven, CT 6511 (~24.9mi. from 06880)
NOOCCAR LLC  516-484-1077
360 Motts Cove RD S
Roslyn, NY 11576 (~28.1mi. from 06880)
EMS MOTORSPORTS  845-225-0674
323 Route 52
Carmel, NY 10512 (~28.2mi. from 06880)
PRECISION INTERNATIONAL AUTOMO  631-567-2000
210 Knickerbocker Ave
Bohemia, NY 11716 (~28.3mi. from 06880)
PRECISION INTERNATIONAL  631-567-2000
14 Todd CT
Yaphank, NY 11980 (~30.8mi. from 06880)
AUTO COLLISION ABA  631-842-6542
10 Deauville Blvd
Copiague, NY 11726 (~32.2mi. from 06880)
C 6 AUTO REPAIR SHOP  718-716-7028
1765 Carter Ave
Bronx, NY 10457 (~35.4mi. from 06880)
JMC AUTO EQUIPMENT  516-887-6807
82 North Dr
Valley Stream, NY 11580 (~37.5mi. from 06880)
BEST TIRE  718-267-7900
6001 Northern Blvd
Woodside, NY 11377 (~40.3mi. from 06880)
PAUL CORNER AUTO INCORPORATED  718-672-1977
59 74 54 Ave
Maspeth, NY 11378 (~41.3mi. from 06880)
PAUL CORNER AUTO INC  718-672-1977
5974 54th Ave
Maspeth, NY 11378 (~41.3mi. from 06880)
AIR BROOK BUS & COACH DIVISION  201-843-7272
18 Overlook Ave
Rochelle Park, NJ 7662 (~41.6mi. from 06880)
AIR BROOK BUS & COACH DIVISION  800-800-1990
18 Overlook Ave
Rochelle Park, NJ 7662 (~41.6mi. from 06880)
BELL IMPORTED AUTO SERVICE  845-782-7314
22 Maple Ave
Harriman, NY 10926 (~41.9mi. from 06880)
BELL IMPORTED AUTO SERVICE COR  845-782-7314
30 Carpenter Pl
Monroe, NY 10950 (~45.7mi. from 06880)
HAKIMOV INC  718-972-6044
796 Mcdonald Ave
Brooklyn, NY 11218 (~47.8mi. from 06880)
ALKAPLUS INCORPORATED  718-232-0469
1574 61st St
Brooklyn, NY 11219 (~49.1mi. from 06880)
ALKAPLUS INC  718-232-0469
2748 E 19th St
Brooklyn, NY 11235 (~49.9mi. from 06880)



HOME  MAJOR CITIES  CATEGORIES  LINK TO ZIPSLOCAL  ABOUT US 
©2008-2010 ZipsLocal.com
6

Queries

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

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

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Automobile Mfrs Equip & Supls (whol)' AND Display='Y'

 (Records=21, Time=31ms)
SQL = 
spZipsLocalListings

 (Records=28, Time=0ms)
SQL = 
spGetRelatedCats

getRelatedCats (Records=27, Time=0ms)
SQL = 
SELECT		*
	FROM		getRelatedCats1
	WHERE		MYCatID <> 241665
	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=06880 AND a.TargetZip<>06880
	ORDER BY	a.Distance

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

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

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

Execution Time

110 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
16 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
15 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
31 msD:\WEBSITES\ZIPSLOCAL\LISTINGS.CFM
16 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
16 msD:\WEBSITES\_CFCUSTOMTAGS\IS_VALIDATE_PHONE.CFM
0 msSTARTUP, PARSING, & SHUTDOWN

Parameters
URL Parameters:

CATNAME=Automobile_Mfrs_Equip_and_Supls_(whol)
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=06880

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=CFCLIENT_MAGICYELLOW=FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A20%3A56%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A20%3A56%27%7D%23; CFID=117262747; CFTOKEN=36112141
HTTP_HOST=06880.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Automobile_Mfrs_Equip_and_Supls_(whol).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_Mfrs_Equip_and_Supls_(whol)
REMOTE_ADDR=38.107.191.105
REMOTE_HOST=38.107.191.105
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=06880.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI