a:2:{i:0;a:2:{s:6:"schema";O:18:"yii\db\TableSchema":7:{s:10:"schemaName";s:6:"public";s:4:"name";s:6:"houses";s:8:"fullName";s:6:"houses";s:10:"primaryKey";a:1:{i:0;s:2:"ID";}s:12:"sequenceName";s:15:""houses_ID_seq"";s:11:"foreignKeys";a:1:{s:22:"houses_site_index_fkey";a:2:{i:0;s:5:"sites";s:10:"site_index";s:2:"id";}}s:7:"columns";a:80:{s:2:"ID";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";s:15:""houses_ID_seq"";s:4:"name";s:2:"ID";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:4:"int4";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";i:32;s:5:"scale";i:0;s:12:"isPrimaryKey";b:1;s:13:"autoIncrement";b:1;s:8:"unsigned";b:0;s:7:"comment";N;}s:5:"valid";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"valid";s:9:"allowNull";b:1;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:4:"int4";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";i:32;s:5:"scale";i:0;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:27:"At the moment it is unknown";}s:10:"site_index";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"site_index";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:4:"int4";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";i:32;s:5:"scale";i:0;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:50:"Id of data source (site with property information)";}s:11:"property_id";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"property_id";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:28:"Property ID from data source";}s:5:"MLSID";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"MLSID";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"Unique ID in US data bases";}s:5:"REOID";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"REOID";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:26:"Unique ID in US data bases";}s:9:"image_url";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:9:"image_url";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Unknown image";}s:14:"image_url_orig";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:14:"image_url_orig";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:17:"Unknown image url";}s:11:"image_thumb";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"image_thumb";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:19:"Unknown image thumb";}s:11:"status_type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"status_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:68:"Type of real estate representative. E.g Foreclosure, Short Sale, etc";}s:11:"market_type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"market_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:45:"Type of sale. E.g Coming Soon, Available, etc";}s:11:"sale_status";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"sale_status";s:9:"allowNull";b:0;s:4:"type";s:7:"integer";s:7:"phpType";s:7:"integer";s:6:"dbType";s:4:"int4";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";i:32;s:5:"scale";i:0;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:62:"1 and 0 if on sale, else sold. diff between 0 and 1 is unknown";}s:6:"status";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:6:"status";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"For rent or for sale";}s:4:"type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:4:"type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:56:"Type of house. E.g Single Family, Condo, Townhouse, etc.";}s:7:"address";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:7:"address";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:18:"Full house address";}s:7:"country";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:7:"country";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:3:"USA";}s:6:"county";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:6:"county";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"County in US";}s:4:"city";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:4:"city";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"House city";}s:5:"state";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"state";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"House state";}s:12:"parsed_state";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:12:"parsed_state";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Same as state";}s:3:"zip";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:3:"zip";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"US zip code";}s:16:"full_address_md5";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:16:"full_address_md5";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"US zip code";}s:3:"url";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:3:"url";s:9:"allowNull";b:0;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Unknown image";}s:7:"url_md5";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:7:"url_md5";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Unknown image";}s:5:"agent";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"agent";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"Agent name";}s:5:"price";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"price";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:5:"Price";}s:14:"brokerage_firm";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:14:"brokerage_firm";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"Brokerage firm";}s:17:"brokerage_address";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:17:"brokerage_address";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:17:"Brokerage address";}s:14:"brokerage_city";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:14:"brokerage_city";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"Brokerage city";}s:15:"brokerage_state";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:15:"brokerage_state";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Brokerage state";}s:13:"brokerage_zip";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:13:"brokerage_zip";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Brokerage zip";}s:15:"brokerage_phone";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:15:"brokerage_phone";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Brokerage phone";}s:15:"brokerage_email";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:15:"brokerage_email";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Brokerage email";}s:5:"phone";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"phone";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"Agent phone";}s:5:"email";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"email";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"Agent email";}s:12:"created_date";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:12:"created_date";s:9:"allowNull";b:1;s:4:"type";s:9:"timestamp";s:7:"phpType";s:6:"string";s:6:"dbType";s:9:"timestamp";s:12:"defaultValue";s:14:"timezone('utc'";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:28:"First time of receiving data";}s:10:"last_check";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"last_check";s:9:"allowNull";b:1;s:4:"type";s:9:"timestamp";s:7:"phpType";s:6:"string";s:6:"dbType";s:9:"timestamp";s:12:"defaultValue";s:14:"timezone('utc'";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Last check time";}s:11:"last_update";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"last_update";s:9:"allowNull";b:1;s:4:"type";s:9:"timestamp";s:7:"phpType";s:6:"string";s:6:"dbType";s:9:"timestamp";s:12:"defaultValue";s:14:"timezone('utc'";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"Last update time";}s:15:"additional_info";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:15:"additional_info";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"Additional information";}s:8:"bedrooms";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"bedrooms";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:18:"Number of bedrooms";}s:9:"bathrooms";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:9:"bathrooms";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:19:"Number of bathrooms";}s:7:"stories";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:7:"stories";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"Number of floors";}s:6:"sleeps";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:6:"sleeps";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:14:"Number of beds";}s:4:"area";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:4:"area";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:28:"Total area in sq ft or acres";}s:11:"living_area";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"living_area";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:29:"Living area in sq ft or acres";}s:7:"garages";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:7:"garages";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:30:"Number of cars and garage type";}s:14:"parking_spaces";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:14:"parking_spaces";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:24:"Number of parking spaces";}s:17:"construction_year";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:17:"construction_year";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:17:"Construction year";}s:5:"patio";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"patio";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:17:"True if has patio";}s:13:"swimming_pool";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:13:"swimming_pool";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:18:"Yes, No, - or Null";}s:8:"basement";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"basement";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"True if has basement";}s:10:"fire_place";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"fire_place";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"True if has backyard";}s:10:"back_yeard";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"back_yeard";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:20:"True if has backyard";}s:6:"floors";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:6:"floors";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:16:"Number of floors";}s:8:"flooring";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"flooring";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Flooring type";}s:12:"heating_type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:12:"heating_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Type of heating";}s:10:"sewer_type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"sewer_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:13:"Type of sewer";}s:4:"roof";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:4:"roof";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:9:"Roof type";}s:5:"rooms";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"rooms";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"Number of rooms";}s:6:"source";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:6:"source";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"Source name";}s:8:"true_zip";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"true_zip";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"US zip code";}s:10:"true_state";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"true_state";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"House state";}s:15:"true_state_name";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:15:"true_state_name";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:11:"House state";}s:9:"true_city";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:9:"true_city";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:10:"House city";}s:11:"true_county";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:11:"true_county";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:12:"County in US";}s:12:"auction_open";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:12:"auction_open";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:21:"Time of auction close";}s:13:"auction_close";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:13:"auction_close";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:21:"Time of auction close";}s:9:"utilities";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:9:"utilities";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:49:"String with list of utilities. E.g 'Gas,Electric'";}s:4:"pool";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:4:"pool";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:33:"True if has pool, None if no info";}s:8:"lot_size";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"lot_size";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"House style if exists ";}s:5:"style";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:5:"style";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:22:"House style if exists ";}s:3:"hoa";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:3:"hoa";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:15:"True if has HOA";}s:8:"hoa_fees";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"hoa_fees";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:31:"String with price in $. E.g $25";}s:8:"exterior";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"exterior";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:46:"String with exterior. E.g. 'Deck, Front Porch'";}s:3:"air";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:3:"air";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:37:"E.g. 'Ceiling Fans, Central Electric'";}s:10:"appliances";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"appliances";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";N;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";s:60:"String with appliances. E.g. 'Dishwasher, Elec Ovn/Rng/Ctop'";}s:8:"use_type";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:8:"use_type";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";s:0:"";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";N;}s:12:"construction";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:12:"construction";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";s:0:"";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";N;}s:10:"sale_terms";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:10:"sale_terms";s:9:"allowNull";b:1;s:4:"type";s:6:"string";s:7:"phpType";s:6:"string";s:6:"dbType";s:7:"varchar";s:12:"defaultValue";s:0:"";s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";N;}s:13:"is_commercial";O:25:"yii\db\pgsql\ColumnSchema":19:{s:9:"dimension";i:0;s:18:"disableJsonSupport";b:0;s:19:"disableArraySupport";b:0;s:39:"deserializeArrayColumnToArrayExpression";b:1;s:12:"sequenceName";N;s:4:"name";s:13:"is_commercial";s:9:"allowNull";b:0;s:4:"type";s:7:"boolean";s:7:"phpType";s:7:"boolean";s:6:"dbType";s:4:"bool";s:12:"defaultValue";b:0;s:10:"enumValues";N;s:4:"size";N;s:9:"precision";N;s:5:"scale";N;s:12:"isPrimaryKey";b:0;s:13:"autoIncrement";b:0;s:8:"unsigned";b:0;s:7:"comment";N;}}}s:12:"cacheVersion";i:1;}i:1;O:25:"yii\caching\TagDependency":3:{s:4:"tags";s:32:"14fbfd084d36c23e89a96dca0f1fa28c";s:4:"data";a:1:{s:32:"75b60657ab9046c8b43a06cb9239333f";s:21:"0.99510400 1766271001";}s:8:"reusable";b:0;}}