Are you looking for homes for sale in Washington? View recently listed real estate properties throughout the Washington area on Homes.com. We have hundreds of listings including condos, town homes, foreclosures, new homes and apartments for rent. Once you have located a listing of interest, simply complete the information request or search for Washington Real Estate Agents to help you find or purchase your new home. We receive new listings everyday from local agents, brokers and the MLS, so check back regularly!

Listings

  • $675,000
  • 3 Bd, 1
  • 2404 sq.ft.
  • MLS# 28116433
  • $445,950
  • 4 Bd, 2
  • 2190 sq.ft.
  • MLS# 28116366
  • Call for price
  • 5 Bd, 3
  • 5390 sq.ft.
  • MLS# 28137783
  • $1,099,000
  • 6 Bd, 3
  • 7495 sq.ft.
  • MLS# 28022772
  • $169,000
  • 2 Bd, 1
  • 1100 sq.ft.
  • MLS# 28008479
  • $449,000
  • 3 Bd, 2
  • 2545 sq.ft.
  • MLS# 27207024
  • $359,000
  • MLS# 28066075
  • $224,900
  • 2 Bd, 1
  • MLS# 28157895
  • $250,000
  • 2 Bd, 1
  • MLS# 28115204

Browse Options

Properties in Washington

Search Homes Nationwide

Mortgage Rates

RefinanceAPR
30 yr fixed mtg refi 5.7%
15 yr fixed mtg refi 5.4%
1 yr ARM refi 5.86%
PurchaseAPR
30 yr fixed mtg 5.71%
15 yr fixed mtg 5.42%
1 yr ARM 5.86%
View Washington Rates

Local Resources

Apartments in Washington
Search for apartment rentals
www.forrent.com

Puyallup WA Real Estate
Find Homes for Sale in Puyallup WA
View Featured Propertied & Listings

Kirkland WA Area Homes
Current and Complete List of Homes
Buy/Sell Homes Condos Townhouses

Federal Way WA Area Homes
Real Estate in Federal Way WA
View Listings, Pics, Info & More

Three Star Realty, Inc.
Buy / Sell Real Estate
Vancouver, WA Homes

East Lewis County Homes
Free Real Estate Listings in WA
Find the Ideal Home in Washington

© Copyright 2007 - 2008 Dominion Enterprises. All Rights Reserved.

Debugging Information
ColdFusion Server Enterprise 8,0,0,176276
Template /Content/PropertyDirectoryStateCounties.cfm
Time Stamp 01-Dec-08 04:32 PM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 38.103.63.57
Host Name 38.103.63.57

Execution Time

top level (8ms) /web/Portal_F5/HomesCom/Application.cfm
top level (3699ms) /web/Portal_F5/HomesCom/Content/PropertyDirectoryStateCounties.cfm
  · arrowtop level (14ms) /web/Portal_F5/HomesCom/Include/Logic/mdlHeaderNew.cfm @ line 41
  ·  · arrowtop level (3ms) /web/Portal_F5/HomesCom/Include/Logic/mdlDartLogic.cfm @ line 157
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/Include/Logic/mdlSetPageMetas.cfm @ line 166
  · arrowtop level (2804ms) /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ line 44
  ·  · arrowtop level (2147ms) /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ line 366
  · arrowtop level (18ms) /web/Portal_F5/HomesCom/Include/HeaderNew.cfm @ line 47
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/cobrand.cfm @ line 28
  ·  · arrowtop level (7ms) /web/Portal_F5/HomesCom/Include/Logic/mdlHeaderNew.cfm @ line 31
  ·  ·  · arrowtop level (0ms) /web/Portal_F5/HomesCom/Include/Logic/mdlDartLogic.cfm @ line 157
  ·  ·  · arrowtop level (0ms) /web/Portal_F5/HomesCom/Include/Logic/mdlSetPageMetas.cfm @ line 166
  · arrowtop level (697ms) /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryStateCounties.cfm @ line 50
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (0ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 197
  ·  · arrowtop level (13ms) CFC[ /web/Portal_F5/HomesCom/Components/navigation.cfc | dspLeftNav(dspConfig = [complex value]) ] from /web/Portal_F5/HomesCom/Components/navigation.cfc @ line 240
  ·  · arrowtop level (629ms) /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ line 253
  ·  ·  · arrowtop level (80ms) /web/Portal_F5/Modules/Output/OutputPropMortgage.cfm @ line 34
  ·  ·  ·  · arrowtop level (6ms) CFC[ /web/Portal_F5/HomesCom/Components/bankRate.cfc | getStateAverages([complex value]) ] from /web/Portal_F5/HomesCom/Components/bankRate.cfc @ line 20
  ·  ·  ·  · arrowtop level (53ms) CFC[ /web/Portal_F5/HomesCom/Components/bankRate.cfc | getStateAverages([complex value]) ] from /web/Portal_F5/HomesCom/Components/bankRate.cfc @ line 23
  ·  ·  ·  · arrowtop level (8ms) CFC[ /web/Portal_F5/HomesCom/Components/Utilities.cfc | StateAbbrevToFull(WA) ] from /web/Portal_F5/HomesCom/Components/Utilities.cfc @ line 91
  ·  · arrowtop level (0ms) CFC[ /web/Portal_F5/HomesCom/Components/navigation.cfc | dspRightNav() ] from /web/Portal_F5/HomesCom/Components/navigation.cfc @ line 255
  ·  · arrowtop level (0ms) /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryFooterText.cfm @ line 262
  · arrowtop level (0ms) CFC[ /web/Portal_F5/HomesCom/Components/ListingSearch/location.cfc | translatePropTypeCode( ) ] from /web/Portal_F5/HomesCom/Components/ListingSearch/location.cfc @ line 57
  · arrowtop level (151ms) /web/Portal_F5/HomesCom/Include/FooterNew.cfm @ line 66
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/Include/footerlinks.cfm @ line 34
  ·  · arrowtop level (0ms) /web/Portal_F5/HomesCom/Include/CopyrightNew.cfm @ line 38
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/Include/omnitureTracking.cfm @ line 42
  ·  · arrowtop level (140ms) /web/Portal_F5/HomesCom/Include/impressionCounter.cfm @ line 53
  ·  ·  · arrowtop level (0ms) CFC[ /web/Portal_F5/HomesCom/Components/impressions.cfc | init() ] from /web/Portal_F5/HomesCom/Components/impressions.cfc @ line 2
  ·  ·  · arrowtop level (133ms) CFC[ /web/Portal_F5/HomesCom/Components/impressions.cfc | logPropertySearchImpression([complex value]) ] from /web/Portal_F5/HomesCom/Components/impressions.cfc @ line 10

(5 ms) STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
(3712 ms) TOTAL EXECUTION TIME
red = over 250 ms execution time

SQL Queries

qStates (Datasource=HomesCom, Time=6ms, Records=53) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ 16:32:29.029
		SELECT ABBREV as Code, STATE 
		FROM ZIP_STATES_BASE 
		WHERE COUNTRY IN ('US','VI') AND SHOWSTATE = 1
		ORDER BY STATE
qCounties (Datasource=HomesCom, Time=43ms, Records=36) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ 16:32:29.029
		SELECT initcap(z.county_name) as county, 
			sum(cs.props) as props
		FROM portal_city_summary cs, 
			(select distinct city, state, county_name, country FROM zip_codes) z
		WHERE cs.city = z.city 
          	AND cs.fk_state = z.state 
			AND z.county_name is not null
          	AND z.country =  ?
			AND z.state = ? AND props != 0 
		GROUP BY z.county_name
		ORDER BY z.county_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = US
Parameter #2(CF_SQL_VARCHAR) = WA

getFullStateName (Datasource=HomesCom, Time=6ms, Records=1) in /web/Portal_F5/HomesCom/Components/forrent.cfc @ 16:32:29.029
        SELECT state FROM ols_states WHERE abbrev = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

getLink (Datasource=HomesCom, Time=6ms, Records=1) in /web/Portal_F5/HomesCom/Components/forrent.cfc @ 16:32:29.029
        SELECT 'Search Apartments for Rent in WA' as displaystring
        , 'http://www.forrent.com/search-apartments-by-area/WA.php' AS url
        , 'Apartments in Washington' AS rightnavdisplaystring
        , 'http://www.forrent.com/search-apartments-by-area/WA.php' AS rightnavurl
        FROM dual
qStateName (Datasource=HomesCom, Time=1ms, Records=1) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ 16:32:29.029
	select state from ols_states where
	ols_states.abbrev = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

qSelectCityDetail (Datasource=HomesCom, Time=45ms, Records=1) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ 16:32:29.029
		 	  SELECT OCS.FK_STATE						AS State,
					 NVL(PROPS,0)						AS Properties,
					 NVL(RENTALS,0)						AS Rentals,
					 NVL(AGENTS,0)						AS Agents,
					 NVL(BROKERS,0)						AS Brokers,
					 NVL(AGENTS,0)+NVL(BROKERS,0)		AS AgentsAndOffices,
					 NVL(BUILDER,0)						AS Builders,
					 NVL(TOWNHOUSE,0)					AS Townhouse,
					 NVL(CONDO,0)						AS Condo,
					 NVL(TOWNHOUSE,0)+NVL(CONDO,0) as Townhouse_condo,
					 NVL(DUPLEX,0)						AS Duplex,
					 NVL(ACREAGE,0)						AS Acreage,
					 NVL(MOBILE,0)						AS Mobile,
					 NVL(NEWHOMES,0)					AS NewHomes,
					 NVL(RESORTS,0)						AS Resorts,
					 NVL(COMMERCIAL,0)					AS Commercial,
					 NVL(WATERFRONT,0)					AS Waterfront,
					 NVL(FARMS,0)						AS Farms,
					 NVL(HOUSE_RANCH,0)					AS HouseRanch,
					 NVL(GOLF_COURSE,0)					AS Golfcourse,
					 NVL(HOUSES_RENTAL,0)				AS RentalHouses,
					 NVL(RESORT_HOMES,0)				AS ResortHomes,
					 NVL(MOUNTAIN,0)					AS Mountain,
					 NVL(VINEYARD,0)					AS Vineyard,
					 NVL(HISTORIC,0)					AS Historic,
					 NVL(MAGS,0)						AS Mags,
					 NVL(INT_MULTI_PHOTO,0)				AS MultiPhoto,
					 NVL(INT_VIRTUAL_TOUR,0)			AS VirtualTours,
					 NVL(INT_HAS_IPIX,0)				AS Ipix,
					 NVL(OCS.BEDROOMS1,0)				AS Beds1,
					 NVL(OCS.BEDROOMS2,0)				AS Beds2,
					 NVL(OCS.BEDROOMS3,0)				AS Beds3,
					 NVL(OCS.BEDROOMS4,0)				AS Beds4,
					 NVL(OCS.BEDROOMS5,0)				AS Beds5,
					 NVL(OCS.BEDROOMS5PLUS,0)			AS Beds5Plus,
					 NVL(OCS.BATHS1,0)					AS Baths1,
					 NVL(OCS.BATHS2,0)					AS Baths2,
					 NVL(OCS.BATHS3,0)					AS Baths3,
					 NVL(OCS.BATHS4,0)					AS Baths4,
					 NVL(OCS.BATHS5,0)					AS Baths5,
					 NVL(OCS.BATHS5PLUS,0)				AS Baths5Plus,
					 NVL(OCS.SEARCH_FIREPLACE,0)		AS Fireplace,
					 NVL(OCS.SEARCH_GARAGE,0)			AS Garage,
					 NVL(OCS.SEARCH_PATIO,0)			AS Patio,
					 NVL(OCS.SEARCH_POOL,0)				AS Pool,
					 NVL(OCS.SEARCH_WASHERDRYER,0)		AS WasherDryer,
					 NVL(OCS.SEARCH_HANDICAP,0)			AS Handicap,
					 NVL(OCS.SEARCH_HANDICAP,0)			AS HandicapAccess,
					 NVL(OCS.SEARCH_WATERFRONT,0)		AS Waterfront,
					 NVL(OCS.SEARCH_GOLFCOURSE,0)		AS GolfCourse,
					 NVL(OCS.SEARCH_CABLE_TV,0) 		AS Cable_TV,
					 NVL(OCS.SEARCH_BOAT_FAC,0) 		AS Boat_Fac,
					 NVL(OCS.SEARCH_HORSE,0) 			AS Horse,
					 NVL(OCS.SEARCH_TENNIS,0) 			AS Tennis,
					 NVL(OCS.SEARCH_FENCE,0) 			AS Fence,
					 NVL(OCS.SEARCH_FIRE_ALARM,0) 		AS Fire_Alarm,
					 NVL(OCS.SEARCH_SECURITY,0) 		AS Security,
					 NVL(OCS.SEARCH_PETS_ALLOWED,0) 	AS Pets_Allowed,
					 NVL(OCS.SEARCH_DISHWASHER,0) 		AS Dishwasher,
					 NVL(OCS.SEARCH_REFRIG,0) 			AS Refrig,
					 NVL(OCS.SEARCH_MICROWAVE,0) 		AS Microwave,
					 NVL(OCS.SEARCH_RANGEOVEN,0) 		AS Rangeoven,
					 NVL(OCS.SEARCH_DISPOSAL,0) 		AS Disposal,
					 NVL(OCS.SEARCH_CENTRAL_VAC,0) 		AS Central_Vac,
					 NVL(OCS.SEARCH_TRASH_COMP,0) 		AS Trash_Comp,
					 NVL(OCS.SEARCH_COMM_GATED,0) 		AS Comm_Gated,
					 NVL(OCS.SEARCH_COMM_CLUBHOUSE,0) 	AS Comm_Clubhouse,
					 NVL(OCS.SEARCH_COMM_POOL,0) 		AS Comm_Pool,
					 NVL(OCS.SEARCH_COMM_TENNIS,0) 		AS Comm_Tennis,
					 NVL(OCS.SEARCH_COMM_GOLF,0) 		AS Comm_Golf,
					 NVL(OCS.SEARCH_COMM_LAUNDRY,0) 	AS Comm_Laundry,
					 NVL(OCS.SEARCH_COMM_HORSE,0) 		AS Comm_Horse,
					 NVL(OCS.SEARCH_COMM_GYM,0) 		AS Comm_Gym,
					 NVL(OCS.SEARCH_COMM_SAUNA,0) 		AS Comm_Sauna,
					 NVL(OCS.SEARCH_COMM_SPA,0) 		AS Comm_Spa,
					NVL(OCS.SEARCH_COMM_PLAYGROUND,0) 	AS Comm_Playground,
					NVL(OCS.Multi_Family,0) 	AS Multi_family          
			  FROM	PORTAL_STATE_SUMMARY	OCS
	    	  WHERE	oCs.fk_state = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

qSelectTopPropIDs (Datasource=HomesCom, Time=512ms, Records=9) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryStateCounties.cfm @ 16:32:30.030
		select fk_propid
		From (
		    SELECT os.fk_propid, dbms_random.random as randomid
		    FROM OLS_LISTING_SEARCH_HC OS 
		    WHERE os.fk_state = ? AND 
			NVL(OS.FK_PROPERTY_TYPE,0) IN (0,1,6) AND 
		          ( OS.SOLD IS NULL OR OS.SOLD NOT IN ('E','Y')) 
				  
				  and nvl(fk_supplier_id,0) != 215
				  
		order by randomid
		)
		where rownum <= 9
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

qSelectPropertyType (Datasource=HomesCom, Time=2ms, Records=1) in /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ 16:32:30.030
  		SELECT	OPLT.NAME			"Name",
  				OPLT.QUERY			"Query"
  		FROM	OLS_PROP_LIST_TYPE	OPLT
  		WHERE	PK_TYPEID = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) =

qListingRecordsNoHandEnter (Datasource=, Time=543ms, Records=8) in /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ 16:32:32.032
		SELECT propertyid FROM qSelectListingRecords
		WHERE fk_supplier_id is not null
qSelectShowListingAddress (Datasource=HomesCom, Time=6ms, Records=9) in /web/Portal_F5/HomesCom/Components/ListingSearch/listingDetail.cfc @ 16:32:32.032
      	Select decode(MLS_ShowAddress, 'Y', 'Y',  
      	                               'N', 'N',      
      	                               decode(OfficeSubsite, 'N', decode(OfficeShowAddress, 'Y', 'Y',
      	                                                                                    'N', 'N',
      	                                                                                    Agent_ShowAddress),
      	                                                     'Y', decode(AgentSubsite, 'N', Agent_ShowAddress,
      	                                                                               decode(OfficeShowAddress, 'Y', 'Y',
      	                                                                                                         'N', 'N',
      	                                                                                                         Agent_ShowAddress)
      	                                                                ),
      	                                                     decode(AgentSubsite, 'N', decode(Agent_ShowAddress, 'Y', 'Y',
      	                                                                                                         Agent_OverrideAddress),
      	                                                                          decode(OfficeShowAddress, 'Y', 'Y',
      	                                                                                                    'N', 'N',
      	                                                                                                    Agent_ShowAddress)
      	                                                           )
      	                                      )
      	              ) as show_address,
					  fk_propid
        from (select oms.display_street_address as MLS_ShowAddress,
                     AgentSubsite,
                     Agent_ShowAddress,
                     Agent_OverrideAddress,
                     OfficeSubsite,
                     OfficeShowAddress,
					 ol.fk_propid
                from ols_listing ol,
                     ols_mls_supplier oms,
                     (select ola.fk_propid,
                             opp.show_ntl_listing_addresses_ynd Agent_ShowAddress,
                             opp.show_listing_address_yn Agent_OverrideAddress,
                             oot.sub_type AgentSubSite -- Agents Approval 
                        from ols_listing ola,
                             ols_preferred_pages opp,
                             ols_olcp_account ooa,
                             ols_olcp_type oot
                       where (ola.fk_agentid1 = ooa.fk_agentid OR ola.fk_agentid2 = ooa.fk_agentid)
                         and ooa.pk_acctid = opp.fk_acctid
                         and ooa.fk_olcptype = oot.pk_olcptype) agt,
                     (select olo.fk_propid,
                             opp.show_ntl_listing_addresses_ynd OfficeShowAddress,
                             oot.sub_type OfficeSubSite -- Office's approval
                        from ols_listing olo,
                             ols_preferred_pages opp,
                             ols_olcp_account ooa,
                             ols_olcp_type oot
                       where olo.fk_adverid = ooa.fk_adverid
                         and ooa.pk_acctid = opp.fk_acctid
                         and ooa.fk_olcptype = oot.pk_olcptype) ofc
               where ol.fk_supplier_id = oms.pk_supplier_id(+)
                 
				 
		           and ol.fk_propid IN (?,?,?,?,?,?,?,?,?)
		        
				 and ol.fk_propid = agt.fk_propid(+)
            and ol.fk_propid = ofc.fk_propid(+)
         )
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 72963031
Parameter #2(cf_sql_numeric) = 72964660
Parameter #3(cf_sql_numeric) = 74101800
Parameter #4(cf_sql_numeric) = 78141262
Parameter #5(cf_sql_numeric) = 67627754
Parameter #6(cf_sql_numeric) = 61417658
Parameter #7(cf_sql_numeric) = 77597137
Parameter #8(cf_sql_numeric) = 76657670
Parameter #9(cf_sql_numeric) = 77697658

qGetStateAverages (Datasource=HomesCom, Time=3ms, Records=3) in /web/Portal_F5/HomesCom/Components/bankRate.cfc @ 16:32:32.032
  			SELECT
          bl.state, bl.prod_type, bl.prod_no, bl.prod_uid, bl.prod_name, bl.prod_desc, bl.rate, bl.apr_yld, bl.rate_diff, bl.b1wkrate, bl.thisday
          , bp.product_type
        FROM
          bankrate_loans bl
          JOIN bankrate_products bp ON bl.prod_uid = bp.product_uid    
        WHERE state = ? 
          AND bl.prod_uid IN ( 216,215,217 )
        
          ORDER BY prod_no
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

qGetStateAverages (Datasource=HomesCom, Time=44ms, Records=3) in /web/Portal_F5/HomesCom/Components/bankRate.cfc @ 16:32:32.032
  			SELECT
          bl.state, bl.prod_type, bl.prod_no, bl.prod_uid, bl.prod_name, bl.prod_desc, bl.rate, bl.apr_yld, bl.rate_diff, bl.b1wkrate, bl.thisday
          , bp.product_type
        FROM
          bankrate_loans bl
          JOIN bankrate_products bp ON bl.prod_uid = bp.product_uid    
        WHERE state = ? 
          AND bl.prod_uid IN ( 1,2,3 )
        
          ORDER BY prod_no
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = WA

getState (Datasource=HomesCom, Time=5ms, Records=1) in /web/Portal_F5/HomesCom/Components/Utilities.cfc @ 16:32:32.032
			select state from ols_states os where os.abbrev = 'WA'
GetStateName (Datasource=HomesCom, Time=1ms, Records=1) in /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ 16:32:32.032
			SELECT state FROM ols_states WHERE abbrev = ?
Query Parameter Value(s) -
Parameter #1(CF_sql_varchar) = WA

getLocIDS (Datasource=HomesCom, Time=11ms, Records=54) in /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ 16:32:33.033
		SELECT pk_psearch_location FROM psearch_location_cs
		WHERE 1 = 1 
	
		
			and state = ?
Query Parameter Value(s) -
Parameter #1(CF_sql_varchar) = WA

PowerSearchAdvert (Datasource=HomesCom, Time=14ms, Records=13) in /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ 16:32:33.033
			SELECT 
				pal.headline, pal.desc1, pal.desc2, pal.dispurl, pal.desturl 
			FROM 
				psearch_advertiser_listing pal INNER JOIN OLS_OLCP_ACCOUNT OOA on OOA.pk_acctid = pal.fk_acctid
			WHERE pal.fk_acctid IN (SELECT fk_acctid FROM psearch_location_xref WHERE fk_psearch_location IN (2602,2711,984,834,182,6963,642,5502,4281,5501,643,2381,2243,2242,4282,3381,181,2244,5504,2051,5503,271,2241,641,981,3932,183,4021,4291,985,4292,6964,1161,2604,3931,5505,837,2382,723,982,2603,835,211,1822,1821,7553,7556,7554,2061,836,983,2601,2481,7555))
			AND hide <> 1
			AND OOA.fk_olcptype != 'X'

Stored Procedures

portal_impressions.log_listing_impressions (Datasource=HomesCom, Time=130ms) in /web/Portal_F5/HomesCom/Components/impressions.cfc @ 16:32:33.033

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  NULL    
 IN  CF_SQL_VARCHAR  72963031,72964660,74101800,78141262,67627754,61417658,77597137,76657670,77697658    
 IN  CF_SQL_VARCHAR  NULL    
    
resultsets
nameresultset

Scope Variables

Application Variables:
add_affiliate_dns_mx_url=http://ns2.homes.com/cgi-bin/mkaffiliate
add_preferred_dns_mx_url=http://ns2.homes.com/cgi-bin/mkzone2
additionalhtmlhead=
adimageserver=ads.homes.com
adimagespath=http://imgsrv.homes.com/mmsrv/adimages
adserverscript=http://ads.homes.com/cgi-bin/fetchimage
akamaiurl=http://
applicationname=HomesCom
apppathbaseurl=
arlimagepath=http://www.homes.com/HomesCom
backtotop=<DIV ALIGN="RIGHT"><FONT FACE="Verdana,Arial,Helvetica" SIZE="1">[<A HREF="#TOP">Back to top</A>]</FONT></DIV>
banneradstyle=1
billboardadstyle=3
black=000000
bodyalink=99CCCC
bodybackground=background.gif
bodybgcolor=C2D5EA
bodylink=336666
bodyvlink=999933
bullet=<IMG SRC="/Images/Bullets/greenarrow.gif" WIDTH="10" HEIGHT="10" ALT="" BORDER="0" ALIGN="texttop">
buttonlargeback=<INPUT TYPE="Image" NAME="Back" VALUE="Back" SRC="/Images/Buttons/BackLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargebacksrc=SRC="/Images/Buttons/BackLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargecancel=<INPUT TYPE="Image" NAME="Cancel" VALUE="Cancel" SRC="/Images/Buttons/CancelLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargecancelsrc=SRC="/Images/Buttons/CancelLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargeclear=<INPUT TYPE="Image" NAME="Clear" VALUE="Clear" SRC="/Images/Buttons/ClearLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargeclearsrc=SRC="/Images/Buttons/ClearLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargeclose=<INPUT TYPE="Image" NAME="Close" VALUE="Close" SRC="/Images/Buttons/CloseLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargeclosesrc=SRC="/Images/Buttons/CloseLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargefind=<INPUT TYPE="Image" NAME="Find" VALUE="Find" SRC="/Images/Buttons/FindLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargefindsrc=SRC="/Images/Buttons/FindLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargego=<INPUT TYPE="Image" NAME="Go" VALUE="Go" SRC="/Images/Buttons/GoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargegosrc=SRC="/Images/Buttons/GoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargemore=<INPUT TYPE="Image" NAME="More" VALUE="More" SRC="/Images/Buttons/MoreLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargemoresrc=SRC="/Images/Buttons/MoreLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargenext=<INPUT TYPE="Image" NAME="Next" VALUE="Next" SRC="/Images/Buttons/NextLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargenextsrc=SRC="/Images/Buttons/NextLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargeno=<INPUT TYPE="Image" NAME="No" VALUE="No" SRC="/Images/Buttons/NoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargenosrc=SRC="/Images/Buttons/NoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargeokay=<INPUT TYPE="Image" NAME="Okay" VALUE="Okay" SRC="/Images/Buttons/OkayLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargeokaysrc=SRC="/Images/Buttons/OkayLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargesearch=<INPUT TYPE="Image" NAME="Search" VALUE="Search" SRC="/Images/Buttons/SearchLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargesearchsrc=SRC="/Images/Buttons/SearchLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
buttonlargeyes=<INPUT TYPE="Image" NAME="Yes" VALUE="Yes" SRC="/Images/Buttons/YesLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
buttonlargeyessrc=SRC="/Images/Buttons/YesLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
centerwellwidth=494
checkmark=<IMG SRC="/Images/Bullets/bigredcheck.gif" WIDTH="25" HEIGHT="25" ALT="" BORDER="0" ALIGN="texttop">
contentcellcolor=FFFFFF
contentwellwidth=468
contrasttablepadding=EEEEEE
copyright=Copyright &copy;1999-2008 Homes.com, Inc.
copyrightyear=2007 - 2008
delete_dns_mx_url=http://ns2.homes.com/cgi-bin/dnsdel
dkblue=264F78
dkgray=999999
dkmustard=999933
dkteal=336666
domainregistrationurl=http://rogue.websocietyinc.com/cgi-bin/proxy/reg_control
dquote="
emptycell=FFFFFF
eneighnorhoodscustomerid=e6673247-8df1-4660-b33f-8a1997f8b1e0
environment=Production
errorblue=0000FF
errorcolor=FF0000
errorcount=5
foreclosurerotationbool=TRUE
formbordercolor=CCCCCC
formheader=FFCC66
formheaderdk=FFCC66
formhighlight=FFFFCC
formlistcell=FFFFFF
formlistheader=EEEEEE
formrowleft=EEEEEE
formrowright=FFFFFF
formsubheader=EEEEEE
gray=DEDEDE
gutterwidth=8
headingcellcolor=FFCC66
httpsbuttonlargego=<INPUT TYPE="Image" NAME="Go" VALUE="Go" SRC="/Images/Buttons/GoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0">
httpsbuttonlargegosrc=SRC="/Images/Buttons/GoLarge.gif" HEIGHT="25" WIDTH="60" BORDER="0"
imagepathbaseurl=/HomesCom
imageserver=www.homes.com
largestandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="3"
lasterrortime={ts '2008-12-01 16:28:12'}
leftbarwidth=156
leftnavwellwidth=130
logorowwidth=719
ltbluetab=E2ECF6
ltgold=FAF8F3
ltgray=EEEEEE
ltmedgray=DDDDDD
ltmustard=CCCC66
ltteal=99CCCC
ltyellow=FFFFCC
maps=1
mapscript=http://imgsrv.homes.com/cgi-bin/map.cgi
mapscripturl=/scripts/mqinterconnect.exe
mapserverurl=http://maps.homes.com
mapsupplier=3
medbluetab=6595C7
medgold=FBF6E5
medgray=CCCCCC
medpuke=FFCC66
medteal=669999
medyellow=FFFF99
menurowwidth=765
messageheadingcolor=9C0000
messagetextcolor=000000
metacopyright=Copyright &copy;1999-2008 Homes.com, Inc.
metadescription=Homes.com - The world's best real estate web site of homes, real estate, realtors, and homes for sale.  Find real estate agents, mortgage loans and rates, home loans, and home buying help.
metakeywords=homes.com real estate listings homes for sale realtor home homes.com houses real estate listings homes for sale realtor home news agents alabama alaska arizona real estate arkansas california real estate canada real estate caribbean colorado delaware directory estates florida real estate for sale by owner foreclosures fsbo georgia hawaii homes houses idaho real estate illinois immobiliare immobilien immobilier homes indiana inmobiliario iowa kansas kentucky louisiana maryland massachussetts maine michigan minnesota mississippi missouri mls montana nebraska nevada new hampshire real estate jersey mexico york north carolina dakota ohio oklahoma oregon pennsylvania property real estate realtors realty residential rhode island seller south tennessee texas utah vermont virginia washington west virginia wisconsin wyoming mexico
metaowner=Homes.com, Inc.
minibanneradstyle=6
monsterdaatabaseurl=http://www.neighborhoodplace.com/geochooser/?un=homeslite&pw=etilsemoh&spi=CH%5FHOMES%5FLITE%5FHTML&domain=Schools%28Lite%29
monthslist=January,February,March,April,May,June,July,August,September,October,November,December
morereports=<DIV ALIGN="RIGHT"><FONT FACE="Verdana,Arial,Helvetica" SIZE="1">[<A HREF="#Reports">More Reports</A>]</FONT>&nbsp;&nbsp;</DIV>
myencryptionkey=fdjfhslkdfjhasdfews
newline=

nopopularmark=<IMG SRC="/Images/Bullets/shim.gif" WIDTH="20" HEIGHT="19" ALT="" BORDER="0" ALIGN="texttop">
outertablewidth=783
pageleftmargin=10
pagetitle=Homes.com - Real Estate and Homes For Sale.
popularmark=<IMG SRC="/Images/Bullets/popular.gif" WIDTH="20" HEIGHT="19" ALT="" BORDER="0" ALIGN="texttop">
propertyidlist=
puketab=C9B062
questionmark=
red=FF0000
requiredflag=<FONT FACE="Verdana,Arial,Helvetica" SIZE="2" COLOR="FF0000"><B>*</B></FONT>
rightbarwidth=156
rightnavwellwidth=125
searchablefield=<IMG SRC="/Images/Affiliates/arrow10x10.gif" WIDTH="10" HEIGHT="10" BORDER="0" ALT="Fields that will be searched on are indicated by this image.">
separatorline=E4DCC9
sidebaradstyle=2
smallstandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="1"
squote='
standardface=FACE="Verdana,Arial,Helvetica"
standardfontface=FACE="Verdana,Arial,Helvetica" SIZE="2"
standardformdisabledfontface=FACE="Verdana,Arial,Helvetica" SIZE="1" COLOR="999999"
standardformfontface=FACE="Verdana,Arial,Helvetica" SIZE="1" COLOR="000000"
standardformheaderfontface=FACE="Verdana,Arial,Helvetica" SIZE="2" COLOR="000000"
tab=	
tablebordercolor=CCCCCC
tableheader=D6E3AA
tablepadding=FFFFFF
tablesubheader=CCCCCC
tan=D6E3AA
urltocss=/Resources/HomesCom1.css
urltojs=/Resources/JsUtilities1.js
vgnbaseurl=http://www.homes.com/HomesCom
white=FFFFFF
xlargestandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="4"
xxlargestandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="5"
xxxlargestandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="6"
xxxxlargestandardfontface=FACE="Verdana,Arial,Helvetica" SIZE="7"

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=/web/Portal_F5/HomesCom/Content/PropertyDirectoryStateCounties.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.homes.com.
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/web/Portal_F5/HomesCom/Content/PropertyDirectoryStateCounties.cfm
QUERY_STRING=state=WA
REMOTE_ADDR=38.103.63.57
REMOTE_HOST=38.103.63.57
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Content/PropertyDirectoryStateCounties.cfm
SERVER_NAME=www.homes.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.2.9 (Unix) JRun/4.0 mod_ssl/2.2.9 OpenSSL/0.9.8i DAV/2 PHP/5.2.6
WEB_SERVER_API=

Client Variables:
cfid=22057
cftoken=95748594
hitcount=1
lastvisit={ts '2008-12-01 16:32:29'}
timecreated={ts '2008-12-01 16:32:29'}
urltoken=CFID=22057&CFTOKEN=95748594

Cookie Variables:
CFID=22057
CFTOKEN=95748594
MY.USERNAME=

Request Parameters:
cachefilepath=http://cdn-026.homes.com/c1/media/portalfilecache
cacheimagepath=http://cdn-304.homes.com/c1/media/portalimgcache
cachestylepath=http://cdn-013.homes.com/c1/media/portalstylecache
cobrand=
datasource=HomesCom
forrentstruct=Struct (2)
impressionstruct=Struct (1)
oimpressions=Struct (5)
olocation=Struct (19)
omnichannel=Directory | Lists | Homes | All Available | WA 
omnipagename=PropertyDirectoryStateCounties.cfm
omnipagetype=
omniprop1=
server_name=webprod16.as

Server Variables:
COLDFUSION=Struct (8)
OS=Struct (7)

URL Parameters:
STATE=WA
Debug Rendering Time: 16361 ms