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'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','206917766','1675091302','206917766','2022-12-15T07:45:56.353','94074157','Lonny Johnson','Emblem Properties','','','30.914917','-95.249109','38','75862','3','75000.00','Active','Medina','395','Drive','Trinity','1','0','1','450','Single-Family','This cozy Lake area cabin is a must see. It has a covered 13x3 front porch, tankless water heater, storage lofts in the Living room, and primary bedroom, large screened in 19x8 side porch with ceiling fan. This meticulously maintained home is fenced and located on four wooded lots in the gated private subdivision of Harbor Point. Two steel, double space carports, outdoor fire pit area, an 18x10 roll up door storage bldg. and an 8x8 utility/storage bldg.  Shade and mature trees galore. This small home is in excellent condition, serviced with public water/sewer, and ready to move in. The amenities you will enjoy at Harbor Point is of course, Gated access, Lake access with private boat ramps, boat slips, lake front picnic areas, parks, pool, and a community bldg that can be rented.  Enjoy sitting outdoors or in the covered screened in side porch.  Unique opportunity at this price for a ready to live in small home or to retreat from the hustle and bustle. Bring your boat and cookout.','0.1148','42','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Lake Livingston Area','Space Heater','1','See exhibit A in attachments for full legal desciption','Subdivision Lot,Wooded','25000','Appraisal District','','402','0','','0','','0','','','','','Composition','59 - Groveton','GROVETON ELEMENTARY SCHOOL','GROVETON J H-H S','GROVETON J H-H S','Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front','Appraisal District','1','Other Style,Traditional','Harbor Point Sec B','91','1.6133','Public Sewer,Public Water','2012','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T08:53:51.847' ,`MLSNumber` = '98280208' ,`ListAgentFullName` = 'Jaime Black' ,`ListOfficeName` = 'Martin & Black Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.534104' ,`Longitude` = '-95.200788' ,`PhotoCount` = '7' ,`PostalCode` = '77546' ,`RoomCount` = '4' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Quaker' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Friendswood Heights is a distinctive community in the heart of old Friendswood. These modern three-story designs, inspired by urban community living, bring a refreshing alternative to the Friendswood residential housing market. Situated in a park-like setting across from Mary\'s Creek, each home will have open floor plans, full of natural light and warm materials. Access to quality covered outdoor spaces with distinctive landscaping further reinforces the unique qualities of each unit. The high level of design, backed by quality construction, sets a new standard that is second to none. Although all homes are designed with a consistent intent, unique detailing and special features provide opportunities for each unit to reflect your particular lifestyle. Reach out today to learn more about how you can be a part of this unique opportunity!' ,`Acres` = '0.242' ,`Area` = '33' ,`BuilderName` = 'Augusta Kelly and Co' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10, Block 1, Friends Heights' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6360' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Friendswood Heights' ,`TaxAmount` = '722' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675091302' WHERE `Matrix_Unique_ID` = '208038691'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T08:07:09.560' ,`MLSNumber` = '41730693' ,`ListAgentFullName` = 'Aaron Jistel' ,`ListOfficeName` = 'Listing Spark' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.768696' ,`Longitude` = '-95.162073' ,`PhotoCount` = '25' ,`PostalCode` = '77015' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Waldine' ,`StreetNumber` = '14607' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3313' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The house is centered in an amazing place right in between I-10 and Beltway 8 in Houston. The house was recently completely remodeled from the ground up so everything in the home is brand new.' ,`Acres` = '0.2525' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'W 1/2 OF LT 127 MARWOOD' ,`LotDesciption` = 'Other' ,`LotSize` = '11000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CLOVERLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Marwood' ,`TaxAmount` = '8223' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091302' WHERE `Matrix_Unique_ID` = '213433064'  --> Updated record success<br />