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

Retire in Philippines > Prudential Village, Daliao, Davao City >

An Expat Talks about Retiring in Prudential Village, Daliao, Davao City, Philippines

Submitted by standupguy


A Canadian married to a Filipina appreciates the low cost of living in the Philippines, the beautiful weather, the friendly people and that he can afford to live in a house that is a 5 minute walk to the beach. The poverty and bar scene bother him.

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

Prudential Village, Daliao, Davao City

Why did you choose to retire abroad?

I can't afford the Canadian taxes, insurance, cost of living, real estate prices. I am married to a Filipina

Are you retired abroad all year or part of the year?

part of the year for now

Why did you choose the country you retired to?

I married a Filipina

Did you ever live abroad before you retired abroad?

No

How long have you lived abroad since you retired abroad?

3 years

How many countries (other than your home country) have you lived in as a retiree?

none

What have been the most challenging aspects of being retired abroad?

The lack of infrastructure, heat & humidity, stark grinding poverty, and the increase of price for Westerners

What have been the most rewarding aspects of being retired abroad?

An affordable 2 bedroom home 5 minute walk to the beach. Very minimal property tax. Cheap transportation and food costs. Friendly people. Loving wife. Not having cloudy, wet & cold weather. Not having to shovel snow and ice and pack firewood for my wood stove.

What would you do differently if you were just starting the retire abroad process?

Nothing

What is life like for a retiree in your city and its surroundings? (Is there an active expat community? Cultural Attractions? Recreation? Nightlife?)

Recreation is great for me as I am a swimmer. Nightlife is mostly at Hot Legs bars which offer temptations which are not supportive of my fidelity to my wife. A night out is mostly people watching or a restaurant meal.

What residency documents or visas did you need to obtain to retire in your host country? How difficult was this process? (Please describe)

6 month Visa from the Philippine Consulate in Vancouver. I will be applying for a non-quota immigrant visa when I return to my home in Nanaimo, BC

Did you buy a home or apartment, or rent one? Is this a difficult process? (Please describe)

Bought a nice 2 bedroom home, but the title had liens dating back to 1965 so it was not conveyed. We have a lawyer working on that who will petition the court to expunge these encumbrances and issue a new clean title.

Financially, has living abroad in your host country met your expectations? Exceeded them?

It has met them.

What are the most important financial considerations for retiring to your host country?

Avoiding the mark up for Westerners.

How much can a retiree live on comfortably in your host country?

For Air conditioning, internet, phone, cable TV, water, tax, transportation, pharmacy, food and hardware, and all extras cost me $1200 Canadian dollars a month.

Do you have access to quality medical care? (Please describe - is it close? Expensive?)

Yes. A doctor appointment costs $8.

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

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

Is there a lot of crime where you live? (Please describe)

There are scams in bars, and some places I would not walk at night. I avoid the Muslim areas. I am not easily intimidated. Foreigners cannot own guns. But my wife can. Our house has very effective perimeter security.

Describe available transportation where you live. Do you need a car? Is there access to safe public transportation?

Cabs are very cheap. A round trip to Davao centre costs about $10. I don't ride Jeepneys. Tricycles are $1-$1.50. Airline tickets are cheap if you shop around. Always take extra money for airport tax.

Is there high-speed internet access where you live?

yes and full line up of TV channels.

Do you have any other thoughts you would like to share about retiring abroad?

The life here is somewhat chaotic and unorganized. I miss the clean streets and organized living of Canada. I find the poverty disturbing. The Filipino men can be abusive to their wives and drink way too much alcohol. Last week an out of town family group abandoned a little 4 year old girl where we sit at the beach. She didn't even have clothes. That bothers me.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Prudential Village, Daliao, Davao City

Healthcare in Philippines

Healthcare in Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Moving to Davao

An expat in the Philippines talks about what it's like moving to Davao City. He wishes he had brought his golf clubs and shoes and left his scuba gear at home (no fish, no corals). He offers great advice about the pros and cons of typical types of expat housing.

Living in Davao

An expat who has lived in Davao, Philippines for 10 years says that life in Davao revolves around socializing, eating, drinking and living a nice and happy life -- in and surrounded by nature. Although there is some work to be found in Davao, he explains that it's best to have remote Internet-based work from outside the country.

Join our Philippines Expat Forum

Visit our Philippines Forum and talk with other expats who can offer you insight and tips about living in Prudential Village, Daliao, Davao City, Philippines.

More about Philippines

6-Best-Places-to-Live-in-The-PhilippinesExpat Philippines: 6 Best Places to Live in The Philippines

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Philippines.

9-Healthcare--Health-Insurance-Tips-for-Expats-in-the-Philippines9 Healthcare & Health Insurance Tips for Expats in the Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

8-Safest-Places-to-Live-in-the-Philippines8 Safest Places to Live in the Philippines

With the rise of terrorism in certain parts of the Philippines, expats in the Philippines helped us compile a list of safe places to live in the Philippines. Here are 8 of the safest expat destinations in the Philippines.

7-Things-to-Know-Before-You-Move-to-the-PhilippinesMoving to the Philippines: 7 Things to Know Before You Move to the Philippines

Expats moving to the Philippines join others that have moved there for work or a lower cost of living during retirement. It's critical to understand what the realities of living there are, but those that successfully make the adjustment believe it is a good place to live.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment

Comments about this Report

garywigle
Dec 30, 2013 19:07

Sorry about your title. You most likely never get a clean title and thus you don't own the house and land. Alway rent a few years before buying a house in the Philippines. I live in Tagum City just 55 km northeast of Davao and like it fine. I have the 13a visa. You can get yours in Davao. I don't see the "white" tax like you do. Of course I let my wife do the shopping.

Jackhfrost48
Jan 26, 2014 22:12

Is there anyone who can give me some more information about this village and rentals, and people and the cost of living for an American. Thanks Jack

paradive
May 3, 2014 22:20

any advice you can give on shopping around for retirement packages? not insurance policies. i mean as far as including a house and whatnot.

guest
Jan 15, 2015 11:59

Thanks for taking the time to write this. I can certainly appreciate all that you addressed here. I am going back to Cagayan De Oro in April to live with my fiancee-not married yet....yikes!-ha!...I have 2 previous visits to the Philippines. I have heard and read that Davao is a fairly safe city with good governance. I met a guy at LAX-U.S.- 2 years ago that has a ranch 40 minutes outside of the city. His wife is a prolific poster on face book so I have seen the beautiful gardens, etc...Bet the seafood is great and 5 minutes from the beach-wow!...Nice...What happened to the little girl? OH MY!.... Mark

WOODS096
Jun 11, 2015 10:18

So sad about the 4 year old girl on the beach. I would like to retire in 2 years with my philipina wife. We are currently living in the US.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in PhilippinesHealthcare in Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Restaurants in Prudential Village, Daliao, Davao CityRestaurants in Prudential Village, Daliao, Davao City

Support your favorite restaurants in Prudential Village, Daliao, Davao City 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.

Moving to Davao

An expat in the Philippines talks about what it's like moving to Davao City. He wishes he had brought his golf clubs and shoes and left his scuba gear at home (no fish, no corals). He offers great advice about the pros and cons of typical types of expat housing.

Living in Davao

An expat who has lived in Davao, Philippines for 10 years says that life in Davao revolves around socializing, eating, drinking and living a nice and happy life -- in and surrounded by nature. Although there is some work to be found in Davao, he explains that it's best to have remote Internet-based work from outside the country.

6-Best-Places-to-Live-in-The-PhilippinesExpat Philippines: 6 Best Places to Live in The Philippines

With its low cost of living, beautiful beaches, bustling cities and hot climate, expats have been flocking to the Philippines for years. Here are six of the best places for expats to live in the Philippines.

9-Healthcare--Health-Insurance-Tips-for-Expats-in-the-Philippines9 Healthcare & Health Insurance Tips for Expats in the Philippines

Expats in the Philippines have a lot to say about the quality of medical care, hospitals, prescription medicine availability and health insurance in the Philippines.

Philippines Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rspnet.cfm
Time Stamp 13-Jul-20 06:26 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.62.46
Host Name 172.69.62.46


Execution Time

Total Time Avg Time Count Template
93 ms 93 ms 1 top level /home/www/html/rspnet.cfm
27 ms 27 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
20 ms 20 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
19 ms 19 ms 1 /home/www/html/navcontentboxcitypc.cfm
19 ms 19 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/navmpu_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
6 ms 6 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
5 ms 5 ms 1 /home/www/html/breadcrumb_ctygd.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.cfm
0 ms 0 ms 4 /home/www/html/rewritecityname.cfm
0 ms 0 ms 4 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 4 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
100 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 @ 18:26:41.041
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=4ms, Records=1) in /home/www/html/Application.cfm @ 18:26:41.041
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 18:26:41.041
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 96
AND networkid = 90 
AND 64852 = answerid

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

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

AND answers.answerid = 64852 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 18:26:41.041
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 64852 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:26:41.041
	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 @ 18:26:41.041
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/navmeta_rdesign4.cfm @ 18:26:41.041
	Select *
	From citynetworks
	Where networkID = 90
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:26:41.041
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
GetMessages (Datasource=forum, Time=1ms, Records=5) in /home/www/html/navmeta_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 64852 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 18:26:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-04-13"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 18:26:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-07-13 00:00:00.000"
and logtime < "2020-07-13 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 @ 18:26:41.041
SELECT *
FROM tracking
WHERE ipaddress = '172.69.62.46'
and logtime > "2020-07-06"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 18:26:41.041
	SELECT *
	From contentcountcountry
	Where networkid = 90 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 18:26:41.041
	SELECT *
	From contentcountcity
	Where citynetworkid = 5624 
getarticlesection (Datasource=expert, Time=0ms, Records=25) in /home/www/html/breadcrumb_ctygd.cfm @ 18:26:41.041
SELECT *
FROM articleCategories
 
WHERE section = 11
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 18:26:41.041
		Select *
		FROM allreports, citynetworks
         where answerid = 64852
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getretireintro (Datasource=expert, Time=4ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 18:26:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	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 = '11'
    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-07-13"

    ORDER by articles.articleID asc   
    
user (Datasource=forum, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 81429 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 18:26:41.041
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 64852 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
	Select *
	From Networks
	Where networkid = 90 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 90
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 90
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
	Select *
	From Networks
	Where networkid = 90 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:26:41.041
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 90
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-12"
and natsentencestart < "2020-07-13"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
gettaxgeneral2 (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
	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 = 5624
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-13" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 90 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 90 
         and allreports.answerid <> 64852 
          and citynetworkid = 5624
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75746 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
            
         and allreports.answerid <> 64852         
         and networkid = 90
          and citynetworkid = 5624
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 72366 
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 90 
         and allreports.answerid <> 64852         
          and citynetworkid = 5624
         and city <> ''
         order by date DESC
gettaxgeneral (Datasource=expert, Time=5ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 18:26:41.041
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	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-13"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 18:26:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
    and bannerPlacement.networkid = 90
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 18:26:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 18:26:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-12 18:26:41'}
    and fromDate <{ts '2020-07-13 18:26:41'}
    and weight > 7
    and bannerPlacement.networkid = 90
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:26:41.041
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-12 18:26:41'}
    and fromDate <{ts '2020-07-13 18:26:41'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:26:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=5) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 64852 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 41801 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 83787 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 90512 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 18:26:41.041
  SELECT *
  FROM users
  WHERE userid = 113864 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 90 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 64852         
         and networkid = 90
          and citynetworkid = 5624
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75746 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
            
         and allreports.answerid <> 64852         
           and city <> ''
         and networkid = 90
          and citynetworkid = 5624
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 72366 
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 18:26:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
            
         and allreports.answerid <> 64852         
         and networkid = 90
          and citynetworkid = 5624
         and city <> ''
         order by date DESC


Scope Variables

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