Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T04:59:09.863' ,`MLSNumber` = '52664968' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839008' ,`Longitude` = '-95.682217' ,`PhotoCount` = '19' ,`PostalCode` = '77084' ,`RoomCount` = '4' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakhampton' ,`StreetNumber` = '18307' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ROOF 10/2022!  Nice and cozy 4 bedrooms with primary room downstairs.  2 bathrooms upgraded 2021.  House painted and new carpet replaced 2021.   Plenty spaces with long driveway to detached garage for parking spaces.  Hug room for outdoor party in the backyard.  This house won’t last long!   Call agent today to make appointment.' ,`Acres` = '0.2066' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 40 DEERFIELD VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 04' ,`TaxAmount` = '5115' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924639' WHERE `Matrix_Unique_ID` = '207160295'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:21:24.823' ,`MLSNumber` = '88357116' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.128205' ,`Longitude` = '-96.948776' ,`PhotoCount` = '24' ,`PostalCode` = '76670' ,`RoomCount` = '6' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Water' ,`StreetNumber` = '407' ,`StreetSuffix` = '' ,`City` = 'Milford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS PRICE IMPROVEMENT and $500 offered rate buy down! Country roads take me home, this adorable and affordable home is located in the heart of Milford and just minutes from the highway. Well maintained home features three bedrooms, two baths and backs up to wide open pasture land. The front porch is perfect for you to sip coffee and visit with the neighbors. The open floor plan and wood floors are perfect to give the feeling of HOME as you walk in the front door. Milford is located in the southern part of Ellis County and is centrally located between Dallas and Waco.' ,`Acres` = '0.25' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '470 E L HOGAN 0.25 AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '743 - Milford' ,`SchoolElementary` = 'MILFORD SCHOOL' ,`SchoolHigh` = 'MILFORD SCHOOL' ,`SchoolMiddle` = 'MILFORD SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'E L Hogan' ,`TaxAmount` = '2316' ,`TaxRate` = '1.6381' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924639' WHERE `Matrix_Unique_ID` = '212076642'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:20:46.887' ,`MLSNumber` = '31508925' ,`ListAgentFullName` = 'Kimberly Capps-Rumfield' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.976934' ,`Longitude` = '-97.356530' ,`PhotoCount` = '30' ,`PostalCode` = '76692' ,`RoomCount` = '6' ,`ListPrice` = '378500.00' ,`Status` = 'Active' ,`StreetName` = 'Cloud Shadow' ,`StreetNumber` = '161' ,`StreetSuffix` = 'Drive' ,`City` = 'Whitney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1497' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE PRICE REDUCTION! Just minutes from beautiful Lake Whitney and the charming downtown of Whitney, this cutie is well built and waiting on you to call it HOME! It features three bedrooms and two baths on 1.38 +- acres with a beautiful view from the back porch of wide open spaces and beautiful towering trees! Brand new granite countertops, vinyl planking floors, and fresh paint throughout! Oh, and just a short drive to Texas Great Country Cafe and Pie Pantry for some of the best home cooking you will ever eat.' ,`Acres` = '1.387' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LAKE SHADOW BLK 2 LT 8 & 9 1.387 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '60418' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1035 - Whitney' ,`SchoolElementary` = 'WHITNEY ELEMENTARY SCHOOL (WHITNEY)' ,`SchoolHigh` = 'WHITNEY HIGH SCHOOL' ,`SchoolMiddle` = 'WHITNEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Shadow' ,`TaxAmount` = '3847' ,`TaxRate` = '2.0289' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924640' WHERE `Matrix_Unique_ID` = '212088384'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:00:22.600' ,`MLSNumber` = '36545651' ,`ListAgentFullName` = 'Erwin Nicholas' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.767651' ,`Longitude` = '-95.412284' ,`PhotoCount` = '30' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '965000.00' ,`Status` = 'Active' ,`StreetName` = 'Roy' ,`StreetNumber` = '606' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Take a look at this beautiful 4 story single family master piece! This home is unique with commercial floor to ceiling windows and sliding doors. High ceilings and very open floor plan make this home perfect for entertaining guest! Stainless steel Jenn-Air commercial grade appliances compliment the kitchen with a very large seating area. The seller has also upgraded the lighting fixtures and added custom improvements through out the home. One of the most exciting additions to the home is the first in Houston container pool and private side yard! This is a must see home!' ,`Acres` = '0.0373' ,`Area` = '16' ,`BuilderName` = 'Eppers & Wakefield' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 CHATEAUS ON ROY STREET' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '1625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground,Enclosed,Fiberglass' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Chateaus/Roy Street' ,`TaxAmount` = '13072' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667924640' WHERE `Matrix_Unique_ID` = '212271826'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:39:29.710' ,`MLSNumber` = '34540375' ,`ListAgentFullName` = 'Karen Hoogendorn' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.725248' ,`Longitude` = '-95.558532' ,`PhotoCount` = '19' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '134500.00' ,`Status` = 'Active' ,`StreetName` = '10th' ,`StreetNumber` = '1622' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Farmhouse Style 3 bedroom, 2 baths, carport, storage building with backyard, located 1 block from Elementary school, near Historic downtown Huntsville. *Zoned for Residential or Commercial, great investment property.' ,`Acres` = '0.1515' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROGERVILLE, LOT 7, ACRES 0.1515, (MH 7.1)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rogerville' ,`TaxAmount` = '194' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924640' WHERE `Matrix_Unique_ID` = '213455821'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:24:46.290' ,`MLSNumber` = '34415572' ,`ListAgentFullName` = 'Lina Campbell' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.827454' ,`Longitude` = '-95.512069' ,`PhotoCount` = '36' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Autauga' ,`StreetNumber` = '8907' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1881' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING! 3/4 BDS, 2 FULL BTHS, BRICK HOME, WITH A VERY NICE LAYOUT, IN THE BEAUTIFUL & HIGHLY DESIRABLE BINGLEWOOD.\r\nTHIS HOME\'S BACKYARD IS AN ENJOYABLE OASIS WITH ALL IT\'S BREEZE & SHADE OF THE TREES. JUST BEAUTIFUL.\r\nTHE OFFICE/BONUS ROOM HAS THE DESIGN DIVERSITY FROM GUEST DINING, GAME TO GUEST BEDROOM.\r\nSURROUNDED BY TRANQUILITY, THIS HOME IS BUILT WITH STRAIGHT POSITION SUN RISES ON GARAGE SIDE GIVING THE HOME A \r\nMARVELOUS AIR CIRCULATION THAT DRAWS HIGH PROFILE OF ENERGY\r\nSAVING. FROM LOADING,WASHING,COOKING TO INVENTORY ADJACENT TO\r\nKITCHEN,THERE IS A SIDE DOOR IN LAUNDRY ROOM TO\r\nEXTERIOR TRASH BEAM SAVING TIME FROM HEAVY DUTY HOUSEKEEPING.IMAGINE HAVING A PICNIC WITH FRIENDS AND FAMILY IN COMMUNITY PARK THAT TAKES TWO MINUTES BY WALKING.\r\nGREAT LIVING STYLE 15-20 MINUTES TO MEMORIAL MALL AND IKEA, COSTCO, HOME DEPOT HEB, ASIAN SUPERMARKETS, 99 RANCH & H-MART & ZEN STYLE FOOD.\r\nTHIS HOME IS THE PERFECT CHOICE FOR LIVING QUALITY ACQUIRING AND VALUE\r\nGROWING!' ,`Acres` = '0.2149' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 444 BLK 24 BINGLEWOOD SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'EDGEWOOD ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'NORTHBROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Binglewood Sec 04' ,`TaxAmount` = '6502' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924640' WHERE `Matrix_Unique_ID` = '213701338'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T04:17:58.990' ,`MLSNumber` = '61649078' ,`ListAgentFullName` = 'Robyn Davis' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662942' ,`Longitude` = '-95.053587' ,`PhotoCount` = '25' ,`PostalCode` = '77571' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Winburn Tide' ,`StreetNumber` = '527' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3/2/2 in one of La Porte\'s newest subdivision; Morgan\'s Landing. Open concept, spacious home, neighborhood filled with amenities, fully fenced. There are no neighbors to the back and the home faces a cul-de-sac. This home is a must see! Does have an assumable loan at just over 4%.' ,`Acres` = '0.1395' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 MORGANS LANDING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '895' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morgans Lndg Sec 5' ,`TaxAmount` = '8002' ,`TaxRate` = '3.5108' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924640' WHERE `Matrix_Unique_ID` = '214120561'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-08T03:01:22.690' ,`MLSNumber` = '62307217' ,`ListAgentFullName` = 'Erwin Nicholas' ,`ListOfficeName` = 'Mr. Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.641883' ,`Longitude` = '-95.377403' ,`PhotoCount` = '15' ,`PostalCode` = '77051' ,`RoomCount` = '3' ,`ListPrice` = '115000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunnydale' ,`StreetNumber` = '3126' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unfinished Remodel opportunity.' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 11 SUGAR VALLEY' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'REYNOLDS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sugar Valley' ,`TaxAmount` = '3383' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667924641' WHERE `Matrix_Unique_ID` = '214217906'  --> Updated record success<br />