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

Property in Ireland

By Christina McDonald

Summary: From a lack of national property listings to arranging financing, buying property in Ireland presents some challenges. Author Christina McDonald provides tips and insight into the process of buying a home in Ireland.

Property in Ireland - Tips for Buying a Home

Once you are finally feeling comfortable (and confident) enough to buy a property in Ireland, the secret to success is research, research, research. Buying in Ireland can be complex and time-consuming, so don't set yourself ridiculous deadlines, and keep an open mind. It is important to note that, unlike the United States, there are no national property listings in Ireland. This can be exceedingly frustrating and means the entire process often takes a lot longer than is necessary. Rather than choosing one agent who goes out and searches for houses that suit you, you have to endlessly register with different estate agents, who will only show you what is listed with their company. But if you are willing to invest the time and patience, you will eventually see light at the end of the tunnel and own your own little piece of Ireland.

Once you've decided on your ideal location, use the same ideas mentioned under Renting in order to find a house to purchase. Keep your eyes peeled for For Sale signs, read the classified sections (particularly in the region you are looking to purchase), and browse websites to find recently listed properties. Most importantly, sign up with the local estate agent offices and find out what homes they have listed for sale.

Next, think about your budget. This may be entirely dependent on your personal situation, but a house is a giant financial commitment, so don't get yourself in over your head. Find something that is within your budget and suits your tastes. A four-bedroom house in Dublin is going to cost you an awful lot more than an ancient cottage in Doolin.

Purchasing Steps

You should make sure to hire a good solicitor to guide you through the necessary legal paperwork. Unlike in the United States, where all of real-estate-related legal matters are wrapped up with the agent, in Ireland a solicitor (lawyer) is hired to do all of this. Solicitors charge 1–1.5 percent of the total house price.

Once you have settled on your ideal property and have your solicitor to do paperwork, you should arrange financing. Unless you have cash to pay out- right, this will be the trickiest part of the process-- banks can be difficult to extract money from-- but not impossible if you have a stable job, a good in- come, and a good credit record.

Once you have financing, you can put an offer on the property by paying a booking deposit. This deposit ranges from €3,000 to 3 percent of the sale price but is refundable up until contracts are signed. Your offer should be con- tingent on a property survey, which will detail any problems with the prop- erty, such as mold, a leaking roof, or a crumbling infrastructure. A property survey can cost upward of €400 depending on the size of the property, but this is one area you do not want to skimp on. If you are purchasing an older property, paying the extra money for a more detailed survey may save you bucket loads in future repairs.

I should mention that even after you have put a deposit down, another buyer can swoop in and make a higher offer, rendering your offer null and void. Unfortunately, this is quite common. I had a friend who had this happen to her four times when looking for a house in Galway. Each time she thought the house was her dream house and was absolutely crushed when another buyer offered more.

If everything goes according to plan, the estate agent will issue your solicitor contracts. This is where your solicitor earns the money you're paying. The solicitor checks to make sure there are no tricks in the legalese before approving it and letting you sign. You will also need to finalize your mortgage, submit a direct debit order (for funds to automatically be debited from your account), purchase building insurance, and buy life insurance. (Life insurance is dicussed more in Hidden Fees.) At this stage you pay about 10 percent of the purchase price as a deposit, although this amount is usually negotiable. Once your contracts are signed and exchanged, you will sign a few more papers, pay the final amount, and the property will be yours.

Hidden Fees

You already know about your legal fees, the surveyor fee, and your deposit, but there are a few more hidden costs associated with purchasing property that you should be aware of. You should make sure to include these costs in your budget.

You will have to pay stamp duty (tax) to the government. This is 1 percent of the total value of your home up to €1 million, and 2 percent on any value above €1 million. Your lender will charge an application fee for applying for a mortgage. You will be required to get building insurance, which is similar to homeowners insurance, and if you are purchasing with a mortgage (rather than paying with cash), you are required to buy life insurance. Finally, don't forget that VAT adds 21 percent to all professional services, such as the solicitor or the surveyor. These fees add up quickly, so be aware of them prior to making an offer on any property.

From the book Moon Living Abroad in Ireland by Christina McDonald. Excerpted by arrangement with Avalon Travel, a member of the Perseus Books Group. Copyright © 2012. For more information, visit http://www.moon.com.

About the Author

AS Christina McDonaldChristina McDonald is the author of Moon Living Abroad in Ireland. Her first memory of Ireland is seeing a photo of the Dingle Peninsula when she was a child. Having grown up in Seattle, she was sure there was no place greener than Washington State, but that picture proved her wrong. Twenty-five years later, she went to Dingle and was seduced by the intense emerald green of the countryside, the colorful terraced houses, the sparkling blue of the sea, and the friendly, charismatic people. A year after returning home to America, she decided to make the move to Ireland to pursue a master's degree in journalism at the National University of Ireland, Galway. While she was there, she met her future husband, Richard, in a tae kwon do class.

After receiving her degree, Christina married Richard and stayed in Ireland for a few years before moving to London, where she currently lives. Since then, she has enjoyed writing for print, radio, and online media in Ireland, England, and the United States, including Dublin's Sunday Times, Galway's Connacht Tribune, the Galway Independent, the Seattle Post Intelligencer, Colures Magazine, Expedia.com, and USAToday.com.

When not busy writing, Christina likes to spend time with friends and family, read, work out at the gym, and travel with her husband and their young son, Adam.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Join our Ireland Expat Forum

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

More about Ireland

10-Tips-for-Living-in-Ireland

10 Tips for Living in Ireland

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make the effort and take their time are rewarded with life-long Irish friends and a love of Ireland.

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make ...

How-an-Expat-Retiree-Fought-to-Stay-in-Ireland

How an Expat Retiree Fought to Stay in Ireland

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love.

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love....

5-Tips-for-Tech-Jobs-in-Dublin

5 Tips for Tech Jobs in Dublin

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms of all sizes.

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms...

10-Best-Places-to-Live-in-Ireland

10 Best Places to Live in Ireland

Expats in Ireland have a lot of options when they consider where they would like to live on the Emerald Isle. From great cities like Dublin and Galway, to more rustic areas such as Killarney, this is a good start for expats looking to explore where they will be happiest in Ireland.

Expats in Ireland have a lot of options when they consider where they would like to live on the Emerald Isle. From great cities like Dublin and Galway, to more rustic areas such as Killarney, this is...

5-Neighborhoods-to-Consider-in-Dublin,-Ireland

5 Neighborhoods to Consider in Dublin, Ireland

Expats in Dublin have several neighborhoods to consider. There are several factors to consider, such as proximity to work, schools and transportation access.

Expats in Dublin have several neighborhoods to consider. There are several factors to consider, such as proximity to work, schools and transportation access....

Digital-Nomads-in-Dublin

Living Abroad: Digital Nomads in Dublin

The number of people interested in becoming a digital nomad continues to grow, and those that are interested in a thriving metropolis as a destination would be wise not to scratch Dublin - and other cities in Ireland - off your list.

The number of people interested in becoming a digital nomad continues to grow, and those that are interested in a thriving metropolis as a destination would be wise not to scratch Dublin - and other c...

Moving-to-Dublin

Moving to Dublin

Expats are moving to Dublin in increasing numbers. Over the course of the last few decades, Ireland has emerged as a formidable economic force, and Dublin has benefited greatly. Here are some basics for those expats considering moving to Dublin.

Expats are moving to Dublin in increasing numbers. Over the course of the last few decades, Ireland has emerged as a formidable economic force, and Dublin has benefited greatly. Here are some basics...

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

guest
May 7, 2012 13:01

One word about buying property in dear old Ireland. DON'T!!!!!!

guest
May 7, 2012 15:22

Couple of things, solicitor fees can be negotiated to far less than 1.5% of the value of the property. Also, don't worry too much about having someone come in and make a higher offer than your offer on a property-the market is very slow, dormant in some areas, and it's a trick that some real estate agents use to jack up the price. One more thing, don't expect the level of professionalism from estate agents here as you would get in the U.S.

guest
May 7, 2012 19:28

most properties on sale on Ireland will be placed on this website w w w daft dot ie. you can search by area and budget and type of property

guest
May 7, 2012 20:09

Having owned and still in ownership of properties in Ireland may I say it is true negotiation is always possible. However being gazumped in Galway is more than real, as it is one of the few major well sort after property areas with a finite number of properties. Having also bought in the States the estate agents there have equally unpleasant methods to steer clients to their gain. Best way to buy is retrieve as much advice as you can from other purchasers, they have been through the mill and will set you in the path of those officials to be relied on. Always expect the unexpected and utmost at the top of the list, have patience.

guest
May 8, 2012 03:23

Hi Christina, I just wanted to say "hello" to a fellow Seattleite! I too, am from Seattle, and moved here to do an MA in Business Tourism. I met my husband shortly after I graduated and we still live in Ireland. We bought a house here about 7 years ago, and while it was a seemingly smooth transaction, we had heard about "gazumping" as you mentioned above. I can't believe it is legal! Anyway, we didn't pay stamp duty as we were first time buyers. There were a few other things different to the States as you mentioned, but all in all a relatively easy process. Thank you for sharing, Susan

guest
Jul 27, 2012 11:16

Foreign citizens have alwyas been able to buy property in the US. But it does not give them a residency status. If you have a passport, you can get a visitor's Visa usually good for 3 month. If you are an EU citizen you do not need a visa, and you can visit for 3 month at the time. You can also apply for a Student Visa if you are accepted at one of our schools. But watch out for scams!

guest
Jul 27, 2012 12:51

Wow, thanks for all the febedack! Glad to see others are in the same boat as me (misery loves company!), but I also really appreciate the : Yeah it's totally frustrating, and I would agree that it's a British jobs for British workers thing except that SO MANY corporate positions in London, at least, are filled by non-British Europeans. Since the UK job market is now open to other EU members, it seems like the strategy is to at least keep out those they can i.e., : Oh man, I would've thought being a UK citizen would help! Good luck to your fiance he's definitely not : That's such a shame that you're having to leave because of the job market, but I totally understand. If I was in your position with a solid offer back home, it would make it really hard to justify sticking it out in the : Thanks for the encouraging words! Yep, it doesn't help to be defeatist. Some employer somewhere in London is thinking to him or herself right now, I really wish I could find a young American to hire. Glad to hear from someone who was : I know, I keep seeing all these reports on the news about how UK grads are struggling to find jobs and how it's only going to get worse. X-( I'm trying to ignore them @M: I can be an asshole, it's true, but I'm not that much of an asshole to single you out for targeting in a blog post. The whole blame it on the economy thing was and still is a MASSIVE thing, written about over and over in the NY Times, Newsweek, etc. You were most certainly not the only person pegging his/her situation on the economy. I guess I've seen a few jobs for US attys seems quite a few UK firms/offices are expanding their US practices but almost no one wants untrained American JDs. I actually applied to that listing you sent John, but with no success. Even a few months at a big firm (but not, apparently, as a summer) makes a difference to these guys. We can talk about my feelings on that in person I also like the purple thingy. @Kelly: Don't tempt : Thanks for the encouragement! Yep, I'm not giving up, and I do hope the visa will make some difference, although understandably, a lot of jobs are not stoked about hiring someone who they'll still have to sponsor after two years. And of course, the visa still doesn't clear up the UK/US qualification problem for lawyers. But I know someone will give me a shot I just have to find : I quite agree. Most people don't find happiness in their jobs, they find it in life outside the job. So you're right it's life outside the job that should take priority. And I'm lucky that I've got some leeway in order to set those : First of all, you are misrepresnting things to say that you spent a decade job hunting. Second, given that you found a top-notch employer willing to sponsor you straight out of undergrad and another straight out of law school (and in fact had multiple offers for your summer position), it seems you did alright getting American employers to consider you. (Given that you had all American qualifications, it makes sense that you should have been a more attractive candidate in the US than I am in the UK.) But, I do agree that the US government s policy on work visas is no more friendly than the UK's and is probably even worse. Clerly the Special Relationship doesn't extend to highly skilled workers!

First Published: May 03, 2012

Cigna Expat Health InsuranceExpatriate Health Insurance

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

12-Expats-Talk-about-Living-in-Ireland12 Expats Talk about Living in Ireland

Expats in Ireland talk about meeting people, expat life, cultural blunders and more. Some expats find it hard to make real friends and become part of community life.
Expats in Ireland talk about meeting people, expat life, cultural blunders and more. Some expats find it hard to make real friends and become part of community life....

Expat-Ireland10 Tips for Living in Ireland

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make the effort and take their time are rewarded with life-long Irish friends and a love of Ireland.

Expats living in Ireland say that the transition from tourist to expat is not as easy as one would think -- from challenges making friends with the Irish to the rainy, gloomy weather. Expats who make ...

Retiring-in-IrelandHow an Expat Retiree Fought to Stay in Ireland

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love.

Expat retirees David and Maura Woods were given 7 days notice to leave Ireland. David shares his story, why they were asked to leave, and how they found a way to stay in the adoptive land they love....

Tech-Expats-in-Dublin5 Tips for Tech Jobs in Dublin

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms of all sizes.

Expats in the tech industry in Dublin live in one of the most vibrant tech economies in the world. Ireland's favorable tax policies and other factors have made "Silicon Docks" a magnet for tech firms...

Retirement-In-GalwayAn Expat Shares What it's Like Retiring in Galway, Ireland

A retiree in Galway, Ireland talks about living in Ireland. Although the cost of living is high, crime is practically non existent (unless you count a stolen cow), doctors make house calls and there is a lot to do in Galway.

A retiree in Galway, Ireland talks about living in Ireland. Although the cost of living is high, crime is practically non existent (unless you count a stolen cow), doctors make house calls and there ...

Moving-To-TobercurryAn Expat Talks about Moving to Tobercurry, Ireland

A retired couple, who first gave retirement in Florida a try, found that Ireland has a much lower cost of living and enjoyable lifestyle. They miss their family and friends, but appreciate that modern technology helps them see their grandkids regularly. They talk about the research they did, how they chose Tobercurry and what living in Ireland is like.

A retired couple, who first gave retirement in Florida a try, found that Ireland has a much lower cost of living and enjoyable lifestyle. They miss their family and friends, but appreciate that moder...

Ireland 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 02-Jul-20 02:54 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 172.69.63.127
Host Name 172.69.63.127


Execution Time

Total Time Avg Time Count Template
135 ms 135 ms 1 top level /home/www/html/lib_rd.cfm
71 ms 71 ms 1 /home/www/html/commentsnew_rdesign4.cfm
31 ms 31 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
29 ms 29 ms 1 /home/www/html/navcontentbox.cfm
29 ms 29 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/lib_rd_ctrygd_readnext.cfm
9 ms 9 ms 1 /home/www/html/navtop_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navbottomad_rdesign5.cfm
6 ms 6 ms 1 /home/www/html/breadcrumb.cfm
3 ms 3 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 1 ms 2 /home/www/html/navinjection.cfm
2 ms 2 ms 1 /home/www/html/navleader_rdesign5.cfm
2 ms 2 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/bottommobilenav_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/constants.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 10 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
139 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 @ 14:54:07.007
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=2ms, Records=1) in /home/www/html/Application.cfm @ 14:54:07.007
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 14:54:07.007
	Select *
	From articles
	Where articleID = 4077
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd.cfm @ 14:54:07.007
	Select *
	From sponcers
	Where sponcerID = 426 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 14:54:07.007
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 4077 
	and articles.articleID = 4077 
	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 @ 14:54:07.007
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 4077
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 4077
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:54:07.007
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 14:54:07.007
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 56 
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/navmeta_rdesign4.cfm @ 14:54:07.007
	Select *
	From citynetworks
	Where networkID = 56
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 14:54:07.007
  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 @ 14:54:07.007
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 4077 
  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 @ 14:54:07.007
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-04-02"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 14:54:07.007
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-07-02 00:00:00.000"
and logtime < "2020-07-02 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:54:07.007
SELECT *
FROM tracking
WHERE ipaddress = '172.69.63.127'
and logtime > "2020-06-25"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 14:54:07.007
	SELECT *
	From contentcountcountry
	Where networkid = 56 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 14:54:07.007
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 14:54:07.007
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
UpdatePageViews (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 14:54:07.007
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/breadcrumb.cfm @ 14:54:07.007
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4077 
checkcitynetwork (Datasource=expert, Time=1ms, Records=0) in /home/www/html/breadcrumb.cfm @ 14:54:07.007
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 4077 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getpropertyintro (Datasource=expert, Time=5ms, Records=0) in /home/www/html/breadcrumb.cfm @ 14:54:07.007
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 56 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '3'
    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-07-02"

    ORDER by articles.articleID asc   
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 14:54:07.007
SELECT tag
FROM natadoptions 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 14:54:07.007
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4077 
gettaxgeneral3 (Datasource=expert, Time=6ms, Records=4) in /home/www/html/lib_rd_ctrygd_readnext.cfm @ 14:54:07.007
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 56 
	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 <> 4077
    and publishdate < "2020-07-02"
    and publishdate > "2014-01-01"

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

    ORDER by articles.articleID asc   
    
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navbottomad_rdesign5.cfm @ 14:54:07.007
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-01"
    and fromDate < "2020-07-02"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 14:54:07.007
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 862 
gethpbox (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 14:54:07.007
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-07-01 14:54:07'}
    and fromDate <{ts '2020-07-02 14:54:07'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 14:54:07.007
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=7) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 4077 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=1ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 14:54:07.007
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 14:54:07.007
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 4077 
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-02"
     
         and rptarticlenetworks.networkid = 56 
    ORDER by rptarticles.rptarticleID asc   
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 14:54:07.007
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 29
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 14:54:07.007
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 56 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
SELECT  hiimg
FROM rptarticles
where rptarticleID = 29
and hiimg <> ''
gettaxgeneral2 (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 56 
	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-02"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=3) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 56 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
		Select summary, hiimg 
		FROM answers
         where answerid = 74562
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 56 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 14:54:07.007
		Select summary, hiimg 
		FROM answers
         where answerid = 75585
         and summary <> ''


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=4077&networkid=56
REMOTE_ADDR=172.69.63.127
REMOTE_HOST=172.69.63.127
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=30739886
cftoken=58785310
sessionid=IBEXPATEXCHANGE.COM_30739886_58785310
urltoken=CFID=30739886&CFTOKEN=58785310
URL Parameters:
articleID=4077
networkid=56
Debug Rendering Time: 10 ms