Aventura Foreclosures for Sale

Florida Homes > Miami-dade County Homes > Aventura Foreclosures for Sale
Agents: Post Your Listings

Are you looking for homes for sale in Aventura, Florida? View recently listed real estate properties throughout the Aventura, Florida 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 Aventura Real Estate Agents to help you find or purchase your new Aventura home. We receive new listings everyday from local agents, brokers and the MLS, so check back regularly!

Listings

1 2 3 > >>

Displaying 1 - 9 of 511 Listings

  • $3,191,220
  • , Ba
  • MLS# 21337016
  • $3,000,300
  • 4 Bd, 5 Ba
  • MLS# 22431232
  • $1,330,000
  • 3 Bd, 4 Ba
  • MLS# 20785170
  • $1,275,000
  • 2 Bd, 3 Ba
  • 2984 sq.ft.
  • MLS# 22038843
  • $1,148,431
  • 3 Bd, 2 Ba
  • 2030 sq.ft.
  • MLS# 20301624
  • $1,000,000
  • 4 Bd, 4 Ba
  • MLS# 22244804
  • $967,500
  • 3 Bd, 2 Ba
  • MLS# 22664792
  • $965,756
  • , Ba
  • MLS# 21337466
  • $947,043
  • 3 Bd, 4 Ba
  • 3220 sq.ft.
  • MLS# 20791768
1 2 3 > >>

Browse Options

Change Location or Price

$

to $

Properties in Aventura, FL

Maximum Price

Bedrooms

Bathrooms

Mortgage Rates

RefinanceAPR
30 yr fixed mtg refi 5.58%
15 yr fixed mtg refi 5.31%
1 yr ARM refi 5.73%
PurchaseAPR
30 yr fixed mtg 5.62%
15 yr fixed mtg 5.33%
1 yr ARM 5.73%
View Florida Rates

Local Resources

Miami Beach FL Homes
Search the Miami Beach FL MLS Daily
Contact Me Today For More Info!

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

Debugging Information
ColdFusion Server Enterprise 8,0,0,176276
Template /Content/PropertyDirectoryCityListings.cfm
Time Stamp 01-Dec-08 04:47 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 (7ms) /web/Portal_F5/HomesCom/Application.cfm
top level (4977ms) /web/Portal_F5/HomesCom/Content/PropertyDirectoryCityListings.cfm
  · arrowtop level (31ms) /web/Portal_F5/HomesCom/Include/Logic/mdlHeaderNew.cfm @ line 27
  ·  · arrowtop level (17ms) /web/Portal_F5/Modules/SelectTerritory.cfm @ line 134
  ·  · arrowtop level (2ms) /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 (1476ms) /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryCityListings.cfm @ line 30
  · arrowtop level (38ms) /web/Portal_F5/HomesCom/Include/HeaderNew.cfm @ line 33
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/cobrand.cfm @ line 28
  ·  · arrowtop level (27ms) /web/Portal_F5/HomesCom/Include/Logic/mdlHeaderNew.cfm @ line 31
  ·  ·  · arrowtop level (16ms) /web/Portal_F5/Modules/SelectTerritory.cfm @ line 134
  ·  ·  · arrowtop level (1ms) /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 (3195ms) /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ line 36
  ·  · arrowtop level (3ms) /web/Portal_F5/HomesCom/Include/PropertyDirectoryPageIndex.cfm @ line 108
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/Modules/Output/OutputPropDirListing.cfm @ line 221
  ·  · arrowtop level (1ms) /web/Portal_F5/HomesCom/Include/PropertyDirectoryPageIndex.cfm @ line 243
  ·  · arrowtop level (7ms) CFC[ /web/Portal_F5/HomesCom/Components/navigation.cfc | dspLeftNav(dspConfig = [complex value]) ] from /web/Portal_F5/HomesCom/Components/navigation.cfc @ line 272
  ·  · arrowtop level (96ms) /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ line 285
  ·  ·  · arrowtop level (31ms) /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 (6ms) 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(FL) ] 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 287
  ·  · arrowtop level (0ms) /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryFooterText.cfm @ line 294
  · arrowtop level (224ms) /web/Portal_F5/HomesCom/Include/FooterNew.cfm @ line 47
  ·  · 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 (213ms) /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 (205ms) CFC[ /web/Portal_F5/HomesCom/Components/impressions.cfc | logPropertySearchImpression([complex value]) ] from /web/Portal_F5/HomesCom/Components/impressions.cfc @ line 10

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

SQL Queries

qStateName (Datasource=HomesCom, Time=1ms, Records=1) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryCityListings.cfm @ 16:47:44.044
	select state from ols_states where
	ols_states.abbrev = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = FL

qCountySelect (Datasource=HomesCom, Time=2ms, Records=1) in /web/Portal_F5/HomesCom/Include/Logic/mdlPropertyDirectoryCityListings.cfm @ 16:47:44.044
		select DISTINCT z.county_name as name
		from zip_codes z
		where z.country = ?
			AND z.state = ?
		  	and z.city=?
               and z.county_name is not null
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = US
Parameter #2(CF_SQL_VARCHAR) = FL
Parameter #3(CF_SQL_VARCHAR) = AVENTURA

getCityData (Datasource=HomesCom, Time=10ms, Records=1) in /web/Portal_F5/HomesCom/Components/forrent.cfc @ 16:47:44.044
  			SELECT 
          'Find Apartments for Rent in ' || initcap(city) || ', ' || initcap(state) as displaystring
          , url
          , 'Apartments in ' || initcap(city) || ', ' || initcap(state) AS rightnavdisplaystring
          , url AS rightnavurl
        FROM forrent_city
        WHERE
          city = ?
          AND state = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = AVENTURA
Parameter #2(CF_SQL_VARCHAR) = FL

qSelectCompactCity (Datasource=HomesCom, Time=2ms, Records=1) in /web/Portal_F5/Modules/SelectTerritory.cfm @ 16:47:44.044
					SELECT	COMPACT_CITY(?)	"CompactCity"
					FROM	DUAL
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = AVENTURA

qSelectPropertyType (Datasource=HomesCom, Time=2ms, Records=1) in /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ 16:47:44.044
  		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) =

qSelectPropertyType (Datasource=HomesCom, Time=2ms, Records=1) in /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ 16:47:44.044
  		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=226ms, Records=9) in /web/Portal_F5/Modules/SelectListingRecordsMultiCity.cfm @ 16:47:46.046
		SELECT propertyid FROM qSelectListingRecords
		WHERE fk_supplier_id is not null
qSelectShowListingAddress (Datasource=HomesCom, Time=4ms, Records=9) in /web/Portal_F5/HomesCom/Components/ListingSearch/listingDetail.cfc @ 16:47:46.046
      	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) = 76675404
Parameter #2(cf_sql_numeric) = 79051947
Parameter #3(cf_sql_numeric) = 75222539
Parameter #4(cf_sql_numeric) = 78227594
Parameter #5(cf_sql_numeric) = 74083484
Parameter #6(cf_sql_numeric) = 78677802
Parameter #7(cf_sql_numeric) = 79495134
Parameter #8(cf_sql_numeric) = 76675401
Parameter #9(cf_sql_numeric) = 75222546

Caller.qSelectPropTypes (Datasource=HomesCom, Time=0ms, Records=10, Cached Query) in /web/Portal_F5/Modules/SelectPropTypes.cfm @ 16:47:46.046
		SELECT	DESCRIPTION			AS Description,
				TYPE_VALUE	AS Code
		FROM	OLS_PROP_TYPE
		ORDER BY 2
qSelectShowListingAddress (Datasource=HomesCom, Time=4ms, Records=9) in /web/Portal_F5/HomesCom/Components/ListingSearch/listingDetail.cfc @ 16:47:46.046
      	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) = 76675404
Parameter #2(cf_sql_numeric) = 79051947
Parameter #3(cf_sql_numeric) = 75222539
Parameter #4(cf_sql_numeric) = 78227594
Parameter #5(cf_sql_numeric) = 74083484
Parameter #6(cf_sql_numeric) = 78677802
Parameter #7(cf_sql_numeric) = 79495134
Parameter #8(cf_sql_numeric) = 76675401
Parameter #9(cf_sql_numeric) = 75222546

showListingAddressQuery (Datasource=, Time=460ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:46.046
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 76675404
showListingAddressQuery (Datasource=, Time=311ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:47.047
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 79051947
showListingAddressQuery (Datasource=, Time=275ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:47.047
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 75222539
showListingAddressQuery (Datasource=, Time=342ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:47.047
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 78227594
showListingAddressQuery (Datasource=, Time=326ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:47.047
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 74083484
showListingAddressQuery (Datasource=, Time=124ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:48.048
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 78677802
showListingAddressQuery (Datasource=, Time=491ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:48.048
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 79495134
showListingAddressQuery (Datasource=, Time=267ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:48.048
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 76675401
showListingAddressQuery (Datasource=, Time=412ms, Records=1) in /web/Portal_F5/HomesCom/Include/Content/dspPropertyDirectoryCityListings.cfm @ 16:47:49.049
              SELECT show_address AS displaylistingaddress FROM qSelectShowListingAddress WHERE fk_propid = 75222546
qGetStateAverages (Datasource=HomesCom, Time=3ms, Records=3) in /web/Portal_F5/HomesCom/Components/bankRate.cfc @ 16:47:49.049
  			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) = FL

qGetStateAverages (Datasource=HomesCom, Time=3ms, Records=3) in /web/Portal_F5/HomesCom/Components/bankRate.cfc @ 16:47:49.049
  			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) = FL

getState (Datasource=HomesCom, Time=5ms, Records=1) in /web/Portal_F5/HomesCom/Components/Utilities.cfc @ 16:47:49.049
			select state from ols_states os where os.abbrev = 'FL'
getLocIDS (Datasource=HomesCom, Time=5ms, Records=1) in /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ 16:47:49.049
		SELECT pk_psearch_location FROM psearch_location_cs
		WHERE 1 = 1 
		
			AND city = ? 
			and state = ?
Query Parameter Value(s) -
Parameter #1(CF_sql_varchar) = AVENTURA
Parameter #2(CF_sql_varchar) = FL

PowerSearchAdvert (Datasource=HomesCom, Time=5ms, Records=1) in /web/Portal_F5/Modules/Output/OutputPowerSearchAdvert.cfm @ 16:47:49.049
			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 (7618))
			AND hide <> 1
			AND OOA.fk_olcptype != 'X'

Stored Procedures

portal_impressions.log_listing_impressions (Datasource=HomesCom, Time=200ms) in /web/Portal_F5/HomesCom/Components/impressions.cfc @ 16:47:49.049

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_VARCHAR  NULL    
 IN  CF_SQL_VARCHAR  76675404,79051947,75222539,78227594,74083484,78677802,79495134,76675401,75222546    
 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=2
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:34:17'}
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/PropertyDirectoryCityListings.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/PropertyDirectoryCityListings.cfm
QUERY_STRING=City=AVENTURA&State=FL&Proptype=Foreclosures&TotalRecs=468&FirstRec=1
REMOTE_ADDR=38.103.63.57
REMOTE_HOST=38.103.63.57
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Content/PropertyDirectoryCityListings.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=22426
cftoken=41860303
hitcount=1
lastvisit={ts '2008-12-01 16:47:44'}
timecreated={ts '2008-12-01 16:47:44'}
urltoken=CFID=22426&CFTOKEN=41860303

Cookie Variables:
CFID=22426
CFTOKEN=41860303
MY.USERNAME=

Request Parameters:
cachefilepath=http://cdn-031.homes.com/c1/media/portalfilecache
cacheimagepath=http://cdn-304.homes.com/c1/media/portalimgcache
cachestylepath=http://cdn-072.homes.com/c1/media/portalstylecache
cobrand=
datasource=HomesCom
forrentstruct=Struct (3)
impressionstruct=Struct (1)
oimpressions=Struct (5)
omnichannel=Directory | Homes | FL | AVENTURA
omnipagename=PropertyDirectoryCityListings.cfm
omnipagetype=
omniprop1=
server_name=webprod16.as

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

URL Parameters:
CITY=AVENTURA
FIRSTREC=1
PROPTYPE=Foreclosures
STATE=FL
TOTALRECS=468
Debug Rendering Time: 12603 ms