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

Expat Chile: The Best Places to Live in Chile

By Betsy Burlingame

Last updated on: Mar 03, 2019

Summary: Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile.

Expat Chile - The Best Places to Live in Chile

Santiago, Chile

Population: Approximately 5.6 million
Location: Inland, Central Chile

santiago chile

An expat living in Santiago provided an insightful overview of life there, "finding other expats here in Santiago is not very difficult at all really. Just take a stroll down Isidora Goyenechea or El Bosque and you'll feel as though you found a street somewhere in the U.S. Santiago is a very diverse city in terms of religious, racial, economic and cultural matters. They seem very accepting of any religious groups but I have noticed here a strong tendency towards "classism" and a definite prejudice (among some) towards any darker skinned people. There is a definite divide among different social classes. The job market is a bit tough here just now but if you teach English, you shouldn't have a problem finding work. Also, anyone in the technical (computer) or health fields should not have trouble finding work either. Although it is possible to find work before you come to Chile, most employers prefer that you are already here in Chile before they hire you. I would tell a friend looking to move here to learn a little Spanish first, don't bring everything you own with you because you can find all you need here and prepare to have a wonderful, new cultural experience because Chile is an interesting and beautiful place to live."

Another expat described her suburb of Santiago, "we live in a small community on the west side of the city that is now officially the 'safest' in all Chile. Where they get that statistic I am not sure but anyway. There are 250 houses here with one dead end road in and out. A river on one side and mountain behind us. There are very few houses for rent here. When is your time frame and what kind of price range do you have? I will check to see what is possible. There are many building going up as they are expanding by 60 houses down near the river but I can't imagine any of those will be rentals. Ours will be available in about 6 months as our house goes up though. If you are looking on a map it is part of Santiago and Pudahuel. It is called 'Lomas de lo Aguirre.' It looks far from the city, but by car is 15 min to town. By bus/subway during high traffic it is 1 hour plus (they use a different route and stop a lot :) But we use them a lot, you just plan ahead. Most expats live in several areas of the city that are indeed pricey and similar to the US big city. We are in a quite nice house and pay $800 USD a month for a nice 4BR house. So as usual expenses are a function of where you have to live."

Another expat said, "I have been to Santiago 3 times now....I have lived here 4-5 months this time. My experience is that the people have been very very friendly, that it is relatively cheap to live. I came from Canada so for me food prices, rents, and especially alcohol are dirt cheap! I feel safe walking alone here....my Spanish is not good but when I tell people I speak English they are very patient and try to help. I think it's a great place to live!"

La Serena, Chile and Coquimbo City, Chile

Population: Approximately 200,000
Location: About 5 hours 20 minutes north of Santiago

la serena chile

"La Serena is linked by the Ocean front with Coquimbo City. Both add up to nearly 350,000 people. The beach length is over 10 kilometers. So if you want to enjoy the Ocean, you should rent an apartment on the shore line. La Serena City has an Spanish architecture on the centre. It is a beautiful city. Coquimbo City is more popular. They have the pier for fishing boats and the fish market. This city is more popular, less organized and they have several pubs for dancing. Both cities have different charms, so you must choose where to live there. La Serena must be seen with Coquimbo as Twin Cities as they are neighboring cities. La Serena is more organized, one of the oldest cities of Chile, keeping some Spanish style. Coquimbo is more popular, more workers living on it, but has the charm of the port, the always attractive fish market and the fun of the lay people. Regarding weather -- it is like a permanent Spring -- never cold and seldom over 30C. Today at the start of the winter, the ranges were 12C and 21C. Both cities have a fantastic beach of more than 10 kilometers. Nice for swimming, walking and watching birds. There is always room to be alone, isolated on such a lengthy beach. If you go off season, the better. For your information, Chileans mostly have their vacations concentrated in only two months of the year: January and February. Also, another fun date for Chileans are Fiestas Patrias, the days around 18th and 19th of September when we celebrate Independence. If you like local customs, you shouldn't miss this celebration. It is an entire week of holiday, so people come massively to La Serena on these days. But the rest of the year, you have 9 months and 3 weeks of beach activity just for local people. Coquimbo people are unique in Chile. They take tents and celebrate for an entire week to a place called La Pampilla, around the end of September. La Serena is not surrounded by desert. Just look Google Earth. It is a dry area and a severe draught is affecting it. If you move 60 kilometers to Ovalle into the inner valleys, there are big green parcels of land full of grapes, avocado trees and vegetables. You have both dry soil with cactus and scarce food for the people's goats, and at the same time beautiful green areas. La Serena is really close to Santiago by air. it is a 450 kilometer ride, or 6 hours for normal, good bus lines and there are many of them. So, you always can travel to Santiago for business or for shopping. La Serena has branches of all the major department stores of Santiago. So, you can find almost anything you may need," described one expat living in Chile.

Vina del Mar, Chile

Population: Approximately 325,000
Location: on the Coast4.5 hours, approximately 1 hour 40 minutes northwest of Santiago

vina del mar

"This [Vina del Mar] is BY FAR the best city to live in Chile, we have a community of over 600 expats, at least 200 from the US, many retirees. Near the end of each month, we organize a get-together, you will be able to get all the tips from Visa to Healthcare," wrote one expat in a thread about Vina del Mar.

"I currently live in Los Angeles California with my partner and we visit Vina del Mar every year. We are planning to retire in 2016. We just bought a condo together in Vina just 3 blocks from the ocean, brand new for about 150K. Chile is beautiful, safe, the people are friendly. I have read a lot about how to immigrate to Chile and it is very easy as long as you can prove you have a retirement income," recommended one person moving to Vina del Mar. Another said, "to give you an example, if you choose to live in the resort town of Vina del Mar, you can rent a 2 bedroom in a good part of town for about 500 mil pesos (about one thousand dollars) and you can definitely pay all the other bills and live a comfortable life."

Pucon, Chile

Population: Approximately 14,000
Location: 4.5 hours south of Concepcion in the Lakes Region

Pucon Chile

An expat living in Pucon, Chile described the area saying, "Pucon is blessed with lakes, rivers, three national parks, a national forest, a ski slope, salmon fishing, river rafting, sailing, scuba diving, parasailing, parachute jumping, canoeing/kayaking, trecking, cycling, jogging and marathons. There is a golf course, the main hotels have swimming pools and in the surrounding areas there are several hot springs / day spas. There are tennis courts, massage parlors, exercise rooms, gymnasium, yoga classes. Plenty to see and do."

Puerto Varas, Chile

Population: Approximately 24,000
Location: 7 hours south of Concepcion in the Lakes Region

Puerto Varas Chile

An expat who moved to Puerto Varas said, "Puerto Varas and Pucon are the two nicest places in the south of Chile that I can recommend. The expats who don't want to live in a big city like Santiago would do well to consider the beautiful, laid back but tasteful cities in the Lakes region."

About the Author

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Chile Expat Forum

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

More about Chile

Living-and-Starting-a-Business-in-Chile

Expat Chile: Living and Starting a Business in Chile

James Jones offers advice about starting a business in Chile. He says that the main thing to remember as an expatriate opening a business in Chile is that customer service is much desired. If you provide a top-notch service to Chilean people, you can expect your business to flourish rapidly.

James Jones offers advice about starting a business in Chile. He says that the main thing to remember as an expatriate opening a business in Chile is that customer service is much desired. If you prov...

10-Tips-for-Living-in-Chile

10 Tips for Living in Chile

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challenge. But, the expat community in Chile is strong and offers a great support system for newcomers.

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challeng...

5-Important-Tips-about-Healthcare-for-Expats-in-Chile

5 Important Tips about Healthcare for Expats in Chile

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity.

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity. ...

Shipping,-Customs-Inspections--Extra-Baggage

Moving to Chile: Shipping, Customs Inspections & Extra Baggage

Expats in Chile offer advice to newcomers about shipping to Chile, customs inspections and more.

Expats in Chile offer advice to newcomers about shipping to Chile, customs inspections and more....

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

albatross1969
Jan 16, 2017 11:32

I believe that expats should travel South and explore Cities that are not like the Cities they have left behind. Pucon, Valdivia, Peurto Montt, Orsorno to name a very few. I am an expat from Melbourne Australia, I came to Chile to retire and get away from the hustle and bustle of city life and be at peace with the countryside style of living.

Updated On: Mar 03, 2019

First Published: Jul 04, 2014

Cigna Expat Health InsuranceExpatriate Health Insurance

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

5-Expats-Talk-About-Living-in-Chile5 Expats Talk About Living in Chile

5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life.
5 expats talk about what it's like living in Chile. Expats appreciate the focus on family in Chile, the strong work ethic and the slower pace of life. ...

Expat-ChileExpat Chile: The Best Places to Live in Chile

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile.

Expats in Chile enjoy the country's beaches, beautiful cities and lower cost of living. Santiago, La Serena, Vina del Mar and other destinations top their favorite places to live in Chile....

Expats-in-Chile10 Tips for Living in Chile

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challenge. But, the expat community in Chile is strong and offers a great support system for newcomers.

Expats in Chile enjoy the stable economy, friendly people and relatively affordable cost-of-living. Many find becoming close friends with Chileans, who primarily socialize with family, a big challeng...

Expats-in-Chile5 Important Tips about Healthcare for Expats in Chile

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity.

After considering their individual health, Expats moving to Chile should carefully consider the health care options where they'll live, and what else is available in the immediate vicinity. ...

Moving-To-Puerto-VarasAn Expat Talks about Moving to Puerto Varas, Chile

An expat in Puerto Varas, Chile talks about moving to Chile with a few suitcases and a shipping container coming in six months. She and her husband lived in temporary housing and investigated areas to live in the south of Chile such as Pucon and Puerto Varas. They love their spacious, new home with amazing views of the lake and volcanoes.

An expat in Puerto Varas, Chile talks about moving to Chile with a few suitcases and a shipping container coming in six months. She and her husband lived in temporary housing and investigated areas t...

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

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /lib_rd.cfm
Time Stamp 03-Jul-20 07:02 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.108
Host Name 162.158.78.108


Execution Time

Total Time Avg Time Count Template
63 ms 63 ms 1 top level /home/www/html/lib_rd.cfm
26 ms 26 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/navcontentbox.cfm
25 ms 25 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
8 ms 8 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 0 ms 7 /home/www/html/rewritearticle.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /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
68 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 @ 07:02:00.000
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 07:02:00.000
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 07:02:00.000
	Select *
	From articles
	Where articleID = 4402
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 07:02:00.000
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 07:02:00.000
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4402 
	and articles.articleID = 4402 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=1ms, Records=0) in /home/www/html/lib_rd.cfm @ 07:02:00.000
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4402
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4402
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 07:02:00.000
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:02:00.000
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getcities (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:02:00.000
	Select *
	From citynetworks
	Where networkID = 30
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 07:02:00.000
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 07:02:00.000
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4402 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:02:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 07:02:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-03 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 @ 07:02:00.000
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 07:02:00.000
	SELECT *
	From contentcountcountry
	Where networkid = 30 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 07:02:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 07:02:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 07:02:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4402 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 07:02:00.000
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4402 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb.cfm @ 07:02:00.000
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 07:02:00.000
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 07:02:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4402 
gettaxgeneral3 (Datasource=expert, Time=5ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 07:02:00.000
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 4402
    and publishdate < "2020-07-03"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 07:02:00.000
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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.articleID <> 4402
    and publishdate < "2020-07-03"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 07:02:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 07:02:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:02:00.000
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-02 07:02:00'}
    and fromDate <{ts '2020-07-03 07:02:00'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 07:02:00.000
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 07:02:00.000
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4402 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 07:02:00.000
  SELECT *
  FROM users
  WHERE userid = 177408 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 07:02:00.000
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4402 
checkrptarticles (Datasource=reports, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-03"
     
         and rptarticlenetworks.networkid = 30 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 07:02:00.000
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 6
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 07:02:00.000
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 30 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
SELECT  hiimg
FROM rptarticles
where rptarticleID = 6
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=3) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 30 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-03"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 30 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 30 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 07:02:00.000
		Select summary, hiimg 
		FROM answers
         where answerid = 74152
         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/lib_rd.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/lib_rd.cfm
QUERY_STRING=articleID=4402&networkid=30
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=30913475
cftoken=27714138
sessionid=IBEXPATEXCHANGE.COM_30913475_27714138
urltoken=CFID=30913475&CFTOKEN=27714138
URL Parameters:
articleID=4402
networkid=30
Debug Rendering Time: 15 ms