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-01T21:16:10.513' ,`MLSNumber` = '2726108' ,`ListAgentFullName` = 'Kenna Stephenson' ,`ListOfficeName` = 'State 28 Real Estate, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232440' ,`Longitude` = '-95.668935' ,`PhotoCount` = '30' ,`PostalCode` = '77354' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Hill' ,`StreetNumber` = '40279' ,`StreetSuffix` = 'Pass' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2972' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLERS. So many upgrades in this limited edition floor plan! 5 bedrooms (2 downstairs), 3 full baths, plus home office/study. Open concept island kitchen. In-house laundry with primary closet access. Huge game room upstairs. Storage for days - You will love storage beneath the stairs AND added attic storage / access thru game room closet!! Custom covered patio extension with no back neighbors! Shed with electricity conveys with home. Check out Mostyn Springs planned community amenities. Close proximity to Magnolia\'s newest HEB shopping plaza and excellent Magnolia ISD schools.' ,`Acres` = '0.1944' ,`Area` = '15' ,`BuilderName` = 'Gray Point / Gehan' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S733300 - MOSTYN SPRINGS SUBDIVISION 01, BLOCK 3, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Spgs Sub 01' ,`TaxAmount` = '9088' ,`TaxRate` = '3.1087' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098601' WHERE `Matrix_Unique_ID` = '213860320'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T21:51:51.490' ,`MLSNumber` = '42716703' ,`ListAgentFullName` = 'Saahir Ramji' ,`ListOfficeName` = 'Beacon Real Estate Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792327' ,`Longitude` = '-95.459781' ,`PhotoCount` = '32' ,`PostalCode` = '77055' ,`RoomCount` = '3' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Clarkson' ,`StreetNumber` = '6106' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Story townhome with a 4th floor roof deck with views of the Houston skyline and downtown. The house has 3 bedrooms and 3.5 bathrooms. The living room, kitchen, and dinning rooms are on the 2nd floor. Plenty of sunlight. The home has recently been repainted and new carpet has been installed in the bedrooms. ' ,`Acres` = '0.0455' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 MAYFAIR AT CLARKSON' ,`LotDesciption` = 'Other' ,`LotSize` = '1982' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Mayfair/Clarkson Reserves A &' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098601' WHERE `Matrix_Unique_ID` = '214084735'  --> 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','214827970','1675098601','214827970','2023-01-01T22:40:34.100','55921958','William Benton','Rose-Rich Realty','','','29.554111','-95.815165','24','77471','7','269900.00','Active','Frost','1317','Street','Rosenberg','2','0','3','1527','Single-Family','Beautiful 3 bedroom 2 bath home on large corner lot in a quiet and older, established neighborhood.  No HOA, no MUD taxes, no deed restrictions.  Oversized 24\' x 34\' 6\"  3 car garage.  Additional 12\' x 14\' Storage Building.  Fenced backyard with mature trees for shade.  Large kitchen with appliances (stove, dishwasher, side by side fridge stay).  Extra room with utility area (washer stays). Ready to move in and enjoy for the holidays.  New paint and floor.  Primary bath has new walk-in shower.  Minutes from Highway 59 for commuting, shopping, etc.  Many churches in the area to choose from. Please contact us with any questions or to make an appointment to see this property.','0.1983','30','','','Electric Dryer Connections','','Sellers Disclosure','1','','','Fort Bend South/Richmond','Central Electric,Central Gas','0','ALLENDALE MANOR, BLOCK 3, LOT 5','Corner','8640','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Cooktop','','Composition','33 - Lamar Consolidated','BOWIE ELEMENTARY SCHOOL (LAMAR)','TERRY HIGH SCHOOL','NAVARRO/GEORGE JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Appraisal District','1','Other Style','Allendale Manor','3530','2.0748','Public Sewer,Public Water','1960','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','215980370','1675098601','215980370','2023-01-01T21:44:42.737','35509997','Kristi Graham','Realty Associates','','','29.723237','-95.446970','12','77005','2','749998.00','Active','Dartmouth','4260','Avenue','West University Place','1','0','2','1287','Single-Family','Rare opportunity to own/build new in highly coveted West University Place. Corner lot with no flooding during Harvey, perfectly positioned on quiet street offering all the amenities of this central neighborhood; known as \"The Neighborhood City.\" Great location zoned to West University Elementary (Buyer to verify eligibility). House is livable but property is being sold for lot; house in its present condition. New construction throughout neighborhood. Come join family friendly West University, which includes International Baccalaureate schools, short walk or bike ride to Tiny\'s, Milk & Cookies, little league, parks, pool, recreation center and tennis. Minutes to the world renowned Texas Medical Center, Galleria and Downtown with low HISD tax rates.  All measurements & information approximate, please independently verify, all per Seller.','0.1148','17','','','','','Sellers Disclosure','','','','West University/Southside Area','Central Gas','0','LT 30 BLK 9 COLLEGE COURT PLACE','Corner,Subdivision Lot','5000','Appraisal District','','','0','','2','','0','','','','','Composition','27 - Houston','WEST UNIVERSITY ELEMENTARY SCHOOL','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','No Supra Keybox','Appraisal District','1','Traditional','College Court Place','9332','2.2589','Public Sewer,Public Water','1945','Appraisal District');  --> New record created successfully<br />