$2,950,000

9440 Butterworth Road

Hamilton Twp OH, 45140

Description

Cincinnati's most premier property! Custom build estate has it all! Located in loveland, private setting, outdoor kitchen, fully stocked pond, infinity pool, hot tub, 5 car heated garage with guesthouse above.

Details

MLS#1637098
StyleHouse
Sub-TypeResale
StatusActive
Year2010
Days On Site66

Features

Bed(s)6
Bath(s) 5 Full
SQ Feet7,748
Story(s)2 Story
Acreage25.00
Property ViewYes

Loading Form

Loading Form

Area Information

StateOH
CountyWarren
CityHamilton Twp
Zip Code45140
AreaWarren-E09
Community NameHamilton Twp.
School DistrictLittle Miami Local S
Listing VS Median (in Hamilton Twp.)
Price:
$2,950,000
low | high
Med:
$299,450
100% of Average
SqFt:
7,748
low | high
Med:
2,256
100% of Average
$ / SqFt:
$381
low | high
Med:
$134
100% of Average
On Site:
66
low | high
Med:
93
70.967741935484% of Average
SITE:www.gerryannerocco.com
SERVER:iq-web-1
DATA SERVER:cust-sql-0
COMPANY ID:iq_cb_heritage
USER:N/A
ACTING AS:N/A
REFERER:
REMOTE ADDRESS:100.24.115.253
USER AGENT:CCBot/2.0 (https://commoncrawl.org/faq/)
REQUEST URL:http://www.gerryannerocco.com/for-sale/9440-butterworth-road-hamilton-twp-oh-45140/175-204361
DATE:11/14/2019 15:59:42



Catch
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT *, ROW_NUMBER() OVER (ORDER BY distance asc, List_Price desc) + 0 AS RowNumberFROM (SELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage')THEN (1)ELSE (2)END),dbo.fn_LatLongDistance (39.29594039917, -84.243797302246, l.lat, l.lon) AS Distance,'f' AS iswatching,l.image_path AS ImagePath,l.url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentFirstName,'' AS AgentLastName,'' AS AgentPhone,'' AS AgentCell,'' AS AgentFax,'' AS AgentEmail,'' AS AgentWebsiteAddress,'' AS AgentTeam,'' AS AgentCertification,'' AS AgentLicenseNumber,'' AS AgentBioPath,'' AS AgentHasBlog,'' AS AgentURL,'' AS SecondAgentPublicID,'' AS SecondAgentImagePath,'' AS SecondAgentFirstName,'' AS SecondAgentLastName,'' AS SecondAgentPhone,'' AS SecondAgentCell,'' AS SecondAgentFax,'' AS SecondAgentEmail,'' AS SecondAgentWebsiteAddress,'' AS SecondAgentTeam,'' AS SecondAgentCertification,'' AS SecondAgentLicenseNumber,'' AS SecondAgentBioPath,'' AS SecondAgentHasBlog,'' AS SecondAgentURL,'' AS OfficeID,'' AS OfficeName,'' AS OfficePhone,'' AS OfficeAddress,'' AS OfficeCity,'' AS OfficeState,'' AS OfficeZip,'' AS OfficeDomain,'' AS LogoPath,'' AS LogoPathSmall,'' AS leadpublicid,'' AS AudioTour,PropertyID.PropertyID,'list_price' AS OrderBy,'desc' AS OrderDirection,l.MLSID,l.listingid,l.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,ROUND(l.Lat,5,0) as latitude,l.Lon,ROUND(l.Lon,5,0) as longitude,l.List_Price,l.LO_Name,l.LA_Name,l.ML_Number,l.PublicID,l.SecondPublicID,l.StreetAddress,l.City,l.State,l.Zip_Code,l.County,l.SchoolDistrict,l.ElementarySchool,l.JRHighSchool,l.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,l.ReducedDateTime,l.AddDateTime,l.Prev_List_Price,l.VirtualTourID,l.Images,l.SubType,l.Optional_01,l.Optional_02,l.Optional_03,l.Optional_04,l.Optional_05,l.Optional_06,l.Optional_07,l.Optional_08,l.Optional_09,l.Optional_10,l.Optional_11,l.Optional_12,l.Optional_13,l.Optional_14,l.Optional_15,l.Optional_16,l.Optional_17,l.Optional_18,l.Optional_19,l.Optional_20,l.VideoTour,l.SecondVideoTour,l.MLS_Remarks,l.Description,l.MLS_StatusCode,l.Orig_List_Price,l.SalePrice,l.ListingDateTime,l.DateTime,l.ClosingDateTime,l.ContractDateTime,l.DOM,l.REO,l.ShortSale,l.LO_ID,l.LA_ID,l.BO_ID,l.BA_ID,l.BO_Name,l.BA_Name,l.Image_List,l.DeleteFlag,l.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,l.Baths,l.FullBaths,l.HalfBaths,l.ThreeQuarterBaths,l.Beds,l.Garage,l.Style,l.sq_foot,l.Year_Built,l.Pool,l.Acreage,l.Story,l.Previews,l.Featured,l.CommunityName,l.PropertyView,l.Waterfront,l.Golfcourse,l.Basement,l.Carport,l.PatioSQ_Foot,l.BuildingName,l.UnitFloor,l.HOA,l.HoaDues,l.Zoning,l.sq_foot_Office,l.Units,l.AskingPricePersq_foot,l.SalesTerms,l.SaleType,l.sq_foot_Vacant,l.SuiteNumber,l.SuiteFloor,l.GrossBuildingArea,l.GrossLeaseArea,l.BuildingClass,l.LegalDescription,l.Occupancy,l.TenantOccupancyBasis,l.ConstructionStatus,l.YearRenovated,l.LeedCertification,l.Buildings,l.ParkingType,l.ParkingSpaces,l.PotentialRentalIncome,l.NetOperatingIncome,l.CapRate,l.InternalRateOfReturn,l.CashOnCash,l.PotentialRentalIncomeRemarks,l.NoiRemarks,l.CapRateRemarks,l.LoanBalance,l.InterestRate,l.AmortizationPeriod,l.MaturityDate,l.subarea,l.propertystory,l.propertystorystatus,l.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','MultiFamily','Residential','Land')AND PropertyID.Status = 'A'LEFT OUTER JOIN agents_teams_members WITH (NOLOCK)ON agents_teams_members.publicid = l.publicidand agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a')and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE l.id in (0)) dt ORDER BY distance, List_Price desc, ml_number ASC
DataSource
stringiq_cb_heritage
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringConnection reset
NativeErrorCode
number0
queryError
stringSELECT *, ROW_NUMBER() OVER (ORDER BY distance asc, List_Price desc) + 0 AS RowNumberFROM (SELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage')THEN (1)ELSE (2)END),dbo.fn_LatLongDistance (39.29594039917, -84.243797302246, l.lat, l.lon) AS Distance,'f' AS iswatching,l.image_path AS ImagePath,l.url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentFirstName,'' AS AgentLastName,'' AS AgentPhone,'' AS AgentCell,'' AS AgentFax,'' AS AgentEmail,'' AS AgentWebsiteAddress,'' AS AgentTeam,'' AS AgentCertification,'' AS AgentLicenseNumber,'' AS AgentBioPath,'' AS AgentHasBlog,'' AS AgentURL,'' AS SecondAgentPublicID,'' AS SecondAgentImagePath,'' AS SecondAgentFirstName,'' AS SecondAgentLastName,'' AS SecondAgentPhone,'' AS SecondAgentCell,'' AS SecondAgentFax,'' AS SecondAgentEmail,'' AS SecondAgentWebsiteAddress,'' AS SecondAgentTeam,'' AS SecondAgentCertification,'' AS SecondAgentLicenseNumber,'' AS SecondAgentBioPath,'' AS SecondAgentHasBlog,'' AS SecondAgentURL,'' AS OfficeID,'' AS OfficeName,'' AS OfficePhone,'' AS OfficeAddress,'' AS OfficeCity,'' AS OfficeState,'' AS OfficeZip,'' AS OfficeDomain,'' AS LogoPath,'' AS LogoPathSmall,'' AS leadpublicid,'' AS AudioTour,PropertyID.PropertyID,'list_price' AS OrderBy,'desc' AS OrderDirection,l.MLSID,l.listingid,l.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,ROUND(l.Lat,5,0) as latitude,l.Lon,ROUND(l.Lon,5,0) as longitude,l.List_Price,l.LO_Name,l.LA_Name,l.ML_Number,l.PublicID,l.SecondPublicID,l.StreetAddress,l.City,l.State,l.Zip_Code,l.County,l.SchoolDistrict,l.ElementarySchool,l.JRHighSchool,l.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,l.ReducedDateTime,l.AddDateTime,l.Prev_List_Price,l.VirtualTourID,l.Images,l.SubType,l.Optional_01,l.Optional_02,l.Optional_03,l.Optional_04,l.Optional_05,l.Optional_06,l.Optional_07,l.Optional_08,l.Optional_09,l.Optional_10,l.Optional_11,l.Optional_12,l.Optional_13,l.Optional_14,l.Optional_15,l.Optional_16,l.Optional_17,l.Optional_18,l.Optional_19,l.Optional_20,l.VideoTour,l.SecondVideoTour,l.MLS_Remarks,l.Description,l.MLS_StatusCode,l.Orig_List_Price,l.SalePrice,l.ListingDateTime,l.DateTime,l.ClosingDateTime,l.ContractDateTime,l.DOM,l.REO,l.ShortSale,l.LO_ID,l.LA_ID,l.BO_ID,l.BA_ID,l.BO_Name,l.BA_Name,l.Image_List,l.DeleteFlag,l.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,l.Baths,l.FullBaths,l.HalfBaths,l.ThreeQuarterBaths,l.Beds,l.Garage,l.Style,l.sq_foot,l.Year_Built,l.Pool,l.Acreage,l.Story,l.Previews,l.Featured,l.CommunityName,l.PropertyView,l.Waterfront,l.Golfcourse,l.Basement,l.Carport,l.PatioSQ_Foot,l.BuildingName,l.UnitFloor,l.HOA,l.HoaDues,l.Zoning,l.sq_foot_Office,l.Units,l.AskingPricePersq_foot,l.SalesTerms,l.SaleType,l.sq_foot_Vacant,l.SuiteNumber,l.SuiteFloor,l.GrossBuildingArea,l.GrossLeaseArea,l.BuildingClass,l.LegalDescription,l.Occupancy,l.TenantOccupancyBasis,l.ConstructionStatus,l.YearRenovated,l.LeedCertification,l.Buildings,l.ParkingType,l.ParkingSpaces,l.PotentialRentalIncome,l.NetOperatingIncome,l.CapRate,l.InternalRateOfReturn,l.CashOnCash,l.PotentialRentalIncomeRemarks,l.NoiRemarks,l.CapRateRemarks,l.LoanBalance,l.InterestRate,l.AmortizationPeriod,l.MaturityDate,l.subarea,l.propertystory,l.propertystorystatus,l.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','MultiFamily','Residential','Land')AND PropertyID.Status = 'A'LEFT OUTER JOIN agents_teams_members WITH (NOLOCK)ON agents_teams_members.publicid = l.publicidand agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a')and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE l.id in (0)) dt ORDER BY distance, List_Price desc, ml_number ASC
Sql
stringSELECT *, ROW_NUMBER() OVER (ORDER BY distance asc, List_Price desc) + 0 AS RowNumberFROM (SELECT COMPANY = (CASEWHEN (companyid = 'iq_cb_heritage')THEN (1)ELSE (2)END),dbo.fn_LatLongDistance (39.29594039917, -84.243797302246, l.lat, l.lon) AS Distance,'f' AS iswatching,l.image_path AS ImagePath,l.url,'' AS SortOrder,'' AS AgentPublicID,'' AS AgentImagePath,'' AS AgentFirstName,'' AS AgentLastName,'' AS AgentPhone,'' AS AgentCell,'' AS AgentFax,'' AS AgentEmail,'' AS AgentWebsiteAddress,'' AS AgentTeam,'' AS AgentCertification,'' AS AgentLicenseNumber,'' AS AgentBioPath,'' AS AgentHasBlog,'' AS AgentURL,'' AS SecondAgentPublicID,'' AS SecondAgentImagePath,'' AS SecondAgentFirstName,'' AS SecondAgentLastName,'' AS SecondAgentPhone,'' AS SecondAgentCell,'' AS SecondAgentFax,'' AS SecondAgentEmail,'' AS SecondAgentWebsiteAddress,'' AS SecondAgentTeam,'' AS SecondAgentCertification,'' AS SecondAgentLicenseNumber,'' AS SecondAgentBioPath,'' AS SecondAgentHasBlog,'' AS SecondAgentURL,'' AS OfficeID,'' AS OfficeName,'' AS OfficePhone,'' AS OfficeAddress,'' AS OfficeCity,'' AS OfficeState,'' AS OfficeZip,'' AS OfficeDomain,'' AS LogoPath,'' AS LogoPathSmall,'' AS leadpublicid,'' AS AudioTour,PropertyID.PropertyID,'list_price' AS OrderBy,'desc' AS OrderDirection,l.MLSID,l.listingid,l.PropertyType,l.PublicID AS LA_PublicID,l.CompanyID,l.StatusCode,l.Area,l.DisplayAddress,l.DisplayRemarks,l.DisplayCMA,l.Lat,ROUND(l.Lat,5,0) as latitude,l.Lon,ROUND(l.Lon,5,0) as longitude,l.List_Price,l.LO_Name,l.LA_Name,l.ML_Number,l.PublicID,l.SecondPublicID,l.StreetAddress,l.City,l.State,l.Zip_Code,l.County,l.SchoolDistrict,l.ElementarySchool,l.JRHighSchool,l.HighSchool,DATEDIFF ( "D" , DATEFROMPARTS(left(AddDateTime,4), substring(AddDateTime,5, 2), substring(AddDateTime,7, 2)) , getdate() ) AS DaysOnSite,l.ReducedDateTime,l.AddDateTime,l.Prev_List_Price,l.VirtualTourID,l.Images,l.SubType,l.Optional_01,l.Optional_02,l.Optional_03,l.Optional_04,l.Optional_05,l.Optional_06,l.Optional_07,l.Optional_08,l.Optional_09,l.Optional_10,l.Optional_11,l.Optional_12,l.Optional_13,l.Optional_14,l.Optional_15,l.Optional_16,l.Optional_17,l.Optional_18,l.Optional_19,l.Optional_20,l.VideoTour,l.SecondVideoTour,l.MLS_Remarks,l.Description,l.MLS_StatusCode,l.Orig_List_Price,l.SalePrice,l.ListingDateTime,l.DateTime,l.ClosingDateTime,l.ContractDateTime,l.DOM,l.REO,l.ShortSale,l.LO_ID,l.LA_ID,l.BO_ID,l.BA_ID,l.BO_Name,l.BA_Name,l.Image_List,l.DeleteFlag,l.isprivate,'' AS OpenHouseSchedule,'' AS BathsString,l.Baths,l.FullBaths,l.HalfBaths,l.ThreeQuarterBaths,l.Beds,l.Garage,l.Style,l.sq_foot,l.Year_Built,l.Pool,l.Acreage,l.Story,l.Previews,l.Featured,l.CommunityName,l.PropertyView,l.Waterfront,l.Golfcourse,l.Basement,l.Carport,l.PatioSQ_Foot,l.BuildingName,l.UnitFloor,l.HOA,l.HoaDues,l.Zoning,l.sq_foot_Office,l.Units,l.AskingPricePersq_foot,l.SalesTerms,l.SaleType,l.sq_foot_Vacant,l.SuiteNumber,l.SuiteFloor,l.GrossBuildingArea,l.GrossLeaseArea,l.BuildingClass,l.LegalDescription,l.Occupancy,l.TenantOccupancyBasis,l.ConstructionStatus,l.YearRenovated,l.LeedCertification,l.Buildings,l.ParkingType,l.ParkingSpaces,l.PotentialRentalIncome,l.NetOperatingIncome,l.CapRate,l.InternalRateOfReturn,l.CashOnCash,l.PotentialRentalIncomeRemarks,l.NoiRemarks,l.CapRateRemarks,l.LoanBalance,l.InterestRate,l.AmortizationPeriod,l.MaturityDate,l.subarea,l.propertystory,l.propertystorystatus,l.secondpublicid as listingagentsecondpublicid,l.publicid as listingagentpublicid,agents.officeid as listingagentofficeid,agents_teams_members.agentteamid as listingagentteamidFROM Listings l WITH (NOLOCK)LEFT OUTER JOIN PropertyID WITH (NOLOCK)ON PropertyID.MLSID = l.mlsidAND PropertyID.ML_Number = l.ML_NumberAND PropertyID.dbTable IN ('Commercial','MultiFamily','Residential','Land')AND PropertyID.Status = 'A'LEFT OUTER JOIN agents_teams_members WITH (NOLOCK)ON agents_teams_members.publicid = l.publicidand agents_teams_members.publicid in (select publicid from agents_teams where agents_teams.status = 'a')and agents_teams_members.publicid not in (select publicid from agents_teams where agents_teams.status = 'i')LEFT OUTER JOIN agents WITH (NOLOCK)ON agents.publicid = l.publicidWHERE l.id in (0)) dt ORDER BY distance, List_Price desc, ml_number ASC
SQLState
string08S01
StackTrace
stringlucee.runtime.exp.DatabaseException: Connection resetat com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2435)at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1991)at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6310)at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7545)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:465)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:393)at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:301)at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:282)at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:226)at lucee.runtime.tag.Query.executeDatasoure(Query.java:1133)at lucee.runtime.tag.Query._doEndTag(Query.java:693)at lucee.runtime.tag.Query.doEndTag(Query.java:583)at lucee.runtime.functions.query.QueryExecute.call(QueryExecute.java:86)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:265)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725)at iqquery_cfc$cf.udfCall1(/iqquery.cfc:155)at iqquery_cfc$cf.udfCall(/iqquery.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2010)at lucee.runtime.tag.CFTag.cfcEndTag(CFTag.java:569)at lucee.runtime.tag.CFTag.doAfterBody(CFTag.java:207)at components.listings_cfc$cf.udfCall1_000025(/components/listings.cfc:1078)at components.listings_cfc$cf.udfCall1(/components/listings.cfc:770)at components.listings_cfc$cf.udfCall(/components/listings.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197)at components.listing_layout_cfc$cf.udfCall_000029(/components/listing_layout.cfc:1563)at components.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:1445)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197)at components.listing_cfc$cf.udfCall(/components/listing.cfc:106)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:212)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:694)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:2006)at lucee.runtime.tag.Invoke.doComponent(Invoke.java:224)at lucee.runtime.tag.Invoke.doEndTag(Invoke.java:197)at iqweb.app._listing_cfm$cf.call(/production/iqweb/app/_listing.cfm:16)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725)at iqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:248)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:940)at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:830)at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:812)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:809)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725)at lib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39)at lib.iq_cfc$cf.udfCall(/lib/iq.cfc)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993)at lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:756)at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1725)at application_cfc$cf.udfCall(/application.cfc:325)at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:107)at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357)at lucee.runtime.type.UDFImpl.call(UDFImpl.java:226)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:692)at lucee.runtime.ComponentImpl._call(ComponentImpl.java:573)at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1993)at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:438)at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43)at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2480)at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2470)at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2443)at lucee.runtime.engine.Request.exe(Request.java:44)at lucee.runtime.engine.Request.run(Request.java:30)
TagContext
Array
Rows: 13
1
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number265
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:265)
template
string/iqquery.cfc
type
stringcfml
2
Struct
codePrintHTML
string
codePrintPlain
string
column
number0
id
string??
line
number155
Raw_Trace
stringiqquery_cfc$cf.udfCall1(/iqquery.cfc:155)
template
string/iqquery.cfc
type
stringcfml
3
Struct
codePrintHTML
string1076: ml_number ASC<br>1077: <br><b>1078: &lt;/cfiqquery&gt;</b><br>1079: <br>1080: <br>
codePrintPlain
string1076: ml_number ASC1077: 1078: </cfiqquery>1079: 1080:
column
number0
id
string??
line
number1078
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1_000025(/components/listings.cfc:1078)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
4
Struct
codePrintHTML
string768: &lt;cfif arguments.countonly NEQ &quot;f&quot;&gt;<br>769: &lt;cfreturn local.retval&gt;<br><b>770: &lt;/cfif&gt;</b><br>771: <br>772: &lt;cfif arguments.RowLimit NEQ 0 AND local.retVal.TotalRowCount GT arguments.RowLimit&gt;<br>
codePrintPlain
string768: <cfif arguments.countonly NEQ "f">769: <cfreturn local.retval>770: </cfif>771: 772: <cfif arguments.RowLimit NEQ 0 AND local.retVal.TotalRowCount GT arguments.RowLimit>
column
number0
id
string??
line
number770
Raw_Trace
stringcomponents.listings_cfc$cf.udfCall1(/components/listings.cfc:770)
template
stringC:\realistiq\production\iqweb\components\listings.cfc
type
stringcfml
5
Struct
codePrintHTML
string1561: &lt;cfinvokeargument name=&quot;mlnumber_ignorelist&quot; value=&quot;#arguments.rsListings.ml_number#&quot;&gt;<br>1562: &lt;cfinvokeargument name=&quot;impression_from&quot; value=&quot;Nearby Listings&quot;&gt;<br><b>1563: &lt;/cfinvoke&gt;</b><br>1564: &lt;/cfif&gt;<br>1565: <br>
codePrintPlain
string1561: <cfinvokeargument name="mlnumber_ignorelist" value="#arguments.rsListings.ml_number#">1562: <cfinvokeargument name="impression_from" value="Nearby Listings">1563: </cfinvoke>1564: </cfif>1565:
column
number0
id
string??
line
number1563
Raw_Trace
stringcomponents.listing_layout_cfc$cf.udfCall_000029(/components/listing_layout.cfc:1563)
template
stringC:\realistiq\production\iqweb\components\listing_layout.cfc
type
stringcfml
6
Struct
codePrintHTML
string1443: &lt;/td&gt;<br>1444: &lt;/tr&gt;<br><b>1445: &lt;/cfif&gt;</b><br>1446: &lt;/tbody&gt;<br>1447: &lt;/table&gt;<br>
codePrintPlain
string1443: </td>1444: </tr>1445: </cfif>1446: </tbody>1447: </table>
column
number0
id
string??
line
number1445
Raw_Trace
stringcomponents.listing_layout_cfc$cf.udfCall(/components/listing_layout.cfc:1445)
template
stringC:\realistiq\production\iqweb\components\listing_layout.cfc
type
stringcfml
7
Struct
codePrintHTML
string104: &lt;cfinvokeargument name=&quot;rsListings&quot; value=&quot;#retListing.query#&quot;&gt;<br>105: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;#arguments.view_from#&quot;&gt;<br><b>106: &lt;/cfinvoke&gt;</b><br>107: &lt;cfelse&gt;<br>108: &lt;cfinvoke component=&quot;listing_layout&quot; method=&quot;NoRecords&quot; returnvariable=&quot;LOCAL.retLayout&quot;&gt;<br>
codePrintPlain
string104: <cfinvokeargument name="rsListings" value="#retListing.query#">105: <cfinvokeargument name="view_from" value="#arguments.view_from#">106: </cfinvoke>107: <cfelse>108: <cfinvoke component="listing_layout" method="NoRecords" returnvariable="LOCAL.retLayout">
column
number0
id
string??
line
number106
Raw_Trace
stringcomponents.listing_cfc$cf.udfCall(/components/listing.cfc:106)
template
stringC:\realistiq\production\iqweb\components\listing.cfc
type
stringcfml
8
Struct
codePrintHTML
string14: &lt;cfinvokeargument name=&quot;propertytype&quot; value=&quot;#request.propertytype#&quot;&gt;<br>15: &lt;cfinvokeargument name=&quot;view_from&quot; value=&quot;Listing Details Page&quot;&gt;<br><b>16: &lt;/cfinvoke&gt;</b><br>17: <br>18: &lt;!--- this is the a missing or removed MLSID ---&gt;<br>
codePrintPlain
string14: <cfinvokeargument name="propertytype" value="#request.propertytype#">15: <cfinvokeargument name="view_from" value="Listing Details Page">16: </cfinvoke>17: 18: <!--- this is the a missing or removed MLSID --->
column
number0
id
string??
line
number16
Raw_Trace
stringiqweb.app._listing_cfm$cf.call(/production/iqweb/app/_listing.cfm:16)
template
stringC:\realistiq\production\iqweb\app\_listing.cfm
type
stringcfml
9
Struct
codePrintHTML
string80: <br>81: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/app/_#local.PageName#.cfm&quot;)&gt;<br><b>82: &lt;cfinclude template=&quot;#request.AppMapPath#/app/_#local.PageName#.cfm&quot; /&gt;</b><br>83: &lt;cfelse&gt;<br>84: &lt;cfset MissingFile = local.PageName&gt;<br>
codePrintPlain
string80: 81: <cfif FileExists("#request.AppAbsolutePath#/app/_#local.PageName#.cfm")>82: <cfinclude template="#request.AppMapPath#/app/_#local.PageName#.cfm" />83: <cfelse>84: <cfset MissingFile = local.PageName>
column
number0
id
string??
line
number82
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:82)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
10
Struct
codePrintHTML
string246: &lt;/cfif&gt;<br>247: &lt;div class=&quot;#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#&quot;&gt;<br><b>248: #request.iqlib.RenderPage()#</b><br>249: &lt;/div&gt;<br>250: &lt;/div&gt;<br>
codePrintPlain
string246: </cfif>247: <div class="#request.page eq 'listings' or request.page eq 'rentals' or request.page eq 'house-value' ? 'container-fluid' : 'container'#">248: #request.iqlib.RenderPage()#249: </div>250: </div>
column
number0
id
string??
line
number248
Raw_Trace
stringiqweb.sitetemplates._24.layouts._site_cfm$cf.call(/production/iqweb/sitetemplates/24/layouts/_site.cfm:248)
template
stringC:\realistiq\production\iqweb\sitetemplates\24\layouts\_site.cfm
type
stringcfml
11
Struct
codePrintHTML
string57: &lt;cfelse&gt;<br>58: &lt;cfif FileExists(&quot;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot;)&gt;<br><b>59: &lt;cfinclude template=&quot;#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&quot; /&gt;</b><br>60: &lt;cfelse&gt;<br>61: &lt;strong&gt;File Not Found.&lt;/strong&gt;&lt;br&gt;The file &amp;quot;&lt;em&gt;#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm&lt;/em&gt;&amp;quot; could not be found.<br>
codePrintPlain
string57: <cfelse>58: <cfif FileExists("#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm")>59: <cfinclude template="#request.AppMapPath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm" />60: <cfelse>61: <strong>File Not Found.</strong><br>The file &quot;<em>#request.AppAbsolutePath#/sitetemplates/#request.domain.TemplateName#/layouts/_#local.Layout#.cfm</em>&quot; could not be found.
column
number0
id
string??
line
number59
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:59)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
12
Struct
codePrintHTML
string37: &lt;/cfif&gt;<br>38: &lt;cfscript&gt;<br><b>39: doLayout();</b><br>40: &lt;/cfscript&gt;<br>41: &lt;/cfif&gt;<br>
codePrintPlain
string37: </cfif>38: <cfscript>39: doLayout();40: </cfscript>41: </cfif>
column
number0
id
string??
line
number39
Raw_Trace
stringlib.iq_cfc$cf.udfCall1(/lib/iq.cfc:39)
template
stringC:\realistiq\production\iqweb\lib\iq.cfc
type
stringcfml
13
Struct
codePrintHTML
string323: &lt;cfset local.url = new lib.url() /&gt;<br>324: &lt;cfset local.url.process(CGI.path_info) /&gt;<br><b>325: &lt;cfoutput&gt;#request.iqlib.RenderContent()#&lt;/cfoutput&gt;</b><br>326: &lt;/cfif&gt;<br>327: &lt;/cfif&gt;<br>
codePrintPlain
string323: <cfset local.url = new lib.url() />324: <cfset local.url.process(CGI.path_info) />325: <cfoutput>#request.iqlib.RenderContent()#</cfoutput>326: </cfif>327: </cfif>
column
number0
id
string??
line
number325
Raw_Trace
stringapplication_cfc$cf.udfCall(/application.cfc:325)
template
stringC:\realistiq\production\iqweb\application.cfc
type
stringcfml
type
stringdatabase
where
string
Listing Updated: 11/13/2019
MLS Number: 1637098
Listing Provided By:
Avery Perleberg  of  Whites Realty
MLS Internet Data Exchange (IDX) information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS of Greater Cincinnati.