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

Retire in Bahamas > Coral Harbour >

An Expat Talks about Retiring in Coral Harbour, Bahamas

Feb 04, 2019


An expat who retired in Coral Harbour, Bahamas talks about what it's like living there - from the thriving nightlife to the lack of big stores, financial requirements for permanent residence and healthcare.

What is the name of the city or town that you are reporting on?

Coral Harbour

Why did you choose to retire abroad?

I could not longer take the cold weather and wanted to retire in the sunshine.

Are you retired abroad all year or part of the year?

All year (although my wife and I travel alot)

Why did you choose the country you retired to?

Beach, sun, warm weather was our primary focus. However since we travel a lot we also wanted somewhere close to a major airport and low cost flights.

Did you ever live abroad before you retired abroad?

Yes, we lived in the Mediterranean for a few years before retiring here in the Bahamas.

How long have you lived abroad since you retired abroad?

We lived abroad for 5 years before moving to the Bahamas and retiring here 11 years ago.

Moving to Bahamas soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a Moving Quote

Moving to Bahamas soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

How many countries (other than your home country) have you lived in as a retiree?

1

What have been the most challenging aspects of being retired abroad?

The damages that can be caused by hurricanes. Make sure you put additional monies aside for unexpected damages that can and do occur when living in the Caribbean.

What have been the most rewarding aspects of being retired abroad?

We have made lots of new friends and get to spend our time in the sunshine. This is a big plus for someone like me who has a lot of aches and pains that are worse in the cold weather.

What would you do differently if you were just starting the retire abroad process?

The banking system can be difficult here for retirees. Make sure you properly look into what banking services will be available to you before you move here.

What is life like for a retiree in your city and its surroundings? (Is there an active expat community? Cultural Attractions? Recreation? Nightlife?)

Their is huge expat community here, people from all over the world and all types of characters retire here. This is a Caribbean island so don't expect to much amenities as you would find in the U.S.A. or Europe. We do not have a Walmart, Auchan or Harrods here although we did just get an IMAX theatre. We have lots of recreational activities related to the sea (having a boat is a huge advantage). We also have all types of nightlife as the tourist industry is fairly vibrant here as well.

What residency documents or visas did you need to obtain to retire in your host country? How difficult was this process? (Please describe)

The process is fairly simple if you come from North America or European countries. You need to be able to show that you can support yourself financially and that you will not be a burden on the local economy. Make sure to get private health care insurance.

Did you buy a home or apartment, or rent one? Is this a difficult process? (Please describe)

We rented at first to make sure we were happy here. We later bought a home and both options work well. For the residency documents you can use either a rental lease or a property deed but the minimum value has changed over the years.

Financially, has living abroad in your host country met your expectations? Exceeded them?

Yes, we expected it to cost us more and it has. No kidding, this is not a cheap island to retire too. Everything costs more here from groceries to real estate. Expect to spend more then you would in your home country.

What are the most important financial considerations for retiring to your host country?

Properly check your finances and make sure its realistic for you before coming. Healthcare is another must. It is necessary to have here and you should have one that does not have an age limit on it or you may find yourself having to leave once you pass 75 years old.

How much can a retiree live on comfortably in your host country?

Housing costs vary greatly but the last time I checked you needed to spend $500,000 USD as a minimum on the home in order to qualify for a permanence residence. This number may have risen in the last couple of years as they have talked about changing it to 750,000 or 1 million dollars. Besides that expect to spend at least $800 a month in groceries for a couple that eats well. Restaurants can run fairly expensive at about $50 for dinner for a couple up to thousands of dollars in the fancy places.

Do you have access to quality medical care? (Please describe - is it close? Expensive?)

We have both a general hospital and private hospitals as well as private clinics. The healthcare is adequate. For major health issues many people choose to fly to Florida as well. The cost is comparable but the choice of healthcare is perceived to be greater.

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

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

Is there a lot of crime where you live? (Please describe)

The east end of the island definitely has more crime then the west end. In recent times the crime has come out west as more of the wealthy people live out west. This is mostly non-violent crime unless you are involved with criminal elements such as the gangs or drug scene.

Describe available transportation where you live. Do you need a car? Is there access to safe public transportation?

The public busses are sketchy at best. We have our own car and that has served us well. Taxis are readily available for shuttling around if you prefer not to own a car here, however that could get rather expensive.

Is there high-speed internet access where you live?

Yes. The common providers are BTC (telephone company) and REV (cable company). Both work well for recreational internet use. If you need more upload capabilities then the average person then check the package offered by REV. This is the most upload bandwidth available on the island a the moment.

Do you have any other thoughts you would like to share about retiring abroad?

You have worked hard during your life time and now you deserve to enjoy your retirement. Consider what makes you the happiest. Is it the weather, sporting activities, clubs, social life? What ever it is make sure your destination will provide you with that, then work out the rest of the details.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

More about Coral Harbour

Guide to Living in Coral Harbour

Guide to Living in Coral Harbour

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.

Healthcare in Bahamas

Healthcare in Bahamas

Expats in The Bahamas share tips and advice about healthcare and health insurance in The Bahamas. Advice about emergency services on smaller islands, flying to Florida for care, ambulance services, prescription medicine and having a baby in the Bahamas.

Moving to Nassau

Work with a good realtor. Talk to people and look at websites. Look for "security" first and foremost. Gated community feels safest if you are alone.

Moving to Nassau

When you're moving to the Bahamas, pack everything in plastic boxes to keep the cockroaches away, consider finding a home in a gated community for better security and make sure you have a extra room for your many guests!

Expat Healthcare & Health Insurance

Expat Healthcare & Health Insurance in Nassau

An expat living in Nassau, Bahamas talks about the quality of healthcare in the Bahamas. He explained that the hospitals and clinics in the Bahamas provide care more quickly than in this home country of Canada. Also, many expats in need of specialized care take a quick trip to Florida.

Culture Shock in Nassau

An expat in the Bahamas says that learning to throw away schedules and live on island time in one of the most challenging aspects of living in the Bahamas. But, he also explains how the laid back lifestyle and less stressful work environment is one of the most rewarding aspects... you have more time to listen to and be present for your children.

Culture Shock in Nassau

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.

Join our Bahamas Expat Forum

Visit our Bahamas Forum and talk with other expats who can offer you insight and tips about living in Coral Harbour, Bahamas.

More about Bahamas

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.

13-Things-to-Know-Before-You-Move-to-The-BahamasMoving to The Bahamas: 13 Things to Know Before You Move to The Bahamas

Expats in The Bahamas share 13 key considerations for anyone planning to move to the Bahamas.

Pros-and-Cons-of-Living-in-The-BahamasExpats in The Bahamas: Pros and Cons of Living in The Bahamas

Expats in the Bahamas discuss the pros and cons of living in the Bahamas. Topics covered include meeting people, the friendly Bahamians, beautiful beaches, schools, go-with-the-flow attitude, cost of living and the lack of eldercare facilities. Expats in the Bahamas have specific advice about where to live if you have kids and want to meet people.

11-Healthcare--Health-Insurance-Tips-for-Expats-in-The-Bahamas11 Healthcare & Health Insurance Tips for Expats in The Bahamas

Expats in The Bahamas share tips and advice about healthcare and health insurance in The Bahamas. Advice about emergency services on smaller islands, flying to Florida for care, ambulance services, prescription medicine and having a baby in the Bahamas.

Cigna International Health Insurance

Write a Comment about this Expat Report

Sign In to post a comment.
addacomment
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Guide to Living in Coral HarbourGuide to Living in Coral Harbour

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.

Healthcare in BahamasHealthcare in Bahamas

Expats in The Bahamas share tips and advice about healthcare and health insurance in The Bahamas. Advice about emergency services on smaller islands, flying to Florida for care, ambulance services, prescription medicine and having a baby in the Bahamas.

Restaurants in NassauRestaurants in Nassau

Have you eaten at Blue Sail in Coral Harbour? Learn about this and other restaurants in Coral Harbour in our new Coral Harbour Restaurant Guide.

Moving to Nassau

Work with a good realtor. Talk to people and look at websites. Look for "security" first and foremost. Gated community feels safest if you are alone.

Moving to Nassau

When you're moving to the Bahamas, pack everything in plastic boxes to keep the cockroaches away, consider finding a home in a gated community for better security and make sure you have a extra room for your many guests!

Expat Healthcare & Health InsuranceExpat Healthcare & Health Insurance in Nassau

An expat living in Nassau, Bahamas talks about the quality of healthcare in the Bahamas. He explained that the hospitals and clinics in the Bahamas provide care more quickly than in this home country of Canada. Also, many expats in need of specialized care take a quick trip to Florida.

Culture Shock in Nassau

An expat in the Bahamas says that learning to throw away schedules and live on island time in one of the most challenging aspects of living in the Bahamas. But, he also explains how the laid back lifestyle and less stressful work environment is one of the most rewarding aspects... you have more time to listen to and be present for your children.

Culture Shock in Nassau

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.

Tips for Buying Propery in Nassau, BahamasTips for Buying Propery in Nassau, Bahamas

An expat in the Bahamas offers in-depth advice about the real estate market in the Bahamas. Covers he most popular areas for expats like Sandyport, Old Fort Bay and Lyford Caye. Also, housing costs, the steps in buying property, closing costs and more.

Tips for Renting Property in Nassau, BahamasTips for Renting Property in Nassau, Bahamas

An expat talks about renting a home on Paradise Island, Bahamas. Did you know that most rentals in the Bahamas are fully furnished? and many landlords won't allow any of the existing furniture to be removed.

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.

13-Things-to-Know-Before-You-Move-to-The-BahamasMoving to The Bahamas: 13 Things to Know Before You Move to The Bahamas

Expats in The Bahamas share 13 key considerations for anyone planning to move to the Bahamas.

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


Execution Time

Total Time Avg Time Count Template
247 ms 247 ms 1 top level /home/www/html/rspnet.cfm
127 ms 127 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
126 ms 126 ms 1 /home/www/html/navcontentboxcitypc.cfm
126 ms 126 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
71 ms 71 ms 1 /home/www/html/navcontentboxcityrptsmobile.cfm
9 ms 9 ms 1 /home/www/html/commentsnew_rdesign4.cfm
9 ms 9 ms 1 /home/www/html/navtop_ctygd2.cfm
8 ms 8 ms 1 /home/www/html/breadcrumb_ctygd.cfm
8 ms 8 ms 1 /home/www/html/rspnet_ctygd_readnext.cfm
6 ms 6 ms 1 /home/www/html/Application.cfm
4 ms 2 ms 2 /home/www/html/nativerotationtop_tester13.cfm
4 ms 4 ms 1 /home/www/html/navbottomad_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/navmeta_rdesign4.cfm
4 ms 4 ms 1 /home/www/html/navmpu_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/bottomnav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 5 /home/www/html/eetr/rewritetipheading.cfm
1 ms 1 ms 2 /home/www/html/navinjection.cfm
1 ms 0 ms 6 /home/www/html/rewritearticle.cfm
1 ms 1 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navlikeandmore_rdesign5.cfm
0 ms 0 ms 8 /home/www/html/rewritecityname.cfm
0 ms 0 ms 8 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 8 /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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
255 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 @ 22:22:40.040
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 22:22:40.040
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getreportresponses (Datasource=expert, Time=1ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:40.040
SELECT  networkname as ctry, city, networkid, rid, networkname, answerid, citynetworkid
FROM allreports
WHERE rid = 96
AND networkid = 18 
AND 75945 = answerid

GROUP BY answerid
ORDER by city
citystatus (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:40.040
	Select *
	From allreports, citynetworks 
	Where allreports.answerid = 75945
	and allreports.citynetworkid = citynetworks.citynetworkid
getquestions (Datasource=reports, Time=6ms, Records=21) in /home/www/html/rspnet.cfm @ 22:22:40.040
SELECT DISTINCT questions.qid, answers.answerid, questions.question, responsequestions.qid, answerstext.qid, answerstext.answer as answer, answerstext.reviewed, answerstext.score, answers.rid, answers.reviewed, responses.intro, responses.responsename, responsequestions.listorder, answers.userid, answers.date
FROM responsequestions, questions, answers, responses, answerstext
WHERE answerstext.qid = questions.qid

AND 75945 = answerstext.answerid
 
AND answerstext.score > 1
AND answerstext.answer <> ''

AND answers.answerid = 75945 
AND answers.reviewed = 'y'
AND questions.qid = responsequestions.qid
AND responses.responseid = responsequestions.responseid
AND answers.rid = responses.rid
ORDER BY responsequestions.listorder ASC
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:40.040
SELECT DISTINCT img, photocaption, summary, hpimg, fbimg, twimg
FROM answers 
WHERE answers.answerid = 75945 
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:40.040
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:40.040
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 18 
getcities (Datasource=expert, Time=1ms, Records=4) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:40.040
	Select *
	From citynetworks
	Where networkID = 18
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:40.040
  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
GetMessages (Datasource=forum, Time=0ms, Records=0) in /home/www/html/navmeta_rdesign4.cfm @ 22:22:40.040
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75945 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:22:40.040
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-03-05"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_ctygd2.cfm @ 22:22:40.040
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-06-04 00:00:00.000"
and logtime < "2020-06-04 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_ctygd2.cfm @ 22:22:40.040
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-05-28"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:22:40.040
	SELECT *
	From contentcountcountry
	Where networkid = 18 
citycontentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_ctygd2.cfm @ 22:22:40.040
	SELECT *
	From contentcountcity
	Where citynetworkid = 4317 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:40.040
SELECT *
FROM articleCategories
 
WHERE section = 11
checkcitynetwork (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:40.040
		Select *
		FROM allreports, citynetworks
         where answerid = 75945
         and citynetworks.citynetworkid = allreports.citynetworkid
         and citynetworks.status = 'live'
getretireintro (Datasource=expert, Time=7ms, Records=0) in /home/www/html/breadcrumb_ctygd.cfm @ 22:22:40.040
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 18 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
      and keycity = 0
    and cityintro = 'n'
    and sectionintro = 'y'
   and articleCategories.section = '11'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-04"

    ORDER by articles.articleID asc   
    
getphotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rspnet.cfm @ 22:22:40.040
SELECT DISTINCT img, photocaption, summary, hpimg, twimg
FROM answers 
WHERE answers.answerid = 75945 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
	Select *
	From Networks
	Where networkid = 18 
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 18
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-03"
and natsentencestart < "2020-06-04"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getreportnetworks (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
	Select *
	From Networks
	Where networkid = 18 
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 22:22:40.040
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 18
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-06-03"
and natsentencestart < "2020-06-04"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high')
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articleCategories, articlecityplace
	Where hitopic <> ''
	and hidescript <> ''
    and type = '3'
   and articlecityplace.citynetworkid = 4317
	and articlecityplace.articleid = articles.articleID
     and articleCategories.articleID = articles.articleID
    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.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-06-04" 
    ORDER by articles.articleID desc  
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	Select summary, hpimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4317
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=7ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 18 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
checkmovingfeature (Datasource=expert, Time=6ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         and networkid = 18 
         and allreports.answerid <> 75945 
          and citynetworkid = 4317
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 45314 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 38516 
gethealthcare (Datasource=tipripper, Time=16ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  4317
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=7ms, Records=5) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79586
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79586 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79586'
getheading (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79586'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
	SELECT DISTINCT hpimg as photo
	FROM answers
	WHERE answerid = 79586 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
         and networkid = 18 
         and allreports.answerid <> 75945         
          and citynetworkid = 4317
         and city <> ''
         order by date DESC
checkculturefeature (Datasource=expert, Time=5ms, Records=2) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75945         
         and networkid = 18
          and citynetworkid = 4317
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74032 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcityrptsmobile.cfm @ 22:22:40.040
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 65310 
gettaxgeneral (Datasource=expert, Time=7ms, Records=4) in /home/www/html/rspnet_ctygd_readnext.cfm @ 22:22:41.041
	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 keycity = '0'
   and cityintro = 'n'
    and summary <> ''
    and publishdate < "2020-06-04"
    and publishdate > "2014-01-01"

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:22:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eebannercountry"
    and toDate > "2020-06-03"
    and fromDate < "2020-06-04"
    and bannerPlacement.networkid = 18
    and bannerPlacement.bannerid = banners.bannerid
    and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 22:22:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 869 
gethpbox (Datasource=expert, Time=1ms, Records=0) in /home/www/html/navmpu_rdesign5.cfm @ 22:22:41.041
	Select *
	From banners, bannerPlacement
	WHERE status <> "hold"
	AND position = "eehpboxcountry"
    and toDate > {ts '2020-06-03 22:22:41'}
    and fromDate <{ts '2020-06-04 22:22:41'}
    and weight > 7
    and bannerPlacement.networkid = 18
    and bannerPlacement.bannerid = banners.bannerid
    and banners.type <> 'swf'
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:22:41.041
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eehpbox"
	and weight > 7
    and toDate > {ts '2020-06-03 22:22:41'}
    and fromDate <{ts '2020-06-04 22:22:41'}
     and banners.type <> 'swf'
       
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 22:22:41.041
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 22:22:41.041
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 75945 
  and m.commenttype = 2
  and m.isapproved = 1
  ORDER BY msgid ASC
getguidesummary (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	Select summary, hiimg 
	From articles, articlecityplace
	Where  articlecityplace.citynetworkid = 4317
	and articlecityplace.articleid = articles.articleID
    and articles.cityintro = 'y'
 
gethealthsummary (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	Select summary, hpimg
	From articles, articlePlacement, articleCategories
	Where articlePlacement.networkID = 18 
	AND articlePlacement.articleID = articles.articleID
   	and articleCategories.articleID = articles.articleID
   	and articleCategories.section = 9
   	and articles.sectionintro = 'y'
    ORDER by articles.articleID desc
gethealthcare (Datasource=tipripper, Time=15ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  4317
and allreports.topicid = 15
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 15 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'
checkmovingfeature (Datasource=expert, Time=8ms, Records=2) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
        
         and allreports.answerid <> 75945         
         and networkid = 18
          and citynetworkid = 4317
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 45314 
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 38516 
gethealthcare (Datasource=tipripper, Time=17ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  4317
and allreports.topicid = 7
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 7 
getanswerstext (Datasource=tipripper, Time=6ms, Records=5) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79586
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79586 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79586'
getheading (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79586'
	and qid = 391
getphoto (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79586 
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'
checkretirefeature (Datasource=expert, Time=6ms, Records=0) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
            
         and allreports.answerid <> 75945         
         and networkid = 18
          and citynetworkid = 4317
         and city <> ''
         order by date DESC
checkculturefeature (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
            
         and allreports.answerid <> 75945         
         and networkid = 18
          and citynetworkid = 4317
         and city <> ''
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 74032 
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
		Select summary, hiimg, hpimg
		FROM answers
         	where answerid = 65310 
gethealthcare (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  4317
and allreports.topicid = 10
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 10 
getanswerstext (Datasource=tipripper, Time=7ms, Records=9) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 79950
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 79950 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT summary
	FROM answers
	WHERE answers.answerid = '79950'
getheading (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '79950'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 79950 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'
gethealthcare (Datasource=tipripper, Time=12ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT *
FROM allreports, Networks 
WHERE rid = 100
and Networks.networkid = 18
and allreports.networkid = 18
 and allreports.citynetworkid2 =  4317
and allreports.topicid = 9
and hide <> 'y'
order by allreports.answerid DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.articletitle
FROM topics
WHERE topicid = 9 
getanswerstext (Datasource=tipripper, Time=7ms, Records=19) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT DISTINCT answerstext.aid, questions.question, topicquestions.required, questions.qid, questions.type, answers.answerid, answers.reviewed, answers.rid, answers.dbid, answerstext.answer, answerstext.qid, answerstext.answerid, answers.img, answers.hiimg, answers.hpimg, answers.fbimg, answers.photocaption, answers.photocredit, answers.summary, topicquestions.outputtext, answerstext.uniqueheader, answerstext.uniqueheaderprop, answerstext.answerstextphoto, answerstext.photoplacement
FROM answerstext, answers, topicquestions, questions 
WHERE answers.answerid = 80106
AND (100 = answers.rid or 99 = answers.rid)
and topicquestions.qid <> 391
and topicquestions.qid <> 62
AND topicquestions.topicid = answers.topicid
and answerstext.answer <> ''
AND topicquestions.qid = questions.qid
AND topicquestions.qid = answerstext.qid
AND 80106 = answerstext.answerid 
ORDER BY topicquestions.order ASC
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT summary
	FROM answers
	WHERE answers.answerid = '80106'
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80106'
	and qid = 391
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
	SELECT DISTINCT hiimg as photo
	FROM answers
	WHERE answerid = 80106 
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/navcontentboxcitypc.cfm @ 22:22:41.041
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '18'


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/rspnet.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/rspnet.cfm
QUERY_STRING=rid=96&answerid=75945&networkid=18
REMOTE_ADDR=173.245.54.173
REMOTE_HOST=173.245.54.173
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/rspnet.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=29018866
cftoken=74775594
sessionid=IBEXPATEXCHANGE.COM_29018866_74775594
urltoken=CFID=29018866&CFTOKEN=74775594
URL Parameters:
answerid=75945
networkid=18
rid=96
Debug Rendering Time: 13 ms