Home Spain Forum Spain Guide Moving to Spain Real Estate Healthcare in Spain
Spain
Resources
City Guides
JoinSign In
Take the 2020 Expat Exchange Survey

Moving to Spain > 5 Best Places to Live in Spain

5 Best Places to Live in Spain

By Joshua Wood, LPC

Sep 06, 2017

Summary: Expats in Spain have a lot of opinions as to the best places to live in Spain. It all comes down to preferences, resources and where you are in life. Here's a good start in your research for deciding where to live in Spain as an expat!

Moving to Spain - 5 Best Places to Live in Spain

Expat who Live in Spain have a lot of advice to offer others about where to live in Spain.

Those considering moving to Spain will glean a lot of information by reading this article and the resources linked in the text. Often people researching living abroad glance over or disregard important points. Read carefully, throughly, and take the advice of expats already in Spain seriously! Many are happy to cite their experiences to help you avoid headaches - especially lost time and money!

Each expat in Spain has their favorite places to live there, but here are some of the more popular options that cover a variety of motivations for moving there.

Living in Barcelona, Spain

Expat Living in Barcelona

A long time favorite is Barcelona. Take the time to read tips for living in Barcelona article

An expat living in Barcelona advised expats to, "come and enjoy Barcelona - be responsible and most of all punctual, work hard, be prepared to play if you're young (let's say under 40), and you'll have a great time.

Barcelona is developing into a "New Technology - High Technology" center, as well as being a center for pharmaceutical companies and telecommunications companies - both growth industries. People find jobs by "contacts, contacts, contacts and hard work."

Another expat who moved to Barcelona wrote "it is cheaper here than many large cities in the US, yet choice ultimately depends on your budget and needs. Prices may be lower the farther you go from Ciutat Vella, plus you will still have metro access."

Here is information about international schools for expats moving to Barcelona.

An expat who moved to Barcelona strongly recommended using a relocation company writing that "they are the right people to tell you what are the advantages and disavantages about the different areas with an orientation tour. Also to visit properties, I think they give you the best idea on what is on the market.

They also added that "I live in a house in Gava Mar (south Barcelona). It is quite common for expats in this area. It is difficult to find a house in Barcelona, there are mostly flats. A house by the sea is perfect for a family with children."

Private Health Insurance for Expats in Spain

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

Living in Madrid, Spain

Expat Living in Madrid

As the capital and largest city, Madrid also gets a lot of attention from expats beginning to explore Spain. Start by reading our tips for living in Madrid.

An expat who moved to Madrid added that "You can get much cheaper and larger apartments outside of the center of the city (duh). I do like where I live simply because I don't have to go anywhere to have fun. I'm 10 min away from the central tourist/party area of Sol. I live 2 minutes away from a metro stop and have literary hundreds of club and bars outside my doorstep. With all of this I hear no sounds at night since my apartment window faces inwards."

He added that "I live in a flat like most other expats and there are PLENTY of them here!"

One expat advised those seeking jobs that "If you're interested in teaching in English, there are plenty of British Schools in Madrid. I know about King's College Schools as having very good reviews across their 3 Madrid schools.

Living in Almeria, Spain

Expat Living in Almeria Spain

Another option for expats is the coastal town of Almeria, which is in the southeast of Spain on the Mediterranean Sea.

An expat wrote about Moving to Almeria and advised others to "hire a car, tour the area and find the village or town that appeals to you most. Find a good Spanish registered SL or SA estate agency... and spend three days looking at houses in the area of your choice. Make sure that you have a car or access to one because in rural Spain it is essential to have transport."

One expat recommended Almeria, noting that "Almeria in particular is still a very affordable area which is not over run with expats."

Another expat in Spain added "It would be well worth a visit to the Almeria province, which is down on the South Coast and still part of the autonomous region of Andalucia. My partner and I have lived here for nearly 14 years and haven't looked back. We travelled all around the coast of Spain and constantly came back to this area which is less developed and still has a great air of friendliness and is strikingly beautiful. It is also a lot cheaper in terms of buying a house and the cost of living too."

Moving to Spain

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

Living in Seville, Spain

Expat Living in Saville Spain

Seville is the capital and largest city of Andalucia and lies on the plain of the river Guadalquivir.

Anexpat who had lived in Seville wrote "In terms of American networks, there are a good percentage of Americans living in Seville, mostly students, but some expats as well. I know there is an American Women's Club with a branch in Seville."

One expat added that "in Seville I used to live in Triana and Los Remedios. The later is more stylish and you can find all prices of apartments there."

Living in Costa Blanca, Spain

Expat Living in Costa Blanca Spain

Costa Blanca is another area popular with expats.

A realtor who offered advice to expats wrote the following about Costa Blanca: "Costa Blanca enjoys a typical Mediterranean climate, with cool sea breezes in summer and protection by surrounding mountains against the cold North winds in winter." He also wrote that the WHO cites "the area is one of the most equitable in the world, so, anyone with health issues can be reassured that with this consistent and attractive weather they will be very comfortable in this environment."

Expats interested in Retiring to Spain should read our article 5 Affordable Places to Retire in Spain.

Expat Health Insurance in Spain

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

Cigna Expat Health InsuranceExpatriate Health Insurance

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

7-Things-to-Know-Before-Moving-to-SpainMoving to Spain: 7 Things to Know Before Moving to Spain

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for moving to Spain will get you started on picking the perfect place for you.

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for mo...

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb....

Moving-To-SpainExpats Talk about What it's Like Moving to Spain

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

Join our Spain Expat Forum

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

Read Next

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Moving-to-BarcelonaMoving to Barcelona

Expats in Barcelona enjoy a beautiful city on the Mediterranean Sea and one of the most popular cities in Europe. Here is some great advice from expat that already live there.

10-Tips-for-Living-in-Spain10 Tips for Living in Spain

Expats Living in Spain offer their advice for others making the move to the nation on the Iberian peninsula. From what to bring, to learning Spanish, culture shock and more, read on to learn how to settle into your new life as an expat in Spain.

Pros-and-Cons-of-Living-in-SpainExpats in Spain: Pros and Cons of Living in Spain

Expats in Spain discuss the pros and cons of living in Spain. Topics discussed include lower cost of living, taxation on worldwide income, friendliness of Spaniards, LGBT community, slower pace of life and more.

7-Things-to-Know-Before-Moving-to-SpainMoving to Spain: 7 Things to Know Before Moving to Spain

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for moving to Spain will get you started on picking the perfect place for you.

About the Author

Joshua Wood Joshua Wood, LPC joined Expat Exchange in 2000. Joshua has a BA from Syracuse and a Master's in Clinical and Counseling Psychology from Fairleigh Dickinson University. Some of Joshua's more popular articles include Pros and Cons of Living in Portugal, 10 Best Places to Live in Ireland and 5 Best Places to Live in Spain. Connect with Joshua on LinkedIn.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

First Published: Sep 06, 2017

Cigna Expat Health InsuranceExpatriate Health Insurance

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

7-Things-to-Know-Before-Moving-to-SpainMoving to Spain: 7 Things to Know Before Moving to Spain

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for moving to Spain will get you started on picking the perfect place for you.

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for mo...

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb....

Moving-To-SpainExpats Talk about What it's Like Moving to Spain

Already living abroad? Write a report about moving overseas to help people preparing to move abroad.

Spain 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-Jun-20 03:35 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.194
Host Name 162.158.78.194


Execution Time

Total Time Avg Time Count Template
67 ms 67 ms 1 top level /home/www/html/lib_rd.cfm
22 ms 22 ms 1 /home/www/html/navcontentboxmovingmobile.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/commentsnew_rdesign4.cfm
6 ms 6 ms 1 /home/www/html/lib_rd_readnext.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
3 ms 1 ms 3 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navbottomad_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/navcontentboxmovingpc.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/constants.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_4985_91478.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 12 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereportscountry.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
74 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 @ 03:35:29.029
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 03:35:29.029
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 03:35:29.029
	Select *
	From articles
	Where articleID = 4985
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/lib_rd.cfm @ 03:35:29.029
	Select *
	From sponcers
	Where sponcerID = 288 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 03:35:29.029
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4985 
	and articles.articleID = 4985 
	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 @ 03:35:29.029
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4985
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4985
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 03:35:29.029
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 03:35:29.029
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 03:35:29.029
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 03:35:29.029
  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=0) in /home/www/html/navmeta_rdesign4.cfm @ 03:35:29.029
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4985 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 03:35:29.029
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-03-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 03:35:29.029
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-06-03 00:00:00.000"
and logtime < "2020-06-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 @ 03:35:29.029
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.194'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 03:35:29.029
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 03:35:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 03:35:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 03:35:29.029
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 874 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 03:35:29.029
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4985 
checkcitynetwork (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 03:35:29.029
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4985 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 03:35:29.029
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-02"
and headerparagraphstart < "2020-06-03"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-02"
and natsentencestart < "2020-06-03"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 1
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 03:35:29.029
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-06-02"
and headerparagraphstart < "2020-06-03"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxmovingmobile.cfm @ 03:35:29.029
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
   and (articleCategories.section = '1' or articleCategories.section = '2' or articleCategories.section = '4' or articleCategories.section = '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    
    and articles.articleID <> '4985'
	
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"
     ORDER by articles.sectionintro DESC, articles.articleID desc 
 
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentboxmovingmobile.cfm @ 03:35:29.029
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
      
         and networkid = 101 
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxmovingmobile.cfm @ 03:35:29.029
		Select summary, hiimg 
		FROM answers
         where answerid = 72927
         and summary <> ''
getbestplaces (Datasource=expert, Time=8ms, Records=0) in /home/www/html/navcontentboxmovingmobile.cfm @ 03:35:29.029
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl, publishdate
	FROM articles, articlePlacement, articleCategories 
 	Where hitopic <> ''
	and (((title LIKE '%Best%') OR (author LIKE '%Best%') OR (hitopic LIKE '%Best%') OR (hidescript LIKE '%Best%')) AND ((title LIKE '%Places%') OR (author LIKE '%Places%') OR (hitopic LIKE '%Places%') OR (hidescript LIKE '%Places%')))
	and articlePlacement.networkID = 101
	AND articlePlacement.articleID = articles.articleID
	  and articleCategories.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and (articleCategories.section <> '1' and articleCategories.section <> '2' and articleCategories.section <> '4' and articleCategories.section <> '5')   
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and summary <> ''
    and publishdate < "2020-06-03"
    ORDER by articles.articleID desc
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 03:35:29.029
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4985 
gettaxgeneral (Datasource=expert, Time=5ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 03:35:29.029
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	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.articleID <> 4985
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 03:35:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 03:35:29.029
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=0ms, Records=2) in /home/www/html/navmpu_rdesign5.cfm @ 03:35:29.029
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-02 03:35:29'}
    and fromDate <{ts '2020-06-03 03:35:29'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 03:35:29.029
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 03:35:29.029
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4985 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 03:35:29.029
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4985 


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=4985&networkid=101
REMOTE_ADDR=162.158.78.194
REMOTE_HOST=162.158.78.194
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=28918479
cftoken=36683483
sessionid=IBEXPATEXCHANGE.COM_28918479_36683483
urltoken=CFID=28918479&CFTOKEN=36683483
URL Parameters:
articleID=4985
networkid=101
Debug Rendering Time: 9 ms