Home Peru Forum Peru Guide Peru Resources Real Estate Healthcare in Peru
Peru
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Peru Expat Forum

Arequipa real estate

Post New Topic
wypeck
11/10/2015 22:54 EST

We are considering a move to Arequipa in about a year after retiring. My wife is from Lima and her family lives there, but we like Arequipa better and believe housing may be less expensive. I haven't been able to find much on the internet. Can anyone tell me if it's possible to buy a reasonably priced property (say <~$175,000) 3+bed, 1.5+ bath, and at least a small yard for a dog? Or similar rentals that would accept a dog and 2 cats? Other information on cost of living would be appreciated too.

Post a Reply

00abuse

pistachio
11/28/2015 08:35 EST

here is the page of a site that lists properties all over Peru / search like you would search on Amazon....

http://www.adondevivir.com/

pistachio

Post a Reply

10abuse

wypeck
1/10/2016 19:42 EST

gracias

Post a Reply

00abuse

littlepaul26
3/17/2016 02:03 EST

there are a lot of good deals in Arequipa at the moment. 3 bedroom 2 bath for about 57000 us dollars.

Post a Reply

10abuse

littlepaul26
3/17/2016 02:04 EST

http://www.adondevivir.com/
tis is one of the highest real estate pages in Peru

Post a Reply

10abuse

Digga
4/20/2016 06:42 EST

Arequipa is a great place. The people are friendly and it has a safe feel. (especially compared to Lima). for the money you are talking you should be able to get what you are looking for although yard size is hard to find. Many dogs live on the roof top level of the houses and appartments. Best suburbs are Yanahuara. then Cayma and Cerro Colorado. .all close to the city centre. General medical facilities dentists etc are good and cheap compared to where I live, Australia. To rent something good you will want around 1000 sol per month in these suburbs which is what I would recommend you do to give you time to settle in and find the right place. Good supermarkets in this area although you will save heaps, have larger choices, and really embrace the culture( not to mention supporting the small farmers) more by going to the traditional markets. I love to drive when Im there but I love to drive. If your not such a confident driver Taxis are cheap. The small buses are cheaper if you know the right ones to catch. Arequipa is a Great choice you will not regret.

Post a Reply

00abuse

wypeck
4/21/2016 11:36 EST

Thanks. Good information. We loved Arequipa the two times we visited.

Post a Reply

00abuse

pistachio
4/22/2016 07:40 EST

I have heard too that Arequipa is a great place. I never got there but maybe it is time for a trip.
Some say that Arequipians consider themselves a sub country of Peru holding themselves at a higher status.
I haven't researched this thoroughly but I think there is a huge active volcano there Mt. Misti, and that Arequipa and surrounding areas are all sitting in a Super Caldera.
I do know from watching reports for years now of seismic activity that Southern Peru and Northern Chile have very frequent earthquake activity.
Still, I would love to know more about the area and the lifestyle.

Post a Reply

00abuse

Digga
4/23/2016 11:06 EST

My wife's family is from Arequipa hence my interest in relocating. Arequipanions? Are very proud people with there own flag who has in the past tried to become a country in Thiet own right. The " local patriotism " is strong. And prejudices are still long held (the whole Spanish/cholo things (I'm still surprised the more I learn) But I believe this could be said of most South American countries? But that said, times they are a changing. Thankfully it doesn't have the metropolis feel like Lima and the people are friendly. After a while even a gringo like me forgets about living in the " Death Zone " of El Misti and instead embraces being surrounded by the three volcanos and the beauty they provide with their almost year round snow capped peaks.

Post a Reply

00abuse

wypeck
5/7/2016 18:38 EST

My wife is from Lima. She says she is from Chiclayo (Pimental really) because that is where her parents are from. But she only lived in Pimental a short time. Most of her youth was in Cuzco and then later Lima where her parents and brothers still live. We visited Arequipa twice for about a week each time. Her brother worked there for about 5 years and married an Arequipana. Yes, the Arequipanos are known in Peru as being proud of being Arequipanos and almost thinking they are a separate country. I found them to be proud of where they are from and, like Peruvians in other places, to be very friendly. With justification I think to be proud of where they are from. It is beautiful there and about the perfect climate. And, like in Lima, the food is great! My brother-in-law recently went back for a visit with his wife and he told us it has changed. That the traffic has gotten bad and a lot of people from poor pueblos moving there. I suspect his perspective is colored by what he remembers from when he was younger and younger people do tend to idealize places they lived in when they were younger. I kind of doubt it has changed that much since he lived there 10-15 years ago. Certainly has not been impacted by people moving there from the highlands like Lima. But we will see when we visit with an eye to moving there. Unless it has changed drastically, which I just do not believe it has, we want to move there as soon as we can. Which will probably be a few years yet until our sons become self sufficient. We expect to go back in a year or so to scout it out as a place to retire.

Post a Reply

00abuse

pistachio
5/7/2016 18:55 EST

I was visiting Peru in 2oo1 and many more time until I moved here inJuly 2012........
Peru is changing,, most notably in the Urban areas....... lots of construction, taxi's with signs, at malls taxi fares are posted so no longer bargaining ........more new cars than ever,,,,,,,,,,more malls than ever....apartments are what is selling in the real estate market and prices are higher than ever and still increasing.............
A suggestion would be to secure a property, apartment or some sort of real estate now that suits you because you could be facing even higher prices as time goes by.......

Post a Reply

00abuse

Digga
5/16/2016 22:41 EST

How very true. Prices have been rising in Arequipa quite rapidly in recent years. Oh to have had a crystal ball five years ago. Do be very carfull and employ a good lawer as I have heard of horror stories where property is bought from someone only to end in years of legal wrangly because it was also sold to another person and even lawyers can be in on this. Contact me if you like and I can put you on to a good lawyer who is a long time family friend and very trustworthy.We have had her deal with a few things for us and she is very good Bargans can be had though like anywhere so dont make a fast deal. The price will come down if they know you are interested but are prepared to wait. Same as anywhere in the world when it comes to realestate. Real bargans can also be had from the courts and banks when they are about to foreclose. Like all realestate the homework you put in and being there to take advantage of opportunity is the key.

Post a Reply

00abuse

pistachio
5/22/2016 11:15 EST

so,, you have a Lot of replies,, for a while there it looked a little lonesome....

I think everyone falls in love with the first place they visit in Peru...

I am sure Arequipa is great,, I have heard many good things....

Like California,, Peru is a Long country so there Could be other places you would enjoy.... for instance,, Cajamarca, or Trujillo or Huanchaco.......

Traveling here is easy, and by bus time consuming but in a matter of hours your in a totally new zone....

ok,,,

here is another what appears to be a very comprehensive real estate site,,,

http://urbania.pe/venta-de-propiedades-en-arequipa

good listings and nice property and dwellings... good pics too....

Reading them and the pics will give you insight....

There are areas surround Arequipa that are listed too,,, Cayma for instance,,, but I really do not know anything specific about that whole area...

oh,,, except for one thing... There is a Papaya that is small and only available in Arequipa,,, you don't see anywhere else in Peru... [ unless someone is just getting off a bus ] LoL !

They are considered very special.....

pistachio

Post a Reply

00abuse

scumbuster
5/28/2016 08:37 EST

An interesting thread. We are in the process of selling our home in Colombia. (have a deposit) I would highly recommend anyone live some place for more than a year before buying. I visited a sleepy little town in Colombia that is almost 2 hours from Bogota, with nothing of consequence between it and Bogota. It was just to far to travel to Bogota more than a couple times a month for actives. The peace and quiet there was great for about 1 year at which time I became quite board. Since Colombia has just started taxing expats on foreign income making a disincentive to live there more than 180 days, we are looking elsewhere to live for at least 1/2 the year. I will be retiring again in September and plan to spend 6 months exploring Peru. Arequipa is on our list. We were in Barranco on the north of Lima earlier this year (only 10 days) and liked the area but I can see it would cost more to live there than in Colombia. At least where I was living in Colombia. If we find a place we really like I would rent for at least a year before buying. Its much easier to buy than sell a place, although it seems like I lucked out. Most locals don't have the available finances of us expats and the likelihood of selling to another expat is probably low. In my case sleepy little towns, while quaint and relaxing are nice in the beginning, an be quite boring long term. Plus I can almost guarantee if your living some place for a year you will get a better deal when buying than if you rush into buying after a few weeks or even few months. Because the prices seem so good compared to the US its easy to fall in love with a place and buy without knowing how it will suite you long term. I know because I did it. If this sale goes through I will have dodged a bullet because not many buyers in a little town like this and after 5 years we will just be breaking even, although will be freeing up funds for future adventure.

Post a Reply

00abuse

scumbuster
5/28/2016 08:39 EST

OH...I guess Baranco was on the south of Lima.. Adjacent to Miraflores. Got turned around.

Post a Reply

00abuse

pistachio
5/29/2016 09:51 EST

ok,,, there are Two,,, well Almost

There is a District in Lima around the vicinity of St Isidro and Miraflores called Barranco

To the North of Lima there is an area called Barranca

Post a Reply

00abuse

pistachio
5/29/2016 09:59 EST

barranco / barranca

https://en.wikipedia.org/wiki/Barranca,_Lima

-----------

https://en.wikipedia.org/wiki/Barranco_District

pistachio

Post a Reply

00abuse

wypeck
6/1/2016 14:20 EST

Glad you are likely to dodge the bullet in Columbia. Columbia is another place we have considered, but we are more interested in Peru (because my wife's family lives there among other things that we like about Peru and Arequipa in particular) and Ecuador. I have been to Barranco, the place just south of Miraflores where the Puente de los Suspiros (Bridge of Sighs) is located. That is a very nice area, but expensive for Peru. It is known for having a large number of artists living there. My wife's parents live a block off the coast just north of there in Miraflores where we have spent a lot of time. Miraflores is very nice and has improved a lot since I first saw it back in 1991. But again, housing is relatively expensive for Peru. We love the weather and the city of Arequipa and as of now housing is I believe considerably cheaper than in the livable areas around Lima. We would like to rent before buying and we will probably try to do that. Our main concern about renting is the fact we have a German Shepherd and two cats we would be taking along and I'm not sure how easy it would be to find a suitable place that would accept them.

Post a Reply

00abuse

wypeck
6/1/2016 14:35 EST

Thanks for the reply and information. We have been to many parts of Peru, including Trujillo. Trujillo is very pretty, especially the Plaza de Armas. And we did think about Trujillo, but my in-laws in Miraflores say that there is much more crime there than many other places, for example Arequipa. Also, the weather and mountain views from Arequipa are much better I think. Arequipa is somewhat isolated. But it is large enough I think to find many things to do, including visiting the Cayon de Colca area. And it has many good places to eat. Not as much as Lima, but still a lot. And last I knew flights to Lima were only about $75, though I think that may be the one-way price. We would really like to live in Lima, although the weather is not near perfect like in Arequipa, because my wife has a lot of family members there. But from the research I've done, it appears housing in a livable area for an ex-pat is much higher than in Arequipa. Although I know from experience, food is cheap and good restaurants abound at good prices. One of the reasons for moving there is to increase our retirement savings (or decrease the draw down) so we can travel more and, perhaps, leave a good sum to our kids. And to do that is highly dependent on finding less expensive housing than we have in a small college town in Wyoming.

Post a Reply

00abuse

wypeck
6/1/2016 14:41 EST

Thank you for the offer. I may contact you when the time comes. My brother-in-law's wife is from Arequipa, so we were also thinking we might be able to get assistance through her family or acquaintances. Also, my brother-in-law lived there for 5 years as a professional and still knows people there himself. Our oldest son has one more year of high school and we would need to stay in the U.S. until he is self sufficient. So it will likely be a few years yet. Although, we are considering visiting Arequipa again in about a year and we would entertain the idea of buying a place at that time, but not moving there until we are able to. However, I think that could be a risky thing to do. Perhaps if it were watched over by a friend of my wife's family.

Post a Reply

00abuse

pistachio
6/1/2016 14:46 EST

I am sure Arequipa can be good for you.
Just saying, the talk of crime issues in Trujillo are false.

pistachio

Post a Reply

00abuse

pistachio
6/1/2016 14:51 EST

A thought would be to buy a piece of property on which to build. Houses are constructed handily on a matter of just a few months. Also, you escape the high market because you build for the cost of materials and labor.

And, not much to watch while you're waiting.....

( a good idea, no? )


pisrachio

Post a Reply

00abuse

scumbuster
6/1/2016 16:02 EST

@wypeck
Don't get me wrong about Colombia. I like Colombia very much. My wife is from Bogota originally. The little town Pacho was just too laid back and they role up the sidewalks at 8:00 PM. While in the US I most always lived in small towns and thoroughly enjoyed it. However even in a small town in the US you are normally within 30 minutes of anything you would ever want to do. I was almost 2 hrs out of Bogota with very little in between. So an evening in Bogota wasn't even a possibility unless you got a hotel in the city. The mountain roads were bad and dangerous in the day let alone late at night. Bogota, like any big city has its good points and bad points. We still plan to live at least 1/2 the year in Bogota, but defiantly want to look at other options. I originally retired at 57 and after almost 2 years came back to the states (Dallas) for work. My old employer was happy to have me back. But after 8 months back, I just don't have the drive I did when I left. I guess after that amount of time off its hard to be back in the rat race. So in September I will be retired again, ready to explore.

Of course I owned our house in Pacho, so no rent to pay. We lived comfortably on 1K a month. But I am figuring probably at least double that in Bogota.
I think climate wise Arequipa is probably similar to Bogota. Bogota is over 8,000'. I have always liked the ocean and like the idea of being within a tolerable drive to the ocean. We will probably be back to Peru early next year and plan to explore pretty much the whole coast top to bottom. Even thought about checking out Arica, Chile while in the south.
Your money does go a long way in Colombia if you don't mind being well outside the big cities.

Post a Reply

00abuse

pistachio
6/2/2016 14:24 EST

alright,, just to say....

on the coast of Peru to the north you will find Mancora and Zorritos,, both nice but a million miles from where you want some city sometimes....

To the farthest north is Tumbes,, an old city at the Ecuadorian frontier... it is old, a little beat but it does have its' charms....

on the way to the north you will hit 3 cities,,,, Chimbote / south of Trujillo,, and to the north of Trujillo,, Chiclayo and Piura.... both for Peru Major cites,, Chimbote not so much...

ok,,, now,, back to Trujillo,, a city that really has everything you want in a city and really is very livable,, but,, you said you like the beach.....

well,,, Huanchaco is 11 to 15 km from Trjuillo,, a twenty minute car jaunt or a little more by combi or taxi...

but,, Huanchaco has Much better pricing for real estate purchase and apartment rental.....than Trujillo...

You got the beach 24/7 and always a walk to from where ever you could be in Huanchaco....... lots of surfers and Peruvian visitors.... great restaurants,, some nightlife and good people,, so......

Huanchaco is like a little moon of Trujillo,, so,,, living on the moon here could work out for you.........

just sayin........

pistachio

Post a Reply

10abuse

scumbuster
6/3/2016 12:55 EST

pistachio, I really enjoy your perspective on Peru and Huanchaco and Trujillo are on our list too. I'm not sure how I will like the desert type landscape of that area but am willing to keep an open mind. It does have the advantage of close proximity of the ocean. Even living in Huanchaco it would be a short taxi or bus ride to the ocean. The problem in Lima is the cliffs separating most of the city from the ocean. It was quite a long walk to get down there from Barranco. We had talked about even going up into Ecuador and flying back from Quito. It will be nice to just play it by ear and not have any timelines. Stay some place till your tired of it and then move on down the road to another place.

Post a Reply

00abuse

pistachio
6/3/2016 17:00 EST

Well,, Coastal Peru is really all desert. Where people live in urban areas with lots of houses it tends to be much greener but certainly never Lush....
It is dusty,, but really I think all of Peru is dusty... have never seen a screened window yet Once you go outside an urban or city area unless you see farms and agriculture it is more desert like.....

and you will be able to walk to the beach in five to ten minutes from anywhere in Huanchaco

When you get in town here is a nice accommodation...........

Look in

https://www.tripadvisor.com/

for a hotel called NAYLAMP.....

not expensive and Very nice... you will be At The Beach.............and in Huanchaco.....

Yvonne will probably be at the desk,, you can say michael says hello ! !

Post a Reply

00abuse

wypeck
6/19/2016 13:03 EST

Thanks for the information. Do you know if it is relatively easy to rent a place in Arequipa that allows pets (1 GSD and two cats)? With a deposit to cover possible damage by the pets? We see that our pets do not damage a place, whether we own or are renting.

Post a Reply

00abuse

wypeck
6/19/2016 13:33 EST

Thanks for the information pistachio. Yes, Huanchaco looks and sounds interesting. I didn't find a lot of single family homes for sale there, but two I found appeared very nice for the listed price and with views of the beach. It will be an area we will definitely visit and consider. We do like the coast. We did like Trujillo and it would be great to be on the beach and just 20 minutes from Trujillo. Do you know if Trujillo has good doctors? My wife has a mild form of MS. Doesn't affect her much, but she does take an expensive medication, which if Peru is like many other countries, would be much cheaper than in the U.S. I would plan to keep my health insurance in the U.S. so that if needed, we could travel to the U.S. for a serious condition that we felt was better treated by a doctor in the U.S.

Post a Reply

00abuse

wypeck
6/19/2016 13:40 EST

Yes, coastal Peru is very much a desert. I found the scenery grows on you, especially next to the coast. I am most familiar with the Lima area (Miraflores) and the humidity is surprisingly high for a desert, but then I come from an area of very low humidity, Wyoming. I do seem to recall other places along the coast (e.g. Trujillo) seemed to be less humid.

Post a Reply

00abuse

wypeck
6/19/2016 13:49 EST

I first visited Peru in 1992, Lima area, Cuzco, and Macchu Picchu. Lima has changed a lot since 1992 as of the last time I visited in 2014. There were no American fast food restaurants except one or two KFCs. Now there are a lot. Of course grown a lot in population and the Miraflores business area has grown a lot. A lot for the good. The coast along Miraflores on down to Barranco is much cleaner (much less trash) than in 1992 and nice parks have been built or improved. Overall, I think the Lima area (Miraflores in particular) is better now. Though I wish the fast food restaurants and gambling casinos had not come in. Still, there are plenty of places to eat authentic Peruvian cuisine and it still definitely has not become overly Americanized. I understand the country is forging ties with China. So I wouldn't be surprised if it is more influenced by Chinese culture than American culture in the future. Lima does have a fairly large, longstanding, and vibrant population of people with Chinese heritage. Their unique cuisine received a lot of its inspiration from Chinese cuisine.

Post a Reply

00abuse

pistachio
6/20/2016 10:02 EST

So, a GSD is a German Sheperd, a large dog and two cats in your family. I don't think you should make such an issue, it would be - are pets allowed or not. Or Better, I like the apartment and I want to rent it, I have a pet, ?Is that a problem?
About you offering a deposit..... you going to put up a security deposit which you will never get back. To offer a second, well it is simple, your never going to see that back either. If you offer it OF COURSE, the landlord is going to take it......and keep it.

In Huanchaco, prices for real estate are very good compared to the City market, whether for land, houses or apartments,,, renting or buying.

ok,, Doctors, I do have some experience with the Docs here and have found them to be more than acceptable. I also have experience with Vets and they are good but their offices and equipment are a trip to 1910. In the States the Vet offices are like mini hospitals,, here,, well it is not unusual if you bring your pet for grooming, it will be the Vet who bathes your dog.......
Medicine: You could contact Inkafarma, [a place where you get your meds] to see if they have your medicine on hand. Realize the name will be different but the medicine the same. You need to the brand name and if not the chemical name so they can look it up. Keeping your US insurance in the States sound sensible but likely you will pay and not use it,, a tragedy. You could look at insurance policies here once you get a look at the services and maybe even talk with the Docs about your specific situations. Many people travel to Peru specifically for dental, eye and medical treatments because of the pricing.

Lima weather in the Summer is fine, but it winter it is Only Gray. High Humidity and lower temps,,, kind of uncomfortable.........
In Trujillo the weather is always pleasant but in Summer where the skies are clear and blue the humidity is high,, just short of 100% but never rains. Rain is so Unusual here that if you see drops it is a major downpour....Sometimes it is just misty and you can feel the Lightest of Drizzles.... and even that is unusual...
So,, in the Summer the humidity gets kinda uncomfortable...... Generally summer is pleasant but there is always a run of about 2-3 weeks where the humidity gets outtahand.....

Peru has changed much in the past recent years.........Many malls, modern apartments, consumer goods are increased in availability but all are imported....there are real Taxis now before it was anyone who had a car wanting to make a few Soles.....
The middle class is growing and expanding and the hunger for modern living and good has increased significantly. This is true for the Urban areas,, travel for 20 minutes outside of town and you go back about 80 years............
I am confident you will Always find Traditional Peruvian food .... Always.

Generations ago lots of Chinese emigrated to Peru. There is what I would call and Indigenous Chinese Culture,, firmly entrenched to the populous. As far as influence of that culture compared to the US,,, NO....
No one here dreams of traveling to or learning Chinese.... The influence is relegated strictly to Trade and Peru is in dire need of increased Export. But Culturally,,, no,,,,!!

The Chinese food here is good but it has definitely been influenced by traditional Peruvian food.....

Much of my comments here are my opinions and perceptions and by no means concrete facts. The bottom line is I live here and I like it here......

and Yeah,, I used to Hate seeing KFC and Pizza Hut franchises here.... but now just ignore.....

Let me know how your plans progress....and of course,, we can continue our conversations.........

pistachio

Post a Reply

00abuse

Digga
6/26/2016 18:30 EST

Just a few thoughts. I have found the doctors in Peru to be good. I had an operation done there as it was much cheaper than having it done in Australia( vasectomy reversal ) about a third of the cost. Good clinic, doctors etc. I've also had a lot of dental work done in Arequipa and again first class work,clinic,doctors and the costs about a fifth of Aussie dentists. The only thing I have found expensive was a medication I was taking. I guess in australia we have a government subsidised scheme for most meds of which mine was on that list. All in all I have nothing but good things to say about Peruvian doctors and clinics. A visit to the GP was 50 sol. I'll find the name of the dentists in Arequipa and post it here soon. They are great??

Post a Reply

00abuse

scumbuster
6/27/2016 14:49 EST

"The only thing I have found expensive was a medication"

I know the cost of medications vary widely depending on what it is but how much were the certain ones you bought? I guess that's something I will need to check on on our next trip down.

Post a Reply

00abuse

scumbuster
6/27/2016 19:16 EST

I have 2 medications that I take. Both are covered 100% in Colombia, but you can only get a 30 day supply at a time. To buy them over the counter, which you can do, is a little pricy @ around $125 for both of them. I wouldn't want to buy a 6 month supply for an extended trip to Peru unless there was no other way. In the US with insurance they were $10 each.

Post a Reply

00abuse

Digga
6/27/2016 22:20 EST

It was an anti depressant named Zoloft ( no longer thankfully) cost in Australia about $12 for 30 days but was about $70 us (100 aus) and wasn't widely available.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Peru.

International Moving Companies

Moving to Peru? Get a moving quote.


Mail Forwarding to Peru

Mail Forwarding to Peru.


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!

Integra Expat Health InsuranceExpatriate Health Insurance

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

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

10-Tips-for-Living-in-Peru10 Tips for Living in Peru

Expats love Peru's friendly people, low cost of living, inexpensive healthcare, beautiful beaches and low level of crime. Read 10 tips from expats for people moving to and living in Peru on topics such as driving in Peru, healthcare in Peru and international schools.

Expats love Peru's friendly people, low cost of living, inexpensive healthcare, beautiful beaches and low level of crime. Read 10 tips from expats for people moving to and living in Peru on topics su...

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

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

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

Peru 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 25-May-20 05:10 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
58 ms 58 ms 1 /home/www/html/expat/messages_rdesign5.cfm
47 ms 47 ms 1 /home/www/html/expat/message_rdesign5.cfm
45 ms 45 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
45 ms 45 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
45 ms 45 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 1 ms 35 /home/www/html/navvote_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
22 ms 22 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.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 35 /home/www/html/expat/common/formatmsg.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/ibstyle.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_GeneralSet.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 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.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:10:41.041
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:10:41.041
      	  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:10:41.041
	Select *
	From Networks
	Where frmid = 274 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 89 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 274 
getcities (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select *
	From citynetworks
	Where networkID = 89
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
  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:10:41.041
	Select *
	From Networks
	Where networkID = 89 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
  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 = 274 
  AND t.tpcid = 3405557 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
  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 = 3405557
  and  t.tpcid = 3405557
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 89
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
  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 = 3405557
  and  t.tpcid = 3405557
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 05:10:41.041
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 89
	order by lastsent ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:10:41.041
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-02-24"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 05:10:41.041
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-25 00:00:00.000"
and logtime < "2020-05-25 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 @ 05:10:41.041
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-18"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 05:10:41.041
	SELECT *
	From contentcountcountry
	Where networkid = 89 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:10:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-24"
    and fromDate < "2020-05-25"
    and bannerPlacement.networkid = 89
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 05:10:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 05:10:41.041
  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 = 274 
  AND tpcid = 3405557 
  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:10:41.041
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 274
  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:10:41.041
  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:10:41.041
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=5ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 05:10:41.041
  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 = 3405557
  AND m.userid = u.userid
  AND topics.tpcid = 3405557
  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=34) in /home/www/html/expat/messages_rdesign5.cfm @ 05:10:41.041
  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 = 3405557
  AND m.userid = u.userid
  AND topics.tpcid = 3405557
    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:10:41.041
SELECT vote
FROM votes
WHERE voteid = 323698
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 323698
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 05:10:41.041
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:10:41.041
	Select *
	From Networks
	Where networkid = 89 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:10:41.041
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 05:10:41.041
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 89
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-24"
and natforumstart < "2020-05-25"
and natforumstatus = 'live'

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

and (natforumweight = 'medium' or natforumweight = 'high' or natforumweight = 'low')
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 05:10:41.041
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 89
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-24"
and natforumstart < "2020-05-25"
and natforumstatus = 'live'
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 349872
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 349872
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 350041
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 350041
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 350252
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 350252
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 353224
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 353224
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 353228
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 353228
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 354801
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 354801
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 355968
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 355968
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357087
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357087
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357089
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357089
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357229
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357229
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357231
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357231
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357817
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357817
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357819
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357819
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357820
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357820
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357822
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357822
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357823
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357823
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357828
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 357828
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358020
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358020
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358233
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358233
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358266
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 358266
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361995
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361995
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361997
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361997
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361998
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 361998
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 362000
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 362000
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 362156
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 362156
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 363829
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 363829
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364078
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364078
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364149
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364149
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364192
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 05:10:41.041
SELECT vote
FROM votes
WHERE voteid = 364192
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=21ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 05:10:41.041
	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 = 89
	AND "2020-05-25" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentbox.cfm @ 05:10:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 89 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 05:10:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 89 
        and date > '2013-04-01'
		order by date DESC
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 05:10:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 89 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-25"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 05:10:41.041
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-25"
     
         and rptarticlenetworks.networkid = 89 
    ORDER by rptarticles.rptarticleID asc   
    


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=274&tpcid=3405557
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=28382467
cftoken=70121591
sessionid=IBEXPATEXCHANGE.COM_28382467_70121591
urltoken=CFID=28382467&CFTOKEN=70121591
URL Parameters:
frmid=274
tpcid=3405557
Debug Rendering Time: 12 ms