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

Mexico Expat Forum

Retiring in Puerto Vallarta

Post New Topic
raeernisse
1/29/2014 22:55 EST

We are considering retirement in PV and would love to hear from expat that has made the move to area. We are particularly interested in what housing is available in what area(would like to be close to the beach) that is safe. Also would like to know about taxes (income tax specifically) and estimated costs of living. Thanks.

Post a Reply

00abuse

jpaford
1/30/2014 11:14 EST

Me too! Oct 1....will be watching for responses to your post I hav lived there before so I have some insites. There are Facebook and Expats in Vallarta-is a online site you might check out.

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

jpaford
1/30/2014 11:17 EST

We are currently in the hunt for a place to rent--and that is a scary thing--there are some people I am learning to avoid--and they are the most visable! Craigslist Vallarta has a lot of posts too. Good luck. email me if you want to chat.

Post a Reply

00abuse

sunshine71
1/30/2014 12:06 EST

I retired inPV 12 years ago, and I love every inch of it! I chose to live in the Marina, on the beach. It is an exclusive area, but property is much cheaper than it was in CA, and now is a buyers market! Income tax, your earnings from the bank or financial institutions are taxed automatically, taken out of your proceeds. Mexico does not tax your internatonal income, only the USA does that. Property tax is very cheap~Any questions, I am happy to help answer.

Post a Reply

00abuse

nelsonokelmgmailcom
1/30/2014 12:11 EST

My wife and I have been living in PV for 4 months. Love it here. I am not aware that there are any areas in PV that are not safe. We walk all over town and do not feel threatened. We drove our suburban down. Having a vehicle is a real plus. Although the public transit is extensive and low cost. Depending on what type of immigration you intend it may be necessary to license your vehicle here (a real pain in the rear!). Be advised that this time of year there are very few "decent" condos/apartments available. The snowbirds have decimated the inventory. Best time to seek a domicile is April-July when the inventory is at its max. We flew down in July to secure a place. I was concerned about the heat. It is amazing how your body acclimatizes to the heat. Plus there is an almost constant onshore breeze. Find a place on a hill! If you have any specific questions I'll be glad to help.

Nelson

Post a Reply

20abuse

LovePV
2/3/2014 08:51 EST

We just bought a condo in Nuevo Vallarta at a very reasonable price. It is gated as is the overall Nuevo area, although I agree we feel safe almost anywhere in PV, near the beach. We used Kim Moore in the PV Marina District as our realtor. She can help with a rental or if you buy. Very honest and from the USA. Has lived here many years. She did an excellent job for us. She also helps you with all the nuances of buying in Mexico. 0443221498563. Costa Alegre Realty.

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

marilynexpat
5/19/2014 01:19 EST

Hello there. I would love to know why you love living in Puerto Vallarta so much. I am considering buying there. Please tell me what life is like living there. Do you need to know Spanish well to communicate with all the locals also?

Post a Reply

00abuse

LovePV
5/19/2014 04:05 EST

We are in Nuevo Vallarta, just north of PV. We feel very safe in PV and Nuevo. We're walking distance to Bucerias which has lots of restaurants and quaint shops. The beach in Nuevo is one of the best on Banderas Bay.It is a sand beach and you can walk for miles. Nuevo is gated and the condo is also gated. The entire area is well maintained.

You don't need to speak Spanish. Most people can communicate with you and go out of their way to help you. The Mexicans are very family/friendly oriented. There is a large population of Americans and Canadians in the winter months.

Downtown PV is really fun as well. In general there is allot to do if you like fishing, snorkeling, whale watching, shopping, para-sailing, sailing etc.

The Airport is about 15 minutes from us. They have customs and immigration's streamlined so it doesn't take long.

Medical is good. There is a new Hospital in Nuevo and lots of Urgent Care locations. Their medical services gets high reviews.

Taxi service is reasonable and readily available. Buses are cheap and great in Nuevo. The PV City buses are old and not very nice but they get you where you need to go.

Lots of options for groceries. There are 2 Walmart's, two other similar stores and a Costco.

Banking is easy. We use InterCam. When we had remodeling done our banker received all the bills and made payment for us. She was like having a personal assistant.

Our Realtor is American and was great at guiding us through all the issues.

Post a Reply

20abuse

hpropp
5/20/2014 21:34 EST

We are also looking to relocate/retire to PV!!! This thread has been immensley helpful! We are looking to be there by May 2015, we just got back a week ago from 12 days looking at property. Thanks for all the good info and the leads to other info! Will be watching the others for all of their relocation info, as well as sharing my own soon!

Post a Reply

00abuse

LovePV
5/20/2014 22:31 EST

What are you looking for? Condo? house? Do you have a location that you are zooming in on?

Post a Reply

00abuse

sparksmex
5/21/2014 13:16 EST

Rent, rent and rent some more. Be absolutely sure of your chosen community, Mexico in general and if you can take summer beach temperatures. Very expensive to be running air conditioning 24/7 ..... or at all

Post a Reply

00abuse

LovePV
5/27/2014 21:39 EST

The area to rent or buy depends on what you are looking for. Old Town is very quaint and the architecture can be beautiful. It is walking distance to restaurants and shopping. Many homes and condo's are older. If you are on a hill be aware it can be difficult to walk home from the beach. The beach isn't that long in the area and is often crowded.

The PV Marina is starting to look run down. Allot of shops in the PV Marina District have closed down and it is desolate. The last several times we have been there it was void of tourists. Your investment might not be the best in PV Marina District. People seem to be going to Old Town or Nuevo Vallarta. Likely for the reasons I mentioned before. Again it has the best beach and almost all condo complexes are on the beach. Resteruants and shops are a little further away... mostly in Bucerias. There are a few in Nuevo.

Post a Reply

00abuse

LovePV
5/27/2014 22:30 EST

We have a beachfront condo in the north end of Nuevo Flamingos and love it. The area is continuing to grow, is gated and safe, and has easy access to medical, grocery, banks, restaurants, both inside Neuvo and 1 mile away in Bucerias. Restaurant food is very good and reasonable. Nuevo beach is the best, flat and good for swimming and some boogyboarding. Nuevo Marina has water ferry to downtown and Rythyms of the Night, plus whale watch. Las Cruces, and Punta de Mita are close and have good restaurants and watersports. Love it all.

Post a Reply

00abuse

retireready
5/30/2014 11:22 EST

Does anyone have an opinion on living in the Alta Vista area? We're considering a long-term rental on a condo there and would value any recommendations and tips. Much appreciated!

Post a Reply

00abuse

raeernisse
6/18/2014 20:38 EST

Thanks to all for the info. Well, we went to PV last part of May and fell in love. We will definitely be moving there in 700 days :). We went to every area and decided on the Romantic Zone as the area we will live. As one would expect we have many questions. We are researching healthcare polices, visas etc. A couple of questions maybe someone can help answer are:

1) What do you do for cell service? Costs?
2) We plan to fly down (will be selling cars) and need to know how many bags, boxes can we bring on the plane? Are there limitations of what we can bring (i.e., kitchen knives, small appliances).
3) We have our investments with Fidelity and hope to have our pensions deposited there. Is there a need for a bank account?

Thanks.

Post a Reply

00abuse

bgrateful
12/15/2015 19:18 EST

I am moving there this month and would like to know if you know of any rentals? I am moving from San Diego Ca. I love the area.

Post a Reply

00abuse

LovingPV
12/15/2015 23:09 EST

Tim Longpre has the largest inventory of rentals in town:

All price ranges & types.

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Mexico.

International Moving Quotes

Moving to Mexico? Get a moving quote.


Mail Forwarding to Mexico

Mail Forwarding to Mexico.


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 Mexico from our partner, Cigna Global Health.
Get a Quote

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....

Book-ReviewBook 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...

Crime-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...

Expat-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....

Retirement-In-ApizacoAn Expat Shares What it's Like Retiring in Apizaco, Mexico

A retiree in Apizaco, Mexico talks about retiring in Mexico. He and his wife decided to move to Mexico for the lower cost of living and climate.

A retiree in Apizaco, Mexico talks about retiring in Mexico. He and his wife decided to move to Mexico for the lower cost of living and climate. ...

Moving-To-Puerto-PenascoAn Expat Talks about Moving to Puerto Penasco, Mexico

An expat talks about living in the Mirador section on Puerto Penasco, Mexico - the close proximity to Tuscon, the lower cost of living finding a rental and more.

An expat talks about living in the Mirador section on Puerto Penasco, Mexico - the close proximity to Tuscon, the lower cost of living finding a rental and more....

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 /expat/index.cfm
Time Stamp 31-May-20 02:52 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
69 ms 69 ms 1 /home/www/html/expat/Application.cfm
36 ms 36 ms 1 /home/www/html/expat/messages_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/expat/message_rdesign5.cfm
19 ms 19 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
12 ms 1 ms 17 /home/www/html/navvote_rdesign5.cfm
11 ms 11 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
8 ms 8 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navcontentbox.cfm
5 ms 5 ms 1 /home/www/html/navtop_rdesign5.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
3 ms 0 ms 17 /home/www/html/expat/common/formatmsg.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/constants.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
1 ms 1 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
1 ms 1 ms 2 /home/www/html/navinjection.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/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/ibstyle.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_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.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
69 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 @ 14:52:19.019
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/expat/Application.cfm @ 14:52:19.019
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 14:52:19.019
	Select *
	From Networks
	Where frmid = 254 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 254 
getcities (Datasource=expert, Time=0ms, Records=21, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	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/navmetaforums_rdesign5.cfm @ 14:52:19.019
  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, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select *
	From Networks
	Where networkID = 77 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
  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 = 254 
  AND t.tpcid = 3382024 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=5ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
  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 = 3382024
  and  t.tpcid = 3382024
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=62, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 77
	order by lastsent ASC
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
  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 = 3382024
  and  t.tpcid = 3382024
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=0ms, Records=62, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 14:52:19.019
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 77
	order by lastsent ASC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:52:19.019
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-03-01"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:52:19.019
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-31 00:00:00.000"
and logtime < "2020-05-31 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 @ 14:52:19.019
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.128'
and logtime > "2020-05-24"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:52:19.019
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 14:52:19.019
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-05-30"
    and fromDate < "2020-05-31"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:52:19.019
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 14:52:19.019
  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 = 254 
  AND tpcid = 3382024 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0, Cached Query) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 14:52:19.019
  SELECT u.userid, u.username, u.userdbname 
  FROM users u, moderators mo
  WHERE u.userid = mo.userid
  AND mo.frmid = 254
  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 @ 14:52:19.019
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 14:52:19.019
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=5ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 14:52:19.019
  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 = 3382024
  AND m.userid = u.userid
  AND topics.tpcid = 3382024
  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=4ms, Records=16) in /home/www/html/expat/messages_rdesign5.cfm @ 14:52:19.019
  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 = 3382024
  AND m.userid = u.userid
  AND topics.tpcid = 3382024
    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 @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217476
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217476
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
	Select *
	From Networks
	Where networkid = 77 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=1ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 77
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-30"
and natforumstart < "2020-05-31"
and natforumstatus = 'live'

and natforumweight = 'high'
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217479
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217479
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217486
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217486
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217487
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 217487
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 218048
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 218048
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=0ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
	Select *
	From Networks
	Where networkid = 77 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 77
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-30"
and natforumstart < "2020-05-31"
and natforumstatus = 'live'

and natforumweight = 'high'
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 14:52:19.019
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 @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236350
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236350
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=2) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236358
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236358
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236695
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236695
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236705
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236705
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236919
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 236919
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 237995
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 237995
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 238001
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 238001
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 238439
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 238439
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 241597
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 241597
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 326317
and liketype = 6 
votebadcount (Datasource=forum, Time=1ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 326317
and vote = 'bad'
and liketype = 6 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 326328
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 14:52:19.019
SELECT vote
FROM votes
WHERE voteid = 326328
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=0ms, Records=1, Cached Query) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 14:52:19.019
	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 = 77
	AND "2020-05-31" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
checkrptarticles (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:52:19.019
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-31"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=0ms, Records=1, Cached Query) in /home/www/html/rewritearticlefirsttitle.cfm @ 14:52:19.019
	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 @ 14:52:19.019
	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 @ 14:52:19.019
SELECT  hiimg
FROM rptarticles
where rptarticleID = 28
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=0ms, Records=3, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:52:19.019
	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-05-31"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:52:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         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 @ 14:52:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 74253
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=0ms, Records=4, Cached Query) in /home/www/html/navcontentbox.cfm @ 14:52:19.019
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         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 @ 14:52:19.019
		Select summary, hiimg 
		FROM answers
         where answerid = 75685
         and summary <> ''


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=254&tpcid=3382024
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=28764219
cftoken=83252479
sessionid=IBEXPATEXCHANGE.COM_28764219_83252479
urltoken=CFID=28764219&CFTOKEN=83252479
URL Parameters:
frmid=254
tpcid=3382024
Debug Rendering Time: 11 ms