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

By candace7

An expat talks about living in Paysandu, Uruguay. Topics covered include public vs. private hospitals, petty crime, applying to residency, nightlife and restaurants (pizza parlors are everywhere), golf clubs, international schools and much more. Continue Reading

Real Estate Listings in Uruguay

Add a Property Listing

House for Rent and for Sale

Punta del Este, Uruguay

4 Bedroom / 2 Full Bath / Half Bath

Furnished

Price: us $ 260.000

Living Space: 180 sq meters

House for Rent and for Sale in Punta del Este, Uruguay

Reduced Price!! Visit our sitepage:chihuahuarent.wordpress.com. This new modern home is located just 300mts from the beach on a 1020m2 lot , it has sea views from the first floor and roof terrace. Superb modern design respecting the surrounding landscape

View Full Listing

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-PiriapolisAn Expat Talks about Culture Shock & Living in Piriapolis, Uruguay

An American who retired to Uruguay talks about why he moved to Piriapolis. He offers incredible insight into culture shock, how the challenges of living in Uruguay gradually wore on him and what he appreciated about the culture in Uruguay.

An American who retired to Uruguay talks about why he moved to Piriapolis. He offers incredible insight into culture shock, how the challenges of living in Uruguay gradually wore on him and what he a...

Living-in-Punta-del-DiabloAn Expat Discusses Living in Punta del Diablo, Uruguay

Punta del Diablo is a picturesque fishing village about 2.5 hours up the coast of Uruguay from Punta del Este with a growing expat population. The local people are focused on family, most depend on the tourism industry and everyone loves of soccer. An expat offers an in-depth look at expat life in Punta del Diablo.

Punta del Diablo is a picturesque fishing village about 2.5 hours up the coast of Uruguay from Punta del Este with a growing expat population. The local people are focused on family, most depend on t...

Expats-Talk-About-The-Biggest-Challenges-They-Face-Living-in-Latin-AmericaExpats Talk About The Biggest Challenges They Face Living in Latin America

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint: you'll be much happier if you learn the language) and adjust your expectations (realities: the roads are rough, the pace of life is slower and bureaucracy is unavoidable). Despite all of the challenges, the list of what expats like about life in Latin America far exceeds the challenges.

Expats talk about some of the biggest challenges they've faced living in Latin America. Whether you're moving to Panama City or Punta del Este, this article is a must read to help you prepare (hint:...

Pros-and-Cons-of-Living-in-UruguayExpats in Uruguay: Pros and Cons of Living in Uruguay

Many expats who consider living in Uruguay have lived in other South American countries, and then they are exposed to stories of all that it has to offer.

Many expats who consider living in Uruguay have lived in other South American countries, and then they are exposed to stories of all that it has to offer....

11-Expats-Talk-About-What-Its-Really-Like-Living-in-Uruguay11 Expats Talk About What It's Really Like Living in Uruguay

Expats in Uruguay have often lived in other Central and South American countries before landing in Uruguay. They appreciate Uruguay's low-key lifestyle, beautiful beaches and family-focused Uruguayans. 11 expats talk about what it's really like living in Uruguay.
Expats in Uruguay have often lived in other Central and South American countries before landing in Uruguay. They appreciate Uruguay's low-key lifestyle, beautiful beaches and family-focused Uruguayan...

Uruguay 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 30-May-20 09:43 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.75
Host Name 173.245.54.75


Execution Time

Total Time Avg Time Count Template
291 ms 291 ms 1 /home/www/html/eetr/Application.cfm
249 ms 249 ms 1 top level /home/www/html/eetr/tips.cfm
99 ms 99 ms 1 /home/www/html/navtop_rdesign5.cfm
92 ms 92 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
56 ms 56 ms 1 /home/www/html/eetr/tipsrentalproperties_include.cfm
55 ms 55 ms 1 /home/www/html/eetr/tipsrentalproperties_includebox.cfm
44 ms 44 ms 1 /home/www/html/eetr/tipsrentalproperty.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
11 ms 6 ms 2 /home/www/html/eetr/rewritetipheadingstate.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.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 1 /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/rewritearticlefirsttitle.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 1 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 1 /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/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 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
541 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 @ 21:43:20.020
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 21:43:20.020
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=2) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
	Select *
	From citynetworks
	Where networkID = 115
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
getpropertycountries (Datasource=tipripper, Time=48ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
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=36ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
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 @ 21:43:20.020
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
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=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
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 = 115 
AND allreports.networkid = 115 
and allreports.tipcategoryid <> 2791

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

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

WHERE topicid = 9 
getcountryphoto (Datasource=expert, Time=1ms, Records=16) in /home/www/html/eetr/eetr_navmeta.cfm @ 21:43:20.020
SELECT *
FROM countryphotos
WHERE networkid = 115 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:43:20.020
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:43:20.020
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 21:43:20.020
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.75'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:43:20.020
	SELECT *
	From contentcountcountry
	Where networkid = 115 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 21:43:20.020
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:43:20.020
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=2ms, Records=116) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 115 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE allreports.topicid = 6
AND "2020-05-30" < 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 @ 21:43:20.020
	Select *
	From Networks
	Where networkid = 115 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT *
FROM users
WHERE userid = '45154'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8004'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
	SELECT summary 
	FROM answers
	WHERE answerid = 80334 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 21:43:20.020
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80334 
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:43:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 21:43:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 391
	
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
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=4ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 402
gettext401 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 401
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 391
checkexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
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-05-29 21:43:20'}
and expertusers.enddate > {ts '2020-05-30 21:43:20'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:20.020
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-05-30 21:43:20'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:20.020
SELECT username
FROM users
WHERE userid = 45154 
getauthorfirst (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/eetr/tipsrentalproperty.cfm @ 21:43:20.020
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:20.020
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:20.020
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:21.021
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:21.021
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
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 @ 21:43:21.021
SELECT *
FROM expertusers
WHERE userid = 45154
and startdate <{ts '2020-05-29 21:43:21'}
and enddate > {ts '2020-05-30 21:43:21'} 
getclass (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_include.cfm @ 21:43:21.021
SELECT *
FROM allreports, answers
WHERE allreports.topicid = 6
and allreports.networkid = 115
and allreports.hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-05-30" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')

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

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:43:21.021
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 115 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:43:21.021
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 33
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:43:21.021
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:43:21.021
SELECT  hiimg
FROM rptarticles
where rptarticleID = 33
and hiimg <> ''


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=115&s=1&sort=r&slug=Expats&slug2=Real-Estate-in-Uruguay
REMOTE_ADDR=173.245.54.75
REMOTE_HOST=173.245.54.75
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=28726440
cftoken=49978672
hitcount=1
lastvisit={ts '2020-05-30 21:43:20'}
timecreated={ts '2020-05-30 21:43:20'}
urltoken=CFID=28726440&CFTOKEN=49978672
Cookie Variables:
CFID=28726440
CFTOKEN=49978672
Session Variables:
cfid=28726440
cftoken=49978672
sessionid=IBEXPATEXCHANGE_28726440_49978672
urltoken=CFID=28726440&CFTOKEN=49978672
URL Parameters:
networkid=115
s=1
slug=Expats
slug2=Real-Estate-in-Uruguay
sort=r
tipcategoryid=2831
topicid=9
Debug Rendering Time: 11 ms