Home Costa Rica Forum Costa Rica Guide Moving to Costa Rica Real Estate Healthcare in Costa Rica
Costa Rica
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Costa Rica: Expat Counseling & Psychotherapy

Expat counselors and psychotherapists provide services to expats who have adjustment and other personal, professional and familial issues while living in Costa Rica. Expat life can be much more rewarding with the help of these trained professionals.

Interested in being included in this section. Contact us to discuss partnership opportunities.

Kinneloa Coaching

Kinneloa Coaching

Professional coaching for expats looking to freshen their career or personal life. Get more clarity and purpose. I also work with people in recovery.

Learn More

Transitions Therapy International

Transitions Therapy International

Online psychotherapy, counselling, coaching and consulting services for Expatriates, Repatriates and Third Culture Kids (TCK's) around the globe. Office sessions in London.

Learn More

10-Expats-Talk-About-What-Its-Like-Living-in-Costa-Rica10 Expats Talk About What It's Like Living in Costa Rica

Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more.
Expats living in Costa Rica talk about Pura Vida, deciding where to live in Costa Rica, meeting people and more....

Expat-Costa-Rica17 Best Places to Live in Costa Rica

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about the high cost of housing and food. In this updated version of the best places to live in Costa Rica we cover many more locations such as Playa Flamingo, Nosara, Lake Arenal, Jaco Beach and Ojochal.

Costa Rica has a lot to offer expats with its tropical climate, eco-friendly culture, beautiful beaches, welcoming people, good healthcare system and relative safety. Many expats warn newcomers about...

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

Retirement-In-San-Isidro-de-HerediaAn Expat Shares What it's Like Retiring in San Isidro de Heredia, Costa Rica

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa Rica a month ago answers these and other questions.

Why retire in San Isidro de Heredia, Costa Rica? Can you live on $1,000 or $2,000 a month? How difficult is it if you aren't fluent in Spanish when you first arrive? A retiree who arrived in Costa ...

Moving-To-Playa-Hermosa-de-JacoAn Expat Talks about Moving to Playa Hermosa de Jaco, Costa Rica

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat report.

An expat who has lived in Costa Rica gives all kinds of great advice on living there. Cost of housing, what to bring with you, how to settle in and much more is covered in this comprehensive expat re...

Costa Rica 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 /rgall.cfm
Time Stamp 14-Jul-20 01:05 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.227
Host Name 172.69.63.227


Execution Time

Total Time Avg Time Count Template
68 ms 68 ms 1 top level /home/www/html/rgall.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
25 ms 25 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navtop_rdesign5.cfm
12 ms 12 ms 1 /home/www/html/Application.cfm
8 ms 8 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.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
81 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 @ 01:05:05.005
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=10ms, Records=1) in /home/www/html/Application.cfm @ 01:05:05.005
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getcatname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rgall.cfm @ 01:05:05.005
	Select *
	From Categories
	Where categoryid = 83 
getbidders (Datasource=expert, Time=5ms, Records=0) in /home/www/html/rgall.cfm @ 01:05:05.005
Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourcePlacement, resourceCats
    WHERE 83 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	and Resources.type  <> 'local'
	and Resources.type  <> 'free'
	and Resources.type  <> 'affiliate'
	and Resources.type  <> 'locaff'
	and Resources.type <> 'bonusonly'
   and Resources.bid = 'yes'
    and todate > {ts '2020-07-13 01:05:05'}
    and fromdate <{ts '2020-07-14 01:05:05'}
	AND resourcePlacement.networkID = '159'
	AND resourcePlacement.resourceID = Resources.resourceID
	Order by Resources.resourcename
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:05:05.005
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 01:05:05.005
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getcities (Datasource=expert, Time=1ms, Records=9) in /home/www/html/navmeta_rdesign4.cfm @ 01:05:05.005
	Select *
	From citynetworks
	Where networkID = 33
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 01:05:05.005
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:05:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-04-14"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 01:05:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-14 00:00:00.000"
and logtime < "2020-07-14 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 @ 01:05:05.005
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.227'
and logtime > "2020-07-07"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 01:05:05.005
	SELECT *
	From contentcountcountry
	Where networkid = 33 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:05:05.005
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-13"
    and fromDate < "2020-07-14"
    and bannerPlacement.networkid = '33'
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 01:05:05.005
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
getaffiliates (Datasource=expert, Time=4ms, Records=0) in /home/www/html/rgall.cfm @ 01:05:05.005
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.contactname, Resources.email, Resources.phone, Resources.fax, Resources.street, Resources.city, Resources.state_prov, Resources.zip, Resources.country, Resources.longdescription, Resources.photo, Resources.site, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl
    From Resources, resourceCats
    WHERE 83 = resourceCats.categoryID 
	and resourceCats.resourceID = Resources.resourceID 
	and Resources.type = 'affiliate'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-13 01:05:05'}
    and fromdate <{ts '2020-07-14 01:05:05'}
	Order by Resources.resourcename
getcatname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rgall.cfm @ 01:05:05.005
	Select *
	From Categories
	Where categoryid = 83 
UpdateImpressions (Datasource=expert, Time=2ms, Records=1) in /home/www/html/rgall.cfm @ 01:05:05.005
  UPDATE Categories
  SET rgnetimpressions = rgnetimpressions + 1
  Where categoryid = 83 
getlistings (Datasource=expert, Time=5ms, Records=2) in /home/www/html/rgall.cfm @ 01:05:05.005
	Select DISTINCT Resources.resourceID, Resources.type, Resources.resourcename, Resources.eventdate, Resources.description, Resources.homepage, Resources.directlink, Resources.includelink, Resources.photo, Resources.phototype, Resources.quotebutton, Resources.usefullrewriteurl, Resources.fullrewriteurl, resourceCats.categoryorder
    From Resources, resourcePlacement, resourceCats
    WHERE 83 = resourceCats.categoryID 
	AND resourceCats.resourceID = Resources.resourceID 
	AND Resources.type <> 'hold'
	AND Resources.type <> 'guide'
	AND Resources.type <> 'local'
	AND Resources.type <> 'free'
	and Resources.type <> 'bonusonly'
    and Resources.bid <> 'yes'
    and todate > {ts '2020-07-13 01:05:05'}
    and fromdate <{ts '2020-07-14 01:05:05'}
	AND (33 = resourcePlacement.networkID OR resourcePlacement.networkID = '159')
	AND resourcePlacement.resourceID = Resources.resourceID
    
	Order by Resources.resourcename
	
gettaxgeneral (Datasource=expert, Time=7ms, Records=15) in /home/www/html/rgall.cfm @ 01:05:05.005
	Select *
	From articles, articlePlacement
	Where type = 3
   	and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
   	and articlePlacement.networkid = 33
   	and articles.articleid = articlePlacement.articleid
    and publishdate <{ts '2020-07-14 01:05:05'}
    ORDER by publishdate desc 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-14"
     
         and rptarticlenetworks.networkid = 33 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:05:05.005
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 15
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 01:05:05.005
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 33 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
SELECT  hiimg
FROM rptarticles
where rptarticleID = 15
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 33 
	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-07-14"

    ORDER by articles.articleID desc
    
checkretirefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 33 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
		Select summary, hiimg 
		FROM answers
         where answerid = 76511
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 33 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 01:05:05.005
		Select summary, hiimg 
		FROM answers
         where answerid = 75202
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rgall.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/rgall.cfm
QUERY_STRING=categoryID=83&networkID=33
REMOTE_ADDR=172.69.63.227
REMOTE_HOST=172.69.63.227
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rgall.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=31855031
cftoken=32518528
sessionid=IBEXPATEXCHANGE.COM_31855031_32518528
urltoken=CFID=31855031&CFTOKEN=32518528
URL Parameters:
categoryID=83
networkID=33
Debug Rendering Time: 17 ms