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	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	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	iBrokerId = ? 

		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	DISTINCT cc
	from	tblAgentRecord 
	where ai in (select ai from tblAgentRecord where bDrarMember = 1)

		SELECT iBrokerId, BrandId, BrokerListingLogo, BrokerBanner, bkrStyleSheet, bkrCommonImages, BrokerName, cc, bkrFormMailRecipient, bkrNoHeadShotImage, bkrFormMailRecipient, brokerFormLogo, brokerFormBanner
		FROM	tblBrokerRecord
		WHERE	cc = ? 

		select distinct l.iListingId, a.active, sUnitNo, sStreetNo, sStreetName, sStreetType, sStreetDir, sMunicipality, sStyle, sTypeSearch, sWaterfront, l.dCreated, iProv, l.iCountry, iPictureTotal, mListPrice, sMlsNo, sBrokerId, l.BrokerName, l.OfficeName, iListAgent1Id, iCoListAgent1id, iAccountId, l.ContactFirstName, l.ContactLastName, l.ContactTitle, iDispAddress, sNameLong, sCountryName, b.ContactFirstName as coFirst, b.ContactLastName as coLast, b.ContactTitle as coTitle, b.active, b.BrokerName as coBroker, b.OfficeName, sPhotoName, sPhotoUrl, fLatitude,fLongitude, sStatusSearch, sStyle, sAdRemarks, iListOffice1ID, l.TelephoneDirect, l.TelephoneOffice, l.OfficePhone, sSaleLeaseSearch, sTypeSearch, sBuildingTypeSearch, sRooms, sBedrooms, iBathrooms, iPictureTotal
		from vwListingActive l
		inner join tblAgentRecord as a on l.iListAgent1Id = a.ai
		inner join tblProvinces as prov on l.iProv=prov.iProvinceId
		inner join tblCountries as c on l.iCountry=c.iCountryId
		left outer join tblPhotosActive p on l.iListingId = p.iListingId and iDisplayOrder = 1
		left outer join tblAgentRecord as b on l.iCoListAgent1Id = b.ai
		where iListAgent1Id IN (select ai from tblAgentRecord where bDrarMember = 1)
		AND		sTypeSearch = 'Residential'
		AND		sSaleLeaseSearch = 'Sale'
		AND l.dCreated < dateadd(hh, -1, getdate())
		ORDER BY	l.dCreated DESC
	

		select distinct l.iListingId, a.active, sUnitNo, sStreetNo, sStreetName, sStreetType, sStreetDir, sMunicipality, sStyle, sTypeSearch, sWaterfront, l.dCreated, iProv, l.iCountry, iPictureTotal, mListPrice, sMlsNo, sBrokerId, l.BrokerName, l.OfficeName, iListAgent1Id, iCoListAgent1id, iAccountId, l.ContactFirstName, l.ContactLastName, l.ContactTitle, iDispAddress, sNameLong, sCountryName, b.ContactFirstName as coFirst, b.ContactLastName as coLast, b.ContactTitle as coTitle, b.active, b.BrokerName as coBroker, b.OfficeName, sPhotoName, sPhotoUrl, fLatitude,fLongitude, sStatusSearch, sStyle, sAdRemarks, iListOffice1ID, l.TelephoneDirect, l.TelephoneOffice, l.OfficePhone, sSaleLeaseSearch, sTypeSearch, sBuildingTypeSearch, sRooms, sBedrooms, iBathrooms, iPictureTotal
		from vwListingActive l
		inner join tblAgentRecord as a on l.iListAgent1Id = a.ai
		inner join tblProvinces as prov on l.iProv=prov.iProvinceId
		inner join tblCountries as c on l.iCountry=c.iCountryId
		left outer join tblPhotosActive p on l.iListingId = p.iListingId and iDisplayOrder = 1
		left outer join tblAgentRecord as b on l.iCoListAgent1Id = b.ai
		where iListAgent1Id IN (select ai from tblAgentRecord where bDrarMember = 1)
		AND		sTypeSearch = 'Residential'
		AND		sSaleLeaseSearch = 'Lease'
		AND l.dCreated < dateadd(hh, -1, getdate())
		ORDER BY	l.dCreated DESC
	

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

										SELECT		dOHdate, tOHfrom, tOHto, sOHtime
										FROM			tblOpenHouses
										WHERE			iListingId = ?
								    	AND				dOHdate >= 'May 21, 2024'
								    	ORDER BY	dOHdate
								    

												SELECT		dOHdate, tOHfrom, tOHto, sOHtime
												FROM			tblOpenHouses
												WHERE			iListingId = ?
										    AND				dOHdate >= 'May 21, 2024'
										    ORDER BY	dOHdate
										  

	SELECT	sTeamID, IsInTeam, AgentID as iAgentId, ai as iAccountId
	FROM	tblAgentRecord
	WHERE	ai = ? 

	SELECT	ai, AgentHeadshotLocation, ContactFirstName, ContactLastName, ServiceLevel
	FROM	tblAgentRecord
	WHERE	ai = ? 

	select iBlogId, sBlogTitle, aid, sBlogEntry, dBlogDate, sAuthor, sBlogCategory, sSubtitle, sThumbnail, sBlogPicture, iCommun, iNeigh, sMetaDescription
	from	tblBlogEntries
	where	aid = '157146'
	and		bHidden IS NULL
	and 	dBlogDate <= getDate()
	order by dBlogDate DESC

	select DISTINCT sBlogCategory
	from	tblBlogEntries
	where	aid = '157146'
	and		bHidden IS NULL
	order by sBlogCategory

	select  sBlogTitle, iBlogId
	from	tblBlogEntries
	where	bFavourite = 'true'
	and		aid = '157146'

	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.durhamrealestate.org
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\www\MCStemplateFiles\CustomSites\Brokers\DRAR\default.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.durhamrealestate.org
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.durhamrealestate.org
HTTP_REFERER=http://www.quinte-mls.com/listings/QR1800076/picton/includes/js/assets/v2/img/site-overlay-icon-calculator@2x.png
HTTP_URL=/default.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\DRAR\default.cfm
QUERY_STRING=
REMOTE_ADDR=3.149.240.35
REMOTE_HOST=3.149.240.35
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/default.cfm
SERVER_NAME=www.durhamrealestate.org
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=196600085
CFTOKEN=d62ff953e8338f6b-12A17580-018E-4BAC-0E5FE238998882BD

Session Variables:
aid=0
aidblog=157146
badvtracking=0
btrebvow=0
cfid=196600085
cftoken=d62ff953e8338f6b-12A17580-018E-4BAC-0E5FE238998882BD
client=Struct (7)
defaultlocations=&cities=Ajax,Brock,Clarington,Oshawa,Pickering,Scugog,Uxbridge,Whitby
defaultprovince=&province=9
detailpagefeatured=0
detailpagehero=1
detailpagethumbnails=1
fp=
fps=
gapikey=AIzaSyBqTHxAiHrzlnJ7-ws55JmdjySRiSjlAOI
lstar=0
mobilesite=1
mysearch=
nearbyproperties=0
nearbyschools=0
neighbourhoodlistingsmap=1
neighbourhoodpagehero=0
nspdestid=0
pages=Struct (0)
pcspromo=0
primaryregion=Durham Region
realtorawards=0
realtordetailpage=1
recipient=Rhonda@DurhamRealEstate.org
sbrokerbrand=drar
sbrokerbrandlong=
sbrokercode=durhamreb
sbrokerlist=durhamreb
sbrokername=Durham Region Association of REALTORS
sbrokernamelong=Durham Region Association of REALTORS
sbrokernameshort=Durham Region Association of REALTORS
sdomain=durhamrealestate.org
seolinks=0
sessionid=D:\WWW\MCSTEMPLATEFILES\CUSTOMSITES\BROKERS\DRAR\APPLICATION.CFC_196600085_d62ff953e8338f6b-12A17580-018E-4BAC-0E5FE238998882BD
showbrokersolds=0
similarproperties=0
sitetype=broker
srealtorfirstname=
srealtorlastname=
srealtortitle=
steamtitle=
summarysplit=0
theme=bright
urltoken=CFID=196600085&CFTOKEN=d62ff953e8338f6b-12A17580-018E-4BAC-0E5FE238998882BD
wgflatitude=44.082509
wgflongitude=-78.953839