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

Uruguay Expat Forum

Exploring Relocation Trip

Post New Topic
Emanuela
5/7/2019 15:43 EST

Hello,
My family will travel to Uruguay to explore the option to relocate from the US. We are planning about two weeks trip in August with the objective to get the feel of the country, people, environment, and eventually pick a home to settle. We would love to live on a chacra.
We have a five year old and would like very much for him to be able to play/socialize with other children, even attend local Uruguayan school. Spanish language is not an issue with us.
We would also like to be near to a English speaking community in Uruguay.
So, we would much appreciate your advise on which town/areas to visit/stay and eventually settle there.
Also, do you any recommendations for a local real estate agent. Thanks

Post a Reply

00abuse

83xlx
5/8/2019 08:20 EST

We are picking up the keys to our chacra tomorrow. We picked a spot between La Barra and San Carlos. 20 min to beach and shopping but mostly outside the insanity of high season.

We used the services of Martina van Bevern (www.van-bevern.com). I cannot recommend her highly enough. She speaks German, Spanish and English. fluently. She also has a young son and would have some insight into schools. She knows everyone, at least in the Punta del Este area and was an invaluable help in getting functional here.

We let her know what we wanted and she showed us several nice chacras.

Post a Reply

10abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

mypinares
5/8/2019 09:35 EST

congratulations on your deal. Hope you will be happy in your new home. Another very reliable real estate agent in Punta del Este is Margret with 14 years experience in the property business is www.uruguayproperty.com. She is fluent in German,English and Spanish and is a fountain of knowledge.

Post a Reply

00abuse

Emanuela
5/8/2019 12:12 EST

Thanks so much for your encouraging information. Yes, we have seen the inventory of Martina van Bevern online and it is good to hear positive comments of her services.
Congratulations on your new home!

How is the weather now there as you enter winter? We'v heard about constant winds - how bad it is outside Punta del Este/San Carlos, etc?

Post a Reply

00abuse

Vortice
5/8/2019 15:49 EST

We are in the Sierra de Las Ánimas, about 25 km West of San Carlos and 25km from Piriápolis (the coast). Yes, it has been windy lately as a much needed rainstorm blew through (4-7/8" in our rain gauge :-). Local, up to date weather radar info is not available, but the frogs had been very quiet during the weeks of no rain, until 2 days before the storm. They became very loud and we were confident rain would follow. We have real weather here: in 1/2 hr we got 1" of rain and the electrical storm was prodigious.
Uruguay is flat, much of surrounding Argentina is flat not to mention the Atlantic Ocean; there isn't much to slow winds or storms. This makes for fast changing and somewhat unpredictable weather. Keep the wind in mind when you look at chacras. The previous owner of ours cut down 200 of the wind block trees so as to improve the views, but now there is an open North-South corridor to channel winds from Brazil or the frigid winds from Argentina/Antarctica. I've planted over 100 trees so far and will plant more now that the ground is soft and it is cooling down (nights in mid 40's days 65º-75º). A;so be wary of low, flood prone land which is very common here.

Post a Reply

00abuse

MobilityLC
5/9/2019 15:21 EST

Hi Emanuela!

Hope you are fine.

I have sent you a PM back on April answering to your first message.

Have a great rest of the day and wish you well.

Cheers!

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

sylk
5/9/2019 15:30 EST

for campos - we had an excellent experience with Noel de los Santos who is based in San Carlos. Their office provides immobilaria, legal, and escribana services, are well established and respected. They're also very kind & fluent in English.
We can't recommend them highly enough!!
His real estate (immobiliaria) is called "Inmobiliaria Campos del Este":
25 de Agosto 956
(between Ituzaingo and Carlos Alberto Cal, close to the center)
20400 San Carlos,
Departamento de Maldonado
tel: 442 666687


check out the beautiful campos on their website:
http://www.camposdeleste.com/site/index.php

Post a Reply

10abuse

Emanuela
5/9/2019 16:26 EST

Thank you everyone for the abundant information. We will follow your lead. Any advice you may have for us, about living on a chacra, would be greatly appreciated.

Post a Reply

00abuse

ChiquitaBanana
5/9/2019 17:09 EST

Hi Emanuela, my husband and I have been visiting Uruguay, Punta Del Este for the last 4 years. Our last visit was a couple of months ago during which time we took the time to look at some properties to purchase. We stayed a few weeks and got to understand many different areas as well as locations and we concluded that although chacras are wonderful, they are just not very practical if you need to be near schools or shops, entertaining. Having a car will facilitate and of course all is a matter of choice and likes.
Our agent Marina Gutierrez took the job of educating us about all of this and showed us many options.
Frankly she was awesome, always available, very knowledgeable and helpful Initially we contacted her over the internet through a client of mine that knew her and while speaking to her we realized how lucky we were to have meet her.
Good luck!

Post a Reply

11abuse

stratossailor
5/10/2019 06:32 EST

Hi Emanuela,

the most helpful contact I met in UY is Marina from focus-properties
She and her husband Michael know almost everything and do help a lot. Their offers are very good choice as well.
Best wishes for your UY-future!

Post a Reply

12abuse

Vortice
5/10/2019 08:45 EST

Some of the reasons we like living on a chacra are privacy, natural beauty, relative quiet, pitch dark nights, our own non-chlorinated well water, room to grow plants, room to build, room for the dogs. Disadvantages would include the need for a car (preferably 4x4), the closest store is a 15 minute drive so you don't want to forget anything. When we get 3+ inches of rain in a day the creeks flood and we cannot get out, security is an issue (we do not leave the chacra unattended for more than a day, since we moved onto the farm 2 years ago, we have had no more problems). Venomous snakes are an issue, I have seen 4 Yaras this season and we always wear tall rubber or leather boots or work boots and snake gaiters when working outside. We worry most about the dogs getting bitten.
Dirt roads raise clouds of dust, so we bought a chacra that is set back from the road. Rural dust pollution (pm10) is a health threat and makes for a dirty house. Our car is never clean! That being said, neighbors are friendly and everyone waves at each other. We do have some local traffic jams in the form of 50 head of cattle with horseback gauchos and their busy cattle dogs. This can lead to "fender benders"; one day, the impatient car in front of us was head butted by a large, and incensed cow. Driver was not "tranqui" so neither was the cow.

Post a Reply

00abuse

papajohn
5/10/2019 09:03 EST

What do you do for fun out there in the middle of nowhere?

Post a Reply

00abuse

pjantares
5/10/2019 10:03 EST

Vortice, you summed it up quite nicely. Don't forget peaceful days and stunning sunsets.

Post a Reply

00abuse

Vortice
5/10/2019 11:00 EST

Hola Papajohn, the internet makes all the difference out in the campo. Youtube is one of the most popular websites here, not to mention Facetime conversations with family and friends in the US. We put benches around the chacra to sit and take in the views of nature, which we find very interesting. From birds to bugs, nature is very different here than in California and we are learning a lot. The chacra has native monte, a year round creek and we are planting many natives in the landscape and removing invasive non-native plants. The latter being a sisyphean task given the extent of honeysuckle invasion.
We are rarely satisfied with restaurant fare (at least at our budget) so we spend the plata on quality materials and cook great meals on the farm. Last night was medium-rare filet mignon with a velvety bernaise sauce and organic garlic mashed potatoes. We also have a plethora of hobbies and love to read books (made of paper!) and so are able to amuse ourselves "en el medio de nada."

Post a Reply

00abuse

papajohn
5/10/2019 11:33 EST

Thanks Vortice. It sounds like you've found your little piece of paradise so to speak. What is the filet mignon called here? We've not had good luck with our beef buys and stopped eating it a while back and now subsist mostly on vegetables we grow and buy. Every now and then, we do get a hankering for a thick, juicy, flavorful steak and even more so with a nice Bearnaise sauce!

Post a Reply

00abuse

Vortice
5/10/2019 12:09 EST

Papajohn, Filet mignon is called lomo here. We do not buy the lomo in the packages and ask the butcher if they have a " lomo entero" or whole tenderloin. They have to cut it from a side of beef and trim it while we wait. We slice it and wrap it in servings for the freezer. We too have been disappointed with the cuts of beef, unless we are making stew! Given that we eat small steaks and not more than once a week, we decided to buy only quality filet. In a country that is famous for beef and where there are 4 cows for every person, we were surprised by the scarcity of good beef. Me thinks the fine beef is mostly exported. We have not yet tried buying steak at Las Nenas Steak House in Pta del Este. On our 1st exploratory trip in 2014 we wanted to experience the parilla and walked into "El Fogon" in MVD. The med-rare filets came to the table virtually raw but I decided to taste it before sending it back to the grill. It was absolutely the most tender and tasty steak I have ever had. It exists here, we simply need to find it. Anyone else solved this?

Post a Reply

00abuse

pjantares
5/10/2019 14:52 EST

Beef is not aged here. Refrigeration is too expensive. I have aged my grass fed beef in a spare fridge on a rack over a broiler pan at 36F for one week. it not only breaks down the muscle tissue but improves the flavor.

Post a Reply

00abuse

Expat91364
5/10/2019 20:54 EST

I do find marinading, Corning or slow cooking all improve the local beef. On the other hand you can find meet for export which is amazing.

Keep in mind they butcher differently and that can make the meat seem tough if not cutting across the grain.

But it is for the most part half the price of meat in the US so I find ways to make it work....

Post a Reply

00abuse

Wanderlustspirit
5/21/2019 22:12 EST

There are several South Africans looking to develop a community in Pueblo Eden. That is about 30 minutes to Minas which has a bilingual school. Pm me if you would like more details.

Post a Reply

00abuse

Sailingalong
6/20/2019 12:26 EST

I have learned first hand only to believe face-to-face recommendations from living in other countries. Anyone can pose as anyone on these boards. In the last country I lived, there were individuals that were posing as others but were recommending themselves to new arrivals. Very dishonest. No idea if that is happening in Uruguay but best to ensure that your "recommendations" are coming from real people, especially based on other threads from this group.

Post a Reply

10abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Uruguay.

International Moving Companies

Moving to Uruguay? Get a moving quote.


Mail Forwarding to Uruguay

Mail Forwarding to Uruguay.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

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

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

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

Moving-To-Punta-Del-EsteAn Expat Talks about 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.

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

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 /expat/index.cfm
Time Stamp 02-Jun-20 05:25 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.145
Host Name 173.245.54.145


Execution Time

Total Time Avg Time Count Template
133 ms 133 ms 1 /home/www/html/expat/Application.cfm
53 ms 53 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
53 ms 53 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
40 ms 40 ms 1 /home/www/html/expat/messages_rdesign5.cfm
31 ms 31 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/expat/message_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navcontentbox.cfm
16 ms 16 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
14 ms 1 ms 20 /home/www/html/navvote_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/navtop_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navleader_rdesign5.cfm
5 ms 3 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 0 ms 20 /home/www/html/expat/common/formatmsg.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
1 ms 1 ms 2 /home/www/html/navinjection.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/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
134 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/expat/queries/qry_GeneralSet.cfm @ 05:25:30.030
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:25:30.030
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 05:25:30.030
	Select *
	From Networks
	Where frmid = 320 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 115 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 320 
getcities (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	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/navmetaforums_rdesign5.cfm @ 05:25:30.030
  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/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select *
	From Networks
	Where networkID = 115 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 320 
  AND t.tpcid = 3437189 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3437189
  and  t.tpcid = 3437189
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=16) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 115
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3437189
  and  t.tpcid = 3437189
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=16, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:25:30.030
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 115
	order by lastsent ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:25:30.030
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-03-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:25:30.030
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-06-02 00:00:00.000"
and logtime < "2020-06-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:25:30.030
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:25:30.030
	SELECT *
	From contentcountcountry
	Where networkid = 115 
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 05:25:30.030
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-01"
    and fromDate < "2020-06-02"
UpdatePageViews (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:25:30.030
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:25:30.030
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 320 
  AND tpcid = 3437189 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 05:25:30.030
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 320
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 05:25:30.030
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 05:25:30.030
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=4ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 05:25:30.030
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3437189
  AND m.userid = u.userid
  AND topics.tpcid = 3437189
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=6ms, Records=19) in /home/www/html/expat/messages_rdesign5.cfm @ 05:25:30.030
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3437189
  AND m.userid = u.userid
  AND topics.tpcid = 3437189
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527110
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527110
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
	Select *
	From Networks
	Where networkid = 115 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 115
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527117
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527117
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527142
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527142
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527182
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527182
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527303
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527303
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
	Select *
	From Networks
	Where networkid = 115 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 115
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-06-01"
and natforumstart < "2020-06-02"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:25:30.030
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527307
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527307
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527311
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527311
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527320
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527320
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=3) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527395
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527395
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527408
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527408
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527413
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527413
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527431
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527431
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527436
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527436
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527440
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527440
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527453
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527453
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527476
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527476
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527507
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 527507
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 528780
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 528780
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 532785
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:25:30.030
SELECT vote
FROM votes
WHERE voteid = 532785
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=26ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 05:25:30.030
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 115
	AND "2020-06-02" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:25:30.030
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-02"
     
         and rptarticlenetworks.networkid = 115 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 05:25:30.030
	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 @ 05:25:30.030
	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 @ 05:25:30.030
SELECT  hiimg
FROM rptarticles
where rptarticleID = 33
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 05:25:30.030
	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-02"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 05:25:30.030
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 115 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 05:25:30.030
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         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 @ 05:25:30.030
		Select summary, hiimg 
		FROM answers
         where answerid = 74372
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/expat/index.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/expat/index.cfm
QUERY_STRING=frmid=320&tpcid=3437189
REMOTE_ADDR=173.245.54.145
REMOTE_HOST=173.245.54.145
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28861618
cftoken=48469039
sessionid=IBEXPATEXCHANGE.COM_28861618_48469039
urltoken=CFID=28861618&CFTOKEN=48469039
URL Parameters:
frmid=320
tpcid=3437189
Debug Rendering Time: 13 ms