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:43 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.innovationrealty.ca
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\www\MCStemplateFiles\CustomSites\Brokers\InnovationRealty\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.innovationrealty.ca
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.innovationrealty.ca
HTTP_REFERER=https://www.innovationrealty.ca/listing/1094097-1035-march-road-kanata-ontario-k2k1x7/assets/v2/css/assets/v2/img/social-icon-pinterest@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\InnovationRealty\404.cfm
QUERY_STRING=
REMOTE_ADDR=3.144.107.116
REMOTE_HOST=3.144.107.116
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/404.cfm
SERVER_NAME=www.innovationrealty.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=196600088
CFTOKEN=2a504d872a324fd6-12A185EF-D9DA-F24A-814CF5E022D51F3F
USAFEED=0

Session Variables:
aid=174818
aidblog=0
badvtracking=0
btrebvow=0
cfid=196600088
cftoken=2a504d872a324fd6-12A185EF-D9DA-F24A-814CF5E022D51F3F
client=Struct (7)
defaultlocations=&cities=Ottawa,Embrun,Kanata,Kemptville,Orléans,Orleans,Smiths+Falls,Westport,Carleton+Place
defaultprovince=&province=9
detailpagefeatured=0
detailpagehero=1
detailpagethumbnails=1
fmls=0
fp=
fps=
gapikey=AIzaSyCQuWT3bgnMVH1agr1OVj4e-ph0mt8VaAs
hideleases=0
lstar=0
mapsource=google
mobilesite=1
mysearch=
nearbyproperties=1
nearbyschools=1
neighbourhoodlistingsmap=0
neighbourhoodpagehero=0
nspdestid=49101
pages=Struct (0)
pcspromo=1
primaryregion=Ottawa
realtorawards=0
realtordetailpage=1
recipient=info@innovationrealty.ca
sbrokerbrand=innovationrealty
sbrokerbrandlong=
sbrokercode=innovationrealtyltd
sbrokerlist=innovationrealtyltd
sbrokername=Innovation Realty Ltd.
sbrokernamelong=Innovation Realty Ltd., Brokerage
sbrokernameshort=Innovation Realty Ltd.
sdomain=www.innovationrealty.ca
seolinks=0
sessionid=D:\WWW\MCSTEMPLATEFILES\CUSTOMSITES\BROKERS\INNOVATIONREALTY\APPLICATION.CFC_196600088_2a504d872a324fd6-12A185EF-D9DA-F24A-814CF5E022D51F3F
showbrokersolds=1
showlistingagent=0
similarproperties=1
sitetype=broker
soldinventory=0
soldsource=OTON
soldstats=0
srealtorfirstname=
srealtorlastname=
srealtortitle=
steamtitle=
summarysplit=1
urltoken=CFID=196600088&CFTOKEN=2a504d872a324fd6-12A185EF-D9DA-F24A-814CF5E022D51F3F
usafeed=0
wgflatitude=45.3781947
wgflongitude=-75.6932598