Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T21:40:21.093' ,`MLSNumber` = '64258158' ,`ListAgentFullName` = 'Clarissa Castleberry' ,`ListOfficeName` = 'Surge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789151' ,`Longitude` = '-95.407170' ,`PhotoCount` = '27' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '1174000.00' ,`Status` = 'Active' ,`StreetName` = 'Lawrence' ,`StreetNumber` = '1009' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 1009 Lawrence; a thoughtfully designed 2-story home with a detached 2 car garage, on a large 6k lot in the heights! As you enter this craftsman style home you are greeted by the formal dining area and the office. The heart of the home boasts a large, open, airy kitchen with a butlers pantry, a walk-in pantry, and plenty of cabinetry. The family room features high ceiling, an electric fireplace, and a nice view of your backyard. A 2nd living area awaits at the top of the 2nd floor. The private primary suite has lots of windows, a large en suite bath, and a spacious walk-in closet that leads to the Utility room. Customization of the interior of this home is still available! Make this home yours today! Built by Forthright Construction- Mid-End January completion!*SELLER CAN CONTRIBUTE TO LOWER RATE*' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = 'Forthright Constr.' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 7 WEST HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'West Heights' ,`TaxAmount` = '9433' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101238' WHERE `Matrix_Unique_ID` = '211144226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-03T21:48:57.173' ,`MLSNumber` = '52712774' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Princeton Classic Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.535050' ,`Longitude` = '-95.675051' ,`PhotoCount` = '43' ,`PostalCode` = '77469' ,`RoomCount` = '10' ,`ListPrice` = '534990.00' ,`Status` = 'Active' ,`StreetName` = 'Noble Cypress' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Greatwood Lake in Richmond, TX! The Garner floor plan is a stunning 2-story home with soaring ceilings in the foyer and family room! This home has it all - 5 bedrooms, 3.5 bathrooms, formal dining room, study, game and flex/media room, AND a 3-car garage! You\'ll love all of the designer features, including a fire place and under cabinet lighting! The gourmet kitchen is sure to please with 42\" cabinetry, granite countertops, and and stainless steel appliances! Retreat to the Owner\'s Suite featuring a beautiful bay window, separate tub and mudset shower, and a spacious walk-in closet. Enjoy the great outdoors with a sprinkler system and covered patio! Don\'t miss your opportunity to call Greatwood Lake home, schedule a visit today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Princeton Classic' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend Southeast' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 2 Section 2B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9865' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'VELASQUEZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greatwood Lake' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675101238' WHERE `Matrix_Unique_ID` = '213236241' --> Updated record success
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','215434261','1675101238','215434261','2023-01-03T22:24:16.777','25723735','Cristian Samayoa','eXp Realty, LLC','','','29.582774','-96.321924','49','77434','2','57000.00','Active','State','1402','Street','Eagle Lake','1','0','2','760','Single-Family','Property sold as-is, sight unseen.','0.097','56','','','','','Other Disclosures,Sellers Disclosure','','','','','No Heating','0','BLK 1 LT 1 PUTNEY-ROOS EAGLE LAKE & HOUSE','Other','4224','Appraisal District','','','0','','0','','0','','','','','Composition','161 - Rice Consolidated','EAGLE LAKE INTERMEDIATE SCHOOL','RICE HIGH SCHOOL (RICE CISD)','RICE JUNIOR HIGH SCHOOL (RICE CISD)','Temporarily No Showings','Appraisal District','1','Other Style','Putney-Roose','618','2.5343','Public Sewer','1975','Seller'); --> New record created successfully
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','215682182','1675101238','215682182','2023-01-03T21:43:33.140','4667906','Bradley Tiffan','Princeton Classic Homes','','','29.534946','-95.674934','42','77469','8','509990.00','Active','Millstone Trail','7738','Lane','Richmond','3','1','4','2727','Single-Family','Love where you live in Greatwood Lake in Richmond, TX! The Valiant floor plan is a stunning 2-story home featuring 4 bedrooms, 3.5 bathrooms, game room, study, AND 3-car garage! This home includes ALL of the designer finishes you\'ve been looking for with its modern interior selections! The gourmet kitchen is sure to please with a large island, 42\" cabinetry, granite countertops, and stainless steel appliances! Retreat to the Owner\'s Suite featuring double sinks, separate tub and shower, and a walk-in closet. Enjoy the great outdoors with a large covered patio and sprinkler system! Don\'t miss your opportunity to call Greatwood Lake home, schedule a visit today!','','30','Princeton Classic','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','0','Fort Bend Southeast','Central Gas','1','Lot 32 Block 1','Subdivision Lot','7857','Survey','','775','1','Never Lived In','3','Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','33 - Lamar Consolidated','VELASQUEZ ELEMENTARY SCHOOL','GEORGE RANCH HIGH SCHOOL','RYON/READING JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Greatwood Lake','','3.32279','Water District','2022','Builder'); --> New record created successfully
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','215979735','1675101238','215979735','2023-01-03T21:28:46.897','7739754','Deborah Freeman','Freeman Properties Group, LLC','','','29.922690','-93.928384','20','77642','9','110000.00','Active','Rosedale','3021','Drive','Port Arthur','2','0','2','1871','Single-Family','Great Starter /Investment home with a highly motivated seller. Has an upstairs room that could be 3rd bedroom. The home Is located on an oversized lot in a family-oriented neighborhood. Has a great kitchen that opens up to a large family room. A very large primary bedroom with a large primary bathroom. Has a very relaxing atmosphere with a fireplace. There is a wooden deck and a fenced-in backyard. Needs a little TLC to make it perfect. Give me a call MOTIVATED SELLER! Great Investment property OR A cozy starter home, 2/2 possible 3 home in Griffin Park. Has lots of potential with lots of living space. Large den to enjoy family gatherings while mom cooks in the connected kitchen. Wooden deck to enjoy the family. Exposed wooden beams in the ceiling den add a nice touch to make a warm atmosphere. Freshly painted and an oversized Primary bedroom with a large primary bathroom. Older home with larger rooms. It is a perfect starter home. It sits on an oversized lot.','0.2101','51','','','','','No Disclosures,Sellers Disclosure','','','','','Central Gas','0','LT 17 BLK 50 GRIFFING RES PARK','Subdivision Lot','9150','Appraisal District','','','0','','2','','0','','','','','Composition','236 - Port Arthur','TYRRELL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)','Appointment Required,Lockbox Back','Appraisal District','1','Contemporary/Modern,Traditional','Griffing Residential Park','2877','3.176','Public Sewer,Public Water','1962','Appraisal District'); --> New record created successfully