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-02T19:11:11.133' ,`MLSNumber` = '84543964' ,`ListAgentFullName` = 'Sherry Williams' ,`ListOfficeName` = 'Bay City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.972041' ,`Longitude` = '-95.940903' ,`PhotoCount` = '42' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Heatherglen' ,`StreetNumber` = '4105' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2631' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see the tall vaulted ceiling in the massive living room with a cozy wood burning fireplace. Head straight back to a spacious room that is large enough for a pool table with windows to the back yard and a view of open meadows. Updated kitchen connects to a dining area with a breakfast bar to make family time or entertaining a joy, then a bonus front room off the kitchen, maybe for exercising or a children\'s play area? There is also a separate office off the living room. A hallway leads to the 4 bedrooms, 3 baths. This home gives so much space and flexibility to enjoy hosting a party, running a home business, parking a boat or RV in the side driveway. Two outside AC units were new in 2018.' ,`Acres` = '0.23' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MCDONALD MEADOWS, BLOCK 5, LOT 2, SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10019' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Mcdonald Meadows' ,`TaxAmount` = '5766' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '202888329'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T18:09:34.533' ,`MLSNumber` = '20096192' ,`ListAgentFullName` = 'Melanie Wingate' ,`ListOfficeName` = 'Bates-Brinkley Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.758943' ,`Longitude` = '-94.973184' ,`PhotoCount` = '50' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekbend' ,`StreetNumber` = '3405' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '5305' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury executive home for large or combined family - 2 primary suites downstairs plus another primary up - total of 5 bedrooms, 5 full bathrooms on double-corner lot - luscious landscaping outside as you enter the double front doors - brick floors throughout most of 1st story - plenty of space in the main family area which leads to huge sunroom in rear - first story includes large utility space with tons of space for folding, storage, extra refrigerator, and cabinets to store the baskets - kitchen with breakfast island, walk-in pantry, and tons of prep space - formal dining with another fireplace and built-ins completes the downstairs- Upstairs has 3 secondary bedrooms, 2 more full baths, a gameroom, and study, and another oversized storage closet - spacious backyard with patio space - Seller recently updated exterior paint, installed brand-new roof, updated attic insulation, & 1 ac is 5 years old, 2 other ac\'s are 3 years old' ,`Acres` = '0.341' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 7 & 8 BLK 2 PARKRIDGE BEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ALAMO ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkridge Bend' ,`TaxAmount` = '11339' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '206726546'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T18:28:34.010' ,`MLSNumber` = '76238394' ,`ListAgentFullName` = 'Moises Govea' ,`ListOfficeName` = 'Century 21 Garlington & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.934189' ,`Longitude` = '-95.077096' ,`PhotoCount` = '49' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '259950.00' ,`Status` = 'Active' ,`StreetName` = 'Crows Nest' ,`StreetNumber` = '17434' ,`StreetSuffix` = 'Way' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2156' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 3-bedroom 2 full Baths home located on an oversized corner lot, features, study/ sitting area, A large family room open to the kitchen and formal dining area, countertops, cabinets and , flooring throughout ,' ,`Acres` = '0.2342' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 8 NEWPORT SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'NEWPORT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport Sec 05' ,`TaxAmount` = '5480' ,`TaxRate` = '2.7105' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '208440479'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T19:07:55.090' ,`MLSNumber` = '50124699' ,`ListAgentFullName` = 'Becky Lowe' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981242' ,`Longitude` = '-95.536642' ,`PhotoCount` = '49' ,`PostalCode` = '77069' ,`RoomCount` = '20' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Richardson' ,`StreetNumber` = '6630' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '7623' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a private,tranquil, park-like setting on +/- 2 acres in the heart of Champions area, this magnificent custom home is unique in every way. Built by David Gunn and designed by L. Barry Davidson. Texas Hill Country ambiance meets Modern Farmhouse charm. Slate roof, reclaimed wood floors throughout, and an abundance of natural light everywhere. Formal dining, family room, paneled study, huge craft room could be a classroom, interior workshop, 2 utility rooms downstairs.  Fifth Bedrooom with bath, is currently outfitted with shelving for even more storage. Primary bedroom on first floor. Upstairs features gameroom, 3 more bedrooms w/ ensuite baths. Designed with future elevator in mind. Walk-up finished attic. 3 car attached garage + one more freestanding one. Fully irrigated and fenced. Full house generator. Call Listing agent for a full list of features - Too much to mention!  This is a MUST SEE.' ,`Acres` = '2' ,`Area` = '13' ,`BuilderName` = 'Gunn Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 31C ABST 618 B PAGE' ,`LotDesciption` = 'Other,Subdivision Lot,Wooded' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Turtle Pines' ,`TaxAmount` = '30476' ,`TaxRate` = '2.5156' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '208978309'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T19:06:55.873' ,`MLSNumber` = '19271597' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.180858' ,`Longitude` = '-95.150079' ,`PhotoCount` = '7' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '370990.00' ,`Status` = 'Active' ,`StreetName` = 'Forest View' ,`StreetNumber` = '814' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2170' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW DR Horton Home! Situated on a huge homesite! Over 19,000 square feet and tons of trees! 3 car garage!  Fantastic floor plan with 4 bedrooms and 3 full baths! Two beds and two full baths downstairs!  The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances! Spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers and landscape package! Also features a home automation system!  You will appreciate the great storage and energy efficient features throughout. Hurry and call TODAY!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 12 Block 10 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19034' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '209107171'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T18:48:56.287' ,`MLSNumber` = '35000572' ,`ListAgentFullName` = 'Michelle Foltz' ,`ListOfficeName` = 'Southern Integrity Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.987562' ,`Longitude` = '-95.945485' ,`PhotoCount` = '12' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '1720' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1224' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute starter home in a great neighborhood. This was originally a two bedroom/one bath home. half of the garage was converted to a third bedroom. The backyard is large and fully fenced.' ,`Acres` = '0.225' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BIRKNER ADDITION, BLOCK 3, LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Birkner Add' ,`TaxAmount` = '2539' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693729' WHERE `Matrix_Unique_ID` = '210935702'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T19:43:42.813' ,`MLSNumber` = '96013556' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.877932' ,`Longitude` = '-95.785469' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '838900.00' ,`Status` = 'Active' ,`StreetName` = 'Switchgrass Valley' ,`StreetNumber` = '24502' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3791' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perry Homes New Construction! Curved staircase highlights two-story entry. Home office with French doors and formal dining room set at entry. Two-story family room with wall of windows and corner wood mantel fireplace opens to kitchen and morning area. Kitchen features walk-in pantry, double wall oven, 5-burner gas cooktop and island with built-in seating space. First-floor primary suite with wall of windows. Dual vanities, garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. First-floor guest suite offers private bath. A game room, media room and three secondary bedrooms are upstairs. Extended covered backyard patio. Three-car garage.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9_Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8434' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693730' WHERE `Matrix_Unique_ID` = '210972043'  --> Updated record success<br />