Home Portugal Forum Portugal Guide Moving to Portugal Real Estate Healthcare in Portugal
Cascias, Portugal
Portugal
Resources
City Guides
Cascais, Portugal
JoinSign In

Living in Portugal > Cascais > 5 Tips for Living in Cascais, Portugal

5 Tips for Living in Cascais, Portugal

By Betsy Burlingame

Last updated on: Feb 13, 2017

Expats in the beautiful seaside city of Cascais, Portugal discuss how they chose to move to Cascais. They share information about expat life in Cascais - cost of living, international schools, housing and more.

Cascais, Portugal grew from a fishing village to a popular resort city on the Estoril Coast with a population of over 200,000. Expats in Cascais love that it is located about 40 minutes west of Lisbon by car or train.

Expat Life in Cascais

"Hey, I'm retired in one of the most gorgeous locations in Europe, of course I've increased my eating and drinking... but I've also vastly increase my beautiful sea side walking, biking, and hiking," confessed a retiree who loves living in Cascais.

"Portuguese are intrinsically accepting of others, so they embrace diversity. They respect American, British and Scandinavian persons highly among foreigners; they will not embrace 'Gypsies' but won't go out of their way to disrespect them. A good size foreign population lives here, representing all of Europe, South Africa, Asia, Middle East and South Americans," commented another expat.

Is Cascais Right for You?

An expat in Cascais shared how she ended up choosing to move to Cascais, "We came to Portugal last year for 2 weeks. We explored two areas only: first, the Algarve and next, Lisboa. These selections were based on weather, as we didn't want the colder weather in the North of Portugal. The Algarve is dead in winter, congested in summer, and just stuffed with Brits. The Lisboa area was delightful but we were sold when we took a train from Lisboa to Cascais. This is ideal: generally reliably nice weather, pristine beaches, restaurants all over the narrow streets and squares as well as along the pedestrian esplanade along the ocean. An easy train ride into Lisbon any time you want more culture or diversions, while plenty of museums, shows and parks in the Estoril/Cascais area. IDEAL!"

"Spend time here -- two weeks or so -- before making any commitment. Renting for a few months or longer is most common and affords the flexibility to try other towns, as the lifestyle varies quite a bit between city and village or rural life. This is not a dirt-streets beach town; it is historic, relaxed, casual yet chic," reported one expat living in Cascais.

Expats living in Portugal 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 Portugal interested in expat health insurance should take a minute to get a quote from our trusted expat health insurance partner, CIGNA.

Home Search in Cascais

"Highly helpful to work with a realtor while on your scouting trip. In the Cascais area, three are among the most trusted: MAP, Rose Realty and Porta de Frente," advised one expat. For a short-term rental, one expat living in Cascais advised, "Suggest you go to the MAP, Casasapo and RE/MAX sites for properties, see where they are on the map, and narrow your search -- but most of all, just get a one or two month rental first and get acclimated, go around with realtors to see properties in your favorite areas."

"We are in a mid-rise condo building, renting a 2 bedroom apartment. We scoured all of the online sites, and fortunately took the advice of the owner of a holiday rentals site (Portugal Portfolio) to rent through her for 1 month and take that time to look around. This resulted in us finding our current home that we'd have never known about, at a better price, and ideally situated in an area of both local residents and holiday-renters, with every amenity within walking distance. We have no car -- we walk to the market, beach, restaurants. We rent a car for excursions further away, as we are visiting every part of Portugal that we can, taking a trip every few weeks," explained another expat.

Moving to Portugal 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 Portugal 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.

Cost of Living in Cascais

"Housing costs are lower here, but we're comparing a mortgage on a million-dollar plus condo in the US to rent on a 2 bedroom apartment with ancient appliances. It is easy to find a clean, modern, 2 bed/2 bath apartment with new appliances in the upscale, coastal Estoril/Cascias area for less than $2200/month if one works with a local realtor, and can cut those costs in about half in the smaller towns and villages inland. Utilities per month can add about $100. Internet service is about $30. On average, this feels like one can get a bit more with less but Portugal's Lisboa coast isn't a low cost choice. South and North and inland are less costly," explained one expat in Cascais.

Expat Health Insurance in Portugal

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

Schools in Cascais

There are several schools for expats in Cascais including International Christian School of Cascais, St. James Primary School and Prime School's Boarding School in Cascais. Pre-schools in Cascais include Cascais International Childcare and St. John's Pre-School. In addition to the Cascais schools, there are many other schools for expats in nearby towns and cities. These include Prime School in Sintra (22 minutes by car), Saint Dominics International School in Outeiro de Polima (21 minutes by car), Carlucci American International School of Lisbon, which is located in Sintra not Lisbon (20 minutes by car), Oeiras International School in Oeiras (30 minutes by car), International Preparatory School in Alcabideche (17 minutes by car) and St. Julian's School in Carcavelos (20 minutes by car).

One parent shared their experiences with the International Christian School of Cascais saying, "This is a small school with very loving, caring teachers. It is a 'family' atmosphere. The focus is more on academics rather than sports. Go and visit; it might not be for you if you are against your child learning the Bible. We are Christians, so we like that. There are many other non-christian families though that appreciate the good morals that are encouraged here."

Another expat talked about the Prime School International of Portugal saying, "The school is located in Sintra and Cascais. Prime School in Sintra is located in Portela surrounded by Sintra unique beauty and nature. The school has been awarded and certified by Eco Schools and is therefore involved in many environmental activities one of which includes a vegetable garden at the entrance of the school that have been planted and cared for through the year by the students. The Cambridge program also allows the students through it curriculum to adjust to the changes and transitions from their home country to their new country."

About the Author

AS Betsy BurlingameBetsy 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 Portugal from our partner, Cigna Global Health.
Get a Quote

More about Cascais

Healthcare in Portugal

Healthcare in Portugal

Expats in Portugal with a residency visa can participate in the national health care system. Here's what you need to know about the SNS and the combination of public and private services you'll need to manage your health in Portugal.

Living in Cascais

An expat in Cascais, Portugal talks about life in the casual, yet chic coastal town of Cascais. Locals are very accepting of most foreigners. If you're thinking of moving there, spend some time there before making the move.

Retirement in Cascais

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!

Culture Shock in Cascais

An expat who moved to Cascais, Portugal has enjoys the kind, helpful and genuinely friendly Portuguese people. And, he appreciates the beautiful and, mainly, pristine beaches, forests, villages, towns, rivers and ocean.

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.

Join our Portugal Expat Forum

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

More about Portugal

Demystifying-the-Paper-TrailUnited States Citizens Moving to Portugal: Demystifying the Paper Trail

Thanks to Susan Stults Korthase for this helpful overview of current requirements to begin the process of obtaining a Residency Visa when moving from the US to Portugal. Note: Information Updated December 2018.

5-Best-Places-to-Retire-in-Portugal5 Best Places to Retire in Portugal

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal.

The-8-Best-Countries-for-Brits-to-Retire-AbroadThe 8 Best Countries for Brits to Retire Abroad

Many Brits choose to retire to Australia and the United States. In addition to these popular locales, Ryan Smith recommends several other great retirement destinations for British retirees.

How-to-Get-Your-First-Residence-Permit-in-PortugalHow to Get Your First Residence Permit in Portugal

Wondering how to obtain your first residency permmit in Portugal? Susan Stults Korthase provides the information that you'll need to make it happen.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

wfb1943
Apr 26, 2016 14:24

$2200 for a 2/2 apartment? Those are big city USA prices. I am only paying $700 for a 3/2 home here. It doesn't seem like Portugal is so cheap to live after seeing that price. Was that a typo? That would eat up my entire monthly budget.

guest
Feb 13, 2017 11:55

$2200 for a 2/2 apartment? Those are big city USA prices. I am only paying $700 for a 3/2 home here. It doesn't seem like Portugal is so cheap to live after seeing that price. Was that a typo? That would eat up my entire monthly budget.

First Published: Apr 21, 2016

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in CascaisGuide to Living in Cascais

Expats in the beautiful seaside city of Cascais, Portugal discuss how they chose to move to Cascais. They share information about expat life in Cascais - cost of living, international schools, housing and more.

Healthcare in PortugalHealthcare in Portugal

Expats in Portugal with a residency visa can participate in the national health care system. Here's what you need to know about the SNS and the combination of public and private services you'll need to manage your health in Portugal.

Restaurants in CascaisRestaurants in Cascais

Support your favorite restaurants in Cascais 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.

Living in Cascais

An expat in Cascais, Portugal talks about life in the casual, yet chic coastal town of Cascais. Locals are very accepting of most foreigners. If you're thinking of moving there, spend some time there before making the move.

Retirement in Cascais

Here is a wonderful, detailed report about what it's like to retire in Portugal. Written by a woman with dual US/Dutch citizenship, she has left no stone unturned!

Culture Shock in Cascais

An expat who moved to Cascais, Portugal has enjoys the kind, helpful and genuinely friendly Portuguese people. And, he appreciates the beautiful and, mainly, pristine beaches, forests, villages, towns, rivers and ocean.

Demystifying-the-Paper-TrailUnited States Citizens Moving to Portugal: Demystifying the Paper Trail

Thanks to Susan Stults Korthase for this helpful overview of current requirements to begin the process of obtaining a Residency Visa when moving from the US to Portugal. Note: Information Updated December 2018.

5-Best-Places-to-Retire-in-Portugal5 Best Places to Retire in Portugal

Expat retirees love Portugal for its welcoming people, gorgeous beaches, quaint towns and wonderful restaurants. In this article, we cover 5 great places to retire in Portugal.

Portugal 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 13-Jul-20 11:40 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
155 ms 155 ms 1 top level /home/www/html/lib_rd.cfm
52 ms 52 ms 1 /home/www/html/navcontentboxcitymobile.cfm
45 ms 45 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
44 ms 44 ms 1 /home/www/html/navcontentboxcitypc.cfm
44 ms 44 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/commentsnew_rdesign4.cfm
7 ms 7 ms 1 /home/www/html/lib_rd_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb_ctygd.cfm
6 ms 2 ms 3 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 6 /home/www/html/rewritereport.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/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_4736_48091.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 9 /home/www/html/rewritearticle.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.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
160 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 @ 23:40:28.028
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 23:40:28.028
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 23:40:28.028
	Select *
	From articles
	Where articleID = 4736
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 23:40:28.028
	Select *
	From sponcers
	Where sponcerID = 287 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 23:40:28.028
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4736 
	and articles.articleID = 4736 
	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=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 23:40:28.028
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4736
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4736
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:28.028
	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 @ 23:40:28.028
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 92 
getcities (Datasource=expert, Time=0ms, Records=6, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:28.028
	Select *
	From citynetworks
	Where networkID = 92
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:28.028
  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
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:28.028
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4736 
commentcount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 23:40:28.028
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4736 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 23:40:28.028
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-04-13"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 23:40:28.028
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
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 @ 23:40:28.028
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
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 @ 23:40:28.028
	SELECT *
	From contentcountcountry
	Where networkid = 92 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 23:40:28.028
	SELECT *
	From contentcountcity
	Where citynetworkid = 5074 
citykeyimg (Datasource=expert, Time=1ms, Records=3) in /home/www/html/navtop_ctygd2.cfm @ 23:40:28.028
	SELECT *
	From countryphotos
	Where citynetworkid = 5074
	and keyimg <> ''
	and usekey = 'y'
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 23:40:28.028
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4736 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=6ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 23:40:28.028
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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 = '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-13"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 23:40:28.028
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 92
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-07-12"
and headerparagraphstart < "2020-07-13"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 92
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=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 46
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 23:40:28.028
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 92
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=4ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	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 = 5074
	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.articleID <> '4736'
	
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-13" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 92 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 92
and allreports.networkid = 92
 and allreports.citynetworkid2 =  5074
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
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 = 7 
getanswerstext (Datasource=tipripper, Time=4ms, Records=3) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
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 = 65966
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 65966 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65966'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65966'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 65966 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65966 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '92'
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
         and networkid = 92
          and citynetworkid = 5074
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 68565 
checkretirefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 92
          and citynetworkid = 5074
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75637 
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
         and networkid = 92
          and citynetworkid = 5074
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitymobile.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 44047 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 23:40:28.028
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4736 
gettaxgeneral (Datasource=expert, Time=5ms, Records=4) in /home/www/html/lib_rd_ctygd_readnext.cfm @ 23:40:28.028
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 92 
	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 <> 4736
    and publishdate < "2020-07-13"
    and publishdate > "2014-01-01"
 
    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 23:40:28.028
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-12"
    and fromDate < "2020-07-13"
    and bannerPlacement.networkid = 92
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 23:40:28.028
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 23:40:28.028
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-12 23:40:28'}
    and fromDate <{ts '2020-07-13 23:40:28'}
    and weight > 7
    and bannerPlacement.networkid = 92
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 23:40:28.028
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-12 23:40:28'}
    and fromDate <{ts '2020-07-13 23:40:28'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 23:40:28.028
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=2) in /home/www/html/commentsnew_rdesign4.cfm @ 23:40:28.028
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4736 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 23:40:28.028
  SELECT *
  FROM users
  WHERE userid = 146007 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 23:40:28.028
  SELECT *
  FROM users
  WHERE userid = 2 
getguidesummary (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 5074
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 92 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 92
and allreports.networkid = 92
 and allreports.citynetworkid2 =  5074
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
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 = 7 
getanswerstext (Datasource=tipripper, Time=3ms, Records=3) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
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 = 65966
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 65966 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	SELECT summary
	FROM answers
	WHERE answers.answerid = '65966'
getheading (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '65966'
	and qid = 391
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 65966 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 65966 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '92'
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
                    
           and city <> ''
         and networkid = 92
          and citynetworkid = 5074
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 68565 
checkretirefeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
                    
         and networkid = 92
          and citynetworkid = 5074
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 75637 
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
                    
         and networkid = 92
          and citynetworkid = 5074
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 23:40:28.028
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 44047 


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=4736&networkid=92
REMOTE_ADDR=173.245.54.217
REMOTE_HOST=173.245.54.217
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=31851888
cftoken=63660409
sessionid=IBEXPATEXCHANGE.COM_31851888_63660409
urltoken=CFID=31851888&CFTOKEN=63660409
URL Parameters:
articleID=4736
networkid=92
Debug Rendering Time: 15 ms