ZIPS Local Home
Keyword:  ZipCode:

Artists Materials & Supplies in 72201 ZIP Code (Little Rock, AR)





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


Countless individuals attempt to locate various items that are sold at a variety of rates. Wholesale products are often the most reasonable price an item can be sold for, and there are a number of outlet centers, stores, and online companies that sell different items at retail rates. Artist's materials and supplies are often some kinds of items that can be sold at numerous prices and artists materials and supplies are often produced and sold in many different types of supply stores. There are a lot of depots that make available various types of non-toxic paint, and paint is often sold in different textures and colors. These artists' products can also comprise of wax paper, paintbrushes, and instructions about the correct technique to utilize paint.


Numerous artists' items can often include paintbrushes, wax paper, and instructions about the proper way to use paint. There are many stores that provide different kinds of non-toxic paint, and paint is often found in various colors and textures. Artist's materials and supplies are often a few types of products that can be found to be sold for various rates and artists materials and supplies are often distributed in many different kinds of supply stores. Wholesale items are often the lowest price an object can be sold for, and there are many stores, outlet centers, and online companies that sell various products at retail prices. Many people try to find different products that are sold at wholesale and retail prices because of these reasons.


HOME  MAJOR CITIES  CATEGORIES  LINK TO ZIPSLOCAL  ABOUT US 

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

GetCat (Records=1, Time=0ms)
SQL = 
SELECT	MYCatID, CatName, htmlTitle, keywordSingle2 AS KW
	FROM	listingcategories
	WHERE	CatName='Artists Materials & Supplies' AND Display='Y'

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

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

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

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

getArticleLong (Records=1, Time=31ms)
SQL = 
SELECT textSection1 AS articleText, title, articleID, myCatID, styleID
		FROM Article
		WHERE display = 1
			AND myCatID = 239978
			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 = 239978
			AND styleID = (SELECT StyleID FROM ArticlePlacementsCurrent WHERE PlacementID=12)
		ORDER BY createDt desc


Execution Time

141 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
47 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSBOTTOM.CFM
31 msD:\WEBSITES\ZIPSLOCAL\ARTICLELISTINGSTOP.CFM
0 msD:\WEBSITES\ZIPSLOCAL\CHITIKA.CFM
16 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\GOOGLEADS.CFM
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
15 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 msSTARTUP, PARSING, & SHUTDOWN


Parameters
URL Parameters:

CATNAME=Artists_Materials_and_Supplies
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
PAGE=1
ZIP=72201

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=118160836; CFTOKEN=1693751; CFCLIENT_MAGICYELLOW=CATNAME%3DAsbestos%5FInspection%5FRemoval%5FConsulting%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D3%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A39%3A03%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A34%3A39%27%7D%23
HTTP_HOST=72201.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/Artists_Materials_and_Supplies.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=Artists_Materials_and_Supplies
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/listings.cfm
SERVER_NAME=72201.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI