Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingNevada GamblingLas Vegas Gambling
MGM Grand Hotel & Casino Las Vegas
Nearby Casinos
Hotel ReservationsEntertainmentNewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Nevada Gambling
Las Vegas Gambling
MGM Grand Hotel & Casino Las Vegas
Hotel ReservationsEntertainmentNewsTweetsMapExecutivesOwnership

Casinos Near MGM Grand Hotel & Casino Las Vegas

There are 100 casinos within 100 miles of MGM Grand Hotel & Casino Las Vegas

Map Index Distance (miles) Casino
  MGM Grand Hotel & Casino Las Vegas  find on map
3799 Las Vegas Boulevard South, Las Vegas, Nevada
0.0 MGM Grand Hotel & Casino Las Vegas  find on map
3799 Las Vegas Boulevard South, Las Vegas, Nevada
0.2 Tropicana Las Vegas  find on map
3801 Las Vegas Boulevard South, Las Vegas, Nevada
0.2 OYO Hotel & Casino  find on map
115 East Tropicana Avenue, Las Vegas, Nevada
0.2 New York-New York Hotel & Casino  find on map
3790 Las Vegas Boulevard South, Las Vegas, Nevada
0.3 Park MGM  find on map
3770 Las Vegas Boulevard South, Las Vegas, Nevada
0.3 Excalibur Hotel and Casino  find on map
3850 Las Vegas Boulevard South, Las Vegas, Nevada
0.5 Aria Resort & Casino  find on map
3730 Las Vegas Boulevard South, Las Vegas, Nevada
0.5 Luxor Hotel and Casino  find on map
3900 Las Vegas Boulevard South, Las Vegas, Nevada
0.6 Planet Hollywood Las Vegas  find on map
3667 Las Vegas Boulevard South, Las Vegas, Nevada
0.6 Paris Las Vegas  find on map
3655 Las Vegas Boulevard South, Las Vegas, Nevada
0.6 The Cosmopolitan of Las Vegas  find on map
3708 Las Vegas Boulevard South, Las Vegas, Nevada
0.7 Mandalay Bay Resort and Casino  find on map
3950 Las Vegas Boulevard South, Las Vegas, Nevada
0.8 Wild Wild West Gambling Hall & Hotel  find on map
3330 West Tropicana Avenue, Las Vegas, Nevada
0.8 Bally's - Las Vegas  find on map
3645 Las Vegas Boulevard South, Las Vegas, Nevada
0.8 Bellagio  find on map
3600 Las Vegas Boulevard South, Las Vegas, Nevada
0.9 Ellis Island Casino & Brewery  find on map
4178 Koval Lane, Las Vegas, Nevada
0.9 The Cromwell  find on map
3595 Las Vegas Boulevard South, Las Vegas, Nevada
0.9 Stage Door Casino  find on map
4000 Linq Lane, Las Vegas, Nevada
1.0 Flamingo Las Vegas  find on map
3555 Las Vegas Boulevard South, Las Vegas, Nevada
1.0 Tuscany Suites and Casino  find on map
255 East Flamingo Road, Las Vegas, Nevada
1.1 Virgin Hotels Las Vegas  find on map
4455 Paradise Road, Las Vegas, Nevada
1.1 Caesars Palace  find on map
3570 Las Vegas Boulevard South, Las Vegas, Nevada
1.1 The LINQ Hotel + Experience  find on map
3535 Las Vegas Boulevard South, Las Vegas, Nevada
1.2 Harrah's Las Vegas Casino & Hotel  find on map
3475 Las Vegas Boulevard South, Las Vegas, Nevada
1.3 Casino Royale and Hotel  find on map
3411 Las Vegas Boulevard South, Las Vegas, Nevada
1.3 Silver Sevens Hotel & Casino  find on map
4100 Paradise Road, Las Vegas, Nevada
1.3 The Venetian Las Vegas  find on map
3355 Las Vegas Boulevard South, Las Vegas, Nevada
1.4 The Mirage  find on map
3400 Las Vegas Boulevard South, Las Vegas, Nevada
1.4 Rio All-Suite Hotel & Casino  find on map
3700 West Flamingo Road, Las Vegas, Nevada
1.5 The Palazzo Resort Hotel Casino  find on map
3325 Las Vegas Boulevard South, Las Vegas, Nevada
1.6 Treasure Island  find on map
3300 Las Vegas Boulevard South, Las Vegas, Nevada
1.6 Michael Gaughan Airport Slots  find on map
5757 Wayne Newton Boulevard, McCarran International Airport, Las Vegas, Nevada
1.6 Gold Coast Hotel and Casino  find on map
4000 West Flamingo Road, Las Vegas, Nevada
1.6 The Palms Casino Resort  find on map
4321 West Flamingo Road, Las Vegas, Nevada
1.7 The Orleans  find on map
4500 West Tropicana Avenue, Las Vegas, Nevada
1.7 PT's Pub - 1089 East Tropicana  find on map
1089 East Tropicana Avenue, Las Vegas, Nevada
1.7 Wynn Las Vegas  find on map
3131 Las Vegas Boulevard South, Las Vegas, Nevada
1.8 The Sand Dollar Lounge  find on map
3355 Spring Mountain Road, Suite 30, Las Vegas, Nevada
1.9 Mardi Gras Hotel & Casino  find on map
3500 Paradise Road, Las Vegas, Nevada
1.9 Encore Resort  find on map
3131 Las Vegas Boulevard South, Las Vegas, Nevada
2.1 Flowing Tide pub 6  find on map
4680 South Decatur Boulevard, Las Vegas, Nevada
2.2 PT's Place - Lower South Decatur  find on map
5355 South Decatur Boulevard, Las Vegas, Nevada
2.2 PT's Pub - West Flamingo Road  find on map
4825 West Flamingo Road, Suite 3, Las Vegas, Nevada
2.2 Peppermill Restaurant and Lounge  find on map
2985 Las Vegas Boulevard South, Las Vegas, Nevada
2.4 PT's Pub - Spring Mountain Road  find on map
4424 Spring Mountain Road, Las Vegas, Nevada
2.5 Circus Circus Hotel Casino - Las Vegas  find on map
2880 Las Vegas Boulevard South, Las Vegas, Nevada
2.5 Wildfire Valley View Casino  find on map
3045 South Valley View Boulevard, Las Vegas, Nevada
2.6 Westgate Las Vegas Resort & Casino  find on map
3000 Paradise Road, Las Vegas, Nevada
2.8 PT's Gold - South Decatur  find on map
6235 South Decatur Boulevard, Las Vegas, Nevada
2.8 Palace Station Hotel and Casino  find on map
2411 West Sahara Avenue, Las Vegas, Nevada
2.9 SAHARA Las Vegas  find on map
2535 Las Vegas Boulevard South, Las Vegas, Nevada
2.9 Dotty's 15  find on map
2839 West Sahara Avenue, Las Vegas, Nevada
3.1 Jackpot Joanie's - Tropicana & Jones  find on map
6120 West Tropicana Avenue, Las Vegas, Nevada
3.1 PT's Gold - Sunset  find on map
1661 East Sunset Road, Las Vegas, Nevada
3.1 PT's Pub - East Warm Springs Road  find on map
310 East Warm Springs Road, Las Vegas, Nevada
3.2 Aztec Casino  find on map
2200 Las Vegas Boulevard South, Las Vegas, Nevada
3.2 Eureka Casino  find on map
595 East Sahara Avenue, Las Vegas, Nevada
3.2 PT's Place - East Sahara  find on map
532 East Sahara Avenue, Las Vegas, Nevada
3.2 The STRAT Hotel, Casino and SkyPod  find on map
2000 Las Vegas Boulevard South, Las Vegas, Nevada
3.5 PT's Pub - West Sahara Avenue  find on map
4604 West Sahara Avenue, Unit 10, Las Vegas, Nevada
3.6 Dotty's 9  find on map
2300 South Maryland Parkway, Las Vegas, Nevada
3.6 Village Pub & Poker - Airport  find on map
2301 East Sunset Road, Suite 14, Las Vegas, Nevada
3.7 Sierra Gold - Las Vegas  find on map
6515 South Jones Boulevard, Las Vegas, Nevada
4.0 Jackpot Joanie's - Charleston & Rancho  find on map
2202 West Charleston Boulevard, Las Vegas, Nevada
4.0 Jackpot Joanie's - Triple Play  find on map
1875 South Decatur Boulevard, Las Vegas, Nevada
4.0 Jackpot Joanie's - Pecos & Russell  find on map
3375 East Russell Road, Las Vegas, Nevada
4.1 Village Pub & Poker - Cannery  find on map
3455 East Flamingo Road, Las Vegas, Nevada
4.1 Jackpot Joanie's - Rainbow & Flamingo  find on map
4012 South Rainbow Boulevard, Las Vegas, Nevada
4.1 Cariba Charlie's  find on map
4835 South Rainbow Boulevard, Suite 303, Las Vegas, Nevada
4.1 TA Petro - Las Vegas  find on map
8050 Dean Martin Drive, Las Vegas, Nevada
4.2 Skinny Dugan's Casino and Lounge  find on map
4127 West Charleston Boulevard, Las Vegas, Nevada
4.2 PT's Place - Upper South Decatur  find on map
1281 South Decatur Boulevard, Las Vegas, Nevada
4.2 Silverton Casino Lodge Las Vegas  find on map
3333 Blue Diamond Road, Las Vegas, Nevada
4.5 PT's Pub - 3470 East Sunset  find on map
3470 East Sunset Road, Las Vegas, Nevada
4.5 Jackpot Joanie's - Sahara & Torrey Pines  find on map
6356 West Sahara Avenue, Las Vegas, Nevada
4.6 Village Pub & Poker - Decatur  find on map
8075 South Decatur Boulevard, Las Vegas, Nevada
4.7 Arizona Charlie's Decatur  find on map
740 South Decatur Boulevard, Las Vegas, Nevada
4.9 Dotty's 107  find on map
3345 East Sahara Avenue, Las Vegas, Nevada
4.9 Golden Nugget - Las Vegas  find on map
129 Fremont Street, Las Vegas, Nevada
4.9 Dotty's 83  find on map
6000 West Charleston Boulevard, Las Vegas, Nevada
4.9 The D Las Vegas  find on map
301 Fremont Street, Las Vegas, Nevada
4.9 Four Queens Hotel and Casino  find on map
202 Fremont Street, Las Vegas, Nevada
5.0 El Cortez Hotel & Casino  find on map
600 Fremont Street, Las Vegas, Nevada
5.0 Golden Gate Hotel & Casino  find on map
1 Fremont Street, Las Vegas, Nevada
5.0 Lucky's Gaming and Spirits Casino  find on map
2501 East Charleston Boulevard, Las Vegas, Nevada
5.0 Binion's Gambling Hall  find on map
128 Fremont Street, Las Vegas, Nevada
5.0 Jackpot Joanie's - Windmill & Eastern  find on map
2381 East Windmill Lane, Las Vegas, Nevada
5.0 Fremont Hotel & Casino  find on map
200 Fremont Street, Las Vegas, Nevada
5.0 Plaza Hotel and Casino  find on map
1 South Main Street, Las Vegas, Nevada
5.0 Circa Resort & Casino  find on map
8 East Fremont Street, Las Vegas, Nevada
5.1 Downtown Grand Las Vegas  find on map
206 North Third Street, Las Vegas, Nevada
5.1 PT's Pub - 4310 East Tropicana  find on map
4310 East Tropicana Avenue, Las Vegas, Nevada
5.1 California Hotel & Casino  find on map
12 East Ogden Avenue, Las Vegas, Nevada
5.2 Main Street Station Casino Brewery and Hotel  find on map
200 North Main Street, Las Vegas, Nevada
5.3 Boulder Station Hotel & Casino  find on map
4111 Boulder Highway, Las Vegas, Nevada
5.3 Dotty's 5  find on map
2823 North Green Valley Parkway, Suite D, Henderson, Nevada
5.3 Dotty's 62  find on map
4213 Boulder Highway, Las Vegas, Nevada
5.4 Village Pub & Poker - Rainbow  find on map
7575 South Rainbow Boulevard, Las Vegas, Nevada
5.4 Barley's Casino & Brewing Company  find on map
4500 East Sunset Road, Suite 30, Henderson, Nevada
5.5 Village Pub & Poker - Wigwam  find on map
8515 South Eastern Avenue, Las Vegas, 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 20-Apr-21 11:54 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
117 ms 117 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
107 ms 107 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
20 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/microLeftNav.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/footerMicro.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/rightSide2.cfm
0 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=1ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 23:54:21.021
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		INNER JOIN ActivePropertyMiniSites ON ActivePropertyMiniSites.PropertyId = Property.PropertyId
		WHERE ActivePropertyMiniSites.FQDN = 'mgmgrand.casinocity.com'
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	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) = 19600

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=2ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	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=0ms, Records=14) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 19600

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=89ms, Records=100) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 23:54:21.021
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 19600;
				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=6ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	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) = 19600

getCCRegion (Datasource=GamingProperties-RO-CasinoCity, Time=1ms, Records=0) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	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=0ms, Records=14) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 23:54:21.021
	SELECT * FROM PropertyNavigation 
	WHERE  PropertyId=?
	  AND  Active=1
	ORDER BY SortOrder
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 19600


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=mgmgrand.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=mgmgrand&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=mgmgrand.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:
nearest=OK
site=mgmgrand
Debug Rendering Time: 14 ms