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-28T11:30:15.560' ,`MLSNumber` = '24025150' ,`ListAgentFullName` = 'Rickey Chavez' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.921335' ,`Longitude` = '-95.505146' ,`PhotoCount` = '17' ,`PostalCode` = '77086' ,`RoomCount` = '6' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Wood' ,`StreetNumber` = '9614' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1438' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! One story home full of character and charm with open concept floorplan and laminate flooring throughout the entire house. Granite counter tops with stone located is the island. window seat gives the space a cozy feel with French doors leading out to the outdoor space. These 3 beds 2 bath home nestles in the heart of Willowood is truly a hidden gem!' ,`Acres` = '0.1422' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 WILLOWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EPPS ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'KLEIN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowood Sec 01' ,`TaxAmount` = '4081' ,`TaxRate` = '2.8555' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704029' WHERE `Matrix_Unique_ID` = '208238583'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T10:42:59.737' ,`MLSNumber` = '88408902' ,`ListAgentFullName` = 'Lisa Sanders' ,`ListOfficeName` = 'Living Vogue Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034585' ,`Longitude` = '-94.872085' ,`PhotoCount` = '47' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Ford' ,`StreetNumber` = '405' ,`StreetSuffix` = 'Avenue' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this fabulous find in Fordland Estates on a 1/3 acre lot! The storage building is a bonus and still has lots of room for backyard activities. This beauty boasts a split floor plan for easy living. Once inside, you will love everything this home offers. The kitchen offers abundant cabinetry, counter space and breakfast bar. Open kitchen and family room - great for entertaining! The primary suite is large in size-matched to a large master bath with a garden tub and separate shower. Secondary bedrooms are tucked away from the primary suite. Easy drive for the commuter with convenient access to SH 146 and Hwy. 90. No HOA dues! Schools are in close proximity. Don\'t miss out on this charmer!' ,`Acres` = '0.32' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FORDLAND ESTATES, SEC 1, LOT 2, ACRES .32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13939' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Fordland Estates, Sec 1' ,`TaxAmount` = '5427' ,`TaxRate` = '2.4832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704029' WHERE `Matrix_Unique_ID` = '208720202'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T10:25:03.570' ,`MLSNumber` = '32138411' ,`ListAgentFullName` = 'Brenda Campbell' ,`ListOfficeName` = 'C.R.Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.741996' ,`Longitude` = '-95.884174' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Zephyr Park' ,`StreetNumber` = '3314' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2098' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You are going to love all this beautiful home has to offer! Welcome to this 4 bedroom, 2 bath, one story D.R. Horton home with an inviting floor plan in the heart of the master planned community of Tamarron! You are so close to everything the community and the surrounding area has to offer! Shopping, Dining, Lakes, Jogging Trails, community pools, rec center,...it\'s all here. Not to mention the beautiful home itself with an inviting living space with stunning tiled flooring in the kitchen and living areas. A kitchen that invites the chef in the family, with Granite counters, gas oven & cook-top, and plenty of space to create family favorites. The primary is a place you are going to love relaxing and unwinding. The backyard is made for entertaining outside and enjoying all the seasons. This home is waiting for you!' ,`Acres` = '0.1492' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 43, BLOCK 6, LOT 62' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '7999' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704029' WHERE `Matrix_Unique_ID` = '208752801'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T11:29:44.360' ,`MLSNumber` = '79543077' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750326' ,`Longitude` = '-95.879729' ,`PhotoCount` = '41' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '653000.00' ,`Status` = 'Active' ,`StreetName` = 'Tarragon Crest' ,`StreetNumber` = '2807' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Achieve the lifestyle you’ve been dreaming of in the remarkably spacious Harvard dream home. Beautiful master bedroom, spacious bathroom and a huge walk in closet! Explore your interior design skills in the glamorous open concept family and dining areas. The chef’s specialty kitchen offers ample room for storage, meal prep, and presentation, with a large entertainers delight kitchen island. Features 5 bedrooms; 2 down & 3 up with 4 full bathrooms and 1 half bath! Create the ideal specialty rooms for you and yours in the upstairs retreat and downstairs study, plus a Bonus/TV room upstairs as well! The guest suites present unique features & plenty of privacy. A huge covered patio and a 3-car garage as well all on a oversized pool size lot!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 02 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704029' WHERE `Matrix_Unique_ID` = '209322880'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T10:06:57.097' ,`MLSNumber` = '23982343' ,`ListAgentFullName` = 'Kaycee Anthony' ,`ListOfficeName` = 'Fowler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.836490' ,`Longitude` = '-94.268471' ,`PhotoCount` = '13' ,`PostalCode` = '75979' ,`RoomCount` = '3' ,`ListPrice` = '88000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 4072' ,`StreetNumber` = '190' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Precious 2/1 home sitting on just under half an acre. This is an investors dream! There are several new updates throughout the home, and ready for you to make it yours! Schedule your appointment today.' ,`Acres` = '0.473' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'S2551 FOSTER HILLS SEC 2 (A2), LOT 12, ACRES .473' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20604' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Foster Hills' ,`TaxAmount` = '559' ,`TaxRate` = '1.9972' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704030' WHERE `Matrix_Unique_ID` = '210439812'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T10:56:52.783' ,`MLSNumber` = '83672232' ,`ListAgentFullName` = 'Frances Aldridge' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003805' ,`Longitude` = '-96.305036' ,`PhotoCount` = '12' ,`PostalCode` = '77418' ,`RoomCount` = '11' ,`ListPrice` = '799999.00' ,`Status` = 'Active' ,`StreetName` = 'Highway 36 N' ,`StreetNumber` = '5960' ,`StreetSuffix` = '' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3447' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1.31 Acre home in the Bellville School District.  With an awesome outdoor covered entertaining area with kitchen/bar and double sided fireplace.  A seperate fire pit with seating area, and a good size storage shed. Circle Drive and Hwy 36  Road Frontage. Stainless Steel appliances. Refrigerator, Washer and Dryer Included.  Wood and Laminate Floors, Tile and Carpet. Metal roof.' ,`Acres` = '1.31' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'HICKORY CREEK RANCH SUB LOT 69' ,`LotDesciption` = 'Corner' ,`LotSize` = '57064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '75' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Hickory Creek Ranch Sub' ,`TaxAmount` = '6452' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704030' WHERE `Matrix_Unique_ID` = '210698005'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T11:42:05.370' ,`MLSNumber` = '64731173' ,`ListAgentFullName` = 'Natasha Simon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.815747' ,`Longitude` = '-95.320074' ,`PhotoCount` = '18' ,`PostalCode` = '77026' ,`RoomCount` = '3' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Caplin' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely renovated home with newer roof, new doors and new granite counter tops and new cabinets in kitchen and bathrooms, all new laminated flooring, plenty of space in the living dining area and a utility room. The house features a driveway, spacious front yard and backyard with metal fence. Conveniently located in a quiet neighborhood, minutes away from downtown and with access to I-610 and I-59.' ,`Acres` = '0.1389' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1543C & 1544C BLK 67 KASHMERE GARDENS PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Survey' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Kashmere Gardens Park' ,`TaxAmount` = '3261' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704030' WHERE `Matrix_Unique_ID` = '211850923'  --> Updated record success<br />