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

10 Tips for Living in Mexico

By Betsy Burlingame

Last updated on: Aug 26, 2018

Summary: Is it safe to live in Mexico? What should I bring with me to Mexico? How can I find a home? Expats offer advice on these and other topics.

Expat Mexico - 10 Tips for Living in Mexico

Meeting People in Mexico

"There is so much to do here and lots of people who speak English. The locals are very friendly. There are always exceptions but we have been very happy. It is a noisy country and there is dust. There is a theater group, a community choir, an art society and a multitude of clubs, restaurants, live music that you will recognize," explained an expat in Lake Chapala.

"The language is fun to learn, the food is great, a lot of people I've met are really special and I've made some friends, although it hasn't been easy. They are a close-knit culture with their families and don't accept gringas very willingly, but I'm okay. There are astoundingly beautiful places that I could never see the like in the States," shared an expat living in Guadalajara.

"MazInfo Yahoo Group and Sunday get-together, MazAmigos get-together, several ladies and mens lunches held weekly, Tourist Aide volunteers, Amigos de los Animals shelter volunteering, La Vina church, Friends of Mexico, American Library, discussion groups, exercise and dance classes, karaoke nights, walking the Malecon (seawalk), reading the Pacific Pearl and Maz Messenger magazines for activities schedules," suggested an expat in Mazatlan.

An expat in Manzanillo said, "We have two groups to meet other ex-pats. One is for couples, they meet weekly and go to dinner. Their name is Thirsty Thursdays. The other is a ladies lunch group. we meet once a month at the restaurant El Tablau, at 1 pm. Everyone is welcome and we generally have a speaker. From these two groups you can learn about the charities and opportunities in Manzanillo."

Finding a Home in Mexico

"This is a cash economy so it had to be a house I could afford. They have an MLS listings here so I could check out everything. I contacted a realtor and he helped weed out houses that had issues or less than savory neighborhoods. I wanted city water, a pressurized/filtration water system and city sewer. Many houses are on septic so I knew that I might have to make a compromise there. We had 14 houses on the final list. We bought the second one we had looked at and we paid cash. And it is on city sewer. We live in a single family dwelling that shares side walls with my neighbors. It is 2 story with 3 bedrooms and 2 baths. Houses are made with brick or cider block with a skin coat of concrete. Many houses have beautiful, lush gardens with indoor/outdoor living. We chose not to have one. Many people have maids and gardeners but it was not in our budget. Square footage of houses include covered porches so be aware of that. We looked at one house that a porch was 1/3 of the square footage which left very little living space," described an expat in Lake Chapala.

"Right now a condo on the beach with 2-3 bedrooms can be purchsed for as low as about 150,000.00 US dollars. This is a buying opportunity. We also have a beautiful house on the beach with 4 bedrooms for 869,000.00 US dollars. It is the perfect time to take advantage of our low prices," explained an expat realtor in Manzanillo, Mexico.

"We live in a large home one town over from where my husband works. I think the type of housing one chooses depends on the expat. Some are single and would rather live modestly and pocket the excess money from the monthly stipend they are given towards housing. Others have families and need/want more elaborate housing. I don't know any expats living here who aren't working for a U.S. company. This isn't the type of area people move to on a whim. They are sent here for work. The costs are a little less to about the same as the U.S. (to rent). The locals have realized they can get more for their properties because they are dealing with petroleum companies who are willing to pay. And, I think there was a housing shortage for a while. The house is nice though. We pay about usd $1800.00 for about 3000 sq.ft. You can rent cheaper places but you will generally end up with problems (leaking roof, older appliances)," said an expat in Comalcalco, Mexico.

"Puebla is a big city and neighborhoods vary. Ask the locals at Starbucks, the hip restaurants or at a local bar in the nice hotels for advice on the better/safer places to live. They are very well informed and friendly. The nicer places to live do require a lease, so come prepared with a proof of employment or job offer letter, a bank statement (you can get a Mexican account after you can present a lease), passport, visa and best of all if you have a local reference that is trusted above all. You will need a lease to begin internet, phone and electric service. Hot water and cooking gas comes in the form of gas. Yes GAS only! Your neighbors can help you with the number of the company that services your neighborhood. I live in a 300 year old historical neighborhood that is very exclusive. There are many expats from Germany, France and other countries in the city that mostly live in very modern, new houses. My home is rare to obtain even by the locals. I asked around at work, drove around the neighborhoods by taxi and by chance while exploring a neighborhood on foot I saw a For Rent sign on a very appealing hacienda. I knocked on the door and the owner rented it to me on the spot," advised an expat living in Puebla.

An expat living in Puerta Vallarta shared, "There are a few neighborhood guides online, including on insidepv.com, with pictures and video of the areas. It's relatively easy to choose where you want to be, because Puerto Vallarta is divided into 5 distinct areas- Marina, Hotel Zone, Centro, Old Town, Mismaloya. The marina is pricey, surrounded by a golf course and yacht slips, fine dining and art galleries. The hotel zone is a strip of resorts and modern shopping centers. These two areas resemble southern California or Florida. Centro is downtown Puerto Vallarta where the famous malecon boardwalk is located- loud, popular with tourists, fast paced Old Town Puerto Vallarta is slower paced, trendy, more traditional with cobblestone streets, residences, bars/clubs- this is also the popular gay area and has become quite stylish. Mismaloya is farthest south with different areas along the way, marked by "the crescent beaches." This area is lush in tropical jungle and lined with villas and luxury condominiums overlooking private beaches and the ocean."

Cost of Living in Mexico

"Much lower. We pay our property taxes and water yearly. Our taxes are $699 MX and water is $1000 MX per year. Electricity is expensive in Mexico but still less than the US and is paid every other month. We have our propane tank filled on the off month and runs about $1600 MX for 2 months. Phone and internet is $600 MX per month and that is with unlimited long distanse. We have satelite which comes out of Canada. They have grocery stores that carry US products but it is imported and therefore expensive. Produce, eggs, meat, chicken and fish is amazing and reasonable. You can pay as much as you want or as little as you have for a house and find something to fit your needs," said one expat living in Mexico," said one expat.

"Much lower. I moved here from New York where my rent was close to 3,000 USD for a loft. My rent now is around 700 USD for a very nice 1 bedroom. Inland, apartments start at $100-$300 USD for decent apartments. To be near the beach however, expect to pay no less than $600 for something decent, and around $1000 for something really nice. Utilities are unpredictable but inexpensive for the most part. I work for InsidePV.com so I have at least 2 computers running all day, and occasionally run the air conditioner. This runs me about $35 USD per month. If I run the air conditioner regularly, the bill can easily jump to double or triple," explained an expat in Puerto Vallarta.

Expat Health Insurance in Mexico

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

What to Bring When You Move

"We brought a lot. 9000 lbs. I would bring the things that make me feel good about my home. (personal things, art) In Manzanillo the sea air is hard on good art and metals. So I would think twice about bringing things of huge value that you want to leave in your family. If you love them and just want to enjoy them, bring them. Electronics, like computers, that you want in English you should bring. If you are a gourmet, bring your pots and pans, bring what it is that you love. Everything else leave," explained one expat living in Manzanillo.

"I wish I had brought more electronics, books, and computer software. All are easily double or triple the price in the US. This includes computers and pc accessories, cell phones, stereos, tv's, books, and magazines, etc. I also wish I would have brought a dehumidifier- they are impossible to find here but absolutely essential. Quality cosmetics, beauty products, and health products are not available here and what is, is limited or made with locals in mind- for example, products for dark hair and skin tones or health shakes made from a local cactus. Comfortable furniture - beds, sofas, and chairs are usually hard as rocks here with rough fabrics. What I could have left are most of my designer clothing and high heels- cobblestone streets ruin shoes and humidity eats fine fabrics. It's not uncommon to go to your closet and pull out a shirt with mildew on it after even a week," advised one expat living in Puerta Vallarta.

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

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.

Learning Spanish

"But if you want to fully enjoy the experience you will want to learn their language so that you can be a part what's going on around you and stop having your eye's glaze over when they start talking to you," advised an expat living in Ajijic.

"I had no knowledge of the Spanish language before moving. I am presently enrolled in Spanish language classes 5 days weekly. It's fun and it certainly helps to become and to feel more a part of the community," explained an expat living in Tequisquiapan.

Life in Mexico

"Fresh food -- veggies, fruit everywhere. Street markets that have everything you need, and the smell of cooking. People saying "buenas dias" and "buenos tarde" when passing on the street. No one's in a hurry, except macho jovenes in their cars, and then it's only to the next tope. Tequila and basic Mexican home cooking. The craftsmen and women, who still make items as their parents and parents before them did, and the fact that chicken wire has so many uses," shared an expat living in Lake Chapala.

"The broken sidewalks, the falling bricks of ancient, beautiful but decrepit houses, the protruding live electric wires, tree branches and glass cases of electric meters, that all do their damn best to discourage you from indulging in reveries while walking," described one expat.

"[I appreciate] The love of family. The societal urge to celebrate everything and anything possible. The pace of life. The priorities of day to day living. I love the way we greet each other. I like the impromptu-ness of life here," explained another expat.

Another expat said, "I appreciate the "family unit" the most. It mirrors the way things must have been with early migration to the U.S. during and after WWII. I love the ingenuity of the Mexican people. I enjoy seeing their appreciation when you show enthusiam for a job well done. I love that the women cook everything from scratch....little if any pre-cooked foods. Most of all, I truly enjoy the simplicity of life. I find I have a smile on my face most of the time. No Drama (except for the novelas)! Life is good."

Saying "No" in Mexico

"Saying "NO" for a Mexican is difficult, so a "YES" not always means "YES". If they are trying to explain that something cannot be done, it won?t be done even if you get a "YES" at the end. A "Maybe" can be translated as "NO"," explained one expat.

Safety in Mexico

"Narco cartels and the resulting territorial violence is more than challenging -- it's scary when it gets close," said an expat in Lake Chapala.

"Don't move here! I was nearly kidnapped. The cartels have made this place way too dangerous! I fled this place to save my life and the life of my husband and lost everything! You have to be insane to consider living in Mexico these days," exclaimed one expat in Tijuana.

Another member in Cardenas, Tabasco said, "Mexico is changing rapidly in regards to safety. I would live in larger cities where it is easy to blend in. In small towns you stick out like a sore thumb. I built a store in Poblado 20, Cardenas, in the state of Tabasco. Everything was fine the first year. Now the cartel is moving in. It has become very dangerous from a kidnapping standpoint and we are leaving. I am going to Ciudad del Carmen. In the small poblados and countryside, there are no police. There is no one to report a crime to. And if there are police, no one to solve it."

"I live in a small colonial town called Tequisquiapan, in the state of Queretaro. There is virtually no crime here. One thing one ought to remember...this is a poor country, with many unemployed men looking for ways to make a peso or two. If you have beautiful, expensive jewelry leave it in your home. If you flaunt your wealth someone will feel entitled to a portion of it. Use common sense," recommended another expat.

An expat in Saltillo explained, "I've been living here for nearly 10 years. While I do still love it here, all the bad press about Mexico isn't just a pact with the devil to keep dollars out of Mexico. It really is dangerous here. But I realize that geography has a lot to do with that perspective. I live in Coahuila (Saltillo), and my in-laws divide their time between Mexico City and Morelos. We now joke that Mexico City is the safest place for us to be. *sigh* Had you asked me last year, I might have agreed with many of you about the bad press. Now, unfortunately I've got to admit that it's deserved (in part--I haven't been to the US in over a year, so I don't know exactly what they're saying there). However, the reality is that I am getting tired of checking Twitter every time I want to leave the house, in order to find out if they're shooting up wherever it is that I want to go. A silver lining is that friends seem to reach out more, emailing and calling on the phone warn us to not leave our houses when they find out that "stuff" is going down. We still walk around downtown, commenting how much we like it here (Saltillo). Then we have to add, "but it's such a shame that they're shooting at us." Sometimes we can forget about it, but it's a big "but."

Violence and safety concerns in Mexico seem to vary greatly by region. Read our article, Crime in Mexico: Where are the Safest Places to Live in Mexico? for a better look at this topic.

Schools in Mexico

Expat Exchange members have submitted reports about numerous expat schools in Mexico - many in Mexico City -- Westhill Institute in Mexico City, Greengates School in Mexico City and many other reports about schools in Mexico.

Parenting in Mexico

An expat parent described parenting in Mexico, "Mexico is a much more spontaneous place, with lots of last-minute changes and invitations. We have had to learn to go with the flow more than we had to at home. We've had to re-gauge when to hold firm and fast to the rules, and when to give them some wiggle-room, since this is a new context. We are also now immigrant parents, with a culture gap between us and our now very Mexican son. Before our move we shared a culture much more fully. There is also now a culture gap between us and our son's friends, school, etc. All new dynamics that did not exist at home."

Join our Mexico Expat Forum

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

Read Next

Expat-Life-in-MexicoBook Review: "Mexico: The Trick is Living Here"

Julia Taylor's book is packed with practical advice and cultural insight and is a must have for expats and anyone preparing to make the move to Mexico.

Where-are-the-Safest-Places-to-Live-in-MexicoCrime in Mexico: Where are the Safest Places to Live in Mexico?

Where are the safest places to live in Mexico? The most unsafe areas are well-covered in today's news headlines, but those considering a move to other cities or towns in Mexico should carefully research their possible destinations, talk with other expats and visit before they move. This article highlights members' recent discussions and comments about crime and safety in popular expat locales and some off-the-beaten path destinations. If you live in Mexico, we encourage you to submit an update on your city or town.

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-Tips-for-Living-in-Lake-Chapala,-Mexico10 Tips for Living in Lake Chapala, Mexico

Lake Chapala is one of Mexico's most popular expat destinations - especially among retirees. Expats love Lake Chapala's near perfect climate, beautiful lakeside homes, low cost of living and thriving expat community. Sadly, Lake Chapala is not immune to Mexico's drug cartel related violence, which those thinking of moving to Lake Chapala should take into consideration.

About the Author

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

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

profwo
Dec 19, 2013 10:12

Singularly the most informative article I've read. Succinct with excellent links. George

guest
Apr 21, 2017 11:42

HI; Good information. How do I find out about shipping some household goods. Who is a reliable mover that is affordable thanks

rbeckerchi
Aug 26, 2018 12:40

As of September 2018; can ANYONE who has lived in Mexico for at least 3 years or more (preferably), actually tell me what are the top 3 SAFEST places for an American to retire in Mexico and why?? I see there is A LOT of bad press about Mexico but I REALLY want to know what is fact vs fiction. Thanks

First Published: Sep 17, 2012

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Puerto-PenascoAn Expat Talks about Culture Shock & Living in Puerto Penasco, Mexico

An expat in Puerto Penasco, Mexico appreciates the lower priced food and rent. She loves seeing the fishermen repair their nets on her street preparing for the next day of fishing. She advises newcomers to use your Spanish, even if you make mistakes, and eat the delicious street food.

An expat in Puerto Penasco, Mexico appreciates the lower priced food and rent. She loves seeing the fishermen repair their nets on her street preparing for the next day of fishing. She advises newcom...

Living-in-HuatulcoAn Expat Discusses Living in Huatulco, Mexico

An expat in Huatulco talks about living in this remote part of Mexico, which is a 7 hour drive from the nearest city. He cautions anyone considering a move to be realistic about whether or not they can handle the isolation and remoteness.

An expat in Huatulco talks about living in this remote part of Mexico, which is a 7 hour drive from the nearest city. He cautions anyone considering a move to be realistic about whether or not they ...

Expat-Life-in-MexicoBook Review: "Mexico: The Trick is Living Here"

Julia Taylor's book is packed with practical advice and cultural insight and is a must have for expats and anyone preparing to make the move to Mexico.

Julia Taylor's book is packed with practical advice and cultural insight and is a must have for expats and anyone preparing to make t...

Where-are-the-Safest-Places-to-Live-in-MexicoCrime in Mexico: Where are the Safest Places to Live in Mexico?

Where are the safest places to live in Mexico? The most unsafe areas are well-covered in today's news headlines, but those considering a move to other cities or towns in Mexico should carefully research their possible destinations, talk with other expats and visit before they move. This article highlights members' recent discussions and comments about crime and safety in popular expat locales and some off-the-beaten path destinations. If you live in Mexico, we encourage you to submit an update on your city or town.

Where are the safest places to live in Mexico? The most unsafe areas are well-covered in today's news headlines, but those considering a move to other cities or towns in Mexico should carefully resea...

10-Tips-for-Living-in-Mexico10 Tips for Living in Mexico

Is it safe to live in Mexico? What should I bring with me to Mexico? How can I find a home? Expats offer advice on these and other topics.

Is it safe to live in Mexico? What should I bring with me to Mexico? How can I find a home? Expats offer advice on these and other topics....

15-Expats-Talk-About-Life-in-Mexico15 Expats Talk About Life in Mexico

Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there.
Expats share some insight into what it's like to live in Mexico on a day-to-day basis once you actually make the move and get there....

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 /lib_rd.cfm
Time Stamp 03-Jun-20 01:10 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.25
Host Name 173.245.54.25


Execution Time

Total Time Avg Time Count Template
67 ms 67 ms 1 top level /home/www/html/lib_rd.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
10 ms 10 ms 1 /home/www/html/lib_rd_readnext.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/breadcrumb.cfm
7 ms 7 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navcontentbox.cfm
6 ms 6 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/navmeta_rdesign4.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 0 ms 11 /home/www/html/rewritearticle.cfm
1 ms 1 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_4120_11917.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /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 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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
73 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 @ 13:10:55.055
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 13:10:55.055
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 13:10:55.055
	Select *
	From articles
	Where articleID = 4120
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 13:10:55.055
	Select *
	From sponcers
	Where sponcerID = 0 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 13:10:55.055
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4120 
	and articles.articleID = 4120 
	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 @ 13:10:55.055
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4120
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4120
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:10:55.055
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:10:55.055
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=0ms, Records=21, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 13:10:55.055
	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 @ 13:10:55.055
  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=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 13:10:55.055
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4120 
  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 @ 13:10:55.055
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.25'
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 @ 13:10:55.055
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.25'
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 @ 13:10:55.055
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.25'
and logtime > "2020-05-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:10:55.055
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 13:10:55.055
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 13:10:55.055
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:10:55.055
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 13:10:55.055
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4120 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 13:10:55.055
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4120 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=8ms, Records=2) in /home/www/html/breadcrumb.cfm @ 13:10:55.055
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

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

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

and natsentenceweight = 'high'
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 13:10:55.055
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4120 
gettaxgeneral (Datasource=expert, Time=8ms, Records=4) in /home/www/html/lib_rd_readnext.cfm @ 13:10:55.055
	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 summary <> ''
    and articles.articleID <> 4120
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 13:10:55.055
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-02"
    and fromDate < "2020-06-03"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 13:10:55.055
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    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 @ 13:10:55.055
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:10:55.055
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-06-02 13:10:55'}
    and fromDate <{ts '2020-06-03 13:10:55'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 13:10:55.055
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=3) in /home/www/html/commentsnew_rdesign4.cfm @ 13:10:55.055
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4120 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:10:55.055
  SELECT *
  FROM users
  WHERE userid = 69954 
GetUser (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 13:10:55.055
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 13:10:55.055
  SELECT *
  FROM users
  WHERE userid = 118299 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 13:10:55.055
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4120 
checkculturefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 77 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
		Select summary, hiimg 
		FROM answers
         where answerid = 75686
         and summary <> ''
checklivingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 77 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
		Select summary, hiimg 
		FROM answers
         where answerid = 76539
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
	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 summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-03"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-03"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:10:55.055
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 28
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:10:55.055
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:10:55.055
SELECT  hiimg
FROM rptarticles
where rptarticleID = 28
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/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=4120&networkid=77
REMOTE_ADDR=173.245.54.25
REMOTE_HOST=173.245.54.25
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=28939850
cftoken=11205070
sessionid=IBEXPATEXCHANGE.COM_28939850_11205070
urltoken=CFID=28939850&CFTOKEN=11205070
URL Parameters:
articleID=4120
networkid=77
Debug Rendering Time: 12 ms