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

Spain Expat Forum

Thinking about moving to Spain

Post New Topic
tmbf57
5/22/2018 18:06 EST

Hello, DH and I (age 65 and 61) are retired, currently living in Miami, FL and would like to move to Spain. We will be taking our 60 lb. Goldendoodle with us.
We would love to live in Madrid, but it appears this will be out of our price range. We do not want to live in an area that is extremely hot because (we are sick of the heat in Miami LOL) but more temperate areas. Our total income is about $3500/mos. We are not looking for a luxurious but comfortable lifestyle. We do not want to sell our Miami home as we will eventually return home. Do any of you have recommendations about areas with temperate climate, dog friendly, good public transportation and reasonable rents (no more than $1000./mos furnished? Any and all suggestions would be most welcome, Thank you in advance !

Post a Reply

00abuse

gvb
5/22/2018 23:48 EST

My husband and I just picked up our nonlucrative visas today! We are moving to Girona which is a small city just north of Barcelona. The weather is nice, it is close to the coast, to the mountains, and to France. We saw a number of apartments in the $1000 range, although we ended up with one a little more because we wanted to be very central. We are not getting a car and will rely on the amazing train and bus system plus inexpensive rental cars when we need them

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

sdamazo
5/23/2018 06:53 EST

I think you should check the north of Spain. San Sebastian is a nice place. Budget is good and there is plenty of good offers.

Catalonia has a political issue going on and far from being sorted.

Post a Reply

00abuse

Neil605
6/10/2018 08:50 EST

You should meet your requirements for sure anywhere along the Costa Del Sol. There is a lot of good info on this site about this. The main attraction is the weather and meets what you were asking for exactly. We are retiring to Malaga province focusing on Nerja in September and are waiting for on Non lucrative visas. You are in luck in that the Spanish consulate is in Coral Gables, saves you a trip. Getting the visas is involved but there is good info on that on the site as well.....

Post a Reply

00abuse

tvfilmproducer
6/12/2018 05:22 EST

I recently moved to Girona. Spain from Washington. DC. Although I have been here for only a month, I'm very please with the Girona area and the city is beautiful. You can drive to southern France in 90 minutes. to the Costa Brava coast beaches in 30 mins and to Barcelona 75 mins. Being in the Northeast of Spain. Girona does not get as hot as it does in the South. Currently, the temperatures have been in the high 60's to high 70's. Rents on long term basis (1 year - firnishes) can be found from 700 to 1100 € per month. I live In the Old Town and the rent is higher here and so is the noise. Church bells ring every 15 minutes - 24 hours a day. If you look at places outside of the city center the rents are less expensive. Larry

Post a Reply

00abuse

tvfilmproducer
6/12/2018 05:22 EST

I recently moved to Girona. Spain from Washington. DC. Although I have been here for only a month, I'm very please with the Girona area and the city is beautiful. You can drive to southern France in 90 minutes. to the Costa Brava coast beaches in 30 mins and to Barcelona 75 mins. Being in the Northeast of Spain. Girona does not get as hot as it does in the South. Currently, the temperatures have been in the high 60's to high 70's. Rents on long term basis (1 year - firnishes) can be found from 700 to 1100 € per month. I live In the Old Town and the rent is higher here and so is the noise. Church bells ring every 15 minutes - 24 hours a day. If you look at places outside of the city center the rents are less expensive. Larry

Post a Reply

00abuse

expat health insurance from CIGNA

Choosing an expat health insurance provider is an important decision. Get a quote from our trusted expat health insurance partner, CIGNA. With Cigna Global Health Options, you can create an international health insurance plan that's perfectly tailored for the needs of you and your family.

Get a Quote

gvb
6/12/2018 10:46 EST

We are moving to Girona in 3 weeks! Our apartment is near the Placa Catalonia. We can’t wait! Hope we meet you there!

Post a Reply

00abuse

gvb
6/12/2018 10:46 EST

We are moving to Girona in 3 weeks! Our apartment is near the Placa Catalonia. We can’t wait! Hope we meet you there!

Post a Reply

00abuse

mishakaro
6/26/2018 06:42 EST

I can appreciate your concern for being too hot for you.

North of Spain is the logical choice but snow is possible. However, you have the rest of northern Europe easily at your feet.

There are places in South of Spain and can provide a more moderate and comfortable climate year round. Ronda, a beautiful whitewash mountain town, is about an hour from the coast and Malaga international airport. It is touristy in the summer but relaxed and beautiful in the winter with average temperatures in the 50s and 60s.

Granada, is also in the mountain and it's reputation is well documented as a stunning place to be in during the off-season. I chose Benalmadena,

Costa del Sol (about 1.5 hours away from Ronda) because its warm and comfortable in the winter months and I'm back in Toronto for her best weather in the summer.
My two cents.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Spain.

International Moving Companies

Moving to Spain? Get a moving quote.


Mail Forwarding to Spain

Mail Forwarding to Spain.


Expat Tax

Expat Tax Preparation, Expat Tax Professionals

Join Today (free)

Join Expat Exchange to meet expats in your area or get advice before your move. It's FREE and takes 1 minute!

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Granada-An Expat Talks about Culture Shock & Living in Granada , Spain

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive.

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive. ...

Living-in-ValenciaAn Expat Discusses Living in Valencia, Spain

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano.

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano. ...

10-Tips-for-Living-in-SpainExpat Spain: 10 Tips for Living in Spain

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain.

With it's warm culture, thriving cities and beautiful countryside, expats agree that Spain has it all. Expats share their tips and experiences living in Spain....

5-Tips-for-Living-in-Barcelona5 Tips for Living in Barcelona

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thriving nightlife scene.

Barcelona is the capital of Catalonia, a region where some citizens are fighting for their independence from Spain. Barcelona is a beautiful city that's rich in history and architecture with a thrivi...

International-Schools-in-BarcelonaInternational Schools in Barcelona, Spain

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we highlight several of the more popular English schools and expats' advice with regard to public vs. private English schools.

Families moving to Barcelona have a number of great schools to consider. There are several American and British schools plus foreign children are allowed to attend public school. In this article we ...

12-Expats-Talk-About-What-Its-Like-Moving-to-Spain12 Expats Talk About What It's Like Moving to Spain

Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat.
Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat. ...

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 /expat/index.cfm
Time Stamp 27-May-20 09:58 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.128
Host Name 162.158.78.128


Execution Time

Total Time Avg Time Count Template
121 ms 121 ms 1 /home/www/html/expat/Application.cfm
58 ms 58 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
58 ms 58 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
57 ms 57 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
33 ms 33 ms 1 /home/www/html/navcontentbox.cfm
28 ms 28 ms 1 /home/www/html/expat/messages_rdesign5.cfm
28 ms 28 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
16 ms 16 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
15 ms 15 ms 1 /home/www/html/expat/message_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 1 ms 9 /home/www/html/navvote_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navleader_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/ibstyle.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 9 /home/www/html/expat/common/formatmsg.cfm
0 ms 0 ms 1 /home/www/html/expat/copyright.cfm
0 ms 0 ms 1 /home/www/html/expat/datasources.cfm
0 ms 0 ms 1 /home/www/html/expat/ibkey.cfm
0 ms 0 ms 1 /home/www/html/expat/index.cfm
0 ms 0 ms 1 /home/www/html/expat/instaboard.cfm
0 ms 0 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.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/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
121 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 21:58:40.040
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/expat/Application.cfm @ 21:58:40.040
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 21:58:40.040
	Select *
	From Networks
	Where frmid = 296 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 296 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	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/navmetaforums_rdesign5.cfm @ 21:58:40.040
  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
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select *
	From Networks
	Where networkID = 101 
GetTopicTitle (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
  SELECT f.frmid as frmid, frmname, t.tpcname, m.msgtext, t.urlchanged, t.tpcrewriteurl, t.section, t.citynetworkid, t.tpcnamenew, t.summary, t.keywords, m.msgid
  FROM forums f, topics t, messages m  
  WHERE f.frmid = 296 
  AND t.tpcid = 3430542 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=6ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3430542
  and  t.tpcid = 3430542
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=36) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext as msgintro, m.msgparent, m.msghost, m.msgdate, m.msgupdate, t.tpcupdate, m.replylevel, m.userid, u.userid, u.username, t.msgcount-1 as replycount, topicimage, topicimageapproved
  FROM messages m, users u, topics t
  WHERE m.tpcid = 3430542
  and  t.tpcid = 3430542
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=36, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:58:40.040
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 101
	order by lastsent ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:58:40.040
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-02-26"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:58:40.040
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-27 00:00:00.000"
and logtime < "2020-05-27 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:58:40.040
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-20"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:58:40.040
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 21:58:40.040
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-26"
    and fromDate < "2020-05-27"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 21:58:40.040
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-26"
    and fromDate < "2020-05-27"
UpdatePageViews (Datasource=expert, Time=4ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:58:40.040
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 21:58:40.040
  SELECT catid, allowattach, isreviewed, isprivate, f.frmid as frmid, frmname, frmdesc, frmorder, frmpass, frmnotice, isapproved, f.isclosed as frmclosed, tpcname, tpcid, t.isclosed as tpcclosed, ispoll, isreviewed
  FROM forums f, topics t  
  WHERE f.frmid = 296 
  AND tpcid = 3430542 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 21:58:40.040
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 296
  AND u.userdbname = "ee"
  ORDER BY u.username
GetCategory (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GetCategory.cfm @ 21:58:40.040
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 21:58:40.040
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 21:58:40.040
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, topics.tpcname, forums.frmname, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3430542
  AND m.userid = u.userid
  AND topics.tpcid = 3430542
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=5ms, Records=8) in /home/www/html/expat/messages_rdesign5.cfm @ 21:58:40.040
  SELECT distinct m.msgid as mid, m.msgid, m.msgtext, m.msgparent, m.msghost, m.msgdate, m.msgupdate, m.replylevel, m.attachment, m.attachsize, m.updateuser, m.usesmilies, m. usesignature, m.isapproved, m.isdeleted, topics.isclosed, m.tpcid, m.userid, m.dbname, u.userid, u.usericon, u.username, u.useremail, u.userdbname, u.usertitle, u.isactive, u.signature, u.location, u.totalposts, u.userdate, u.allowpm, u.showicq, u.icqnumber, forums.frmid, topics.tpcid, topics.frmid, forums.dbname, m.guestname, m.guestemail, m.report, m.good, m.bad, messageimage, messageimageapproved
  FROM messages m, users u, forums, topics  
  WHERE m.tpcid = 3430542
  AND m.userid = u.userid
  AND topics.tpcid = 3430542
    AND m.isdeleted <> 1
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
     AND m.msgparent <> 0
  AND m.isapproved = 1
   
    ORDER BY m.msgid ASC 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 477977
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 477977
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-26"
and natforumstart < "2020-05-27"
and natforumstatus = 'live'

and (natforumweight = 'medium' or natforumweight = 'high')
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 477995
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 477995
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480254
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480254
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480479
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480479
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480480
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480480
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
	Select *
	From Networks
	Where networkid = 101 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-26"
and natforumstart < "2020-05-27"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:58:40.040
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 1 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480521
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480521
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480522
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 480522
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 482402
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:58:40.040
SELECT vote
FROM votes
WHERE voteid = 482402
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=22ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 21:58:40.040
	SELECT answersphoto.photo, answersphoto.answerid, answersphoto.qid, answers.rid, allreports.networkname, allreports.networkid, allreports.city, allreports.state
	FROM answersphoto, answers, allreports 
	WHERE answersphoto.answerid = answers.answerid
	and allreports.answerid = answers.answerid
	and allreports.topicid = 6
	and allreports.hide <> 'y'
	and (answers.paid = 'yes' or answers.paid = 'free')
	AND answersphoto.qid = '104'
	AND allreports.networkid = 101
	AND "2020-05-27" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 101 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
		Select summary, hiimg 
		FROM answers
         where answerid = 76449
         and summary <> ''
checklivingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 101 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
		Select summary, hiimg 
		FROM answers
         where answerid = 75819
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=8ms, Records=3) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
	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.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-27"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-27"
     
         and rptarticlenetworks.networkid = 101 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:58:40.040
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 10
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 21:58:40.040
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 21:58:40.040
SELECT  hiimg
FROM rptarticles
where rptarticleID = 10
and hiimg <> ''


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/expat/index.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/expat/index.cfm
QUERY_STRING=frmid=296&tpcid=3430542
REMOTE_ADDR=162.158.78.128
REMOTE_HOST=162.158.78.128
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expat/index.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Cookie Variables:
MS=flat
Session Variables:
cfid=28550091
cftoken=78882030
sessionid=IBEXPATEXCHANGE.COM_28550091_78882030
urltoken=CFID=28550091&CFTOKEN=78882030
URL Parameters:
frmid=296
tpcid=3430542
Debug Rendering Time: 16 ms