Home Ecuador Forum Ecuador Guide Moving to Ecuador Real Estate Healthcare in Ecuador
Ecuador
Resources
City Guides
JoinSign In
Cigna International Health Insurance
Real Estate Listings Property Advice Local Experts
Add a Property Listing

House for Sale

House for Sale in Vilcabamba, Ecuador

Vilcabamba, Ecuador

5 Bedroom / 4 Full Bath / Half Bath

Furnished

Price: $ 249,000

Living Space: 3000 sqf

Website:

About the Property

Prime area of Cucanama, Vilcabamba on one lot- what is half hectare, 5000 m2 two quality homes for sale. Both homes are well built with owner constant supervision. Both home has private separate electric and water services, separate driveways and gates, fenced totally separate. Main House sits on about 2500 m2 fenced lot. Newer construction, built in 2016, american standard, open floor, exposed wooden cathedral ceiling 160 m2. 3 bed/2 bath, cozy living and family room,spacious kitchen with granite counter. Fully furnished,ready to move in, everything is newer furniture, washer-dryer, gas stove, refrigerator, orthopedic mattresses, bedding. all bedrooms have giant built in wooden closets. Manicured inside and outside. Built with natural material such as wood and brick, covered patios around the home. Astonishing panoramic view with privacy. More fruit trees such as avocado, lemon, orange, banana, nispero, papaya on property, 3 covered carport and 2 storages.. THE 2nd HOME is 7 years old sits on 2500 m2 land 3 bed/ 2 bath about 120m2, walk in closets, covered patio all around. Very private, surrounded with nice neighbors. 1 covered garage and 2 chicken coops, two storages. 150 m hand made stone wall and fence around property. More than 100 mature fruit trees banana, orange, lemon, avocado, guaba, nispero, mulberries, cacao,macadame and others. BOTH PROPERTIES FENCED SEPARATE, there is about 50 m distance between the two homes. Both has separate electric meters , private gates and driveways, sharing about 50-50%o the land size. If you looking for a place where you can live ,walk and even go for longer vacation, this safe community is for you (without community fees) A must to see! Retire in Ecuador in the famous sacred valley of Vilcabamba. Your home is ready just bring your personals. The second home can be a good rental income or if you have bigger family they can live close to you. do NOT contact me with unsolicited services or offers

All rooms have giant wooden closets. The house built with natural materials such us wood and brick and with the owner constant supervision. All windows has mosquito screens and window coverings. Double, covered parking space and covered patios around the house. Mature fruit trees such as lemon, oranges, mandarin, nispero, mango and banana. The property lays on a 2500 m2 fenced lot with amazing panoramic views. 8 minutes drive to the center of Vilcabamba. Close enough when need to go but far enough from the noise of it. If you looking for quality, safe and private place to live, walk or even go for long vacations, this home is for you. Requires at least 3 months rent contract.

Interested in this Property?

If you are would like to have the property owner or broker contact you, please submit your contact information below. We will only share your contact information with that owner or broker.

Name:

E-mail:

Telephone:

Security Question: 2+7 =

Message:

Yes, I would like to have the property owner or broker associated with this listing contact me. I understand that Expat Exchange will share my contact information with that owner or broker.
No, please do not have the property owner or broker associated with this listing contact me.

  

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 28-May-20 03:12 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.68
Host Name 162.158.78.68


Execution Time

Total Time Avg Time Count Template
292 ms 292 ms 1 /home/www/html/eetr/tip.cfm
290 ms 290 ms 1 /home/www/html/eetr/Application.cfm
122 ms 122 ms 1 /home/www/html/navtop_rdesign5.cfm
116 ms 116 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
102 ms 102 ms 1 /home/www/html/eetr/tiprentalproperties_included.cfm
32 ms 32 ms 1 /home/www/html/navcontentbox.cfm
32 ms 32 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
32 ms 32 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/eetr/navgettiplink.cfm
10 ms 5 ms 2 /home/www/html/eetr/rewritetipheadingstate.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/navleadproperty.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/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/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
0 ms 0 ms 3 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
583 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 @ 15:12:42.042
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 15:12:42.042
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
	Select *
	From citynetworks
	Where networkID = 39
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 39 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
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=35ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
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 @ 15:12:42.042
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 = 80557 
and "2020-05-28" < enddate

and sitecategories.tipcategoryid = allreports.tipcategoryid
GetClassifieds (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT *
FROM allreports
WHERE answerid = 80557
and "2020-05-28" < allreports.enddate
GetClassified (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT allreports.networkname, allreports.networkid, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, answers.paid, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkid
FROM allreports, answers
WHERE allreports.answerid = 80557
and hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-05-28" < allreports.enddate
getholdinfo (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT *
FROM holdcomments
WHERE answerid = 80557 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT *
FROM topics

WHERE topicid = 6
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 15:12:42.042
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 15:12:42.042
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
getlocationtag3 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/navgettiplink.cfm @ 15:12:42.042
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '422'
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	and qid = 391
	
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
 	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 15:12:42.042
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:12:42.042
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-02-27"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:12:42.042
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-05-28 00:00:00.000"
and logtime < "2020-05-28 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 15:12:42.042
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.68'
and logtime > "2020-05-21"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 15:12:42.042
	SELECT *
	From contentcountcountry
	Where networkid = 39 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 15:12:42.042
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-27"
    and fromDate < "2020-05-28"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 15:12:42.042
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getpropertycountries (Datasource=tipripper, Time=24ms, Records=130) in /home/www/html/eetr/tip.cfm @ 15:12:42.042
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 @ 15:12:42.042
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 @ 15:12:42.042
  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 = 80557
  and t.tpcid = 80557
  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 @ 15:12:42.042
SELECT *
FROM topics
WHERE topicid = 6 
getpropertycountries (Datasource=expert, Time=7ms, Records=36) in /home/www/html/eetr/tip.cfm @ 15:12:42.042
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE (rid = 67 or rid = 66)
AND "2020-05-28" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getprice (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80557'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80557'
AND answersmc.qoid = qoptions.qoid
getcontactname (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 49
getcontactemail (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 50
getcontactwebsite (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 394
getcontacttel (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 403
getlongdescription (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80557'
	AND answerstext.qid = 129
gettour1 (Datasource=tipripper, Time=14ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
gettour2 (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '105'
	AND answersphoto.photo <> 'none'
gettour3 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '106'
	AND answersphoto.photo <> 'none'
gettour4 (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
 	AND answersphoto.qid = '107'
	AND answersphoto.photo <> 'none'
gettour5 (Datasource=tipripper, Time=2ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '108'
	AND answersphoto.photo <> 'none'
gettour6 (Datasource=tipripper, Time=2ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '109'
	AND answersphoto.photo <> 'none'
gettour7 (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '110'
	AND answersphoto.photo <> 'none'
gettour8 (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '111'
	AND answersphoto.photo <> 'none'
gettour9 (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '112'
	AND answersphoto.photo <> 'none'
gettour10 (Datasource=tipripper, Time=1ms, Records=0) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80557'
	AND answersphoto.qid = '113'
	AND answersphoto.photo <> 'none'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tiprentalproperties_included.cfm @ 15:12:42.042
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '39'
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 15:12:42.042
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-28"
     
         and rptarticlenetworks.networkid = 39 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:12:42.042
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 1
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 15:12:42.042
	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 @ 15:12:42.042
SELECT  hiimg
FROM rptarticles
where rptarticleID = 1
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 15:12:42.042
	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-05-28"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=8ms, Records=4) in /home/www/html/navcontentbox.cfm @ 15:12:42.042
		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 @ 15:12:42.042
		Select summary, hiimg 
		FROM answers
         where answerid = 75944
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 15:12:42.042
		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 @ 15:12:42.042
		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=80557&networkid=39&topicid=6&slug=ecuador&slug2=House-for-Sale-in-Vilcabamba-Ecuador
REMOTE_ADDR=162.158.78.68
REMOTE_HOST=162.158.78.68
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=28592798
cftoken=92503972
hitcount=1
lastvisit={ts '2020-05-28 15:12:42'}
timecreated={ts '2020-05-28 15:12:42'}
urltoken=CFID=28592798&CFTOKEN=92503972
Cookie Variables:
CFID=28592798
CFTOKEN=92503972
Session Variables:
cfid=28592798
cftoken=92503972
sessionid=IBEXPATEXCHANGE_28592798_92503972
urltoken=CFID=28592798&CFTOKEN=92503972
URL Parameters:
answerid=80557
networkid=39
slug=ecuador
slug2=House-for-Sale-in-Vilcabamba-Ecuador
topicid=6
Debug Rendering Time: 10 ms