ZIPS Local Home
Keyword:  ZipCode:

Antique Dealers 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  


Mature may be what gives an antique a market value for the antique dealer to persuade somebody to buy it or to find a party who might be interested in owning the piece. Antique dealers who know their market may spend a fair amount of time with a client make sure he or she is satisfied with their purchase. Antique dealers may negotiate objects, which reached an age that makes them apart of another era in history. Dealers may understand all aspects of what makes an antique an antique. Quality to some aspect may make an antique a unique and priceless commodity for the antique dealer to persuade somebody to buy it. Some common antiques may be furniture, like a desk, or an earlier automobile.

PARIS ON WHITESBURG ANTIQUES &  256-534-7930
2336A Whitesburg Dr S
Huntsville, AL 35801
PARKWAY ANTIQUES  256-533-3111
2806 Memorial Pkwy SW
Huntsville, AL 35801
ANTIQUES ON THE AVENUE  256-539-3383
708 Pratt Ave NE
Huntsville, AL 35801
ALPHA ESTATE & AUCTION SALES  256-536-3117
1214 Meridian St N
Huntsville, AL 35801
THE DANCING RABBIT  205-652-6252
307 Monroe St NW
Huntsville, AL 35801
RIVERBARK & ROPER LLC  256-564-9800
900 Bob Wallace Ave SW
Huntsville, AL 35801
RAILROAD STATION ANTIQUES  256-533-6550
315 Jefferson St N
Huntsville, AL 35801
DARWIN ANTIQUES  256-539-9803
614 Madison St SE
Huntsville, AL 35801
LENNARTS INC  256-536-6789
806 Wellman Ave NE
Huntsville, AL 35801
ANTIQUES ETC APPRAISALS  256-533-7647
509 Pratt Ave NE
Huntsville, AL 35801
ANTIQUES ETC  256-533-7647
7515 Whitesburg Dr S
Huntsville, AL 35802 (~3.9mi. from 35801)
WHITE LILY ANITQUES  256-489-7717
8512 Whitesburg Dr S
Huntsville, AL 35802 (~3.9mi. from 35801)
FURSDON VALERIE INC  256-882-9119
5000 Whitesburg DR S
Huntsville, AL 35802 (~3.9mi. from 35801)
J DS OLF STUFF & ANTIQUES LLC  256-859-4046
3615 Highway 72 E
Brownsboro, AL 35741 (~5.1mi. from 35801)
LOUIES OLDIES  256-859-8336
3414 Blue Spring Rd NW
Huntsville, AL 35810 (~5.8mi. from 35801)
YETISPACE INC  256-489-9460
3701 Lakewood Dr NW
Huntsville, AL 35811 (~6.0mi. from 35801)
MADISON SQUARE ANTIQUES  256-430-0909
1017 Old Monrovia Rd NW
Huntsville, AL 35806 (~7.5mi. from 35801)
BLUEBIRD ANTIQUE MALL  256-725-4000
9195 Highway 431 S
Owens Cross Road, AL 35763 (~9.6mi. from 35801)
LIMESTONE FLEA MARKET INCORPOR  256-233-5183
Us Hwy 72
Madison, AL 35756 (~10.3mi. from 35801)
PACKARDS ANTIQUES  256-881-1678
11110 Memorial Pkwy SW
Huntsville, AL 35803 (~11.5mi. from 35801)
RED ROOSTER ANTIQUE MALL  256-881-6530
12519 Memorial Pkwy SW
Huntsville, AL 35803 (~11.5mi. from 35801)
FIREHOUSE ANTIQUES  256-880-9111
10095 Memorial Pkwy SW
Huntsville, AL 35803 (~11.5mi. from 35801)
HARTLEX ANTIQUES & INTERIORS  256-464-3940
181 Hughes RD
Madison, AL 35758 (~14.8mi. from 35801)
SPECIAL TOUCH ANTIQUE MALL  256-498-5504
4287 Highway 231
Laceys Spring, AL 35754 (~17.0mi. from 35801)
SOPHIES SISTERS ANTIQUES & GIF  256-778-0771
4241 Highway 36 E
Somerville, AL 35670 (~20.1mi. from 35801)

Dealers may understand all aspects of what makes an antique an antique. Artistry of the characteristic may make an antique a unique and priceless commodity for the antique dealer to trade. Some common antiques may be furniture, like a desk, or an earlier automobile. Becoming old may be what gives an antique a market value for the antique dealer to trade it to a party who might be interested in owning the piece. Antique dealers who know their market may spend quite a bit of time with a buyer to make sure he or she is satisfied with their purchase. Antique dealers may trade objects, which reached an age that makes them apart of another era in history.

Go to page   1   2   3   4   5  

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

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

 (Records=121, Time=46ms)
SQL = 
spZipsLocalListings

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

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

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

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

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


Execution Time

125 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
16 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
61 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
16 msSTARTUP, PARSING, & SHUTDOWN


Parameters
URL Parameters:

CATNAME=Antique_Dealers
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%3DAutomated%5FTeller%5FMachines%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D3%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A15%3A48%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=/Antique_Dealers.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=Antique_Dealers
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
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