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

Living in Nicaragua > Granada > 5 Tips for Living in Granada, Nicaragua

5 Tips for Living in Granada, Nicaragua

By Betsy Burlingame

Last updated on: Dec 10, 2016

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.

Granada, Nicaragua is a beautiful city with a colonial heritage. It's population is estimated at approximately 123,000 (according to Granada, Nicaragua on Wikipedia).

Expat Life in Granada, Nicaragua

"Life here [in Granada] has been good to us. What you really need to think about is what you will do when you get here. Successful expats reinvent their lives and do things that they have always wanted to do. We do some volunteer work, are active in our church and pursue interests we didn't have time for in our former life. We also travel a great deal. Central America is a great place to see. We live just fine. The restaurant food is so so, some good some bad. The availability is stores is great, imported food is expensive. We have found most of what we want. The grocery store we shop in, La Colonia, is one of the best run stores I have ever been in with a friendly, helpful staff. We go to Managua once a month for groceries and have a fun time," said an expat in Granada. Another expat said, "the expat commmunity is just starting to formalize groups and organizations though many expats work with the various non-profits to help Nicaragua and its people. Here in Granada we have Amigos de la Policia (to improve the rapport with the local police), Care Granada (works with city and mayor for improvement projects), Calzada Centro de Arte (people learn to paint or paint with other artists), Book Club (the usual monthly group to discuss books) and monthly luncheons to just get together."

Cost of Living in Granada, Nicaragua

"Live like a Nica on $500 a month or buy your expansive colonial home and entertain lavishly. We find we can live on around $1500 a month but emergencies do happen and that does not include flights back home. The world is different now with many things being fairly expensive now like gas, flights overseas, rising food costs, etc. Nicaragua is a cash society. We have no loans or credit card balances and it feels quite good. I go to the ATM when I need money and even pay utilities with cash. Owning our home eliminates the biggest bill, which is the rent. Food is the next greatest expense. It makes purchase decisions so much easier. If we do not have sufficient cash, we do not buy it," explained one expat in Granada. Another expat said, "you can live here very well on whatever income you have. We live in a middle class neighborhood for a fraction of what it would cost in the US or Canada."

Housing in Granada, Nicaragua

A real estate professional in Nicaragua advised, "the most common request I get is for home, apartment and room rentals. I suggest you come to Granada and stay at a hotel then you can go see the rental options. While there are rental agencies and property management companies, many of the rentals you can only find out by networking." She went on to provide an extensive list of real estate agencies in Granada.

Another expat warned, "the worst prices are found in the American owned companies. They sell properties that the owner is willing to sell at $15,000.00 for $50,000.00 I remember when I almost bought the historical home in Granada, old residence of General Chamorro. My friend Ramon Lopez r.i.p. the old owner of Hotel Granada owned it and offered it to me for $150,000.00. The American that bought it is asking over $1 Million. Don't go buying wooden nickels."

Health Care in Granada, Nicaragua

"One of the most modern hospitals in Central America is 45 minutes away. We do not have health insurance, which will shock many people, but the USA is one of very few countries without universal health care. We love our doctor who we feel is better than any doctor we have had in the states. He speaks English and we trust him completely. The office visit is $15. Medical costs are low enough to pay as you go. Our prescriptions are less than the co-pay amount was in the states. How can that be? They are the same drugs," commented one expat in Granada.

"The only health care professional we have used is a pharmacist. He is from El Salvador and speaks English. Great service at good prices. You don't need a script for most meds, only narcotics. We each take one med and it costs about one-fifth of what it would cost in the states. My husband saw a doctor once, good service and the office visit was $40 for taking off two bad skin spots. Many people go straight to a lab and if they think they have something just take the lab report to a pharmacist who can prescribe meds. No need for a doctor at all. Doctors here make house calls," said another expat.

Safety in Granada

"It is relatively safe and we have experienced less crime here than in the states. We use common sense such as using taxis after dark, not driving at night, etc. Having said that, Nicaragua is a poor country and there is more common theft. For example, if you lay your phone, iPod, laptop on your table at a restaurant and turn away, it will be gone. It is important to have good neighbors and to form friendships with them. Our home has never been robbed in the past five years here," explained one expat. Another expat living in Granada said, "our neighborhood is very safe, our neighbors are friendly and watch out for us, but you must practice common sense. Most of the crime is opportunistic crime and if you are walking home drunk and talking on your iphone at midnight, expect to invite trouble. We also avoid heavy tourist areas like La Calzada, which are magnets for crime. Be just as careful of expats as Nicas. Don't trust anyone you meet in a bar. Get to know people before you get too friendly. Most Nicas pride themselves on their honesty. I frequently hold out my hand with change and let vendors take their money, but I also am careful and take precautions. It is no different than anywhere else, you will learn what you need to do. The most dangerous place you will go is the road, any road, every road. Practice the most caution there."

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Granada

Healthcare in Nicaragua

Healthcare 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 Tips for Living in Granada, Nicaragua

12 Tips for Living in Granada, Nicaragua in Granada

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.

Join our Nicaragua Expat Forum

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

More about Nicaragua

Leon,-Nicaragua---Some-Like-it-Hot!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.

A-Year-of-Nicaraguan-Festivals-and-CelebrationsA 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.

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.

13-Things-to-Know-Before-You-Move-to-NicaraguaMoving 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.

About the Author

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

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

icaj
Jan 2, 2016 10:18

Wow - it all sounds wonderful. I am currently living and working as a university teacher in Istanbul and want to leave at the end of the academic year - july 2016. I have been teaching and travell?ng now for 8 years , as a solo 50+ teacher of Scottish extraction - and I would be grateful t hear about good language schools where I can LEARN Spanish and opportunities for teaching English - and most importantly are there swimming pools in Leon and tennis courts in Grenada ? and ex-pats of my age, who enjoy travelling, tennis, reading and learning about other cultures? Hope so - ?t all looks so pretty and peaceful.

Suziemiki
Dec 10, 2016 12:02

Hi, wonderful comments, as I too found Granada a friendly, helpful community. Loved the monthly street stage performances with its dancing and live music. Belonged to a expat group on Sundays that held a worship hour. Ran a Bnb and most tourists preferred Nicaragua to Costa Rica for its prices and friendliness.

First Published: Apr 08, 2015

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in GranadaGuide to Living in Granada

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.

Healthcare in NicaraguaHealthcare 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.

Restaurants in GranadaRestaurants in Granada

Support your favorite restaurants in Granada 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.

12 Tips for Living in Granada, Nicaragua12 Tips for Living in Granada, Nicaragua in Granada

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.

Leon,-Nicaragua---Some-Like-it-Hot!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.

A-Year-of-Nicaraguan-Festivals-and-CelebrationsA 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.

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.

13-Things-to-Know-Before-You-Move-to-NicaraguaMoving 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.

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 /lib_rd.cfm
Time Stamp 30-May-20 09:24 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
136 ms 136 ms 1 top level /home/www/html/lib_rd.cfm
56 ms 56 ms 1 /home/www/html/navcontentboxcitymobile.cfm
46 ms 46 ms 1 /home/www/html/navcontentboxcitypc.cfm
46 ms 46 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
46 ms 46 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/breadcrumb_ctygd.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
6 ms 6 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 4 /home/www/html/eetr/rewritetipheading.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/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 8 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
143 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:24:38.038
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 21:24:38.038
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 21:24:38.038
	Select *
	From articles
	Where articleID = 4546
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 21:24:38.038
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 21:24:38.038
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4546 
	and articles.articleID = 4546 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 21:24:38.038
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4546
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4546
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:24:38.038
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:24:38.038
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 295 
getcities (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 21:24:38.038
	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:24:38.038
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 21:24:38.038
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4546 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 21:24:38.038
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=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 21:24:38.038
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_ctygd2.cfm @ 21:24:38.038
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_ctygd2.cfm @ 21:24:38.038
	SELECT *
	From contentcountcountry
	Where networkid = 295 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 21:24:38.038
	SELECT *
	From contentcountcity
	Where citynetworkid = 4195 
citykeyimg (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 21:24:38.038
	SELECT *
	From countryphotos
	Where citynetworkid = 4195
	and keyimg <> ''
	and usekey = 'y'
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 21:24:38.038
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4546 
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 21:24:38.038
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4546 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=6ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 21:24:38.038
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 295 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 21:24:38.038
SELECT tag
FROM natadoptions 
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	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 = 4195
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and articles.articleID <> '4546'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 295 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4195
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
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=5ms, Records=3) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
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
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65925'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65925'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65925 
getphoto (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	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/navcontentboxcitymobile.cfm @ 21:24:38.038
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4195
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
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=6ms, Records=12) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
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
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79615'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79615'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79615 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 21:24:38.038
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 21:24:38.038
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4546 
gettaxgeneral (Datasource=expert, Time=4ms, Records=4) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 21:24:38.038
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 4546
    and publishdate < "2020-05-30"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 21:24:38.038
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
    and bannerPlacement.networkid = 295
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 21:24:38.038
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 21:24:38.038
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-05-29 21:24:38'}
    and fromDate <{ts '2020-05-30 21:24:38'}
    and weight > 7
    and bannerPlacement.networkid = 295
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 21:24:38.038
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-05-29 21:24:38'}
    and fromDate <{ts '2020-05-30 21:24:38'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 21:24:38.038
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=2) in /home/www/html/commentsnew_rdesign4.cfm @ 21:24:38.038
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4546 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 21:24:38.038
  SELECT *
  FROM users
  WHERE userid = 137947 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 21:24:38.038
  SELECT *
  FROM users
  WHERE userid = 103158 
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4195
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 295 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=11ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4195
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
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=3ms, Records=3) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
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
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65925'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65925'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 65925 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	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/navcontentboxcitypc.cfm @ 21:24:38.038
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'
gethealthcare (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 295
and allreports.networkid = 295
 and allreports.citynetworkid2 =  4195
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 @ 21:24:38.038
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 @ 21:24:38.038
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
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79615'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79615'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79615 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 21:24:38.038
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '295'


Scope Variables

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