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` = '2022-08-13T20:41:19.180' ,`MLSNumber` = '62382354' ,`ListAgentFullName` = 'Mike Morrison' ,`ListOfficeName` = '101 Main St. Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.914967' ,`Longitude` = '-95.285649' ,`PhotoCount` = '36' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Timber Bay' ,`StreetNumber` = '284' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1632' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Timber Bay is an excellent subdivision. One street allows manufactured home and the other two streets do not. Roads are asphalt and paved. Timber Bay is located on Lake Livingston and has boat ramp and long pier for fishing or relaxing!! Home is on 6.5 lots which is 2.75 acres Beautifully landscaped with large oak trees. ..The interior has been repainted and there was wall paper in couple rooms and that has been taken off. There are 3 septic tanks, 2 for the restrooms and 1 for kitchen with a total of 300 feet of field lines. All tanks have recently been pumped and cleaned. There is double thick flooring with 3/4 plywood screwed down (not nailed) to prevent squeaking. All windows are double paned, gas filled storm windows. All interior walls are insulated for sound reduction. Custom hard wood millwork and trim throughout. Double the industry standard number of electrical outlets installed during original construction' ,`Acres` = '2.7551' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TIMBER BAY, LOT 179-181, LOT 182 N 1/2 OF, LOT 231-233' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '120000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '290' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (TRINITY)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Bay' ,`TaxAmount` = '3573' ,`TaxRate` = '1.8863' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698200' WHERE `Matrix_Unique_ID` = '206323023' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T20:40:15.487' ,`MLSNumber` = '92931435' ,`ListAgentFullName` = 'Keith Guillory' ,`ListOfficeName` = 'Guillory Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818407' ,`Longitude` = '-95.387577' ,`PhotoCount` = '7' ,`PostalCode` = '77022' ,`RoomCount` = '2' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Delhi' ,`StreetNumber` = '3505' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sold for Lot value! Nice 60x100 Lot.' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 3 & 4 BLK 5 LINCOLN HEIGHTS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lincoln Heights' ,`TaxAmount` = '3331' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698201' WHERE `Matrix_Unique_ID` = '210885671' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T21:12:26.367' ,`MLSNumber` = '59063430' ,`ListAgentFullName` = 'Rita Chanchlani' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579774' ,`Longitude` = '-95.549198' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Creek' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique and one of a kind patio home. Very spacious and open with all upgrades. Granite in kitchen, tile and wood floors, built in appliances, crown molding, four bedrooms, walk in closet in master. Huge living and dining room. Lead glass door. Gas cooktop. No carpet in the house. Two car garage with Golf cart parking too. Come see this beautiful home. The backyard is a wrap around the house but the previous owners fenced off a section for their dog. Has gates to the backyard on both sides of the house' ,`Acres` = '0.1571' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY PATIO HOMES, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '6843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1047' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Quail Valley Patio Homes' ,`TaxAmount` = '5601' ,`TaxRate` = '2.4603' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698201' WHERE `Matrix_Unique_ID` = '210935916' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T20:00:41.957' ,`MLSNumber` = '95240359' ,`ListAgentFullName` = 'Richard Boehck' ,`ListOfficeName` = 'Boehck Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.830027' ,`Longitude` = '-95.490527' ,`PhotoCount` = '16' ,`PostalCode` = '77092' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Clemson' ,`StreetNumber` = '6638' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom one bath. House is close to freeway and close to galleria area shopping.' ,`Acres` = '0.1792' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 22 BLK 17 LANGWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7808' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BENBROOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Langwood Sec 01' ,`TaxAmount` = '3429' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698201' WHERE `Matrix_Unique_ID` = '211402318' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T21:08:15.820' ,`MLSNumber` = '81692666' ,`ListAgentFullName` = 'Crystal Hernandez' ,`ListOfficeName` = 'ST Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.163106' ,`Longitude` = '-97.014428' ,`PhotoCount` = '25' ,`PostalCode` = '78382' ,`RoomCount` = '3' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Palmetto Point' ,`StreetNumber` = '520' ,`StreetSuffix` = 'Road' ,`City` = 'Rockport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1318' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further! This home is ready for the Summer! It\'s fully furnished and suitable as a vacation rental. Views of the Bay as well as the canal makes it feel relaxing. Home features 3 bedrooms, 2 baths on a double lot size, and a storage room downstairs. One owner and single person occupied shows how well it\'s been kept up with. Call now before it is gone and schedule a tour.' ,`Acres` = '0.2296' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HOLIDAY BEACH NEWCOMB BEND, LOT 25 & 26' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '10001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Holiday Beach Newcomb Bend' ,`TaxAmount` = '2341' ,`TaxRate` = '1.3696' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698201' WHERE `Matrix_Unique_ID` = '211403615' --> Updated record success