Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T08:02:52.923' ,`MLSNumber` = '62177817' ,`ListAgentFullName` = 'Trinh Tran' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.710028' ,`Longitude` = '-95.380585' ,`PhotoCount` = '15' ,`PostalCode` = '77021' ,`RoomCount` = '0' ,`ListPrice` = '470000.00' ,`Status` = 'Active' ,`StreetName` = 'Charleston' ,`StreetNumber` = '2406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1363' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of last lot in the area. Great investment opportunity. You can remodel the house already there or build a brand new one. Please call or text agent to schedule or if you have any questions. ' ,`Acres` = '0.1618' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 16C OF LT 6 BLK 1 CLINTON - OLD' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clinton Old' ,`TaxAmount` = '7251' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098788' WHERE `Matrix_Unique_ID` = '206647114' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T07:22:58.780' ,`MLSNumber` = '96338000' ,`ListAgentFullName` = 'Christina Osborne' ,`ListOfficeName` = 'Houston Realty Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.945784' ,`Longitude` = '-95.491490' ,`PhotoCount` = '8' ,`PostalCode` = '75862' ,`RoomCount` = '2' ,`ListPrice` = '50000.00' ,`Status` = 'Active' ,`StreetName` = 'Wood Road' ,`StreetNumber` = '53' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great weekend get-away, on creek and just a few blocks to Subdivision Ramp into main body of Trinity River. Great decks overlooking creek, House is on stilts, yard will flood. Good gravel roads, lightly populated. Home in need work and has been empty. ***Unsafe**** Stairs missing a step[s]****' ,`Acres` = '' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Walker County - North' ,`HeatSystem` = 'Butane,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'DEEP RIVER - SEC 4, BLOCK 1, LOT 4, ACRES .18' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Deep River Plantation' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098788' WHERE `Matrix_Unique_ID` = '210645122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T07:43:58.880' ,`MLSNumber` = '90130320' ,`ListAgentFullName` = 'Jessica Wilkerson' ,`ListOfficeName` = 'JPAR Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.943065' ,`Longitude` = '-95.327171' ,`PhotoCount` = '29' ,`PostalCode` = '75862' ,`RoomCount` = '6' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Shallow Springs' ,`StreetNumber` = '38' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Year..New Price! This 3/2 home is designed with a spacious floor plan connecting common areas effortlessly meeting your hosting or relaxing needs. Situated on a desirable cul-de-sac lot surrounded by mature landscaping with a beautiful golf course and tee box walking distance from the backyard is additional to the amenities offered within the community located on the highly desirable Lake Livingston. Less than an hour and a half from Downtown Houston and College Station and within 30 minutes from Huntsville, The Woodlands, or Sam Houston State the drive and views outside of city limits are indescribable only to be seen yourself. It doesn\'t end with the drive because the views continue with both sunrise and sunset that are so surreal seen from the front porch and backyard wrap around deck. Your new home is ready for making new memories! Schedule a showing to see all its beauty.' ,`Acres` = '0.2455' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 07, BLOCK 80 LOT 05' ,`LotDesciption` = 'Cul-De-Sac,On Golf Course' ,`LotSize` = '10694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores' ,`TaxAmount` = '4174' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098788' WHERE `Matrix_Unique_ID` = '211495208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T08:38:29.313' ,`MLSNumber` = '16020074' ,`ListAgentFullName` = 'Michael Shafer' ,`ListOfficeName` = 'Origen Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658249' ,`Longitude` = '-94.903240' ,`PhotoCount` = '31' ,`PostalCode` = '77523' ,`RoomCount` = '5' ,`ListPrice` = '1150000.00' ,`Status` = 'Active' ,`StreetName` = 'Dow Reef' ,`StreetNumber` = '6410' ,`StreetSuffix` = 'Drive' ,`City` = 'Beach City' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '2797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home in Beach City offers a gorgeous view of Trinity Bay and is located inside the gated community of The Oaks at Houston Point. Settled on a 1.2-acre lot this custom home built in 2020 features a private pool with hot tub and a 1200 sq. ft. external workshop. With 3 bedrooms, 2 full baths and 2 half baths and nearly 2800 sq. ft. this home features granite counter tops and waterproof vinyl flooring throughout. This residence also comes equipped with a whole home dehumidifier as well as a 22000-kw generator that is a must in the Texas Gulf Coast area.' ,`Acres` = '1.251' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 THE OAKS @ HOUSTON POINT FC% FOR M7' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '54494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oaks/Houston Point' ,`TaxAmount` = '12102' ,`TaxRate` = '2.15' ,`WaterSewer` = 'No Water,Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098788' WHERE `Matrix_Unique_ID` = '211610748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T07:43:02.957' ,`MLSNumber` = '65078334' ,`ListAgentFullName` = 'Christina Osborne' ,`ListOfficeName` = 'Houston Realty Team' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.272354' ,`Longitude` = '-95.583339' ,`PhotoCount` = '15' ,`PostalCode` = '77316' ,`RoomCount` = '1' ,`ListPrice` = '900000.00' ,`Status` = 'Active' ,`StreetName` = 'Ponderosa' ,`StreetNumber` = '7202' ,`StreetSuffix` = 'Trail' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Commercial Building just built! Can be used in so many ways! Incredible property and easy access to I45, FM1488, MF2854 and Aggie Hwy! It offers a 6000 Square foot Warehouse on ONE ACRE CORNER LOT! 14\' garage doors, plumbed for 2 bathrooms at each end, two entrance doors with two exit doors, electric has been installed, septic is being installed and should be completed by end of September. Very unique property and unrestricted!' ,`Acres` = '1' ,`Area` = '39' ,`BuilderName` = 'Seller-ArmstongBuild' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'S942000 - VALLEYWOOD ACRES, LOT 1, SERIAL ALCA0894680S22436,' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Valleywood Acres' ,`TaxAmount` = '1762' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098789' WHERE `Matrix_Unique_ID` = '211845853' --> Updated record success
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','215147681','1675098789','215147681','2023-01-02T08:44:30.787','77925223','Aron Anderson','The Cox Company Real Estate Gr','','','29.852203','-95.203034','13','77044','3','209900.00','Active','Drifting Winds','12826','Drive','Houston','2','0','3','1490','Single-Family','PRICE REDUCED!!! This charming 3 BDR 2 BTH home has been completely remodeled and is move in ready! The spacious living room is the perfect place to be with a warm and cozy fireplace and plenty of room for entertaining. Enjoy cooking in this newly updated kitchen with plenty of cabinets throughout. This home features a large fenced in backyard with plenty of space. Don\'t miss out on the chance to make this your new home! \r\nSchedule a showing today!','0.1653','2','','','','','Sellers Disclosure','','','1','North Channel','Central Electric','1','LT 23 BLK 9 PARKWAY FOREST SEC 1','Cleared','7200','Appraisal District','','','0','','1','','0','','','','','Composition','46 - Sheldon','MONAHAN ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Parkway Forest Sec 01','4661','2.9993','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully
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','215979860','1675098789','215979860','2023-01-02T07:42:56.250','73927313','Monserrat Louimeus','The Realty Bridge','','','30.026554','-95.315505','38','77338','4','432000.00','Active','Foxwood Fair','7311','Lane','Humble','2','1','4','3220','Single-Family','Beautiful and very spacious house in Humble! Primary Bedroom Downstairs, dual vanities, walking closets. Spacious kitchen with beautiful open concept to living area. Media room, office/studio, game room. Great location convenient to restaurants, shopping and major highways! \r\nUpgraded Bathrooms and Kitchen!','0.1121','12','','','','','HOA First Right of Refusal,Mud','1','Gas Connections','1','Humble Area West','Central Electric,Central Gas','1','LT 13 BLK 2 FOXWOOD SEC 11','Subdivision Lot','4882','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Range','','Wood Shingle','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Accompany,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Foxwood Sec 11','6381','2.7734','Public Sewer,Public Water','2013','Appraisal District'); --> New record created successfully