lodging guide home lodging businesses lodging destinations About allaboutrivers.com Contact allaboutrivers.com
New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the AllAboutRivers.com Lodging Guide
Local Lodging Guide top banner

New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the  AllAboutRivers.com Lodging GuideHome  :: Lodging Properties  :: Bed & Breakfasts  :: New Mexico Bed & Breakfasts
New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the  AllAboutRivers.com Lodging Guide
 

Bed & Breakfasts
» Alabama Bed & Breakfasts
» Alaska Bed & Breakfasts
» Arizona Bed & Breakfasts
» California Bed & Breakfasts
» Colorado Bed & Breakfasts
» Connecticut Bed & Breakfasts
» Georgia Bed & Breakfasts
» Idaho Bed & Breakfasts
» Louisiana Bed & Breakfasts
» Maine Bed & Breakfasts
» Massachusetts Bed & Breakfasts
» Michigan Bed & Breakfasts
» Missouri Bed & Breakfasts
» Montana Bed & Breakfasts
» New Hampshire Bed & Breakfasts
» New Jersey Bed & Breakfasts
» New Mexico Bed & Breakfasts
» New York Bed & Breakfasts
» North Carolina Bed & Breakfasts
» Ohio Bed & Breakfasts
» Oregon Bed & Breakfasts
» Pennsylvania Bed & Breakfasts
» Tennessee Bed & Breakfasts
» Texas Bed & Breakfasts
» Utah Bed & Breakfasts
» Vermont Bed & Breakfasts
» Virginia Bed & Breakfasts
» Washington Bed & Breakfasts
» West Virginia Bed & Breakfasts
» Wyoming Bed & Breakfasts
 

Other New Mexico Lodging
» New Mexico Bed & Breakfasts
» New Mexico Cabins, Condos, and Vacation Rentals
» New Mexico Hotels & Motels
» New Mexico Youth Hostels
» New Mexico Guest Ranches & Dude Ranches
 

Members
» Login
» Advertise On Our Site
 

Links Info
» Link to Us
» Links & Resources
 


 


 

New Mexico Bed & Breakfasts

New Mexico Bed & Breakfasts. We've compiled this list of New Mexico Bed & Breakfasts to help you book your New Mexico lodging. New Mexico is full of opportunities for your vacation and we want you to find the Bed & Breakfasts in New Mexico that best suits you.

Use our filters to the right to help refine your search for Bed & Breakfasts in New Mexico or use the menus to the left to find other lodging options. Then just contact the Bed & Breakfasts of your choice to book your lodging.
Filter New Mexico Bed & Breakfasts
Albuquerque Bed & Breakfasts
Cerrillos Bed & Breakfasts
Chimayo Bed & Breakfasts
Corrales Bed & Breakfasts
Farmington Bed & Breakfasts
Pecos Bed & Breakfasts
Raton Bed & Breakfasts
Santa Fe Bed & Breakfasts
Taos Bed & Breakfasts



56 Other Bed & Breakfasts in New Mexico
Adobe Garden at Los Ranchos
641 Chavez NW
Albuquerque, NM 87107
(505) 345-1954
Adobe Nido Bed and Breakfast
1124 Major Ave NW
Albuquerque, NM 87107
866-435-6436
Bottger Mansion of Old Town
110 San Felipe NW
Albuquerque, NM 87104
800-758-3639
Casita Chamisa
850 Chamisal Road NW
Albuquerque, NM 87107
(505) 897-4644
Cinnamon Morning Bed & Breakfast
2700 Rio Grande Blvd NW
Albuquerque, NM 87104
800-214-9481
Enchanted Vista Bed and Breakfast
10700 Del Rey NE
Albuquerque, NM 87122
(505) 823-1301
Hacienda de Colores Bed and Breakfast
1113 Montoya NW
Albuquerque, NM 87104
877-265-6737
Hacinenda Antigua Inn
6708 Tierra Drive NW
Albuquerque, NM 87107
800-201-2986
Heritage House Bed & Breakfast
207 High St NE
Albuquerque, NM 87102
888-342-0223
Inn At Paradise
10035 Country Club Lane
Albuquerque, NM 800-9
505-898-6161
Old Town Bed and Breakfast
707 17th St NW
Albuquerque, NM 87104
888-900-9144
Petroglyphs Guest House
8032 Petroglyph Ave NW
Albuquerque, NM 87120
(505) 480-3870?
Sarabande Bed and Breakfast
5637 Rio Grande Blvd NW
Albuquerque, NM 87107
(888) 506-4923
The Mauger Estate Bed & Breakfast
701 Roma Avenue NW
Albuquerque, NM 87102
800-719-9189
High Feather Ranch Bed and Breakfast
29 High Feather Ranch
Cerrillos, NM 87010
800-757-4410
Madrid Lodging
14 Opera House Rd
Cerrillos, NM 87010
505-471-3450
Rancho Manzana
26 Camino de Mision
Chimayo, NM 87522
888-505-2227
Inn the Village
58 Perea Road
Corrales, NM 87048
877-897.3670
Galisteo Inn
9 La Vega
Galisteo, NM 87540
866-404-8200
Pecos Paradise Inn
14 Main St
Pecos, NM 87552
(505) 757-3669
Heart's Desire Bed & Breakfast
301 S 3rd St
Raton, NM 87740
(866) 488-1028
AdobeStar Inn
222 McKenzie St
Santa Fe, NM 87501
505-988-3024
Alexander's Inn
529 E Palace Ave
Santa Fe, NM 87501
(888) 321-5123?
Casa De Cuma Bed & Breakfast
105 Paseo De La Cuma
Santa Fe, NM 87501
(877) 741-7928?
Casa Del Toro
323 Mc Kenzie
Santa Fe, NM 87501
866-476-1091
Casa Pacifica Bed and Breakfast
1705 Paseo De Peralta
Santa Fe, NM 87501
(877) 982-2078?
Crystal Mesa Farm
27 Crystal Mesa Rd
Santa Fe, NM 87508
505-424-0703
Delmar En La Cienega
50 Entrada La Cienega
Santa Fe, NM 87507
(505)-471-6498
Don Gaspar Inn
623 Don Gaspar
Santa Fe, NM 87501
(888) 986-8664
El Farolito B&B Inn
514 Galisteo
Santa Fe, NM 87501
888-634-8782
El Paradero Bed & Breakfast Inn
220 West Manhattan
Santa Fe, NM 87501
866-558-0918
Four Kachinas Inn
512 Webber St
Santa Fe, NM 87501
800-397-2564
Guadalupe Inn
604 Agua Fria St
Santa Fe, NM 87501
(505) 989-7422
Hacienda Las Barrancas
27 County Rd 84D
Santa Fe, NM 87501
866-455-2197
Hacienda Nicholas Inn
320 East Marcy St
Santa Fe, NM 87501
888-284-3170
Inn of the Turquoise Bear
342 East Buena Vista St
Santa Fe, NM 87501
800-396-4104
Inn on the Alameda
303 East Alameda
Santa Fe, NM 87501
888-984-2121
Madeleine Inn
106 E Faithway St
Santa Fe, NM 87501
(505) 982-3465?
Pueblo Bonito Inn
138 West Manhattan
Santa Fe, NM 87501
800-461-4599
The Bobcat Inn
442 Old Las Vegas Highway
Santa Fe, NM 87505
505-988-9239
Water Street Inn
427 West Water St
Santa Fe, NM 87501
800-646-6752
Adobe & Pines Inn
4107 Road 68
Taos, NM 87571
800-723-8267
American Artists Gallery House
132 Frontier Lane
Taos, NM 87571
800 532 2041
Casa Benavides Bed & Breakfast Inn
137 Kit Carson Road
Taos, NM 87571
(800) 552-1772
Casa Europa Inn
840 Upper Ranchitos Road
Taos, NM 87571
888-758-9798
Country Inn of Taos
720 Karavas Rd
Upper Ranchitos Rd
Taos, NM 87571
800.866.6548
Dreamcatcher Bed & Breakfast
416 La Lomita Road
Taos, NM 87571
888-758-0613
Duncan Retreat Bed & Breakfast
1122 Don Juan Valdez
Taos, NM 87574
505-758-3966
Hacienda del Sol
109 Mabel Dodge Ln
Taos, NM 87571
866-333-4459
Inn On The Rio
910 East Kit Carson Road
Taos, NM 87571
800.737.7199
La Doña Luz Inn
114 Kit Carson Road
Taos, NM 87571
800-758-9187
Little Tree Bed & Breakfast
226 Hondo Seco Road
Taos, NM 87571
(800) 334-8467
Old Taos Guesthouse
1028 Witt Road
Taos, NM 87571
800-758-5448
Orinda Bed and Breakfast
461 Valverde St
Taos, NM 87571
800-847-1837
San Geronimo Lodge
1101 Witt Rd
Taos, NM 87571
800-894-4119
Touchstone Inn
110 Mabel Dodge Ln
Taos, NM 87571
800-758-0192

 
New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the  AllAboutRivers.com Lodging GuideHome  :: Lodging Properties  :: Bed & Breakfasts  :: New Mexico Bed & Breakfasts
New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the  AllAboutRivers.com Lodging Guide
Home Lodging Properties Lodging Destinations Contact LocalLodgingGuide About Us
 
  Privacy Policy Site Map  

Active Travel Network: Rafting Guide  -  Kayaking Guide  -  Online Kayak Store

New Mexico Bed & Breakfasts - Find Bed & Breakfasts in New Mexico using the AllAboutRivers.com Lodging Guide
 
website hosted and developed by    Quicksilver Interactive Media, Inc.  

© 2008 Quicksilver Interactive Media, Inc. - All Rights Reserved



State Lodging Destinations
Alaska Lodging Accomodations
Alabama Lodging Accomodations
Arkansas Lodging Accomodations
Arizona Lodging Accomodations
California Lodging Accomodations
Colorado Lodging Accomodations
Connecticut Lodging Accomodations
Delaware Lodging Accomodations
Florida Lodging Accomodations
Georgia Lodging Accomodations
Hawaii Lodging Accomodations
Iowa Lodging Accomodations
Idaho Lodging Accomodations
Illinois Lodging Accomodations
Indiana Lodging Accomodations
Kansas Lodging Accomodations
Kentucky Lodging Accomodations
Louisiana Lodging Accomodations
Massachusetts Lodging Accomodations
Maryland Lodging Accomodations
Maine Lodging Accomodations
Michigan Lodging Accomodations
Minnesota Lodging Accomodations
Missouri Lodging Accomodations
Mississippi Lodging Accomodations
Montana Lodging Accomodations
North Carolina Lodging Accomodations
North Dakota Lodging Accomodations
Nebraska Lodging Accomodations
New Hampshire Lodging Accomodations
New Jersey Lodging Accomodations
New Mexico Lodging Accomodations
Nevada Lodging Accomodations
New York Lodging Accomodations
Ohio Lodging Accomodations
Oklahoma Lodging Accomodations
Oregon Lodging Accomodations
Pennsylvania Lodging Accomodations
Rhode Island Lodging Accomodations
South Carolina Lodging Accomodations
South Dakota Lodging Accomodations
Tennessee Lodging Accomodations
Texas Lodging Accomodations
Utah Lodging Accomodations
Virginia Lodging Accomodations
Vermont Lodging Accomodations
Washington Lodging Accomodations
Wisconsin Lodging Accomodations
West Virginia Lodging Accomodations
Wyoming Lodging Accomodations
Most Popular Town Destinations
Ashland Oregon Lodging
Aspen Colorado Lodging
Barryville New York Lodging
Bend Oregon Lodging
Big Sky Montana Lodging
Boise Idaho Lodging
Bozeman Montana Lodging
Breckenridge Colorado Lodging
Buena Vista Colorado Lodging
Cascade Colorado Lodging
Charlemont Massachusetts Lodging
Clayton Idaho Lodging
Colorado Springs Colorado Lodging
Cosby Tennessee Lodging
Crested Butte Colorado Lodging
Denali Park Alaska Lodging
Denver Colorado Lodging
Eugene Oregon Lodging
Flagstaff Arizona Lodging
Grants Pass Oregon Lodging
Helena Montana Lodging
Hood River Oregon Lodging
Idleyld Park Oregon Lodging
Index Washington Lodging
Jackson Wyoming Lodging
Kalispell Montana Lodging
Keystone Colorado Lodging
Kooskia Idaho Lodging
Lansing West Virginia Lodging
Los Angeles California Lodging
Mammoth Lakes California Lodging
Manitou Springs Colorado Lodging
McCall Idaho Lodging
Milford Pennsylvania Lodging
Missoula Montana Lodging
Moab Utah Lodging
Nathrop Colorado Lodging
Newport Oregon Lodging
Oakland California Lodging
Park City Utah Lodging
Phoenix Arizona Lodging
Pigeon Forge Tennessee Lodging
Poncha springs Colorado Lodging
Portland Oregon Lodging
Sacramento California Lodging
Salem Oregon Lodging
Salida Colorado Lodging
Salmon Idaho Lodging
Salt Lake City Utah Lodging
San Diego California Lodging
San Francisco California Lodging
Santa Fe New Mexico Lodging
Seattle Washington Lodging
South Lake Tahoe California Lodging
Stanley Idaho Lodging
Steamboat Springs Colorado Lodging
Sun Valley Idaho Lodging
Taos New Mexico Lodging
Vail Colorado Lodging
Victor Idaho Lodging
Winter Park Colorado Lodging
Yachats Oregon Lodging
Hotels & Motels Lodging Properties
Alaska Hotels & Motels
Alabama Hotels & Motels
Arkansas Hotels & Motels
Arizona Hotels & Motels
California Hotels & Motels
Colorado Hotels & Motels
Connecticut Hotels & Motels
Delaware Hotels & Motels
Florida Hotels & Motels
Georgia Hotels & Motels
Hawaii Hotels & Motels
Iowa Hotels & Motels
Idaho Hotels & Motels
Illinois Hotels & Motels
Indiana Hotels & Motels
Kansas Hotels & Motels
Kentucky Hotels & Motels
Louisiana Hotels & Motels
Massachusetts Hotels & Motels
Maryland Hotels & Motels
Maine Hotels & Motels
Michigan Hotels & Motels
Minnesota Hotels & Motels
Missouri Hotels & Motels
Mississippi Hotels & Motels
Montana Hotels & Motels
North Carolina Hotels & Motels
North Dakota Hotels & Motels
Nebraska Hotels & Motels
New Hampshire Hotels & Motels
New Jersey Hotels & Motels
New Mexico Hotels & Motels
Nevada Hotels & Motels
New York Hotels & Motels
Ohio Hotels & Motels
Oklahoma Hotels & Motels
Oregon Hotels & Motels
Pennsylvania Hotels & Motels
Rhode Island Hotels & Motels
South Carolina Hotels & Motels
South Dakota Hotels & Motels
Tennessee Hotels & Motels
Texas Hotels & Motels
Utah Hotels & Motels
Virginia Hotels & Motels
Vermont Hotels & Motels
Washington Hotels & Motels
Wisconsin Hotels & Motels
West Virginia Hotels & Motels
Wyoming Hotels & Motels

Bed & Breakfasts Lodging Properties
Alaska Bed & Breakfasts
Alabama Bed & Breakfasts
Arizona Bed & Breakfasts
California Bed & Breakfasts
Colorado Bed & Breakfasts
Connecticut Bed & Breakfasts
Georgia Bed & Breakfasts
Idaho Bed & Breakfasts
Louisiana Bed & Breakfasts
Massachusetts Bed & Breakfasts
Maine Bed & Breakfasts
Michigan Bed & Breakfasts
Missouri Bed & Breakfasts
Montana Bed & Breakfasts
North Carolina Bed & Breakfasts
New Hampshire Bed & Breakfasts
New Jersey Bed & Breakfasts
New Mexico Bed & Breakfasts
New York Bed & Breakfasts
Ohio Bed & Breakfasts
Oregon Bed & Breakfasts
Pennsylvania Bed & Breakfasts
Tennessee Bed & Breakfasts
Texas Bed & Breakfasts
Utah Bed & Breakfasts
Virginia Bed & Breakfasts
Vermont Bed & Breakfasts
Washington Bed & Breakfasts
West Virginia Bed & Breakfasts
Wyoming Bed & Breakfasts

Campgrounds Lodging Properties
Alaska Campgrounds
Arizona Campgrounds
California Campgrounds
Colorado Campgrounds
Idaho Campgrounds
Maine Campgrounds
Montana Campgrounds
Nevada Campgrounds
New York Campgrounds
Oregon Campgrounds
Pennsylvania Campgrounds
Tennessee Campgrounds
Utah Campgrounds
Virginia Campgrounds
Washington Campgrounds
West Virginia Campgrounds

Cabins, Condos, and Vacation Rentals Lodging Properties
Alaska Cabins, Condos, and Vacation Rentals
Arkansas Cabins, Condos, and Vacation Rentals
Arizona Cabins, Condos, and Vacation Rentals
California Cabins, Condos, and Vacation Rentals
Colorado Cabins, Condos, and Vacation Rentals
Florida Cabins, Condos, and Vacation Rentals
Georgia Cabins, Condos, and Vacation Rentals
Hawaii Cabins, Condos, and Vacation Rentals
Idaho Cabins, Condos, and Vacation Rentals
Illinois Cabins, Condos, and Vacation Rentals
Maryland Cabins, Condos, and Vacation Rentals
Maine Cabins, Condos, and Vacation Rentals
Michigan Cabins, Condos, and Vacation Rentals
Minnesota Cabins, Condos, and Vacation Rentals
Missouri Cabins, Condos, and Vacation Rentals
Mississippi Cabins, Condos, and Vacation Rentals
Montana Cabins, Condos, and Vacation Rentals
North Carolina Cabins, Condos, and Vacation Rentals
New Hampshire Cabins, Condos, and Vacation Rentals
New Mexico Cabins, Condos, and Vacation Rentals
Nevada Cabins, Condos, and Vacation Rentals
Oregon Cabins, Condos, and Vacation Rentals
Pennsylvania Cabins, Condos, and Vacation Rentals
South Carolina Cabins, Condos, and Vacation Rentals
South Dakota Cabins, Condos, and Vacation Rentals
Tennessee Cabins, Condos, and Vacation Rentals
Texas Cabins, Condos, and Vacation Rentals
Utah Cabins, Condos, and Vacation Rentals
Virginia Cabins, Condos, and Vacation Rentals
Vermont Cabins, Condos, and Vacation Rentals
Washington Cabins, Condos, and Vacation Rentals
West Virginia Cabins, Condos, and Vacation Rentals
Wyoming Cabins, Condos, and Vacation Rentals

Youth Hostels Lodging Properties
Colorado Youth Hostels
Montana Youth Hostels
New Mexico Youth Hostels
Oregon Youth Hostels

Guest Ranches & Dude Ranches Lodging Properties
Colorado Guest Ranches & Dude Ranches
New Mexico Guest Ranches & Dude Ranches
Oregon Guest Ranches & Dude Ranches
Texas Guest Ranches & Dude Ranches
Wyoming Guest Ranches & Dude Ranches

Cabins for Sale Lodging Properties
Alaska Cabins for Sale
Colorado Cabins for Sale


Debugging Information
ColdFusion Server Standard 7,0,2,142559
Template /businesses/showstate.cfm
Time Stamp 03-Dec-08 04:05 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.103.63.61
Host Name 38.103.63.61


Execution Time

Total Time Avg Time Count Template
1155 ms 1155 ms 1 /home/locallod/public_html/businesses/showstate.cfm
551 ms 551 ms 1 /home/locallod/public_html/common/subheader.cfm
550 ms 550 ms 1 /home/locallod/public_html/common/sidenav.cfm
548 ms 548 ms 1 /home/locallod/public_html/common/sidenav_typestate.cfm
466 ms 466 ms 1 /home/locallod/public_html/common/masterfooter.cfm
464 ms 464 ms 1 /home/locallod/public_html/common/summary_boxes.cfm
7 ms 0 ms 175 /home/locallod/public_html/businesses/inc_stateurl.cfm
2 ms 2 ms 1 /home/locallod/public_html/Application.cfm
2 ms 1 ms 2 /home/locallod/public_html/businesses/inc_caturl.cfm
2 ms 0 ms 51 /home/locallod/public_html/destinations/inc_stateurl.cfm
1 ms 0 ms 9 /home/locallod/public_html/businesses/inc_cityurl.cfm
1 ms 1 ms 1 /home/locallod/public_html/common/sidenav_members.cfm
1 ms 0 ms 62 /home/locallod/public_html/destinations/inc_cityurl.cfm
0 ms 0 ms 1 /home/locallod/public_html/common/language_english.cfm
0 ms 0 ms 1 /home/locallod/public_html/common/masterheader.cfm
0 ms 0 ms 1 /home/locallod/public_html/common/subfooter.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1160 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getbiztype (Datasource=RIVERS, Time=9ms, Records=1) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:40.040
 
	SELECT *
		FROM biz_types 
	 WHERE biztype_id = 3 
getstate (Datasource=RIVERS, Time=41ms, Records=56) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:40.040
 
	SELECT biz_contacts.state, states.*, biz_contacts.city
	  FROM biz_contacts INNER JOIN states ON biz_contacts.state = states.abv
	 WHERE biz_contacts.state='NM' AND type = 3 
getstate_sn (Datasource=RIVERS, Time=26ms, Records=30) in /home/locallod/public_html/common/sidenav_typestate.cfm @ 16:05:40.040
	SELECT DISTINCT s.abv, s.name, bt.biztype_desc
	FROM (states s INNER JOIN biz_contacts bc ON s.abv=bc.state) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
	WHERE bc.active = 1 AND bc.type = 3 
	ORDER BY s.name
getstateother_sn (Datasource=RIVERS, Time=403ms, Records=5) in /home/locallod/public_html/common/sidenav_typestate.cfm @ 16:05:41.041
	SELECT DISTINCT s.abv, s.name, bt.biztype_desc, bt.biztype_id, bc.type
	FROM (states s INNER JOIN biz_contacts bc ON s.abv=bc.state) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
	WHERE bc.active = 1  AND s.abv = 'NM' AND bt.lodging = 1
	ORDER BY s.name
GetAllListings (Datasource=RIVERS, Time=9ms, Records=9) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:41.041
   SELECT DISTINCT bc.cityid
	 FROM biz_contacts bc 
	WHERE bc.state = 'NM'
		AND bc.type = 3
	  AND bc.active = 1
	ORDER BY bc.city
getpremiumlistings (Datasource=RIVERS, Time=25ms, Records=0) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:41.041
   SELECT DISTINCT bc.listingnumber, bc.active, bc.paytype, bc.type, bc.bizamens, bc.bizname, bc.city, bc.state, bc.description, bc.website, bc.pets, bp.listingnumber, bp.mainphoto
	 FROM biz_contacts bc LEFT OUTER JOIN biz_photos bp ON bc.listingnumber = bp.listingnumber
	WHERE bc.state = 'NM'
	  AND bc.paytype <> 'free'
	  AND bc.active = 1
		AND bc.type = 3 
getfreelistings (Datasource=RIVERS, Time=30ms, Records=56) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:41.041
		 SELECT DISTINCT bc.listingnumber, bc.active, bc.paytype, bc.shortdescription, bc.bizname, bc.address1, bc.address2, bc.city, bc.state, bc.zip, bc.biz_phone1
		 FROM biz_contacts bc LEFT OUTER JOIN outfitter_trips ot ON bc.listingnumber = ot.listingnumber
		WHERE bc.state = 'NM'
			AND bc.paytype = 'free'
			AND bc.active = 1
			AND bc.type = 3
	 ORDER BY bc.city, bc.bizname
	
cityinfo (Datasource=allaboutmountaintowns1, Time=4ms, Records=9) in /home/locallod/public_html/businesses/showstate.cfm @ 16:05:41.041
											SELECT city, cityid
												FROM city 
											 WHERE cityid IN (233,5281,5282,2528,123,5285,234,121,84)
											 ORDER BY city
										
getlodgebiztypes (Datasource=RIVERS, Time=0ms, Records=7, Cached Query) in /home/locallod/public_html/common/summary_boxes.cfm @ 16:05:41.041
			SELECT *
			FROM biz_types
			WHERE lodging = 1
			ORDER BY biztype_id
		
get_lodge_states (Datasource=RIVERS, Time=44ms, Records=26546, Cached Query) in /home/locallod/public_html/common/summary_boxes.cfm @ 16:05:41.041
						SELECT bc.state, bc.city, bc.zip, s.name, s.abv, bt.*
							FROM (biz_contacts bc INNER JOIN states s ON bc.state = s.abv) INNER JOIN biz_types bt ON bc.type = bt.biztype_id
						 WHERE bc.active = 1
							AND bt.lodging = 1
						ORDER BY