ZIPS Local Home
 Keyword:  ZipCode:

Auto Rental Leasing Car in 35801 ZIP Code (Huntsville, AL)





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



HERTZ CORP  256-551-2744
2223 Memorial Pkwy SW
Huntsville, AL 35801
HERTZ RENT A CAR  256-772-9331
Huntsville International
Huntsville, AL 35801
HERTZ RENT A CAR  256-722-2150
6675 Hwy 72 W
Huntsville, AL 35801
THRIFTY CAR RENTAL  256-350-1699
Hwy 31 N
Huntsville, AL 35801
U HAUL COMPANY  256-837-8786
7015 Hwy 72 W
Huntsville, AL 35801
NATIONAL CAR RENTAL  256-772-9336
Huntsville International Air
Huntsville, AL 35801
HERTZ PENSKE TRUCK RENTAL  256-828-6823
Hazel Grn
Huntsville, AL 35801
PENSKE TRUCK RENTAL  256-852-5537
1300 C Fletcher St
Huntsville, AL 35801
PENSKE TRUCK RENTAL  256-880-8161
2223 Memorial Pkwy SW
Huntsville, AL 35801
BUBBAS PENSKE TRUCK RENTAL  256-551-0616
1300 Fletcher St NW
Huntsville, AL 35801
U-HAUL CO  256-518-9632
816 Demasters Ave NW
Huntsville, AL 35801
HERTZ CAR & TRUCK RENTAL  256-722-2150
6675 Highway 72 W
Huntsville, AL 35801
U-HAUL COMPANY  256-533-5998
301 Brown St NW
Huntsville, AL 35805 (~3.4mi. from 35801)
U HAUL COMPANY  256-533-6370
3713 Governors DR SW
Huntsville, AL 35805 (~3.4mi. from 35801)
ENTERPRISE RENT A CAR  256-534-9700
2401 Bob Wallace Ave SW
Huntsville, AL 35805 (~3.4mi. from 35801)
ENTERPRISE RENT A CAR  256-518-8265
2120 Drake Ave SW
Huntsville, AL 35805 (~3.4mi. from 35801)
U HAUL COMPANY  256-650-3482
250 Jones Valley DR SW
Huntsville, AL 35802 (~3.9mi. from 35801)
U HAUL COMPANY  256-721-6995
4440 University DR NW
Huntsville, AL 35816 (~4.1mi. from 35801)
U HAUL COMPANY  256-830-6464
1903 Sparkman DR NW
Huntsville, AL 35816 (~4.1mi. from 35801)
ENTERPRISE RENT A CAR  256-539-5176
3800 University Dr NW
Huntsville, AL 35816 (~4.1mi. from 35801)
AVIS RENT A CAR  256-772-7404
3154 University Dr NW
Huntsville, AL 35816 (~4.1mi. from 35801)
WOODY ANDERSON FORD RENTAL  256-517-1300
2500 Jordan Ln NW
Huntsville, AL 35816 (~4.1mi. from 35801)
AVIS TRUCK RENTAL  256-539-8483
3154 University DR NW
Huntsville, AL 35816 (~4.1mi. from 35801)
AGENCY RENT A CAR  256-830-1317
555 Sparkman Dr NW
Huntsville, AL 35816 (~4.1mi. from 35801)
U-HAUL COMPANY  256-513-6716
4440 University Dr NW
Huntsville, AL 35816 (~4.1mi. from 35801)


Go to page   1   2   3   4   5   6   7  

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=35801

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Auto Rental Leasing Car' AND Display='Y'

 (Records=160, Time=78ms)
SQL = 
spZipsLocalListings

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

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

GetNearbyZips1 (Records=50, Time=15ms)
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=35801 AND a.TargetZip<>35801
	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 = 241987
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=11)
		ORDER BY createDt desc

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

Execution Time

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

Parameters
URL Parameters:

CATNAME=Auto_Rental_Leasing_Car
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=35801

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=118156301; CFTOKEN=71317184; CFCLIENT_MAGICYELLOW=CATNAME%3DAntique%5FDealers%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D5%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A27%3A23%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A14%3A15%27%7D%23
HTTP_HOST=35801.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Auto_Rental_Leasing_Car.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=Auto_Rental_Leasing_Car
REMOTE_ADDR=38.107.191.108
REMOTE_HOST=38.107.191.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=35801.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI