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

Mazatlan or Puerto Vallarta - where do you prefer to live as an expat and WHY? ;-)

Post New Topic
expat2016
5/11/2016 03:09 EST

If you are an expat from the US/Canada, where do you prefer to live as an expat and WHY - Mazatlan or Puerto Vallarta??? ;-)

AARP, International Living, Live and Invest Overseas all rank PV very high, but not for Mazatlan. What's your experience and opinion? Beachfront condos pricing in Mazatlan look very attractive.

Thank you.

Post a Reply

00abuse

Cozumeldeb
5/11/2016 07:47 EST

Drug cartels killed Mazatlan, housing cheap because ex-pats lost their asses on real estate..there was a time when cruise ships would not even dock there..Safety first...Ex-pat community's Lake Chapla & Ajjica are rated #1 ex-pat location, near perfect climate...if u are more interested in ocean, Yucatan/QROO is the best.

Post a Reply

10abuse

allianz international health insurance

For expats in Mexico, choosing an expat health insurance provider is an important decision. Get a quote from our partner, Allianz Care. Their plans ensure that you have access to quality healthcare whenever you need it. Allianz Care's flexible solutions allow you to tailor your cover to meet your needs and budget.

Get a Quote

souix
5/12/2016 13:01 EST

Hope you can withstand EXTREMLY HOT SUMMERs? Running AC is not any cheaper either.

Post a Reply

00abuse

sunshine71
5/13/2016 13:24 EST

I love living in PV, been here as a single female for 14 years. Very safe, lots of English spoken, If you live right on the beach, which is more expensive, there is no pollution, fresh air, and a little cooler, with the ocean breeze. Biggest problem in life is figuring out which bathing suit to wear!!!! And what day the repairman will show up!

Post a Reply

10abuse

KiteFlyer
5/23/2016 12:05 EST

I guess I should stick up for Mazatlán, since I have lived here year round for over 12 years.

First, if you live here you would disagree with the statement that drug lords killed the city. Yes, it is true we have had (notice the past tense) some tough years, but those are pretty well behind us. Our housing market is coming back and a number of my friends sold their homes this season and none lost their ass. We did lose cruise ships in 2011, but this year everyone was back except Disney and they are returning next season. This season about 275,000 cruise passengers visited our city.

As far as the weather, Mazatlán has a tropical wet and dry/ savanna climate with a pronounced dry season in the low-sun months. There is no cold season, but our wet season is in the high-sun months. Beginning in May and continuing through October the governments subsidizes consumers’ electric rates. So most often we pay a lower bill in the summer than we do in the winter, but certainly not higher.

Over the years I have been living in México, I have visited many Mexican cities and have friends who have lived in a number of them. Without exception everyone says Mazatlán has a sense of community that you do not find anywhere else.

Unlike Puerto Vallarta, tourism is not the city’s primary industry. Mazatlán has the largest fishing fleet on the Pacific coast and fishing is its primary industry. So, when the season is over in April/May, our city continues to flourish.

One advantage Puerto Vallarta has over Mazatlán is air service. But, that is improving in Mazatlán.

Before you choose, visit our fair city.

Post a Reply

00abuse

nelsonokelmgmailcom
5/23/2016 12:25 EST

We have been living in PV almost 3 years full time. And loving it. We have a great eXpat community here. Spend time in both and make an informed decision. PV is probably more expensive to live. Don't really think you can say that one is "better" than the other. Depends upon YOUR preferences! So have fun exploring both and chose based upon YOUR observations. Love living in Mexico!! Good luck and make it fun!!!

Post a Reply

00abuse

allianz international health insurance

For expats in Mexico, choosing an expat health insurance provider is an important decision. Get a quote from our partner, Allianz Care. Their plans ensure that you have access to quality healthcare whenever you need it. Allianz Care's flexible solutions allow you to tailor your cover to meet your needs and budget.

Get a Quote

souix
5/23/2016 13:49 EST

No Mosquitos???????

Post a Reply

00abuse

Expatriate Health Insurance

Get a quote for expat health insurance in Mexico.

International Moving Companies

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!

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 30-May-20 09:35 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
123 ms 123 ms 1 /home/www/html/expat/Application.cfm
64 ms 64 ms 1 /home/www/html/expat/navsidesbottomforum_rdesign5.cfm
64 ms 64 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
63 ms 63 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
37 ms 37 ms 1 /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/expat/messages_rdesign5.cfm
25 ms 25 ms 1 /home/www/html/expat/navtop2forum_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/expat/message_rdesign5.cfm
14 ms 14 ms 1 /home/www/html/navmetaforums_rdesign5.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
6 ms 3 ms 2 /home/www/html/nativerotationtop_tester13.cfm
6 ms 1 ms 7 /home/www/html/navvote_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/expat/navforumads_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 7 /home/www/html/expat/common/formatmsg.cfm
0 ms 0 ms 1 /home/www/html/expat/constants.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/queries/qry_DesignSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetCategory.cfm
0 ms 0 ms 1 /home/www/html/expat/queries/qry_GetModerators.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign4.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
123 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_GeneralSet.cfm @ 21:35:23.023
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/expat/Application.cfm @ 21:35:23.023
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expat/navtop2forum_rdesign5.cfm @ 21:35:23.023
	Select *
	From Networks
	Where frmid = 254 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, welcomefrmid, networkintro, shortnamecap
	From Networks
	Where frmid = 254 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	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 @ 21:35:23.023
  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=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	Select *
	From Networks
	Where networkID = 77 
GetTopicTitle (Datasource=forum, Time=1ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
  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 = 3411116 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
  AND t.tpcid = m.tpcid
  AND m.msgparent = 0
GetTopicInformation (Datasource=forum, Time=4ms, Records=1) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
  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 = 3411116
  and  t.tpcid = 3411116
  AND m.userid = u.userid
  AND m.msgparent = 0
  AND m.isdeleted <> 1
getcountryphoto (Datasource=expert, Time=1ms, Records=62) in /home/www/html/navmetaforums_rdesign5.cfm @ 21:35:23.023
	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 @ 21:35:23.023
  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 = 3411116
  and  t.tpcid = 3411116
  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 @ 21:35:23.023
	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 @ 21:35:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 21:35:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 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 @ 21:35:23.023
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 21:35:23.023
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 21:35:23.023
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 21:35:23.023
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 21:35:23.023
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
GetNavigator (Datasource=forum, Time=0ms, Records=1) in /home/www/html/expat/Application.cfm @ 21:35:23.023
  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 = 3411116 
  AND f.isactive = 1
  
  and f.frmid = t.frmid
GetModerators (Datasource=forum, Time=0ms, Records=0) in /home/www/html/expat/queries/qry_GetModerators.cfm @ 21:35:23.023
  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 @ 21:35:23.023
  SELECT *
  FROM categories
  WHERE catid = "2"
DesignSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/expat/queries/qry_DesignSet.cfm @ 21:35:23.023
  SELECT * FROM designset
  WHERE designsetid = 11 
GetFirstMessage (Datasource=forum, Time=6ms, Records=1) in /home/www/html/expat/messages_rdesign5.cfm @ 21:35:23.023
  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 = 3411116
  AND m.userid = u.userid
  AND topics.tpcid = 3411116
  AND forums.frmid = topics.frmid
  AND forums.dbname = "ee"
  AND m.isapproved = 1
  AND m.msgparent = 0
  AND m.isdeleted <> 1
GetMessages (Datasource=forum, Time=5ms, Records=6) in /home/www/html/expat/messages_rdesign5.cfm @ 21:35:23.023
  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 = 3411116
  AND m.userid = u.userid
  AND topics.tpcid = 3411116
    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=1) in /home/www/html/navvote_rdesign5.cfm @ 21:35:23.023
SELECT vote
FROM votes
WHERE voteid = 353901
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:35:23.023
SELECT vote
FROM votes
WHERE voteid = 353901
and vote = 'bad'
and liketype = 6 
getnatadtopull (Datasource=expert, Time=1ms, Records=8) in /home/www/html/nativerotationtop_tester13.cfm @ 21:35:23.023
SELECT *
FROM natadoptions 
WHERE placementname = 'natforumtype' 
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:35:23.023
	Select *
	From Networks
	Where networkid = 77 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:35:23.023
SELECT *
FROM natadoptions 
WHERE natadtypeid = 3 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 21:35:23.023
SELECT resourceid, natforum as adcode, natforumweight, natads.natadid
FROM natads, natadPlacement
WHERE natadPlacement.networkID = 77
and natadPlacement.natadid = natads.natadid
and natforumend > "2020-05-29"
and natforumstart < "2020-05-30"
and natforumstatus = 'live'

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

and (natforumweight = 'medium' or natforumweight = 'high')
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 21:35:23.023
SELECT resourceid, natforum as adcode, natforumweight, natadid
FROM natads 
WHERE natadid = 41 
votecount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:35:23.023
SELECT vote
FROM votes
WHERE voteid = 356177
and liketype = 6 
votebadcount (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navvote_rdesign5.cfm @ 21:35:23.023
SELECT vote
FROM votes
WHERE voteid = 356177
and vote = 'bad'
and liketype = 6 
getclasscheck (Datasource=tipripper, Time=24ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 21:35:23.023
	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-30" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getpropertyslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
SELECT *
FROM topics
WHERE topicid = 6
getclass (Datasource=tipripper, Time=23ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
	SELECT DISTINCT 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-30" < allreports.enddate
	AND answersphoto.photo <> 'none'
	ORDER BY answerid DESC
getprice (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 109
getbed (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 113
getbath (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80508'
	AND answerstext.qid = 114
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '77'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navpropertybox_interim_main_new_rdesign5.cfm @ 21:35:23.023
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80508'
AND answersmc.qoid = qoptions.qoid


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=3411116
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
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=28726000
cftoken=75864002
sessionid=IBEXPATEXCHANGE.COM_28726000_75864002
urltoken=CFID=28726000&CFTOKEN=75864002
URL Parameters:
frmid=254
tpcid=3411116
Debug Rendering Time: 10 ms