|
 Durango restaurants offer a diverse selection of culinary delights. Enjoy fine dining, hearty steakhouses, fresh sushi, traditional southwest fare and much more. Indulge in one of historic Downtown Durango, Colorado’s award-winning restaurants on Main Avenue. Wet your whistle with a locally brewed Durango beer from one of the four local Durango, Colorado breweries.
[ Durango Spring and Summer Planning Guide >>]
Stunning scenery and fresh local ingredients combine to make Durango, Colorado one of the top culinary hotspots in the United States. You can almost smell the coffee and bread.
|
<%
dim cn, rs, strSQL, strDSN, strNow, intTotalRows, strLastUpdate, strCurrentDate, strType, count
strType = "restaurant"
count = 0
'strDSN = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=atlas;UID=durango;PWD=book$4staff;DATABASE=durango"
'strDSN = "DSN=durangodb"
strDSN = "Driver={Microsoft Access Driver (*.mdb)};Dbq=" & request.servervariables("APPL_PHYSICAL_PATH") & "db\durango.mdb;uid=durango;pwd=book$4staff;"
'build connect string
set cn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select lastupdate AS last from lastupdate WHERE type = '" & strType & "'"
cn.Open strDSN
rs.open strSQL, cn
'set total rows
strLastUpdate = rs("last")
'clean up
cn.Close
set rs.ActiveConnection = Nothing
strCurrentDate = date
strLastUpdate = Replace(TRIM(strLastUpdate), "/", "")
strCurrentDate = Replace(TRIM(strCurrentDate), "/", "")
'if strLastUpdate <> strCurrentDate then
if 1 = 1 then
strSQL = "Select max(placement) AS intTotal from Lodging WHERE type = '" & strType & "'"
cn.Open strDSN
rs.open strSQL, cn
'set total rows
intTotalRows = rs("intTotal")
'clean up
cn.Close
set rs.ActiveConnection = Nothing
strSQL = "Update Lodging Set Placement = Placement + 1 WHERE type = '" & strType & "'"
cn.Open strDSN
cn.Execute strSQL
'clean up
cn.Close
strSQL = "Update Lodging Set Placement = 1 WHERE type = '" & strType & "' AND Placement = " & intTotalRows + 1
cn.Open strDSN
cn.Execute strSQL
'clean up
cn.Close
'strSQL = "Update lastupdate Set lastupdate = '" & strCurrentDate & "' WHERE type = '" & strType & "'"
'cn.Open strDSN
'cn.Execute strSQL
'clean up
'cn.Close
end if
strSQL = "Select * From Lodging WHERE type = '" & strType & "' Order by Placement"
cn.Open strDSN
rs.open strSQL, cn
if rs.EOF <> "True" then
Do While not rs.EOF
count = count + 1
%>
" target="_blank"> " border="0"> |
|
<%=rs("desc")%>
" target="_blank" style="font-weight: bold;"><%=rs("title")%>
<% if rs("local") <> "" then%>
Local: <%=rs("local")%>
<% end if %>
<% if rs("tollfree") <> "" then%>
Toll Free: <%=rs("tollfree")%>
<% end if %>
|
|
<%
rs.MoveNext
Loop
end if
'clean up
cn.Close
set rs.ActiveConnection = Nothing
set cn = Nothing
set rs = Nothing
%>
8th Ave. Tavern
Balcony Bar & Grill
Brickhouse Café
Carver Brewing Company
Christina's Bar & Grill
College Café
Cosmopolitan
Cuckoo's Chicken House & Waterin' Hole
Diamond Belle Saloon
Digs Market Café
Durango Bagel
Edgewater Grill
Iron Horse Pizza
Ken & Sue's
Kennebec Café
Lady Falconburgh's Barley Exchange
Mahogany Grille
Max's Big Burgers
Olde Tymers Cafe
Ore House
Oscar's Café Palace Restaurant
Raiders Ridge Café
Randy's
Red Snapper
Season's Rotisserie & Grill
Serious Texas Barbeque
Sow's Ear
Steamworks Brewing Co.
Sweeney's Fine Dining
SWING Dalton Ranch Golf Course
T’s Smokehouse and Grill
The Glacier Club at Tamarron
The Hamilton Chop House
The Lost Dog Bar & Lounge
The Palace Restaurant
Asian Pacific Grill
China Café
East by Southwest
Himalayan Kitchen
May Palace
Mongolian Grill
Shanghai Pearl
Sizzling Siam
Sushitarian
Great Wall
8th Ave. Tavern
Babo’s Bar and Grill
Balcony Bar & Grill
Christina’s Bar and Grills
Colorado Pongas
Cuckoo’s
Dante’s Backside
Derailed Saloon
Diamond Belle Saloon
El Patio
El Rancho Tavern
Joel’s
Lady Falconburgh’s
Legends Lounge and Grill
|
|
Mill Street Brew
Moe’s Starlight Lounge
Office Spiritorium
Orio’s Roadhouse
Purple Haze Bar & Grill
SKA Brewing Company
Steamworks Brewing Company
The Lost Dog Bar and Grill
The Summit
Wild Horse Saloon
Brickhouse Cafe
Durango Coffee Company
Durango Joe's - Town Plaza
Durango Joe's Coffee House
Magpie's Newsstand Café
Steaming Bean Coffee Co.
Jean-Pierre Bakery & Tea Room
Jitter's Java
C.J.’s Diner
Durango Doughworks
Nature's Oasis
Poppy's
RGP'S Flame Grilled Wraps
Upper East Side Deli
Diorio's South Pizza
Guido's Favorite Foods
Homeslice Pizza
Iron Horse Pizza
J. Bo Pizza & Rib Company
Mama's Boy
Mutu's Italian Kitchen
Olde Schoolhouse Café
Cocina Linda
El Rancho Tavern
Fiesta Mexicana
Francisco's Restaurante Y Cantina
Gazpacho
Griego's Mexican Food
Kachina Kitchen
Nini's Taqueria
Tequila's
Zia Taqueria
Cairo Café – Egyptian
Chez Grand-Mere – French
Cyprus Café – Mediterranean
Zuberfizz Soda Shop
Durangourmet
The Yellow Carrot Catering
|
|
|
|
Related Articles:
4th of July in Durango - starting with breakfast at 7:30 am and ending the day with fireworks over downtown
Durango Blues Train - 3 hours of live blues while traveling by train through San Juan National Forest.
Durango Wine Experience - Three Days and hundreds of wineries, artisan spirits and craft beers.
Peanuts™ Easter Beagle Train - Read about this top Easter activity the whole family can enjoy.
Wild Wild West Chocolate - check out the Chocolate Fantasia event
Valentine's Day - Durango offers everything from hot springs to cuisine to romance on the rails.
Durango Snow Report - Read full details about Durango snowfall.
Durango, Colorado in the News - Durango added to two "top" travel destination lists.
USA Today Names Durango a Top Weekend Getaway Spot - for its small town feel with plenty of things to do!
First Night/New Years Eve - with activities centered around the Crossroads Clock Tower at 11th St and Main
Bar D Wranglers - Durango's famous cowboy singers bring you a Christmas Jubilee
Noel Night - a very special event in Downtown Durango
It's Almost HOLIDAZZLE Time in Durango! - officially kicks off the day after Thanksgiving– the traditional start of the holiday shopping season.
|
