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-12T05:55:13.047' ,`MLSNumber` = '7387148' ,`ListAgentFullName` = 'Katy Pugh' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005014' ,`Longitude` = '-96.279986' ,`PhotoCount` = '46' ,`PostalCode` = '77418' ,`RoomCount` = '9' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'High Meadows' ,`StreetNumber` = '460' ,`StreetSuffix` = 'Road' ,`City` = 'Bellville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A stunning custom stone home located in Piney Creek built by highly reputable Willmark Custom Homes, nestled back in privacy on a meticulously manicured 6 acre lot scattered with beautiful trees.\r\nSuch a great floorplan:  Open living, kitchen and dining, primary bedroom separated from guest rooms, office, media or 2nd living room, utility room, 2 car garage, & large covered back porch with cedar pergola.\r\nGranite counters throughout home, walls of windows, crown molding, wood look tile plank flooring, & high ceilings.  \r\n2 metal buildings located at rear of property.  The larger building is 50\'x63\' insulated & wood framed, 200 amp service, piped for compressed air, 6 roll up doors, special LED commercial lighting, work benches & shelving.\r\n2nd building is 30\'x40\' steel framed with work benches & shelving, 2 roll up doors, & 40\'x16\' lean to.  \r\nRecent improvements include pipe fencing & automatic gate at front of property, concrete drive with extended parking and perimeter fencing.' ,`Acres` = '5.923' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'PINEY CREEK SUB SECT I LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '258006' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Creek Sub' ,`TaxAmount` = '11911' ,`TaxRate` = '1.8096' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675128691' WHERE `Matrix_Unique_ID` = '210281974'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T06:46:27.300' ,`MLSNumber` = '89591498' ,`ListAgentFullName` = 'Andrea Cooksey' ,`ListOfficeName` = 'Exit Realty 360' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773980' ,`Longitude` = '-95.406977' ,`PhotoCount` = '32' ,`PostalCode` = '77007' ,`RoomCount` = '10' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Maxie' ,`StreetNumber` = '4517' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Back on market A Listing with options prime location minutes from Downtown sport venues, Memorial Park Houston Galleria, Local neighborhood restaurants, sprawling new development all around. This cute historical cottage  2 plus a study  or 3 bedroom 2 full baths updated kitchen, hardwood floors and a great back yard. Or it is your perfect development spot to create your own new paradise in a prime location. Room dimensions are approx. Owner finally decided to sell so hurray location location location one of the few last full home sites in the area.' ,`Acres` = '0.1171' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 8 & 9 BLK 84 BRUNNER' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunner' ,`TaxAmount` = '6654' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675128691' WHERE `Matrix_Unique_ID` = '210608427'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-12T06:13:56.433' ,`MLSNumber` = '11316616' ,`ListAgentFullName` = 'Angela Seff' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014587' ,`Longitude` = '-95.152119' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Spoonwood' ,`StreetNumber` = '20310' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4177' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Located on Hole 6 of Atascocita Golf Club\'s Pinehurst course you will find this beautifully updated home. You won’t be lacking for space with 5 bedrooms 3 full and 2 half baths on a cul-de-sac lot in highly acclaimed Humble ISD. Updates throughout including marble and stone countertops, hand scraped wood floors, new carpet in all rooms and on both staircases. Primary bedroom located on the first floor with his and hers cedar closets, walk in shower, double sinks and separate soaking tub. Direct access to the large sunroom from the primary bedroom. Large home office located on the first floor. Wet bar directly off the living room as well as an additional wet bar in the large game room upstairs. To top it off there’s an oversized 3 car garage!' ,`Acres` = '0.3014' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 12 PINEHURST OF ATASCOCITA SEC 2' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course,Subdivision Lot' ,`LotSize` = '13130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PINEFOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinehurst of Atascocita' ,`TaxAmount` = '8995' ,`TaxRate` = '2.216' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675128692' WHERE `Matrix_Unique_ID` = '212235456'  --> 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','215954177','1675128692','215954177','2023-01-12T06:40:07.857','68636844','Tracy Montgomery','Keller Williams RealtyNortheast','','','29.947693','-95.140167','49','77532','7','599900.00','Active','Shore Shadows','3403','Drive','Crosby','3','1','4','3944','Single-Family','Custom built home w/ wrap around porch & that has a 3 car oversized garage & separate guest suite. Guest suite has living area, sink,fridge bedroom w/washroom & full bath.Sits on huge corner lot w/an extra lot & no back neighbors.Home is close to creek that feeds to Lake Houston & boat ramp is in walking distance. Huge master suite has spacious en-suite & an extra sitting room with fireplace. Master bath offers separate shower, jetted tub, his/her sinks, vanity, & custom closet w/built-ins Chefs dream island kitchen w/SS appliances, breakfast bar, ton of cabinet/counter space for storage. Huge breakfast are that has double fireplace between den. Large family room w/gas fireplace & high ceilings. Secondary bedrooms/closets with custom built ins complete the home.Pool sized backyard has large, extended covered patio that has gas grill hook-up and outdoor lighting. Other features include: 3 ACs, handicap accessible, & study w/glass doors. Make an appointment today, this home will go fast.','0.7972','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','2','Crosby Area','Central Gas','1','RES B LAKE SHADOWS SEC 1','Corner,Subdivision Lot','34725','Appraisal District','','250','0','','3','Gas Oven','0','','','Gas Cooktop','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','1','Traditional','Lake Shadows','17031','2.6843','Water District','2015','Appraisal District');  --> New record created successfully<br />