Home Panama Forum Panama Guide Moving to Panama Real Estate Healthcare in Panama
Panama City, Panama
Panama
Resources
City Guides
Panama City, Panama
JoinSign In

Living in Panama > Panama City > Panama City, Panama

Panama City, Panama

By Betsy Burlingame

Last updated on: Oct 30, 2019

Global nomads, retirees and expats are attracted to Panama City for many reasons. Our Guide to Living in Panama City, Panama covers the Best Places to Live, Schools, Healthcare, Cost of Living, Transportation and more.

With approximately 1.3 million people in the PC metropolitan area, daily highs in the mid to upper 80s and beautiful views of the Panama Bay, Panama City is a bustling city that is attracting lots of expats, global nomads and overseas retirees. Our Guide to Living in Panama City, Panama is an invaluable resource that covers:

Cost of Living in Panama City

"In my experience economic migrants who move to Panama ONLY to reduce their cost of living wind up bitter and disappointed because life in a developing country with a different culture and language has challenges that aren't erased by lower costs," commented one expat.

"Panama is no longer cheap, though not expensive. In most places you can live without a car if you want. Utilities are cheap, except electricity-keep this in mind if you want to live at low elevation. Real estate is slow now and deals can be had on rentals and purchases (but rent to try out before buying) A couple can rent and live comfortably, but not extravagantly, on $2000 a month," wrote one expat.

Additional Info: Cost of Living in Panama City

Healthcare in Panama City

"Beware of any hype about the quality and cost of healthcare in Panama. Over the last 4 years I've volunteered as a friendly visitor for those awaiting medical evacuation to European Union countries, and have heard many horror stories. Panama being a small, developing country, the critical mass, expertise, equipment or products for some conditions is just not here, unlike the situation at a major North American or European medical centre where they see hundreds or thousands of cases annually. As for cost, sure, basic healthcare is widely available at reasonable prices. However any kind of healthcare that is beyond basic is getting expensive. If you have advanced health needs like cardiac care, joint replacement, cancer treatment or neurosurgery, you'll eventually wind up in Panama City where specialists cost $60/visit, and hospitalization runs up to $4,000/day in a private facility. Public facilities are available but are overcrowded, not very clean, and poorly equipped. Costs for anything requiring advanced diagnostic testing or hospitalization can add up quickly. You'd have to set aside quite a bit to deal with emergencies, or have deep pockets to cover the costs. Furthermore, in Panama you pay upfront, called 'una garantia.' If you can't pay, they send you home, no joke. I recommend that everyone immigrating to Panama purchase health insurance that will allow you to get the best treatment possible back in your home country. If that is not an option, at least get insurance that will cover you in Panama, assuming your age and pre-existing conditions allow you to qualify. One of the reasons North Americans leave Panama is lack of adequate healthcare as they grow older," advised one expat.

Additional Info: Guide to Healthcare in Panama

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

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

Best Places to Live in Panama City

What do expats say are the best places to live in Panama City? The answer depends on a few criteria and preferences such as whether you need to be near schools, want to be able to walk or take the Metro to work and whether you prefer high-rise living or being a bit out of the city. Our article, Best Places to Live in Panama City, Panama, lists the best places to live according to expats and differentiates places for working expats, retirees, families and more.

Additional Info: Best Places to Live in Panama City, Panama

If you're thinking about moving to Panama and haven't narrowed down where you would like to live, consider taking a tour with our partner, Panama Relocation Tours. Learn More

If you're thinking about moving to Panama and haven't narrowed down where you would like to live, consider taking a tour with our partner, Panama Relocation Tours.

English-Speaking Areas of Panama City

A newcomer asked, "Which part of Panama City may be the best choice to find a monthly rental in a walkable area where some English is spoken?" One member offered helpful insight about English-speaking areas of Panama City, "English is scattered and intermingled in the city. There are not really any English speaking expat areas...you can find that in Boquete though. The city is a melting pot of sorts with expats from all over the world, and a good concentration of other Latin American countries along with Panamanians. In my opinion the best areas in terms of location are Punta Pacifica / Paitilla / Marbella, El Cangrejo / Bella Vista, San Fancisco, Casco Viejo, Amador Causeway. Then at the west end of the city is Ancon, and the east end is Costa del Este. Any of these would be good depending on type of housing and amenities you are looking for."

Panama City Traffic

Panama City Traffic

Traffic is a real issue in and around Panama City. If you are moving to Panama City for work, you may want to consider living within walking distance of work or near a Metro station.

In a discussion about traffic in and around Panama City, one expat said, "Those that have disparaged living in or within an hour of PC and don't live in these areas, I feel can only speak generally about the traffic. We live 30 minutes across the canal and have learned the times that are best to leave home and return. Also to be where you want to be during lunch time in PC. At present there are only the two bridges to get across the canal, but a third one is in the process to be built. Also a couple new highway accesses for the current bridges are currently being built. When I go into or return from PC there are several choices to get to either of the current bridges. I use WAZE for traffic information, which is usually accurate, to make my choices, and know a few tricks of my own. Also Traffic posts I subscribe to get on my Facebook page helps deciding which route to take if there are accidents. Managing my travel routes is mostly non problematic using a few tools and experiences. Can't say I haven't run into a snag or two, but turn up the music and just keep on rolling."

Another expat had a different view, "I live in the city and if you work from home or are retired then traffic becomes a non-issue. But if you need to go into an office everyday then I would think twice."

"I always swore that if I worked in the city, I would live next door in order to avoid driving. But I have a 'hack' to avoid city driving altogether. I leave my truck en route (usually in Coronado) then I wait for a big bus. They are soooo much better than the Coaster 'chicken' buses-smoother, quieter, bigger seats, better driver. Once I get to Albrook, I get on the Metro which is awesome. Once off the Metro, I grab a taxi or Uber to get to my destination. Also, I always avoid being on the roads during rush hours," wrote another expat.

Schools in Panama City, Panama

Panama City has several international schools that are highly recommended by expats such as Metropolitan School (MET), AIP (Academie Interamericana de Panamá), Balboa Academy and Boston School.

Additional Info: International Schools in Panama City

Is Panama City Safe?

Like any big city, Panama City has its share of crime, but is generally safe if you know what neighborhoods to avoid and use street smarts.

"Via Veneto [El Cangrejo neighborhood] is a known place for pickpockets. No wallets in back pockets, Zipped up bags over the shoulder and held in front of you. Ignore the guys who offer to show you around. They have ulterior motives. No real danger, they just grab, run and hand off to their partner in crime in case someone runs after them," cautioned one expat.

"Report crimes to the local police by dialing 104 (National Police) or 511-9260 (Tourist Police in Panama City) and contact the U.S. Embassy at +507-317-5000," wrote the US State Department.

Additional Info: Is Panama City Safe?

Meeting Other Expats in Panama City

The American Society of Panama hosts Thanksgiving gatherings, Halloween Parties, mixers, holiday parties and more.

"Balboa Elks Lodge on La Boca Road, members' (all visitor welcome even IF you are NOT a member) bar in bar, also access thru the 'red door' by the back parking lot," shared one expat.

Amador Balboa Yacht Club for happy hour & sunset, it is located next to the TGI Fridays & Country Inn & Suites (for a taxi ride there some times it helps to tell the drive this location "next to the TGI Fridays & Country Inn & Suites," said one member.

U.S. Navy League Panama Foundation is open to anyone interested in maritime activity and not exclusive to US military. They hold meetings on the second Tuesday of every month at the Wyndham Hotel in Albrook with speakers on a wide variety of topics - ambassadors, non-profit leaders and others.

El Metro de Panamá (Panama Metro)

Metro Panama

Panama's Metro light rail system, the first in Central America, began operating in 2014 and currently has 2 lines in operation with 7 more planned (map of Line 1 and Line 2). Line one runs from Albrook Station north to San Isidro. Line 2 runs from San Miguelito northeast to Nuevo Tocumen (PTY international airport). The Tocumen airport station opened in April of 2019.

For more information on the Metro lines that are under construction or in the planning stages, read Mapping out the future of Panama City's metro system by bnamericas and look at Metro de Panama's website. Note: while these sites and pages are helpful, there is conflicting information about the timeline and whether certain stations are open or still in planning or construction phases.

Download the Metro de Panama Apple App

or Google Play App. The Apple app let's you add money to your Rapi Pass card (Metro Card).

Additional Info: Metro de Panama

Taxis & Uber in Panama City

An helpful discussion about taxis and Uber in Panama City ensued when a newcomer asked, "Does anyone know an average costs for Taxis or Uber from the Tocumen airport to downtown Panama City?"

One member replied, "$30 is a good price [for a taxi from the airport to the city]. The taxis in Panama City operate on what I call the 'vulture system.' The cars are un-metered and many of the drivers will get you for all they can. Prices are at a premium at the airport, as well. In my experience, wifi sucks at the airport so unless you are already have a SIM card and minutes, or an intl. plan on your phone (and good luck with that from what I understand) you can't call Uber. Though you may be able to buy a kit from an orange vending machine in the lobby. When you exit customs and baggage, you will immediately be approached for a taxi. Ask the cost-I would be surprised if they say anything less than $40 to go to Cinta Costera. But you can negotiate. How is your Spanish? Anyway, from my last experience with Uber, it was a good $5.00 cheaper. But here is what happened awhile back for me. I was standing across the departures doors, at the edge of the short term parking, pissing with my phone to call Uber. And I was approached by a taxi driver. I asked him the price to go to San Francisco, and he said $30, which I accepted. Remember the taxi rule in Panama: Always ask the cost to your destination before you get in a taxi!"

"We just returned from a month in Panama mid November. Your Uber app will display what parking row number to wait for your ride to arrive when traveling from Tocumen to Panama City. Once in PC Uber "can" be less expensive than taxis for short distances, depends on time of day and availability. My wife and I walk out of Tocumen towards hiway and bus stop where taxis come into aiport, negociate $20 rides to Panama City, successful every time," added another member.

In another thread about Panama city, members talked about taxi prices and offered helpful advice, "My experience with taxis has been that there are two prices: one for locals and one for expats. We are viewed as having the disposable income and the expectation, at least among cab drivers, is that we share the joy. Now, I've tried having a local negotiate with the cabby before I get in.... inevitably, about half way there, the driver will come up with an excuse to at least double my rate!" Another added, "Never get a taxi in front of a hotel. It use to be $1.25 per zone but how do you know where the zones are. I'd say 7.50 from El Cangrejo to the BYC & $50.00 back unless you walk to the Balboa YMCA." Finally, another person echoed the same advice about taxis,"Always negotiate a price before entering the cab. If not, you're at their mercy when reaching your destination. Don't be afraid to tell them to move along, then wave down another taxi ... then start the process all over again."

"Use only licensed and registered taxis. Avoid taxis with passengers and instruct the driver not to pick up additional fares while en-route to your destination. Regular taxis are yellow in color. Many hotels also have 'tourist taxis' that are not yellow but only pick up passengers in front of well-known hotels. Taxis in Panama do not use meters so agree on a fare before getting into the taxi," advised the US State Department.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Panama City

Best Places to Live in Panama City

Best Places to Live in Panama City

Learn which neighborhoods rank as the best places to live in Panama City according to expats. Plus, learn which two neighborhoods may not fit the bill despite one of them being one of the most popular tourist destinations in Panama City.

Cost of Living in Panama City

Cost of Living in Panama City

Should you move to Panama City for a lower cost of living? The answer may surprise you.

Healthcare in Panama

Healthcare in Panama

Expats have differing opinions about healthcare in Panama. Many advice against public hospitals and healthcare, but some recount good experiences. This article covers public vs private healthcare, cost of healthcare, obtaining prescription medications and much more.

Schools in Panama City

International Schools in Panama City

If you're moving to Panama City with school-aged children, living near your children's school will make life easier. There are schools in central Panama, Clayton and elsewhere. Below you'll find information about the most popular schools for expats in Panama City.

Living in Panama City

A resident of Panama city for 60 years provides a brief glimpse of life in Panama for expats. Job opportunities and the modern amenities are a few of the features described.

Retirement in Panama City

An expat retiree in Panama advises others not to move there to save money, because the cost of living is probably less in rural, small cities in the US. But, he says that you can save a lot on healthcare in Panama.

Culture Shock in Panama City

An expat in Panama City, Panama shares her experience with settling into a new culture and how the experience has been a surprise for her given her present stage of life.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Join our Panama Expat Forum

Visit our Panama Forum and talk with other expats who can offer you insight and tips about living in Panama City, Panama.

More about Panama

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.

Costa-Rica-vs-PanamaCost of Living: Costa Rica vs. Panama

People considering a move to Central America often narrow down their list to Panama and Costa Rica. Expats talk about the cost of living in Panama and Costa Rica - housing costs, gas, car, electric, internet, groceries, budgets for various lifestyles and more.

Healthcare-in-PanamaHealthcare in Panama

Expats have differing opinions about healthcare in Panama. Many advice against public hospitals and healthcare, but some recount good experiences. This article covers public vs private healthcare, cost of healthcare, obtaining prescription medications and much more.

Cost-of-Living-in-PanamaCost of Living in Panama

Expats in Panama enjoy a relatively low cost of living. However, it's important to do your research to make sure you'll actually enjoy those saving while creating a high quality of life as an expat in Panama.

Tips-for-Expats-in-PanamaExpat Banking: Tips for Expats in Panama

Expats in Panama face unique challenges in managing their finances while living there, and that always starts with settling on the right expat financial services. Here are some basic tips from expats living in Panama - their insights are based on their actual experiences managing their finances while living there.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Updated On: Oct 30, 2019

First Published: Oct 30, 2019

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in Panama CityGuide to Living in Panama City

Global nomads, retirees and expats are attracted to Panama City for many reasons. Our Guide to Living in Panama City, Panama covers the Best Places to Live, Schools, Healthcare, Cost of Living, Transportation and more.

Healthcare in PanamaHealthcare in Panama

Expats have differing opinions about healthcare in Panama. Many advice against public hospitals and healthcare, but some recount good experiences. This article covers public vs private healthcare, cost of healthcare, obtaining prescription medications and much more.

Best Places to Live in Panama CityBest Places to Live in Panama City

Learn which neighborhoods rank as the best places to live in Panama City according to expats. Plus, learn which two neighborhoods may not fit the bill despite one of them being one of the most popular tourist destinations in Panama City.

Cost of Living in Panama CityCost of Living in Panama City

Should you move to Panama City for a lower cost of living? The answer may surprise you.

Schools in Panama CityInternational Schools in Panama City

If you're moving to Panama City with school-aged children, living near your children's school will make life easier. There are schools in central Panama, Clayton and elsewhere. Below you'll find information about the most popular schools for expats in Panama City.

Restaurants in Panama CityRestaurants in Panama City

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

Living in Panama City

A resident of Panama city for 60 years provides a brief glimpse of life in Panama for expats. Job opportunities and the modern amenities are a few of the features described.

Retirement in Panama City

An expat retiree in Panama advises others not to move there to save money, because the cost of living is probably less in rural, small cities in the US. But, he says that you can save a lot on healthcare in Panama.

Culture Shock in Panama City

An expat in Panama City, Panama shares her experience with settling into a new culture and how the experience has been a surprise for her given her present stage of life.

Panama 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 /lib_rd.cfm
Time Stamp 04-Jul-20 05:03 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.198
Host Name 162.158.78.198


Execution Time

Total Time Avg Time Count Template
108 ms 108 ms 1 top level /home/www/html/lib_rd.cfm
32 ms 32 ms 1 /home/www/html/navcontentboxcitymobile.cfm
22 ms 22 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
20 ms 20 ms 1 /home/www/html/navcontentboxcitypc.cfm
20 ms 20 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/breadcrumb_ctygd.cfm
8 ms 8 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
7 ms 7 ms 1 /home/www/html/navmpu_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navtop_ctygd2.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
3 ms 1 ms 3 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/natad/native_5471_93888.txt
1 ms 0 ms 8 /home/www/html/rewritearticle.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 2 /home/www/html/navinjection.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 6 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
114 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 05:03:09.009
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 05:03:09.009
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 05:03:09.009
	Select *
	From articles
	Where articleID = 5471
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 05:03:09.009
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 05:03:09.009
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5471 
	and articles.articleID = 5471 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 05:03:09.009
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5471
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5471
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 05:03:09.009
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 05:03:09.009
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 87 
getcities (Datasource=expert, Time=0ms, Records=8, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 05:03:09.009
	Select *
	From citynetworks
	Where networkID = 87
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 05:03:09.009
  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
commentcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 05:03:09.009
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5471 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 05:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 05:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 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_ctygd2.cfm @ 05:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.198'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 05:03:09.009
	SELECT *
	From contentcountcountry
	Where networkid = 87 
citycontentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 05:03:09.009
	SELECT *
	From contentcountcity
	Where citynetworkid = 4202 
citykeyimg (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 05:03:09.009
	SELECT *
	From countryphotos
	Where citynetworkid = 4202
	and keyimg <> ''
	and usekey = 'y'
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 05:03:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5471 
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 05:03:09.009
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5471 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=6ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 05:03:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 87 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-04"

    ORDER by articles.articleID desc
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 05:03:09.009
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 87
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-03"
and natsentencestart < "2020-07-04"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE 'hianchor' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 5 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT resourceid,  natanchorlink as adcode,natanchorlinkweight, natads.natadid
FROM natads, natadPlacement
WHERE natanchorlinktype = 5
and natadPlacement.networkID = 87
and natadPlacement.natadid = natads.natadid
and natanchorlinkend > "2020-07-03"
and natanchorlinkstart < "2020-07-04"
and natanchorstatus = 'live'

and natanchorlinkweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT resourceid, natanchorlink as adcode, natanchorlinkweight, natadid
FROM natads 
WHERE natadid = 46
and natanchorlinktype = 5 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE 'rtsentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 12 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 05:03:09.009
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 12
and natadPlacement.networkID = 87
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-03"
and natsentencestart < "2020-07-04"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4202
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and articles.articleID <> '5471'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-04" 
    ORDER by articles.articleID desc  
getbestsummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4202
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 4
 
getcolsummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
	Select summary, hpimg
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4202
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 2
 
gethealthsummary (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 87 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
getschoolsummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
	Select summary, hpimg
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4202
	and articlecityplace.articleid = articles.articleID
    and articles.keycity = 1
 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
         and networkid = 87
          and citynetworkid = 4202
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 73945 
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 87
          and citynetworkid = 4202
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 65737 
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
         and networkid = 87
          and citynetworkid = 4202
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73456 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 24821 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 05:03:09.009
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5471 
gettaxgeneral (Datasource=expert, Time=6ms, Records=5) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 05:03:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 87 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 5471
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 05:03:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 05:03:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 05:03:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-03 05:03:09'}
    and fromDate <{ts '2020-07-04 05:03:09'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 05:03:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 05:03:09.009
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5471 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4202
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 87 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
                    
           and city <> ''
         and networkid = 87
          and citynetworkid = 4202
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 73945 
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
                    
         and networkid = 87
          and citynetworkid = 4202
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 65737 
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
                    
         and networkid = 87
          and citynetworkid = 4202
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73456 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 05:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 24821 


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/lib_rd.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/lib_rd.cfm
QUERY_STRING=articleID=5471&networkid=87
REMOTE_ADDR=162.158.78.198
REMOTE_HOST=162.158.78.198
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=31001777
cftoken=18009747
sessionid=IBEXPATEXCHANGE.COM_31001777_18009747
urltoken=CFID=31001777&CFTOKEN=18009747
URL Parameters:
articleID=5471
networkid=87
Debug Rendering Time: 14 ms