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-03T08:50:47.537' ,`MLSNumber` = '89256456' ,`ListAgentFullName` = 'Leon Shapiro' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432883' ,`Longitude` = '-95.143864' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '13' ,`ListPrice` = '3099944.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview' ,`StreetNumber` = '418' ,`StreetSuffix` = '' ,`City` = 'Dickinson' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '9409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM ONE STORY MEDITERRANEAN STYLE STUCCO STUNNER WITH HIGH QUALITY OUTSTANDING FINISHES ON 3+ WATERFRONT ACRES! FROM THE GOURMET KITCHEN WITH CHEF\'S PANTRY PLUS APPLIANCE PANTRY AND SEPARATE BUILT-IN REFRIGERATOR AND FREEZER - TO THE HUGE PRIMARY BEDROOM WITH SITTING ROOM, REMOTE CONTROLLED CURTAINS AND DROP DOWN TV - TO THE HUGE PRIMARY BATH WITH MAKE-UP STATIONS, HUGE GLASS BLOCK SHOWER, STEAM ROOM, AND GARDEN BATH WITH FIREPLACE - SEPARATE HIS & HER CLOSETS WITH BUILT-INS, DRY-CLEANING STYLE SPINNER RACKS, AND ONE WITH A STAIRWAY TO MORE SHELVED AREAS - NO DETAIL WAS OVERLOOKED IN BUILDING THIS DREAM HOME!  HUGE CIRCULAR DRIVEWAYE, DOUBLE METAL ENTRY DOORS, 40\'  ROTUNDA W/ CHANDELIER, BARREL STYLE WET BAR, OUTDOOR KITCHEN, THEATER ROOM W/ BALCONY SEATING, 4 SIDED DEN FIREPLACE, 5 CAR GARAGE WITH OVERSIZED DOORS! TWO DRIVEWAY GATES PLUS GATED \'CATERING\' ENTRY,  LOADS OF COVERED OUTSUDE SEATING AREAS - INGROUND GUNITE POOL WITH HUGE WATERFALL AND OVERSIZED HOT TUB INSTALLED 7/2021.' ,`Acres` = '3.02' ,`Area` = '33' ,`BuilderName` = 'JIMMY BROWN' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'THE LAKES OF BAY AREA SEC 3 (2006) ABST 15, BLOCK 2, LOT 16,' ,`LotDesciption` = 'Corner,Water View,Waterfront' ,`LotSize` = '131909' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Lakes Of Bay Area' ,`TaxAmount` = '56907' ,`TaxRate` = '2.1677' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1668973729' WHERE `Matrix_Unique_ID` = '198707086'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:28:55.440' ,`MLSNumber` = '61619989' ,`ListAgentFullName` = 'David Mills' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.046632' ,`Longitude` = '-95.696766' ,`PhotoCount` = '18' ,`PostalCode` = '77480' ,`RoomCount` = '4' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'Maple' ,`StreetNumber` = '603' ,`StreetSuffix` = 'Street' ,`City` = 'Sweeny' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming home is full of updates that has given it life for another 50 years! Walk into the huge living area surrounded by large updated, windstorm certified windows that allow lots of light to come in while helping to maintain energy efficiency. The kitchen has been beautifully updated with cabinetry and appliances. A large rolling kitchen Island is perfect for preparing meals for guest and then storing it away when not needed. A large room on the back side of the garage can easily be used as a garage apartment, workshop or home office. It has been updated with drywall in 2021 and has easy access to utilities. The huge back yard allows for the perfect amount of sunlight for flower beds and small gardens as well as shade from trees and covered porches. Foundation was leveled and completely repaired in 2021. Pex Plumbing in 2021 means that all is left is for you to do is get the keys!' ,`Acres` = '0.3306' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MEADOR (SWEENY) BLK 4 LOT 7 (REPLAT)' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meador Sweeny' ,`TaxAmount` = '4050' ,`TaxRate` = '2.8427' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973729' WHERE `Matrix_Unique_ID` = '208769700'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T08:10:02.853' ,`MLSNumber` = '62214619' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.341208' ,`Longitude` = '-93.858035' ,`PhotoCount` = '38' ,`PostalCode` = '75948' ,`RoomCount` = '6' ,`ListPrice` = '188000.00' ,`Status` = 'Active' ,`StreetName` = 'Worth' ,`StreetNumber` = '825' ,`StreetSuffix` = 'Street' ,`City` = 'Hemphill' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 1950s charmer in the quaint country town of Hemphill,TX! This recently retouched home features all of the charm from days gone by, while still giving you the comfort of modern amenities. Within walking distance of the historic and bustling courthouse square, this home gives you a taste of country living within a stones\' throw of \"city\" conveniences! This home features 3 spacious bedrooms with a primary bedroom feat. an en-suite bath, a cozy living space that opens onto the dining room framed by built-in cabinetry and leads to the roomy kitchen with original crank windows and gas stove! Enjoy Southern evenings entertaining on the covered patio porch overlooking the backyard with storage shed. A home too easy to fall in love with! Call today for more information and to schedule your viewing!' ,`Acres` = '0.615' ,`Area` = '79' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.615 ABST: 57 JOSEPH WALKER HOUSE/IMPROVEMENTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '26789' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '217 - Hemphill' ,`SchoolElementary` = 'HEMPHILL ELEMENTARY SCHOOL (HEMPHILL)' ,`SchoolHigh` = 'HEMPHILL HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPHILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1442' ,`TaxRate` = '1.4607' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973730' WHERE `Matrix_Unique_ID` = '210143975'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T09:44:30.807' ,`MLSNumber` = '1098261' ,`ListAgentFullName` = 'Linh Nguyen' ,`ListOfficeName` = 'The Professional Landlords' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.147041' ,`Longitude` = '-95.639626' ,`PhotoCount` = '31' ,`PostalCode` = '77486' ,`RoomCount` = '10' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Bowie' ,`StreetNumber` = '406' ,`StreetSuffix` = 'Street' ,`City` = 'West Columbia' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '3744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Attention Investors!  Huge income potential for a boarding house, with several chemical plants and manufacturing facilities nearby, or someone with a big family!  Originally designed as a duplex, the property has been set up perfectly as a boarding house for blue-collar workers.  Potentially 10 bedrooms.  Also has 4 full and 2 half baths.  Two full kitchens.  Big back porch for outdoor relaxation for residents or owners. Right in town with shopping and restaurants nearby.   Contact seller for showings and offers.' ,`Acres` = '0.2169' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ALAMO HEIGHTS (WEST COLUMBIA) BLK 2 LOT 5' ,`LotDesciption` = 'Other' ,`LotSize` = '9448' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '56' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Alamo Heights West Columbia' ,`TaxAmount` = '5795' ,`TaxRate` = '2.4263' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1668973730' WHERE `Matrix_Unique_ID` = '210967143'  --> Updated record success<br />