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-09-11T07:22:41.430' ,`MLSNumber` = '28900084' ,`ListAgentFullName` = 'Maria Lule' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313165' ,`Longitude` = '-96.109132' ,`PhotoCount` = '12' ,`PostalCode` = '77488' ,`RoomCount` = '7' ,`ListPrice` = '75900.00' ,`Status` = 'Active' ,`StreetName` = 'Milam' ,`StreetNumber` = '921' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '896' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investments income Producing Property!!!\r\nTwo bedroom one bath,  formal living room, dinning, kitchen, and large utility room. Washer/Dryer Connections.  Large yard has variety of mature trees. Walking distance to Historical down town Wharton featuring shopping, Theatre, restaurants antique shops, coffee shops and much more!' ,`Acres` = '0.1664' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CLINE BLOCK 1 LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`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,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cline' ,`TaxAmount` = '736' ,`TaxRate` = '2.43336' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709259' WHERE `Matrix_Unique_ID` = '201738345'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T07:22:01.120' ,`MLSNumber` = '19147708' ,`ListAgentFullName` = 'Maria Lule' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313641' ,`Longitude` = '-96.110704' ,`PhotoCount` = '14' ,`PostalCode` = '77488' ,`RoomCount` = '5' ,`ListPrice` = '74999.00' ,`Status` = 'Active' ,`StreetName` = 'Milam' ,`StreetNumber` = '1105' ,`StreetSuffix` = 'Street' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investments income Producing Property!!! Two bedroom one bath, formal living room, dinning and kitchen. Large yard has variety of mature trees. Walking distance to Historical down town Wharton featuring shopping, Theatre, restaurants antique shops and coffee shops.' ,`Acres` = '0.1664' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'WM.KINCHELOE BLOCK 63 LOT 154B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`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` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wmkincheloe' ,`TaxAmount` = '736' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709259' WHERE `Matrix_Unique_ID` = '201739197'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T07:24:07.527' ,`MLSNumber` = '39421365' ,`ListAgentFullName` = 'Maria Lule' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279214' ,`Longitude` = '-95.961851' ,`PhotoCount` = '36' ,`PostalCode` = '77420' ,`RoomCount` = '5' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'School Rd' ,`StreetNumber` = '218' ,`StreetSuffix` = '' ,`City` = 'Boling' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.7346' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'IAGO BLOCK 2 LOT 10, 11 Acres:0.7346' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'IAGO BLOCK 2 LOT 10, 11' ,`TaxAmount` = '4392' ,`TaxRate` = '1.64679' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709259' WHERE `Matrix_Unique_ID` = '203100285'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T07:34:10.630' ,`MLSNumber` = '60771996' ,`ListAgentFullName` = 'Claudia Oakley' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.084594' ,`Longitude` = '-95.693997' ,`PhotoCount` = '40' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Lakes' ,`StreetNumber` = '22210' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing price reduction!! Take advantage of this great opportunity! This picture-perfect colonial-style home in the gated community of Estates of Holly Lakes, framed by mature trees is ready for the next family to enjoy! The grand entrance welcomes you with soaring ceilings, elegant chandeliers and spiral staircase! The family room offers walls of windows for an amazing view! The chef’s kitchen offers lots of cabinets, built-in refrigerator, gas cooktop, double ovens, ice maker, a walk-in pantry, surrounded by windows with natural light and is perfect for entertaining. The primary bedroom downstairs has a private fireplace, a door to the backyard and a packet door to the study. The architecture and layout unite style and function gracefully in this home! Upstairs you will find a huge game room and four very spacious bedrooms and 3 bathrooms! The backyard is a gardener’s dream with plenty of green space and a lake view to relax and unwind.' ,`Acres` = '1.644' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 ESTATES OF HOLLY LAKE ABST 20 J H EDWARDS' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '71612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates/Holly Lakes' ,`TaxAmount` = '15380' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709259' WHERE `Matrix_Unique_ID` = '209887970'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T07:47:11.323' ,`MLSNumber` = '24456860' ,`ListAgentFullName` = 'Paige Houston' ,`ListOfficeName` = 'Texas Real Estate Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.024231' ,`Longitude` = '-95.563880' ,`PhotoCount` = '42' ,`PostalCode` = '77379' ,`RoomCount` = '17' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Courtney Pine' ,`StreetNumber` = '17430' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4642' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home located in the prestigious Brentwood Lakes subdivision with 5 bedrooms and 3.5 bathrooms. Beautiful stucco exterior. The grand 2 story entry features a formal dining room on one side and French doors leading to a classy home office with built-in shelving on the other. The family room opens to the kitchen with an island and stainless steel appliances. Secluded first floor primary suite overlooking the backyard. Home features two staircases! Entertain family and friends in the game room and media room upstairs. 3 CAR GARAGE! Zoned to the desirable Klein ISD! Conveniently located close to 249, 99, and Vintage Park - you will love living here!' ,`Acres` = '0.3058' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 3 BRENTWOOD LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13321' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HASSLER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Brentwood Lakes' ,`TaxAmount` = '9655' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709259' WHERE `Matrix_Unique_ID` = '210161810'  --> Updated record success<br />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','212111583','1663709260','212111583','2022-09-11T07:19:35.793','83984806','CHUKWUELOKA UZODIKE','J. Lindsey Properties','','','29.695680','-95.636867','21','77083','6','350000.00','Active','Mesa Ranch','7614','Trail','Houston','3','0','3','2170','Single-Family','2020 K Hovnanian corner lot home close to major freeways, the energy corridor, and shopping. The home features an open floor plan with 3 bedrooms and 3 full bathrooms, high ceilings throughout and a huge family room. The beautiful kitchen opens to the family room and includes granite countertops and a large under-mount sink. The study/office on the 1st floor can also serve as a 4th bedroom, and includes a large closet and a full bath. The primary suite is a large sanctuary with a lovely bathroom that includes a tub, separate shower and double sink vanity. All windows have 2\" blinds. Appliances include refrigerator, washer & dryer. Don\'t let this home sitting on one of the largest lots in the subdivision get away from you.','0.112','28','','','','','Sellers Disclosure,Tenant Occupied','1','','','Alief','Central Gas','1','LT 4 BLK 1 TERRA DEL SOL SEC 7','Corner','4880','Appraisal District','','560','0','','2','Gas Oven','0','','','Gas Range','','Composition','2 - Alief','HICKS ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','ALBRIGHT MIDDLE SCHOOL','Accompany,Appointment Required','Appraisal District','2','Ranch','Terra Del Sol Sec 7','1184','2.6193','Water District','2020','Appraisal District');  --> New record created successfully<br />