Home Antigua & Barbuda Forum Antigua & Barbuda Guide Antigua & Barbuda Resources Real Estate Healthcare in Antigua & Barbuda
Antigua & Barbuda
Resources
JoinSign In
Cigna International Health Insurance

Houses for Sale and Rent in Antigua & Barbuda

Our Antigua & Barbuda real estate section will include real estate listings from expats and real estate brokers. Plus, we're adding expert advice from real estate professionals about renting and buying homes in cities and towns in Antigua & Barbuda. For information about becoming an Expat Exchange Real Estate Expert, click here. As an expert, your listings, profile and advice about renting and buying real estate will appear in this new section.

Sort Listings By: Newest | City
Add a Property Listing
Cigna Expat Health InsuranceExpatriate Health Insurance

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

Living-in-St-JohnsAn Expat Discusses Living in St Johns, Antigua & Barbuda

An expat in St. Johns, Antigua recommends that newcomers get to know the locals, learn Cricket, attend live music events and go to the beach. If you're looking for employment opportunities, teachers and medical professionals are in high demand.

An expat in St. Johns, Antigua recommends that newcomers get to know the locals, learn Cricket, attend live music events and go to the beach. If you're looking for employment opportunities, teachers ...

Antigua & Barbuda 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 /eetr/tips.cfm
Time Stamp 06-Jun-20 08:46 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
309 ms 309 ms 1 /home/www/html/eetr/Application.cfm
123 ms 123 ms 1 top level /home/www/html/eetr/tips.cfm
94 ms 94 ms 1 /home/www/html/navtop_rdesign5.cfm
83 ms 83 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
22 ms 22 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
21 ms 21 ms 1 /home/www/html/navcontentbox.cfm
21 ms 21 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.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/eetr/datasources.cfm
0 ms 0 ms 3 /home/www/html/eetr/navconstants.cfm
0 ms 0 ms 1 /home/www/html/eetr/navinjection.cfm
0 ms 0 ms 1 /home/www/html/eetr/qry_GeneralSet.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
0 ms 0 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 1 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
432 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/qry_GeneralSet.cfm @ 20:46:26.026
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=307ms, Records=1) in /home/www/html/eetr/Application.cfm @ 20:46:26.026
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=0ms, Records=153, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
	Select *
	From citynetworks
	Where networkID = 365
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 365 
getpropertycountries (Datasource=tipripper, Time=43ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT allreports.networkname, allreports.networkid, shortname, allreports.date
FROM allreports, Networks, sitecategories
WHERE rid = 100
and Networks.networkid = allreports.networkid
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3
and allreports.hide <> 'y'

and allreports.tipcategoryid <> 2791

and allreports.tipcategoryid <> 2797
and allreports.networkid <> 159
group by allreports.networkid
order by allreports.networkname ASC
gettipcategories (Datasource=tipripper, Time=33ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT * 
FROM sitecategories, qoptions, allreports
WHERE qoptions.qoid = sitecategories.tipcategoryid
and qoptions.parent = 0
and allreports.hide <> 'y'
and sitecategories.siteid = 3
and sitecategories.tipcategoryid <> 2791
and sitecategories.tipcategoryid <> 2797
and sitecategories.tipcategoryid <> ''
and sitecategories.tipcategoryid <> 2793
and sitecategories.tipcategoryid <> 2792
and allreports.tipcategoryid = sitecategories.tipcategoryid
group by sitecategories.tipcategoryid 
getcategoryinfo (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT topics.slug, topics.slugcity, topics.slugstate,topics.slugcitynostate, topics.slugcountry, topics.slugentry, topics.topicqid, topics.topicqidanswer, topics.promolinktext, topics.promophoto600, topics.tipstemplate
FROM topics

WHERE topicid = 6 
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 365 
GetClassifieds (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate, allreports.networkname as country
FROM allreports, answers, Networks
WHERE allreports.topicid = 6
and hide <> 'y'
and answers.answerid = allreports.answerid
and "2020-06-06" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')
AND Networks.networkid = 365 
AND allreports.networkid = 365 
order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT *
FROM topics

WHERE topicid = 6
gettopic (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT *
FROM topics

WHERE topicid = 6 
getcountryphoto (Datasource=expert, Time=1ms, Records=0) in /home/www/html/eetr/eetr_navmeta.cfm @ 20:46:26.026
SELECT *
FROM countryphotos
WHERE networkid = 365 
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:46:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-03-07"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 20:46:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-06-06 00:00:00.000"
and logtime < "2020-06-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 @ 20:46:26.026
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.173'
and logtime > "2020-05-30"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 20:46:26.026
	SELECT *
	From contentcountcountry
	Where networkid = 365 
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 20:46:26.026
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 20:46:26.026
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-06-05"
    and fromDate < "2020-06-06"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 20:46:26.026
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
getcount (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 20:46:26.026
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 365 
order by city ASC, answerid DESC
checkifreports (Datasource=tipripper, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 20:46:26.026
SELECT Networks.networkname, allreports.networkid, shortname, allreports.answerid, allreports.userid, allreports.tiptitle, allreports.tipcategory, allreports.tipcategoryid, allreports.comments, allreports.date, allreports.allowcomments, allreports.citynetworkid, allreports.citynetworkid2, allreports.statenetworkid, allreports.city, sitecategories.categoryslug, sitecategories.headingnav, allreports.topicid, allreports.state, allreports.networkname, allreports.enddate
FROM allreports, sitecategories, Networks
WHERE allreports.rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and hide <> 'y'
and sitecategories.siteid = 3
and allreports.tipcategoryid <> 2797
and (allreports.topicid = 9 or allreports.topicid = 10 or allreports.topicid = 11)
AND Networks.networkid = 365 
AND allreports.networkid = 365 
 and allreports.tipcategoryid <> 2791 
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 20:46:26.026
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE topicid = 6
AND "2020-06-06" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getcountryphoto (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 20:46:26.026
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 365 
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 20:46:26.026
	Select *
	From Networks
	Where networkid = 365 
checkculturefeature (Datasource=expert, Time=5ms, Records=0) in /home/www/html/navcontentbox.cfm @ 20:46:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 365 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
checklivingfeature (Datasource=expert, Time=5ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:46:26.026
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 365 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 20:46:26.026
		Select summary, hiimg 
		FROM answers
         where answerid = 48226
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 20:46:26.026
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 365 
	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-06-06"

    ORDER by articles.articleID asc   
    
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 20:46:26.026
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-06-06"
     
         and rptarticlenetworks.networkid = 365 
    ORDER by rptarticles.rptarticleID asc   
    


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/eetr/tips.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/eetr/tips.cfm
QUERY_STRING=topicid=6&tipcategoryid=2831&networkid=365&s=1&sort=r&slug=Real-Estate-&slug2=Houses-for-Sale-in-Antigua-barbuda
REMOTE_ADDR=173.245.54.173
REMOTE_HOST=173.245.54.173
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/eetr/tips.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Client Variables:
cfid=29122441
cftoken=33475558
hitcount=1
lastvisit={ts '2020-06-06 20:46:26'}
timecreated={ts '2020-06-06 20:46:26'}
urltoken=CFID=29122441&CFTOKEN=33475558
Cookie Variables:
CFID=29122441
CFTOKEN=33475558
Session Variables:
cfid=29122441
cftoken=33475558
sessionid=IBEXPATEXCHANGE_29122441_33475558
urltoken=CFID=29122441&CFTOKEN=33475558
URL Parameters:
networkid=365
s=1
slug=Real-Estate-
slug2=Houses-for-Sale-in-Antigua-barbuda
sort=r
tipcategoryid=2831
topicid=6
Debug Rendering Time: 9 ms