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

Expat Guide to Living in Uruguay

Whether you're already living in Uruguay or preparing to move to Uruguay, our Expat Guide to Living in Uruguay offers articles and reports submitted by expats about expat life in Uruguay. For answers to specific questions, visit our Uruguay Forum to talk with expats in Uruguay.

Expats 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 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.

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 Uruguayans. 11 expats talk about what it's really like living in Uruguay.

5 Important Tips about Healthcare for Expats in Uruguay

Expats in Uruguay have a variety of healthcare options available to them. Understanding what is available is an important part of preparing to move there. Information about proximity of care and prescription medications in Uruguay is also provided.

Expats in Uruguay: 8 Tips For Living in Punta del Este

Expats in Punta del Este live in a beautiful coastal setting that will leave you wondering why more people don't consider this new hot spot when they scan the globe for their next expat adventure.

12 Tips for Living in Paysandu, Uruguay

12 Tips for Living in Paysandu, Uruguay

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.

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Punta del Diablo

An expat in Punta del Diablo, Uruguay discusses the quality of healthcare in Punta del Diablo, the availability of prescription medicines and health insurance.

Moving to Punta Del Este, Uruguay

An expat in Uruguay talks about moving to the beautiful resort town of Punta Del Este. She talks about housing prices, what to bring and leave behind and more.

Culture Shock 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.

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.

Dream vs Reality of Living in Valdense, Uruguay

After six months of trying to buck the bureaucracy of Argentina, one expat talks about his move to Uruguay and the ease of living there. With its lower cost of living, benefits for seniors, friendly locals and local organic meat and produce, he's enjoying life in Uruguay.

More Culture Shock Reports for Uruguay

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Uruguay handle it can be very comforting. Below are some of the responses from expats in Uruguay:
Submit a Culture Shock Report

More Living in Uruguay Reports

What are people's priorities in Uruguay - work? family? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Uruguay:
Submit a Living Overseas Report

More Moving to Uruguay Reports

What should you take with you when you move to Uruguay? What should you leave behind? What type of housing and neighborhoods are typical for expats in Uruguay? Below are some of the responses from expats in Uruguay:
Submit a Moving Overseas Report

Reviews of Schools in Uruguay

Reviews and school profiles from expat parents and even a few school administrators in Uruguay. Great place to find insight into school facilities, teachers and curriculum. Below are some of the reviews from expats in Uruguay:
Submit an International School Review

Dream vs. Reality of Living in Uruguay Reports

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Uruguay. If you are already living in Uruguay, share how those "dreams" have been fulfilled, and how they have not. Below are some of the reports from expats in Uruguay:
Submit a Dream vs. Reality Report

Overseas Retirement Report

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in Uruguay by taking our Overseas Retirement report.

Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Uruguay? Help other expats who are preparing to have a baby in Uruguay by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Uruguay? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Uruguay? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Additional Articles
Moving to Uruguay: 7 Things to Know Before Moving to Uruguay

Expats who move to Uruguay offer a lot of advice about moving there. There are several aspects of living in Uruguay that need to be taken into consideration: health care, cost of living, transportation and types of housing are just a few of the areas to investigate. Going to Uruguay to visit first is critical!

Expat Uruguay: 7 Best Places to Live in Uruguay

Expats in Uruguay agree that the best thing about living in Uruguay is the friendly people. In addition to the friendly locals, the weather, beautiful beaches and stable economy make it a great place to live. We've compiled a list of the 7 best places to live in Uruguay based upon expats' recommendations.

5 Great Places to Retire in South America

Expats offered their recommendations for places to retire in South America. We know that this is a short list and hope you'll add your favorites below in the comments section.

10 Tips for Living in Uruguay

Uruguay may not be the most popular expat destination, but expats there are probably hoping that the truth about Uruguay's healthy lifestyle, family-oriented culture and beautiful beaches doesn't get out.

Living in Uruguay: How Don and His 9-Year-Old Grandson are Retiring Overseas

Live and Invest Overseas Correspondent, Don Peterson, describes the journey that he and his grandson took to find their beloved Mercedes, Uruguay.

The Most Sought After Document in South America

Charles Barrett offers some helpful tips to ensure that you minimize risk associated with a lost or stolen passport.

World's Top Retirement Havens 1 Through 9

Where are the best places to retire overseas? Which retirement haven is right for you? France? Ecuador? Panama? Nicaragua? Thailand? Kathleen Peddicord shares the pros and cons of the world's top 9 retirement havens.

4 Months Later: Reflections on Living in Uruguay

Chrystal and Brian Johnson share their views of Uruguay after their first four months living in Uruguay.

Ten Things You Should Know Before You Move To Central or South America

Lee offers ten tips for people contemplating a move to Central or South America.

Moving to Punte del Este, Uruguay

Punta del Este offers a great lifestyle to expats - fresh food, beautiful beaches, welcoming people and luxuries that the average expat could not afford in at home.

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...

10-Tips-for-Living-in-Uruguay10 Tips for Living in Uruguay

Uruguay may not be the most popular expat destination, but expats there are probably hoping that the truth about Uruguay's healthy lifestyle, family-oriented culture and beautiful beaches doesn't get out.

Uruguay may not be the most popular expat destination, but expats there are probably hoping that the truth about Uruguay's healthy lifestyle, family-oriented culture and beautiful beaches doesn't get ...

5-Great-Places-to-Retire-in-South-America5 Great Places to Retire in South America

Expats offered their recommendations for places to retire in South America. We know that this is a short list and hope you'll add your favorites below in the comments section.

Expats offered their recommendations for places to retire in South America. We know that this is a short list and hope you'll add your favorites below in the comments section....

7-Best-Places-to-Live-in-UruguayExpat Uruguay: 7 Best Places to Live in Uruguay

Expats in Uruguay agree that the best thing about living in Uruguay is the friendly people. In addition to the friendly locals, the weather, beautiful beaches and stable economy make it a great place to live. We've compiled a list of the 7 best places to live in Uruguay based upon expats' recommendations.

Expats in Uruguay agree that the best thing about living in Uruguay is the friendly people. In addition to the friendly locals, the weather, beautiful beaches and stable economy make it a great place...

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 /expatguide.cfm
Time Stamp 03-Jun-20 03:18 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.151
Host Name 173.245.54.151


Execution Time

Total Time Avg Time Count Template
291 ms 291 ms 1 /home/www/html/expatguide.cfm
32 ms 32 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
30 ms 30 ms 1 /home/www/html/navcontentbox.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 2 /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/rewriterealtorlink.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 17 /home/www/html/rewritearticle.cfm
0 ms 0 ms 17 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 17 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 17 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
298 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 03:18:05.005
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 03:18:05.005
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
getcities (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select *
	From citynetworks
	Where networkID = 115
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select *
	From Networks
	Where networkID = 115 
getphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 115
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 03:18:05.005
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 115 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 03:18:05.005
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 03:18:05.005
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-03 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 @ 03:18:05.005
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 03:18:05.005
	SELECT *
	From contentcountcountry
	Where networkid = 115 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 03:18:05.005
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 03:18:05.005
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 03:18:05.005
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=5ms, Records=14) in /home/www/html/expatguide.cfm @ 03:18:05.005
	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 publishdate < "2020-06-03"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Uruguay' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 115 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 115 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 115 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 115 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 115 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 115 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 115 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 115 
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 115 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 115 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
      
         and rptarticlenetworks.networkid = 115 
checklivingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 115 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 115 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 115 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 115 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=6ms, Records=4) in /home/www/html/expatguide.cfm @ 03:18:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 115 
   	 order by city, date DESC
         
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 03:18:05.005
	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 @ 03:18:05.005
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
getlivingphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT  hpimg
FROM rptarticles
where rptarticleID = 33
and hpimg <> ''
getrealestateadvice (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80334
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80334 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80334
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80334
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80334'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:05.005
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80334'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 45154
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80334 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT *
	FROM markers
	WHERE answerid = '80334'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 03:18:06.006
SELECT *
FROM expertusers
WHERE userid = 45154
and startdate <{ts '2020-06-02 03:18:06'}
and enddate > {ts '2020-06-03 03:18:06'} 
getrestaurants (Datasource=tipripper, Time=11ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=5) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=5) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=4ms, Records=5) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 78009
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 78009 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 78009
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 78009
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT summary
	FROM answers
	WHERE answers.answerid = '78009'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '78009'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 156708
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 156708
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 156708
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 156708
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 156708
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 78009 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 03:18:06.006
	SELECT *
	FROM markers
	WHERE answerid = '78009'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74372 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21738 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75805 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26371 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 73073 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 27054 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 31387 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 03:18:06.006
	Select *
	From Networks
	Where networkID = 115 
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 46462
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 43648
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27340
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 03:18:06.006
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 27337
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=9ms, Records=1) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
		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=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
		Select summary, hiimg 
		FROM answers
         where answerid = 75805
         and summary <> ''
checklivingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
		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=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
		Select summary, hiimg 
		FROM answers
         where answerid = 73073
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
	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-06-03"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 03:18:06.006
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 115 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 03:18:06.006
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 33
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 03:18:06.006
	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 @ 03:18:06.006
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/expatguide.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/expatguide.cfm
QUERY_STRING=networkID=115
REMOTE_ADDR=173.245.54.151
REMOTE_HOST=173.245.54.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=28918009
cftoken=15329382
sessionid=IBEXPATEXCHANGE.COM_28918009_15329382
urltoken=CFID=28918009&CFTOKEN=15329382
URL Parameters:
networkID=115
Debug Rendering Time: 11 ms