Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:41:12.157' ,`MLSNumber` = '28357784' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.817891' ,`Longitude` = '-95.111894' ,`PhotoCount` = '7' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '79500.00' ,`Status` = 'Active' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '612' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is being sold \"As Is\", public utilities are available. All Dimensions must be verified. Home is on a large, fenced in lot.\r\n\r\nProperty is currently occupied by tenant. PLEASE DO NOT DISTURB THE TENANTS. This property is part of a group of homes that are being sold \"As Is\". Investment Opportunity.' ,`Acres` = '0.5372' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 91, 92 & 93 SERIAL# ALFRD2431985 H' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 4' ,`TaxAmount` = '810' ,`TaxRate` = '2.1464' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794352' WHERE `Matrix_Unique_ID` = '201127071' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:23:32.727' ,`MLSNumber` = '54171727' ,`ListAgentFullName` = 'Norma Smalley' ,`ListOfficeName` = 'Cobb Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472938' ,`Longitude` = '-94.590651' ,`PhotoCount` = '48' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '835000.00' ,`Status` = 'Active' ,`StreetName` = 'Carioca' ,`StreetNumber` = '3017' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This luxurious beach home isn\'t the average home! This open concept, resort-style home is perfect for entertaining inside or outside on the 1140 sq ft wrap-around deck. Upon entering, you\'ll immediately notice how meticulously this home has been maintained. The bright gourmet kitchen boasts granite counters, stainless steel appliances (including a s/s farmhouse sink), and plenty of cabinets. The master suite features a king bed, & master bath offers double sinks, granite counters, a large tiled shower w/ a window, and a walk-in closet. Three other bedrooms share two full baths. This gorgeous Crystal Beach getaway is accessible to the beach with just a short stroll to a private neighborhood walkover. This lovely oasis features all of the essentials expected of a luxury retreat, including amazing rental history. All furniture, decor, appliances, bedding/bath linens stay. Please verify room dimensions, HOA, taxes & insurance. Located on a cul-de-sac street, this home will not disappoint.' ,`Acres` = '0.202' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 10 BLK 2 COPACABANA BY THE SEA' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Copacabana By The Sea' ,`TaxAmount` = '7080' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794352' WHERE `Matrix_Unique_ID` = '206331237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:24:19.353' ,`MLSNumber` = '83023978' ,`ListAgentFullName` = 'Terri Mund' ,`ListOfficeName` = 'Hudgins-Groover Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.320216' ,`Longitude` = '-96.073117' ,`PhotoCount` = '49' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Bolling Green' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Circle' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2238' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'With your renovations this custom 2,200+ sq. ft. home could become your dream Home. This 3-bedroom, 2-bath home offers waterfront access in the highly desired neighborhood of Lake Nett. This home has so much potential! Home features a breakfast area, formal dining area, game room, in-home laundry area, screened in porch, tons of storage, and a huge lot on the water for your delight! New HVAC. Though this home is being sold AS IS, with your TLC it could be your forever home!! Schedule your private tour today!!' ,`Acres` = '0.6838' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE NETT LOT 28A,37A-1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '29786' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Nett' ,`TaxAmount` = '5096' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '207443256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:36:49.487' ,`MLSNumber` = '30818744' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.818414' ,`Longitude` = '-95.121207' ,`PhotoCount` = '14' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '117000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 356' ,`StreetNumber` = '666' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located on FM 356, Could also be commercial property. Property is OCCUPIED. \r\nPLEASE DO NOT DISTURB THE TENANTS. This property is part of a group of homes that are being sold \"As Is\". Investment Opportunity. Dimensions to be verified.\r\nHome is on the tax roll as 666 FM 356, it is marked as 658 FM 356' ,`Acres` = '0.2242' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 14 & 15 PT' ,`LotDesciption` = 'Other' ,`LotSize` = '9768' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '1136' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208140104' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:47:36.990' ,`MLSNumber` = '31412492' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821114' ,`Longitude` = '-95.118145' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly' ,`StreetNumber` = '286' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is located in Onalaska. Dimensions will need to be verified. This home is currently occupied, PLEASE DO NOT DISTURB THE TENANT. The property is included in a portfolio listing. Home is being sold \"As Is\". \r\nPer Seller, Mobile Home is 16 x 75. Year of home to be verified.' ,`Acres` = '0.3373' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 414' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14692' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '88' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208575671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:49:44.643' ,`MLSNumber` = '75030732' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.692519' ,`Longitude` = '-94.928257' ,`PhotoCount` = '14' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '54999.00' ,`Status` = 'Active' ,`StreetName` = 'Liberty' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is being sold \"As Is\". It is part of a group of homes that are being sold. PLEASE DO NOT DISTURB THE TENANTS. Property is currently occupied. All dimensions must be verified. Investment Opportunity.' ,`Acres` = '0.1768' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PINECREST BLK 3 LOT 7' ,`LotDesciption` = 'Other' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pinecrest' ,`TaxAmount` = '735' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208576157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:42:52.823' ,`MLSNumber` = '44082244' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.823580' ,`Longitude` = '-95.113915' ,`PhotoCount` = '26' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '74500.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '720' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is Occupied, please do not disturb tenants. Verify Dimensions. Home is on a corner lot. Washer and Dryer connections are located on the lower level.' ,`Acres` = '0.185' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Other Heating,Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 1 LOT 154' ,`LotDesciption` = 'Other' ,`LotSize` = '8060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 1' ,`TaxAmount` = '1437' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208576549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:40:16.310' ,`MLSNumber` = '57381480' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.818198' ,`Longitude` = '-95.119246' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '94000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '165' ,`StreetSuffix` = 'Park' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is currently occupied by tenant. Please do not disturb tenant. All dimensions will need to be verified. Investment Opportunity.' ,`Acres` = '0.3581' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 251 & 252 SERIAL# AILA770772143537' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 2' ,`TaxAmount` = '959' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208584017' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:39:29.620' ,`MLSNumber` = '47760832' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.814525' ,`Longitude` = '-95.112326' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located in Canyon Park Subdivision. This home sits on two lots. Property is OCCUPIED. PLEASE DO NOT DISTURB THE TENANTS. This property is part of a group of homes that are being sold \"AS IS\". Investment Opportunity. Dimensions to be verified.' ,`Acres` = '0.3582' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 390' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park Sec 4' ,`TaxAmount` = '88' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794353' WHERE `Matrix_Unique_ID` = '208935273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:05:27.540' ,`MLSNumber` = '10905020' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Christian Luis' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.814806' ,`Longitude` = '-95.322704' ,`PhotoCount` = '22' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '230000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wipprecht' ,`StreetNumber` = '6103' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two properties for the price of one. Looking for home ownership with an opportunity to generate passive income? Just inside 610 loop, minutes from downtown Houston. Home is being sold as is, along with an adjoining vacant lot. Go to MLS # 79149425 for details about the lot! That\'s right, two properties for one price. The home is liveable and could be updated at leisure. Roof is 5 years old. AC unit is being serviced. Homes boasts over 1835 square feet, large kitchen, family and den. The vacant lot once had a garage/apartment which has now been demolished, creating the opportunity to build a new home. \r\n\r\n\r\nNo HOA Dues, No Mud Taxes. Opportunity and options are present for home ownership or investment opportunity. This community is up and coming whereby gentrification is underway. Many homes have been rennovated and there are more than several new builds. Book your showing, bring your offers and make your investment in this opportunity go to work for you.' ,`Acres` = '0.2066' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1411A BLK 58 KASHMERE GARDENS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '4178' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '209521851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:32:45.593' ,`MLSNumber` = '72081471' ,`ListAgentFullName` = 'Lori Balusek' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777050' ,`Longitude` = '-96.159871' ,`PhotoCount` = '15' ,`PostalCode` = '77474' ,`RoomCount` = '3' ,`ListPrice` = '264000.00' ,`Status` = 'Active' ,`StreetName` = '6th' ,`StreetNumber` = '516' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1600 square foot, 3 bedroom 2 bath home is a MUST SEE! Right in the heart of Sealy and close to the city park.! TOTALLY REMODELED! New A/C with warranty, roof is only a couple of years old but like new. All new light fixtures, bathroom fixtures, has a fireplace with new brick German Schmear that you just have to see! New hot water heater, all new showers, granite countertops, a new island has been added in the kitchen. All new appliances. New back deck and fenced back yard. This one is a must see!!! Room sizes are approximate.' ,`Acres` = '0.241' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SEALY TOWNSITE BLOCK 55 LOT 5 REAL PROPERTY LABEL # TEX05257' ,`LotDesciption` = 'Other' ,`LotSize` = '10498' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SELMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sealy Townsite' ,`TaxAmount` = '1476' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '209852965' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:27:41.897' ,`MLSNumber` = '26121050' ,`ListAgentFullName` = 'Jarad Mollon' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851383' ,`Longitude` = '-95.817590' ,`PhotoCount` = '22' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Marisol cove dr' ,`StreetNumber` = '5310' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'It\'s on a lake! Built in December 2021, this Beazer home is one you don\'t want to miss! The rod-iron fence provides a nice view from the back covered patio. Passing the porch and landscaped maintained by a sprinkler system, you will enter the home on 12\" wood tile floors that leads into the kitchen with quartz countertops which opens to high ceilings in the family room. A newer home with oversized rooms and a mother in law suite. Walk-in pantry, walk-in laundry and more! Come check it out, before its too late!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 MARISOL SEC 2' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '209985174' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:32:15.800' ,`MLSNumber` = '70287985' ,`ListAgentFullName` = 'Kristi Henry' ,`ListOfficeName` = 'Galveston Vacation Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535745' ,`Longitude` = '-95.170485' ,`PhotoCount` = '5' ,`PostalCode` = '77546' ,`RoomCount` = '7' ,`ListPrice` = '326000.00' ,`Status` = 'Active' ,`StreetName` = 'Raven Falls' ,`StreetNumber` = '2618' ,`StreetSuffix` = 'Lane' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Just what you\'ve been waiting for! Fall in love with the open floor plan of this 3 bedroom, 2 bath home, nestled away in the quiet subdivision of Heritage Park Village. Centrally located close to I 45 access makes commuting very convenient! You are always just minutes away from restaurants, shopping, malls, medical centers and much more! Everything at your fingertips! Zoned to some of the most highly sought after and top rated schools in the Clear Creek district. Home has just been recently refreshed with interior paint throughout along with several updates and custom upgrades! This home won\'t last long! It\'s waiting for you to come add your personal touch and make it your own. Call today for details! Don\'t miss another opportunity!' ,`Acres` = '0.151' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 HERITAGE PARK SEC 25' ,`LotDesciption` = 'Cleared,Cul-De-Sac' ,`LotSize` = '6578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GREENE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Heritage Park Sec 25' ,`TaxAmount` = '5064' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '210328070' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:54:34.547' ,`MLSNumber` = '97118952' ,`ListAgentFullName` = 'Seth Halstead' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838792' ,`Longitude` = '-94.835679' ,`PhotoCount` = '44' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowlands' ,`StreetNumber` = '14402' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2586' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to \"The Hill\"! Home built in 2016 and barely lived in. House has 5 Bedrooms with the master down, and another bedroom on the opposite side of the home. All of the other bedrooms are upstairs. The home features an open concept complete with everything that you could want. The backyard oasis features a pool built in 2017! Don\'t let this one slip away! Home is in Barbers Hill ISD and has convenient access to I-10 and the newly complete Grand Parkway! Washer/Dryer and refrigerator all stay!' ,`Acres` = '0.233' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 5 BK 10 LAKES OF CHAMPIONS EST SEC 2B PHASE 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10149' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '402' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes Of Champions' ,`TaxAmount` = '7263' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '210754475' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:42:13.260' ,`MLSNumber` = '50189670' ,`ListAgentFullName` = 'Daniela Antelo' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848441' ,`Longitude` = '-95.430808' ,`PhotoCount` = '24' ,`PostalCode` = '77091' ,`RoomCount` = '2' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '1206' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '872' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PROPERTY IS BEING SOLD AT LOT VALUE - STRUCTURE ON PROPERTY IS UNINHABITABLE. Structure is sold as-is, where-is. No repairs. Great for investors, builders and developers looking for prime real estate in NW Houston. Lot is in an opportunity zone!!! LTS 7 & 8 BLK 17 HIGHLAND HEIGHTS ANNEX SEC 3; HCAD account numbers for the respective lots are 0570910000007 and 0570910000092. 2 lots @ 43,561 sqft. = 87,122 sf.' ,`Acres` = '2' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 17 HIGHLAND HEIGHTS ANNEX SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '87122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Highland Heights Anx 3' ,`TaxAmount` = '5513' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794354' WHERE `Matrix_Unique_ID` = '211081499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:32:28.590' ,`MLSNumber` = '77275407' ,`ListAgentFullName` = 'Grant Threatt' ,`ListOfficeName` = 'Beebe Real Estate, LLC' ,`SellingAgentFullName` = 'Sean Martucci' ,`SellingOfficeName` = 'Irie Properties, LLC' ,`Latitude` = '29.692320' ,`Longitude` = '-95.292185' ,`PhotoCount` = '28' ,`PostalCode` = '77087' ,`RoomCount` = '3' ,`ListPrice` = '179999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Thurow' ,`StreetNumber` = '7535' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner home offered for sale in established, Greenway subdivision. Close to city districts, airports, hospitals, shopping, and more. Situated just outside the 610 Loop, this home is minutes from the Gulfgate Center and the Astrodome. The property has tremendous potential for a new owner and includes a 12x20 workshop with power, water, and sewer. Property boasts a beautiful lawn, thoughtful paths, deck, and landscaping. It is ready for your touches to make this gem uniquely yours. All dimensions should be verified.' ,`Acres` = '0.1599' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Probate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 14 GREENWAY SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GOLFCREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenway' ,`TaxAmount` = '2371' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '211379686' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:15:57.100' ,`MLSNumber` = '73565523' ,`ListAgentFullName` = 'Andrea Grimm' ,`ListOfficeName` = 'AgentInc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890293' ,`Longitude` = '-95.560117' ,`PhotoCount` = '39' ,`PostalCode` = '77040' ,`RoomCount` = '8' ,`ListPrice` = '1500000.00' ,`Status` = 'Active' ,`StreetName` = 'Tahoe' ,`StreetNumber` = '15805' ,`StreetSuffix` = 'Drive' ,`City` = 'Jersey Village' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5057' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Original owner has taken excellent care of this home and has added lots of upgrades throughout the home to include a tandem detached garage, with office. This separate garage built exclusively for car collection and business. From the spacious living area inside this well appointed luxurious home, the floor to above the ceiling, features a fully opening up design to your own private oasis in back, where you can enjoy the full seclusion of this retreat, also accessible from the ensuite. Home is to reflect the new current updates, add ons and (per seller) the actual square footage of home and land attached in documents.' ,`Acres` = '1.9173' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 42 JERSEY VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '83517' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range,Grill' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'POST ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jersey Village' ,`TaxAmount` = '15420' ,`TaxRate` = '2.7758' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '211412775' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:25:08.603' ,`MLSNumber` = '3257757' ,`ListAgentFullName` = 'Marnie Wyatt' ,`ListOfficeName` = 'Wyatt Realty Group, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.542847' ,`Longitude` = '-95.366209' ,`PhotoCount` = '23' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Senova Dr' ,`StreetNumber` = '3427' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3346' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*Brand New Roof 9/16/22.\r\nStunning home located in Pearland with quick access to Downtown Houston and other convenient places. When you first walk in you will notice the stunning staircase that boasts elegance. High ceilings and an open concept make this home ideal for entertaining. While walking through the home, you will notice the amazing views of the backyard/pool area through the Kitchen, Living Room, upstairs walkway and the Primary Bedroom.\r\n There is an amazing amount of natural light and a great floorplan that allows everyone to have their own space.\r\nZoned to highly rated schools is just a bonus for this beautiful home.\r\nOutside of the home there is access to parks throughout the subdivision, along with a tennis court and an amazing golf course. Grocery stores and other shopping/eating options are literally minutes away,\r\nSchedule your personal tour today! Per Seller a new roof will be placed asap.' ,`Acres` = '0.2435' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CAMBRIDGE COVE AT SILVERLAKE SEC 1 (A0548-A0721) BLK 1 LOT 2' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '10607' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '685' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cambridge Cove At Silverlake S' ,`TaxAmount` = '9389' ,`TaxRate` = '2.3537' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '211707120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:47:04.637' ,`MLSNumber` = '92802770' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.834396' ,`Longitude` = '-95.101746' ,`PhotoCount` = '11' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '66900.00' ,`Status` = 'Active' ,`StreetName` = 'Cottonwood' ,`StreetNumber` = '117' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'All dimensions to be verified. Large lot located in a community. Home is part of an estate sale.' ,`Acres` = '0.3223' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'YAUPON COVE MOBILE HOME SECTION 6 LOT 28 & 29 SERIAL# TI0018' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Yaupon Cove Mobile Home' ,`TaxAmount` = '947' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '211955364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:54:04.707' ,`MLSNumber` = '62158212' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.749266' ,`Longitude` = '-95.050437' ,`PhotoCount` = '8' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '30000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '193' ,`StreetSuffix` = 'Ridge' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Trailers will be removed from the property. Currently occupied. All dimensions should be verified.' ,`Acres` = '0.3547' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR RIDGE SECTION 1 LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Ridge Sec 1' ,`TaxAmount` = '59' ,`TaxRate` = '1.9558' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '212027109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:45:25.780' ,`MLSNumber` = '24567026' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.825204' ,`Longitude` = '-95.121822' ,`PhotoCount` = '9' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Tree Harbor' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home recently vacated.' ,`Acres` = '0.1548' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PINE HARBOR SECTION 2 BLK 12 LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6745' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pine Harbor' ,`TaxAmount` = '48' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '200' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794355' WHERE `Matrix_Unique_ID` = '212084678' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:38:22.463' ,`MLSNumber` = '77168724' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.816122' ,`Longitude` = '-95.115787' ,`PhotoCount` = '7' ,`PostalCode` = '77360' ,`RoomCount` = '1' ,`ListPrice` = '108000.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Large corner lot in subdivision.' ,`Acres` = '0.3806' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 351 & 352' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16579' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '1351' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212087254' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:43:35.847' ,`MLSNumber` = '75967685' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.820513' ,`Longitude` = '-95.111971' ,`PhotoCount` = '41' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '70000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Oak' ,`StreetNumber` = '149' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is vacant. Located on a large lot.' ,`Acres` = '0.2316' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 182' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '166' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212087390' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:44:44.237' ,`MLSNumber` = '16211275' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.815836' ,`Longitude` = '-95.115095' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Seminole' ,`StreetNumber` = '161' ,`StreetSuffix` = 'Circle' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.1791' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 309 SERIAL# K2301837 HUD# TXS05467' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '389' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212087805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:48:19.997' ,`MLSNumber` = '36524709' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.819064' ,`Longitude` = '-95.117488' ,`PhotoCount` = '33' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '59999.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '270' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is part of an estate.' ,`Acres` = '0.3581' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 328 & 329 SERIAL# A508 HUD# TXS057' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '371' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212088778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:46:08.663' ,`MLSNumber` = '63687400' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821214' ,`Longitude` = '-95.112358' ,`PhotoCount` = '8' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '69900.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.2107' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 162 SERIAL# 1380662172 HUD# TEX004' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '319' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212088885' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:51:09.973' ,`MLSNumber` = '14424104' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.824407' ,`Longitude` = '-95.115859' ,`PhotoCount` = '12' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '47000.00' ,`Status` = 'Active' ,`StreetName` = 'Canyon' ,`StreetNumber` = '453' ,`StreetSuffix` = 'Drive' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.3361' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 1 LOT 125, 126 & 127 SERIAL# 12535653 HU' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '1126' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794356' WHERE `Matrix_Unique_ID` = '212098507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:52:40.297' ,`MLSNumber` = '30119779' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.819098' ,`Longitude` = '-95.112074' ,`PhotoCount` = '7' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '42300.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '593' ,`StreetSuffix` = 'Park' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.3581' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 289 & 290 SERIAL# 70144394AL HUD#' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '378' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212098697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:49:00.497' ,`MLSNumber` = '39181281' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.817181' ,`Longitude` = '-95.111196' ,`PhotoCount` = '14' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '59500.00' ,`Status` = 'Active' ,`StreetName` = 'Sequoia' ,`StreetNumber` = '614' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.1791' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 200' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '128' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212098731' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:53:17.470' ,`MLSNumber` = '39440182' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.820299' ,`Longitude` = '-95.120216' ,`PhotoCount` = '12' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '42300.00' ,`Status` = 'Active' ,`StreetName` = 'Huckleberry' ,`StreetNumber` = '415' ,`StreetSuffix` = 'Road' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '924' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2328' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 47 SERIAL# TXFL1A751031021 HUD# TE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '649' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212098901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:42:08.473' ,`MLSNumber` = '83384563' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.819430' ,`Longitude` = '-95.111351' ,`PhotoCount` = '39' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '78500.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '645' ,`StreetSuffix` = 'Park' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '756' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '0.1791' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 2 LOT 293 SERIAL# ALWH2618205 HUD# PFS00' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '482' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212098986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:50:32.707' ,`MLSNumber` = '71239425' ,`ListAgentFullName` = 'Teresa Hill McCray' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.817929' ,`Longitude` = '-95.111666' ,`PhotoCount` = '13' ,`PostalCode` = '77360' ,`RoomCount` = '2' ,`ListPrice` = '47000.00' ,`Status` = 'Active' ,`StreetName` = 'Cherokee' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Text agent with request. All dimensions to be verified by client. Home is currently occupied, do not disturb the tenants.' ,`Acres` = '' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CANYON PARK SECTION 4 LOT 91, 92 & 93 SERIAL# N/A HUD# N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Canyon Park' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212100219' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:39:22.287' ,`MLSNumber` = '10996172' ,`ListAgentFullName` = 'Brandy Liss' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.519245' ,`Longitude` = '-94.995886' ,`PhotoCount` = '40' ,`PostalCode` = '77518' ,`RoomCount` = '9' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Miles' ,`StreetNumber` = '202' ,`StreetSuffix` = 'Road' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2308' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO YOUR NEW HOME!\r\n\r\nYou\'ll fall in love with this cottage chic home the moment you walk in. From the mid-century modern woodwork to the bead-board coffered ceilings, this home has all of the luxurious finishes you could want. Wait until you see the oversized garage!! \r\n\r\nThe pride of ownership shines through in every detail, from the new roof and fence to the new windows and beautiful finishes. You\'ll love spending time in this home, whether you\'re cooking in the gorgeous kitchen with granite counters and apron front stainless sink or entertaining friends and family in the spacious backyard. \r\n\r\nBest of all, this home is incredibly affordable with low taxes and no HOA fees. So call today for a private tour and start enjoying your new home!' ,`Acres` = '0.3128' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 67 N FULLER SUR LOT 2 & NW 43.3 FT OF LOT 1 & SE 20 FT' ,`LotDesciption` = 'Corner' ,`LotSize` = '13625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'Bayview Add' ,`TaxAmount` = '2679' ,`TaxRate` = '1.9548' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794357' WHERE `Matrix_Unique_ID` = '212202068' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:37:47.830' ,`MLSNumber` = '18662624' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.882755' ,`Longitude` = '-95.511509' ,`PhotoCount` = '24' ,`PostalCode` = '77040' ,`RoomCount` = '7' ,`ListPrice` = '269995.00' ,`Status` = 'Active' ,`StreetName` = 'Battleoak' ,`StreetNumber` = '7918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1161' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! Fully remodeled 3 bedroom 1.5 bath 2 car garage home. Home features OPEN CONCEPT FLOOR PLAN, recessed lighting, beautiful laminate flooring throughout the entire home, NO CARPET! The living room features a wood burning fire place with modern brick accent wall, perfect for those winter nights! The kitchen features QUARTZ COUNTER TOPS, beautiful tile back splash, designer SOFT CLOSE KITCHEN CABINETS, breakfast bar, gas range, and STAINLESS STEEL APPLIANCES INCLUDED! The spacious bedrooms include WALK IN CLOSETS! The bathroom features modern vanities with mirror and a tub/shower combo with modern tiling. NEW TIMBERLINE ROOF, DOUBLE PANE WINDOWS, NEW INTERIOR/EXTERIOR DOORS,NEW A/C,NEW DUCT WORK,NEW THERMOSTAT,NEW WATER HEATER, NEW FURNACE, NEW ELECTRICAL PANEL, NEW GARAGE DOOR AND MOTOR,NEW LED LIGHTING. There is a 23\'x11\' detached building in the LARGE BACKYARD that could easily be converted into a GUEST HOUSE or POTENTIAL RENTAL INCOME!Stucco cement material is included!' ,`Acres` = '0.1653' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 616 BLK 15 WOODLAND OAKS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Oaks Sec 03' ,`TaxAmount` = '3032' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794358' WHERE `Matrix_Unique_ID` = '212232874' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:36:55.150' ,`MLSNumber` = '23733438' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665818' ,`Longitude` = '-95.542989' ,`PhotoCount` = '39' ,`PostalCode` = '77031' ,`RoomCount` = '9' ,`ListPrice` = '324995.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Meadow' ,`StreetNumber` = '9407' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! Completely remodeled 4 bedroom 2 bath 2 car DETACHED GARAGE home. Home features open concept floor plan, wood laminate flooring in main living areas and tile in kitchen and bathrooms, NO CARPET! Recessed lighting in main living area and wood burning fireplace. The kitchen features quartz counter tops, beautiful cabinets and hardware, gas stove and ALL STAINLESS STEEL APPLIANCES INCLUDED! The laundry room is conveniently located inside the home. The primary bedroom can perfectly accommodate a large bedroom set and features a beautiful en-suite bath! The bathrooms have been tastefully remodeled with quartz counter tops, double sinks, stand up shower with frameless glass! Home also has NEW EXTERIOR SIDING, NEW INTERIOR/EXTERIOR DOORS, NEW WATER HEATER, NEW PLUMBING, NEW LED LIGHTING, NEW GARAGE MOTOR, NEW 30 YR. TIMBERLINE ROOF. The community pool and park is just steps away from your new home! Schedule your appointment today!' ,`Acres` = '0.1641' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 20 BRAEBURN VALLEY WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'VALLEY WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeburn Valley West Sec 01' ,`TaxAmount` = '3410' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794358' WHERE `Matrix_Unique_ID` = '212236405' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:39:26.810' ,`MLSNumber` = '63791371' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876519' ,`Longitude` = '-95.451404' ,`PhotoCount` = '27' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnyhill' ,`StreetNumber` = '8318' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN NEW CONSTRUCTION!Welcome to your beautiful 3 bedroom,2.5 bath,2 car garage home!From the moment you walk through the covered porch leading to the MODERN GLASS FRONT DOOR you will be WOWED! Home features OPEN CONCEPT FLOOR PLAN with high ceilings,tile flooring in main living area and recessed lighting throughout. Kitchen features beautiful QUARTZ COUNTER TOPS, breakfast bar,STAINLESS STEEL APPLIANCES, modern design back splash,42\"cabinets.The half bath is conveniently located on first floor.Beautiful stained stair treads leading up to the second floor.The EXTRA LARGE PRIMARY BEDROOM can perfectly accommodate any size bedroom set and features a COVERED BALCONY!The en-suite bath features a modern frame less shower and separate tub, DOUBLE SINKS with quartz counter tops, and best of all a LARGE WALK IN CLOSET! The utility room is centrally located between all bedrooms on the second floor. The backyard is fully fenced and features a covered porch.Schedule your showing today!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'TL Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 3 WASHINGTON HEIGHTS ANNEX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Washington Heights Annex Sec 0' ,`TaxAmount` = '539' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794358' WHERE `Matrix_Unique_ID` = '212298973' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:40:01.647' ,`MLSNumber` = '96937922' ,`ListAgentFullName` = 'Iliana Sanchez' ,`ListOfficeName` = 'NuWay Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.876258' ,`Longitude` = '-95.451284' ,`PhotoCount` = '27' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '324900.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnyhill' ,`StreetNumber` = '8320' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN NEW CONSTRUCTION!Welcome to your beautiful 3 bedroom,2.5 bath,2 car garage home!From the moment you walk through the covered porch leading to the MODERN GLASS FRONT DOOR you will be WOWED! Home features OPEN CONCEPT FLOOR PLAN with high ceilings,tile flooring in main living area and recessed lighting throughout. Kitchen features beautiful QUARTZ COUNTER TOPS, breakfast bar,STAINLESS STEEL APPLIANCES, modern design back splash,42\"cabinets.The half bath is conveniently located on first floor.Beautiful stained stair treads leading up to the second floor.The EXTRA LARGE PRIMARY BEDROOM can perfectly accommodate any size bedroom set and features a COVERED BALCONY!The en-suite bath features a modern frame less shower and separate tub, DOUBLE SINKS with quartz counter tops, and best of all a LARGE WALK IN CLOSET! The utility room is centrally located between all bedrooms on the second floor. The backyard is fully fenced and features a covered porch.Schedule your showing today!' ,`Acres` = '' ,`Area` = '11' ,`BuilderName` = 'TL Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 3 WASHINGTON HEIGHTS ANNEX SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Washington Heights Annex Sec 0' ,`TaxAmount` = '539' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663794358' WHERE `Matrix_Unique_ID` = '212303676' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T05:59:37.343' ,`MLSNumber` = '57987557' ,`ListAgentFullName` = 'Christopher Hiller' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768114' ,`Longitude` = '-95.714719' ,`PhotoCount` = '50' ,`PostalCode` = '77094' ,`RoomCount` = '11' ,`ListPrice` = '672000.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Green' ,`StreetNumber` = '1327' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning, classic CUSTOM home w/gorgeous pool/private backyard paradise zoned to coveted schools in highly desired Estates of Green Trails. Iconic tree lined street ushers in property w/A+ curb appeal. Double French door entry opens to lovely formal dining overlooking huge family rm w/FP & builtins. Study/home office w/brick wall plus circular stair to 2nd level library! Upldated kit/breakfast w/granite, chiseled tile, builtin china cabinets. Large private primary w/expanded closet, sitting area, updated primary bath. Design features throughout incl extensive crown moulding, fluted wood trim, parquet. Roof \'21, carpet \'22, radiant barrier. Parking for 7+ vehicles. Wshr,Dryr,fridge, wall mounted TVs stay! Huge back patio overlooks lush landscaping. Backs to greenbelt w/path network leading to miles of trails thru Geo Bush & Terry Hershey parks! Zoned to acclaimed Pattison/McMeans/Taylor track! Quick access to West Houston Medical Center & Energy Corridor! Low tax rate! NO FLOODING!' ,`Acres` = '0.2893' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 10 GREEN TRAILS SEC 1' ,`LotDesciption` = 'Greenbelt,Subdivision Lot,Wooded' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1060' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'PATTISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Trails' ,`TaxAmount` = '11437' ,`TaxRate` = '2.2423' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794358' WHERE `Matrix_Unique_ID` = '212517780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-21T04:56:41.887' ,`MLSNumber` = '15173130' ,`ListAgentFullName` = 'Jason Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.385826' ,`Longitude` = '-95.608917' ,`PhotoCount` = '27' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '1090000.00' ,`Status` = 'Active' ,`StreetName` = 'Hemingway' ,`StreetNumber` = '2827' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3273' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unbelievably STUNNING Lakehouse with open water views, private pool, boat dock with boat lift and separate personal watercraft lifts! The water location of your dreams - views of the open lake in the peacefulness of a \"no wake\" cove. Soak in the saltwater pool in the summer or in the raised hot tub while overlooking the lake or the stars. Inside is light and bright with high ceilings upstairs, a large kitchen that opens to the living and dining areas, and VIEWS from everywhere in the home! Wet bar off of the living area, office area tucked away for privacy. VIEWS in the primary bedroom, HUGE primary bathroom with walk-in shower, jetted tub, and luxurious cabinet space! Downstairs is an additional living area, two secondary bedrooms with their own bathrooms, the laundry and access to two individual garages. Rest easy on the upstairs balcony, the downstairs covered balcony, or walk out to the hammock nestled between the massive shade trees! This is the Lakehouse of your dreams!' ,`Acres` = '0.1868' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 06, BLOCK 18, LOT 54' ,`LotDesciption` = 'In Golf Course Community,Water View,Waterfront' ,`LotSize` = '8138' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Walden' ,`TaxAmount` = '12363' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663794359' WHERE `Matrix_Unique_ID` = '212584063' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212751317','1663794359','212751317','2022-09-21T04:43:58.040','90472088','David Nguyen','B & W Realty Group LLC','','','29.733803','-95.470986','45','77056','10','945000.00','Active','Lampasas','5354','Street','Houston','4','1','4','3710','Single-Family','Welcome home to 5354 Lampasas. This AMAZING 4 bedroom 4.5 bath home located in the in the heart of the Historical Post Oak/Galleria area. This home is only a short walk away from the main the Galleria District . This stunning home features a open concept living space, large walk-in closets, and elegant hardwood floor throughout the home. The owner has recently had the entire home professionally painted. The The kitchen space features high end appliances; Double oven, built in refrigerator. Refrigerator and washer dryer are included in the sale. Each floor features a large family room. The downstairs family room features a wet bar with a wine fridge and ice maker. The Primary suite has its own private patio overlooking the pool. Additionally, there is an exquisite primary bathroom with a double vanity, double shower and built in cabinets in the closet. The backyard features a beautifully landscaped Waterfall Pool and recreational area perfect for entertaining.','0.1515','22','','','','','Sellers Disclosure','','','1','Galleria','Central Gas','0','LT 30 BLK 5 LAMAR TERRACE','Subdivision Lot','6600','Appraisal District','','','0','','2','','1','In Ground','','','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Lamar Terrace','20260','2.4457','Public Water','1999','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212752935','1663794359','212752935','2022-09-21T05:31:51.983','46077995','Susan Delgado','Continental Realty','','','29.656139','-95.451553','0','77035','6','215000.00','Active','Spellman','4423','Road','Houston','1','1','3','1202','Single-Family','Beautiful brick home that needs a total rehabilitation inside. Great neighborhood. Award winning schools. Close to downtown, NRG, Medical Centers.','0.1608','20','','','','','No Disclosures','0','','','Willow Meadows Area','No Heating','0','LT 3 BLK 11 POST OAK MANOR SEC 4','Subdivision Lot','7006','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','RED ELEMENTARY SCHOOL','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Post Oak Manor Sec 04','4774','2.3307','Public Sewer,Public Water','1955','Appraisal District'); --> New record created successfully