Why Leasing Brokers Use Our Product

The Best Brokers Close the Deal with Reis

There’s nothing like that final round of handshakes after you have closed a deal to place a corporate tenant into a commercial real estate space.

Rent Comps Sample Sales Comps Sample New Construction Sample

ReisReports is a low cost research tool that keeps you ahead of the competition, allows you to complete appraisals faster, and gives you access to trusted nationally recognized information.

Generate Market Reports in Seconds

We often hear from brokers that one of their most time-consuming tasks is translating charts and spreadsheets into write-ups that are easily understood by their clients.
Reis has solved this problem. Every quarter, for each market and submarket, Reis offers an Executive Briefing report, covering supply and demand fundamentals, including rent, vacancy, construction, absorption, and forecasts. The two minutes that it takes to read these reports confer upon the reader a conversational mastery of the market, which in turn helps leasing brokers impress their clients and prospects.

Market Narratives Submarket Narrative Sales Analysis

Brokers who use Reis information become trusted consultants to their clients. This leads to smoother negotiations, faster closes, more referrals, more business—and more commissions.


Debugging Information
ColdFusion Server Enterprise 11,0,05,293506
Template /index.cfm
Time Stamp 14-Dec-17 05:22 AM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.227.51.103
Host Name 54.227.51.103


Exceptions

05:22:31.031 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
05:22:31.031 - Expression Exception - in /websiteReisReports/wwwroot/Application.cfc : line 508
	    Element USER is undefined in SESSION.
	    
05:22:36.036 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element canonical is undefined in a CFML structure referenced as part of an expression.
	    
05:22:36.036 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element simplifi is undefined in a CFML structure referenced as part of an expression.
	    
05:22:36.036 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element inlineJS is undefined in a CFML structure referenced as part of an expression.
	    
05:22:36.036 - Expression Exception - in /websiteReisReports/components/com/model-glue/ModelGlue/gesture/collections/ViewCollection.cfc : line 50
	    Element underInlineJS is undefined in a CFML structure referenced as part of an expression.
	    


SQL Queries

getSessionID (Datasource=pQuarterly, Time=2ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 05:22:31.031
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
passwordData (Datasource=pQuarterly, Time=1ms, Records=1) in /websiteReisReports/components/com/reis/user/reisReportsUser/ReisReportsUser.cfc @ 05:22:31.031
		SELECT REGEXPATTERN,REGEXDESCRIPTION
		FROM PASSWORDREGEXPATTERN
		WHERE PASSWORDREGEXPATTERN_ID = 21
		
getSessionID (Datasource=pQuarterly, Time=0ms, Records=1) in /websiteReisReports/components/com/reis/user/UserSession.cfc @ 05:22:31.031
		SELECT S_CUSTOMER_SESSION_ID.nextval AS nextID
		FROM dual
		
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/wwwroot/Application.cfc @ 05:22:31.031
			INSERT INTO customerRequestLog(
				SESSIONID,
				REQUESTTIME,
				TEMPLATE,
				URL,
				FORM
			)
			VALUES(
				?,
				?,
				?,
				?,
				?
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 32AE699484B90001C87ADF4FAA819700.axis1
Parameter #2(cf_sql_timestamp) = 2017-12-14 05:22:31.37
Parameter #3(cf_sql_varchar) = /index.cfm
Parameter #4(cf_sql_varchar) = {"event":"static.leasingbrokers"}
Parameter #5(cf_sql_varchar) = {}

local.payperiods (Datasource=pQuarterlyMinus, Time=1ms, Records=3) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 05:22:31.031
			SELECT PAYPERIODID,PAYPERIOD
			FROM PAYPERIOD
		
subscriptionDetailQuery (Datasource=pQuarterlyMinus, Time=2ms, Records=0) in /websiteReisReports/components/com/reisreports2/reportBarrier/cashier.cfc @ 05:22:31.031
			SELECT
				theRank,
				trim(MSA.NAME) as NAME,
				MSA.MSA,
				MSA.state,
				SECTORDESC,
				S.SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				TEIRPRICE,
				ADDITIONALSECTORDISCOUNT,
				CASE
					WHEN theRank = 1 OR ISSUBSCRIPTION = 0 THEN TEIRPRICE
					ELSE TEIRPRICE - (TEIRPRICE*ADDITIONALSECTORDISCOUNT)
				END AS sectorPrice,
				ENDDATE,
				CUSTOMERPACKAGEITEMID,
				ISCURRENT,
				ISSUBSCRIPTION,
				isLocal,
				tier
			FROM (
				SELECT
					RANK() OVER (PARTITION BY MSA ORDER BY MSA, CP.ENDDATE NULLS FIRST,ISCURRENT DESC, SECTOR) AS theRank,
					MSA,
					SECTOR,
					INCLUDEDREPORTS,
					ISSAMPLE,
					CASE
						WHEN CP.ENDDATE IS NOT NULL THEN 0
						WHEN TIER = 1 AND ISSUBSCRIPTION = 1 THEN TIER1MSAPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 1 THEN TIER2MSAPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 1 THEN TIER3MSAPRICE
						WHEN TIER = 1 AND ISSUBSCRIPTION = 0 THEN TIER1REPORTPRICE
						WHEN TIER = 2 AND ISSUBSCRIPTION = 0 THEN TIER2REPORTPRICE
						WHEN TIER = 3 AND ISSUBSCRIPTION = 0 THEN TIER3REPORTPRICE
					END AS TEIRPRICE,
					ADDITIONALSECTORDISCOUNT,
					CP.ENDDATE,
					CP.CUSTOMERPACKAGEITEMID,
					ISCURRENT,
					ISSUBSCRIPTION,
					isLocal,
					tier
				FROM
					(
			
						SELECT CP.CUSTOMERPACKAGEID,CUSTOMERID,MSA,SECTOR,CPI.ENDDATE,CPI.CUSTOMERPACKAGEITEMID,ISSAMPLE,TIER, 1 ISCURRENT, 1 ISSUBSCRIPTION
						FROM
							CUSTOMERPACKAGE CP
							INNER JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
						WHERE NVL(CPI.ENDDATE,SYSDATE) >= SYSDATE 
					
						
			
					) CP
					LEFT JOIN (
			
						SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM (
							SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC,CUSTOMERPACKAGEOFFERID DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
							FROM CUSTOMERPACKAGEOFFER
						)
						WHERE THERANK = 1
			
					) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
					LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
					LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				WHERE
					CUSTOMERID = ?
					AND
					ISSAMPLE = 'N'
			) SUBSCRIPTIONS
			LEFT JOIN SECTOR S ON S.SECTOR = SUBSCRIPTIONS.SECTOR
			LEFT JOIN MSA ON MSA.MSA = SUBSCRIPTIONS.MSA
			
			WHERE 1 = 1
			
			ORDER BY NAME,THERANK
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

isSubscribed (Datasource=pQuarterlyMinus, Time=6ms, Records=0) in /websiteReisReports/components/com/reisreports2/customerPackage/customerPackage.cfc @ 05:22:31.031
		SELECT *
		FROM (
		
		WITH
		ENTITLEMENTS AS (
			SELECT
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE
			FROM
				CUSTOMERPACKAGE CP
				LEFT JOIN (
					
					SELECT CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
					FROM (
						SELECT RANK() OVER (PARTITION BY CUSTOMERPACKAGEID ORDER BY CREATEDATE DESC) AS THERANK,CUSTOMERPACKAGEOFFERID,CUSTOMERPACKAGEID,OFFERPRICEID,CREATEDATE
						FROM CUSTOMERPACKAGEOFFER
					)
					WHERE THERANK = 1
				
				) CPO ON CP.CUSTOMERPACKAGEID = CPO.CUSTOMERPACKAGEID
				LEFT JOIN OFFERPRICE OP ON OP.OFFERPRICEID = CPO.OFFERPRICEID
				LEFT JOIN OFFER O ON O.OFFERID = OP.OFFERID
				LEFT JOIN CUSTOMERPACKAGEITEM CPI ON CP.CUSTOMERPACKAGEID = CPI.CUSTOMERPACKAGEID
			WHERE
				CUSTOMERID = 0
				AND
				NVL(ENDDATE,SYSDATE) >= SYSDATE
		),
		PAYPERIOD AS (
			SELECT
				TRUNC(ADD_MONTHS(FIRSTPAYPPERIODSTARTDATE,FLOOR(MONTHS_BETWEEN(sysdate,FIRSTPAYPPERIODSTARTDATE)))) AS PAYPPERIODSTARTDATE
			FROM (
				SELECT
					nvl(PPP.FIRSTPAYDATE,CP.CREATEDATE) AS FIRSTPAYPPERIODSTARTDATE
				FROM
					CUSTOMERPACKAGE CP
					LEFT JOIN
						(
							SELECT
								PAYPALPROFILEID,
								ADD_MONTHS(TO_DATE(PP_START,'MMDDYYYY'),-1) AS FIRSTPAYDATE
								--this is the first day that we recived RECURING payment form the user.
								--We minus 1 becuase this is always in the future when a user starts.
							FROM PAYPALPROFILE
							WHERE DELETED = 'N'
						) PPP ON CP.PAYPALPROFILEID = PPP.PAYPALPROFILEID
				WHERE CUSTOMERID = 0
			)
		),
		ISNATIONAL AS (
			SELECT 1 ISNATIONAL
			FROM
				customerpackage join customerpackageitem on customerpackage.customerpackageid = customerpackageitem.customerpackageid
			WHERE customerid = 0
			AND msa is null
			AND sector is null
			AND ISSAMPLE ='N'
			AND (ENDDATE > sysdate OR ENDDATE is NULL)
        )
		
		
		
		SELECT
			ALLTOKENS.MSA,
			MSA.NAME,
			ALLTOKENS.SECTOR,
			S.SECTORDESC,
			--ALLTOKENS.INCLUDEDREPORTS,
			ALLTOKENS.REPORTTOKEN,
			ALLTOKENS.ISSAMPLE,
			ISSUBSCRIPTIONTOKEN,
			NVL(BILLABLETRANSACTIONS.ID,NONBILLABLETRANSACTIONS.ID) AS ID
		FROM
		(
			SELECT 
				MSA,
				SECTOR,
				INCLUDEDREPORTS,
				ISSAMPLE,
				'Y' ISSUBSCRIPTIONTOKEN, 
				REPORTTOKEN
			FROM
				ENTITLEMENTS join (select rownum as REPORTTOKEN from all_objects where rownum <= (select max(INCLUDEDREPORTS) from OFFER)) on includedreports >= REPORTTOKEN
			UNION
			SELECT
				CUSTOMERREPORTTOKEN.MSA,
				CUSTOMERREPORTTOKEN.SECTOR,
				1 INCLUDEDREPORTS,
				'N' ISSAMPLE,
				'N' ISSUBSCRIPTIONTOKEN, 
				RANK() OVER (PARTITION BY CUSTOMERREPORTTOKEN.MSA,CUSTOMERREPORTTOKEN.SECTOR ORDER BY CREATEDATE,CUSTOMERREPORTTOKENID) + NVL(ENTITLEMENTS.INCLUDEDREPORTS,0) AS REPORTTOKEN
			FROM
				CUSTOMERREPORTTOKEN
				LEFT JOIN ENTITLEMENTS ON
					(
						ENTITLEMENTS.MSA = CUSTOMERREPORTTOKEN.MSA
						AND
						ENTITLEMENTS.SECTOR = CUSTOMERREPORTTOKEN.SECTOR
					)  OR
					(
						ENTITLEMENTS.MSA IS NULL AND CUSTOMERREPORTTOKEN.MSA IS NULL
					   	AND
						ENTITLEMENTS.SECTOR IS NULL AND CUSTOMERREPORTTOKEN.SECTOR IS NULL
						AND ISSAMPLE = 'N'
					)
			WHERE
				CUSTOMERID = 0
				AND
				(ENDDATE > sysdate or ENDDATE IS NULL)
		) ALLTOKENS
		LEFT JOIN SECTOR S ON S.SECTOR = ALLTOKENS.SECTOR
		LEFT JOIN MSA ON MSA.MSA = ALLTOKENS.MSA
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				CASE
					WHEN (SELECT ISNATIONAL FROM ISNATIONAL) = 1 THEN
					    ROW_NUMBER() OVER (ORDER BY ORDER_DATE)
					ELSE
						ROW_NUMBER() OVER (PARTITION BY MSA,SECTOR ORDER BY ORDER_DATE)
				END AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 1
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) BILLABLETRANSACTIONS ON (
		  	BILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,BILLABLETRANSACTIONS.MSA)
		  	AND
		  	BILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,BILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	BILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ISSAMPLE = 'N'
			)
		LEFT JOIN (
			SELECT
				ID,
				MSA,
				SECTOR,
				ORDER_DATE,
				ROW_NUMBER() OVER (ORDER BY ORDER_DATE) AS REPORTTOKEN
			FROM TRANSACTIONS
			WHERE
				CUSTOMER_ID = 0
				AND
				ORDER_DATE >= (SELECT PAYPPERIODSTARTDATE FROM PAYPERIOD)
				AND
				TRANS_STATUS = 'C'
				AND
				BILLABLE = 0
				AND
				PRODUCTTYPE = 'RFSB'
				AND
				PARENT_TRANS_ID IS NULL
		) NONBILLABLETRANSACTIONS ON (
		  	NONBILLABLETRANSACTIONS.MSA = NVL(ALLTOKENS.MSA,NONBILLABLETRANSACTIONS.MSA)
		  	AND
		  	NONBILLABLETRANSACTIONS.SECTOR = NVL(ALLTOKENS.SECTOR,NONBILLABLETRANSACTIONS.SECTOR)
		  	AND
		  	NONBILLABLETRANSACTIONS.REPORTTOKEN = ALLTOKENS.REPORTTOKEN
		  	AND ALLTOKENS.ISSAMPLE = 'Y'
			)
		ORDER BY MSA,SECTOR,ISSAMPLE,REPORTTOKEN
		
		)
		WHERE
			ISSAMPLE != 'Y'
			AND ISSUBSCRIPTIONTOKEN != 'N'
		
getCustomerTestGroupID (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 05:22:31.031
						SELECT S_CUSTOMERTESTGROUP.nextVal AS nextVal
						FROM DUAL
					
getCurrentDistribution (Datasource=pQuarterlyMinus, Time=4642ms, Records=2) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 05:22:36.036
						SELECT
							NVL( DATA.TESTGROUP , SKELETON.TESTGROUP ) TESTGROUP,
							NVL( DATA.TESTGROUPPERCENT , SKELETON.TESTGROUPPERCENT ) TESTGROUPPERCENT
						FROM
						(
							SELECT 'A' AS TESTGROUP,-1  AS TESTGROUPPERCENT
							FROM DUAL
							UNION
							SELECT 'B',-1
							FROM DUAL
							UNION
							SELECT 'C',-1
							FROM DUAL
							UNION
							SELECT 'E',-1
							FROM DUAL
							UNION
							SELECT 'F',-1
							FROM DUAL
							UNION
							SELECT 'G',-1
							FROM DUAL
							UNION
							SELECT 'H',-1
							
							FROM DUAL
						) SKELETON
						LEFT JOIN
						(
							SELECT
								TESTGROUP,
								GROUPCOUNT/ROWCOUNT TESTGROUPPERCENT
							FROM (
								SELECT
									DISTINCT
									TESTGROUP,
								    COUNT(*) OVER (PARTITION BY TESTGROUP) GROUPCOUNT,
								    COUNT(*) OVER (PARTITION BY NULL) ROWCOUNT
								FROM CUSTOMERTESTGROUP
								WHERE createDate > TO_DATE('08/28/2014 02:38 P.M.','mm/dd/YYYY HH:MI A.M.')
								AND TESTGROUP in ('G','H')
							)
						) DATA
						ON SKELETON.TESTGROUP = DATA.TESTGROUP
						where SKELETON.TESTGROUP in ('G','H')
						ORDER BY SKELETON.TESTGROUP
					
(Datasource=pQuarterlyMinus, Time=2ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 05:22:36.036
						INSERT INTO CUSTOMERTESTGROUP(CUSTOMERTESTGROUPID,TESTGROUP,CREATEDATE,USERAGENT,sessionid,ipaddress)
						VALUES(	?,
								?,
								sysdate,
								?,
								?,
								?
								)
					
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 4394202
Parameter #2(cf_sql_varchar) = G
Parameter #3(cf_sql_varchar) = CCBot/2.0 (http://commoncrawl.org/faq/)
Parameter #4(cf_sql_varchar) = 32AE699484B90001C87ADF4FAA819700.axis1
Parameter #5(cf_sql_varchar) = 54.227.51.103

updateHits (Datasource=pQuarterlyMinus, Time=1ms, Records=1) in /websiteReisReports/modelglueapp/controller/reisreports2/localOnlyTest.cfc @ 05:22:36.036
				UPDATE
					CUSTOMERTESTGROUP
				SET HITS = HITS + 1
				WHERE CUSTOMERTESTGROUPID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 4394202.0

jobFunctionQuery (Datasource=pQuarterlyMinus, Time=1ms, Records=7) in /websiteReisReports/modelglueapp/controller/reisreports/registration.cfc @ 05:22:36.036
		
		SELECT title AS NAME,
			title AS VALUE
		FROM CUSTOMER_TITLE
		WHERE CORPORATE_ID = 16280034
		ORDER BY NAME
		


Scope Variables

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=/websiteReisReports/wwwroot/reisreports2/index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
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=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=rr.reis.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/websiteReisReports/wwwroot/reisreports2/index.cfm
QUERY_STRING=event=static.leasingbrokers
REMOTE_ADDR=54.227.51.103
REMOTE_HOST=54.227.51.103
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=rr.reis.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.15 (Unix) DAV/2 PHP/5.3.3 mod_jk/1.2.40
WEB_SERVER_API=
Cookie Variables:
CLIENTID=4D6E8D60-E901-AFCB-B13591E26BB5225D
CUSTOMERTESTGROUPID=4394202
Session Variables:
getpropertyreport=Complex type
getuser=Complex type
googleecommercearr=Array (0)
googleeventarr=Array (0)
haspropertyreport=Complex type
propertyreport=
sessionid=32AE699484B90001C87ADF4FAA819700.axis1
setpropertyreport=Complex type
setuser=Complex type
urltoken=CFID=1275276&CFTOKEN=3dac89be94153327-4D6E8D0D-B58E-63DB-78FDFDEE6338A869&jsessionid=32AE699484B90001C87ADF4FAA819700.axis1
user=Struct (99)
URL Parameters:
event=static.leasingbrokers
Debug Rendering Time: 4 ms