Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingNevada GamblingReno Gambling
Circus Circus at THE ROW
Nearby Casinos
Hotel ReservationsNewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Nevada Gambling
Reno Gambling
Circus Circus at THE ROW
Hotel ReservationsNewsTweetsMapExecutivesOwnership

Casinos Near Circus Circus at THE ROW

There are 100 casinos within 100 miles of Circus Circus at THE ROW

Map Index Distance (miles) Casino
  Circus Circus at THE ROW  find on map
500 North Sierra Street, Reno, Nevada
0.0 Circus Circus at THE ROW  find on map
500 North Sierra Street, Reno, Nevada
0.1 Silver Legacy at THE ROW  find on map
407 North Virginia Street, Reno, Nevada
0.2 Eldorado at THE ROW  find on map
345 North Virginia Street, Reno, Nevada
0.3 Siri's Casino  find on map
241 North Virginia Street, Reno, Nevada
0.3 Little Nugget  find on map
233 North Virginia Street, Reno, Nevada
0.3 Sands Regency Casino Hotel  find on map
345 North Arlington Avenue, Reno, Nevada
0.3 Harrah's Reno  find on map
219 North Center Street, Reno, Nevada
0.3 Club Cal Neva Casino  find on map
38 East Second Street, Reno, Nevada
0.6 Gold Dust West - Reno  find on map
444 Vine Street, Reno, Nevada
0.6 Gold 'N Silver Inn  find on map
790 West Fourth Street, Reno, Nevada
0.8 Ramada Reno Hotel and Casino  find on map
1010 East Sixth Street, Reno, Nevada
2.0 Sak' N Save  find on map
1901 Silverada Boulevard, Reno, Nevada
2.0 Grand Sierra Resort and Casino  find on map
2500 East Second Street, Reno, Nevada
2.3 Rail City Casino  find on map
2121 Victorian Avenue, Sparks, Nevada
2.4 Peppermill Reno  find on map
2707 South Virginia Street, Reno, Nevada
2.6 Flowing Tide Pub 1  find on map
10580 North McCarran Boulevard, No.109, Reno, Nevada
2.6 Baldini's Casino  find on map
865 South Rock Boulevard, Sparks, Nevada
2.6 Flowing Tide Pub 5  find on map
9570 South McCarran Boulevard, Suite 101, Reno, Nevada
2.8 Reno-Tahoe International Airport Slots  find on map
2001 East Plumb Lane, Reno, Nevada
2.8 Bonanza Casino  find on map
4720 North Virginia Street, Reno, Nevada
3.0 Nugget Casino Resort  find on map
1100 Nugget Avenue, Sparks, Nevada
3.1 Dotty's 99  find on map
1144 Victorian Avenue, Sparks, Nevada
3.2 Atlantis Casino Resort & Spa  find on map
3800 South Virginia Street, Reno, Nevada
3.4 JJ's Sports and Spirits  find on map
950 Holman Way, Sparks, Nevada
3.9 Hobey's Casino Restaurant  find on map
5195 Sun Valley Boulevard, Sun Valley, Nevada
4.2 Sierra Sid's Casino  find on map
200 North McCarran Boulevard, Sparks, Nevada
4.3 Flowing Tide Pub 3  find on map
4690 Longley Lane, Suite 30, Reno, Nevada
4.3 Western Village Inn and Casino  find on map
815 Nichols Boulevard, Sparks, Nevada
4.5 Scolari's Food & Drug Company 8  find on map
5430 Sun Valley Boulevard, Sun Valley, Nevada
4.9 Raley's  find on map
3310 South McCarran Boulevard, Reno, Nevada
5.3 Flowing Tide Pub 4  find on map
1450 East Prater Way, Sparks, Nevada
5.7 TA Petro - Sparks  find on map
1950 East Greg Street, Sparks, Nevada
6.9 Flowing Tide Pub 2  find on map
465 South Meadows Parkway, No.5, Reno, Nevada
7.1 Sierra Junction  find on map
680 South Meadows Parkway, Suite 100, Reno, Nevada
7.1 Sierra Gold - Reno  find on map
680 South Meadows Parkway, Suite 200, Reno, Nevada
8.0 Boomtown Casino - Reno  find on map
2100 Garson Road, Verdi, Nevada
8.7 Tamarack Casino  find on map
13101 South Virginia Street, Reno, Nevada
10.1 Gold Ranch Casino & RV Resort  find on map
350 Gold Ranch Road, Verdi, Nevada
13.8 Bordertown Casino RV Resort  find on map
19575 US Highway 395 North, Reno, Nevada
17.6 Bucket of Blood Saloon  find on map
1 South C Street, Virginia City, Nevada
17.6 Mark Twain Saloon Casino  find on map
62 South C Street, Virginia City, Nevada
21.2 Grand Lodge Casino  find on map
111 Country Club Drive, Incline Village, Nevada
22.3 Nevada Nugget - Dayton  find on map
6 Retail Road, Dayton, Nevada
22.3 Pioneer Crossing Casino - Dayton  find on map
4 Pine Cone Road, Dayton, Nevada
22.5 Carson Plains Casino  find on map
6996 Highway 50 East, Dayton, Nevada
23.2 Gold Ranch Casino  find on map
755 Highway 50 East, Dayton, Nevada
23.3 Tahoe Nugget  find on map
20 State Route 28, Crystal Bay, Nevada
23.3 Tahoe Biltmore Lodge and Casino  find on map
5 State Route 28, Crystal Bay, Nevada
23.3 Crystal Bay Club Casino  find on map
14 State Highway 28, Crystal Bay, Nevada
23.3 Cyrstal Bay Casino Lake Tahoe  find on map
14 State Route 28, Crystal Bay, Nevada
23.6 Dotty's 55  find on map
145 East Highway 50, Dayton, Nevada
23.7 Comstock Casino - Carson City  find on map
3680 Goni Road, Carson City, Nevada
24.4 SlotWorld Cabaret Casino  find on map
324 East Winnie Lane, Carson City, Nevada
24.8 SlotWorld Casino  find on map
3879 Highway 50 East, Carson City, Nevada
24.8 Jackpot Crossing Casino - Carson City  find on map
1897 North Edmonds Drive, Carson City, Nevada
24.9 Dotty's 10  find on map
2260 Route 50 East, Carson City, Nevada
25.0 Gold Dust West - Carson City  find on map
2171 Highway 50 East, Carson City, Nevada
25.0 Lucky Strike Casino  find on map
444 East William Street, Suite 8, Carson City, Nevada
25.3 Cactus Jack's Casino  find on map
420 North Carson Street, Carson City, Nevada
25.3 Carson Nugget Casino Hotel  find on map
507 North Carson Street, Carson City, Nevada
25.9 MAX Casino Carson City  find on map
900 South Carson Street, Carson City, Nevada
27.7 Dotty's 12  find on map
3771 South Carson Street, Carson City, Nevada
27.7 Casino Fandango  find on map
3800 South Carson Street, Carson City, Nevada
28.7 Bodines Casino  find on map
5650 South Carson Street, Carson City, Nevada
29.9 Pilot Casino - Fernley  find on map
465 Pilot Road, Fernley, Nevada
29.9 Love's Travel Stop 246  find on map
825 Commerce Center Drive, Fernley, Nevada
30.0 Jackpot Crossing Casino - Fernley  find on map
206 Logan Lane, Fernley, Nevada
30.4 Wigwam Casino  find on map
255 West Main Street, Fernley, Nevada
31.6 Fernley Nugget  find on map
1190 East Main Street, Suite A, Fernley, Nevada
32.0 Dotty's 79  find on map
1440 US Highway 95A North, Fernley, Nevada
32.2 Silverado Casino  find on map
1380 West Newlands Drive, Fernley, Nevada
32.4 Silver Strike Casino  find on map
1190 Highway 50 East, Silver Springs, Nevada
32.4 Terrible's Casino - Fernley  find on map
480 Truck Inn Way, Fernley, Nevada
32.5 Nugget - Silver Springs  find on map
1280 Highway 95A North, Silver Springs, Nevada
32.5 Pioneer Crossing Casino - Fernley  find on map
1705 US Highway 50A, Fernley, Nevada
39.3 Lakeside Inn and Casino  find on map
168 Highway 50, Stateline, Nevada
39.8 Carson Valley Inn  find on map
1627 US Highway 395 North, Minden, Nevada
39.9 Hard Rock Hotel & Casino - Lake Tahoe  find on map
50 Highway 50, Stateline, Nevada
39.9 MontBleu Resort Casino & Spa  find on map
55 Highway 50, Stateline, Nevada
39.9 Dotty's 71  find on map
31 Highway 50, Stateline, Nevada
40.0 C.O.D. Casino  find on map
1593 Esmeralda Avenue, Minden, Nevada
40.0 Harvey's Lake Tahoe  find on map
18 Highway 50, Stateline, Nevada
40.0 Harrah's Lake Tahoe Hotel and Casino  find on map
15 Highway 50, Stateline, Nevada
40.9 Sharkey's Casino  find on map
1440 US Highway 395 North, Gardnerville, Nevada
43.1 Wa She Shu Casino  find on map
1003 US Highway 395 North, Gardnerville, Nevada
51.2 Dotty's 82  find on map
120 North Main Street, Yerington, Nevada
51.2 Dini's Lucky Club  find on map
45 North Main Street, Yerington, Nevada
51.3 Pioneer Crossing Casino - Yerington  find on map
11 North Main Street, Yerington, Nevada
51.4 Oasis Springs Casino  find on map
4901 Reno Highway, Fallon, Nevada
54.2 Dotty's 17  find on map
2111 West Williams Avenue, Fallon, Nevada
54.3 Churchill Springs Casino  find on map
2015 West Williams Avenue, Fallon, Nevada
54.6 Stockman's Casino  find on map
1560 West Williams Avenue, Fallon, Nevada
54.9 Fallon Speedway Market  find on map
1000 West Williams Avenue, Fallon, Nevada
55.0 Depot Casino and Restaurant  find on map
875 West Williams Avenue, Fallon, Nevada
55.1 Bonanza Inn & Casino  find on map
855 West Williams Avenue, Fallon, Nevada
55.5 Comstock Casino - Fallon  find on map
1975 South Taylor Street, Fallon, Nevada
55.6 Headquarters Bar and Casino  find on map
134 South Maine Street, Fallon, Nevada
55.6 Nugget - Fallon  find on map
70 South Maine Street, Fallon, Nevada
56.2 Walker River Resort  find on map
700 Hudson Way, Smith, Nevada
57.6 Nevada Trading Company  find on map
3900 Carter Way, Wellington, Nevada
About us | Editorial Staff | Feedback | Advertising
CASINO CITY NETWORK: Online Casino City | Casino City Times | Poker Zone | RGT Online | Casino City Press | Gaming Directory

 


Debugging Information
ColdFusion Server Standard 9,0,1,274733
Template /map.cfm
Time Stamp 18-Apr-21 05:21 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 216.116.192.60
Host Name 216.116.192.60


Execution Time

Total Time Avg Time Count Template
115 ms 115 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
96 ms 96 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
19 ms 10 ms 2 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/MicroLeftNavQueries.cfm
1 ms 1 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/footerMicro.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/minisites.casinocity.com/htdocs/Application.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/GoogleAnalyticsJavaScript.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/OCCBonusBlock.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/casinocitynetwork.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/legal.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mappingfunctions.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/microLeftNav.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/rightSide2.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
117 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=6ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 17:21:51.051
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		WHERE dbo.StringToUrl(Property.City) = 'reno'
		  AND Property.UrlOrganizationName = 'circus-circus-at-the-row'
  		  AND Property.PropertyStatusTypeId =1
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=7ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT 	Top 1 Property.PropertyId, 
		Property.PlaceId,
		Property.Abbreviation,
		Property.OrganizationName,
		CASE
			WHEN IsNull(Property.ShortOrganizationName,'') = '' THEN Property.OrganizationName
			ELSE Property.ShortOrganizationName
		END ShortOrganizationName,
		Property.Address1,
		Property.Address2,
		Property.Address3,
		Property.City,
		StateNamePlaces.PlaceName AS StateName,
		Property.PostalCode,
		Property.CCURL,
		Property.URL,
		Property.EmailGeneral,
		Property.Longitude,
		Property.Latitude,
		Property.OwnerType,
		IsNull(Property.TravelNowID, 0) TravelNowId,
		Property.Latitude,
		Property.Longitude,
		Property.Geolocation,
		GeocodePrecision.GeocodePrecision,
		Property.GeocodeConfidence,
		CASE
			when Property.OwnerType = 'INDIAN' then 'Native American'
			else ''
		END formatedOwnerType,
		Property.PropertyType,
		Casino.CasinoName,
		Casino.StructureType,
		IsNull(Casino.SquareFeet, 0) SquareFeet,
		LTrim(RTrim(Casino.Hours)) Hours,
		PropertyStatusTypes.*,
		IsNull(SlotPropertyAndGame.Quantity, 0) SlotQuantity,
		IsNull(TableGamePropertyAndGame.Quantity, 0) TableQuantity,
		
		StatePlaces.PlaceCode State,
		StatePlaces.PlaceName StateName,
		CountryPlaces.PlaceCode Country,
		CountryPlaces.PlaceId   CountryId,
		CASE	WHEN IsNull(CountryPlaces.CommonName,'') <> '' THEN CountryPlaces.CommonName
				ELSE CountryPlaces.PlaceName
		END	FullCountryName,
		PropertyDetails.CasinoCityUrl MicrositeUrl,
		(
			SELECT 	Top 1 PropertyAndExecutiveUpdates.Id 
			FROM PropertyAndExecutiveUpdates 
			INNER JOIN ExecutiveUpdates ON
				PropertyAndExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdates.ExecutiveUpdateId
			INNER JOIN ExecutiveUpdatesAndExecutiveResponsibilities ON
				ExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveUpdateId
			INNER JOIN ExecutiveResponsibility ON 
				ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveResponsibilityId = ExecutiveResponsibility.ExecutiveResponsibilityId
			WHERE PropertyAndExecutiveUpdates.PropertyId= Property.PropertyId
			AND ExecutiveUpdates.EndDate IS NULL
			AND ExecutiveUpdates.Status = 'A'
		) AnyExecs,
		(
			SELECT 	Top 1 PropertyAndGamingBusinesses.PropertyId
			FROM PropertyAndGamingBusinesses 
			WHERE PropertyID = Property.PropertyId
			AND PropertyAndGamingBusinesses.EndActiveDate IS NULL
		) AnyOwners,
		(
			SELECT 	Top 1 PropertyAndImage.PropertyId
			FROM 	PropertyAndImage
			INNER JOIN Image ON 
				PropertyAndImage.ImageID = Image.ImageID
			WHERE 	PropertyAndImage.PropertyId = Property.PropertyId
		) AnyImages,
		
	(SELECT COUNT (DISTINCT Articles.ArticleId)
	FROM Articles
	INNER JOIN Content 
		ON Articles.ContentId = Content.ContentId
	INNER Join ContentAndObjects ON
		(ContentAndObjects.ContentId = Content.ContentId
		AND ContentAndObjects.ObjectId = Property.PropertyId AND
		ContentAndObjects.TableId = 1)
	) HaveNews
	
	FROM	Property
	INNER JOIN PropertyDetails ON Property.PropertyId = PropertyDetails.PropertyId
	LEFT JOIN GeocodePrecision ON Property.GeocodePrecisionId = GeocodePrecision.GeocodePrecisionId
	-- State Name
	LEFT JOIN PropertyAndPlaces PropertyAndStateNamePlaces ON (Property.PropertyId = PropertyAndStateNamePlaces.PropertyId
		AND PropertyAndStateNamePlaces.PlaceLevel = 2
		AND PropertyAndStateNamePlaces.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StateNamePlaces ON 
		PropertyAndStateNamePlaces.PlaceId = StateNamePlaces.PlaceId
	-- Country Info
	INNER JOIN PropertyAndPlaces PropertyAndPlacesCountry ON (Property.PropertyId = PropertyAndPlacesCountry.PropertyId
		AND PropertyAndPlacesCountry.PlaceLevel =1
		AND PropertyAndPlacesCountry.LocationTypeCode = 'P'
		)
	INNER JOIN Places CountryPlaces ON 
		PropertyAndPlacesCountry.PlaceId = CountryPlaces.PlaceId
	LEFT JOIN ActiveCountryMiniSites ON CountryPlaces.PlaceId = ActiveCountryMiniSites.PlaceId
	-- State Info
	LEFT JOIN PropertyAndPlaces PropertyAndPlacesState ON (Property.PropertyId = PropertyAndPlacesState.PropertyId
		AND PropertyAndPlacesState.PlaceLevel = 2
		AND CountryPlaces.ExposeChildrenInCasinoCity = 1
		AND PropertyAndPlacesState.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StatePlaces ON 
		PropertyAndPlacesState.PlaceId = StatePlaces.PlaceId
	LEFT JOIN ActiveStateMiniSites ON
		StatePlaces.PlaceId = ActiveStateMiniSites.PlaceId
	-- Slot Count
	LEFT JOIN PropertyAndGame SlotPropertyAndGame ON
		Property.PropertyId = SlotPropertyAndGame.PropertyId AND SlotPropertyAndGame.GameId = 100
	LEFT JOIN Game SlotGame ON
		SlotPropertyAndGame.GameID = SlotGame.GameID AND SlotGame.[Description] = 'Slots'
	-- Table Game Count
	LEFT JOIN PropertyAndGame TableGamePropertyAndGame ON
		Property.PropertyId = TableGamePropertyAndGame.PropertyId AND TableGamePropertyAndGame.GameId = 10300
	LEFT JOIN Game TableGame ON
		TableGamePropertyAndGame.GameID = TableGame.GameID AND TableGame.[Description] = 'Table Games'

	LEFT JOIN PropertyStatusTypes ON
		Property.PropertyStatusTypeID=PropertyStatusTypes.PropertyStatusTypeID
	LEFT JOIN Casino ON
		Property.PropertyId = Casino.PropertyId
	LEFT JOIN Minisites ON
		Property.PropertyId = Minisites.PropertyId
	LEFT JOIN Hosts ON
		Minisites.MinisiteId = Hosts.MinisiteId
	WHERE	Property.Propertyid= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5600

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=2ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT PlaceGroupId, FqDn,
			 CASE WHEN ActiveRegionMinisites.PlaceGroup IN ('Central America','South America') THEN 'Central and South America'
			 		ELSE ActiveRegionMinisites.PlaceGroup
			 END	PlaceGroup
	FROM  ActiveRegionMinisites
	WHERE ActiveRegionMinisites.PlaceGroup =
		(	SELECT CASE WHEN PlaceGroups.PlaceGroup = 'Central America'	THEN 'South America'
							WHEN PlaceGroups.PlaceGroup = 'Russian Federation' THEN 'Europe'
							ELSE PlaceGroups.PlaceGroup
					 END PlaceGroup
			FROM 	Places
			INNER JOIN PlaceGroupsAndPlaces	ON PlaceGroupsAndPlaces.PlaceId = Places.PlaceId
			INNER JOIN PlaceGroups				ON PlaceGroups.PlaceGroupID = PlaceGroupsAndPlaces.PlaceGroupId
			WHERE Places.PlaceId = 2
			AND 	PlaceGroups.PlaceGroup IN ('Europe','North America','South America','Central America','Asia','Africa','Oceania','Caribbean')
		)
navStructure (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=13) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5600

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=82ms, Records=100) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 17:21:51.051
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 5600;
				SELECT TOP 100 Property.PropertyId,
				Property.OrganizationName,
				Property.CCURL,
				 Property.Address1,
				 Property.Address2,
				 Property.City,
				 Property.StateName,
				 Property.CountryName,
				 Property.PostalCode,
				 Property.Country AS CountryCode,
				
				 Property.PropertyId as CasinoId,
				 Property.Latitude, Property.Longitude,
				 Property.Geolocation.STDistance(@GeoLocation)/1609.344  Distance
				FROM Property
				INNER JOIN PropertyStatusTypes	ON Property.PropertyStatusTypeId = PropertyStatusTypes.PropertyStatusTypeID
				WHERE Property.Latitude IS NOT NULL 
				and Property.Longitude IS NOT null
				AND Property.Geolocation.STDistance(@GeoLocation)/1609.344  <= 100
				AND Property.PropertyStatusTypeId = 1
				AND Property.PropertyId <> 10600
				ORDER BY Property.Geolocation.STDistance(@GeoLocation)
			
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT 	Top 1 Property.PropertyId, 
		Property.PlaceId,
		Property.Abbreviation,
		Property.OrganizationName,
		CASE
			WHEN IsNull(Property.ShortOrganizationName,'') = '' THEN Property.OrganizationName
			ELSE Property.ShortOrganizationName
		END ShortOrganizationName,
		Property.Address1,
		Property.Address2,
		Property.Address3,
		Property.City,
		StateNamePlaces.PlaceName AS StateName,
		Property.PostalCode,
		Property.CCURL,
		Property.URL,
		Property.EmailGeneral,
		Property.Longitude,
		Property.Latitude,
		Property.OwnerType,
		IsNull(Property.TravelNowID, 0) TravelNowId,
		Property.Latitude,
		Property.Longitude,
		Property.Geolocation,
		GeocodePrecision.GeocodePrecision,
		Property.GeocodeConfidence,
		CASE
			when Property.OwnerType = 'INDIAN' then 'Native American'
			else ''
		END formatedOwnerType,
		Property.PropertyType,
		Casino.CasinoName,
		Casino.StructureType,
		IsNull(Casino.SquareFeet, 0) SquareFeet,
		LTrim(RTrim(Casino.Hours)) Hours,
		PropertyStatusTypes.*,
		IsNull(SlotPropertyAndGame.Quantity, 0) SlotQuantity,
		IsNull(TableGamePropertyAndGame.Quantity, 0) TableQuantity,
		
		StatePlaces.PlaceCode State,
		StatePlaces.PlaceName StateName,
		CountryPlaces.PlaceCode Country,
		CountryPlaces.PlaceId   CountryId,
		CASE	WHEN IsNull(CountryPlaces.CommonName,'') <> '' THEN CountryPlaces.CommonName
				ELSE CountryPlaces.PlaceName
		END	FullCountryName,
		PropertyDetails.CasinoCityUrl MicrositeUrl,
		(
			SELECT 	Top 1 PropertyAndExecutiveUpdates.Id 
			FROM PropertyAndExecutiveUpdates 
			INNER JOIN ExecutiveUpdates ON
				PropertyAndExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdates.ExecutiveUpdateId
			INNER JOIN ExecutiveUpdatesAndExecutiveResponsibilities ON
				ExecutiveUpdates.ExecutiveUpdateId = ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveUpdateId
			INNER JOIN ExecutiveResponsibility ON 
				ExecutiveUpdatesAndExecutiveResponsibilities.ExecutiveResponsibilityId = ExecutiveResponsibility.ExecutiveResponsibilityId
			WHERE PropertyAndExecutiveUpdates.PropertyId= Property.PropertyId
			AND ExecutiveUpdates.EndDate IS NULL
			AND ExecutiveUpdates.Status = 'A'
		) AnyExecs,
		(
			SELECT 	Top 1 PropertyAndGamingBusinesses.PropertyId
			FROM PropertyAndGamingBusinesses 
			WHERE PropertyID = Property.PropertyId
			AND PropertyAndGamingBusinesses.EndActiveDate IS NULL
		) AnyOwners,
		(
			SELECT 	Top 1 PropertyAndImage.PropertyId
			FROM 	PropertyAndImage
			INNER JOIN Image ON 
				PropertyAndImage.ImageID = Image.ImageID
			WHERE 	PropertyAndImage.PropertyId = Property.PropertyId
		) AnyImages,
		
	(SELECT COUNT (DISTINCT Articles.ArticleId)
	FROM Articles
	INNER JOIN Content 
		ON Articles.ContentId = Content.ContentId
	INNER Join ContentAndObjects ON
		(ContentAndObjects.ContentId = Content.ContentId
		AND ContentAndObjects.ObjectId = Property.PropertyId AND
		ContentAndObjects.TableId = 1)
	) HaveNews
	
	FROM	Property
	INNER JOIN PropertyDetails ON Property.PropertyId = PropertyDetails.PropertyId
	LEFT JOIN GeocodePrecision ON Property.GeocodePrecisionId = GeocodePrecision.GeocodePrecisionId
	-- State Name
	LEFT JOIN PropertyAndPlaces PropertyAndStateNamePlaces ON (Property.PropertyId = PropertyAndStateNamePlaces.PropertyId
		AND PropertyAndStateNamePlaces.PlaceLevel = 2
		AND PropertyAndStateNamePlaces.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StateNamePlaces ON 
		PropertyAndStateNamePlaces.PlaceId = StateNamePlaces.PlaceId
	-- Country Info
	INNER JOIN PropertyAndPlaces PropertyAndPlacesCountry ON (Property.PropertyId = PropertyAndPlacesCountry.PropertyId
		AND PropertyAndPlacesCountry.PlaceLevel =1
		AND PropertyAndPlacesCountry.LocationTypeCode = 'P'
		)
	INNER JOIN Places CountryPlaces ON 
		PropertyAndPlacesCountry.PlaceId = CountryPlaces.PlaceId
	LEFT JOIN ActiveCountryMiniSites ON CountryPlaces.PlaceId = ActiveCountryMiniSites.PlaceId
	-- State Info
	LEFT JOIN PropertyAndPlaces PropertyAndPlacesState ON (Property.PropertyId = PropertyAndPlacesState.PropertyId
		AND PropertyAndPlacesState.PlaceLevel = 2
		AND CountryPlaces.ExposeChildrenInCasinoCity = 1
		AND PropertyAndPlacesState.LocationTypeCode = 'P'
		)
	LEFT JOIN Places StatePlaces ON 
		PropertyAndPlacesState.PlaceId = StatePlaces.PlaceId
	LEFT JOIN ActiveStateMiniSites ON
		StatePlaces.PlaceId = ActiveStateMiniSites.PlaceId
	-- Slot Count
	LEFT JOIN PropertyAndGame SlotPropertyAndGame ON
		Property.PropertyId = SlotPropertyAndGame.PropertyId AND SlotPropertyAndGame.GameId = 100
	LEFT JOIN Game SlotGame ON
		SlotPropertyAndGame.GameID = SlotGame.GameID AND SlotGame.[Description] = 'Slots'
	-- Table Game Count
	LEFT JOIN PropertyAndGame TableGamePropertyAndGame ON
		Property.PropertyId = TableGamePropertyAndGame.PropertyId AND TableGamePropertyAndGame.GameId = 10300
	LEFT JOIN Game TableGame ON
		TableGamePropertyAndGame.GameID = TableGame.GameID AND TableGame.[Description] = 'Table Games'

	LEFT JOIN PropertyStatusTypes ON
		Property.PropertyStatusTypeID=PropertyStatusTypes.PropertyStatusTypeID
	LEFT JOIN Casino ON
		Property.PropertyId = Casino.PropertyId
	LEFT JOIN Minisites ON
		Property.PropertyId = Minisites.PropertyId
	LEFT JOIN Hosts ON
		Minisites.MinisiteId = Hosts.MinisiteId
	WHERE	Property.Propertyid= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5600

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT PlaceGroupId, FqDn,
			 CASE WHEN ActiveRegionMinisites.PlaceGroup IN ('Central America','South America') THEN 'Central and South America'
			 		ELSE ActiveRegionMinisites.PlaceGroup
			 END	PlaceGroup
	FROM  ActiveRegionMinisites
	WHERE ActiveRegionMinisites.PlaceGroup =
		(	SELECT CASE WHEN PlaceGroups.PlaceGroup = 'Central America'	THEN 'South America'
							WHEN PlaceGroups.PlaceGroup = 'Russian Federation' THEN 'Europe'
							ELSE PlaceGroups.PlaceGroup
					 END PlaceGroup
			FROM 	Places
			INNER JOIN PlaceGroupsAndPlaces	ON PlaceGroupsAndPlaces.PlaceId = Places.PlaceId
			INNER JOIN PlaceGroups				ON PlaceGroups.PlaceGroupID = PlaceGroupsAndPlaces.PlaceGroupId
			WHERE Places.PlaceId = 2
			AND 	PlaceGroups.PlaceGroup IN ('Europe','North America','South America','Central America','Asia','Africa','Oceania','Caribbean')
		)
navStructure (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=13) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 17:21:51.051
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5600


Scope Variables

Application Variables:
applicationname=Minisites
dbpassword=m0nsters,Inc
dbusername=CC-RO-CasinoCity
dsn=GamingProperties-RO-CasinoCity
googlemapkey=AIzaSyDM2pDbQRrl4ZeldPpxu1lf8nENUYv-BLM
googlemapkey3=AIzaSyD56LEu3WUieqGOTmHj08k_WHnsVpAyTr4
sitename=casinocity.com
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:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=nevada.casinocity.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=/map.cfm
PATH_TRANSLATED=D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
QUERY_STRING=site=nevada&city=reno&property=circus-circus-at-the-row&nearest=OK
REMOTE_ADDR=216.116.192.60
REMOTE_HOST=216.116.192.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/map.cfm
SERVER_NAME=nevada.casinocity.com
SERVER_PORT=3012
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Server Variables:
coldfusion=Struct (8)
os=Struct (5)
URL Parameters:
city=reno
nearest=OK
property=circus-circus-at-the-row
site=nevada
Debug Rendering Time: 14 ms