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-08-06T12:40:36.993' ,`MLSNumber` = '3029931' ,`ListAgentFullName` = 'Kelly Turner' ,`ListOfficeName` = 'BSRH Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795818' ,`Longitude` = '-96.170042' ,`PhotoCount` = '20' ,`PostalCode` = '77474' ,`RoomCount` = '8' ,`ListPrice` = '449400.00' ,`Status` = 'Active' ,`StreetName` = 'Hunters Crossing' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Drive' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction in Hunters Crossing! This 2 story 4 bedroom 3 1/2 bath, includes a spacious kitchen with granite counter-tops and stainless steel appliances. Wood floors in family, kitchen and dining. The master suite includes an oversized shower and master closet. Another Secondary bedroom is located downstairs with en-suite bath.  Two additional bedrooms, and game room are located upstairs. Don\'t forget the large covered patio where you can relax and enjoy the fresh country breeze! Walking distance to Sealy Elementary School. (Room measurements to be verified by buyer.) Zoned to Sealy Elementary. (Room measurements to be verified by buyer.)' ,`Acres` = '' ,`Area` = '57' ,`BuilderName` = '0000' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3, Block 1,  Hunters Crossing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Hunters Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695149' WHERE `Matrix_Unique_ID` = '205463207'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T12:23:43.350' ,`MLSNumber` = '80156965' ,`ListAgentFullName` = 'Chris Hotfelt' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.269947' ,`Longitude` = '-95.468671' ,`PhotoCount` = '41' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Lake' ,`StreetNumber` = '21727' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2763' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to the beautiful neighborhood of Chenango Ranch with an oversized 1 acre lot! This custom stucco home sits on over 1 acres with huge 2 car detached garage, fire pit area, tuf shed in back, and plenty of space for entertaining and country living. House was a secondary home and feels brand new. Luxury at every turn with strong engineered wood flooring throughout the house, granite counters, large ceiling high kitchen cabinets, and two separate washer/dryer areas. All bedrooms upstairs but with full bathroom downstairs great for when guests are in town visiting. 4th bedroom upstairs is currently being used as an office having french doors leading to a beautiful view on your upstairs balcony. Back door has mudroom leading to your massive 2 car detached garage with plenty of space for cars and work area. More than enough space on the property to entertain or just relax with aged oak trees all around! Book your tour today!!' ,`Acres` = '1.046' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CHENANGO RANCH SEC 1 (A0071-A0122-A0144) BLK 1 LOT 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '45564' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chenango Ranch Sec 1' ,`TaxAmount` = '6121' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695149' WHERE `Matrix_Unique_ID` = '206495279'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T13:49:32.680' ,`MLSNumber` = '52733765' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Matthew Shelton' ,`SellingOfficeName` = 'Greenwood King Properties' ,`Latitude` = '30.236006' ,`Longitude` = '-95.708247' ,`PhotoCount` = '13' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '316490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'WINTER GRASS BEND' ,`StreetNumber` = '40502' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW EXPRESS HOME IN THE BEST LOCATION! This charming one story has it all!!! HUGE 12,000 sq ft home site! PRIVATE back yard with no back neighbors! Lovely floor plan with open living spaces and modern finishes! Great kitchen with granite countertops, hard surface flooring, beautiful cabinetry, and so much more! Home also includes landscaping, irrigation system, blinds, refrigerator, washer & dryer, full gutters, and garage door opener!  Zoned to Magnolia ISD! Hurry and call TODAY!!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695149' WHERE `Matrix_Unique_ID` = '210577922'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T12:14:33.967' ,`MLSNumber` = '75094507' ,`ListAgentFullName` = 'Suzan Odom' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.454934' ,`Longitude` = '-94.630420' ,`PhotoCount` = '32' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '895900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '1977' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1548' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Beachside Custom Home. Fully Furnished and Complete with an In Home Elevator. This Property is an Entertainers Dream. The Main Floor Open Concept Allows You and Your Guests Plenty of Room to Socialize. Step Out Onto the Deck and Enjoy the Sights and Sounds of the beach. The Mezzanine Level Offers Endless Options to Enjoy the Outside and the Cool Breezes of the Gulf. Two Garages Under The Home Offer Plenty of Room for Your Beach Toys and Cars While the Additional Two Car Detached Garage Makes a Perfect Workshop. The Outdoor Sand Shower is the Perfect Spot To Rinse Off From a Day at the Beach and the Fish Station is Perfect for Your Daily Catch! This Beauty Sits on Two Lots and would Make a Wonderful Vacation Home or a Stunning Permanent Residence. Beach Living At Its Finest. Welcome Home!' ,`Acres` = '0.2296' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 16 & 17 (17-0) BLK 4 GULF SHORES SE' ,`LotDesciption` = 'Water View' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gulf Shores 1' ,`TaxAmount` = '7040' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695150' WHERE `Matrix_Unique_ID` = '210945520'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T12:06:12.457' ,`MLSNumber` = '45629883' ,`ListAgentFullName` = 'Marjorie Portillo' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761656' ,`Longitude` = '-95.755651' ,`PhotoCount` = '15' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Landing' ,`StreetNumber` = '1419' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great renovated home in Creekstone. 1 story, 3 bedroom, 2 bedroom, 2 bath, 2 car attached garage. Nice cozy den with fireplace. Kitchen offers plenty of counter and cabinet space, breakfast bar room. Nice size bedrooms. Cute wooden deck on the side of the house.' ,`Acres` = '0.1472' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 5 CREEKSTONE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6413' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Creekstone Sec 01' ,`TaxAmount` = '3873' ,`TaxRate` = '2.3333' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695150' WHERE `Matrix_Unique_ID` = '210971004'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T12:19:58.420' ,`MLSNumber` = '771059' ,`ListAgentFullName` = 'Hoang Tran' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736978' ,`Longitude` = '-95.343050' ,`PhotoCount` = '12' ,`PostalCode` = '77003' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Hussion' ,`StreetNumber` = '1801' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1380' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Investment opportunity. The home located near the University of Houston, and just away from Downtown, easy access to the I-45 freeway. Come with your offer.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 8 PASTORIZA' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pastoriza' ,`TaxAmount` = '5056' ,`TaxRate` = '2.4557' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1927' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695150' WHERE `Matrix_Unique_ID` = '211132136'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-06T13:12:59.760' ,`MLSNumber` = '72141551' ,`ListAgentFullName` = 'Lannie Christensen' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926010' ,`Longitude` = '-95.572124' ,`PhotoCount` = '28' ,`PostalCode` = '77064' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Golden Grain' ,`StreetNumber` = '10930' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dry during Harvey! Harvest Bend cute open floor plan home.  Boasts soaring ceilings and tile floors.  Wood burning fireplace for those chilly nights in Texas.  Sunken tub in Master with skylights to relax in the evenings.  Large backyard for entertaining and outside cooking. Convenient location to Beltway 8 and shopping.' ,`Acres` = '0.1566' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 HARVEST BEND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '368' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'FRANCONE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Bend Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695150' WHERE `Matrix_Unique_ID` = '211135273'  --> Updated record success<br />