Rollover images for more info
View All Specials

Tire Center

Test Drive Trade Appraisal Credit Application Vehicle Locator eNotify Me!

Best Tire Brands, Best Selection, Best Prices

At Steve King we offer the best brands and selection of tires to fit your car, SUV, Van or Truck. The brands we offer include the familiar names below; and we can order almost any unique tire to meet your automotive needs.
Whether Passenger Car Tires or Light Truck Tires or Tires for your SUV, we have them in stock and can get them installed quickly in one of our seven service bays.
When it comes to Tires in Nashua and Southern New Hampshire, Steve King Auto LLC is your best choice.

Please complete the form below if you have a question or want to schedule tire service.

All fields marked with a red asterisk are required fields.
Phone: (603) 882-4888
FAX: (603) 821-7376

321 Main Street ~ Nashua, New Hampshire ~ 03060
Hours & Directions

Our Tire Brands Include:

General

Goodyear

BF Goodrich

Michelin

Uniroyal

Continental

Please provide year, make, and model information below.

Queries

qrySpecials (Records=1, Time=47ms)
SQL = 
SELECT	TOP 3 V.vin, V.cstocknum, V.cmileage, V.cyear, V.deleted, M.make_descr, V.cmodel, VS.special_price,
			VS.special_price, O.model_descr, VS.special_id, VSS.special_status_descr, V.cmodel, VS.special_status_id
	FROM	vehix V INNER JOIN vehix_specials VS ON V.vin = VS.vin
			INNER JOIN vehix_special_status VSS ON VS.special_status_id = VSS.special_status_id
			INNER JOIN vehix_make M ON V.make_id = M.make_id
			INNER JOIN vehix_model O ON V.model_id = O.model_id
	WHERE	V.dealership_id = 13860
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order

qryFeature (Records=0, Time=62ms)
SQL = 
SELECT    	 V.vin, V.cyear, M.make_descr, V.cmodel, V.cprice, V.cmileage, isNull(B.body_descr,V.body) as body_descr, V.ccolor, V.transmission, V.engine, V.cenginesiz, D.dealership_id, 
                      M.make_id, O.model_descr, V.model_id, V.active, T.vehix_type_descr, dbo.monthlyPrice(V.cprice, D.default_rate, D.default_terms) AS payment, 
                      V.vehix_sales_id, V.vehix_status_id, V.certified, V.option_list, V.msr_price, V.body, MT.vehix_model_type_descr, V.invoice_price, S.special_price, 
                      S.deleted AS special_deleted,V.trim_level,V.mfg_model_number,V.cstocknum, V.dealer_location_id, 
		v.engine_brand_id, eb.engine_brand,v.engine_fuel_id,ef.engine_fuel,v.dual_wheel_drive,bd.bed_length,c.cab,c.cab_id,dateDiff(second,getDate(),S.ltEndDate) as timeLeft,
		S.ltprice,S.ltActive,v.date_in,vehix_comments
FROM         	dbo.vehix_dealership D
		INNER JOIN dbo.vehix V ON D.dealership_id = V.dealership_id 
INNER JOIN dbo.vehix_make M ON V.make_id = M.make_id 
LEFT OUTER JOIN dbo.vehix_model O ON V.model_id = O.model_id 
LEFT OUTER JOIN dbo.vehix_model_type MT ON O.vehix_model_type_id = MT.vehix_model_type_id 
LEFT OUTER JOIN dbo.vehix_specials S ON V.vin = S.vin AND V.dealership_id = S.dealership_id AND S.deleted = 0 
LEFT OUTER JOIN dbo.vehix_body B ON V.body_id = B.body_id 
LEFT OUTER JOIN dbo.vehix_type T ON B.vehix_type_id = T.vehix_type_id
LEFT join vehix_engine_brand eb on eb.engine_brand_id = v.engine_brand_id
LEFT join vehix_engine_fuel ef on ef.engine_fuel_id = v.engine_fuel_id
LEFT join vehix_bed_length bd on bd.bed_length_id = v.bed_length_id
LEFT join vehix_cab c on c.cab_id = v.cab_id
WHERE   (V.active = 1)
		and v.dealership_id = 13860
		AND v.vehix_sales_id = 'F'

qryMakeModel (Records=1132, Time=0ms)
SQL = 
spDealerModels 1, 'U'

Execution Time

266 milliseconds

Parameters
URL Parameters:

SEC=info

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:\www\locatecentral.com\clients\steveking\tires.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/xml,application/xhtml+xml,text/html;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=2179663; CFTOKEN=947784
HTTP_HOST=www.stevekingauto.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc02-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/tires.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\steveking\tires.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.89
REMOTE_HOST=38.107.191.89
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/tires.cfm
SERVER_NAME=www.stevekingauto.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI