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-10-02T03:37:20.003' ,`MLSNumber` = '54014535' ,`ListAgentFullName` = 'Lucy Alvarado' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888033' ,`Longitude` = '-95.424304' ,`PhotoCount` = '16' ,`PostalCode` = '77088' ,`RoomCount` = '5' ,`ListPrice` = '199999.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Rock' ,`StreetNumber` = '1422' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1038' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful corner lot home that has a huge, cleared back yard with covered patio. Perfect for children or pets\r\nto enjoyed it. Plenty of parking space. The possibilities are endless. Conveniently located near 45N and easy access to HWY 249. All appliances stay. Burglar Bars throughout home that were installed in 2019. No low ballers. Make sure you are able to afford this home before seeing it.' ,`Acres` = '0.1696' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 20 WILLOW RUN SEC 5' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '7387' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'HILL ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Run Sec 05' ,`TaxAmount` = '3644' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1664710816' WHERE `Matrix_Unique_ID` = '210703756'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T02:35:54.550' ,`MLSNumber` = '10992251' ,`ListAgentFullName` = 'Susana Mendoza' ,`ListOfficeName` = 'Sylvia Valenzuela' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.500007' ,`Longitude` = '-95.390295' ,`PhotoCount` = '45' ,`PostalCode` = '77578' ,`RoomCount` = '4' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Montecito' ,`StreetNumber` = '14' ,`StreetSuffix` = 'Lane' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2527' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is located in a beautifully established community located off Hwy 288. Close to highway 6, beltway 8, the medical center and pearland. Rodeo palms offers amenities such as a community pool, club house and a recreation center.' ,`Acres` = '0.1348' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RODEO PALMS PALM VILLAS SEC 2 (A0459 ACH&B) (MANVEL) BLK 3 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5872' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Rodeo Palms Palm Villas Sec 2' ,`TaxAmount` = '9689' ,`TaxRate` = '3.6694' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710816' WHERE `Matrix_Unique_ID` = '211655269'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T02:27:12.953' ,`MLSNumber` = '19000667' ,`ListAgentFullName` = 'Irene Rangel' ,`ListOfficeName` = 'Fathom Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.828960' ,`Longitude` = '-95.708654' ,`PhotoCount` = '22' ,`PostalCode` = '77449' ,`RoomCount` = '4' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lilly Ln' ,`StreetNumber` = '3926' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The property is occupied, and the Tenant is on a month-to-month basis. This is a beautiful home in Westfield, it has an open Kitchen, spacious bedrooms, nice backyard and covered patio.  Make it your home or your next investment property.  Showings will start on October 1st, Please call for details and/or for an appointment. Irene Rangel, Realtor' ,`Acres` = '0.196' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 WESTFIELD SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8557' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '437' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'RHOADS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710817' WHERE `Matrix_Unique_ID` = '212331041'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T02:42:49.320' ,`MLSNumber` = '76285375' ,`ListAgentFullName` = 'Rayito Stephens' ,`ListOfficeName` = 'Real Properties of Texas, PLLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841418' ,`Longitude` = '-95.682924' ,`PhotoCount` = '31' ,`PostalCode` = '77084' ,`RoomCount` = '9' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Longmoor' ,`StreetNumber` = '18335' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3113' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful custom home in fantastic community with mature trees. Stately, located on quiet cul de sac lot with approx.3,113 sq. ft. 4 bedrooms (two with built in desks), 3.5 baths, 2 car detached garage.  New carpeting throughout. Master on 1st floor with custom walk in jetted tub, separate shower, double closets and sinks. Kitchen has Chef\'s Cooktop on island with granite countertops, open to breakfast with a beautiful bay window view of the backyard.  Large walk in pantry.  Great home for entertaining.  Three bedrooms and gameroom upstairs with two full baths.  Two bedrooms have built in desks and shelves, and living area, gameroom, and study/office have cabinets with shelves above.  Formal dining room, Spacious office/study/library by main entry. Beautiful wood and mosaique flooring downstairs with carpet in downstairs master. Gazebo in the back.  Community Pool, walking trails, close shopping, easy commute.  LOW TAXES!  Estimated room measurements.' ,`Acres` = '0.2652' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 47 DEERFIELD VILLAGE SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '11551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '835' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'WATKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deerfield Village Sec 05' ,`TaxAmount` = '6079' ,`TaxRate` = '2.251' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710817' WHERE `Matrix_Unique_ID` = '212668677'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-02T03:56:36.357' ,`MLSNumber` = '43972943' ,`ListAgentFullName` = 'Brenda Klushin' ,`ListOfficeName` = 'Realty Pros of Texas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706844' ,`Longitude` = '-95.871122' ,`PhotoCount` = '46' ,`PostalCode` = '77441' ,`RoomCount` = '4' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Winding Terrace' ,`StreetNumber` = '28703' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2412' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**** Amazing Taylor Morrison home (Granada Floorplan) located in Bonterra at Cross Creek Ranch, a 55+ community!  2 BR + 3rd Flex Rm (currently a Study), 2.5 Baths, 2.5 Car Extended Garage. This beautiful, energy efficient & ADA compliant home is loaded with well thought out upgrades, located on a cul-de-sac lot with a lake view & gated lake access. Features A  22KW Generac WHOLE HOUSE GENERATOR, Water Softener & Filter System, Tankless HWH, ‘Instant Heater’ (kitchen sink), Cameras/IT Rack upgrades, Indoor & Outdoor shades (some electric!), Indoor/outdoor Surround Sound, Huge backyard, Flag Pole, no back neighbors, Extended Covered Patio, HOT TUB, Outdoor Kitchen, Rear Gate (lake access), Fountain, Drainage/Driveway Extension, extended garage, & WiFI sprinkler system.  Front lawn maintenance included in HOA dues. Community amenities include The Club @ Bonterra plus walking trails, ponds, pools, pickleball, access to other Cross Creek amenities & more!' ,`Acres` = '0.2832' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BONTERRA AT CROSS CREEK RANCH SEC 6, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '12338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra At Cross Creek Ranch Sec 6' ,`TaxAmount` = '13537' ,`TaxRate` = '3.3362' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664710817' WHERE `Matrix_Unique_ID` = '212882044'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213209664','1664710817','213209664','2022-10-02T03:29:32.683','91843177','Jennifer Pareya','JLA Realty','','','29.709466','-95.168202','22','77503','3','139900.00','Active','Darling','3113','Avenue','Pasadena','2','0','3','1310','Single-Family','Don\'t miss this Darling of a Deal! Add this 3/2/2 property to your portfolio. Handyman special with a possibility of adding value by turning the detached garage in an income producing property. \r\nThis property already has two driveways.','0.1263','6','','','','','Sellers Disclosure','','','','Pasadena','Central Gas','0','E 20 FT OF LT 183 & W 35 FT OF LT 184 DEEPWATER','Subdivision Lot','5500','Appraisal District','','','0','','1','','0','','','','','Composition','16 - Deer Park','DEEPWATER ELEMENTARY SCHOOL','DEER PARK HIGH SCHOOL','DEEPWATER JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Deepwater','2934','2.6198','Public Sewer,Public Water','1950','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213212532','1664710817','213212532','2022-10-02T02:05:51.520','15675255','Guadalupe Ordonez Marroquin','Texas Signature Realty','','','29.843945','-95.434187','31','77091','3','295000.00','Active','Donovan','1419','Street','Houston','2','0','3','1399','Single-Family','WOW A MUST SEE! NEVER FLOODED, Make your own memories here in this cute and recently remodeled home with 3or4bed/2bath, lots of modern touches, office/4th room/guest room with independent entrance, new windows and many more updates! \r\nBack yard has a HUGE cover patio followed by an amazing uncover patio with built in grill that is ready to be enjoy, and no back neighbors. Detached building/storage/you name it at the back of the property with electricity and sewer ready for future plants. This is a MUST SEE!  Good price for a solid house. Invest in your future (Measurements are approximate)','0.1667','9','','','','','Sellers Disclosure','1','','','Northwest Houston','Central Gas','0','LT 18 BLK 4 ELLA PARK TERRACE','Subdivision Lot','7260','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','HIGHLAND HEIGHTS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','WILLIAMS MIDDLE SCHOOL','Appointment Required','Seller','1','Contemporary/Modern,Ranch,Traditional','Ella Park Terrace','2292','2.3307','Public Sewer,Public Water','1968','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213212754','1664710817','213212754','2022-10-02T02:17:40.673','20773563','Rizwan Adenwalla','Welcome Home Residential, LLC','','','29.668091','-95.596048','21','77099','5','189500.00','Active','Creekhurst','12135','Drive','Houston','2','0','3','1675','Single-Family','Nice three bedroom starter home or investment property, Has a  covered patio and nice size backyard. Needs some TLC, selling as is. Very close to Hwy 59 and beltway 8.','0.1729','28','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Stafford Area','Central Electric','1','LT 9 BLK 7 HUNTINGTON VILLAGE SEC 1','Subdivision Lot','7533','Appraisal District','','400','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','2 - Alief','KENNEDY ELEMENTARY SCHOOL (ALIEF)','AISD DRAW','HOLUB MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Huntington Village Sec 01','3817','2.4411','Public Sewer,Public Water','1973','Appraisal District');  --> New record created successfully<br />