Uruguay
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Moving to Uruguay > Punta Del Este >

An Expat Talks about Moving to Punta Del Este, Uruguay

Sep 05, 2017


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.

What is the name of the city or town that you are reporting on?

Punta Del Este

Name three things that you wish you had brought and three you wish you had left at home.

3 Things I Wish I Had Brought:

1) Reverse osmosis system

2) Supplements

3) Patio furniture

3 Things I Wished I Had Left At Home:

1) Some of our artwork (no good place to store)

2) Kitchen gadgets

3) Bulky items

Moving to Uruguay

Moving to Uruguay soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

What advice would you give someone preparing to move to your area about the actual move, choosing a neighborhood and finding a home?

Research, research, research. Try to find competent people. Find out other people's experiences. Join expat forums for Uruguay to solicit information. Visit as many places as possible to get a feel for the neighborhoods & options available.

What type of housing do you live in? Is this typical for most expats in your area?

House Yes. Most expats live in houses, condos or apartments.

How did you choose your neighborhood and find your home or apartment?

Looked for an area with natural beauty, reasonable taxes, and slightly off the beaten path.....

Expats living in Uruguay interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA. Get a Quote

Expats living in Uruguay interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Are your housing costs higher or lower than they were in your home country? What is the average cost of housing there?

Lower than the taxes where I lived in the States. Average cost of housing in Punta Del Este of interest to expats is $200-450k.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Punta Del Este

Guide to Living in Punta Del Este

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

Healthcare in Uruguay

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

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Punta del Este

An expat living in the Maldonado / Punta del Este area of Uruguay recommends enrolling in a hospital mutualista. Because he has had some medical issues and is a diabetic, he does not qualify and self insures through an ambulance service. He also discusses prescription medicines, lower medical costs and the quality of health care in Punta del Este.

Join our Uruguay Expat Forum

Visit our Uruguay Forum and talk with other expats who can offer you insight and tips about living in Punta Del Este, Uruguay.

More about Uruguay

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.

7-Things-to-Know-Before-Moving-to-UruguayMoving 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!

5-Important-Tips-about-Healthcare-for-Expats-in-Uruguay5 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.

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.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in Punta Del EsteGuide to 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.

Healthcare in UruguayHealthcare 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.

Restaurants in Punta Del EsteRestaurants in Punta Del Este

Support your favorite restaurants in Punta Del Este as they recover from the pandemic. Submit a free listing for them on Expat Exchange to help spread the word about them to the expat community.

Expat Healthcare & Health InsuranceExpat Healthcare & Health Insurance in Punta del Este

An expat living in the Maldonado / Punta del Este area of Uruguay recommends enrolling in a hospital mutualista. Because he has had some medical issues and is a diabetic, he does not qualify and self insures through an ambulance service. He also discusses prescription medicines, lower medical costs and the quality of health care in Punta del Este.

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.

7-Things-to-Know-Before-Moving-to-UruguayMoving 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!

5-Important-Tips-about-Healthcare-for-Expats-in-Uruguay5 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.

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.

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 /rspnet.cfm
Time Stamp 15-Aug-20 12:40 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 108.162.219.74
Host Name 108.162.219.74


Execution Time

Total Time Avg Time Count Template
115 ms 115 ms 1 top level /home/www/html/rspnet.cfm
44 ms 44 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
30 ms 30 ms 1 /home/www/html/navcontentboxcitypc.cfm
30 ms 30 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
30 ms 30 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/navbottomad_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb_ctygd.cfm
1 ms 1 ms 2 /home/www/html/eetr/rewritetipheading.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/constants.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 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 8 /home/www/html/rewritearticle.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
122 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 @ 12:40:18.018
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 12:40:18.018
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 12:40:18.018
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 63
AND networkid = 115 
AND 74372 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 12:40:18.018
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 74372
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=6) in /home/www/html/rspnet.cfm @ 12:40:18.018
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 74372 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 74372 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 12:40:18.018
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 74372 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 12:40:18.018
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 12:40:18.018
	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 @ 12:40:18.018
	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 @ 12:40:18.018
  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
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 12:40:18.018
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 74372 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:40:18.018
SELECT *
FROM tracking
WHERE ipaddress = '108.162.219.74'
and logtime > "2020-05-16"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 12:40:18.018
SELECT *
FROM tracking
WHERE ipaddress = '108.162.219.74'
and logtime > "2020-08-15 00:00:00.000"
and logtime < "2020-08-15 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 @ 12:40:18.018
SELECT *
FROM tracking
WHERE ipaddress = '108.162.219.74'
and logtime > "2020-08-08"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:40:18.018
	SELECT *
	From contentcountcountry
	Where networkid = 115 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 12:40:18.018
	SELECT *
	From contentcountcity
	Where citynetworkid = 5085 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:40:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-08-14"
    and fromDate < "2020-08-15"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 12:40:18.018
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-08-14"
    and fromDate < "2020-08-15"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 12:40:18.018
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=0ms, Records=103) in /home/www/html/breadcrumb_ctygd.cfm @ 12:40:18.018
SELECT *
FROM articleCategories
 
WHERE section = 1
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 12:40:18.018
		Select *
		FROM allreports, citynetworks
         where answerid = 74372
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getphotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 12:40:18.018
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 74372 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
	Select *
	From Networks
	Where networkid = 115 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 115
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-08-14"
and headerparagraphstart < "2020-08-15"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
	Select *
	From Networks
	Where networkid = 115 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 12:40:18.018
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 115
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-08-14"
and natsentencestart < "2020-08-15"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 5085
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-08-15" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 5085
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 115 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 115 
         and allreports.answerid <> 74372 
          and citynetworkid = 5085
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21738 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
 and allreports.citynetworkid2 =  5085
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
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=6ms, Records=5) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
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 = 78355
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 78355 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	SELECT summary
	FROM answers
	WHERE answers.answerid = '78355'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '78355'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 78355 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 12:40:18.018
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 12:40:19.019
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-08-15"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 12:40:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-08-14"
    and fromDate < "2020-08-15"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 12:40:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-08-14"
    and fromDate < "2020-08-15"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 12:40:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 12:40:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-08-14 12:40:19'}
    and fromDate <{ts '2020-08-15 12:40:19'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 12:40:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 12:40:19.019
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 74372 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 5085
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 115 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 74372         
         and networkid = 115
          and citynetworkid = 5085
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 21738 
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 115
and allreports.networkid = 115
 and allreports.citynetworkid2 =  5085
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
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/navcontentboxcitypc.cfm @ 12:40:19.019
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 = 78355
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 78355 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
	SELECT summary
	FROM answers
	WHERE answers.answerid = '78355'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '78355'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 78355 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 12:40:19.019
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '115'


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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=63&answerid=74372&networkid=115&start=74372
REMOTE_ADDR=108.162.219.74
REMOTE_HOST=108.162.219.74
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=34012372
cftoken=69633196
sessionid=IBEXPATEXCHANGE.COM_34012372_69633196
urltoken=CFID=34012372&CFTOKEN=69633196
URL Parameters:
answerid=74372
networkid=115
rid=63
start=74372
Debug Rendering Time: 12 ms