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-04T05:34:20.603' ,`MLSNumber` = '74828264' ,`ListAgentFullName` = 'Kirsstien Delossantos' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.288585' ,`Longitude` = '-95.736492' ,`PhotoCount` = '12' ,`PostalCode` = '77430' ,`RoomCount` = '5' ,`ListPrice` = '181999.00' ,`Status` = 'Active' ,`StreetName` = 'Commerce' ,`StreetNumber` = '3815' ,`StreetSuffix` = '' ,`City` = 'Damon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled house looking for new owners! House has new roof, electrical, A/C, a brand new farmhouse kitchen with new appliances! Plus it\'s conveniently located close to HWY 36, area is growing and expanding. Home sits on a spacious lot with mature trees, great for an outdoor family event or just to relax. No HOA! Buyer to verify all measurements and do it’s own due diligence. Schedule to tour this property today! ' ,`Acres` = '0.3099' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RR (DAMON) BLK 5 LOT 8-9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '14 - Damon' ,`SchoolElementary` = 'DAMON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAMON HIGH SCHOOL' ,`SchoolMiddle` = 'DAMON ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rr Damon' ,`TaxAmount` = '919' ,`TaxRate` = '1.5443' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587715' WHERE `Matrix_Unique_ID` = '211701920'  --> 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','213616426','1667587716','213616426','2022-11-04T04:28:37.210','14928964','Kyle Tweed','Compass RE Texas, LLC','','','30.405993','-95.658990','33','77356','12','1065000.00','Active','Grand Pine','11427','Drive','Montgomery','4','0','5','4836','Single-Family','Within the gated and sought after community of Grand Harbor, this gorgeous waterfront estate boasts 5+ bedrooms and 4 bathrooms along with a 20ft. foyer and ceilings in living area. Open feel throughout all of the bedrooms and kitchen will leave you wanting to entertain! Impressive kitchen appliances including a double French door convection oven that will handle family holidays with ease. Beautiful Shaw carpet throughout the bedrooms, expansive closets, upstairs, and game room. Out back, you can enjoy your screened-in porch, or hop in the salt water pool and spa. Feeling adventurous? Head on down to your very own boat dock(boat lift and 2 jet ski lifts) and do some fishing, or take a boat ride to any of the wonderful restaurants Lake Conroe has to offer..sunsets included. 3 car garage. BRAND NEW roof. 2 new water heaters. 2 new A/C units. Grand Harbor includes: community boat ramp, volleyball,basketball,tennis courts, baseball field, covered pavilion. AMAZING Montgomery schools.','0.489','39','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Lake Conroe Area','Central Gas','1','GRAND HARBOR 06, BLOCK 1, LOT 13','Subdivision Lot,Water View,Waterfront','21301','Appraisal District','','1200','0','','3','Convection Oven,Electric Oven','1','Gunite,In Ground,Salt Water','','Gas Cooktop,Gas Range','','Composition','37 - Montgomery','MADELEY RANCH ELEMENTARY SCHOOL','MONTGOMERY HIGH SCHOOL','MONTGOMERY JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','2','Mediterranean,Traditional','Grand Harbor 06','12526','1.8242','Aerobic,Other Water/Sewer,Septic Tank','2006','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','214141168','1667587716','214141168','2022-11-04T04:30:11.807','9392877','Ryan Adams','Compass RE Texas, LLC','','','29.473756','-95.524565','49','77459','10','759900.00','Active','Orchard','9419','Trail','Missouri City','4','1','5','3856','Single-Family','**OPEN HOUSE - SAT 2-4, SUNDAY 12-2** Marvelous and Chic home in Sienna! Located on a picturesque lot, this almost NEW, 5BR/4.5BA, 3,856 sqft abode enthralls with a stucco and stone detailing, fully fenced-in backyard, and tidy landscaping. Built by Perry Homes, the impressive interior has an open floorplan, wood style luxury vinyl plank flooring throughout, soaring vaulted ceilings, and tons of shimmering natural light. Explore further to find an open-concept kitchen with stainless-steel appliances, sleek  countertops, pantry, and a center island w/seating! Sleep easy in the master bedroom, which includes a walk-in closet and an enviable en suite w/soaking tub. Bask in an active community clubhouse with a golf course, tennis court, gym, playground, and swimming pool. Enjoy your backyard with a Fully screened in patio with porcelain tile floor. Other features: 3-car garage, loft, laundry room, media room, close to shopping, highways, and highly rated schools!','0.2238','38','Perry','','','','Mud,Sellers Disclosure','1','','','Sienna Area','Central Gas','1','SIENNA PLANTATION SEC 33-A, BLOCK 1, LOT 5, (28% IN R52)','In Golf Course Community','9747','Appraisal District','','1307','0','','3','','0','','','','','Composition','19 - Fort Bend','LEONETTI ELEMENTARY SCHOOL','RIDGE POINT HIGH SCHOOL','THORNTON MIDDLE SCHOOL (FORT BEND)','Appointment Required,Supra Keybox','Appraisal','2','Traditional','Sienna','13819','3.1629','Public Sewer,Public Water,Water District','2020','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','214237415','1667587716','214237415','2022-11-04T05:47:13.763','93834520','Anderson Tolosa','Keller Williams Premier RealtyKaty','','','29.946837','-95.993705','18','77484','4','280000.00','Active','Morgan','35340','Road','Waller','2','0','3','1216','Single-Family','LOCATION!! LOCATION!! 1.26 acres FULLY FENCED. Close to  I-10 or 290.  Single Wide mobile home. Find an excellent floor plan. Primary bath counts with a jet tub, separate shower, and double sinks. laminate floor throughout. Spacious bedrooms kitchen, and Livingroom. Possibilities are endless with a large extra 24x32 independent apartment building. Ready to perform your projects? find a huge warehouse storage with INDEPENDENT power 220V.    \r\n\r\nCall to schedule your appointment today!','1.268','26','','','','','Other Disclosures','','','','Hempstead','Central Electric','0','ABS A329600 A-296 T W DAW,TRACT 4-3,ACRES 1.268,SN1 OC010718','Corner','55234','Appraisal District','','','0','','0','','0','','','','','Aluminum','24 - Hempstead','HEMPSTEAD ELEMENTARY SCHOOL','HEMPSTEAD HIGH SCHOOL','HEMPSTEAD MIDDLE SCHOOL','Accompany,Supra Keybox','Appraisal District','1','Traditional','Other','1895','1.8575','Septic Tank,Well','2007','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-04T05:22:05.490' ,`MLSNumber` = '23025499' ,`ListAgentFullName` = 'Willie Harris' ,`ListOfficeName` = 'Keyhole Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.900989' ,`Longitude` = '-94.736545' ,`PhotoCount` = '32' ,`PostalCode` = '75934' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Community' ,`StreetNumber` = '1097' ,`StreetSuffix` = 'Drive' ,`City` = 'Camden' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2 bath home located on 10.75 Acres.  A get away from the noisy life of the city. Separate  Workshop for the creative person. You will have to come and see to appreciate this listing.' ,`Acres` = '10.75' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 284 JNO HAVILAND SURVEY TRACT 2A' ,`LotDesciption` = 'Cleared' ,`LotSize` = '468270' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '238 - Corrigan-Camden' ,`SchoolElementary` = 'CORRIGAN-CAMDEN PRIMARY/ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CORRIGAN-CAMDEN HIGH SCHOOL' ,`SchoolMiddle` = 'CORRIGAN-CAMDEN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Corrigan' ,`TaxAmount` = '1144' ,`TaxRate` = '1.7144' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667587716' WHERE `Matrix_Unique_ID` = '214305658'  --> Updated record success<br />