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` = '2023-01-20T06:45:06.577' ,`MLSNumber` = '62253201' ,`ListAgentFullName` = 'Tony Prock' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.278152' ,`Longitude` = '-95.751480' ,`PhotoCount` = '14' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '1650000.00' ,`Status` = 'Active' ,`StreetName` = 'Tecova Creek' ,`StreetNumber` = '7406' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4529' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Introducing 7406 Tecova Creek by G&G Designs Custom Homes. Located on an intimate cul-de-sac, this spectacular residence features an inviting and open floor plan highlighted by a spacious chef\'s kitchen, opening to an expansive great room showcasing stackable glass sliders that open onto an oversized back entertaining area. Simply, this is an entertainer\'s dream home offering plenty of gathering spaces as well as primary suite privacy as it is located within its own wing of the thoughtfully designed floor plan. The oversized garage features 3.5 bays, enlarged doors for taller vehicles, and plenty of storage. Upstairs you will find a game room plus a bedroom complete with an ensuite bath. If you have not visited High Meadow Estates, you will love this acreage community located a mere 30 minutes from The Woodlands. A peaceful country setting yet close to a plethora of dining and shopping options. Floor plan is uploaded under attachments. Schedule your private showing today!' ,`Acres` = '1.472' ,`Area` = '39' ,`BuilderName` = 'G&G Designs' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S580109 - High Meadow Estates 09, BLOCK 2, Lot 11' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '64120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Ranch' ,`Subdivision` = 'High Meadow Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675216524' WHERE `Matrix_Unique_ID` = '213526750'  --> 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','216386189','1675216524','216386189','2023-01-20T05:20:22.883','34833192','Norberto Lopez','Keller Williams Signature','','','29.847100','-95.543574','14','77041','8','255000.00','Active','Porto Rico','10135','Road','Houston','2','1','3','1772','Single-Family','AWESOME 3 BEDRM 3-BA Townhome nestled on a Quiet & Safe Street in a Family-Friendly Community! Spring Branch Area, Immaculately Maintained Bright & Open Floorplan includes Sleek Cabinetry, Ample Countertops, Plenty Cabinets, Polished Appls & Open Dining Area. Cozy – Roomy Dining/Family Room has Ceramic Tile Floors & High Ceilings-. The elegant Master Retreat boasts an EnSuite Bath w/ Sink Vanity, a Large Walk-in Closet, and Spacious Rooms with a Secondary Bath in 2nd. Floor. Spacious Back Patio overlooks Lush Backyard w/ Privacy Fencing, 1-CAR Attached Garage, Premium Gas Stove/Oven, Arched Doorways, Refrigerator, Extra Insulation, Conveniently Located near Belt Way 8, 290 Highway and I-10 Freeway *, Wide Driveway are Just a Sampling of a Long List of Features Extras & Value! Currently Occupied by Tenants on a Month to Month Lease.','','24','Miranda Builders','','','','Sellers Disclosure','1','','','Spring Branch','Central Gas','0','LT 185 BLK H CARVERDALE SEC 2','Subdivision Lot','3500','Other','','','0','','1','Gas Oven,Single Oven','0','','','Gas Range','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','No Supra Keybox','Seller','2','Traditional','Carverdale Sec 02','6000','2.5842','Public Sewer,Public Water','2015','Appraisal District');  --> New record created successfully<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','216426993','1675216524','216426993','2023-01-20T05:21:23.223','85111687','Norberto Lopez','Keller Williams Signature','','','29.847100','-95.543574','14','77041','8','255000.00','Active','Porto Rico','10135','Road','Houston','2','1','3','1772','Single-Family','AWESOME 3 BEDRM 3-BA Townhome nestled on a Quiet & Safe Street in a Family-Friendly Community! Spring Branch Area, Immaculately Maintained Bright & Open Floorplan includes Sleek Cabinetry, Ample Countertops, Plenty Cabinets, Polished Appls & Open Dining Area. Cozy – Roomy Dining/Family Room has Ceramic Tile Floors & High Ceilings-. The elegant Master Retreat boasts an EnSuite Bath w/ Sink Vanity, a Large Walk-in Closet, and Spacious Rooms with a Secondary Bath in 2nd. Floor. Spacious Back Patio overlooks Lush Backyard w/ Privacy Fencing, 1-CAR Attached Garage, Premium Gas Stove/Oven, Arched Doorways, Refrigerator, Extra Insulation, Conveniently Located near Belt Way 8, 290 Highway and I-10 Freeway *, Wide Driveway are Just a Sampling of a Long List of Features Extras & Value! Currently Occupied by Tenants on a Month to Month Lease.','','24','Miranda Builders','','','','Sellers Disclosure','1','','0','Spring Branch','Central Gas','0','Lt 185 BLK H CARVERDALE SEC. 2','Subdivision Lot','3500','Other','','','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','No Supra Keybox','Seller','2','Traditional','Carverdale','6097','2.58','Public Sewer,Public Water','2015','Appraisal District');  --> New record created successfully<br />