ZIPS Local Home
 Keyword:  ZipCode:

Batteries Storage Retail in 06040 ZIP Code (Manchester, CT)





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



MIDSTATE BATTERY  860-243-0646
139C Dale Rd
Manchester, CT 6040
BERNIES AUTO ELECTRIC INC  860-528-4177
621 Main St
East Hartford, CT 6108 (~5.0mi. from 06040)
POSITIVE BATTERY COMPANY  860-282-1511
200 Prospect St Ste 1
East Hartford, CT 6108 (~5.0mi. from 06040)
ADVANCE AUTO PARTS  860-610-3278
701 Main St
East Hartford, CT 6108 (~5.0mi. from 06040)
ADVANCE AUTO PARTS  860-870-8500
535 Talcottville Rd
Vernon, CT 6066 (~5.4mi. from 06040)
FLEETPRIDE  860-724-6971
130 Murphy Rd
Hartford, CT 6114 (~7.9mi. from 06040)
ADVANCE AUTO PARTS  860-947-3020
560 Wethersfield Ave
Hartford, CT 6114 (~7.9mi. from 06040)
AUTOZONE  860-520-1339
1487 Albany Ave
Hartford, CT 6112 (~9.0mi. from 06040)
ADVANCE AUTO PARTS  860-292-5300
154 Bridge St
East Windsor, CT 6088 (~9.8mi. from 06040)
ADVANCE AUTO PARTS  860-231-8264
443 New Park Ave
West Hartford, CT 6110 (~11.2mi. from 06040)
INTERNATIONAL AUTO SERVICE CEN  860-953-1675
16 South St
West Hartford, CT 6110 (~11.2mi. from 06040)
MIDSTATE BATTERY  860-243-0646
139 W Dudley Town Rd
Bloomfield, CT 6002 (~12.1mi. from 06040)
ADVANCE AUTO PARTS  860-666-3636
2584 Berlin Tpke
Newington, CT 6111 (~12.3mi. from 06040)
ADVANCE AUTO PARTS  860-832-4646
180 E Main St
New Britain, CT 6051 (~14.8mi. from 06040)
ADVANCE AUTO PARTS  860-347-6777
856 Washington St
Middletown, CT 6457 (~17.2mi. from 06040)
RAE STORAGE BATTERY CO  860-828-6007
51 Deming RD
Berlin, CT 6037 (~17.3mi. from 06040)
ADVANCE AUTO PARTS  860-537-1703
179 Linwood Ave
Colchester, CT 6415 (~17.6mi. from 06040)
ADVANCE AUTO PARTS  860-684-1654
67 W Stafford Rd
Stafford Springs, CT 6076 (~20.1mi. from 06040)
ADVANCE AUTO PARTS  860-423-9304
320 Boston Post Rd
North Windham, CT 6256 (~20.7mi. from 06040)
AUTOZONE  860-621-8908
60 Interstate Park Dr
Southington, CT 6489 (~21.2mi. from 06040)
ADVANCE AUTO PARTS  413-730-6626
128 Island Pond Rd
Springfield, MA 1118 (~22.1mi. from 06040)
ADVANCE AUTO PARTS  203-639-6503
566 W Main St
Meriden, CT 6451 (~22.4mi. from 06040)
ADVANCE AUTO PARTS  860-583-1298
301 Main St
Bristol, CT 6010 (~22.4mi. from 06040)
ADVANCE AUTO PARTS  860-589-2636
1182 Farmington Ave
Bristol, CT 6010 (~22.4mi. from 06040)
ADVANCE AUTO PARTS  413-788-6461
382 Saint James Ave
Springfield, MA 1109 (~23.7mi. from 06040)


Go to page   1   2   3  

HOME  MAJOR CITIES  CATEGORIES  LINK TO ZIPSLOCAL  ABOUT US 
©2008-2010 ZipsLocal.com
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=06040

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Batteries Storage Retail' AND Display='Y'

 (Records=70, Time=62ms)
SQL = 
spZipsLocalListings

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

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

GetNearbyZips1 (Records=50, Time=16ms)
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=06040 AND a.TargetZip<>06040
	ORDER BY	a.Distance

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

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

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

Execution Time

219 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
32 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
62 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
93 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
0 msD:\WEBSITES\_CFCUSTOMTAGS\IS_VALIDATE_PHONE.CFM
0 msSTARTUP, PARSING, & SHUTDOWN

Parameters
URL Parameters:

CATNAME=Batteries_Storage_Retail
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=06040

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=117259947; CFTOKEN=11836560; CFCLIENT_MAGICYELLOW=CATNAME%3DAudiologists%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D3%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A08%3A55%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A07%3A41%27%7D%23
HTTP_HOST=06040.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Batteries_Storage_Retail.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=Batteries_Storage_Retail
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=06040.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI