Home Bahamas Forum Bahamas Guide Moving to Bahamas Real Estate Healthcare in Bahamas
Bahamas
Resources
City Guides
JoinSign In
AGS Worldwide Movers

Expat Guide to Living in New Providence

Whether you're already living in New Providence or preparing to move to New Providence, our Expat Guide to Living in Bahamas offers articles and reports submitted by expats about expat life in New Providence. For answers to specific questions, visit our Bahamas Forum to talk with expats in New Providence.

Living in New Providence, Bahamas

An expat on New Providence, an island that is home to the capital city of Nassau, offers advice on moving to the Bahamas and what it's like to live there. Finances, life as an expat, locals and more are covered in this report.

Retirement in New Providence, Bahamas

An expat retiree on New Providence, Bahamas, which is the home of the capital Nassau, offers valuable advice on how to retire there. Information on housing, health care, transportation, night life and more is provided.

Culture Shock Report

Culture shock is part of the settling in process. Knowing the different phases of culture shock and how other expats in New Providence handle it can be very comforting. Help others preparing to move to New Providence by filling out our Culture Shock Report.

Submit a Culture Shock Report

More Living in New Providence Reports

What are people's priorities in New Providence - work? family? socializing? What are the best ways to meet other expats? Are people accepting of racial, cultural and religious differences? Below are some of the responses from expats in New Providence:
Submit a Living Overseas Report

Moving Overseas Report

What should you take with you when you move to New Providence? What should you leave behind? What type of housing and neighborhoods are typical for expats in New Providence? Help others moving to New Providence by filling out our Moving Overseas Report.

Submit a Moving Overseas Report

International School Report

Parents are invited to answer questions about the schools that their kids attend (Pre-K through High School) in hopes of helping others moving to New Providence with the school selection process. If you have expat children who attend school in New Providence, take a few minutes to submit a School Review.

Submit an International School Review

Dream vs. Reality Report

Most expats have have "dreams" (and fears) about the expatriate experience before they moved to New Providence. If you are already living in New Providence, share how those "dreams" have been fulfilled, and how they have not by filling out our Dream vs. Reality Report.

Submit a Dream vs. Reality Report

Retiring in New Providence Reports

Retiring abroad can be a great option for retirees seeking their dream lifestyle at an affordable price. Help other retirees, who are thinking about retiring in New Providence, by filling out our Overseas Retirement report. Below are some of the reports from expats in New Providence:
Submit a Retire Abroad Report

Having a Baby Abroad Report

How did expats choose their doctors, midwives, hospitals? What is childbirth like in New Providence? Help other expats who are preparing to have a baby in New Providence by filling out our Having a Baby Abroad Report.

Submit a Having a Baby Abroad Report

Working Abroad Report

What's it like to find a job in New Providence? How difficult was it to obtain a work permit? What types are jobs are typical for expats in New Providence? Help others following in your footsteps by filling out our Working Abroad Report.

Submit a Working Abroad Report
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-NassauAn Expat Talks about Culture Shock & Living in Nassau, Bahamas

One expat in the Bahamas advised those considering a move there to visit the island several times before making a commitment to live there, make sure the paperwork is in order and know what they getting into prior to coming. She went on to explain that the island is quite segregated and prices are extremely high.

One expat in the Bahamas advised those considering a move there to visit the island several times before making a commitment to live there, make sure the paperwork is in order and know what they getti...

Living-in-New-ProvidenceAn Expat Discusses Living in New Providence, Bahamas

An expat on New Providence, an island that is home to the capital city of Nassau, offers advice on moving to the Bahamas and what it's like to live there. Finances, life as an expat, locals and more are covered in this report.

An expat on New Providence, an island that is home to the capital city of Nassau, offers advice on moving to the Bahamas and what it's like to live there. Finances, life as an expat, locals and more ...

10-Tips-for-Living-in-The-Bahamas10 Tips for Living in The Bahamas

From duties on household goods to bringing your dog, expats in the Bahamas offer advice for expats and people moving to the Bahamas.

From duties on household goods to bringing your dog, expats in the Bahamas offer advice for expats and people moving to the Bahamas....

5-Tips-for-Living-in-Nassau-in-the-Bahamas5 Tips for Living in Nassau in the Bahamas

Expats who choose to live in the Bahamas can explore a Caribbean paradise. Find out what it means to call Nassau, on the island of New Providence, your home.

Expats who choose to live in the Bahamas can explore a Caribbean paradise. Find out what it means to call Nassau, on the island of New Providence, your home....

5-Tips-for-Living-in-Freeport-in-the-Bahamas5 Tips for Living in Freeport in the Bahamas

Expats in the Bahamas live in the Caribbean but are very close to the U.S. Find out what it means to call Freeport, on the island of Grand Bahamas, your home. Some of it is island paradise, while other parts of the experience are clearly not.

Expats in the Bahamas live in the Caribbean but are very close to the U.S. Find out what it means to call Freeport, on the island of Grand Bahamas, your home. Some of it is island paradise, while ot...

15-Expats-Talk-about-What-Its-Like-Living-in-the-Bahamas15 Expats Talk about What It's Like Living in the Bahamas

Expats in the Bahamas describe what it's like living on an island nation. Cultural adjustment, life in the Bahamas, where to live, meeting people and more is described by people with experience living there.
Expats in the Bahamas describe what it's like living on an island nation. Cultural adjustment, life in the Bahamas, where to live, meeting people and more is described by people with experience livin...

Bahamas 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 /expatguide.cfm
Time Stamp 06-Jul-20 04:48 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.217
Host Name 173.245.54.217


Execution Time

Total Time Avg Time Count Template
172 ms 172 ms 1 top level /home/www/html/expatguide.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
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 1 ms 1 /home/www/html/leftnav_rdesign5.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/boolsearch.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 3 /home/www/html/rewritearticle.cfm
0 ms 0 ms 6 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 6 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 6 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
176 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 @ 04:48:48.048
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 04:48:48.048
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 18 
getcities (Datasource=expert, Time=0ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select *
	From citynetworks
	Where networkID = 18
	and status <> 'hold'
	ORDER by city
getcity (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select *
	From citynetworks
	Where citynetworkid = 7207 
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
  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) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select *
	From Networks
	Where networkID = 18 
getphoto (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 04:48:48.048
	Select *
	From countryphotos
	Where networkID = 18
	and citynetworkid = 7207 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 04:48:48.048
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-04-06"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 04:48:48.048
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-07-06 00:00:00.000"
and logtime < "2020-07-06 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 @ 04:48:48.048
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-06-29"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 04:48:48.048
	SELECT *
	From contentcountcountry
	Where networkid = 18 
gettopbanner (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 04:48:48.048
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-07-05"
    and fromDate < "2020-07-06"
    and bannerPlacement.networkid = 18
    and bannerPlacement.bannerid = banners.bannerid
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 04:48:48.048
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
citystatus (Datasource=expert, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
	Select *
	From citynetworks 
	Where citynetworkid = 7207 
gettaxgeneral (Datasource=expert, Time=3ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement, articlecityplace 
 	Where hitopic <> ''
 	and articlePlacement.networkID = 18 
 	and articlecityplace.citynetworkid = 7207
    AND articlecityplace.articleID = articles.articleID
	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 summary <> ''
    and publishdate < "2020-07-06"
    ORDER by articles.articleID desc
gettaxgeneral (Datasource=expert, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, hpimg, summary, authorurl
	FROM articles, articlePlacement 
 	Where hitopic <> ''
	and (((title LIKE '%New%') OR (author LIKE '%New%') OR (hitopic LIKE '%New%') OR (hidescript LIKE '%New%')) AND ((title LIKE '%Providence%') OR (author LIKE '%Providence%') OR (hitopic LIKE '%Providence%') OR (hidescript LIKE '%Providence%')))
	and articlePlacement.networkID = 18 
	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 summary <> ''
    and author <> 'Expat Exchange Member'
   and author <> 'ExpatExchange Member'
      and author <> 'ExpatExchange.com Member'
    and publishdate < "2020-07-06"
    ORDER by articles.articleID desc
getqoid (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT qoid, value 
FROM qoptions 

WHERE value = 'Bahamas' 

and qid = 46
checkretirefeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         order by date DESC
checkretire (Datasource=expert, Time=6ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         
   	 order by date DESC
   	
checkparenting (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 98
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         
   	 order by date DESC
   	
checkdreamfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         order by date DESC
checkdream (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 97
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         
   	 order by date DESC
   	
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         order by date DESC
checkculture (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 18 
         and citynetworkid = 7207 
         and city <> ''
         
   	 order by date DESC
   	
checkmovingfeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
		order by date DESC
checkmoving (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
   	 order by date DESC
   	
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 18 
         and citynetworkid = 7207 
		order by date DESC
checkliving (Datasource=expert, Time=5ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
   	 order by date DESC
   	
checkbaby (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 88
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
   	 order by date DESC
   	
checkwork (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 65
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
   	 order by date DESC
   	
checkschool (Datasource=expert, Time=5ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 62
         and city <> ''
         
         and networkid = 18 
         and citynetworkid = 7207 
   	 order by date DESC
   	
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73657 
getrealestateadvice (Datasource=tipripper, Time=5ms, Records=3) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrealestateadvice (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  7207
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getrestaurants (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  7207
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=13ms, Records=2) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
gethealthcare (Datasource=tipripper, Time=9ms, Records=0) in /home/www/html/expatguide.cfm @ 04:48:48.048
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  7207
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select summary, hiimg, hpimg
		FROM answers
      where answerid = 73657 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/expatguide.cfm @ 04:48:48.048
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 73644 
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/expatguide.cfm @ 04:48:48.048
	Select *
	From Networks
	Where networkID = 18 
checkculturefeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 18 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
		Select summary, hiimg 
		FROM answers
         where answerid = 65310
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 18 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
		Select summary, hiimg 
		FROM answers
         where answerid = 73657
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 18 
	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-06"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-06"
     
         and rptarticlenetworks.networkid = 18 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 04:48:48.048
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 14
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 04:48:48.048
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 18 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 04:48:48.048
SELECT  hiimg
FROM rptarticles
where rptarticleID = 14
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/expatguide.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/expatguide.cfm
QUERY_STRING=networkid=18&citynetworkid=7207
REMOTE_ADDR=173.245.54.217
REMOTE_HOST=173.245.54.217
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/expatguide.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=31138492
cftoken=28809869
sessionid=IBEXPATEXCHANGE.COM_31138492_28809869
urltoken=CFID=31138492&CFTOKEN=28809869
URL Parameters:
citynetworkid=7207
networkid=18
Debug Rendering Time: 10 ms