Rollover images for more info
View All Specials
Test Drive Trade Appraisal Credit Application Vehicle Locator eNotify Me!

Service You Can Trust

For hours and directions, please visit our Hours & Directions page.

Your Neighborhood Repair Shop with full set of service capabilities including:

  • 12 Service Bays
  • Fully Trained and Certified Technicians
  • State-of-the-Art Computerized Test and Analysis Equipment
  • Computerized Wheel Alignment Equipment
  • Tune-ups, Oil Changes, Transmission Service as well as Major Repairs
  • NH Sate Inspections only $25.00 (includes State Mandated ORD Inspection)
  • We service all Makes - Foreign and Domestic
  • Early Bird Drop Off available
  • Towing Available
  • No Sales Tax !!

Call (603) 893-6060 today or Click Here to schedule a service appointment today.

Queries

qrySpecials (Records=3, 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 = 2469
			AND VS.deleted = 0
			AND V.deleted = 0
			AND VS.special_status_id = 1
	ORDER BY VS.display_order

qryFeature (Records=3, 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 = 2469
		AND v.vehix_sales_id = 'F'

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

Execution Time

265 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\AleksaAuto\service.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_HOST=www.aleksaonline.com
HTTP_PRAGMA=no-cache
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-01
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/service.cfm
PATH_TRANSLATED=D:\www\locatecentral.com\clients\AleksaAuto\service.cfm
QUERY_STRING=
REMOTE_ADDR=38.107.191.112
REMOTE_HOST=38.107.191.112
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/service.cfm
SERVER_NAME=www.aleksaonline.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=ISAPI