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

Moving to Costa Rica > Playa Hermosa de Jaco >

An Expat Talks about Moving to Playa Hermosa de Jaco, Costa Rica

Feb 27, 2018


Beach View Near Jaco in 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.

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

Playa Hermosa de Jaco

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

The items I wish I had brought to Costa Rica - or maybe I should say as an expat living in Costa Rica I wish I had brought more of - are bed linens, pillows and bedcovering (lightweight as it's warm at the beaches), another set of kitchen pots/pans, a quality sound system for the outside, exercise clothes and quality footwear for hiking.

Items that I wish I had left at home: We moved to Costa Rica 17 years ago and did not use a container service. We basically packed our goods up in plastic containers for the airline and moved in that manner. Items that I wish I'd left at home are not many to mention. I probably bought too many clothes. (Being a woman, that's what we do!) I have clothing for colder climates but have never used them being at the beach. By using the airlines (and the help of friends too!) as a means of transportation, everything was scrutinized prior to packing as far as if we really "needed" it in Costa Rica (CR) so I'm proud to say we didn't bring much that we are now regretting.

Moving to Costa Rica

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

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

Spend time in the area and get to know it's full time residents. Participate in community activities, fundraisers, church activities if you are inclined. Eat at the local restaurants, shop locally, go to the local farmers market. Visit your prospective neighborhood at various times of the day especially at night to see if crime is a problem or noise issues. A community feels very different when you spend time with its full time residents and not tourists. You can truly gauge the area determining if it's a good fit for you, your family and your lifestyle. Get an honest lawyer to determine if the house you are interested in has a clean title (and the same for raw land). Get references for doctors and medical facilities in the area. In a nutshell, tourist activities are fun but it's far from reality of every day life. Think about what your day entails in your home country and perform the same activities in your prospective desired area!

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

We live in single family home in a remote and mountainous area. The other homes in the neighborhood are the same. However, the beach closest to us is primarily condos due to the proximity to the water. Being a popular beach town, the condos are privately owned and very popular seasonal rentals.

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

Our first home in Costa Rica (CR) was strictly by word of mouth. We had lived in the area for a few months and told just as many people we trusted that we were looking. In just a few months time, we looked at many properties. We got to know the area very well by renting so we knew the neighborhoods we liked and knew what a good price was to pay. We were in no hurry as we were renting at the time so we didn't appea anxious or desperate to the seller. The purchasing process was a breeze. After 8 years in that same location and home, we decided we wanted a quieter area and we finally were able to realize our original dream of having a water view property. 17 years total in CR ... it's working for us!

Expats living in Costa Rica 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 Costa Rica interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

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

Our housing costs are lower than in the states. Taxes are very inexpensive in CR and the taxes in the states substantially higher. Private home insurance is less expensive in Costa Rica from our experience. It is very hard to determine the average cost of housing. In this area, the closer the location to the beach, the higher the price. Direct waterfront may cost well over $500,000 to the millions depending on amenities. However in a lower profile condo building with less amenities, you can absolutely find something at half that price. Knowing the market is really key here and return on investment must be weighed in if you plan to rent the unit, seasonally or long term.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Playa Hermosa de Jaco

Guide to Living in Playa Hermosa de Jaco

Guide to Living in Playa Hermosa de Jaco

The Expat Guide to Living in Playa Hermosa de Jaco, Costa Rica.

Healthcare in Costa Rica

Healthcare in Costa Rica

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine healthcare and have private expat health insurance for specialists, surgeries and emergencies.

Living in Playa Hermosa de Jaco

An expat in Playa Hermosa de Jaco, Costa Rica says newcomers learn to relax, slow down and enjoy the carefree beach life in Jaco. Expats and locals love to surf, have picnics on the beach, go the the feria (farmer's market) on Friday mornings and choose from the diverse selection of restaurants.

12 Tips for Living in Jaco Beach/Playa Jaco, Costa Rica

12 Tips for Living in Jaco Beach/Playa Jaco, Costa Rica in Playa Jaco

Expats love Playa Jaco (aka Jaco Beach) in Costa Rica because of its beautiful beaches, amazing surfing, relaxed vibe and lively, younger expat crowd. This article covers everything about Playa Jaco - healthcare, restaurants, nightlife, schools, cost of living in Playa Jaco and more.

Retirement in Playa Hermosa de Jaco

An expat in Playa Hermosa de Jaco talks about why she chose to retire to Costa Rica, adapting to life there, the cost of living in Playa Hermosa and more.

Culture Shock in Playa Jaco

An expat living in Playa Jaco, Costa Rica enjoys the family-focused Costa Rican culture and the slower pace of life. She has great tips to help newcomers adapt to life in Costa Rica.

Join our Costa Rica Expat Forum

Visit our Costa Rica Forum and talk with other expats who can offer you insight and tips about living in Playa Hermosa de Jaco, Costa Rica.

More about Costa Rica

Best-Places-to-Live-in-Costa-Rica7 Best Places to Live in Costa Rica

Costa Rica is a relatively safe, eco-friendly, expat-friendly destination with gorgeous beaches and friendly locals. Many expats say that housing and food prices in Costa Rica are high. We've gathered information submitted by expats about Tamarindo, Dominical, Ojochal, Atenas, Escazu, Grecia and others popular towns.

Staying-Safe-in-Costa-RicaStaying Safe in Costa Rica

Recent crimes in Costa Rica have involved robbers arriving at homes and impersonating police officers. Alley Cat offers great advice and detailed information about what you need to know when the police are at your door.

3-Ways-to-Get-Rich-as-an-Expat-in-Costa-Rica3 Ways to Get Rich as an Expat in Costa Rica

Expats in Costa Rica have three main ways to make money legally -- you can obtain permanent residency, find an online job or start your own business. Bill Ripley covers each of these options and offers great tips for expats looking to make money while living in Costa Rica.

8-Things-to-Know-Before-Moving-to-Costa-RicaMoving to Costa Rica: 8 Things to Know Before Moving to Costa Rica

Moving to Costa Rica has become more popular among expats. Making this choice requires a lot of research to ensure the expat experience you hope for will be realized. Expats that live there stress that it should start with a trip there before any major decisions are made.

Cigna International Health Insurance

Write a Comment about this Expat Report

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

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

Guide to Living in Playa Hermosa de Jaco

Expats love Playa Jaco (aka Jaco Beach) in Costa Rica because of its beautiful beaches, amazing surfing, relaxed vibe and lively, younger expat crowd. This article covers everything about Playa Jaco - healthcare, restaurants, nightlife, schools, cost of living in Playa Jaco and more.

Healthcare in Costa RicaHealthcare in Costa Rica

Costa Rica is has both public and private healthcare systems. When you become a resident, you must enroll in the public healthcare system (CAJA). Many expats use the public system for routine healthcare and have private expat health insurance for specialists, surgeries and emergencies.

Restaurants in Playa Hermosa de JacoRestaurants in Playa Hermosa de Jaco

Support your favorite restaurants in Playa Hermosa de Jaco 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 Playa Hermosa de Jaco

An expat in Playa Hermosa de Jaco, Costa Rica says newcomers learn to relax, slow down and enjoy the carefree beach life in Jaco. Expats and locals love to surf, have picnics on the beach, go the the feria (farmer's market) on Friday mornings and choose from the diverse selection of restaurants.

12 Tips for Living in Jaco Beach/Playa Jaco, Costa Rica12 Tips for Living in Jaco Beach/Playa Jaco, Costa Rica in Playa Jaco

Expats love Playa Jaco (aka Jaco Beach) in Costa Rica because of its beautiful beaches, amazing surfing, relaxed vibe and lively, younger expat crowd. This article covers everything about Playa Jaco - healthcare, restaurants, nightlife, schools, cost of living in Playa Jaco and more.

Retirement in Playa Hermosa de Jaco

An expat in Playa Hermosa de Jaco talks about why she chose to retire to Costa Rica, adapting to life there, the cost of living in Playa Hermosa and more.

Culture Shock in Playa Jaco

An expat living in Playa Jaco, Costa Rica enjoys the family-focused Costa Rican culture and the slower pace of life. She has great tips to help newcomers adapt to life in Costa Rica.

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 /rspnet.cfm
Time Stamp 28-May-20 08:32 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.128
Host Name 162.158.78.128


Execution Time

Total Time Avg Time Count Template
170 ms 170 ms 1 top level /home/www/html/rspnet.cfm
73 ms 73 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
72 ms 72 ms 1 /home/www/html/navcontentboxcitypc.cfm
72 ms 72 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
57 ms 57 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
9 ms 9 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/breadcrumb_ctygd.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 4 /home/www/html/rewritearticle.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.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
175 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 @ 08:32:51.051
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 08:32:51.051
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 08:32:51.051
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 63
AND networkid = 33 
AND 75202 = answerid

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

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

AND answers.answerid = 75202 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 08:32:51.051
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 75202 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 08:32:51.051
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 08:32:51.051
	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 @ 08:32:51.051
	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 @ 08:32:51.051
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 08:32:51.051
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75202 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 08:32:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-02-27"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 08:32:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-28 00:00:00.000"
and logtime < "2020-05-28 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_ctygd2.cfm @ 08:32:51.051
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-21"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 08:32:51.051
	SELECT *
	From contentcountcountry
	Where networkid = 33 
citycontentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 08:32:51.051
	SELECT *
	From contentcountcity
	Where citynetworkid = 7298 
getarticlesection (Datasource=expert, Time=1ms, Records=107) in /home/www/html/breadcrumb_ctygd.cfm @ 08:32:51.051
SELECT *
FROM articleCategories
 
WHERE section = 1
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 08:32:51.051
		Select *
		FROM allreports, citynetworks
         where answerid = 75202
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 08:32:51.051
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 75202 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 08:32:51.051
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 08:32:51.051
	Select *
	From Networks
	Where networkid = 33 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 08:32:51.051
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 08:32:51.051
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 33
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-05-27"
and headerparagraphstart < "2020-05-28"
and headerparagraphstatus = 'live'

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

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	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 = 7298
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-28" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 7298
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 33 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 33 
         and allreports.answerid <> 75202 
          and citynetworkid = 7298
		order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
            
         and allreports.answerid <> 75202         
         and networkid = 33
          and citynetworkid = 7298
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74264 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 21985 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 33
and allreports.networkid = 33
 and allreports.citynetworkid2 =  7298
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79720
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79720 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79720'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79720'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79720 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 33 
         and allreports.answerid <> 75202         
          and citynetworkid = 7298
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75342 
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75202         
         and networkid = 33
          and citynetworkid = 7298
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75425 
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 08:32:51.051
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-05-28"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 08:32:51.051
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"
    and bannerPlacement.networkid = 33
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 08:32:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 08:32:51.051
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-05-27 08:32:51'}
    and fromDate <{ts '2020-05-28 08:32:51'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 08:32:51.051
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 08:32:51.051
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75202 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79720'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79720'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 75202 
getphoto (Datasource=tipripper, Time=12ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 75202 
	AND answersphoto.qid = '104'
	
	AND answersphoto.photo <> 'none'
	
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 33 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=10ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 75202         
         and networkid = 33
          and citynetworkid = 7298
		order by date DESC
checklivingfeature (Datasource=expert, Time=9ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
            
         and allreports.answerid <> 75202         
           and city <> ''
         and networkid = 33
          and citynetworkid = 7298
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 74264 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 21985 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 33
and allreports.networkid = 33
 and allreports.citynetworkid2 =  7298
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 11 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79720
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79720 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79720'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79720'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79720 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '33'
checkretirefeature (Datasource=expert, Time=10ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
            
         and allreports.answerid <> 75202         
         and networkid = 33
          and citynetworkid = 7298
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75342 
checkculturefeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75202         
         and networkid = 33
          and citynetworkid = 7298
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 08:32:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75425 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rspnet.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/rspnet.cfm
QUERY_STRING=rid=63&answerid=75202&networkid=33&start=75202
REMOTE_ADDR=162.158.78.128
REMOTE_HOST=162.158.78.128
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=28572772
cftoken=96079860
sessionid=IBEXPATEXCHANGE.COM_28572772_96079860
urltoken=CFID=28572772&CFTOKEN=96079860
URL Parameters:
answerid=75202
networkid=33
rid=63
start=75202
Debug Rendering Time: 11 ms