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

12 Tips for Living in Rio Chico, Ecuador

By kfgosl

An expat talks about what life is like in Rio Chico, Ecuador, a small beach town about 10 minutes from Montanita. With 12 hours of sunlight every day, beautiful beaches and terrific local shops, life in Rio Chico sounds wonderful.

12-Tips-for-Living-in-Rio-Chico,-Ecuador

Expat Life in Rio Chico

The coast of Ecuador has miles of beautiful beaches, with mild temperatures and no hurricanes! Ecuador uses the US dollar so there is no fear of currency fluctuations and the cost of living is easy on the wallet.

Cost of Living in Rio Chico, Ecuador

There is a wide variety of housing available on the Coast. In my little stretch of beach, expats can purchase a home in a gated community starting at just $125K and going up to $285K for an amazing 3 bedroom home with a pool. Rentals are anywhere from $600 and up depending upon amenities. Taxis and food are inexpensive and good.

Local Clubs and Organizations

Many of the expats in my area are actively involved with the local orphanage which houses about 80 children. You can find information about it at www.fosmo.me where you can also donate. There is a Rotary Club in nearby Salinas. I belong to 2 book clubs and there are several card playing clubs.

International Schools in Rio Chico

Sorry. Nothing close to my area.

Shopping in Rio Chico

Local shops are terrific for produce, meats and most every day needs. It's like shopping in the US years ago with one shop just for meat and another for fish, etc. Many expats make the trek into Salinas to shop at the big box grocery stores or the mall at least once a month for those hard to get items.

Public Transportation

The bus to Salinas is $1.50 from Montanita area or half that for seniors. The express bus (CLP) to Guayaquil is a pleasant 3 hour trip for $6 in a reserved seat with AC and movies. Taxis are reliable and cheap. I have never felt unsafe on the bus or taxi but then I don't travel late a night and I am careful with belongings.

Climate

On the equator, we get sunrise at 6:30am and sunset at 6:30pm all year long. We are semi arid with cloudy days and some rain from May to December. Our warmest and sunniest days are Christmas to Easter. I use the AC in bedrooms during those months, but the ocean breeze is sufficient for the rest of the year.

Restaurants and Nightlife

Montanita is the nightlife spot about 10 minutes from me. Lots of young people use the 2 or 3 dance clubs in town. All along the Coast are great little seafood shacks. Near me are also Thai, Peruvian, Mexican, Italian and American style restaurants.

Health Care Facilities in Rio Chico, Ecuador

There is an emergency clinic 5 minutes from my house but the hospitals are in Salinas (45 minutes) or Guayaquil (3 hours) away. Fortunately, I've not had much need for health care but my friends and neighbors have been very pleased at both the quality and the price of procedures here. Although you can find English speaking doctors, it really helps in crisis situations to speak Spanish.

Expat Health Insurance in Ecuador

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

Recreational Activities in Rio Chico

There are miles of gorgeous beaches, what more can anyone want? Surfing is possible year round here as is scuba and snorkeling. Golf is a couple of hours north outside Manta.

Residency and Visa Requirements

The latest residency visas are a two year temporary deal that can then be exchanged for a permanent one. Rules for qualifying stayed the same as when I came 3 years ago, but the temporary visa was a new idea instituted in 2017. The requirements of background checks and proof of ability to support yourself are pretty straightforward. Canadians have had good luck at getting visas before they arrive but most expats I know have used an expediting service or lawyer since the actual rules can change.

Crime in Rio Chico, Ecuador

I just read an article that listed the US as the 36th most dangerous country and Ecuador was around 95th. Mostly, we hear about petty crime. The local communities tend to police crime on their own and violent crime is not tolerated. Shopping the cities especially at Christmas requires more vigilance, but for the most part crime is not a worry at all.

Talk with Expats in Ecuador

If you're not involved in our Ecuador Forum, it's a great place to meet others in your area, get answers to questions about moving to Ecuador or offer advice to a newcomer.

More about Ecuador

10-Tips-for-Living-in-Ecuador

Expat Ecuador: 10 Tips for Living in Ecuador

Expats in Ecuador appreciate the cost of living, the friendly people, the beautiful weather and warm culture. The bureaucracy can be very trying, petty theft an issue and driving downright dangerous. But, if you ask most expats who are retired or working in Ecuador, they don't regret the move to Ecuador.

Expats in Ecuador appreciate the cost of living, the friendly people, the beautiful weather and warm culture. The bureaucracy can be very trying, petty theft an issue and driving downright dangerous....

Thanksgiving-in-Ecuador

Thanksgiving in Ecuador

For American expats looking to dine out on Thanksgiving, here's a list of several restaurants offering Thanksgiving dinners in Quito and Cuena.

For American expats looking to dine out on Thanksgiving, here's a list of several restaurants offering Thanksgiving dinners in Quito and Cuena. ...

Top-10-Reasons-to-Consider-Ecuador-for-Your-Retirement

Top 10 Reasons to Consider Ecuador for Your Retirement

Retirees in Ecuador enjoy an incredible number of benefits in their expat life abroad. Here are ten of the best reasons to consider this South American country when you look abroad for retirement.

Retirees in Ecuador enjoy an incredible number of benefits in their expat life abroad. Here are ten of the best reasons to consider this South American country when you look abroad for retirement....

Ecuador-Check-In-and-Help-Needed-Thread

Ecuador Check-In and Help Needed Thread

The earthquake in Ecuador has impacted many areas where our members reside. Our thoughts and prayers are with everyone in Ecuador. We have setup a Check-In and Help Needed thread for our members in Ecuador.

The earthquake in Ecuador has impacted many areas where our members reside. Our thoughts and prayers are with everyone in Ecuador. We have setup a Check-In and Help Needed thread for our members in ...

Comments & Questions

Sign In or Sign Up to reply

Cigna Expat Health InsuranceExpatriate Health Insurance

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

17-Tips-from-Expats-about-Moving-to-Ecuador17 Tips from Expats about Moving to Ecuador

We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador.
We asked expats in Ecuador for advice for newcomers. From cost of living to what to bring to culture shock, their insight is a must read for anyone thinking about moving to Ecuador. ...

Moving-to-EcuadorMoving to Ecuador: Tips for Newcomers in Ecuador

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and relocation advice and much more!

When it comes to getting an insider's perspective on expat life in Ecuador, our Ecuador network is the place to post! With hundreds of posts each month, members cover current events, moving and reloc...

Expat-LifeInternational Schools in Ecuador

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador.

From the American School of Quito to Acadamia Cotopaxi, we cover the most popular international schools in Ecuador. ...

Expat-Advice-Expat Advice about Crime & Safety in Ecuador

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador.

Advice from Expats in Ecuador about Safety, Security and Crime in Ecuador....

Retirement-In-CuencaAn Expat Shares What it's Like Retiring in Cuenca, Ecuador

A retiree talks about what it's like living in Cuenca, Ecuador - she enjoys the slower pace of living, lower cost of living, climate and that she has friends from all over the world.

A retiree talks about what it's like living in Cuenca, Ecuador - she enjoys the slower pace of living, lower cost of living, climate and that she has friends from all over the world. ...

Moving-To-SalinasAn Expat Talks about Moving to Salinas, Ecuador

An expat talks about moving to Salinas, Ecuador - the lower cost of living, beach life and what to bring to make it feel like home.

An expat talks about moving to Salinas, Ecuador - the lower cost of living, beach life and what to bring to make it feel like home....

Ecuador 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 /eetr/tip.cfm
Time Stamp 10-Jul-20 11:50 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.68.65.192
Host Name 172.68.65.192


Execution Time

Total Time Avg Time Count Template
311 ms 311 ms 1 /home/www/html/eetr/tip.cfm
288 ms 288 ms 1 /home/www/html/eetr/Application.cfm
97 ms 97 ms 1 /home/www/html/navtop_rdesign5.cfm
90 ms 90 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
30 ms 30 ms 1 /home/www/html/eetr/tiprentalproperty.cfm
18 ms 18 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
17 ms 17 ms 1 /home/www/html/navcontentbox.cfm
17 ms 17 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctrygd_readnext.cfm
5 ms 5 ms 1 /home/www/html/eetr/navgettiplinkproperty.cfm
4 ms 4 ms 1 /home/www/html/eetr/rewritetipheadingstate.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.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/eetr/constants.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 2 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritealtimage.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
0 ms 0 ms 7 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
599 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 23:50:05.005
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=286ms, Records=1) in /home/www/html/eetr/Application.cfm @ 23:50:06.006
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportcityid (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	Select citynetworkid2
	From allreports
	Where answerid = 80407 
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	Select *
	From citynetworks 
	Where citynetworkid = 8322 
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=0ms, Records=8, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	Select *
	From citynetworks
	Where networkID = 39
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=32ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, sitecategories.categoryslug, allreports.statenetworkid, allreports.topicid, allreports.city, sitecategories.headingnav, allreports.topicid as topicid, allreports.state, allreports.rid
FROM allreports, sitecategories
WHERE allreports.answerid = 80407 
and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassified (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, Networks.networkid, Networks.shortname, Networks.networkname, citynetworks.shortname, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports, Networks, citynetworks
WHERE rid = 100
and allreports.answerid = 80407
and allreports.statenetworkid = Networks.networkid
and allreports.citynetworkid = citynetworks.citynetworkid
GetClassified (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.topicid as topicid, allreports.city, allreports.state, allreports.answerid, allreports.topicid 
FROM allreports
WHERE rid = 100
and allreports.answerid = 80407 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
SELECT *
FROM topics

WHERE topicid = 11 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/navgettiplinkproperty.cfm @ 23:50:06.006
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 23:50:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80407'
	and qid = 391
	
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	SELECT DISTINCT hpimg as photo, fbimg
	FROM answers
	WHERE answerid = 80407 
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	SELECT DISTINCT summary
	FROM answers
	WHERE answerid = 80407 
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80407 
	AND answerstext.qid = 83
	
getsummary (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 23:50:06.006
	SELECT summary 
	FROM answers
	WHERE answerid = 80407 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 23:50:06.006
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-04-10"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 23:50:06.006
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-10 00:00:00.000"
and logtime < "2020-07-10 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 @ 23:50:06.006
SELECT *
FROM tracking
WHERE ipaddress = '172.68.65.192'
and logtime > "2020-07-03"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 23:50:06.006
	SELECT *
	From contentcountcountry
	Where networkid = 39 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 23:50:06.006
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-09"
    and fromDate < "2020-07-10"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 23:50:06.006
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertycountries (Datasource=tipripper, Time=24ms, Records=130) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=2ms, Records=8) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
SELECT allreports.tipcategory, allreports.tipcategoryid, topicid
FROM allreports
WHERE rid = 100
AND allreports.networkid = 39
group by allreports.tipcategoryid 
CheckTrackings (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
  SELECT t.tpcid, tk.tpcid as tpcid, tk.trackingdate, tk.trackingtype, tk.trackingid, tk.dbname, tk.shared, tk.userid
  FROM commenttrackings tk, comments t 
  WHERE tk.tpcid = 80407
  and t.tpcid = 80407
  and tk.commenttype = 9
  AND tk.trackingtype = "S"
  AND tk.userid = "2"
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
SELECT *
FROM topics
WHERE topicid = 11 
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80407
	AND answerstext.qid = 391
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
SELECT userphoto, tipcount, username, aboutme 
FROM users
WHERE userid = 128279 
GetUserProfile (Datasource=forum, Time=114ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
  SELECT *
  FROM userprofiles
  WHERE userid = 128279 
getbrief (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80407
	AND answerstext.qid = 392
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	SELECT DISTINCT hpimg as photo, tiplibraried, hpimg
	FROM answers
	WHERE answerid = 80407 
getcategory (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = 80407
	AND answerstext.qid = 390
getmostpostsreply (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tip.cfm @ 23:50:06.006
  SELECT msgtext, m.msgdate as commentdate, msgid, userid
  FROM comments m 
  WHERE m.tpcid = 80407
  and m.commenttype = 9
  and m.isapproved = 1
  ORDER BY m.msgid DESC
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
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 = 80407
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 80407 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getanswerstext2 (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT topicquestions.question, answerstext.answer
FROM answerstext, topicquestions, answers
WHERE answerstext.answerid = 80407
AND topicquestions.topicid = answers.topicid
AND answers.answerid = 80407
GROUP BY answerstext.aid
ORDER BY topicquestions.order ASC
checkifexpert (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.startdate <{ts '2020-07-09 23:50:06'}
and expertusers.enddate > {ts '2020-07-10 23:50:06'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
checkexpertexpired (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT answers.answerid, answers.userid, allreports.citynetworkid, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.tiptitle, sitecategories.categoryslug, sitecategories.headingnav, allreports.enddate
FROM expertusers, expertnetworks, answers, allreports, sitecategories
WHERE expertusers.enddate <{ts '2020-07-10 23:50:06'}
and expertnetworks.userid = answers.userid
and answers.topicid = 12
and answers.userid = 128279
and answers.reviewed = 'y'
and expertusers.userid = answers.userid
and allreports.answerid = answers.answerid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
getexpatusername (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT username
FROM users
WHERE userid = 128279 
getauthorfirst (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 95
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getauthorlast (Datasource=tipripper, Time=7ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
SELECT DISTINCT answerstext.answer, answers.userid
FROM answerstext, answers 
WHERE answers.topicid = 12
and answers.userid = 128279
and answerstext.qid = 96
and answers.reviewed = 'y'
and answerstext.answerid = answers.answerid
 
getmarker (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tiprentalproperty.cfm @ 23:50:06.006
	SELECT *
	FROM markers
	WHERE answerid = '80407'
	and lat <> ''
	and lng <> ''
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
	Select *
	From Networks
	Where networkid = 39 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 39
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-09"
and headerparagraphstart < "2020-07-10"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high' or headerparagraphweight = 'low')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
	Select *
	From Networks
	Where networkid = 39 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=1ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 39
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-09"
and headerparagraphstart < "2020-07-10"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high' or headerparagraphweight = 'low')
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 23:50:06.006
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 39
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-09"
and headerparagraphstart < "2020-07-10"
and headerparagraphstatus = 'live'
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/rspnet_ctrygd_readnext.cfm @ 23:50:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 39 
	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-07-10"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-10"
     
         and rptarticlenetworks.networkid = 39 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:50:06.006
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 1
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 23:50:06.006
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
SELECT  hiimg
FROM rptarticles
where rptarticleID = 1
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 39 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-10"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 39 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
		Select summary, hiimg 
		FROM answers
         where answerid = 75944
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 39 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 23:50:06.006
		Select summary, hiimg 
		FROM answers
         where answerid = 76175
         and summary <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/eetr/tip.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/eetr/tip.cfm
QUERY_STRING=answerid=80407&networkid=39&topicid=11&slug=ecuador&slug2=12-Tips-for-Living-in-Rio-Chico-Ecuador
REMOTE_ADDR=172.68.65.192
REMOTE_HOST=172.68.65.192
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tip.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=31661999
cftoken=27635869
hitcount=1
lastvisit={ts '2020-07-10 23:50:05'}
timecreated={ts '2020-07-10 23:50:05'}
urltoken=CFID=31661999&CFTOKEN=27635869
Cookie Variables:
CFID=31661999
CFTOKEN=27635869
Session Variables:
cfid=31661999
cftoken=27635869
sessionid=IBEXPATEXCHANGE_31661999_27635869
urltoken=CFID=31661999&CFTOKEN=27635869
URL Parameters:
answerid=80407
networkid=39
slug=ecuador
slug2=12-Tips-for-Living-in-Rio-Chico-Ecuador
topicid=11
Debug Rendering Time: 11 ms