SMC ResultADORecordSet_mysqli Object ( [databaseType] => mysqli [canSeek] => 1 [dataProvider] => native [fields] => [blobSize] => 100 [sql] => SELECT DISTINCT property.* FROM property WHERE status = 'A-Active' AND syracusesubboardcode = 'Rochester' AND listofficemlsid = 'KEEN' AND (propertytype = 'Single Family Residential') LIMIT 0,9 [EOF] => 1 [emptyTimeStamp] =>   [emptyDate] =>   [debug] => [timeCreated] => 0 [bind] => [fetchMode] => 3 [connection] => ADODB_mysqli Object ( [databaseType] => mysqli [dataProvider] => mysql [hasInsertID] => 1 [hasAffectedRows] => 1 [metaTablesSQL] => SELECT TABLE_NAME, CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= [metaColumnsSQL] => SHOW COLUMNS FROM `%s` [fmtTimeStamp] => 'Y-m-d H:i:s' [hasLimit] => 1 [hasMoveFirst] => 1 [hasGenID] => 1 [isoDates] => 1 [sysDate] => CURDATE() [sysTimeStamp] => NOW() [hasTransactions] => 1 [forceNewConnect] => [poorAffectedRows] => 1 [clientFlags] => 0 [substr] => substring [port] => [socket] => [_bindInputArray] => [nameQuote] => ` [optionFlags] => Array ( [0] => Array ( [0] => 5 [1] => 0 ) ) [arrayClass] => ADORecordSet_array_mysqli [multiQuery] => [_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1); [_genSeqSQL] => create table %s (id int not null) [_genSeqCountSQL] => select count(*) from %s [_genSeq2SQL] => insert into %s values (%s) [_dropSeqSQL] => drop table %s [database] => markmalc_wrdp [host] => 198.143.153.106 [user] => markmalc_wpadmin [password] => not stored [debug] => [maxblobsize] => 262144 [concat_operator] => + [length] => length [random] => rand() [upperCase] => upper [fmtDate] => 'Y-m-d' [true] => 1 [false] => 0 [replaceQuote] => \' [charSet] => [metaDatabasesSQL] => [uniqueOrderBy] => [emptyDate] =>   [emptyTimeStamp] =>   [lastInsID] => [hasTop] => [readOnly] => [genID] => 0 [raiseErrorFn] => [cacheSecs] => 3600 [memCache] => [memCacheHost] => [memCachePort] => 11211 [memCacheCompress] => [sysUTimeStamp] => [noNullStrings] => [numCacheHits] => 0 [numCacheMisses] => 0 [pageExecuteCountRows] => 1 [uniqueSort] => [leftOuter] => [rightOuter] => [ansiOuter] => [autoRollback] => [fnExecute] => [fnCacheExecute] => [blobEncodeType] => [rsPrefix] => ADORecordSet_ [autoCommit] => 1 [transOff] => 0 [transCnt] => 0 [fetchMode] => [null2null] => null [bulkBind] => [_oldRaiseFn] => [_transOK] => [_connectionID] => mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0 [error] => [error_list] => Array ( ) [field_count] => 322 [host_info] => 198.143.153.106 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.7.44-log [server_version] => 50744 [stat] => Uptime: 3529512 Threads: 3 Questions: 1519634889 Slow queries: 0 Opens: 14424773 Flush tables: 1 Open tables: 10240 Queries per second avg: 430.550 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 8589199 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 0 [field_count] => 322 [lengths] => [num_rows] => 0 [type] => 0 ) [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => markmalc_wrdp ) [_numOfRows] => 0 [_numOfFields] => 322 [_queryID] => mysqli_result Object ( [current_field] => 0 [field_count] => 322 [lengths] => [num_rows] => 0 [type] => 0 ) [_currentRow] => -1 [_closed] => [_inited] => 1 [_obj] => [_names] => [_currentPage] => -1 [_atFirstPage] => [_atLastPage] => [_lastPageNo] => -1 [_maxRecordCount] => 0 [datetime] => [adodbFetchMode] => 0 )

The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of the Genesee Region Real Estate Information Service (GENRIS). Real estate listings held by firms are marked with the Powered by Homesteadnet.com/REALTOR® logo and detailed information about them includes the Listing Broker's Firm Name).