select ai from tblAgentRecord where ai = 39902
	

    SELECT	sIPaddress, sIPrange, sUserAgent
    FROM	tblIpsToBlock
    WHERE	sIpAddress = ?
	AND sIpAddress NOT IN (?,?,?,?,?)
	and		bActive = 1

	    DECLARE @UserIPAddress varchar(100);
		SELECT @UserIPAddress=?
		SELECT sIPaddress, sIPrange, sUserAgent
		FROM tblIpsToBlock
		WHERE CHARINDEX(sIPrange,@UserIPAddress) > 0
		and	bActive = 1
	

		    DECLARE @UserAgent varchar(100);
			SELECT @UserAgent=?
			SELECT sIPaddress, sIPrange, sUserAgent
			FROM tblIpsToBlock
			WHERE CHARINDEX(sUserAgent,@UserAgent) > 0
			and	bActive = 1
		

		SELECT	iShowSold, iShowFeatured, bAgentSaves, sSidebarHideCom, bT3mlsSearch, bAgentDdf, bAgentNSPoptIn, bAgentTREBIDXoptIn, bAgentLDONIDXoptIn, bT6disableSpotlightListings, bT6disableSidebarSearchLinks, bT6searchWidgetIncGroups, bT3ignoreCapitalizeTag, bAgentSaves, bAgentTREBVOWoptIn, bAgentNSPrequireLogin, sNeighbourhoods, iT6HomePageSearchWidgetType, sNeighbourhoodsCities, bAgentSavesWatchers, bAgentSavesNewWatcher, bAgentSavesShowListingsBullet, bUseNeighbourhoodPages, iNeighbourhoodsInfo, sNeighbourhoodsInfo, bNeighSumMapInit, bNeighDetMapBottom, bNeighDetCombineHomes, bNeighDetShowComm, sNeighbourhoodsCities, bNeighDetAltLayout, sShowAddress, bVowSolds, bUseVowLists, sVowList, sVowListFull, sUseBlogComments, sVowSoldsList
		FROM	tblPermissions
		WHERE	iAID = ? 

		SELECT	bUseVowLists, sVowList, sVowListFull, sVowSoldsList, bVowSolds, sReviewPwd
		FROM	tblPermissions, tblBrokerRecord
		WHERE	cc = ?
		AND 	tblPermissions.iBrokerId = tblBrokerRecord.iBrokerId
	

		select OfficeAddress, OfficeCity, OfficeCountry, OfficeFax, OfficeName, iOfficeID, OfficePhone, OfficePostalCode, OfficeProvince, OfficeLat, OfficeLng, bNoRoster, OfficeSuite, OfficeTollFree, sOfficePhoto, sDisplayName, tblOfficeRecord.cc
		from tblOfficeRecord
		where cc = ?
		and	(bNoRoster IS NULL or bNoRoster != 1)
		
		order by sDisplayName, OfficeName
	

		select OfficeAddress, OfficeCity, OfficeCountry, OfficeFax, OfficeName, iOfficeID, OfficePhone, OfficePostalCode, OfficeProvince, OfficeLat, OfficeLng, bNoRoster, OfficeSuite, OfficeTollFree, sOfficePhoto, sDisplayName, BrokerName, tblOfficeRecord.cc
		from tblOfficeRecord, tblBrokerRecord
		where tblOfficeRecord.cc IN (?,?)
		and tblOfficeRecord.cc != ?
		and tblOfficeRecord.cc = tblBrokerRecord.cc
		and	(bNoRoster IS NULL or bNoRoster != 1)
		order by sDisplayName, OfficeName
	

		SELECT ai
		FROM	 tblAgentRecord
		WHERE	cc IN (?,?)
		AND		Roster != 'no'
		AND		(sHidden != 'yes' OR sHidden is NULL)
	

		SELECT DISTINCT Languages
		FROM	 tblAgentRecord
		WHERE	cc IN (?,?)
		AND		Languages != 'English'
		AND		Languages != ''
		AND		Roster != 'no'
		AND		(sHidden != 'yes' OR sHidden is NULL)
		ORDER BY Languages
	

		select iAgentId, tblNeighAgentsV2.aid, iNeigh, bGroupCommun, iAreaId, sName, fLatitude, fLongitude, tblNeighV2.iCommun, sPhotoName1 as neighPhoto, sPhotoName2 as neighPhoto2, iProv, sShortDesc
		from tblNeighAgentsV2, tblNeighV2
		where tblNeighAgentsV2.aid = ?
		and iNeigh = iAreaId
		and iNeigh is NOT NULL
	

		select iAgentId, tblNeighAgentsV2.aid, iCommun, bGroupRegion, iCommunId, sName, fLatitude, fLongitude, iRegion, sPhotoName1 as commPhoto, sPhotoName2 as commPhoto2, iProv, sShortDesc
		from tblNeighAgentsV2, tblCommunV2
		where tblNeighAgentsV2.aid = ?
		and iCommun = iCommunId
		and iCommun is NOT NULL
	

					select iNeigh from tblNeighAgentsV2 where iCommun = ? AND aid = ?
					and (iNeigh is NOT NULL and iNeigh != 0)
				

					select iNeigh from tblNeighAgentsV2 where iCommun = ? AND aid = ?
					and (iNeigh is NOT NULL and iNeigh != 0)
				

					select iNeigh from tblNeighAgentsV2 where iCommun = ? AND aid = ?
					and (iNeigh is NOT NULL and iNeigh != 0)
				

		select iAgentId, aid, iNeigh, bGroupCommun, iCommun, bGroupRegion
		from tblNeighAgentsV2
		where aid = ? 
		and iNeigh = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

															select c.sName
															from tblNeighV2 n, tblCommunV2 c
															where iCommun = iCommunId
															and iAreaId = ? 

	select iTotalListings, bAgentSavesShowListingsBullet
	from tblListingStats, tblPermissions
	where iAID = ?
	and sName = sListingStatSource

	select iTotalListings, bAgentSavesShowListingsBullet
	from tblListingStats, tblPermissions
	where iAID = ?
	and sName = sListingStatSource

		insert into tblTrackingSiteCustom (tIPAddress, sBrokerCode, dTimeDate, sPageViewed, sUserAgent, sReferrer, sQueryString, sDomain)
		values (
		?,
		?,
		'May 21, 2024 10:03:45 AM',
		?,
		?,
		?,
		?,
		?
		)
	

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.remaxcollingwood.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\www\MCStemplateFiles\CustomSites\Brokers\REMAX-FourSeasons\neighbourhood-detail.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.remaxcollingwood.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=ffe37c73cd35bc43-12A1CE32-A46E-BDB6-389EE2FA4EF7072E; CFID=196600101; USAFEED=0
HTTP_HOST=www.remaxcollingwood.com
HTTP_REFERER=https://www.remaxcollingwood.com/15COURTICECrescent/Neighbourhoods/Ontario/SimcoeCounty/Stayner/realtors.cfm
HTTP_URL=/neighbourhood-detail.cfm?id=404&thepage=%2F15COURTICECrescent%2FNeighbourhoods%2FOntario%2FSimcoeCounty%2FStayner%2Frealtors%2Ecfm?id=404&thepage=%2F15COURTICECrescent%2FNeighbourhoods%2FOntario%2FSimcoeCounty%2FStayner%2Frealtors%2Ecfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.20.92.23
PATH_INFO=
PATH_TRANSLATED=D:\www\MCStemplateFiles\CustomSites\Brokers\REMAX-FourSeasons\neighbourhood-detail.cfm
QUERY_STRING=id=404&thepage=%2F15COURTICECrescent%2FNeighbourhoods%2FOntario%2FSimcoeCounty%2FStayner%2Frealtors%2Ecfm
REMOTE_ADDR=3.129.5.151
REMOTE_HOST=3.129.5.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/neighbourhood-detail.cfm
SERVER_NAME=www.remaxcollingwood.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=196600101
CFTOKEN=ffe37c73cd35bc43-12A1CE32-A46E-BDB6-389EE2FA4EF7072E
USAFEED=0

Session Variables:
aid=124951
badvtracking=0
btrebvow=0
cfid=196600101
cftoken=ffe37c73cd35bc43-12A1CE32-A46E-BDB6-389EE2FA4EF7072E
client=Struct (7)
defaultlocations=&cities=Collingwood,Thornbury,Stayner,Grey+Highlands,Grey+Highland,Clearview,Creemore,Meaford,Wasaga+Beach,The+Blue+Mountains,The+Blue+Mountain,Blue+Mountains,Blue+Mountain
defaultprovince=&province=9
detailpagefeatured=0
detailpagehero=2
detailpagethumbnails=0
fmls=0
fp=
fps=
gapikey=AIzaSyBs2NMtfZ86vTPjohCKb3Q1mhuMJRjc4fM
lstar=0
mobilesite=1
mysearch=
nearbyproperties=1
nearbyschools=1
neighbourhoodpagehero=0
nspdestid=43127
pages=Struct (0)
pcspromo=0
primaryregion=Collingwood
realtorawards=0
recipient=blairthompson@remaxcollingwood.com
sbrokerbrand=remax
sbrokerbrandlong=RE/MAX
sbrokercode=ONremaxfourseasons
sbrokerlist=ONremaxfourseasons,ONremaxfourseasonsdg
sbrokername=RE/MAX Four Seasons Realty Ltd.
sbrokernamelong=RE/MAX Four Seasons Realty Ltd., Brokerage
sbrokernameshort=RE/MAX Four Seasons Realty Ltd.
sdomain=www.remaxcollingwood.com
seolinks=1
sessionid=D:\WWW\MCSTEMPLATEFILES\CUSTOMSITES\BROKERS\REMAX-FOURSEASONS\APPLICATION.CFC_196600101_ffe37c73cd35bc43-12A1CE32-A46E-BDB6-389EE2FA4EF7072E
showbrokersolds=0
showlistingagent=0
similarproperties=1
sitetype=broker
srealtorfirstname=
srealtorlastname=
srealtortitle=
steamtitle=
summarysplit=1
urltoken=CFID=196600101&CFTOKEN=ffe37c73cd35bc43-12A1CE32-A46E-BDB6-389EE2FA4EF7072E
usafeed=0
wgflatitude=44.5003418
wgflongitude=-80.2240852

URL Parameters:
id=404
thepage=/15COURTICECrescent/Neighbourhoods/Ontario/SimcoeCounty/Stayner/realtors.cfm