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-11-24T06:08:22.060' ,`MLSNumber` = '77073664' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.564746' ,`Longitude` = '-95.747498' ,`PhotoCount` = '50' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '539990.00' ,`Status` = 'Active' ,`StreetName` = 'Travers Hill' ,`StreetNumber` = '23806' ,`StreetSuffix` = 'Road' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the built-in luxuries and limitless interior design potential of the open and bright Laport. Your open concept floor plan features an abundance of energy-efficient windows, soaring ceilings, outdoor living space with fireplace and the versatility to adapt to your decorative style. The gourmet kitchen is designed to support culinary masterpieces and collaborative cooking adventures and includes a dine-in island and a walk in pantry. Each upstairs bedroom offers walk in closets and plenty of room to grow and personalize. Create the perfect specialty rooms for your family in the deluxe upstairs retreat and the brilliant downstairs study. Retire to your luxury master bedroom, which provides, a glamorous bathroom and an extended walk in closet. The downstairs guest suite includes a private bathroom, making it the ideal arrangement for visitors and extra residents. Welcome Home!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 2' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'PHELAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Veranda' ,`TaxAmount` = '' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641935' WHERE `Matrix_Unique_ID` = '211861426'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T06:08:33.930' ,`MLSNumber` = '7888793' ,`ListAgentFullName` = 'Kay Krampitz' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = 'Holly Sincox' ,`SellingOfficeName` = 'RE/MAX Leading Edge' ,`Latitude` = '29.795153' ,`Longitude` = '-96.108666' ,`PhotoCount` = '20' ,`PostalCode` = '77474' ,`RoomCount` = '6' ,`ListPrice` = '385000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Alvin' ,`StreetNumber` = '4071' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3/2 Custom Stone home sits on an acre in a peaceful neighborhood 5 minutes from Sealy. The front of the home has large stone columns, a circle driveway, two great covered porches and a carport. Entering thru the front door your eyes are swept up to the high ceilings, the arches, the grand stone fireplace and Tuscan style plaster walls and LVP and tile flooring.  A spacious open floor plan including the kit., dining & living area. The kitchen has beautiful granite countertops with a unique granite island.  All wood cabinets in the home are custom designed. The M. bedroom has a stone fireplace, lg closet and a bath with a double vanity, a soaking tub and walk-in rain shower. Lots of storage inside as well as the barndominium in the back.  The barn has a 2 car garage, and a 450 Sq. Ft. guest bedroom and bath.  There is a well and septic system. This home is high and dry, very little thru traffic, great neighbors and a wonderful porch to sit back and enjoy Texas sunsets.' ,`Acres` = '1' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'SAN FELIPE FOURTH ADDN ANNEX #2LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`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` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Felipe Fourth Add' ,`TaxAmount` = '6607' ,`TaxRate` = '1.9462' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641935' WHERE `Matrix_Unique_ID` = '214540758'  --> 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','214764021','1669641935','214764021','2022-11-24T06:45:57.067','35598444','Michael Ramirez','MJR Real Estate','','','29.590636','-95.234054','38','77089','9','300000.00','Active','Sagebluff','10802','Drive','Houston','2','1','4','2416','Single-Family','$$ DID NOT FLOOD IN HARVEY- $$ NO FLOOD INS REQUIRED $$ 2416 SQ. FT. SPACIOUS HOME UNDER 300K $$  * LOTS OF UPDATES * 4 BEDROOM BRICK AND VINYL SIDING HOME* ROOMY KITCHEN WITH NEW QUARTZ COUNTER TOPS, LOTS OF CABINETS* NEW STOVE AND NEW DISHWASHER* NEW WOOD LAMINATE FLOORS* NEW PORCELAIN TILE* MASTER DOWN WITH 3 BEDROOMS UP. VERY SPACIOUS FLOOR PLAN WITH FORMAL DINING AND LIVING ROOM AND BREAKFAST AREA OFF KITCHEN* WET BAR SINK OFF KITCHEN* LOTS OF CLOSET SPACE*  ROOF UPDATED* AC UPDATED* BOTH BATHROOMS ARE RECENTLY REMODELED* JUST PAINTED ALL INTERIOR AND EXTERIOR* BACK COVERED PATIO* NEW WATER HEATER* 2-NEW GARAGE DOORS *FOUNDATION REPAIRED BY LEVEL CHECK IN 2005, FULL BRICK WITH SIDING*','0.1869','3','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Owner/Agent,Sellers Disclosure','1','','1','Southbelt/Ellington','Central Gas','1','LT 1 BLK 62 SAGEMONT SEC 10','Subdivision Lot','8140','Appraisal District','','50','0','','2','Electric Oven,Freestanding Oven','0','','','Electric Range','','Composition','41 - Pasadena','FRAZIER ELEMENTARY SCHOOL (PASADENA)','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Sagemont Sec 10','4977','2.6863','Public Sewer,Public Water','1970','Appraisal District');  --> New record created successfully<br />