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

Houses for Sale and Rent in Philippines

Real Estate Listings Property Advice Local Experts My Properties

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

Sort Listings By: Newest | City

Add a Property Listing

Apartment/Flat for Rent

Bonifacio Global City Taguig, Philippines

1 Bedroom / 1 Full Bath / Half Bath

Furnished

Price: PHP 100000

Living Space: 37 Sq meters

View Full Listing

Apartment for Rent in Bonifacio Global City Taguig, Philippines

Self isolate in a secure low density condo adjacent to supermarket, convenience store, chemist, ATM. Walking distance to St Lukes BGC, BGC High Street and offices.

House for Sale

ILOILO, Philippines

4 Bedroom / 2 Full Bath / 1 Half Bath

Unfurnished

Price: $128,000 or P35,000 per month

Living Space: 210 sm Interior living Space

View Full Listing

House for Sale in ILOILO, Philippines

Close to main entrance and nestled in a low traffic area in Glades 'A" - this home enjoys tranquil views from every window and a private patio for relaxing. A 60 acre gated guarded - and safe - subdivision with pools, church, International school, reliable water and Internet. Near several very major malls and renowned hospitals. This home is For Sale by Owner Owner will finance at 1% below Bank Rate WATCH THE VIDEO TOUR https://vimeo.com/356334835

House for Sale

Metro Manila, Philippines

2 Bedroom / 2 Full Bath / 0 Half Bath

Furnished

Price: Peso

Living Space: 70.30 Sq. meter

View Full Listing

House for Sale in Metro Manila, Philippines

OFFERS : ?? Executive Studio, 1 Bedroom , 2 Bedrooms ?? 0% Downpayment ?? 0% Interest in 5 years ?? Flexible and friendly payment terms ?? Get big discounts Call or Message now.

House for Sale

Puerto Princesa, Philippines

5 Bedroom / 5 Full Bath / Half Bath

Furnished

Price: $835,000

Living Space: 400 sq meters

View Full Listing

House for Sale in Puerto Princesa, Philippines

Amazing 5 acre property with a 4 story Mediterranean style house, utility building with deck and 2 guest cottages in the tropical paradise of Palawan, Philippines. House has view decks with 360* views of the Sulu Sea and western mountains. The 2 cottages are available now for monthly rental. 2 Bdrm- P7000mo 1 Bdrm- P5000mo Email for details

Apartment/Flat for Sale

Taguig, Philippines

1 Bedroom / 1 Full Bath / 0 Half Bath

Furnished

Price: PHP 13,990,000 (or USD 279,800)

Living Space: 56 sqm

View Full Listing

Apartment for Sale in Taguig, Philippines

Brand New 1-Bedroom Condo Unit for Sale at Two Serendra in Bonifacio Global City

Cigna Expat Health InsuranceExpatriate Health Insurance

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

Culture-Shock-in-Batangas-CityAn Expat Talks about Culture Shock & Living in Batangas City, Philippines

A retired US Naval Officer and his Filipina wife moved to Batangas City. He shares how he has adapted to live in the Philippines, what he appreciates most about the Filipino culture and more.

A retired US Naval Officer and his Filipina wife moved to Batangas City. He shares how he has adapted to live in the Philippines, what he appreciates most about the Filipino culture and more. ...

Living-in-TaguigAn Expat Discusses Living in Taguig, Philippines

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifacio Global City.

An British expat talks about spending winters in Taguig, Philippines with his Filipina wife of 25 years. He does miss chatting with other English speakers and hopes to find some expat clubs in Bonifa...

Pros-and-Cons-of-Living-in-the-PhilippinesPros and Cons of Living in the Philippines

The Philippines attracts the interest of expats from all over the world - truly has a lot to offer for a variety of different people. However, it's also important to understand the pitfalls that can be avoided with appropriate homework and preparation.

The Philippines attracts the interest of expats from all over the world - truly has a lot to offer for a variety of different people. However, it's also important to understand the pitfalls that can ...

7-Things-to-Know-Before-You-Move-to-the-PhilippinesMoving to the Philippines: 7 Things to Know Before You Move to the Philippines

Expats moving to the Philippines join others that have moved there for work or a lower cost of living during retirement. It's critical to understand what the realities of living there are, but those that successfully make the adjustment believe it is a good place to live.

Expats moving to the Philippines join others that have moved there for work or a lower cost of living during retirement. It's critical to understand what the realities of living there are, but those ...

5-Tips-for-Expats-Living-in-the-Philippines5 Tips for Expats Living in the Philippines

Expats may share some gripes about living in the Philippines, but most agree that one thing makes up for all of the challenges. Can you guess what it is?
Expats may share some gripes about living in the Philippines, but most agree that one thing makes up for all of the challenges. Can you guess what it is?...

Philippines 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 11-Jul-20 01:29 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 162.158.79.9
Host Name 162.158.79.9


Execution Time

Total Time Avg Time Count Template
463 ms 463 ms 1 /home/www/html/eetr/tips.cfm
292 ms 292 ms 1 /home/www/html/eetr/Application.cfm
244 ms 49 ms 5 /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm
98 ms 98 ms 1 /home/www/html/navtop_rdesign5.cfm
89 ms 89 ms 1 /home/www/html/eetr/eetr_navmeta.cfm
40 ms 4 ms 10 /home/www/html/eetr/rewritetipheadingstate.cfm
34 ms 34 ms 1 /home/www/html/navcontentbox.cfm
34 ms 34 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
34 ms 34 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
3 ms 3 ms 1 /home/www/html/navleader_rdesign5.cfm
1 ms 0 ms 3 /home/www/html/eetr/navconstants.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/rewritearticlefirsttitle.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/constants.cfm
0 ms 0 ms 1 /home/www/html/eetr/datasources.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/rewritealtimage.cfm
0 ms 0 ms 5 /home/www/html/eetr/rewritetipheading.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/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritearticle.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 1 /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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
756 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 @ 13:29:58.058
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=tipripper, Time=289ms, Records=1) in /home/www/html/eetr/Application.cfm @ 13:29:58.058
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
GetNetworks (Datasource=tipripper, Time=2ms, Records=153) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getcities (Datasource=expert, Time=1ms, Records=6) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
	Select *
	From citynetworks
	Where networkID = 90
	and status <> 'hold'
	ORDER by city
getname (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getpropertycountries (Datasource=tipripper, Time=44ms, Records=125) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
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 @ 13:29:58.058
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 @ 13:29:58.058
SELECT * 
FROM sitecategories
WHERE sitecategories.tipcategoryid = 2831 
getslugs (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
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 @ 13:29:58.058
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
GetClassifieds (Datasource=tipripper, Time=2ms, Records=5) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
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-11" < allreports.enddate
and (answers.paid = 'yes' or answers.paid = 'free')
AND Networks.networkid = 90 
AND allreports.networkid = 90 
order by allreports.city ASC
getslugs (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
SELECT *
FROM topics

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

WHERE topicid = 6 
getcountryphoto (Datasource=expert, Time=2ms, Records=23) in /home/www/html/eetr/eetr_navmeta.cfm @ 13:29:58.058
SELECT *
FROM countryphotos
WHERE networkid = 90 
checklog (Datasource=stats, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:29:58.058
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-04-11"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:29:58.058
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-11 00:00:00.000"
and logtime < "2020-07-11 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=1ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 13:29:58.058
SELECT *
FROM tracking
WHERE ipaddress = '162.158.79.9'
and logtime > "2020-07-04"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 13:29:58.058
	SELECT *
	From contentcountcountry
	Where networkid = 90 
gettopbanner (Datasource=expert, Time=0ms, Records=0, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 13:29:58.058
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-07-10"
    and fromDate < "2020-07-11"
gettopbanner (Datasource=expert, Time=0ms, Records=2, Cached Query) in /home/www/html/navleader_rdesign5.cfm @ 13:29:58.058
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-07-10"
    and fromDate < "2020-07-11"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 13:29:58.058
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getcount (Datasource=tipripper, Time=3ms, Records=261) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT answerid
FROM allreports, sitecategories
WHERE rid = 100
and allreports.tipcategoryid = sitecategories.tipcategoryid
and sitecategories.siteid = 3 
and networkid = 90 
order by city ASC, answerid DESC
getpropertycountries (Datasource=tipripper, Time=3ms, Records=21) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT allreports.networkname, allreports.networkid, shortname, shortnamecap
FROM allreports, Networks
WHERE topicid = 6
AND "2020-07-11" < allreports.enddate
and Networks.networkid = allreports.networkid
group by allreports.networkid
order by allreports.networkname ASC
getcountryphoto (Datasource=expert, Time=1ms, Records=23) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	Select *
	From countryphotos
	Where hpimg <> ''
	and networkid = 90 
getname (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tippaginglinkmaker.cfm @ 13:29:58.058
	Select *
	From Networks
	Where networkid = 90 
getauthor (Datasource=forum, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT *
FROM users
WHERE userid = '224503'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '9043'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT summary 
	FROM answers
	WHERE answerid = 80703 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80703 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80703 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80703'
	and allreports.answerid = '80703'
getprice (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=6ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80703'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80703'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80703'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80703'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80703'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80703'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80703'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT *
FROM users
WHERE userid = '224161'
getlocationtag1 (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8747'
getbrief (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT summary 
	FROM answers
	WHERE answerid = 80470 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80470 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80470 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	and qid = 391
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80470'
	and allreports.answerid = '80470'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80470'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80470'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=9ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80470'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80470'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT *
FROM users
WHERE userid = '227512'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '4205'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT summary 
	FROM answers
	WHERE answerid = 80752 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80752 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80752 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	and qid = 391
	
getheading (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80752'
	and allreports.answerid = '80752'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80752'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80752'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80752'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=0) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80752'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80752'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80752'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80752'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT *
FROM users
WHERE userid = '93827'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtagdefault (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtag3 (Datasource=expert, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '8137'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT summary 
	FROM answers
	WHERE answerid = 80534 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80534 
getphoto (Datasource=tipripper, Time=3ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:29:58.058
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80534 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80534'
	and allreports.answerid = '80534'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:58.058
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=5ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80534'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80534'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80534'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80534'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80534'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80534'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80534'
AND answersmc.qoid = qoptions.qoid
getauthor (Datasource=forum, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
SELECT *
FROM users
WHERE userid = '221595'
getlocationtag1 (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtagdefault (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
SELECT shortname, networkname, networkid
FROM Networks
WHERE networkid = '90'
getlocationtag3 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
SELECT shortname, city as networkname, citynetworkid as networkid
FROM citynetworks
WHERE citynetworkid = '5243'
getbrief (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
	SELECT summary 
	FROM answers
	WHERE answerid = 80343 
getphoto (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
	SELECT DISTINCT hpimg as photo, tiplibraried, fbimg
	FROM answers
	WHERE answerid = 80343 
getphoto (Datasource=tipripper, Time=4ms, Records=0) in /home/www/html/eetr/tips.cfm @ 13:29:59.059
	SELECT DISTINCT answersphoto.photo, answersphoto.answerid, answersphoto.qid 
	FROM answersphoto 
	WHERE answersphoto.answerid = 80343 
	AND answersphoto.qid = '118'
	
	AND answersphoto.photo <> 'none'
	
getheading (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	and qid = 391
	
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/rewritetipheadingstate.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	and qid = 391
	
getstatus (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answers.highlight, answers.feature, allreports.hide, answers.paid, answers.reviewed
	FROM answers, allreports
	WHERE answers.answerid = '80343'
	and allreports.answerid = '80343'
getprice (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 128
getbed (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 124
getbath (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 125
gethalfbath (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 126
getlivingspace (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 127
getanswers (Datasource=tipripper, Time=7ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT answerstext.answer as city, qoptions.value as ctry, answerstext.rid, answersmc.qoid
FROM answerstext, qoptions, answersmc
WHERE answerstext.answerid = '80343'
AND answerstext.qid = 62
AND answersmc.qid = 46
AND answersmc.answerid = '80343'
AND answersmc.qoid = qoptions.qoid
getlocation (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid as id, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 131
getheading (Datasource=tipripper, Time=3ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 391
getbrief (Datasource=tipripper, Time=4ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answerstext.answer as summary, answerstext.answerid, answerstext.qid
	FROM answerstext
	WHERE answerstext.answerid = '80343'
	AND answerstext.qid = 392
photocheck (Datasource=tipripper, Time=8ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
	SELECT DISTINCT answersphoto.photo, answersphoto.pid, answersphoto.description, answersphoto.tourorder, answersphoto.answerid, answersphoto.qid as pid
	FROM answersphoto
	WHERE answersphoto.answerid = '80343'
	AND answersphoto.qid = '104'
	AND answersphoto.photo <> 'none'
getrentorsale (Datasource=tipripper, Time=1ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 133
AND answersmc.answerid = '80343'
AND answersmc.qoid = qoptions.qoid
getpropertytype (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 130
AND answersmc.answerid = '80343'
AND answersmc.qoid = qoptions.qoid
getfurnished (Datasource=tipripper, Time=0ms, Records=1) in /home/www/html/eetr/tipsrentalproperties_includeboxmain.cfm @ 13:29:59.059
SELECT DISTINCT qoptions.value, qoptions.qoid
FROM qoptions, answersmc
WHERE answersmc.qid = 132
AND answersmc.answerid = '80343'
AND answersmc.qoid = qoptions.qoid
checkculturefeature (Datasource=expert, Time=6ms, Records=4) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 90 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
		Select summary, hiimg 
		FROM answers
         where answerid = 73813
         and summary <> ''
checklivingfeature (Datasource=expert, Time=5ms, Records=3) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 90 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
		Select summary, hiimg 
		FROM answers
         where answerid = 76398
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 90 
	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-11"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=10ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-07-11"
     
         and rptarticlenetworks.networkid = 90 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:29:59.059
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 21
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 13:29:59.059
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 90 
getrptarticlephotos (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 13:29:59.059
SELECT  hiimg
FROM rptarticles
where rptarticleID = 21
and hiimg <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/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=90&s=1&sort=c&slug=Real-Estate-&slug2=Houses-for-Sale-in-Philippines
REMOTE_ADDR=162.158.79.9
REMOTE_HOST=162.158.79.9
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=31695870
cftoken=25839512
hitcount=1
lastvisit={ts '2020-07-11 13:29:58'}
timecreated={ts '2020-07-11 13:29:58'}
urltoken=CFID=31695870&CFTOKEN=25839512
Cookie Variables:
CFID=31695870
CFTOKEN=25839512
Session Variables:
cfid=31695870
cftoken=25839512
sessionid=IBEXPATEXCHANGE_31695870_25839512
urltoken=CFID=31695870&CFTOKEN=25839512
URL Parameters:
networkid=90
s=1
slug=Real-Estate-
slug2=Houses-for-Sale-in-Philippines
sort=c
tipcategoryid=2831
topicid=6
Debug Rendering Time: 11 ms