select bkrFormMailRecipient
				from tblBrokerRecord
				where cc = ? 

			select	cc
			from	tblBrokerRecord
			where	sParentBrokerage = ? 

		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 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.royalservice.ca
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\www\MCStemplateFiles\CustomSites\Brokers\RoyalService\404.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.royalservice.ca
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.royalservice.ca
HTTP_REFERER=https://www.royalservice.ca/34-SHERBOURNE-Port-Hope-ON/239920/assets/v2/css/assets/v2/img/content-footer-icon-person-alt@2x.png
HTTP_URL=/404.cfm
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\RoyalService\404.cfm
QUERY_STRING=
REMOTE_ADDR=3.128.197.221
REMOTE_HOST=3.128.197.221
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/404.cfm
SERVER_NAME=www.royalservice.ca
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=196600097
CFTOKEN=81b17d939c1dee23-12A1BCBE-AF83-5FBD-7570DF9FC17CC541
USAFEED=0

Session Variables:
aid=143221
aidblog=0
badvtracking=0
btrebvow=0
cfid=196600097
cftoken=81b17d939c1dee23-12A1BCBE-AF83-5FBD-7570DF9FC17CC541
client=Struct (7)
defaultlocations=&cities=Bowmanville,Cobourg,Courtice,Millbrook,Newcastle,Oshawa,Port+Hope
defaultprovince=&province=9
detailpagefeatured=0
detailpagehero=1
detailpagethumbnails=1
fmls=0
fp=
fps=
gapikey=AIzaSyB3gX3H5zFY4nF5RYV5uSuXZavqVoIsetg
hideleases=0
lstar=0
mapsource=google
mobilesite=1
mysearch=
nearbyproperties=1
nearbyschools=1
neighbourhoodlistingsmap=0
neighbourhoodpagehero=0
nspdestid=40935
pages=Struct (0)
pcspromo=0
primaryregion=Newcastle
realtorawards=0
recipient=janice@royalservice.ca
sbrokerbrand=royal
sbrokerbrandlong=
sbrokercode=royalservicerealestate
sbrokerlist=royalservicerealestate
sbrokername=Royal Service Real Estate Inc.
sbrokernamelong=Royal Service Real Estate Inc., Brokerage
sbrokernameshort=Royal Service Real Estate Inc.
sdomain=www.royalservice.ca
seolinks=0
sessionid=D:\WWW\MCSTEMPLATEFILES\CUSTOMSITES\BROKERS\ROYALSERVICE\APPLICATION.CFC_196600097_81b17d939c1dee23-12A1BCBE-AF83-5FBD-7570DF9FC17CC541
showbrokersolds=1
showlistingagent=0
similarproperties=1
sitetype=broker
soldinventory=0
soldsource=
soldstats=0
srealtorfirstname=
srealtorlastname=
srealtortitle=
steamtitle=
summarysplit=1
urltoken=CFID=196600097&CFTOKEN=81b17d939c1dee23-12A1BCBE-AF83-5FBD-7570DF9FC17CC541
usafeed=0
wgflatitude=43.9190775
wgflongitude=-78.5876661