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

Houses for Sale and Rent in Italy

Real Estate Listings Property Advice Local Experts My Properties

Find Houses for Sale in Italy, Houses for Rent in Italy, Home Exchange Italy, Roomates, Office Space, Retail Space, B&Bs for Sale in Italy, Hotels for Sale

Florence, Italy
Sort Listings By: Newest | City

Add a Property Listing

House for Sale

Rome, Italy

3 Bedroom / 3 Full Bath / Half Bath

Furnished

Price: €300,000

Living Space: 140 sq meters

View Full Listing

House for Sale in Rome, Italy

Independent villa in a small private estate in a residential neighbourhood outside Rome.

Apartment/Flat for Short-Term Rent

Rome, Italy

2 Bedroom / 1 Full Bath / Half Bath

Furnished

Price: 950€

Living Space: 40

View Full Listing

Apartment for Short-Term Rent in Rome, Italy

This cozy flat located on the second floor of a private building in Monti, 5 mins from the Colosseum, features a big canopy bed, a single bed in a separate room, bathroom with bath/shower, kitchenette and private terrace.

Apartment/Flat for Short-Term Rent

Rome, Italy

1 Bedroom / 1 Full Bath / Half Bath

Furnished

Price: 1000€

Living Space: 65 sq meters

View Full Listing

Apartment for Short-Term Rent in Rome, Italy

Big and cozy flat located on the second floor of a private building in the Monti district, 5 mins from the Colosseum. Features living room with big couch and TV, kitchen, bedroom and bathroom with shower. Free WIFI, AC, heating

Apartment/Flat for Rent

Rome, Italy

2 Bedroom / 2 Full Bath / Half Bath

Furnished

Price: 1100€/month

Living Space: 95 sq meters

View Full Listing

Apartment for Rent in Rome, Italy

Located on the first floor of a private building in Monti district, this wide apartment features furnished kitchen, living room, 2 bedrooms, 2 bathrooms. Free wifi, heating, AC 5 mins from Roman forum

Apartment/Flat for Rent

Roma , Italy

1 Bedroom / 1 Full Bath / 0 Half Bath

Furnished

Price: € 700,00

Living Space: 30 sq

View Full Listing

Apartment for Rent in Roma, Italy

200 steps from Piazza di Spagna - Small but cozy, kitchenette, bed and living, large bathroom, balcony Furnished with style suitable for short term rental.

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Expat-Italy10 Tips for Living in Italy

Italy is a dream destination for many, but some expats have difficulty adjusting to the rustic Italian lifestyle. Expats share their top tips for living in Italy.

Italy is a dream destination for many, but some expats have difficulty adjusting to the rustic Italian lifestyle. Expats share their top tips for living in Italy. ...

Retiring-Abroad5 Great Places to Retire in Western Europe

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These are some of the recommendations!

We asked expats about great places to retire in Western Europe. While many Western European countries have prohibitively high living costs, there are a few areas that fit the retirement bill. These ...

Retiring-in-ItalyRetiring in Italy: The 7 Best Places to Retire in Italy

Italy's villages and cities appeal to retirees for many different reasons - the beautiful beaches, breathtaking countryside, amazing food, wonderful nightlife, bustling town markets and welcoming people. In this article, we cover several of our readers' favorite places.

Italy's villages and cities appeal to retirees for many different reasons - the beautiful beaches, breathtaking countryside, amazing food, wonderful nightlife, bustling town markets and welcoming peop...

Retirement-In-MinturnoAn Expat Shares What it's Like Retiring in Minturno, Italy

An expat who retired in Minturno, Italy talks about health insurance, cost of living in Italy, residence permits and much more.

An expat who retired in Minturno, Italy talks about health insurance, cost of living in Italy, residence permits and much more....

Moving-To-Passignano-sul-TrasimenoAn Expat Talks about Moving to Passignano sul Trasimeno, Italy

Imagine traveling in Italy, seeing a poster for an concert on a lake, attending the concert and finding a beautiful town, like Passignano sul Trasimeno. Dreams do come true!

Imagine traveling in Italy, seeing a poster for an concert on a lake, attending the concert and finding a beautiful town, like Passignano sul Trasimeno. Dreams do come true! ...

Italy 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 03-Jul-20 07:22 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.217
Host Name 173.245.54.217


Execution Time

Total Time Avg Time Count Template
435 ms 435 ms 1 /home/www/html/eetr/tips.cfm
292 ms 292 ms 1 /home/www/html/eetr/Application.cfm
233 ms 47 ms 5 /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm
93 ms 93 ms 1 /home/www/html/navtop_rdesign5.cfm
86 ms 86 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
42 ms 4 ms 10 /home/www/html/eetr/rewritetipheadingstate.cfm
24 ms 24 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
24 ms 24 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
23 ms 23 ms 1 /home/www/html/navcontentbox.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 1 ms 1 /home/www/html/eetr/constants.cfm
1 ms 0 ms 5 /home/www/html/eetr/rewritealtimage.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippaginglinkmaker.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnew.cfm
1 ms 1 ms 1 /home/www/html/eetr/tippagingnewduplicate.cfm
1 ms 0 ms 3 /home/www/html/rewritearticle.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 5 /home/www/html/eetr/rewritetipheading.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 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
727 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 @ 19:22:46.046
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 19:22:46.046
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=0ms, Records=12, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
	Select *
	From citynetworks
	Where networkID = 58
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=0ms, Records=1, Cached Query) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 58 
getpropertycountries (Datasource=tipripper, Time=45ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
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=34ms, Records=12) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
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 @ 19:22:46.046
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
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=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 58 
GetClassifieds (Datasource=tipripper, Time=1ms, Records=5) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
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-07-03" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')
AND Networks.networkid = 58 
AND allreports.networkid = 58 
order by allreports.enddate DESC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
SELECT *
FROM topics

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

WHERE topicid = 6 
getcountryphoto (Datasource=expert, Time=1ms, Records=60) in /home/www/html/eetr/eetr_navmeta.cfm @ 19:22:46.046
SELECT *
FROM countryphotos
WHERE networkid = 58 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:22:46.046
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-04-03"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 19:22:46.046
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-07-03 00:00:00.000"
and logtime < "2020-07-03 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 @ 19:22:46.046
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.217'
and logtime > "2020-06-26"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 19:22:46.046
	SELECT *
	From contentcountcountry
	Where networkid = 58 
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 19:22:46.046
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight > 8
    and toDate > "2020-07-02"
    and fromDate < "2020-07-03"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 19:22:46.046
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=2ms, Records=99) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 58 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=2ms, Records=20) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE topicid = 6
AND "2020-07-03" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getcountryphoto (Datasource=expert, Time=1ms, Records=60) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 58 
getname (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 19:22:46.046
	Select *
	From Networks
	Where networkid = 58 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT *
FROM users
WHERE userid = '227798'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtag3 (Datasource=expert, Time=0ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = ''
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT summary 
	FROM answers
	WHERE answerid = 80770 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80770 
getphoto (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80770 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80770'
	and allreports.answerid = '80770'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80770'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80770'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80770'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80770'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80770'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80770'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80770'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT *
FROM users
WHERE userid = '226563'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4154'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT summary 
	FROM answers
	WHERE answerid = 80607 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80607 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80607 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80607'
	and allreports.answerid = '80607'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80607'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80607'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80607'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80607'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80607'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80607'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80607'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT *
FROM users
WHERE userid = '226563'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4154'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT summary 
	FROM answers
	WHERE answerid = 80608 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80608 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80608 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80608'
	and allreports.answerid = '80608'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80608'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80608'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80608'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80608'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80608'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80608'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80608'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT *
FROM users
WHERE userid = '226563'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4154'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT summary 
	FROM answers
	WHERE answerid = 80604 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80604 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80604 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80604'
	and allreports.answerid = '80604'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80604'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80604'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80604'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80604'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80604'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80604'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80604'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT *
FROM users
WHERE userid = '226543'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '58'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '9030'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT summary 
	FROM answers
	WHERE answerid = 80603 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80603 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80603 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80603'
	and allreports.answerid = '80603'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80603'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80603'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80603'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80603'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80603'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80603'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 19:22:46.046
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80603'
AND answersmc.qoid = qoptions.qoid
checkrptarticles (Datasource=reports, Time=4ms, Records=0) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-03"
     
         and rptarticlenetworks.networkid = 58 
    ORDER by rptarticles.rptarticleID asc   
    
gettaxgeneral2 (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 58 
	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-03"

    ORDER by articles.articleID asc   
    
checkretirefeature (Datasource=expert, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 96
      
         and networkid = 58 
         and city <> ''
         and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
		Select summary, hiimg 
		FROM answers
         where answerid = 74252
         and summary <> ''
checkmovingfeature (Datasource=expert, Time=5ms, Records=4) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 63
         and city <> ''
         
         and networkid = 58 
          and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 19:22:46.046
		Select summary, hiimg 
		FROM answers
         where answerid = 75586
         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/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=58&s=1&sort=r&slug=Real-Estate-&slug2=Houses-for-Sale-in-Italy
REMOTE_ADDR=173.245.54.217
REMOTE_HOST=173.245.54.217
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=30976389
cftoken=80298312
hitcount=1
lastvisit={ts '2020-07-03 19:22:46'}
timecreated={ts '2020-07-03 19:22:46'}
urltoken=CFID=30976389&CFTOKEN=80298312
Cookie Variables:
CFID=30976389
CFTOKEN=80298312
Session Variables:
cfid=30976389
cftoken=80298312
sessionid=IBEXPATEXCHANGE_30976389_80298312
urltoken=CFID=30976389&CFTOKEN=80298312
URL Parameters:
networkid=58
s=1
slug=Real-Estate-
slug2=Houses-for-Sale-in-Italy
sort=r
tipcategoryid=2831
topicid=6
Debug Rendering Time: 13 ms