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-02T20:25:37.277' ,`MLSNumber` = '41053319' ,`ListAgentFullName` = 'Krystal Philp' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.801441' ,`Longitude` = '-95.111683' ,`PhotoCount` = '33' ,`PostalCode` = '77360' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeview Wood' ,`StreetNumber` = '189' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic NEW 3 bedroom/3 bathroom lake view home was designed with VACATION in mind. Builder spared no expense on the features and the home has a beautiful lake view from every window. Desired open concept with the living room and dining next to the kitchen. Primary bedroom with full bathroom downstairs along with a laundry room. Upstairs you will find 2 additional primary bedrooms with their own full bathroom en suites, and a balcony to enjoy the lake views w/ morning coffee or afternoon tea. The community has a gated recreation area just 1/10th of a mile from home w/ boat dock, play park, volleyball court, community hall, picnic area, & pier. In addition, the subdivision offers a community pool. Come and experience boating, fishing, paddle boarding and other fun water activities. Home has a few final touch ups; limestone driveway has been installed & subdivision road will be paved this year as per builder.' ,`Acres` = '0.0623' ,`Area` = '44' ,`BuilderName` = 'Solomon George' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'IMPALA WOODS SECTION 4 BLK 5 LOT 9' ,`LotDesciption` = 'Water View' ,`LotSize` = '2714' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Impala Woods Sec 4' ,`TaxAmount` = '39' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '208171278'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T21:25:26.027' ,`MLSNumber` = '53373973' ,`ListAgentFullName` = 'Erik Delatorre' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654054' ,`Longitude` = '-95.578583' ,`PhotoCount` = '23' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Montverde' ,`StreetNumber` = '11407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Offer has been accepted .\r\nWelcome to your new home!! Fully renovated 3 Bedroom 2 Bath with 2 extra rooms with a private pool. Brand new appliances with filter rise water system. This home offers lots of open space for your love ones, major highways near by 59 south & Beltway 8. Just minutes away from large retailers. Don’t miss out on this gorgeous home, WONT LAST LONG !!' ,`Acres` = '0.1716' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 20 PARKGLEN SEC 4 - ALIEF' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7475' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CUMMINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkglen Sec 04 Alief' ,`TaxAmount` = '4294' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '209597392'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T20:56:49.933' ,`MLSNumber` = '24723930' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792634' ,`Longitude` = '-95.479791' ,`PhotoCount` = '42' ,`PostalCode` = '77055' ,`RoomCount` = '8' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgewood' ,`StreetNumber` = '1265' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2979' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare find! Charming brick home on a corner lot in a gated community. High ranked schools. Features 2-story ceilings, tons of natural light, generous closet & storage space, new porcelain tile on first floor, utility room w/ storage & washer/dryer. Kitchen w/ cabinets galore, lots of countertop space, a breakfast bar, island w/ a gas cooktop, & stainless steel refrigerator. Breakfast area w/ wall to ceiling windows. Large open area living room w/ floating fireplace & built-in cabinets/bookcases, 2-story ceilings & wall of windows. Primary BDRM on first floor, HIS & HER oversized closet w/ shelves & built-in drawers, Jetted tub, HIS & HER vanity. Huge separate formal dining area w/ crown molding. Formal living room w/ 2-story ceilings & a duel facing floating fireplace. Game room w/ built-in study nook & balcony overlooking the living room. All bedrooms are spacious w/ walk-in closets w/built-ins. Covered Patio. LOW TAX RATE, HOA takes care of it all; trash, water, sewer & landscaping.' ,`Acres` = '0.0964' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 RIDGEWOOD PLACE' ,`LotDesciption` = 'Corner' ,`LotSize` = '4200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Place' ,`TaxAmount` = '13078' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '209973418'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T21:05:11.237' ,`MLSNumber` = '14011619' ,`ListAgentFullName` = 'Kirsten Kiara' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.159044' ,`Longitude` = '-95.084434' ,`PhotoCount` = '29' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '268990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5102B' ,`StreetNumber` = '91' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Presenting The Bungalow XL plan by Casas Houston new home builders in the new neighborhood of Santa Fe! Upon entering this picturesque place you are greeted with a spacious, open concept living space open to the kitchen, breakfast bar and dining area. Views of your 50x150 backyard can be seen from your primary bedroom, family room & kitchen. Stop by the Model home or call for more information.' ,`Acres` = '0.16' ,`Area` = '52' ,`BuilderName` = 'Casas Houston' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Santa Fe Sec 3, Lot 6460 Block 50' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6970' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '1002' ,`TaxRate` = '2.15' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '210388563'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T20:19:28.370' ,`MLSNumber` = '56385447' ,`ListAgentFullName` = 'Shari McElroy' ,`ListOfficeName` = 'AVOREC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092250' ,`Longitude` = '-94.105213' ,`PhotoCount` = '8' ,`PostalCode` = '77701' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '1045' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1871' ,`Area` = '51' ,`BuilderName` = 'Destin Developments' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 STEPHENSON NO 1 .1871AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stephenson Add #1' ,`TaxAmount` = '99' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '210417057'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T21:20:46.493' ,`MLSNumber` = '69622175' ,`ListAgentFullName` = 'Angela Maxwell Montier' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809299' ,`Longitude` = '-96.261928' ,`PhotoCount` = '29' ,`PostalCode` = '78933' ,`RoomCount` = '3' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Hillboldt' ,`StreetNumber` = '8448' ,`StreetSuffix` = 'Road' ,`City` = 'Cat Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2729' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this CHARMING COUNTRY RETREAT on almost 5 acres in the desirable Cat Spring community.  Tons of natural light downstairs with a two story living area and stone fireplace.  The living and dining area is spacious and open to the country kitchen.  Lot of storage including a large walk in pantry and large mud room.  The primary retreat is downstairs and features a large walk in closet, claw foot tub, double sinks and a large custom shower.  Upstairs includes two more bedrooms each with their own bathroom.  Enjoy lots of outdoor living with the expansion outdoor patios overlooking the backyard.  Additional space under the large detached carport.  New roof installed last year. Lots of room to roam and for animals.  Low taxes and this property has never flooded. Additional 8.4 acres is also available next door.' ,`Acres` = '4.73' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLUM CREEK ESTATES LOT 7' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '206039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plum Creek Estates' ,`TaxAmount` = '7428' ,`TaxRate` = '1.7832' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '210539639'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T20:18:55.313' ,`MLSNumber` = '33777075' ,`ListAgentFullName` = 'Miguel Rosales' ,`ListOfficeName` = 'Miguel A. Rosales, REALTOR    ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.964145' ,`Longitude` = '-95.294403' ,`PhotoCount` = '0' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Stapley' ,`StreetNumber` = '16719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1232' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 2 bath home is in excellent condition with many recent updates.  Updates include flooring, paint, bathrooms, kitchen and attached covered patio/deck.  Great location with easy access to downtown, sports venues, airport and more.' ,`Acres` = '0.1621' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 5 HEATHER RIDGE VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7061' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'FRANCIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Heather Ridge Village Sec 01' ,`TaxAmount` = '3221' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693761' WHERE `Matrix_Unique_ID` = '210640683'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T20:04:13.063' ,`MLSNumber` = '75466910' ,`ListAgentFullName` = 'Andrew Anders' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.967381' ,`Longitude` = '-95.446488' ,`PhotoCount` = '36' ,`PostalCode` = '77541' ,`RoomCount` = '8' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Gaffney' ,`StreetNumber` = '6402' ,`StreetSuffix` = 'Drive' ,`City` = 'Jones Creek' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic buying opportunity in desirable Jones Creek neighborhood. This 3/2 is highlighted with 3 large living areas and enjoys nearly an acre of land situated on a corner lot. The 30x50 metal building encompasses plenty of space for all the toys and features electricity, water, half bathroom, and 3 garage doors. The side yard features a large fenced in area with several citrus trees including oranges, lemons, and grapefruit along with an additional storage shed. Come and take a look today.' ,`Acres` = '0.8083' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'DURAZNO GARDENS NO 2 (A0020 S F AUSTIN DIV 18) LOT 49-E/20\'' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '35210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Durazno Gardens 2' ,`TaxAmount` = '3956' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693762' WHERE `Matrix_Unique_ID` = '210970283'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T21:32:23.727' ,`MLSNumber` = '37940748' ,`ListAgentFullName` = 'Jennifer McCormick' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.040317' ,`Longitude` = '-95.083156' ,`PhotoCount` = '25' ,`PostalCode` = '77336' ,`RoomCount` = '10' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Pebble' ,`StreetNumber` = '25404' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Peaceful living INSIDE the City!! Lots of pics show off this beautifully maintained home! Tile floors throughout, covered patio, covered carport, complete this nearly 1 acre property! So many possibilities. Stunning kitchen with granite counters and stainless appliances. NEW Aerobic system 2019, NEW well installed 2022!!' ,`Acres` = '0.93' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11 & 30D LAKE HOUSTON FOREST SEC 3 U/R' ,`LotDesciption` = 'Cleared' ,`LotSize` = '40511' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Houston Forest Sec 03 U/R' ,`TaxAmount` = '2262' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693762' WHERE `Matrix_Unique_ID` = '210971537'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T20:53:33.220' ,`MLSNumber` = '80966894' ,`ListAgentFullName` = 'Glenn Johnson' ,`ListOfficeName` = 'Glenn A. Johnson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.423334' ,`Longitude` = '-95.414017' ,`PhotoCount` = '20' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Shores' ,`StreetNumber` = '13107' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1027' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'To be built and ready for move in March 2023. Lots of upgrades: Laminate wood and ceramic tile floors thruout, granite counter tops, upgraded electric/plumbing fixtures, real stone on front of house.  Across the street from lake! Call for more details. Hurry! Won\'t last long!!  Large lot in culdesac. .404 acres' ,`Acres` = '0.404' ,`Area` = '19' ,`BuilderName` = 'Prominent' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'section 02, lot #1490' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View,Wooded' ,`LotSize` = '17600' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '170' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'EDWARD B. CANNAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Forest' ,`TaxAmount` = '575' ,`TaxRate` = '1.84' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693762' WHERE `Matrix_Unique_ID` = '210973875'  --> Updated record success<br />