Home UK Forum UK Guide Moving to UK Real Estate Healthcare in UK
UK
Resources
City Guides
JoinSign In
Cigna International Health Insurance

International Real Estate Advice

Real Estate Listings Property Advice Local Experts My Properties

Real Estate professionals and expats in UK offer advice about renting and buying homes in cities and towns in UK. Topics covered include the rental and buying process in UK, popular areas, documents needed, budgets, rental and purchase agreements, precautions foreigners should take and more.

Sort Listings By: Newest | City

12 Tips for Living in Sheffield, UK

By vionaloos

An expat talks about living in Sheffield in South Yorkshire, England. Many people move to Sheffield for job opportunities. Sheffield has quality healthcare facilities, low crime and good schools. Continue Reading

Tips for Renting Property in Sheffield, UK

By vionaloos

An expat in Sheffield, England answers questions about renting a property in Sheffield - from hard-to-find, pet-friendly rentals to taking pictures of any items in need of repair before you move in. Continue Reading

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in UK from our partner, Cigna Global Health.
Get a Quote

10-Expats-Talk-about-What-Its-Like-Moving-to-the-UK10 Expats Talk about What It's Like Moving to the UK

Expats talk about what it was like moving to the UK. Topics covered include meeting people, NHS, culture shock and more.
Expats talk about what it was like moving to the UK. Topics covered include meeting people, NHS, culture shock and more....

Living-in-LondonCost of Living in London

The cost of living in London routinely ranks among the highest in the world. Here is some basic information about the realities of living in London and what you'll need to consider when deciding whether or not to move there.

The cost of living in London routinely ranks among the highest in the world. Here is some basic information about the realities of living in London and what you'll need to consider when deciding whet...

Expats-in-LondonLiving in London

If you're a global nomad in London or living in London, expats there have a lot to share to newcomers. Here are 11 things to know about living in London.

If you're a global nomad in London or living in London, expats there have a lot to share to newcomers. Here are 11 things to know about living in London....

Moving-To-SheffieldAn Expat Talks about Moving to Sheffield, UK

An expat in discusses renting a home in Sheffield, England. The red tape involved in finding a rental can be challenging (i.e. a 3 year history of utility bills) coupled with the high cost of housing.

An expat in discusses renting a home in Sheffield, England. The red tape involved in finding a rental can be challenging (i.e. a 3 year history of utility bills) coupled with the high cost of housing...

UK Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /eetr/tips.cfm
Time Stamp 07-Jun-20 12:31 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
330 ms 330 ms 1 /home/www/html/eetr/tips.cfm
309 ms 309 ms 1 /home/www/html/eetr/Application.cfm
134 ms 67 ms 2 /home/www/html/eetr/tipsrentalproperty.cfm
124 ms 124 ms 1 /home/www/html/navtop_rdesign5.cfm
110 ms 110 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
32 ms 32 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navcontentbox.cfm
31 ms 31 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 7 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
7 ms 7 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
1 ms 1 ms 2 /home/www/html/eetr/rewriterealtorlink.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/eetr/tipsrentalproperties_include.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 1 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
639 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 00:31:11.011
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=303ms, Records=1) in /home/www/html/eetr/Application.cfm @ 00:31:11.011
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:11.011
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:11.011
	Select *
	From citynetworks
	Where networkID = 1
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:11.011
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 1 
getpropertycountries (Datasource=tipripper, Time=58ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=40ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
getcategoryinfo (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate
FROM topics

WHERE topicid = 9 
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 1 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, sitecategories.categoryslug, sitecategories.headingnav, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, sitecategories, Networks
WHERE allreports.rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and hide <> 'y'
and sitecategories.siteid = 3
and allreports.tipcategoryid <> 2797

and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)

AND Networks.networkid = 1 
AND allreports.networkid = 1 
and allreports.tipcategoryid <> 2791

order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT *
FROM topics

WHERE topicid = 9
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT *
FROM topics

WHERE topicid = 9 
getcountryphoto (Datasource=expert, Time=1ms, Records=34) in /home/www/html/eetr/eetr_navmeta.cfm @ 00:31:12.012
SELECT *
FROM countryphotos
WHERE networkid = 1 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:31:12.012
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-03-08"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 00:31:12.012
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-06-07 00:00:00.000"
and logtime < "2020-06-07 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 00:31:12.012
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-31"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 00:31:12.012
	SELECT *
	From contentcountcountry
	Where networkid = 1 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 00:31:12.012
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-06"
    and fromDate < "2020-06-07"
UpdatePageViews (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 00:31:12.012
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=1ms, Records=35) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 1 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE allreports.topicid = 6
AND "2020-06-07" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 00:31:12.012
	Select *
	From Networks
	Where networkid = 1 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT *
FROM users
WHERE userid = '121181'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '1'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '1'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '7294'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
	SELECT summary 
	FROM answers
	WHERE answerid = 79611 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79611 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79611'
	and qid = 391
	
getheading (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79611'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 11 
gettext402 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79611'
	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79611'
	and qid = 401
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79611'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-06-06 00:31:12'}
and expertusers.enddate > {ts '2020-06-07 00:31:12'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-06-07 00:31:12'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT username
FROM users
WHERE userid = 121181 
getauthorfirst (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 00:31:12.012
SELECT *
FROM expertusers
WHERE userid = 121181
and startdate <{ts '2020-06-06 00:31:12'}
and enddate > {ts '2020-06-07 00:31:12'} 
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT *
FROM users
WHERE userid = '121181'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '1'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '1'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '7294'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
	SELECT summary 
	FROM answers
	WHERE answerid = 79674 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 00:31:12.012
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79674 
getheading (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79674'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79674'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate, topics.articletitle
FROM topics

WHERE topicid = 9 
gettext402 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79674'
	and qid = 402
gettext401 (Datasource=tipripper, Time=5ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79674'
	and qid = 401
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79674'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-06-06 00:31:12'}
and expertusers.enddate > {ts '2020-06-07 00:31:12'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-06-07 00:31:12'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT username
FROM users
WHERE userid = 121181 
getauthorfirst (Datasource=tipripper, Time=10ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 00:31:12.012
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 121181
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 00:31:12.012
SELECT *
FROM expertusers
WHERE userid = 121181
and startdate <{ts '2020-06-06 00:31:12'}
and enddate > {ts '2020-06-07 00:31:12'} 
getclass (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperties_include.cfm @ 00:31:12.012
SELECT *
FROM allreports, answers
WHERE allreports.topicid = 6
and allreports.networkid = 1
and allreports.hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-06-07" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')

order by allreports.answerid DESC
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-07"
     
         and rptarticlenetworks.networkid = 1 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 00:31:12.012
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 35
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 00:31:12.012
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 1 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
SELECT  hiimg
FROM rptarticles
where rptarticleID = 35
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=8ms, Records=2) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 1 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-07"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 1 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 1 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 00:31:12.012
		Select summary, hiimg 
		FROM answers
         where answerid = 75199
         and summary <> ''


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=/home/www/html/eetr/tips.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
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=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/eetr/tips.cfm
QUERY_STRING=topicid=9&tipcategoryid=2831&networkid=1&s=1&sort=r&slug=Expats&slug2=Real-Estate-in-Uk
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=29129800
cftoken=27585981
hitcount=1
lastvisit={ts '2020-06-07 00:31:11'}
timecreated={ts '2020-06-07 00:31:11'}
urltoken=CFID=29129800&CFTOKEN=27585981
Cookie Variables:
CFID=29129800
CFTOKEN=27585981
Session Variables:
cfid=29129800
cftoken=27585981
sessionid=IBEXPATEXCHANGE_29129800_27585981
urltoken=CFID=29129800&CFTOKEN=27585981
URL Parameters:
networkid=1
s=1
slug=Expats
slug2=Real-Estate-in-Uk
sort=r
tipcategoryid=2831
topicid=9
Debug Rendering Time: 12 ms