Visit Casino City's Internet Directory
Casino City HomeWorld GamblingAmerican GamblingNew Jersey Gambling
Meadowlands Racetrack
Nearby Casinos
Hotel ReservationsNewsTweetsMapExecutivesOwnership
Sign up for the
Casino City Times
Weekly Newsletter!
Casino City Home
World Gambling
American Gambling
New Jersey Gambling
Meadowlands Racetrack
Hotel ReservationsNewsTweetsMapExecutivesOwnership

Casinos Near Meadowlands Racetrack

There are 100 casinos within 100 miles of Meadowlands Racetrack

Map Index Distance (miles) Casino
  Meadowlands Racetrack  find on map
1 Racetrack Drive, East Rutherford, New Jersey
0.0 Meadowlands Racetrack  find on map
1 Racetrack Drive, East Rutherford, New Jersey
5.3 Carnival Cruise Line - Miracle  find on map
3655 Northwest 87th Avenue, Miami, Florida
11.0 Bronxdale Bingo Hall  find on map
2028 White Plains Road, Bronx, New York
11.2 Fifth Avenue Bingo Hall  find on map
416 Fifth Avenue, Brooklyn, New York
11.4 Maspeth Bingo Hall  find on map
6920 Grand Avenue, Maspeth, New York
11.4 Winners - Bayonne  find on map
400 Route 440 North, Bayonne, New Jersey
12.9 Empire City Casino  find on map
810 Yonkers Avenue, Yonkers, New York
15.0 Richmond Hill Bingo Hall  find on map
11707 Hillside Avenue, Richmond Hill, New York
16.2 Resorts World Casino New York City  find on map
11000 Rockaway Boulevard, Jamaica, New York
16.3 Aqueduct Racetrack  find on map
11000 Rockaway Boulevard, Jamaica, New York
16.7 InterBets OTB - Pearl River  find on map
12 East Dexter Plaza, Pearl River, New York
19.1 Top Bingo Hall  find on map
22034 Jamaica Avenue, Queens Village, New York
19.7 Belmont Park  find on map
2150 Hempstead Turnpike, Elmont, New York
19.7 Park Avenue Teletheatre at Nanuet  find on map
330 West Route 59, Nanuet, New York
20.1 InterBets OTB - Nyack  find on map
306 Route 59, Hub Shopping Center, Nyack, New York
20.4 Trinity Restaurant & Bar  find on map
190 Jericho Turnpike, Floral Park, New York
21.2 Charlie Meaney's Bar & Grill  find on map
52 Central Court, Valley Stream, New York
21.8 Nassau Downs OTB - Valley Stream  find on map
10-12 Sidney Place, Valley Stream, New York
22.0 Nassau Downs OTB - Franklin Square  find on map
1063 Hempstead Turnpike, Franklin Square, New York
22.7 Finnegan's Pub  find on map
607 Willis Avenue, Williston Park, New York
22.8 Favorites at Woodbridge  find on map
3 LaFayette Road, Fords, New Jersey
23.4 Murphy's Bar & Grill  find on map
234 Old Country Road, Mineola, New York
23.4 TJ Patricks  find on map
1762 Broadway, Hewlett, New York
24.0 B.K. Sweeney's Uptown Grille  find on map
636 Franklin Avenue, Garden City, New York
24.4 Nassau Downs OTB - Carle Place  find on map
180 Glen Cove Road, Carle Place, New York
25.1 Churchill's Restaurant and Bar  find on map
18 South Park Avenue, Rockville Centre, New York
25.6 Lilly's of Long Beach  find on map
954 West Beech Street, Long Beach, New York
25.8 Nassau Downs OTB - Oceanside  find on map
3450 Lawson Boulevard, Oceanside, New York
26.0 J. Paul's Terrace Cafe  find on map
239 Merrick Road, Oceanside, New York
26.8 Cafe Oasis  find on map
779 Brooklyn Avenue, Baldwin, New York
27.2 Hi-Tor Lanes  find on map
40 South Route 9 West, West Haverstraw, New York
28.9 Stop 'N Shop  find on map
1000 Jerusalem Avenue, Merrick, New York
28.9 Nassau Downs OTB - Levittown  find on map
2680 Hempstead Turnpike, Levittown, New York
30.1 The Breezy  find on map
620 Jersey Avenue, Greenwood Lake, New York
30.2 Time Out Sports Cafe  find on map
616 South Oyster Bay Road, Unit A, Hicksville, New York
30.4 BC's Pub & Tiki Bar  find on map
2711 Grand Avenue, Bellmore, New York
31.6 B.K. Sweeney's Parkside Tavern  find on map
356 Broadway, Bethpage, New York
32.2 Bobby V's Restaurant & Sports Bar and Winners - Stamford  find on map
268 Atlantic Street, Stamford, Connecticut
32.6 Runyon's Bar and Restaurant  find on map
3928 Merrick Road, Seaford, New York
33.0 Nassau Downs OTB - Race Palace  find on map
1600 Swamp Road, Plainview, New York
34.4 110 Bingo Hall  find on map
585 Broadhollow Road, Melville, New York
34.6 Favorites at Hillsborough  find on map
150 Route 206, Hillsborough, New Jersey
34.6 The Shamrock Restaurant & Bar  find on map
138 New York Avenue, Halesite, New York
35.2 Monmouth Park  find on map
175 Oceanport Avenue, Oceanport, New Jersey
36.1 InterBets OTB - Monroe  find on map
791 State Route 17M, Monroe Shopping Center, Monroe, New York
37.3 Healy's Inn  find on map
54 Broadway, Suite 1, Greenlawn, New York
38.9 Napper Tandy's  find on map
299 Laurel Avenue, Northport, New York
39.2 50 Yardline Sports Bar  find on map
371 Little East Neck Road, West Babylon, New York
40.1 Winners - Norwalk  find on map
24 Burnell Boulevard, Norwalk, Connecticut
40.2 Savino's Finish Line East  find on map
511 Commack Road, Deer Park, New York
40.5 Freehold Raceway  find on map
130 Park Avenue, Freehold, New Jersey
41.2 Uncle Chuck's Sports Bar & Grill  find on map
401 Sunrise Highway, West Islip, New York
42.2 InterBets OTB - Mahopac  find on map
646 Route 6, 4 Brothers Plaza, Mahopac, New York
42.3 Delancy's Restaurant  find on map
40 Park Place, Goshen, New York
43.1 Main Street Pub  find on map
21 Main Street, Kings Park, New York
47.0 InterBets OTB - Brewster  find on map
1037 Route 22, Brewster, New York
47.1 InterBets OTB - Middletown  find on map
600 North Galleria Drive, PCM Plaza, Middletown, New York
47.2 Rockwell's Bar & Grill  find on map
60 Terry Road, Suite 7, Smithtown, New York
47.6 Jake's 58 Hotel & Casino  find on map
3635 Express Drive North, Islandia, New York
48.5 InterBets OTB - Newburgh  find on map
39 North Plank Road, Mid Valley Mall, Newburgh, New York
49.3 Village Idiot Irish Pub  find on map
1487 Montauk Highway, Oakdale, New York
50.4 Farrell's Tavern  find on map
284 Ronkonkoma Avenue, Ronkonkoma, New York
50.4 Cardland  find on map
4593 Sunrise Highway, Bohemia, New York
50.5 Watson's Public House  find on map
876A Church Street, Suite A, Bohemia, New York
50.6 Filthy Frogzz  find on map
419 Hawkins Avenue, Ronkonkoma, New York
52.8 Winners - Shoreline Star  find on map
255 Kossuth Street, Bridgeport, Connecticut
52.8 Island Bingo  find on map
1055 Portion Road, Suite 4E, Farmingville, New York
53.3 Tommy's Place  find on map
109 Main Street, Port Jefferson, New York
54.0 Grumpy Jack's  find on map
28 Oakland Avenue, Port Jefferson, New York
54.5 Cavanaugh's  find on map
255 Blue Point Avenue, Blue Point, New York
56.2 Tommy's Old Town Tavern  find on map
2229A Route 112, Suite A, Coram, New York
56.3 Jimmy's Pub  find on map
350 East Main Street, Suite 5, Patchogue, New York
58.4 Dunton Inn  find on map
701 South Country Road, East Patchogue, New York
58.9 Favorites at Toms River  find on map
1071 Route 37 West, Toms River, New Jersey
59.6 The Downs at East Stroudsburg  find on map
6 Eagles Glen Plaza, Suite 210, East Stroudsburg, Pennsylvania
60.9 Rocky Point Ale House  find on map
42 Broadway, Rocky Point, New York
61.2 InterBets OTB - Arlington  find on map
11 Raymond Avenue, Poughkeepsie, New York
61.9 Winners - Milford  find on map
89 Roses Mill Road, Milford, Connecticut
62.4 Sal's Place  find on map
99 Vineyard Avenue, Highland, New York
65.9 Georgie O's  find on map
787 Violet Avenue, Hyde Park, New York
66.6 Resorts World Catskills  find on map
888 Resorts World Drive, Monticello, New York
67.0 Parx Casino  find on map
2999 Street Road, Bensalem, Pennsylvania
67.2 Monticello Raceway  find on map
204 State Route 17B, Monticello, New York
68.4 J & R Steakhouse  find on map
4362 Middle Country Road, Route 25, Calverton, New York
68.4 Mount Airy Casino Resort  find on map
312 Woodland Road, Mount Pocono, Pennsylvania
68.8 Wind Creek Bethlehem  find on map
77 Sands Boulevard, Bethlehem, Pennsylvania
69.1 Winners - Sports Haven  find on map
600 Long Wharf Drive, New Haven, Connecticut
72.7 Mohegan Sun Pocono at Lehigh Valley Race and Sportsbook  find on map
1780 Airport Road, Allentown, Pennsylvania
73.7 Winners - Waterbury  find on map
155 Thomaston Avenue, Waterbury, Connecticut
74.1 Hallmark Cards & Gifts  find on map
763 Old Country Road, Riverhead, New York
77.2 InterBets OTB - Kingston  find on map
160 Plaza Road, Kingston Plaza, Kingston, New York
80.3 Villa Roma Resort  find on map
356 Villa Roma Road, Callicoon, New York
80.4 The Bays Bar & Grill  find on map
214 West Montauk Highway, Hampton Bays, New York
81.2 Rivers Casino Philadelphia  find on map
1001 North Delaware Avenue, Philadelphia, Pennsylvania
83.4 Sidelines Restaurant and Sports Bar  find on map
7909 Albany Post Road, Red Hook, New York
83.9 Winners - Torrington  find on map
141 Water Street, Torrington, Connecticut
85.1 South Philadelphia Turf Club  find on map
700 Packer Avenue, Philadelphia, Pennsylvania
85.2 Live! Casino & Hotel Philadelphia  find on map
900 Packer Avenue, Philadelphia, Pennsylvania
86.4 Favorites at Gloucester  find on map
1300 Blackwood Clementon Road, Clementon, New Jersey
86.5 Valley Forge Casino Resort  find on map
1160 First Avenue, King of Prussia, Pennsylvania
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 17-Apr-21 05:13 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
96 ms 96 ms 1 D:/ClusterSites/htdocs/www.casinocity.com/htdocs/includes/mapPageContents.cfm
14 ms 7 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
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/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
111 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetPropertyID (Datasource=GamingProperties-RO-CasinoCity, Time=7ms, Records=1) in D:\ClusterSites\htdocs\minisites.casinocity.com\htdocs\map.cfm @ 05:13:23.023
		SELECT Property.PropertyId, Longitude, Latitude			-- Property.OrganizationName, Countries.PlaceName Country, States.PlaceName State
		FROM Property
		WHERE dbo.StringToUrl(Property.City) = 'east-rutherford'
		  AND Property.UrlOrganizationName = 'meadowlands-racetrack'
  		  AND Property.PropertyStatusTypeId =1
	
Property (Datasource=GamingProperties-RO-CasinoCity, Time=4ms, Records=1) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\microLeftNavQueries.cfm @ 05:13: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) = 301500

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

Nearby (Datasource=GamingProperties-RO-CasinoCity, Time=83ms, Records=100) in D:\ClusterSites\htdocs\www.casinocity.com\htdocs\includes\mapPageContents.cfm @ 05:13:23.023
				DECLARE @GeoLocation Geography;
				SELECT @GeoLocation = GeoLocation FROM Property WHERE Property.PropertyId = 301500;
				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 @ 05:13: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) = 301500

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


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=newjersey.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=newjersey&city=east-rutherford&property=meadowlands-racetrack&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=newjersey.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=east-rutherford
nearest=OK
property=meadowlands-racetrack
site=newjersey
Debug Rendering Time: 13 ms