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

Mexico's Next Big Thing: Riviera Nayarit

By Kathleen Peddicord

Summary: Kathleen interviews Aaron Fisher of Developer Direct about one of Mexico's hottest up-and-coming real estate markets and tourist destinations, Riviera Nayarit. This 100 mile stretch of Pacific coastline north of Puerta Vallarta offers beautiful beaches, great weather, lost cost of living and good investment opportunities.

Mexico  - Riviera Nayarit

"The market in Mexico's Riviera Nayarit is stronger than ever right now," writes Aaron Fisher of Developer Direct. "We continue to see record-breaking sales for development, investment, and second homes.

"Mexico is the seventh most visited tourist destination in the world," Aaron continues. "And it is estimated that, by 2013, Mexico will be the world's second-fastest-growing tourist market.

"Still, it's an emerging destination. It's been only in the past decade that banks have come in to offer loans to foreigner buyers. Historically, Mexico has been stringent with its lending policies and has never catered to a sub-prime borrower. The result is a low public sector deficit with increased lending to foreigners looking to purchase in this country.

"Because Mexico was, until recently, a cash-and-carry market, this new lending stimulus has launched an influx of foreign investment from a new demographic in the U.S. and Canada.

"Of course, I'm a developer. You may find it hard to accept my position as unbiased. Nevertheless, the truth is, there has never been a better time to live and invest in Mexico than right now.

"All the rules of buying in a developing market and in this part of the world apply. Be sure you're buying titled property and invest in title insurance (we work with First American Title, the biggest title company in the world).

"Government in this country has never been more reform-minded, and we have seen the passing of the torch from Vicente Fox to fellow Harvard classmate Felipe Calderon. That's two U.S.-educated presidents in a row.

"Not to mention that Mexico has stepped up to agreements signed with NAFTA and is making big headway toward meeting international standards for infrastructure and government policy.

"We have five new state-of-the-art hospitals offering cutting-edge medical and emergency response care at a fraction the price you pay in the U.S. Prescription medicines are cheaper, too, and you can get a well-rounded health insurance program for as little as US$300 per year.

"After 10 years living on the Riviera Nayarit, however, I'd say that the biggest reason for thinking about joining me down here is the lifestyle. For me, this means easy access, good weather, a low cost of living, and opportunity.

"The Riviera Nayarit is easy to get to with more direct flights to major U.S and Canadian cities than almost any other part of Mexico.

"The climate isn't extreme. We enjoy an average winter temperature of 25 to 26 degrees Celsius (that's 77 to 79 degrees Fahrenheit) and more than 330 days of uninterrupted sunshine. Plus, water temperatures rarely fall below 78 degrees Fahrenheit.

"Regarding the low cost of living, let's face it: Mexico is cheap. Maybe not cheap the way it was a decade or more ago, but still your money goes a long way. Services cost far less than in the States, for example, allowing you luxuries normally reserved in North America for the wealthy, like a housekeeper, a cook, and a gardener.

"As far as opportunity goes, Mexico is a developing nation with a strong appreciating market. The 'World Investment Prospects to 2011' report from the Economist and the Columbia Program on International Investment predicts that direct foreign investment from 2007 to 2011 in Mexico will average US$22.7 billion annually, the 5th greatest rate among developing countries and the 17th greatest in the world.

"Infrastructure is a key consideration when choosing a market for investment. A new highway has been built stretching from Puerto Vallarta up to phase one of the Riviera Nayarit, and our airport has tripled in size over the last two years.

"Another important consideration is the local market. Is there one? This can go a long way toward helping you ride out global ups and downs. In this part of Mexico, Mexicans themselves account for more than 50% of the tourist income; the other 50% is covered by North Americans and Europeans

"Furthermore, Mexico has one of the fastest-growing middle-income demographics in the world. The minimum wage in the Riviera Nayarit is the highest in Mexico, meaning our area is sought-after for employment. Laborers from all over the country migrate here, allowing developers and builders to select the most skilled workers from a big pool.

"I mentioned already the importance of verifying the title to any piece of real estate you consider purchasing in this country. In addition, you want to make sure that the developer has all the required permits in place to do what he represents he's going to do.

"You want to make sure the developer has the ability to build and that funds are being set aside in escrow during construction. You want to know that he has the available liquid cash flow to complete.

"And you want to make sure you are comparing apples to apples, both among different developers and developments you might consider in the country and between what you're looking at in Mexico and what you know from back home."

Related Links:

USA Today: Riviera Nayarit is Mexico's Next Great Place

Fodor's: Mexico's Next Destination: Riviera Nayarit

About the Author

Renowned expert Kathleen Peddicord's newest publication, The Overseas Retirement Letter, is a great tool for those trying to decide where to retire abroad - people seeking lower living costs and better lifestyles.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

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.

More about Mexico

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

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

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

10-Best-Places-to-Teach-Abroad

10 Best Places to Teach Abroad

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

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

9-Best-Places-to-Live-on-Mexicos-Pacific-Coast

9 Best Places to Live on Mexico's Pacific Coast

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

We've compiled a list of the 9 best places to live on the Pacific Coast of Mexico based upon expats' recommendations and security information from the US State Department. From Ensenada in Baja Norte...

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

9 Important Tips about Healthcare for Expats in Mexico

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

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

10-Tips-for-Living-in-Lake-Chapala,-Mexico

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

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

5-Tips-for-Living-in-Manzanillo,-Mexico

5 Tips for Living in Manzanillo, Mexico

Expats in Manzanillo enjoy wonderful winter weather and very hot summers as they engage in all kinds of outdoor activities... All right by the beautiful scenery of the Pacific Ocean.

Expats in Manzanillo enjoy wonderful winter weather and very hot summers as they engage in all kinds of outdoor activities... All right by the beautiful scenery of the Pacific Ocean....

Best-Places-to-Live-in-Riviera-Maya,-Mexico-

5 Best Places to Live in Riviera Maya, Mexico

Riviera Maya is a gorgeous stretch of Caribbean coastline in the Mexican state of Quintana Roo. We highlight expats' 5 favorite places to live in Riviera Maya.

Riviera Maya is a gorgeous stretch of Caribbean coastline in the Mexican state of Quintana Roo. We highlight expats' 5 favorite places to live in Riviera Maya....

5-Tips-for-Living-in-San-Miguel-de-Allende,-Mexico

5 Tips for Living in San Miguel de Allende, Mexico

Expats in San Miguel de Allende love the city's art scene, spring-like weather, beautiful architecture and thriving expat community. Expats share tips for living in San Miguel de Allende.

Expats in San Miguel de Allende love the city's art scene, spring-like weather, beautiful architecture and thriving expat community. Expats share tips for living in San Miguel de Allende. ...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

donter
Aug 15, 2013 12:39

Great points regarding the Real Estate, especially new developments. We have personal knowledge that the Nahui Nayarit development on the north shore of the Bahia de Banderas is embroiled with grievances from clients for non performance in construction and failing to honour termination clauses for the return of deposit money. There are numerous entries on FB ( Nahui Tau Nayarit ) and TripAdvisor under similar 'tags' and on the www for C&C Capital and Hector Cardenas Curiel. Be Aware - Be Informed

First Published: Jan 10, 2009

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-MeridaAn Expat Talks about Culture Shock & Living in Merida, Mexico

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

An expat in Merida, Mexico offers some insight into the challenges of settling in and living there. Some of the topics include driving, what it's like there if you don't speak Spanish, and much more....

Living-in-TijuanaAn Expat Discusses Living in Tijuana, Mexico

An expat in Tijuana, Mexico talks about what it's like living in a border city, locals focus on family, athletic activities and more.

An expat in Tijuana, Mexico talks about what it's like living in a border city, locals focus on family, athletic activities and more. ...

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 04-Jul-20 02:24 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.78.108
Host Name 162.158.78.108


Execution Time

Total Time Avg Time Count Template
69 ms 69 ms 1 top level /home/www/html/lib_rd.cfm
28 ms 28 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
27 ms 27 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
26 ms 26 ms 1 /home/www/html/navcontentbox.cfm
15 ms 15 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
10 ms 10 ms 1 /home/www/html/commentsnew_rdesign4.cfm
10 ms 10 ms 1 /home/www/html/navtop_rdesign5.cfm
5 ms 5 ms 1 /home/www/html/Application.cfm
5 ms 5 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navmpu_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/breadcrumb.cfm
1 ms 1 ms 1 /home/www/html/constants.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/leftnav_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 11 /home/www/html/rewritearticle.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
76 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 @ 02:24:52.052
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 02:24:52.052
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:24:52.052
	Select *
	From articles
	Where articleID = 3263
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:24:52.052
	Select *
	From sponcers
	Where sponcerID = 304 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 02:24:52.052
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 3263 
	and articles.articleID = 3263 
	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=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 02:24:52.052
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 3263
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 3263
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:24:52.052
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:24:52.052
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getcities (Datasource=expert, Time=1ms, Records=21) in /home/www/html/navmeta_rdesign4.cfm @ 02:24:52.052
	Select *
	From citynetworks
	Where networkID = 77
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 02:24:52.052
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 02:24:52.052
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 3263 
  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 @ 02:24:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-04-04"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:24:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-07-04 00:00:00.000"
and logtime < "2020-07-04 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 02:24:52.052
SELECT *
FROM tracking
WHERE ipaddress = '162.158.78.108'
and logtime > "2020-06-27"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 02:24:52.052
	SELECT *
	From contentcountcountry
	Where networkid = 77 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 02:24:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 02:24:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:24:52.052
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3263 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 02:24:52.052
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 3263 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 02:24:52.052
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:24:52.052
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3263 
gettaxgeneral3 (Datasource=expert, Time=7ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:24:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and articles.articleID <> 3263
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettaxgeneral4 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 02:24:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement, articlecityplace
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
		and articlecityplace.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 <> 3263
    and publishdate < "2020-07-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 02:24:52.052
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=1ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 02:24:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight = 10 
    and toDate > "2020-07-03"
    and fromDate < "2020-07-04"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 02:24:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 02:24:52.052
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-07-03 02:24:52'}
    and fromDate <{ts '2020-07-04 02:24:52'}
    and weight > 7
    and bannerPlacement.networkid = 77
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:24:52.052
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-07-03 02:24:52'}
    and fromDate <{ts '2020-07-04 02:24:52'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 02:24:52.052
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=0ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 02:24:52.052
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 3263 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 02:24:52.052
  SELECT *
  FROM users
  WHERE userid = 76338 
getarticlesection (Datasource=expert, Time=0ms, Records=0) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 02:24:52.052
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 3263 
checkculturefeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
		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=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
		Select summary, hiimg 
		FROM answers
         where answerid = 74757
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
		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 @ 02:24:52.052
		Select summary, hiimg 
		FROM answers
         where answerid = 75825
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 77 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-07-04"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-04"
     
         and rptarticlenetworks.networkid = 77 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:24:52.052
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 28
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 02:24:52.052
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 77 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 02:24:52.052
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=3263&networkid=77
REMOTE_ADDR=162.158.78.108
REMOTE_HOST=162.158.78.108
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=30996217
cftoken=94560743
sessionid=IBEXPATEXCHANGE.COM_30996217_94560743
urltoken=CFID=30996217&CFTOKEN=94560743
URL Parameters:
articleID=3263
networkid=77
Debug Rendering Time: 10 ms