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

Retire in Vietnam > Ho Chi Minh >

An Expat Talks about Retiring in Ho Chi Minh, Vietnam

Feb 04, 2019


Ho Chi Minh, Vietnam

A retiree in Ho Chi Minh city talks about returning to Vietnam after serving there during the war. The cost of living, friendly Vietnamese people and the relaxed lifestyle all brought him back to HCMC.

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

Ho Chi Minh

Why did you choose to retire abroad?

I was an Army pilot in Viet Nam in 1968. I certainly did not like the war, but I liked the Vietnamese people and the country was really beautiful.

I looked all over Central America, Mexico and the Caribbean for a retirement destination. In 2004 I came back to Viet Nam and started coming back once a year. I travelled to every country in Southeast Asia and I liked Viet Nam the best.

Travelling within Viet Nam is also a hobby. I've been from Sa Pa in the north to Ca Mau in the south, and also to Vin Pearl and Phu Quoc. The beaches in Viet Nam are superb.

The "American War", as the Vietnamese call it, is ancient history and the people welcome Americans, even if you were a war veteran.

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

All year

Why did you choose the country you retired to?

Read above.

Did you ever live abroad before you retired abroad?

No, just travelled to about 80 countries.

How long have you lived abroad since you retired abroad?

5.5 years

Moving to Vietnam soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a Moving Quote

Moving to Vietnam soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

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

one

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

Being embarrassed by the current American President.

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

The relaxed lifestyle and the economic freedom that living in Viet Nam offers me. The Vietnamese are a warm and friendly people, and many speak English. The food is very good and also healthy. The Vietnamese eat many fruits and vegetables. The diet is much better than in the US. You can also get almost any type of food in restaurants downtown.

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?)

My days are spent going to the gym, playing golf, swimming and many bike rides. (Bicycle) There is much to explore also in HCMC. Restaurants, clubs, museums and shopping are all available.

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

Married a Vietnamese woman. Got a 5 year visa and then a 3 year ID Card. Very easy process.

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

In 2013 I retired and moved permanently to Viet Nam. I had met a Vietnamese woman and married her in 2014. I purchased a 4 story, 4 bedroom 3 bath home in HCMC for $140,000 and I have been living here happily ever since. I live in a Vietnamese district where there are very few foreigners, but I have met some at the pool I go to and at my gym. I also have a number of Vietnamese friends.

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

Exceeded them. I live on half of my retirement income and I live very well. It is possible for a married couple to live well on $1,200 per month.

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

I can live on half my monthly retirement income.

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

A single person could easily live on $1,000 per month.

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

Healthcare is available, and their are also clinics and hospitals for foreigners. Dentistry is good and very cheap. Close and inexpensive.

Expats living in Vietnam 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 Vietnam 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)

NO.

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

I have a bicycle and buses work great. Taxis and motorbike rides are also inexpensive.

Is there high-speed internet access where you live?

Yes, and fairly reliable. Internet + cable is $17 per month.

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

Southeast Asia is way better than Mexico or Central America and much safer!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Ho Chi Minh

Healthcare in Vietnam

Healthcare in Vietnam

If you're moving to Vietnam, healthcare and health insurance require careful consideration. This article covers the quality of healthcare at hospitals and clinics in Vietnam, the availability of prescription medications, vaccinations and more.

Moving to Ho Chi Minh City

An Australian expat in Ho Chi Minh advises newcomers to bring plenty of clothes for very warm weather since clothing there runs very small. He also recommends looking at a lot of apartments before choosing and taking into consideration proximity to work, supermarkets, swimming pools, because traffic is a major issue.

Culture Shock in Ho Chi Minh

An Aussie expat in Ho Chi Minh City, Vietnam has had no problems setting into the culture there. Read about some of his experiences and his take on culture shock.

Culture Shock in Ho Chi Minh City

The culture is vibrant, and new. The cost of living is cheap, even in HCMC which is the viet equivalent to new York city. I actually stay in D7 which is close to Saigon South which is where most foreigners hide.

Join our Vietnam Expat Forum

Visit our Vietnam Forum and talk with other expats who can offer you insight and tips about living in Ho Chi Minh, Vietnam.

More about Vietnam

Having-a-Baby-in-VietnamHaving a Baby in Vietnam

Expats talk about the good and bad experiences they had giving birth in Vietnam. This article is a must read for any expecting expat parents who are considering having a baby in Vietnam.

Healthcare-in-VietnamHealthcare in Vietnam

If you're moving to Vietnam, healthcare and health insurance require careful consideration. This article covers the quality of healthcare at hospitals and clinics in Vietnam, the availability of prescription medications, vaccinations and more.

Moving-to-VietnamMoving to Vietnam

Expats who have moved to Vietnam report a positive experience living in the Southeast Asian nation. They cite the culture, the food, the people as some of the things they love about Vietnam. The heat is a challenge for some!

5-Best-Places-to-Retire-in-Vietnam5 Best Places to Retire in Vietnam

Thinking of retiring in Vietnam? Here are 5 of the best places to retire in Vietnam.

Living-in-Vietnam-or-on-Vacation---Youve-Got-to-Try-a-Non-LaLiving in Vietnam or on Vacation - You've Got to Try a Non-La

Peter Goudge explains all about Vietnam's iconic hat, the non-la, and how it ties into the South East Asian nation's history, folk lore and every day life. There's a lot more to this simple hat than meets the eye!

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in VietnamHealthcare in Vietnam

If you're moving to Vietnam, healthcare and health insurance require careful consideration. This article covers the quality of healthcare at hospitals and clinics in Vietnam, the availability of prescription medications, vaccinations and more.

Restaurants in Ho Chi MinhRestaurants in Ho Chi Minh

Support your favorite restaurants in Ho Chi Minh 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 Ho Chi Minh City

An Australian expat in Ho Chi Minh advises newcomers to bring plenty of clothes for very warm weather since clothing there runs very small. He also recommends looking at a lot of apartments before choosing and taking into consideration proximity to work, supermarkets, swimming pools, because traffic is a major issue.

Culture Shock in Ho Chi Minh

An Aussie expat in Ho Chi Minh City, Vietnam has had no problems setting into the culture there. Read about some of his experiences and his take on culture shock.

Culture Shock in Ho Chi Minh City

The culture is vibrant, and new. The cost of living is cheap, even in HCMC which is the viet equivalent to new York city. I actually stay in D7 which is close to Saigon South which is where most foreigners hide.

Having-a-Baby-in-VietnamHaving a Baby in Vietnam

Expats talk about the good and bad experiences they had giving birth in Vietnam. This article is a must read for any expecting expat parents who are considering having a baby in Vietnam.

Healthcare-in-VietnamHealthcare in Vietnam

If you're moving to Vietnam, healthcare and health insurance require careful consideration. This article covers the quality of healthcare at hospitals and clinics in Vietnam, the availability of prescription medications, vaccinations and more.

Vietnam 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 04-Jul-20 05:03 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.217
Host Name 173.245.54.217


Execution Time

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

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 17:03:09.009
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 75940
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=21) in /home/www/html/rspnet.cfm @ 17:03:09.009
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 75940 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 75940 
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 @ 17:03:09.009
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 75940 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:03:09.009
	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 @ 17:03:09.009
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 119 
getcities (Datasource=expert, Time=1ms, Records=5) in /home/www/html/navmeta_rdesign4.cfm @ 17:03:09.009
	Select *
	From citynetworks
	Where networkID = 119
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 17:03:09.009
  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=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 17:03:09.009
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75940 
  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 @ 17:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 17:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 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 @ 17:03:09.009
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 17:03:09.009
	SELECT *
	From contentcountcountry
	Where networkid = 119 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 17:03:09.009
	SELECT *
	From contentcountcity
	Where citynetworkid = 4262 
getarticlesection (Datasource=expert, Time=0ms, Records=25) in /home/www/html/breadcrumb_ctygd.cfm @ 17:03:09.009
SELECT *
FROM articleCategories
 
WHERE section = 11
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 17:03:09.009
		Select *
		FROM allreports, citynetworks
         where answerid = 75940
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getretireintro (Datasource=expert, Time=4ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 17:03:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 119 
	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-04"

    ORDER by articles.articleID desc
    
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 17:03:09.009
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 75940 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:03:09.009
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:03:09.009
	Select *
	From Networks
	Where networkid = 119 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:03:09.009
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 17:03:09.009
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 119
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-07-03"
and natsentencestart < "2020-07-04"
and natsentencestatus = 'live'

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

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
	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 = 4262
	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-04" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 119 
	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=6ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 119 
         and allreports.answerid <> 75940 
          and citynetworkid = 4262
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 69416 
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 119 
         and allreports.answerid <> 75940         
          and citynetworkid = 4262
         and city <> ''
         order by date DESC
checkculturefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75940         
         and networkid = 119
          and citynetworkid = 4262
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73652 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 46614 
gettaxgeneral (Datasource=expert, Time=6ms, Records=5) in /home/www/html/rspnet_ctygd_readnext.cfm @ 17:03:09.009
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 119 
	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-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 17:03:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 17:03:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 17:03:09.009
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-03 17:03:09'}
    and fromDate <{ts '2020-07-04 17:03:09'}
    and weight < 7
    and bannerPlacement.networkid = 119
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
  
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 17:03:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight < 7
    and toDate > {ts '2020-07-03 17:03:09'}
    and fromDate <{ts '2020-07-04 17:03:09'}
    and banners.type <> 'swf'
    
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:03:09.009
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
    and toDate > {ts '2020-07-03 17:03:09'}
    and fromDate <{ts '2020-07-04 17:03:09'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 17:03:09.009
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 17:03:09.009
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75940 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 119 
	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 @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 75940         
         and networkid = 119
          and citynetworkid = 4262
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 69416 
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
            
         and allreports.answerid <> 75940         
         and networkid = 119
          and citynetworkid = 4262
         and city <> ''
         order by date DESC
checkculturefeature (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75940         
         and networkid = 119
          and citynetworkid = 4262
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73652 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 46614 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 119
and allreports.networkid = 119
 and allreports.citynetworkid2 =  4262
and allreports.topicid = 9
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 
getanswerstext (Datasource=tipripper, Time=5ms, Records=18) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
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 = 79406
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 79406 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79406'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79406'
	and qid = 391
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79406 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 17:03:09.009
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '119'


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=75940&networkid=119
REMOTE_ADDR=173.245.54.217
REMOTE_HOST=173.245.54.217
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=31030414
cftoken=33094261
sessionid=IBEXPATEXCHANGE.COM_31030414_33094261
urltoken=CFID=31030414&CFTOKEN=33094261
URL Parameters:
answerid=75940
networkid=119
rid=96
Debug Rendering Time: 12 ms