SELECT ShopDirectory.ShopID, ShopName, AVG(AVGrating) AS ShopAVGrating, City, Description, StateName FROM ShopDirectory LEFT JOIN ShopReviews ON ShopDirectory.ShopID=ShopReviews.ShopID WHERE ShopDirectory.StateName = '#form.StateName#' GROUP BY ShopDirectory.ShopID, ShopName, City, Description, StateName ORDER by ShopName SELECT StateName FROM StateDirectory ORDER BY StateName ASC MTBMIND -- Riding through all elements!
.. Today is #DateFormat(Now(),"dddd, mmmm dd, yyyy")#
             
       
Shop Directory

Welcome to the Shop Directory page. If you are looking for a local shop to spend some hard earned cash, get friendly with a few good mechanics, or perhaps get a job helping this fine community of bikers, then look no further than our regional shop directory below!  

Narrow your search by State
Click here to add a shop!
 Shop Name
 Location
 Overall Rating
#ShopName#
 #City#, #StateName#


top of page

  
   
   
             

 
   


Copyright © 2002 MTBMIND.com. All Rights Reserved
Site Designed by Chris Gagnon