X
Powered by Windermere Real Estate of Spokane, WA
Primary Listing Image for MLS#: 201819227
  • 2414 E South Altamont Blvd Spokane, WA 99202
  • Status:New
  • Type: Residential
  • Bedrooms:5
  • Bathrooms:2
  • SQFT: 3,500
  • Year Built:1909

Coldwell Banker Tomlinson S
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201812439
  • 3307 E 12th Ave Spokane, WA 99202
  • Status:Active
  • Type: Residential
  • Bedrooms:2
  • Bathrooms:2
  • SQFT: 1,894
  • Year Built:1991

Coldwell Banker Tomlinson S
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201511133
  • 2003-17 E 1st Ave Spokane, WA 99202
  • Status:Active
  • Type: Commercial
  • Year Built:1900

G.K. Hansen Real Estate
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201816225
  • 4010 E 11 th. Ave Spokane, WA 99212
  • Status:Active
  • Type: Residential
  • Bedrooms:4
  • Bathrooms:3
  • Year Built:2004

Kelly Right Real Estate of Spokane
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201818833
  • 2608 E GIRARD Pl Spokane, WA 99223
  • Status:Active
  • Type: Residential
  • Bedrooms:5
  • Bathrooms:2
  • Year Built:1907

Keller Williams Spokane - Main
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201817124
  • 1325 S Ferrall St Spokane, WA 99202
  • Status:Active
  • Type: Residential
  • Bedrooms:4
  • Bathrooms:3
  • SQFT: 3,060
  • Year Built:1964

Top Gold Realty
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201818405
  • 4307 E 8th Ave Spokane, WA 99202
  • Status:Active
  • Type: Residential
  • Bedrooms:3
  • Bathrooms:2
  • Year Built:2014

TCT Real Estate, Inc.
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201818228
  • 3625 E 15th Ave Spokane, WA 99223
  • Status:Contingent - Inspection
  • Type: Residential
  • Bedrooms:4
  • Bathrooms:2
  • SQFT: 2,422
  • Year Built:1954

Keller Williams Spokane - Main
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201815629
  • 1712 E MALLON Ave Spokane, WA 99202
  • Status:Active
  • Type: Residential
  • Bedrooms:3
  • Bathrooms:2
  • SQFT: 1,689
  • Year Built:2017

Live Real Estate, LLC
Listing Courtesy: SARMLS
Primary Listing Image for MLS#: 201817722
  • 3148 E 16th Ave Spokane, WA 99223
  • Status:Contingent - Inspection
  • Type: Residential
  • Bedrooms:4
  • Bathrooms:1
  • SQFT: 1,832
  • Year Built:1930

Coldwell Banker Tomlinson N
Listing Courtesy: SARMLS


Debugging Information
Railo (Togo) Os FINAL 4.2.2.004 (CFML Version 10,0,0,0)
Template /index.cfm (/var/nfs/www/gdwebs/3341/index.cfm)
Time Stamp Jul 20, 2018 3:19 PM
Time Zone America/Los_Angeles
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 0:0:0:0:0:0:0:1
Host Name windermerespokane.com
Architecture 32bit


Execution Time

Total Time Avg Time Count Template
4751 ms 4751 ms 1 /var/nfs/www/gdcore3/mlscore/sarmls/qry_results.cfm
122 ms 122 ms 1 /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
104 ms 104 ms 1 /var/nfs/www/gdcore3/webcore/area/start.cfm
41.2 ms 41.2 ms 1 /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_pageview.cfm
36.5 ms 36.5 ms 1 /var/nfs/www/gdcore3/webcore/area/instant.cfm
14.8 ms 14.8 ms 1 /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu.cfm
8.07 ms 8.07 ms 1 /var/nfs/www/gdcore3/webcore/site/config/extract.cfm
23.7 ms 2.96 ms 8 /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
2.84 ms 2.84 ms 1 /var/nfs/www/gdwebs/3341/gd/module/footer.cfm
2.42 ms 2.42 ms 1 /var/nfs/www/gdcore3/webcore/site/build/marquee/templates/marquee_1.cfm
1.44 ms 1.44 ms 1 /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_analytics.cfm
1.02 ms 1.02 ms 1 /var/nfs/www/gdcore3/webcore/site/config/transition.cfm
0.89 ms 0.89 ms 1 /var/nfs/www/gdcore3/webcore/site/config/roadblock.cfm
6.26 ms 0.626 ms 10 /var/nfs/www/gdcore3/mlscore/sarmls/listing_setup.cfm
0.458 ms 0.458 ms 1 /var/nfs/www/gdcore3/webcore/site/build/footer/inc/fineprint.cfm
0.265 ms 0.265 ms 1 /var/nfs/www/gdcore3/mlscore/listings_refine.cfm
0.26 ms 0.26 ms 1 /var/nfs/www/gdcore3/webcore/site/build/head/output.cfm
0.221 ms 0.11 ms 2 /var/nfs/www/gdcore3/webcore/module/gdpaging.cfm
0.161 ms 0.08 ms 2 /var/nfs/www/gdcore3/mlscore/listings_nav.cfm
0.076 ms 0.076 ms 1 /var/nfs/www/gdcore3/webcore/site/build_setup.cfm
0.752 ms 0.075 ms 10 /var/nfs/www/gdcore3/mlscore/listing.cfm
0.059 ms 0.059 ms 1 /var/nfs/www/gdcore3/webcore/search/listings_setup.cfm
0.105 ms 0.052 ms 2 /var/nfs/www/gdcore3/mlscore/searchString_decode.cfm
0.05 ms 0.05 ms 1 /var/nfs/www/gdcore3/webcore/site/build/footer/inc/disclaimer.cfm
0.049 ms 0.049 ms 1 /var/nfs/www/gdcore3/webcore/site/build/footer/content.cfm
0.799 ms 0.039 ms 20 /var/nfs/www/gd/core/tags/gdFieldValues.cfm
0.027 ms 0.027 ms 1 /var/nfs/www/gdcore3/webcore/site/build/content/banner.cfm
0.023 ms 0.023 ms 1 /var/nfs/www/gdcore3/webcore/site/build/marquee/content.cfm
0.022 ms 0.022 ms 1 /var/nfs/www/gdcore3/webcore/area/instant_banner.cfm
0.021 ms 0.021 ms 1 /var/nfs/www/gdcore3/webcore/site/build/header/content.cfm
0.02 ms 0.02 ms 1 /var/nfs/www/gdcore3/webcore/site/build/tracking/output.cfm
0.019 ms 0.019 ms 1 /var/nfs/www/gdcore3/webcore/area/inc/data_listings.cfm
0.015 ms 0.015 ms 1 /var/nfs/www/gdcore3/webcore/widget/area_map_spatial.cfm
0.015 ms 0.015 ms 1 /var/nfs/www/gdcore3/webcore/site/build/header/templates/header_1.cfm
0.015 ms 0.015 ms 1 /var/nfs/www/gdcore3/webcore/site/build/message/output.cfm
0.014 ms 0.014 ms 1 /var/nfs/www/gdcore3/mlscore/listings_poweredby.cfm
0.011 ms 0.011 ms 1 /var/nfs/www/gdcore3/mlscore/inc/inc_searchQOpenHouses.cfm
0.01 ms 0.01 ms 1 /var/nfs/www/gdcore3/webcore/gd_methods.cfm
0.008 ms 0.008 ms 1 /var/nfs/www/gdcore3/webcore/site/build/control/output.cfm
0.007 ms 0.007 ms 1 /var/nfs/www/gdcore3/webcore/area/inc/data_map.cfm
0.007 ms 0.007 ms 1 /var/nfs/www/gdcore3/gd_cffunctions.cfm
0.072 ms 0.007 ms 10 /var/nfs/www/gdcore3/mlscore/sarmls/fieldvalues/gdStatus.cfm
0.059 ms 0.005 ms 10 /var/nfs/www/gdcore3/mlscore/sarmls/fieldvalues/gdPropType.cfm
0.005 ms 0.005 ms 1 /var/nfs/www/gdcore3/webcore/gd_layouts.cfm
0.005 ms 0.005 ms 1 /var/nfs/www/gdcore3/mlscore/listings_disclaimer.cfm
0.004 ms 0.004 ms 1 /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_custom.cfm
0.004 ms 0.004 ms 1 /var/nfs/www/webs/config.cfm
0.003 ms 0.003 ms 1 /var/nfs/www/gdcore3/webcore/site/build/status/output.cfm
0.002 ms 0.002 ms 1 /var/nfs/www/gdcore3/webcore/gd_circuits.cfm
0.002 ms 0.002 ms 1 /var/nfs/www/gdcore3/webcore/client/control.cfm
0.002 ms 0.002 ms 1 /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_account.cfm
0.001 ms 0.001 ms 1 /var/nfs/www/gdcore3/webcore/site/build/debug/output.cfm
0 ms 0 ms 1 /var/nfs/www/gdwebs/3341/index.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/mlscore/listings.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/config/render.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/build/nav/output.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/gd_fusebox.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/build/footer/output.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/gd_switch.cfm
0 ms 0 ms 1 /var/nfs/www/gd/core/tags/gdStartSite.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/build/nav/templates/nav_2.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/build/marquee/output.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/layout/page.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/area/listings.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/site/build/header/output.cfm
0 ms 0 ms 1 /var/nfs/www/gdcore3/webcore/template/area_instant.cfm
0.435 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
419 ms  APPLICATION EXECUTION TIME
4701 ms  QUERY EXECUTION TIME
5121 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Implicit variable Access

Scope Template Line Var Count
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 4 PATH_TRANSLATED 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 81 remote_addr 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 102 PATH_TRANSLATED 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 859 server_software 2
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 871 request_url 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 876 SERVER_NAME 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 894 SERVER_NAME 1
cgi /var/nfs/www/gd/core/tags/gdStartSite.cfm 896 server_software 2
cgi /var/nfs/www/gdcore3/mlscore/listings_refine.cfm 1 remote_addr 1
query /var/nfs/www/gdcore3/mlscore/sarmls/listing_setup.cfm 28 currentrow 10
query /var/nfs/www/gdcore3/mlscore/sarmls/listing_setup.cfm 28 gdListingID 10
cgi /var/nfs/www/gdcore3/webcore/gd_fusebox.cfm 495 local_host 2
cgi /var/nfs/www/gdcore3/webcore/site/build/footer/inc/fineprint.cfm 3 HTTP_USER_AGENT 2
cgi /var/nfs/www/gdcore3/webcore/site/build/head/output.cfm 57 remote_addr 1
cgi /var/nfs/www/gdcore3/webcore/site/build/marquee/templates/marquee_1.cfm 8 PATH_TRANSLATED 1
cgi /var/nfs/www/gdcore3/webcore/site/build/marquee/templates/marquee_1.cfm 11 PATH_TRANSLATED 1
query /var/nfs/www/gdcore3/webcore/site/build/marquee/templates/marquee_1.cfm 29 name 6
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 14 siteId 8
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 43 pageId 15
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 44 pageParentId 15
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 62 pageTitle 15
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 67 pageKey 15
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 67 pageType 15
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm 70 pageKey 30
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu.cfm 18 pageParentId 48
query /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu.cfm 22 pageDefault 26
query /var/nfs/www/gdcore3/webcore/site/build/nav/templates/nav_2.cfm 22 pageId 8
cgi /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_analytics.cfm 1 HTTP_REFERER 6
cgi /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_analytics.cfm 65 server_name 1
cgi /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_analytics.cfm 66 server_name 1
cgi /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_pageview.cfm 1 server_name 2
cgi /var/nfs/www/gdcore3/webcore/site/config/roadblock.cfm 7 query_string 2
cgi /var/nfs/www/gdcore3/webcore/site/config/roadblock.cfm 12 remote_addr 1
cgi /var/nfs/www/gdcore3/webcore/site/config/roadblock.cfm 19 http_user_agent 2
cookie /var/nfs/www/gdcore3/webcore/site/config/transition.cfm 323 cftoken 1
cookie /var/nfs/www/gdcore3/webcore/site/config/transition.cfm 323 cfid 1
cookie /var/nfs/www/gdcore3/webcore/site/config/transition.cfm 324 cftoken 1
cookie /var/nfs/www/gdcore3/webcore/site/config/transition.cfm 324 cfid 1
query /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm 32 area_id 29
query /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm 39 area_id 19
query /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm 42 area_title 29


SQL Queries

get_siteDomain (Datasource=gd, Time=4.67 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
the following colum(s) are never read within the request:messagingformconfirmationemailbody_showingrequest,headerhtml,transitional_domain_expiration,transitional_registrarusername,messagingemail,colorprimaryover,transitional_registrarname,transitional_pageid_roster,sidebarhtml,messagingformconfirmationemailsubject,profile_socialflickrurl,uistyletheme,hostid,updatedby,transitional_gdwebsiteincludecontainer,leadrouteid,googleanalyticspassword,jscustom,rosterid,messagingformconfirmationemailbody,headertext1,messagingformconfirmationwebbody_showingrequest,webtypeid,transitional_gdwebsiteincludesplash,suspendaen,userplanid,profile_socialyoutube,transitional_pageid_local,messagingformconfirmationwebheading_showingrequest,transitional_pageid_splash,domainmodeid,footertext,transitional_gdwebsiteincludecoda,headertypeid,collectiveid,headertext2,spaceid,profile_socialpinterest,navhtml,transitional_gdwebsiteincludewrapper,ns2,transitional_gdwebsiteinclude404,transitional_pageid_search,mediaphotourl2,sitemodeid,transitional_gdwebsitenavmainbackgroundselected,domaintypeid,transitional_mediaheaderurl,groupid,profile_socialfacebook,transitional_dns_managed_other,csscustom,metadescription,googleverificationcode,mobileuicss,csstypeset,parentsiteid,profile_socialinstagram,transitional_gdwebsitenavmainbackground,deletedat,cssprint,transitional_gdwebsitestylesheet,profile_socialfoursquare,profile_socialgoogleplus,colorsecondaryover,profile_socialtumbler,transitional_pageid_client,memberid,colortext,gdcore,transitional_gdwebsitenavstatedefault,footertypeid,transitional_gdwebsiteincluderider,mediaphotourl1,mobileuidatatheme,transitional_gdwebsiteincludefooter,profileid,sitecore,statusid,colorsecondary,mobileuicssuser,cssuser,metakeywords,publishdomains,transitional_gdwebsiteincludecontent,profile_sociallinkedin,messagingformconfirmationwebheading,siteclasskey,machinename,cssmobile,audit_review_internal,messagecenterid,domainname,transitional_gdwebsitenavstateselected,transitional_gdwebsitenavmaincolor,machinepath,sitestatusid,transitional_pageid_social,templateid,userid,transitional_gdwebsiteincludeheader,isprimary,hasemail,transitional_gdwebsitenavstateover,transitional_pageid_contact,siteclassid,transitional_buildorder,messagingformconfirmationwebbody,audit_review_nouser,profile_socialtwitter,marqueehtml,transitional_gdwebsiteincludenavigation,id,transitional_gdwebsitenavmainheight,coloraccentover,title,itemid,profile_mediaphotourl,transitional_pageid_markets,footerhtml,transitional_pageid_home,createdat,coloraccent,metatitle,transitional_gdwebsitelogindefault,colorprimary,googleanalyticscode,ns1,googleanalyticsusername,marqueetypeid,transitional_notes,stylecode,messagingformconfirmationemailsubject_showingrequest,cssmodal,mobileuistyletheme,navtypeid,audit_notpointedtogddns,transitional_dns_gd_managed,isverified,label,transitional_pageid_areas,aencc,description,disclaimer,transitional_gdwebsiteincludedetail,csselements,transitional_gdwebsitenavmaincolorselected,sitetypeid,createdby,transitional_gdwebsiteincludeoutput,mobileuidatathemebutton,sidebartypeid,publishedat,sitecategoryid,navcount,transitional_gdwebsiteincludecredits,transitional_gdwebsiteincludeinformation,cssdesign,machineid,updatedat,csstailored,medialogourl,transitional_registrarpassword,profile_medialogourl,cssstructure,headertext3
		select		*
		from		domains d
		inner join	sitedomains sd on d.id = sd.domainid
		inner join	sites s on sd.siteid = s.id
		where		d.domainname = 'windermerespokane.com'
	
get_siteDomain (Datasource=graphicaldata, Time=0 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
		SELECT				website_domain_id as domainId,
									website_domain as domainName,
									gdGoogleAnalytics as domainGoogleAnalyticsCode,
									gdGoogleVerify as domainGoogleVerifyCode,
									website_id as siteId	
		FROM					website_domains
		WHERE				website_domain = 'windermerespokane.com'
	
get_site (Datasource=gd, Time=0 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
the following colum(s) are never read within the request:messagingformconfirmationemailbody_showingrequest,messagingformconfirmationemailsubject,hostid,updatedby,transitional_gdwebsiteincludecontainer,messagingformconfirmationemailbody,headertext1,messagingformconfirmationwebbody_showingrequest,webtypeid,transitional_gdwebsiteincludesplash,userplanid,profile_socialyoutube,messagingformconfirmationwebheading_showingrequest,transitional_gdwebsiteincludecoda,collectiveid,headertext2,profile_socialpinterest,transitional_gdwebsiteincludewrapper,transitional_gdwebsiteinclude404,mediaphotourl2,sitemodeid,transitional_gdwebsitenavmainbackgroundselected,transitional_mediaheaderurl,mobileuicss,parentsiteid,profile_socialinstagram,transitional_gdwebsitenavmainbackground,deletedat,transitional_gdwebsitestylesheet,profile_socialfoursquare,profile_socialgoogleplus,profile_socialtumbler,memberid,gdcore,transitional_gdwebsitenavstatedefault,transitional_gdwebsiteincluderider,mobileuidatatheme,mediaphotourl1,transitional_gdwebsiteincludefooter,sitecore,statusid,mobileuicssuser,cssuser,publishdomains,transitional_gdwebsiteincludecontent,messagingformconfirmationwebheading,siteclasskey,audit_review_internal,messagecenterid,transitional_gdwebsitenavstateselected,transitional_gdwebsitenavmaincolor,templateid,transitional_gdwebsiteincludeheader,transitional_gdwebsitenavstateover,messagingformconfirmationwebbody,audit_review_nouser,transitional_gdwebsiteincludenavigation,transitional_gdwebsitenavmainheight,title,profile_mediaphotourl,transitional_pageid_home,createdat,transitional_gdwebsitelogindefault,transitional_notes,messagingformconfirmationemailsubject_showingrequest,mobileuistyletheme,label,aencc,description,disclaimer,transitional_gdwebsiteincludedetail,transitional_gdwebsitenavmaincolorselected,createdby,transitional_gdwebsiteincludeoutput,mobileuidatathemebutton,sitecategoryid,transitional_gdwebsiteincludecredits,transitional_gdwebsiteincludeinformation,machineid,updatedat,medialogourl,profile_medialogourl,headertext3
		SELECT				*
		FROM				sites
		WHERE				id = 3341
	
get_siteblog (Datasource=gd, Time=3.48 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
		SELECT		b.domainname
		FROM		siteblogs sb
		INNER JOIN	blogs b ON sb.blogid = b.id
		WHERE		sb.siteid = 3341
	
get_sitePageIdHome (Datasource=graphicaldata, Time=0 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
		SELECT				TOP 1 page_id as id
		FROM				pages
		WHERE				website_id = 3341
		and					page_default = 1
	
find_rosterProfile (Datasource=gd, Time=0 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
the following colum(s) are never read within the request:templateid,token,createdat,profile_title,deletedat,statusid,createdby,profile_websiteurl,transitional_gdfranchiseid,updatedby,code,updatedat,id,franchiseid,rostertypeid,transitional_collectivelogorequired,title,label,profile_medialogourl,ismanaged,description,profile_email,ispublic
				SELECT				*
				FROM				rosters
				WHERE				id = 1
			
get_siteProfile (Datasource=gd, Time=0 ms, Records=1) in /var/nfs/www/gd/core/tags/gdStartSite.cfm
the following colum(s) are never read within the request:parentid,resumetext,mediayoutubeurl,resumeheading,id,contactname,contactid,socialtumblr,resumeid
			SELECT				*
			FROM				profiles
			WHERE				id = 77204
		
get_site_pages (Datasource=graphicaldata, Time=0 ms, Records=188) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
	select			*
	from			sitePage
	where			siteId = 3341
check_areaRenderKeyForTransition (Datasource=graphicaldata, Time=7.82 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/config/extract.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
		select 		*
		from		sitePage
		where		pageKey = 'area/6715'
		and			siteId = 3341
	
get_siteAPIs (Datasource=gd, Time=3.88 ms, Records=2) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:apiid,createdat,apitypeid,deletedat,statusid,createdby,siteid,updatedby,updatedat,id,title,label,description
	select				*
	from				SiteAPIs
	inner join			API on SiteAPIs.apiId = API.id
	where				SiteAPIs.siteId = 3341
	order by			API.code
get_siteRoster (Datasource=gd, Time=0 ms, Records=284) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:memberprofile_websiteLabel,groupprofile_socialTumblr,groupprofile_introductionHeading,groupprofile_directions,memberprofile_socialYouTube,groupprofile_socialInstagram,rostertype_label,memberprofile_phoneWireless,memberprofile_blogLabel,memberprofile_phone,member_roles,groupprofile_companyName,memberprofile_socialPinterest,member_mlsOfficeId,member_mlsRoles,memberprofile_resumeText4,memberprofile_socialFacebook,groupprofile_websiteLabel,memberprofile_websiteUrl,memberprofile_socialGooglePlus,groupprofile_introductionText,groupprofile_socialFlickr,groupprofile_socialYouTube,groupprofile_socialFoursquare,memberprofile_socialInstagram,memberprofile_blogUrl,groupprofile_mediaPhotoUrl,groupprofile_email,groupprofile_socialGooglePlus,memberprofile_phonePager,memberprofile_templateId,memberprofile_resumeHeading1,site_mlsCode,groupprofile_socialPinterest,memberprofile_resumeHeading2,roster_templateId,memberprofile_languages,memberprofile_fullName,memberprofile_resumeHeading3,memberprofile_mediaLogoUrl,groupprofile_blogUrl,memberprofile_phoneOffice,member_mlsTitle,group_mlsTitle,member_userId,groupprofile_streetAddress2,groupprofile_zipCode,memberprofile_resumeText1,grouptypeid,memberprofile_firstName,memberId,memberprofile_resumeHeading4,memberprofile_phoneFax,memberprofile_socialFoursquare,groupprofile_mediaLogoUrl,groupprofile_latitude,group_mlsCode,groupprofile_websiteUrl,memberprofile_phoneTollFree,member_mlsCode,memberprofile_socialTumblr,rosterprofile_name,member_mlsLabel,group_mlsDescription,groupprofile_templateId,groupp_description,grouptype_label,member_mlsDescription,groupprofile_phoneFax,memberprofile_socialFlickr,memberprofile_credentials,siteId,member_mlsAgentLicense,group_label,group_mlsLabel,memberprofile_email,memberprofile_lastName,memberprofile_resumeText3,groupprofile_city,group_title,groupprofile_mediayoutubeurl,groupprofile_phoneTollFree,groupprofile_county,roster_isPublic,groupprofile_legalName,site_mlsPoweredBy,groupprofile_socialLinkedIn,memberprofile_resumeText2,memberprofile_socialTwitter,groupprofile_state,groupprofile_socialTwitter,groupprofile_longitude,groupprofile_socialFacebook,memberprofile_socialLinkedIn,memberprofile_mediaPhotoUrl,memberprofile_phoneWork,memberprofile_phoneDirect,groupprofile_blogLabel,site_mlsId,groupprofile_phone,groupprofile_streetAddress,memberprofile_mediayoutubeurl
	SELECT		*
	FROM		SiteRosterGroupMemberUsers
	WHERE		siteId = 3341
	ORDER BY	siteId, rosterId, groupId, member_mlsId, member_mlsOfficeId, member_mlsAgentId, memberId
	-- via gd
get_siteRosterGroups (Datasource=gd, Time=0 ms, Records=284) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:memberprofile_websiteLabel,groupprofile_socialTumblr,groupprofile_introductionHeading,groupprofile_directions,memberprofile_socialYouTube,groupprofile_socialInstagram,rostertype_label,memberprofile_phoneWireless,memberprofile_blogLabel,memberprofile_phone,member_roles,rosterId,groupprofile_companyName,memberprofile_socialPinterest,member_mlsOfficeId,member_mlsRoles,memberprofile_resumeText4,memberprofile_socialFacebook,groupprofile_websiteLabel,memberprofile_websiteUrl,memberprofile_socialGooglePlus,groupprofile_introductionText,groupprofile_socialFlickr,groupprofile_socialYouTube,groupprofile_socialFoursquare,memberprofile_socialInstagram,roster_token,memberprofile_blogUrl,groupprofile_mediaPhotoUrl,groupprofile_email,groupprofile_socialGooglePlus,memberprofile_phonePager,memberprofile_templateId,memberprofile_resumeHeading1,site_mlsCode,groupprofile_socialPinterest,memberprofile_resumeHeading2,roster_templateId,groupId,memberprofile_languages,memberprofile_fullName,memberprofile_resumeHeading3,memberprofile_mediaLogoUrl,groupprofile_blogUrl,memberprofile_phoneOffice,member_mlsTitle,group_mlsTitle,member_userId,groupprofile_streetAddress2,groupprofile_zipCode,member_mlsAgentId,memberprofile_resumeText1,grouptypeid,memberprofile_firstName,memberId,memberprofile_resumeHeading4,memberprofile_phoneFax,memberprofile_socialFoursquare,groupprofile_mediaLogoUrl,groupprofile_latitude,roster_description,group_mlsCode,groupprofile_websiteUrl,roster_code,memberprofile_phoneTollFree,member_mlsCode,memberprofile_socialTumblr,rosterprofile_name,member_mlsLabel,group_mlsDescription,groupprofile_templateId,group_mlsId,member_mlsId,groupp_description,grouptype_label,member_mlsDescription,groupprofile_phoneFax,memberprofile_socialFlickr,memberprofile_credentials,siteId,member_mlsAgentLicense,group_label,group_mlsLabel,memberprofile_email,memberprofile_lastName,memberprofile_resumeText3,groupprofile_city,group_title,groupprofile_mediayoutubeurl,groupprofile_phoneTollFree,groupprofile_county,roster_isPublic,groupprofile_legalName,site_mlsPoweredBy,groupprofile_socialLinkedIn,memberprofile_resumeText2,memberprofile_socialTwitter,groupprofile_state,groupprofile_socialTwitter,groupprofile_longitude,groupprofile_socialFacebook,roster_title,memberprofile_socialLinkedIn,memberprofile_mediaPhotoUrl,memberprofile_phoneWork,memberprofile_phoneDirect,groupprofile_blogLabel,site_mlsId,groupprofile_phone,rostertypeid,groupprofile_streetAddress,memberprofile_mediayoutubeurl,roster_label,group_mlsOfficeId
	SELECT		*
	FROM		SiteRosterGroupMemberUsers
	WHERE		siteId = 3341
	ORDER BY	group_label
	-- via gd
get_siteMLS (Datasource=gd, Time=0 ms, Records=7) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
	select				MLS.code as mls_code, MLS.id as mls_id
	from				SiteMLS
	INNER JOIN			MLS on SiteMLS.mlsId = MLS.id
	where				SiteMLS.siteId = 3341
	and					SiteMLS.statusId > 0
	order by			MLS.id
	-- via gd
get_siteHost (Datasource=gd, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:websiteLabel,resumeHeading1,profileId,resumeText2,introductionText,statusId,socialGooglePlus,latitude,socialYouTube,socialTumbler,phoneWireless,phonePager,socialLinkedIn,introductionHeading,phoneDirect,reportstyleCode,userId,lastName,socialInstagram,zipCode,resumeText1,socialFlickr,credentials,resumeHeading2,streetAddress,phone,mediaPhotoUrl,phoneFax,isPublic,phoneTollFree,longitude,socialTwitter,streetAddress2,legalName,resumeHeading3,socialPinterest,state,firstName,name,city,socialFacebook,email,websiteUrl,county,profiletypeId,blogLabel,resumeText3,languages,phoneHome,resumeHeading4,socialFoursquare,phoneWork,blogUrl,companyName,mediaLogoUrl,publicKey,phoneOffice
		SELECT				p.id as profileId, p.profiletypeId, p.publicKey, h.userId, p.statusId, p.isPublic, p.languages, p.name, p.firstName, p.lastName, p.credentials, p.companyName, p.legalName, p.streetAddress, p.streetAddress2, p.city, p.state, p.zipCode, p.county, p.latitude, p.longitude, p.email, p.phone, p.phoneWork, p.phoneWireless, p.phoneHome, p.phoneDirect, p.phoneOffice, p.phoneTollFree, p.phoneFax, p.phonePager, p.socialFacebook, p.socialLinkedIn, p.socialTwitter, p.socialGooglePlus, p.socialFlickr, p.socialPinterest, p.socialInstagram, p.socialTumbler, p.socialYouTube, p.socialFoursquare, p.websiteLabel, p.websiteUrl, p.blogLabel, p.blogUrl, p.mediaPhotoUrl, p.mediaLogoUrl, p.introductionHeading, p.introductionText, p.resumeHeading1, p.resumeText1, p.resumeHeading2, p.resumeText2, p.resumeHeading3, p.resumeText3, p.resumeHeading4, p.resumeHeading4, p.reportstyleCode
		FROM					Hosts AS h
		INNER JOIN		Profiles AS p on h.profileId = p.id
		WHERE				h.siteId = 3341
		AND					h.contexttypeId = 0
		-- via gd, but change to propert SiteHost view (like roster)
	
get_siteAreas (Datasource=gd, Time=0 ms, Records=79) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:templateid,profileid,createdat,deletedat,statusid,createdby,hostid,siteid,updatedby,pageid,updatedat,id
			select			*
			from			SiteAreas
			where			siteId = 3341
			-- via gd
		
KILL_get_localKey (Datasource=graphicaldata, Time=0 ms, Records=1) in /var/nfs/www/gdcore3/webcore/gd_settings_railo.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
	select				*
	from				sitePage
	where				pageId = 112298
	-- UGH FIX THIS
get_areapage (Datasource=graphicaldata, Time=7.42 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,areaId,pageSidebarHTML,pageHeaderImage,pageNavHTML,areaTitle,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
		select			pageTitle as areaTitle,
						pageTypeKey as areaId,
						pageKey,
						*
		from			sitePage
		where			pagetype = 15
		and 			pagetypeKey = '6715'
		and				siteId = 3341
	
get_area (Datasource=gd, Time=4.81 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/start.cfm
		SELECT			areas.id as area_id,
						areas.areatypeid as area_areatypeid,
						areas.spatialareaid as area_spatialid,
						areas.userid as area_userid,
						areas.code as area_code,
						areas.label as area_label,
						areas.title as area_title,
						areas.description as area_description,
						areas.statusid as area_statusid,
						areas.profileid as area_profileid,
						areas.tag as area_tag,
						areas.searchstring as area_searchstring,
						areas.profilestring as area_profilestring,
						areas.latitude as area_latitude,
						areas.longitude as area_longitude,
						areas.createdby as area_createdby,
						areas.updatedby as area_updatedby,
						areas.createdat as area_createdat,
						areas.updatedat as area_updatedat,
						areas.deletedat as area_deletedat
		FROM			areas
		WHERE			areas.id = 6715
	
get_area_spatial (Datasource=gdspatial, Time=4.57 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/start.cfm
				SELECT			spatials.id as spatial_id,
								spatials.token as spatial_token,
								spatials.spatialstatusid as spatial_spatialstatusid,
								spatials.spatialtypeid as spatial_spatialtypeid,
								spatials.tag as spatial_tag,
								spatials.label as spatial_label,
								spatials.title as spatial_title,
								spatials.description as spatial_description,
								spatials.latitude as spatial_latitude,
								spatials.longitude as spatial_longitude,
								spatials.polygon as spatial_polygon,
								spatials.shape as spatial_shape,
								spatials.reprocess as spatial_reprocess,
								spatials.createdby as spatial_createdby,
								spatials.updatedby as spatial_updatedby,
								spatials.createdat as spatial_createdat,
								spatials.updatedat as spatial_updatedat,
								spatials.deletedat as spatial_deletedat
				FROM			spatials
				WHERE			spatials.id = 30146
			
temp_get_mlsid (Datasource=gd, Time=4.15 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/start.cfm
				SELECT		id as mls_id
				FROM		mls
				WHERE		code = 'SARMLS'
			
get_area_listing_collections (Datasource=gd, Time=10.4 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:transitional_accountid,accessid,searchid,userid,isprimary,createdat,uisortorder,deletedat,collectionid,areaid,statusid,createdby,updatedby,mlsid,code,transitional_userid,updatedat,id,collectiontypeid,title,label,description,sortorder
			select				*
			from				areacollections
			inner join 			collections on areacollections.collectionid = collections.id
			where				areacollections.areaid = 6715
			AND					collections.collectiontypeid in (1,2)
			ORDER BY			areacollections.uisortorder,areacollections.id
		
get_area_listing_collection (Datasource=gd, Time=6.53 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:transitional_accountid,accessid,searchid,userid,isprimary,createdat,uisortorder,deletedat,collectionid,areaid,statusid,createdby,updatedby,mlsid,code,transitional_userid,updatedat,id,collectiontypeid,title,label,description,sortorder
			select				*
			from				areacollections
			inner join 			collections on areacollections.collectionid = collections.id
			where				areacollections.areaid = 6715
			AND					collections.collectiontypeid in (1,2)
			and					areacollections.isprimary = 1	
		
get_area_listing_collection (Datasource=gd, Time=8.14 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:transitional_accountid,accessid,searchid,userid,isprimary,createdat,uisortorder,deletedat,collectionid,areaid,statusid,createdby,updatedby,mlsid,code,transitional_userid,updatedat,id,collectiontypeid,title,label,description,sortorder
				select				top 1 *
				from				areacollections
				inner join 			collections on areacollections.collectionid = collections.id
				where				areacollections.areaid = 6715
				AND					collections.collectiontypeid in (1,2)
				order by			areacollections.uisortorder,areacollections.id	
			
get_area_school_collections (Datasource=gd, Time=6.81 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:transitional_accountid,accessid,searchid,userid,isprimary,createdat,uisortorder,deletedat,collectionid,areaid,statusid,createdby,updatedby,mlsid,code,transitional_userid,updatedat,id,collectiontypeid,title,label,description,sortorder
			select				*
			from				areacollections
			inner join 			collections on areacollections.collectionid = collections.id
			where				areacollections.areaid = 6715
			AND					collections.collectiontypeid in (3,4)
			and					areacollections.isprimary = 1	
		
get_area_school_collections (Datasource=gd, Time=8.28 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:transitional_accountid,accessid,searchid,userid,isprimary,createdat,uisortorder,deletedat,collectionid,areaid,statusid,createdby,updatedby,mlsid,code,transitional_userid,updatedat,id,collectiontypeid,title,label,description,sortorder
				select				top 1 *
				from				areacollections
				inner join 			collections on areacollections.collectionid = collections.id
				where				areacollections.areaid = 6715
				AND					collections.collectiontypeid in (3,4)
				order by			areacollections.uisortorder,areacollections.id	
			
get_area_schools (Datasource=gddataset, Time=32.1 ms, Records=5) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:GradeHigh,school,zip,long,lat,DistrictName,photocount,district,GradeLow,state,schoolType,city,schoolname
						select			gdschoolcode as school,
										gdschoolcode as school_code,
										GDDistrictID as district,
										schname as schoolname,
										state as state,
										schoolType,
										GradeLow,
										GradeHigh,
										DistrictName,
										city,
										state,
										zip,
										lat,
										long,
										photocount
						from			schoolview
						where	    	(lat >= 47.634657452632)
						and				(lat <= 47.670693488668)
						and 			(Long >= -117.392662186599)
						and				(Long <= -117.356626150563)	
						group by		gdschoolcode,GDDistrictID,schname,state,GradeLow,GradeHigh,schoolType,DistrictName,city,state,zip,lat,long,photocount
						order by		DistrictName,gradehigh,schname
					
get_areahost (Datasource=gd, Time=10 ms, Records=0) in /var/nfs/www/gdcore3/webcore/area/start.cfm
the following colum(s) are never read within the request:profile_phonefax,areauser_areaid,profile_lastname,profile_firstname,profile_phonedirect,profile_phone,profile_companyname,profile_phoneoffice,profile_mediaphotourl,profile_phonewireless,profile_medialogourl,areauser_userid,profile_email,profile_displayname
			select			areausers.userid as areauser_userid,
							areausers.areaid as areauser_areaid,
							profiles.firstname as profile_firstname,
							profiles.lastname as profile_lastname,
							profiles.name as profile_displayname,
							profiles.companyname as profile_companyname,
							profiles.phone as profile_phone,
							profiles.phonedirect as profile_phonedirect,
							profiles.phoneoffice as profile_phoneoffice,
							profiles.phonewireless as profile_phonewireless,
							profiles.phonefax as profile_phonefax,
							profiles.email as profile_email,
							profiles.mediaphotourl as profile_mediaphotourl,
							profiles.medialogourl as profile_medialogourl
			from			areausers
			inner join		users on areausers.userid = users.id
			inner join		profiles on users.profileid = profiles.id
			where			areausers.areaid = 6715
			and				(128&areausers.roles)=128
		
get_siteMLS (Datasource=gd, Time=4.88 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/instant.cfm
the following colum(s) are never read within the request:createdat,mlsstatusindexinventory,statusid,neighborhooddigest,updatedby,mlsstateindex,mapcentroid,mlsstatusindexclient,mlsopenhouses,mlsstatusindexpublic,label,listingidint,description,hasmlsopenhouses,listingidisint,deletedat,createdby,mapsw,mlsstatusindexcompany,updatedat,medialogourl,mlsstatusindex,hasneighborhooddigest,title,mlsstatusindexcma,mapne
		SELECT				*
		FROM					MLS
		WHERE				code in ('SARMLS')
	
get_areaSpatial (Datasource=gdspatial, Time=17.1 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/instant.cfm
the following colum(s) are never read within the request:gd_areaLabel,gd_dateCreated,gd_areaPolygon,gd_userCreated,gd_areaMLSId,deletedAt,gd_areaType,gd_areaId,gd_dateModified,gd_userModified,gd_reprocess,gd_areaDesc,gd_areaStatus,gd_areaTitle,gd_areaTag
		select			*
		from			gd_area
		inner join	gd_areaMLS on gd_area.gd_areaId = gd_areaMLS.gd_areaId
		where			gd_area.gd_areaId = 30146
		and				gd_areaMLS.gd_mlsId in (1018)
		-- and 			gd_areaShape is not NULL
	
get_areaMarket (Datasource=gd, Time=6.81 ms, Records=2) in /var/nfs/www/gdcore3/webcore/area/instant.cfm
		SELECT				DISTINCT(marketId)
		FROM					MarketAreas
		WHERE				areaId = 6715
	
get_market (Datasource=gd, Time=3.16 ms, Records=1) in /var/nfs/www/gdcore3/webcore/area/instant.cfm
the following colum(s) are never read within the request:templateid,userid,markettypeid,profileid,createdat,deletedat,statusid,createdby,tag,updatedby,code,updatedat,id,label,description
		SELECT				*
		FROM					Markets
		WHERE				id = 9
	
get_marketPage (Datasource=graphicaldata, Time=4 ms, Records=2) in /var/nfs/www/gdcore3/webcore/area/instant.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
		SELECT				*
		FROM					sitePage
		WHERE				siteId = 3341
		AND					pageType = 31
		AND					pageTypeKey = '9'
	
get_listings (Datasource=sarmls, Time=4400 ms, Records=26) in /var/nfs/www/gdcore3/mlscore/sarmls/qry_results.cfm
the following colum(s) are never read within the request:gdOpenHouseListingId,gdBlockKey,gdSquareFootageLot,gdOfficeSold,gd_blockCode,gdVirtualTourMLSURL,gdListingTitleCustom,gdhood,gdArea,gdOfficeCoList,gdMediaID,spatial_areashape,gdAgentSold,gdDateSold,gd_tractCode,gdStreetNumber,gdCounty,gdHoodNew,gdPublishRule2,gdParcel,gdLongitude,gdDatePending,spatial_arealabel,gdPublishRule3,gdLatitude,gdVirtualTour1Title,gdVirtualTour1URL,gdFIPS,gdStreetDirection,gdPublishRule1,gdVirtualTour2URL,gdVirtualTour3Title,gdVirtualTour3URL,gdAcreage,spatial_areaid,gdHits,gdVirtualTour2Title,gdPriceSold,gd_listingId,gdOfficeList,gdOfficeCoListDesc,gdPhotoID,gdStreetname
			  
  	SELECT
	
	top 1001
	
	*
	from gdSearchSpeed
	
	
		INNER JOIN 			[mls_sarmls].spatial_areas spars ON [spars].[spatial_areashape].STIntersects(geography::STGeomFromText('POINT(' + CAST([gdLongitude] as varchar) + ' ' + CAST([gdLatitude] as varchar)+ ')', 4269))=1

		AND					[spars].[spatial_areaid] = 30146
		
	
	
	
	








	

	
LEFT OUTER JOIN	(SELECT
DISTINCT gdListingId as gdOpenHouseListingId, 1 as gdHasOpenHouse 
FROM	gdOpenhouses
WHERE	


	gdOHStartDate >= CONVERT(CHAR(10),GETDATE(),110)
	AND	gdOHStartDate < CONVERT(CHAR(10), dateadd(d, 30, getDate()), 110)







		
	
		AND		gdOHIsMLSData = 0
	
	










AND		gdOHIsDisplay = 1
) as gdOH
ON	gdSearchSpeed.gdListingId = gdOH.gdOpenHouseListingId	




	
		
	
	
	where
	
	
	
	gdStatus in (1,2,10,18)
		
	
	
	
	
	
	
		
	
		
		
		
		
		
	
	
	
	
	
	
	
	
	
	
	
	
	
	

	
		

	
	
	
	
	
		

	
			
	
	
	
	
			
	
	
	
	
	
	and gdPropType in (1,2,3,5)
	
	
	
	
	
	
	
	
	
	
	
		
	
	and gdPublishRule2 = 0
	
	
	
	
	
	
	
	
	AND NOT gdOfficeList = 459
	
	
	
	
	
	
		
	
	order by gdPriceList desc, gdListingID
get_marketAreasForWidget (Datasource=gd, Time=7.45 ms, Records=30) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:longitude,areatypeid,profileid,transition_areakey,createdat,statusid,areaid,hostId,latitude,updatedby,profilestring,code,label,description,marketid,transition_schoolstring,templateid,userid,deletedat,createdby,siteId,tag,spatialareaid,searchstring,pageId,updatedat,transition_areastring,id,title
		select				a.title as area_title, a.id as area_id, *
		from				MarketAreas	ma
		inner join		Areas a on ma.areaId = a.id
		inner join		SiteMarkets sm on ma.marketId = sm.marketId
		where				sm.siteId = 3341
		and					sm.marketId = 9
		and					ma.statusId = 1
		and					a.statusId = 1
		order by			a.title
	
get_areaPage (Datasource=graphicaldata, Time=3.94 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6370'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.36 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6676'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.64 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6678'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.33 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6679'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.41 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6371'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.64 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6734'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=4.45 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6390'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.79 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6691'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=4.36 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6372'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.52 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6689'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.25 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6373'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.65 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6374'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.71 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6732'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.97 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6688'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.54 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6376'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.63 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6696'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.5 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6675'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.74 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6680'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.76 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6681'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.04 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6694'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.81 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6682'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.78 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6693'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.89 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6683'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=4.58 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6377'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.41 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6690'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=3.86 ms, Records=1) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6378'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.27 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6686'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.24 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6687'
						AND					pageKey <> ''
					
get_areaPage (Datasource=graphicaldata, Time=2.47 ms, Records=0) in /var/nfs/www/gdcore3/webcore/widget/market_areas.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
						SELECT				*
						FROM					sitePage
						WHERE				siteId = 3341
						AND					pageType = 15
						AND					pageTypeKey = '6695'
						AND					pageKey <> ''
					
get_sitePages (Datasource=graphicaldata, Time=0 ms, Records=26) in /var/nfs/www/gdcore3/webcore/site/build/nav/templates/nav_2.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageLock,pageMetaTitle,pageMetaKeywords,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,pageFooterHTML,pageDateModified,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType
		SELECT		*
		FROM		sitePage
		WHERE		siteId = 3341
		and			pageStatus = 1
		
		and			pageProtected = 0
		order		by pageOrder
	
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 109810
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=5) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageLock,pageMetaTitle,pageMetaKeywords,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 109846
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=4) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageLock,pageMetaTitle,pageMetaKeywords,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 112298
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 109850
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 109822
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=6) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageLock,pageMetaTitle,pageMetaKeywords,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageStatus,pageMetaDesc,pageHosted,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 109851
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 119008
	
	
	and			pageProtected = 0
	order		by pageOrder
get_drop_subs (Datasource=graphicaldata, Time=0 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/nav/inc/nav_content_menu_submenu.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	SELECT		*
	FROM		sitePage
	WHERE		siteId = 3341
	and			pageStatus = 1
	
	and 		pageParentId = 112437
	
	
	and			pageProtected = 0
	order		by pageOrder
get_siteAreas (Datasource=graphicaldata, Time=2.79 ms, Records=0) in /var/nfs/www/gdwebs/3341/gd/module/footer.cfm
the following colum(s) are never read within the request:siteClass,pageNavCount,pageUrl,pageSidebarType,pageNavType,pageProtected,pageSidebarHTML,pageHeaderImage,pageNavHTML,pageMarqueeHTML,pageDateCreated,pageOrder,pageMarqueeImage,pageHeaderHTML,pageTitle,pageType,pageLock,pageMetaTitle,pageMetaKeywords,pageParentId,pageTypeKey,pageTypeCode,pageTypeCSSClass,pageMarqueeType,siteId,pageFooterHTML,pageDateModified,pageId,pageStatus,pageMetaDesc,pageHosted,pageKey,pageFooterType,pageHeaderType,pageDefault
	select			*
	from			sitePage
	where			siteId = 3341
	and				pageType = 15
	and				pageStatus = 1
	order by 	pageTitle
get_hits (Datasource=graphicaldata, Time=3.69 ms, Records=1) in /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_pageview.cfm
		select	hitcounter
		from	hitCounter
		where	gdWebsiteDomainID = 4205
		and		dayofweek = '07/20/18'
	
hitscounter_update (Datasource=graphicaldata, Time=37 ms, Records=0) in /var/nfs/www/gdcore3/webcore/site/build/tracking/inc/tracking_pageview.cfm
			Update	HitCounter
			set		HitCounter = 3290
			where	gdWebsiteDomainID = 4205
			and		dayofweek = '07/20/18'
		


Scope Variables

Application Variables:
applicationname=windermerespokane.com
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=/var/nfs/www/gdwebs/3341/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
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=Keep-Alive
http_cookie=
http_host=windermerespokane.com
http_referer=
http_user_agent=CCBot/2.0 (http://commoncrawl.org/faq/)
https=
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=127.0.0.1
local_host=web02
path_info=/area/6715
path_translated=/var/nfs/www/gdwebs/3341/index.cfm
query_string=
remote_addr=0:0:0:0:0:0:0:1
remote_host=0:0:0:0:0:0:0:1
remote_user=
request_method=GET
request_url=http://windermerespokane.com/index.cfm/area/6715
script_name=/index.cfm
server_name=windermerespokane.com
server_port=80
server_port_secure=0
server_protocol=HTTP/1.1
server_software=
web_server_api=
Client Variables:
cfid=8f54c977-264c-4473-95bb-b787e46488ec
cftoken=0
context=
gdcore=gdcore3
hitcount=1
lag=LAGCRUTCH
lastvisit={ts '2018-07-20 15:19:12'}
roster_code=
roster_description=Windermere Real Estate/City Group, LLC | Windermere Real Estate/Cornerstone | Windermere Real Estate/Manito, LLC
Windermere Real Estate/North Spokane, LLC | Windermere Real Estate/Valley, Inc.
Windermere Real Estate/Liberty Lake roster_id=1 roster_label=Windermere Real Estate of Spokane, WA roster_mediaLogoUrl=roster.MEDIALOGOURL roster_rostertypeId=1 roster_title=Windermere Real Estate of Spokane, WA roster_token=p2rHuWgvZRRnE95e7fI73Ca1nug8l4r7 site_class=16 site_colorAccent=336699 site_colorAccentOver=FFFFFF site_colorPrimary=336699 site_colorPrimaryOver=FFFFFF site_colorSecondary=6699cc site_colorSecondaryOver=FFFFFF site_colorText=333333 site_domainId=4205 site_domainName=windermerespokane.com site_email=spokaneinfo@windermere.com site_focusBanner= site_focusKey=area site_focusSection=area-home site_focusValue=6715 site_heading=Spokane Real Estate :: Spokane Washington site_Id=3341 site_mediaLogoUrl=http://images.graphicaldata.com/logo_windermere.png site_metaTitle=Spokane Real Estate :: Spokane Washington site_mlsCode_list=SARMLS site_pageId_home=109810 site_pathFileExists=/var/nfs/www/gdwebs/3341 site_pathInclude=/ site_sidebarHTML= site_userId=5250 siteemail=spokaneinfo@windermere.com siteLeadRecipientContent= timecreated={ts '2018-07-20 15:19:12'} urltoken=CFID=8f54c977-264c-4473-95bb-b787e46488ec&CFTOKEN=0 user_groupId_list=1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1141,1142,1142,1142,1142,1142,1142,1142,1142,1142,1142,1142,1142,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1177,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1178,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1179,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180,1180
Cookie Variables:
cfid=8f54c977-264c-4473-95bb-b787e46488ec
cftoken=0
Form Variables:
context=
Request Variables:
magicalkey=area/6715
sesdummyextension=.cfm
sesrbasename=baseHREF
Server Variables:
coldfusion=Struct (9)
java=Struct (8)
os=Struct (7)
railo=Struct (7)
separator=Struct (3)
servlet=Struct (1)
Session Variables:
cfid=8f54c977-264c-4473-95bb-b787e46488ec
cftoken=0
lastvisit={ts '2018-07-20 15:19:18'}
sessionid=windermerespokane.com_8f54c977-264c-4473-95bb-b787e46488ec_0
timecreated={ts '2018-07-20 15:19:18'}
urltoken=CFID=8f54c977-264c-4473-95bb-b787e46488ec&CFTOKEN=0
URL Variables:
urlkeyarea=6715
Debug Rendering Time: 0.001 ms