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-08-17T22:54:20.360' ,`MLSNumber` = '40030777' ,`ListAgentFullName` = 'Dimas Gomez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.665735' ,`Longitude` = '-95.360076' ,`PhotoCount` = '14' ,`PostalCode` = '77051' ,`RoomCount` = '6' ,`ListPrice` = '255500.00' ,`Status` = 'Active' ,`StreetName` = 'Galesburg' ,`StreetNumber` = '4502' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '844' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME LOOK AT THIS BEAUTIFUL REMODELED HOME .. GRANITE COUNTERTOP, NEW PAINT, NEW A/C, NEW ELECTRICAL SYSTEM, NEW ROOF. HOUSE HAS BEEN COMPLETELY REMODELED in 2018.. IN A GROWING AREA..  LOW TAXES.. NO RESTRICTIONS.. NO HOA AND NEVER FLOODED. Remodeled bathroom. Home is in great location just outside the loop and 288. Easy routes to University of Houston and the Medical Center. Come check it out !' ,`Acres` = '0.1148' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 56 BLK 6 RUBURFIELD NO 66' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ruberfield' ,`TaxAmount` = '2319' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699987' WHERE `Matrix_Unique_ID` = '211521794'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T22:59:56.687' ,`MLSNumber` = '64148275' ,`ListAgentFullName` = 'Charlotte Galbraith' ,`ListOfficeName` = 'Bailey Banks & GoldrichProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945366' ,`Longitude` = '-95.207481' ,`PhotoCount` = '24' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Allington Cove Lane' ,`StreetNumber` = '12034' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3739' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Gated Balmoral Subdivision!Gorgeous Upgraded Double Mahogany Front Drs! Beautiful Large Tile Flrs,Accented Paint,Art Niches Throughout!2 Story High Ceiling Foyer w/Dramatic Sweeping Stairway! Study w/Tall French Drs & Coffered Ceilings!Elegant Formal Dining w/Coffered Ceilings,Butlers Pantry w/Granite & Wine Rack!Gourmet Kitchen w/Granite,Working Island,Under-mount Stainless Sink,Tall Cabinets, Built-In Stainless Appliances,Huge Pantry & Breakfast Rm that flows gracefully into Family Room w/Cozy Fireplace & 2 Story Wall of Windows!Master Down w/Luxurious Bath w/2 Private Sink Vanities w/Stone Counters,Deep Garden Tub,Huge Walk-in Shower w/Bench!Upstairs-Game Rm,Media Rm,Jack & Jill Bath,3 Secondary Bedrms & 1 Full Bathrm! Wonderful Amenities w/Lagoon Pool,Splash Pad,future Tennis Courts & more!NO FLOODING!Visit the Balmoral model to make this pocket of paradise your home today!' ,`Acres` = '0.1722' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 4 BALMORAL SEC 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1630' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'RIDGE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Balmoral Sec 1' ,`TaxAmount` = '10883' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699987' WHERE `Matrix_Unique_ID` = '211534100'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T22:22:03.337' ,`MLSNumber` = '91272631' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.625351' ,`Longitude` = '-96.408630' ,`PhotoCount` = '10' ,`PostalCode` = '77807' ,`RoomCount` = '4' ,`ListPrice` = '259990.00' ,`Status` = 'Active' ,`StreetName` = 'Milagro' ,`StreetNumber` = '4708' ,`StreetSuffix` = 'Loop' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Alamosa Springs in Bryan, Texas! The Butler floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, FLEX ROOM, and 2-car garage! This home has it all - including blinds! The first floor offers the perfect entertainment space with a large kitchen overlooking the family room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and a center island! Upstairs offers a private retreat for all the bedrooms! Retreat to the Owner\'s Suite featuring a sizable shower and spacious walk-in closet! Enjoy the great outdoors with full sod, covered patio, and a privacy fence! Don\'t miss your opportunity to call Alamosa Springs home, schedule a visit today!' ,`Acres` = '0.11' ,`Area` = '61' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk. 11 Alamosa Springs 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6003' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'MARY BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Alamosa Springs' ,`TaxAmount` = '' ,`TaxRate` = '2.349' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699987' WHERE `Matrix_Unique_ID` = '211543508'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T23:17:59.293' ,`MLSNumber` = '55263595' ,`ListAgentFullName` = 'Xingru Su' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.856728' ,`Longitude` = '-95.777382' ,`PhotoCount` = '35' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '358000.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Greens Lane' ,`StreetNumber` = '5722' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction, never live-in, Move-in ready. Upgrade  4 side full brick,  One story 3 bedroom, 2 full bath. This house features wood plank looking title throughout kitchen and living room, Spilt bedroom foor plan. New carpet all bedroom , Closet. Primary bedroom offer walk-in closet,60 inch  super shower, Double granite vanity sink.  Open floor plan dining and family room combo. Great size kitchen with granite island, pantry. Band new appliances: microwave dishwasher.Upgrade extend cover Patio and whole house 2 inch faux wood blind. Perfect size back yard for outdoor entertainment. Walking  distance to community amenity. Zone to excellect katy ISD,  Covenient location for commute and shopping.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Century Community' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 2, Aurora Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Aurora' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699987' WHERE `Matrix_Unique_ID` = '211544588'  --> Updated record success<br />