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] => localhost [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] => 36 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 8.0.41 [server_version] => 80041 [stat] => Uptime: 785434 Threads: 6 Questions: 520478012 Slow queries: 41118 Opens: 2627274 Flush tables: 3 Open tables: 10240 Queries per second avg: 662.662 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 5475596 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 0 [field_count] => 36 [lengths] => [num_rows] => 0 [type] => 0 ) [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [databaseName] => markmalc_wrdp ) [_numOfRows] => 0 [_numOfFields] => 36 [_queryID] => mysqli_result Object ( [current_field] => 0 [field_count] => 36 [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).