Home Canada Forum Canada Guide Moving to Canada Real Estate Healthcare in Canada
Canada
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 Canada offer advice about renting and buying homes in cities and towns in Canada. Topics covered include the rental and buying process in Canada, 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 Montreal, Canada

By adminee

Montreal boasts a rich cultural heritage, numerous employers and food that rivals many of the great cities in the world. Here are several things to know before taking the plunge and moving there, whether you're trying to bolster your career path or looking for unique retirement options. Continue Reading

12 Tips for Living in Quebec City, Canada

By adminee

An overview of Quebec City - from English-speaking schools, meeting other expats, public healthcare, cost of living in Quebec City and much more. Continue Reading

Real Estate Listings in Canada

Add a Property Listing

Land for Sale

Lake Huron, Canada

Bedroom / Full Bath / Half Bath

Does Not Apply to This Listing

Price: $299,000 or best offer

Living Space: 1.4 acre lot surrounded by 18,000 acres of LaCloche provincial park

Land for Sale in Lake Huron, Canada

1.4 acre building lot with sandy beach, pebbles, rocky point, surrounded by 18,000 acres of LaCloche provincial park and fronting 295' on North Channel of Lake Huron, in Ontario, Canada ...

View Full Listing

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Halifax,-Nova-ScotiaAn Expat Talks about Culture Shock & Living in Halifax, Nova Scotia, Canada

An expat in Halifax, Nova Scotia enjoys that locals plan small gatherings where you can really get to know people. She talks about the high tax rate, inability to save money while living in Halifax and more.

An expat in Halifax, Nova Scotia enjoys that locals plan small gatherings where you can really get to know people. She talks about the high tax rate, inability to save money while living in Halifax a...

Top-10-Tech-Cities-For-Expats-in-North-America-and-EuropeTop 10 Tech Cities For Expats in North America and Europe

Expats looking for tech jobs often are willing to move any where in the world for the right position. Here are some of the hottest tech cities in Europe and North America for expats to consider.

Expats looking for tech jobs often are willing to move any where in the world for the right position. Here are some of the hottest tech cities in Europe and North America for expats to consider....

5-Tips-For-Expat-Tech-Jobs-in-Canada5 Tips For Expat Tech Jobs in Canada

Canada's technology sector has expats all over the world looking there for career opportunities that are available to those who meet the proper criteria. The Canadian government has created a program to help expats make it happen, and thousands are every year.

Canada's technology sector has expats all over the world looking there for career opportunities that are available to those who meet the proper criteria. The Canadian government has created a program...

Canada 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 06-Jun-20 01:27 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.68
Host Name 162.158.78.68


Execution Time

Total Time Avg Time Count Template
401 ms 401 ms 1 /home/www/html/eetr/tips.cfm
291 ms 291 ms 1 /home/www/html/eetr/Application.cfm
200 ms 100 ms 2 /home/www/html/eetr/tipsrentalproperty.cfm
94 ms 94 ms 1 /home/www/html/navtop_rdesign5.cfm
88 ms 88 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
51 ms 51 ms 1 /home/www/html/eetr/tipsrentalproperties_include.cfm
50 ms 50 ms 1 /home/www/html/eetr/tipsrentalproperties_includebox.cfm
26 ms 26 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
17 ms 4 ms 4 /home/www/html/eetr/rewritetipheadingstate.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 2 /home/www/html/eetr/rewriterealtorlink.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.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/constants.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 1 /home/www/html/eetr/qry_GeneralSet.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/tippaginglinkmaker.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.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/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
692 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 @ 01:27:18.018
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 01:27:18.018
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
	Select *
	From citynetworks
	Where networkID = 28
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 28 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
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=34ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
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=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
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 @ 01:27:18.018
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 28 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
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 = 28 
AND allreports.networkid = 28 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 9 
getcountryphoto (Datasource=expert, Time=1ms, Records=18) in /home/www/html/eetr/eetr_navmeta.cfm @ 01:27:18.018
SELECT *
FROM countryphotos
WHERE networkid = 28 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:27:18.018
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:27:18.018
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-06 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:27:18.018
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:27:18.018
	SELECT *
	From contentcountcountry
	Where networkid = 28 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 01:27:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:27:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getcount (Datasource=tipripper, Time=1ms, Records=33) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 28 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE allreports.topicid = 6
AND "2020-06-06" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 01:27:18.018
	Select *
	From Networks
	Where networkid = 28 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT *
FROM users
WHERE userid = '1'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4457'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
	SELECT summary 
	FROM answers
	WHERE answerid = 79973 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79973 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79973'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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-05 01:27:18'}
and expertusers.enddate > {ts '2020-06-06 01:27:18'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
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=56ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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-06 01:27:18'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
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 @ 01:27:18.018
SELECT username
FROM users
WHERE userid = 1 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
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 @ 01:27:18.018
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
checkstatus (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 01:27:18.018
SELECT *
FROM expertusers
WHERE userid = 1
and startdate <{ts '2020-06-05 01:27:18'}
and enddate > {ts '2020-06-06 01:27:18'} 
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT *
FROM users
WHERE userid = '1'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8016'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
	SELECT summary 
	FROM answers
	WHERE answerid = 79982 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 01:27:18.018
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 79982 
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 402
gettext401 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 401
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79982'
	and qid = 391
checkexpert (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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-05 01:27:18'}
and expertusers.enddate > {ts '2020-06-06 01:27:18'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
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=60ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
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-06 01:27:18'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 1
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 @ 01:27:18.018
SELECT username
FROM users
WHERE userid = 1 
getauthorfirst (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
and answers.reviewed = 'y'
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 1
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 @ 01:27:18.018
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 1
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 @ 01:27:18.018
SELECT *
FROM expertusers
WHERE userid = 1
and startdate <{ts '2020-06-05 01:27:18'}
and enddate > {ts '2020-06-06 01:27:18'} 
getclass (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_include.cfm @ 01:27:18.018
SELECT *
FROM allreports, answers
WHERE allreports.topicid = 6
and allreports.networkid = 28
and allreports.hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-06-06" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')

order by allreports.answerid DESC
getprice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '68604'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '68604'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '68604'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '68604'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '68604'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '68604'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '68604'
AND answersmc.qoid = qoptions.qoid
getnetworkid (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
	SELECT DISTINCT *
	FROM allreports
	WHERE answerid = '68604'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includebox.cfm @ 01:27:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '28'
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 01:27:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 28 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:27:18.018
		Select summary, hiimg 
		FROM answers
         where answerid = 73841
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 01:27:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 28 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentbox.cfm @ 01:27:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 28 
	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-06"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 01:27:18.018
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-06"
     
         and rptarticlenetworks.networkid = 28 
    ORDER by rptarticles.rptarticleID desc
    


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=
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=28&s=1&sort=r&slug=Expats&slug2=Real-Estate-in-Canada
REMOTE_ADDR=162.158.78.68
REMOTE_HOST=162.158.78.68
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=29078935
cftoken=46669313
hitcount=1
lastvisit={ts '2020-06-06 01:27:18'}
timecreated={ts '2020-06-06 01:27:18'}
urltoken=CFID=29078935&CFTOKEN=46669313
Cookie Variables:
CFID=29078935
CFTOKEN=46669313
Session Variables:
cfid=29078935
cftoken=46669313
sessionid=IBEXPATEXCHANGE_29078935_46669313
urltoken=CFID=29078935&CFTOKEN=46669313
URL Parameters:
networkid=28
s=1
slug=Expats
slug2=Real-Estate-in-Canada
sort=r
tipcategoryid=2831
topicid=9
Debug Rendering Time: 10 ms