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-09-14T05:53:35.517' ,`MLSNumber` = '31259221' ,`ListAgentFullName` = 'Liliana Lagou' ,`ListOfficeName` = 'Ameri Choice Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736320' ,`Longitude` = '-95.872916' ,`PhotoCount` = '15' ,`PostalCode` = '77494' ,`RoomCount` = '5' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Daintree Park' ,`StreetNumber` = '3606' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS BEAUTIFUL HOUSE FEATURES ,5 BEDROOM,3.5 BATHROOMS AND TWO CAR GARAGE IS SITTING IN A PREMIUM  LOT (CULDE-SAC),HIGH CEILINGS, FORMAL DINING ROOM, UPGRADED KITCHEN CABINETS AND GRANITE COUNTER TOPS  WITH SPACIOUS OPEN BREAKFAST BAR OPENS UP TO THE FAMILY ROOM, BREAKFAST AREA, DOWNSTAIRS MASTER BEDROOM WITH EXECUTIVE BATH AND LARGE WALK IN CLOSET,LARGE  GAMEROOM UPSTAIRS WITH 4 BEDROOMS WITH CONVENIENT JACK AND JILL BATHROOMS. TAMARRON OFFERS STATE OF THE ART GYM FACILITY WITH A RESORT STYLE POOL. THE COMMUNITY HAS A FARMERS MARKET EVERY SATURDAY!\r\nEASY TO SHOW NOW! MAKE AN APPOINTMENT TO TOUR THIS GEM NOW! LE INVITAMOS A QUE LLAME PARA UNA VISITA A LA PROPIEDAD Y VEA ESTA BELLEZA LISTA PARA MOVERSE YA!' ,`Acres` = '0.2069' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 4, BLOCK 1, LOT 26' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9014' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 4' ,`TaxAmount` = '10151' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710366' WHERE `Matrix_Unique_ID` = '209714350'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T05:28:09.447' ,`MLSNumber` = '65613580' ,`ListAgentFullName` = 'Carol Knott Tefft' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.119682' ,`Longitude` = '-95.385747' ,`PhotoCount` = '24' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '348000.00' ,`Status` = 'Active' ,`StreetName` = 'Legends Line' ,`StreetNumber` = '29422' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Roomy, functional, fresh are words that will instantly come to mind when you step into this home. Your front porch invites you to relax, meet your neighbors and enjoy the place you call home. One of the largest floor plans in Legends Run, it features all bedrooms up with ample space for all!  This home offers an open floor plan with three living areas and 4 spacious bedrooms. Primary bedroom suite includes separate shower and tub! Granite countertops in kitchen, tile floors.  Nice sized yard with room for your pet, trampoline or addition of a pool. Owner replaced carpet, refrigerator,  and had home painted July 2022! Also The community of Legends Run is perfectly located near the Grand Parkway offering an easy commute to almost anywhere! Recently established restaurants, shopping, and other amenities are only a stone\'s throw away. Near The Woodlands and zoned to award winning Conroe ISD schools, this home could be just the place for you!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688207 - LEGENDS RUN 07, BLOCK 3, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5480' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '490' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Run 07' ,`TaxAmount` = '5891' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710367' WHERE `Matrix_Unique_ID` = '210387736'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-14T05:31:36.940' ,`MLSNumber` = '62105804' ,`ListAgentFullName` = 'Deborah Ehlert' ,`ListOfficeName` = 'Deborah Ehlert' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.208044' ,`Longitude` = '-96.287906' ,`PhotoCount` = '50' ,`PostalCode` = '77437' ,`RoomCount` = '14' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lane' ,`StreetNumber` = '2601' ,`StreetSuffix` = 'Lane' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious, traditional 4 bedroom, 2.5 bath brick home sits on an almost 3/4 acre corner lot in a sought-after neighborhood. Home is in walking distance to the El Campo Aquatic Center and just blocks from 2 elementaries.  ECHS is within walking distance as well. Gorgeous, covered patio looks out over a paver patio with mature Live Oaks providing shade. Primary bedroom has a separate door to the patio, as well as a connecting door into one of the 3 guest bedrooms, making that bedroom a perfect home office or nursery arrangement. The huge Family Room and formal Entry Hall are paved with unique stone flooring. The Family Room boasts a large window seat flanked by built-in bookcases. A gas fed, wood burning fireplace sits next to the library area. Formal Dining Room features a chandelier and wainscot trim work connecting to the Formal Living Room and Entry Hall, also lit by a chandelier. Oversized, double car garage has a sink and workshop. Roof is 1 yr. old. 8X8 storage. Sprinkler sys.' ,`Acres` = '0.7438' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TOWN & COUNTRY EST. BLOCK 3 LOT 14' ,`LotDesciption` = 'Corner' ,`LotSize` = '32400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Town & Country Estate' ,`TaxAmount` = '9243' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663710367' WHERE `Matrix_Unique_ID` = '211534927'  --> 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','212459995','1663710367','212459995','2022-09-14T04:49:50.657','37270821','Amy Kershner','RE/MAX Space Center','Christina Harris-Bussard','RE/MAX Space Center-Clear Lake','29.514149','-95.061496','6','77573','8','399000.00','Option Pending','Maresca','943','Lane','League City','2','1','4','2305','Single-Family','Welcome to this great home in Tuscan Lakes. It is located on a corner lot of a cul-de-sac. Enjoy the outdoors under a covered patio and a beautiful pool with hot tub. Open floor plan with beautiful features throughout.  Enjoy a downstairs study or convert to formal dining room. The 3 car garage allows for plenty of parking space. Zoned to highly rated Clear Creek ISD schools.','0.1751','33','','','','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','League City','Central Electric,Central Gas','1','TUSCAN LAKES SEC SF 55-4-1 (2010) ABST 18, BLOCK 1, LOT 1, A','Corner,Cul-De-Sac,Subdivision Lot','7629','Appraisal District','','600','0','','3','','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','9 - Clear Creek','GOFORTH ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','LEAGUECITY INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Tuscan Lakes Sec Sf 55-4-1','8132','2.6697','Public Sewer,Public Water','2011','Appraisal District');  --> New record created successfully<br />