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

Moving to Mexico > Merida >

An Expat Talks about Moving to Merida, Mexico

Nov 23, 2017
Submitted by Tuddiepat1


Merida, Mexico

A newcomer to Merida, Mexico talks about shipping delays, needing a co-signer for a rental property, the low cost of living in Merida and more.

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

Merida

Name three things that you wish you had brought and three you wish you had left at home.

My husband and I were told by the shipper that once we have a Merida address that our items will be shipped to our door within a few days. We have been here for almost a month and we have found that our items are still in Miami!! We were also told that our items cannot be sent from Miami until my husband gets his Temporary Resident card (which he applied for, but we have been told that it will take approximately a month to get it). Once he has the card, then they will schedule the items to be sent and it takes 10 days to go across the Gulf of Mexico and then a few days to go through Customs. So at this rate, we will be lucky if we have our items for the New Year and we have been in Mexico since October 27th. Please be warned about this and make sure that you get everything in writing. We did and we are still having issues. We wish we would have all our items that we shipped and have not found anything that we had wished we left yet.

Moving to Mexico

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

What advice would you give someone preparing to move to your area about the actual move, choosing a neighborhood and finding a home?

One thing is very important if you are thinking of renting. When you pay the first and last months rent, they also ask for payment to a lawyer. You will need to meet with a lawyer (our realtor was with us) and the forms that you have to sign are in Spanish. We had been told that most homes that are rented also need a co-signer, a person who will go with you to the lawyer to vouch that if you do not finish paying the year of rent, that they will pay the remainder of what is owed. Luckily for us, the owner of our home waived the need for a co-signer, so it worked out well for us, but it's really hard moving to a new country, not knowing anyone and then finding out that you need to find a co-signer to rent a property!!! Be aware.

What type of housing do you live in? Is this typical for most expats in your area?

We rented a 3 BR/3 Bath home. It is very modern and has a small front yard and a beautiful back yard with a pool. It is 2 stories. We also have a terrace overlooking the back yard and a sunny roof top overlooking the front of the house. The house has a large wall around it and an electric gate in the front which is very nice for our 2 dogs and 2 cats. They can go in and out as they please.

How did you choose your neighborhood and find your home or apartment?

Merida is made up of the Centro area (downtown) and then many different neighborhoods which are called colonies and Fracc's. We were told by a realtor that many expats move to the North Merida area, which is nice and very safe with many stores and restaurants. He said anything above Calle 59 is good. We ended up finding a place in a small neighborhood called San Pedro Uxmal. I don't think there are many expats there, but the home had everything we wanted and the price was good. We are very happy there.

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

Are your housing costs higher or lower than they were in your home country? What is the average cost of housing there?

We are paying $12,000 pesos/month, which is about $625 USD which is less than we paid in a mobile home community in Florida. Our TV/Internet/Home phone is approx. $70/mo. We have not gotten the electric or water bills yet, but we have been told that electric is about the same as the US and water is cheap. Trash pickup is about $3/mo.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Merida

Healthcare in Mexico

Healthcare in Mexico

If you're moving to Mexico or an expat living in Mexico, understanding the Mexican healthcare system is essential. We offer an overview of the public and private healthcare systems in Mexico, health insurance for expats in Mexico, hospitals and prescription drugs.

Living in Merida

An expat talks about living in beautiful Merida, Mexico. This modern city of over 750,000 on the Yucatan still retains some of the Mayan culture. Parts of the city have very modern architecture while others have colonial. If you're moving to Merida, prepare yourself for the heat and friendly locals.

12 Tips for Living in Merida, Mexico

12 Tips for Living in Merida, Mexico in Merida

An expat talks about what it's like living in beautiful Merida, Mexico where the expat community is thriving -- there's even an expat bowling league. The Merida English Library holds wine tastings, plays, concerts and more. Real estate prices are low compared to the US, but that may not be for long.

Culture Shock in Merida

An expat in Merida, Mexico offers some insight into the challenges of settling in and living there. Some of the topics include driving, what it's like there if you don't speak Spanish, and much more. This expat clearly is an optimist and is determined to make life in Merida with her husband a success!

Join our Mexico Expat Forum

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

More about Mexico

5-Best-Places-to-Live-in-MexicoExpat Mexico: 5 Best Places to Live in Mexico

Mexico's lower cost of living, beautiful weather and warm, welcoming culture are a big draw for people looking to live abroad. However, Mexico's ever changing security situation impacts where expats choose to move. Here are 5 of the best places to live in Mexico based upon recent expat reviews.

10-Best-Places-to-Teach-Abroad10 Best Places to Teach Abroad

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai.

9-Best-Places-to-Live-on-Mexicos-Pacific-Coast9 Best Places to Live on Mexico's Pacific Coast

We've compiled a list of the 9 best places to live on the Pacific Coast of Mexico based upon expats' recommendations and security information from the US State Department. From Ensenada in Baja Norte all the way down to Puerto Escondido, these cities and towns boast beautiful beaches, warm weather and more.

9-Important-Tips-about-Healthcare-for-Expats-in-Mexico9 Important Tips about Healthcare for Expats in Mexico

Expats living in Mexico discuss health insurance and quality of medical care in Mexico.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment

Comments about this Report

kikipt
Feb 6, 2018 22:17

These people didn't do a very good of research before making such a momentous move. The problems with shipping goods could all have been easily handled with just a little foresight. We had none of these problems, because we did our homework and knew what to expect and how to handle things. That rent is actually rather high for Mérida. Our water bill is $10 a month, and electricity runs between $10 and $50 depending on the season, but it can be much higher if one is not careful with electrical use and ends in the high consumption category.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Healthcare in MexicoHealthcare in Mexico

If you're moving to Mexico or an expat living in Mexico, understanding the Mexican healthcare system is essential. We offer an overview of the public and private healthcare systems in Mexico, health insurance for expats in Mexico, hospitals and prescription drugs.

Restaurants in MeridaRestaurants in Merida

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

An expat talks about living in beautiful Merida, Mexico. This modern city of over 750,000 on the Yucatan still retains some of the Mayan culture. Parts of the city have very modern architecture while others have colonial. If you're moving to Merida, prepare yourself for the heat and friendly locals.

12 Tips for Living in Merida, Mexico12 Tips for Living in Merida, Mexico in Merida

An expat talks about what it's like living in beautiful Merida, Mexico where the expat community is thriving -- there's even an expat bowling league. The Merida English Library holds wine tastings, plays, concerts and more. Real estate prices are low compared to the US, but that may not be for long.

Culture Shock in Merida

An expat in Merida, Mexico offers some insight into the challenges of settling in and living there. Some of the topics include driving, what it's like there if you don't speak Spanish, and much more. This expat clearly is an optimist and is determined to make life in Merida with her husband a success!

Dream vs. Reality of Living in Merida

An expat who has lived in three countries talks about her expectations and the reality of living in Merida, Mexico compared to some of her other homes abroad.

5-Best-Places-to-Live-in-MexicoExpat Mexico: 5 Best Places to Live in Mexico

Mexico's lower cost of living, beautiful weather and warm, welcoming culture are a big draw for people looking to live abroad. However, Mexico's ever changing security situation impacts where expats choose to move. Here are 5 of the best places to live in Mexico based upon recent expat reviews.

10-Best-Places-to-Teach-Abroad10 Best Places to Teach Abroad

Anne Keeling highlights the 10 most popular cities for teaching overseas. From Dubai to Bangkok, Doha to Shanghai.

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

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /rspnet.cfm
Time Stamp 29-May-20 07:12 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
130 ms 130 ms 1 top level /home/www/html/rspnet.cfm
49 ms 49 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
43 ms 43 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
42 ms 42 ms 1 /home/www/html/navcontentboxcitypc.cfm
42 ms 42 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
8 ms 8 ms 1 /home/www/html/navtop_ctygd2.cfm
7 ms 7 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb_ctygd.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/eetr/rewritetipheading.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 6 /home/www/html/rewritearticle.cfm
0 ms 0 ms 5 /home/www/html/rewritecityname.cfm
0 ms 0 ms 5 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 5 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
135 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 @ 19:12:52.052
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 19:12:52.052
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 19:12:52.052
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 63
AND networkid = 77 
AND 74750 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 19:12:52.052
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 74750
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=5ms, Records=6) in /home/www/html/rspnet.cfm @ 19:12:52.052
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 74750 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 74750 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 19:12:52.052
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 74750 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:12:52.052
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:12:52.052
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmeta_rdesign4.cfm @ 19:12:52.052
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 19:12:52.052
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 19:12:52.052
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 74750 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:12:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-02-28"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 19:12:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-29 00:00:00.000"
and logtime < "2020-05-29 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 @ 19:12:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-22"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:12:52.052
	SELECT *
	From contentcountcountry
	Where networkid = 77 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 19:12:52.052
	SELECT *
	From contentcountcity
	Where citynetworkid = 4177 
getarticlesection (Datasource=expert, Time=0ms, Records=107) in /home/www/html/breadcrumb_ctygd.cfm @ 19:12:52.052
SELECT *
FROM articleCategories
 
WHERE section = 1
checkcitynetwork (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 19:12:52.052
		Select *
		FROM allreports, citynetworks
         where answerid = 74750
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
user (Datasource=forum, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 19:12:52.052
  SELECT *
  FROM users
  WHERE userid = 182136 
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 19:12:52.052
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 74750 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT *
FROM natadoptions 
WHERE 'moveheader' = tag
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
	Select *
	From Networks
	Where networkid = 77 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT *
FROM natadoptions 
WHERE natadtypeid = 6 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 6
and natadPlacement.networkID = 77
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-05-28"
and headerparagraphstart < "2020-05-29"
and headerparagraphstatus = 'live'

and (headerparagraphweight = 'medium' or headerparagraphweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
	Select *
	From Networks
	Where networkid = 77 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 19:12:52.052
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 77
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-28"
and natsentencestart < "2020-05-29"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
	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 = 4177
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = 0
    and cityintro = 'n'
    and summary <> ''
    
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-29" 
    ORDER by articles.articleID desc  
gethealthsummary (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 77 
         and allreports.answerid <> 74750 
          and citynetworkid = 4177
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 3310 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
            
         and allreports.answerid <> 74750         
         and networkid = 77
          and citynetworkid = 4177
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76048 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  4177
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
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 = 11 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
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 = 80408
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 80408 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80408'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 80408 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
checkculturefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 74750         
         and networkid = 77
          and citynetworkid = 4177
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74757 
gettaxgeneral (Datasource=expert, Time=6ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 19:12:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-05-29"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 19:12:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 19:12:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-28"
    and fromDate < "2020-05-29"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 19:12:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 19:12:52.052
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-05-28 19:12:52'}
    and fromDate <{ts '2020-05-29 19:12:52'}
    and weight > 7
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:12:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-05-28 19:12:52'}
    and fromDate <{ts '2020-05-29 19:12:52'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 19:12:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 19:12:52.052
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 74750 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 19:12:52.052
  SELECT *
  FROM users
  WHERE userid = 137779 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 74750         
         and networkid = 77
          and citynetworkid = 4177
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 3310 
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
            
         and allreports.answerid <> 74750         
           and city <> ''
         and networkid = 77
          and citynetworkid = 4177
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76048 
gethealthcare (Datasource=tipripper, Time=10ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 77
and allreports.networkid = 77
 and allreports.citynetworkid2 =  4177
and allreports.topicid = 11
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
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 = 11 
getanswerstext (Datasource=tipripper, Time=4ms, Records=12) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
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 = 80408
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 80408 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80408'
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80408'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 80408 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
checkculturefeature (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 74750         
         and networkid = 77
          and citynetworkid = 4177
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74757 
checkdreamfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
           and city <> ''
            
         and allreports.answerid <> 74750         
         and networkid = 77
          and citynetworkid = 4177
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 19:12:52.052
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 76054 


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/rspnet.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/rspnet.cfm
QUERY_STRING=rid=63&answerid=74750&networkid=77&start=74750
REMOTE_ADDR=162.158.78.128
REMOTE_HOST=162.158.78.128
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=28657667
cftoken=18651646
sessionid=IBEXPATEXCHANGE.COM_28657667_18651646
urltoken=CFID=28657667&CFTOKEN=18651646
URL Parameters:
answerid=74750
networkid=77
rid=63
start=74750
Debug Rendering Time: 77 ms