ZIPS Local Home
Keyword:  ZipCode:

Agricultural Services 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  



ARCADIA FARMS  480-941-5665
7014 E 1st Ave
Scottsdale, AZ 85251
MOHAVE FARMS  602-275-5402
2600 N 44th St Ste 203
Phoenix, AZ 85008 (~4.6mi. from 85251)
AJ'S FINE FOODS  480-391-3709
10105 E Via Linda
Scottsdale, AZ 85258 (~4.9mi. from 85251)
FARM SOURCES OF  480-248-7530
7373 E Doubletree Ranch Rd
Scottsdale, AZ 85258 (~4.9mi. from 85251)
BOWEN'S HORTICULTURE SERVICE I  480-829-1752
501 W 1st St
Tempe, AZ 85281 (~5.2mi. from 85251)
FARM BUREAU  480-649-1062
Mesa, AZ 85201 (~5.7mi. from 85251)
FARM BUREAU  480-649-3082
11680 E Glenrosa DR
Scottsdale, AZ 85256 (~6.4mi. from 85251)
ASSOCIATED FARMS  480-947-2630
9313 E Thomas RD
Scottsdale, AZ 85256 (~6.4mi. from 85251)
KENLY FARMS  602-248-2238
5125 N 16th St
Phoenix, AZ 85016 (~6.5mi. from 85251)
FARM BUREAL FINANCIA  480-967-7306
3030 S Rural Rd
Tempe, AZ 85282 (~7.1mi. from 85251)
FARM BUREAU FINANCIAL  480-457-1094
2919 S Ellsworth RD
Mesa, AZ 85212 (~7.4mi. from 85251)
FARM BUREAU FINANCIAL SERVICES  480-607-5551
14300 N Northsight Blvd
Scottsdale, AZ 85260 (~7.8mi. from 85251)
FARM BUREAU FINANCIA  480-368-5233
15023 N 73rd St
Scottsdale, AZ 85260 (~7.8mi. from 85251)
FARM BUREAU  480-649-0260
1030 S Stewart Apt 1135
Mesa, AZ 85202 (~8.1mi. from 85251)
T E S FARMS  602-266-7257
6232 N 7th St
Phoenix, AZ 85014 (~8.1mi. from 85251)
JANCA'S JOJOBA OIL &  480-497-9494
320 E 10th Dr
Mesa, AZ 85210 (~8.4mi. from 85251)
SUNBURST FARMS EAST  602-996-5796
13634 N 52nd St
Scottsdale, AZ 85254 (~8.8mi. from 85251)
FARM BUREAU  480-649-1083
2650 E Mckellips RD Unit 102
Mesa, AZ 85213 (~9.0mi. from 85251)
GREENHOUSE RESTAURANT  602-252-2742
139 E Adams St
Phoenix, AZ 85004 (~9.3mi. from 85251)
ARCADIA FARMS  602-251-0204
2301 N Central Ave
Phoenix, AZ 85004 (~9.3mi. from 85251)
HORTICULTURE WEST INC  602-257-4242
Phoenix, AZ 85001 (~9.6mi. from 85251)
PHOENIX FARMS  602-241-6292
3353 N 19th Ave
Phoenix, AZ 85015 (~10.7mi. from 85251)
NATIONAL FARM WORKERS SERVICE  602-246-9657
2020 W Glendale Ave
Phoenix, AZ 85021 (~11.2mi. from 85251)
RAMONA FARMS  520-418-2041
Chandler, AZ 85224 (~12.1mi. from 85251)
SHAMROCK FARMS  602-233-6518
2228 N Black Canyon Hwy
Phoenix, AZ 85009 (~12.7mi. from 85251)


Go to page   1   2   3  

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='Agricultural Services' AND Display='Y'

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

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

getRelatedCats (Records=28, Time=0ms)
SQL = 
SELECT		*
	FROM		getRelatedCats1
	WHERE		MYCatID <> 235883
	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=0ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 235883
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=11)
		ORDER BY createDt desc

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


Execution Time

125 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
31 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
0 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
63 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=Agricultural_Services
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%3DAntique%5FDealers%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+15%3A11%3A18%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=/Agricultural_Services.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=Agricultural_Services
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
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