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

Expat Guide to Living in Nicaragua

Whether you're already living in Nicaragua or preparing to move to Nicaragua, our Expat Guide to Living in Nicaragua offers articles and reports submitted by expats about expat life in Nicaragua. For answers to specific questions, visit our Nicaragua Forum to talk with expats in Nicaragua.

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

9 Important Tips about Healthcare for Expats in Nicaragua

Expats living in Nicaragua discuss health insurance and quality of medical care in Nicaragua. Additional topics include health insurance for 65+, in-home nursing care, prescription medicines and more.

12 Expats Talk About Living in Nicaragua

Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more.

Moving to Nicaragua: 13 Things to Know Before You Move to Nicaragua

If you're thinking about moving to Nicaragua, you must read these 13 things to know before moving to Nicaragua. Expats offer realistic and honest advice about cost of living, learning the language, poverty, renting vs. buying and much more.

5 Tips for Living in Granada, Nicaragua

Expats love Granada, Nicaragua for its colonial architecture, rich history and thriving expat community. In this article, we cover cost-of-living in Granada, safety, real estate, health care and more.

12 Tips for Living in Granada, Nicaragua

12 Tips for Living in Granada, Nicaragua

An expat who retired in Granada, Nicaragua appreciates the low cost of living in Nicaragua, walking along Calle la Calzada, hanging out with other expats at the Cacao Pool Club and year-round warm climate.

Moving to Leon, Nicaragua

An expat who moved to Leon, Nicaragua talks about how she chose Leon, finding her first place to live with the help of a local real estate agency, getting advice from other expats before she moved and much more. She advises others to bring more sheets and towels, more pots and pans and to leave fancy, warm clothing and shoes at home.

Culture Shock in Managua, Nicaragua

An expat who recently moved to Managua, Nicaragua was initially overwhelmed by the country's extreme poverty. But, the loving, caring Nicas have had the greatest impact on her.

Living in Playa Miramar, Nicaragua

An expat in Nicaragua talks about life in the small fishing village of Playa Miramar. The village has 5 surf camps and about 1000 locals. If you're considering a move to Playa Miramar, you may want to start a business or non profit that gives back to the community.

Retirement in Granada, Nicaragua

Bushamy13 chose to retire to Nicaragua because of the low cost of living, the friendly people and the beautiful country. Bushamy13 says that a retiree can live like a Nica on $500 a month or buy your expansive colonial home and entertain lavishly. She lives on approximately $1500 a month, which does not include flights back home.

More Culture Shock Reports for Nicaragua

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in Nicaragua handle it can be very comforting. Below are some of the responses from expats in Nicaragua:
Submit a Culture Shock Report

More Living in Nicaragua Reports

What are people's priorities in Nicaragua - work? family? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in Nicaragua:
Submit a Living Overseas Report

More Moving to Nicaragua Reports

What should you take with you when you move to Nicaragua? What should you leave behind? What type of housing and neighborhoods are typical for expats in Nicaragua? Below are some of the responses from expats in Nicaragua:
Submit a Moving Overseas Report

Reviews of Schools in Nicaragua

Reviews and school profiles from expat parents and even a few school administrators in Nicaragua. Great place to find insight into school facilities, teachers and curriculum. Below are some of the reviews from expats in Nicaragua:
Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to Nicaragua. If you are already living in Nicaragua, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

Submit a Dream vs. Reality Report

Retiring in Nicaragua Reports

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in Nicaragua, by filling out our Overseas Retirement report. Below are some of the reports from expats in Nicaragua:
Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in Nicaragua? Help other expats who are preparing to have a baby in Nicaragua by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in Nicaragua? How difficult was it to obtain a work permit? What types are jobs are typical for expats in Nicaragua? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Additional Articles
5 Best Places to Retire in Nicaragua

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers.

A Year of Nicaraguan Festivals and Celebrations

From San Silvestre Papa in January to Tulululu in May, Nicaragua has more than 200 festivals each year. Casey Callais highlights the best festivals throughout the year.

Expat Nicaragua: Leon, Nicaragua - Some Like it Hot!

Dean LaCoursiere recently visited Leon and describes this wonderful city, a UNESCO historical site, where the temperature is typically above 90 degrees.

5 Great Places to Retire in Central America

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and friendly people.

Isla Ometepe Nicaragua, Your Fantasy Island!

The volcanic Isla Ometepe lies in the middle of Lake Nicaragua, the 10th largest freshwater lake in the world. It takes one hour by ferry to reach Isla Ometepe. In 2010 the island was declared a UNESCO Biosphere Preserve and within has varied terrain and microclimates.

10 Tips for Living in Nicaragua

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua.

World's Top Retirement Havens 1 Through 9

Where are the best places to retire overseas? Which retirement haven is right for you? France? Ecuador? Panama? Nicaragua? Thailand? Kathleen Peddicord shares the pros and cons of the world's top 9 retirement havens.

Nicaraguan Schools for Expats

Advice and overview of Nicaraguan schools for expat children.

Ten Things You Should Know Before You Move To Central or South America

Lee offers ten tips for people contemplating a move to Central or South America.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-ManaguaAn Expat Talks about Culture Shock & Living in Managua, Nicaragua

An expat who recently moved to Managua, Nicaragua was initially overwhelmed by the country's extreme poverty. But, the loving, caring Nicas have had the greatest impact on her.

An expat who recently moved to Managua, Nicaragua was initially overwhelmed by the country's extreme poverty. But, the loving, caring Nicas have had the greatest impact on her. ...

Living-in-Playa-MiramarAn Expat Discusses Living in Playa Miramar, Nicaragua

An expat in Nicaragua talks about life in the small fishing village of Playa Miramar. The village has 5 surf camps and about 1000 locals. If you're considering a move to Playa Miramar, you may want to start a business or non profit that gives back to the community.

An expat in Nicaragua talks about life in the small fishing village of Playa Miramar. The village has 5 surf camps and about 1000 locals. If you're considering a move to Playa Miramar, you may want ...

10-Tips-for-Living-in-Nicaragua10 Tips for Living in Nicaragua

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua.

Did you know that lots of homes in Nicaragua don't have hot water? Did you know that it's very easy to meet other expats in Nicaragua? Expats share their tips for living in Nicaragua. ...

5-Great-Places-to-Retire-in-Central-America5 Great Places to Retire in Central America

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and friendly people.

Central America is an increasingly popular retirement destination. Retirees love it's proximity to the United States, lower cost of living, beautiful cities, amazing beaches, healthy lifestyle and fr...

5-Best-Places-to-Retire-in-Nicaragua5 Best Places to Retire in Nicaragua

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers.

Expats discuss the best places to retire in Nicaragua. From upscale communities on the Emerald Coast to the beautiful city of Granada, Nicaragua is no longer just a haven for surfers....

12-Expats-Talk-About-Living-in-Nicaragua12 Expats Talk About Living in Nicaragua

Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more.
Expats in Nicaragua talks about living in Nicaragua - the high numbers of retirees, the kind and welcoming Nicas, the challenges they face learning the language and more....

Nicaragua 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 /expatguide.cfm
Time Stamp 30-May-20 09:42 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.151
Host Name 173.245.54.151


Execution Time

Total Time Avg Time Count Template
329 ms 329 ms 1 /home/www/html/expatguide.cfm
29 ms 29 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/navcontentbox.cfm
28 ms 28 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 1 ms 2 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 2 /home/www/html/rewritenetworkname.cfm
1 ms 0 ms 21 /home/www/html/rewriteqoptionsctry.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/eetr/rewriterealtorlink.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.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 16 /home/www/html/rewritearticle.cfm
0 ms 0 ms 21 /home/www/html/rewritecityname.cfm
0 ms 0 ms 21 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
334 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 @ 21:42:50.050
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 21:42:50.050
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getcities (Datasource=expert, Time=1ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select *
	From citynetworks
	Where networkID = 295
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select *
	From Networks
	Where networkID = 295 
getphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 295
	and guidephoto = 'yes'
	and twimg <> ''
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 21:42:50.050
	Select fbimg as guidephoto
	From countryphotos
	Where networkID = 295 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:42:50.050
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:42:50.050
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 21:42:50.050
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.151'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:42:50.050
	SELECT *
	From contentcountcountry
	Where networkid = 295 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 21:42:50.050
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:42:50.050
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gettaxgeneral (Datasource=expert, Time=5ms, Records=13) in /home/www/html/expatguide.cfm @ 21:42:50.050
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	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 publishdate < "2020-05-30"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:50.050
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Nicaragua' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 295 
         and city <> ''
         
   	 order by city, date DESC
         
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:50.050
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 295 
         and city <> ''
         
   	 order by city, date DESC
         
checkdreamfeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 295 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 295 
         and city <> ''
         
   	 order by city, date DESC
         
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and city <> ''
         
   	 order by city, date DESC
         
checkmovingfeaturereportarticle (Datasource=reports, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '1'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 295 
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 295 
   	 order by city, date DESC
         
checklivingfeaturereportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.article = '2'
         and rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
      
         and rptarticlenetworks.networkid = 295 
checklivingfeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 295 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=6) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 295 
   	 order by city, date DESC
         
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 295 
   	 order by city, date DESC
         
checkwork (Datasource=expert, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 295 
   	 order by city, date DESC
         
checkschool (Datasource=expert, Time=5ms, Records=4) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 295 
   	 order by city, date DESC
         
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:42:51.051
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 16
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:42:51.051
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getlivingphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT  hpimg
FROM rptarticles
where rptarticleID = 16
and hpimg <> ''
getrealestateadvice (Datasource=tipripper, Time=7ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=2) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42: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 = 9 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/expatguide.cfm @ 21:42: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 = 79615
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 79615 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 79615
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 79615
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79615'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79615'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 120868
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 120868
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 120868
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=6ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 120868
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 120868
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42: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 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79615 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'
getmarker (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT *
	FROM markers
	WHERE answerid = '79615'
	and lat <> ''
	and lng <> ''
checkstatus (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/rewriterealtorlink.cfm @ 21:42:51.051
SELECT *
FROM expertusers
WHERE userid = 120868
and startdate <{ts '2020-05-29 21:42:51'}
and enddate > {ts '2020-05-30 21:42:51'} 
getrestaurants (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42: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 = 7 
getanswerstext (Datasource=tipripper, Time=4ms, Records=3) in /home/www/html/expatguide.cfm @ 21:42: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 = 65925
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 65925 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 65925
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 65925
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65925'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65925'
	and qid = 391
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 35170
and answerstext.qid = 95
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 35170
and answerstext.qid = 96
and answerstext.answerid = answers.answerid
 
getauthorco (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 35170
and answerstext.qid = 97
and answerstext.answerid = answers.answerid
 
getauthorwebsite (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 35170
and answerstext.qid = 394
and answerstext.answerid = answers.answerid
 
getauthorphoto (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT DISTINCT answersphoto.photo, answers.userid
FROM answersphoto, answers 
WHERE answers.topicid = 12
and answers.userid = 35170
and answersphoto.qid = 99
and answersphoto.answerid = answers.answerid
 
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65925 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65925 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/expatguide.cfm @ 21:42:51.051
	SELECT *
	FROM markers
	WHERE answerid = '65925'
	and lat <> ''
	and lng <> ''
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74149 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 1488 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 46451 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26633 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 75911 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 27366 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 26634 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 21:42:51.051
	Select *
	From Networks
	Where networkID = 295 
getschoolname (Datasource=reports, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 26135
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 24249
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=3ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 13167
				AND answerstext.qid = 82
					
getschoolname (Datasource=reports, Time=4ms, Records=1) in /home/www/html/expatguide.cfm @ 21:42:51.051
				SELECT DISTINCT answerstext.answer
				FROM answerstext
				WHERE answerstext.answerid = 5276
				AND answerstext.qid = 82
					
checkculturefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 295 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 46451
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 295 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select summary, hiimg 
		FROM answers
         where answerid = 75911
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=3) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 295 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:42:51.051
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 16
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:42:51.051
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:42:51.051
SELECT  hiimg
FROM rptarticles
where rptarticleID = 16
and hiimg <> ''


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/expatguide.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/expatguide.cfm
QUERY_STRING=networkID=295
REMOTE_ADDR=173.245.54.151
REMOTE_HOST=173.245.54.151
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=28726420
cftoken=18077061
sessionid=IBEXPATEXCHANGE.COM_28726420_18077061
urltoken=CFID=28726420&CFTOKEN=18077061
URL Parameters:
networkID=295
Debug Rendering Time: 11 ms