Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingMassachusetts Gambling
MGM Springfield
Nearby Casinos
Hotel ReservationsNewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
Massachusetts Gambling
MGM Springfield
Hotel ReservationsNewsTweetsMapExecutivesOwnership

Casinos Near MGM Springfield

There are 99 casinos within 100 miles of MGM Springfield

Map Index Distance (miles) Casino
  MGM Springfield  find on map
One MGM Way, Springfield, Massachusetts
0.0 MGM Springfield  find on map
One MGM Way, Springfield, Massachusetts
13.0 Bobby V's Restaurant & Sports Bar - Windsor Locks  find on map
11 Schoephoester Road, Windsor Locks, Connecticut
13.0 Winners - Bradley  find on map
11 Schoephoester Road, Windsor Locks, Connecticut
20.1 Winners - Manchester  find on map
103 Tolland Turnpike, Manchester, Connecticut
25.3 Winners - Hartford  find on map
121 Brainard Road, Hartford, Connecticut
31.2 Winners - New Britain  find on map
160 East Main Street, New Britain, Connecticut
34.5 Winners - Torrington  find on map
141 Water Street, Torrington, Connecticut
38.6 Winners - Putnam  find on map
146 Park Road, Putnam, Connecticut
44.3 Winners - Waterbury  find on map
155 Thomaston Avenue, Waterbury, Connecticut
48.4 Capital OTB - New Lebanon  find on map
Route 20 and 22, Midtown Mall, New Lebanon, New York
48.5 Gallup Inn  find on map
496 Columbia Pike, New Lebanon, New York
49.1 Mohegan Sun  find on map
1 Mohegan Sun Boulevard, Uncasville, Connecticut
57.7 Winners - Sports Haven  find on map
600 Long Wharf Drive, New Haven, Connecticut
59.4 Wonder Casino  find on map
172 Emerald Street, Keene, New Hampshire
59.5 Keene Casino  find on map
222 West Street, Building D2, Keene, New Hampshire
60.4 Twin River Casino Hotel  find on map
100 Twin River Road, Lincoln, Rhode Island
61.4 Capital OTB - Hudson  find on map
86 Healy Boulevard, Unit 1, Hudson, New York
61.8 Lakeview On Crystal Lake  find on map
4 Old Route 66, Averill Park, New York
63.4 Winners - Milford  find on map
89 Roses Mill Road, Milford, Connecticut
63.6 Samson's Bar & Restaurant  find on map
1736 Route 9, Castleton, New York
65.4 Sidelines Restaurant and Sports Bar  find on map
7909 Albany Post Road, Red Hook, New York
66.2 Plainridge Park Casino  find on map
301 Washington Street, Plainville, Massachusetts
67.1 HoeBowl Catskill Lanes  find on map
305 West Bridge Street, Catskill, New York
67.8 Capital OTB - Hoosick Falls  find on map
21 Lyman Street, Hoosick Falls, New York
68.3 Capital OTB - Columbia Turnpike  find on map
308 Columbia Turnpike, Rensselaer, New York
68.7 Villa Valenti Pub  find on map
729 Pawling Avenue, Troy, New York
70.5 Winners - Shoreline Star  find on map
255 Kossuth Street, Bridgeport, Connecticut
71.0 Capital OTB - Menands  find on map
81 Broadway, Menands, New York
71.2 Uncle Sam Lanes  find on map
600 Fulton Street, Troy, New York
71.2 InterBets OTB - Brewster  find on map
1037 Route 22, Brewster, New York
71.6 Boston Billiard Club  find on map
55 Northeastern Boulevard, Nashua, New Hampshire
71.7 Capital OTB - Green Island  find on map
41 Lower Hudson Avenue, Green Island, New York
71.8 Founder's Tavern  find on map
55500 Route 25, Southold, New York
71.8 The Black Bear Inn  find on map
310 19th Street, Watervliet, New York
71.9 Georgie O's  find on map
787 Violet Avenue, Hyde Park, New York
72.5 Capital OTB - Delmar  find on map
180 Delaware Avenue, Elsmere, New York
72.5 Capital OTB - Lansingburgh  find on map
369 Second Avenue, Troy, New York
73.1 Clubhouse Race Book  find on map
711 Central Avenue, Albany, New York
73.2 River Casino and Sports Bar - Nashua  find on map
53 High Street, Nashua, New Hampshire
73.2 Catskill Mountain Lodge  find on map
334 Route 32A, Palenville, New York
73.3 InterBets OTB - Arlington  find on map
11 Raymond Avenue, Poughkeepsie, New York
73.4 Capital OTB - Cohoes  find on map
127 Canvass Street, Cohoes, New York
73.6 Eagle's Wing Function Center  find on map
10 Spruce Street, Nashua, New Hampshire
74.4 InterBets OTB - Kingston  find on map
160 Plaza Road, Kingston Plaza, Kingston, New York
74.7 Jessica Stone's Bar & Grill  find on map
742 New Loudon Road, Latham, New York
74.9 Lewis's Tavern  find on map
205 Main Street, Schaghticoke, New York
75.7 Sal's Place  find on map
99 Vineyard Avenue, Highland, New York
75.7 Capital OTB - Wolf Road  find on map
98 Wolf Road, Hannaford Plaza, Albany, New York
77.6 InterBets OTB - Mahopac  find on map
646 Route 6, 4 Brothers Plaza, Mahopac, New York
77.9 O'Toole's Restaurant Pub  find on map
1814 Central Avenue, Kohl's Plaza, Albany, New York
78.2 Capital OTB - Schaghticoke  find on map
171 Old Schaghticoke Road, Schaghticoke, New York
78.2 Raynham-Taunton Greyhound Park  find on map
1958 Broadway, Raynham, Massachusetts
78.4 Capital OTB - Star Plaza  find on map
2050 Western Avenue, Suite 110, Guilderland, New York
79.7 Tiverton Casino Hotel  find on map
777 Tiverton Casino Boulevard, Tiverton, Rhode Island
80.2 Winners - Norwalk  find on map
24 Burnell Boulevard, Norwalk, Connecticut
80.5 Encore Boston Harbor  find on map
One Broadway, Everett, Massachusetts
80.6 Hallmark Cards & Gifts  find on map
763 Old Country Road, Riverhead, New York
81.3 Rocky Point Ale House  find on map
42 Broadway, Rocky Point, New York
81.4 J & R Steakhouse  find on map
4362 Middle Country Road, Route 25, Calverton, New York
81.5 Carnival Cruise Line - Glory  find on map
3655 Northwest 87th Avenue, Miami, Florida
81.9 Schenectady Bingo Palace  find on map
1866 State Street, Schenectady, New York
82.5 Capital OTB - Woodlawn  find on map
1629 State Street, Schenectady, New York
83.4 Tommy's Place  find on map
109 Main Street, Port Jefferson, New York
83.4 Filotimo Casino & Restaurant  find on map
1279 South Willow Street, Manchester, New Hampshire
83.8 Grumpy Jack's  find on map
28 Oakland Avenue, Port Jefferson, New York
83.9 Chasers Poker Room  find on map
7 Veterans Memorial Parkway, Salem, New Hampshire
84.0 Suffolk Downs  find on map
525 William F. McClellan Highway, East Boston, Massachusetts
84.2 Sportsman's Bowl  find on map
1652 Crane Street, Schenectady, New York
84.4 InterBets OTB - Newburgh  find on map
39 North Plank Road, Mid Valley Mall, Newburgh, New York
84.7 The Bays Bar & Grill  find on map
214 West Montauk Highway, Hampton Bays, New York
84.9 Capital OTB - Smith Street  find on map
510 Smith Street, Schenectady, New York
85.2 Rivers Casino & Resort Schenectady  find on map
1 Rush Street, Schenectady, New York
85.4 Capital OTB - Bellevue  find on map
2224-26 Broadway, Schenectady, New York
85.7 Community Bingo Center  find on map
1050 Holt Avenue, Suite 9, Manchester, New Hampshire
87.5 Bobby V's Restaurant & Sports Bar and Winners - Stamford  find on map
268 Atlantic Street, Stamford, Connecticut
87.6 Tommy's Old Town Tavern  find on map
2229A Route 112, Suite A, Coram, New York
89.8 Saratoga Casino Hotel  find on map
342 Jefferson Street, Saratoga Springs, New York
90.2 Saratoga Race Course  find on map
267 Union Avenue, Saratoga Springs, New York
90.6 Island Bingo  find on map
1055 Portion Road, Suite 4E, Farmingville, New York
90.7 Main Street Pub  find on map
21 Main Street, Kings Park, New York
91.3 Rockwell's Bar & Grill  find on map
60 Terry Road, Suite 7, Smithtown, New York
91.9 Napper Tandy's  find on map
299 Laurel Avenue, Northport, New York
92.0 Filthy Frogzz  find on map
419 Hawkins Avenue, Ronkonkoma, New York
92.7 Farrell's Tavern  find on map
284 Ronkonkoma Avenue, Ronkonkoma, New York
93.9 Jake's 58 Hotel & Casino  find on map
3635 Express Drive North, Islandia, New York
94.0 Healy's Inn  find on map
54 Broadway, Suite 1, Greenlawn, New York
94.2 The Shamrock Restaurant & Bar  find on map
138 New York Avenue, Halesite, New York
94.5 Jimmy's Pub  find on map
350 East Main Street, Suite 5, Patchogue, New York
94.7 Dunton Inn  find on map
701 South Country Road, East Patchogue, New York
95.0 Hi-Tor Lanes  find on map
40 South Route 9 West, West Haverstraw, New York
95.8 Watson's Public House  find on map
876A Church Street, Suite A, Bohemia, New York
95.8 Cavanaugh's  find on map
255 Blue Point Avenue, Blue Point, New York
96.3 Broadway Lanes  find on map
359 Broadway, Fort Edward, New York
96.7 Cardland  find on map
4593 Sunrise Highway, Bohemia, New York
97.3 Saluto Lounge  find on map
186 Main Street, Hudson Falls, New York
97.8 Village Idiot Irish Pub  find on map
1487 Montauk Highway, Oakdale, New York
98.4 InterBets OTB - Monroe  find on map
791 State Route 17M, Monroe Shopping Center, Monroe, New York
98.9 InterBets OTB - Nyack  find on map
306 Route 59, Hub Shopping Center, Nyack, New York
99.3 Savino's Finish Line East  find on map
511 Commack Road, Deer Park, New York
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 14-Apr-21 08:58 AM
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
111 ms 111 ms 1 top level D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm
94 ms 94 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
16 ms 8 ms 2 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/MicroLeftNavQueries.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/microLeftNav.cfm
0 ms 0 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/rightSide2.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
112 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 @ 08:58:23.023
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		WHERE dbo.StringToUrl(Property.City) = 'springfield'
		  AND Property.UrlOrganizationName = 'mgm-springfield'
  		  AND Property.PropertyStatusTypeId =1
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 08:58:23.023
	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) = 981300

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

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=82ms, Records=99) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 08:58:23.023
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 981300;
				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=3ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 08:58:23.023
	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) = 981300

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


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=massachusetts.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=massachusetts&city=springfield&property=mgm-springfield&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=massachusetts.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=springfield
nearest=OK
property=mgm-springfield
site=massachusetts
Debug Rendering Time: 13 ms