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-08T05:45:52.483' ,`MLSNumber` = '51203361' ,`ListAgentFullName` = 'Jackson Mathew' ,`ListOfficeName` = 'Land & Luxe Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.557715' ,`Longitude` = '-95.562211' ,`PhotoCount` = '50' ,`PostalCode` = '77459' ,`RoomCount` = '11' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Belmont Shore' ,`StreetNumber` = '3631' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3644' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderfully Updated Two-Story Home with No-Back Neighbors! Situated in a desirable area with tranquil water views, this 4BR/2.5BA residence fabulously charms with a gorgeous brick façade, manicured landscaping, and a grand covered entryway. Fashioned for modern lifestyles, the interior features high foyer ceilings, beautiful hardwood and laminate floors, an openly flowing floorplan, and a great room w/fireplace. Semi-open for easy entertaining, the kitchen features granite counters, brand-new dishwasher, gas range, and pantry. Gather with guests in the oversized fenced backyard, which has a covered patio and plenty of room for a pool. Rest in the primary bedroom with an enormous closet and an en suite boasting a soaking tub, dual sinks, and shower. Other features: 2-car garage, laundry area, no carpet, game room, extra-large media room w/closet, formal dining room, Brand new ROOF,new water heater (2022), 2 newer A/Cs (2018 or newer) & sprinkler system...near shops, and much more!' ,`Acres` = '0.2571' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLONY LAKES SEC 8, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '11199' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '595' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'AUSTIN PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Colony Lakes Sec 8' ,`TaxAmount` = '10848' ,`TaxRate` = '3.16' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708096' WHERE `Matrix_Unique_ID` = '210658514'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T05:44:54.977' ,`MLSNumber` = '41173244' ,`ListAgentFullName` = 'M\'Lissa Wilkinson' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.598314' ,`Longitude` = '-95.551023' ,`PhotoCount` = '50' ,`PostalCode` = '77358' ,`RoomCount` = '10' ,`ListPrice` = '825000.00' ,`Status` = 'Active' ,`StreetName` = 'Brahman' ,`StreetNumber` = '168' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Imagine being on vacation every single day!Texas Grand Ranch is a premier gorgeous community with rolling hills, trees & creeks.This stunning custom home is located on a quiet street with easy access in & out of the community.The builders attention to detail is superb!Soaring ceilings, open floor-plan,large island kitchen is a chefs dream with all the custom cabinet details,HUGE laundry room with sink & work station, large secondary bedrooms with custom cabinets in the closets, 2 fireplaces, mud area, wine/coffee bar, book-shelf with a hidden storage area & so much more! Retreat from the busy city to this stunning country getaway! The low tax rate is truly exceptional! Exceptional New Waverly school district. 30 minutes to the woodlands & 34 to IAH. Easy access in & out of he neighborhood.' ,`Acres` = '2' ,`Area` = '43' ,`BuilderName` = 'Soarin\' Signature' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'New Waverly Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'I TEXAS GRAND RANCH PHASE 8, BLOCK 30, LOT 32, ACRES 2.' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '105 - New Waverly' ,`SchoolElementary` = 'NEW WAVERLY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEW WAVERLY HIGH SCHOOL' ,`SchoolMiddle` = 'NEW WAVERLY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Texas Grand Ranch' ,`TaxAmount` = '1397' ,`TaxRate` = '1.8438' ,`WaterSewer` = 'Aerobic,Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708096' WHERE `Matrix_Unique_ID` = '210892723'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T04:16:29.103' ,`MLSNumber` = '71786830' ,`ListAgentFullName` = 'Mike Bloom' ,`ListOfficeName` = 'Mike Bloom Properties, LLC.' ,`SellingAgentFullName` = 'Courtney Bullard' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.701673' ,`Longitude` = '-95.412181' ,`PhotoCount` = '42' ,`PostalCode` = '77030' ,`RoomCount` = '8' ,`ListPrice` = '1150000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Glen Haven' ,`StreetNumber` = '2325' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3088' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Architectural integrity abounds within this captivating Tudor manor + garage apartment. Each well-proportioned character-filled room will make you want to live amidst the rich solid wood floors, arched doorways, plank ceilings with rough hewn beams, leaded glass, dramatic lighting, and cozy window seats overlooking the manicured rear yard. Sensitive additions blend seamlessly with the original while also incorporating many fresh modern elements.  The sophisticated kitchen, luxurious primary bath, and enormous (approx. 13\' x 10\' 4\") walk-in primary closet with a center island and an auxiliary closet are unexpected bonuses.  Prime location in the heart of the neighborhood just West of the Texas Medical Center.' ,`Acres` = '0.2385' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Heat Pump,Window Unit,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRACT 7 BLOCK 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10388' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Braeswood' ,`TaxAmount` = '22315' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708096' WHERE `Matrix_Unique_ID` = '211332306'  --> 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','212202287','1663708096','212202287','2022-09-08T04:59:24.077','70805631','Tereana Ottis','Woolson Real Estate, Inc','','','28.414099','-96.478122','46','77982','9','1200000.00','Active','Coastal Springs','195','Springs','Port O Connor','4','1','4','3368','Single-Family','REMARKABLE home in gated community - ELEVATOR , Courtyard, 2 outdoor fireplaces, wrought iron fenced backyard and sprinkler system. BEAUTIFUL HOME - OPEN concept, HIGH CEILINGS up to 24\' , Kitchen for a gourmet cook, Wine Closet, Granite Counters throughout, Office, Game room, Laundry room 1st floor & washer/dryer in Master closet 2nd floor. Oversized garage with epoxy floors. Located at The SANCTUARY at Costa Grande in PORT O\'CONNOR amenities for all ages (Salt water POOL, SPA, Tennis Courts, Outdoor BBQ/grill at the Club House, Dock & Boat Slips, Piers on the ICW, Playground, etc.). Controlled Acess','0.2516','65','','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures,Sellers Disclosure','1','Freestanding','2','','Central Electric,Zoned','1','THE SANCTUARY SUBD PHASE 1, LOT 101','Subdivision Lot,Water View','10960','Appraisal District','','2175','0','','2','Electric Oven','0','','','Electric Cooktop','','Tile','169 - Calhoun County','PORT O\'CONNOR ELEMENTARY','CALHOUN HIGH SCHOOL','TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)','Appointment Required,Controlled Access','Appraisal District','2','Mediterranean','The Sanctuary Sub Ph 1 Po','8567','2.2844','Water District','2009','Appraisal District');  --> New record created successfully<br />