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-12-26T11:31:06.890' ,`MLSNumber` = '39421365' ,`ListAgentFullName` = 'Maria Lule' ,`ListOfficeName` = 'Go Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.279214' ,`Longitude` = '-95.961851' ,`PhotoCount` = '36' ,`PostalCode` = '77420' ,`RoomCount` = '5' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'School Rd' ,`StreetNumber` = '218' ,`StreetSuffix` = '' ,`City` = 'Boling' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4021' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.7346' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'IAGO BLOCK 2 LOT 10, 11 Acres:0.7346' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '140 - Boling' ,`SchoolElementary` = 'NEWGULF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BOLING HIGH SCHOOL' ,`SchoolMiddle` = 'IAGO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'IAGO BLOCK 2 LOT 10, 11' ,`TaxAmount` = '4392' ,`TaxRate` = '1.64679' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095787' WHERE `Matrix_Unique_ID` = '203100285'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T12:32:06.870' ,`MLSNumber` = '15581152' ,`ListAgentFullName` = 'Nettie Murry' ,`ListOfficeName` = 'ERA Legacy Living' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618053' ,`Longitude` = '-95.410379' ,`PhotoCount` = '10' ,`PostalCode` = '77047' ,`RoomCount` = '9' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Fenland Field' ,`StreetNumber` = '13027' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2125' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well kept 4 bedrooms 2.5 baths with all beds up and a game room not to mention on the first floor is an intimate living area with a fireplace to greet guests or for those relaxing moments away from the rest of the home, dining, breakfast area, and family gathering space. This house can quickly be called your home and ready for your special style.' ,`Acres` = '0.1047' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 REGAL OAKS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Regal Oaks Secs 2' ,`TaxAmount` = '5864' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095787' WHERE `Matrix_Unique_ID` = '210276374'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T11:50:36.980' ,`MLSNumber` = '89011768' ,`ListAgentFullName` = 'Jennifer Arriaga' ,`ListOfficeName` = 'Daniel Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.717179' ,`Longitude` = '-95.586916' ,`PhotoCount` = '44' ,`PostalCode` = '77082' ,`RoomCount` = '11' ,`ListPrice` = '2449000.00' ,`Status` = 'Active' ,`StreetName` = 'Portofino' ,`StreetNumber` = '11906' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the best golf course views situated on a cul-de-sac in Royal Oaks Country Club, this spectacular home offers 5 bedrooms, including guest quarters on the 1st floor, 5 full bathrooms & 1half bath. This custom-designed home was well thought through with the use of space & layout. Unbelievable backyard tucked away on the golf course with a beautiful pool, spa, fire pit, outdoor kitchen, multiple outdoor living spaces, green space, and a full pool bath. The mosquito system makes entertaining enjoyable year-round. Formal entry, study, dining, and living room with two-story windows offering tons of natural light. The master retreat offers a view from every angle, sitting room, and fireplace with an enormous master bathroom and closet. Entertaining at its finest with a second-floor game room, card room, balcony, media room, and last but not least the outdoor living areas and pool all overlooking the lakes of holes 15 and 16. You will not want to miss out on this view!' ,`Acres` = '0.3099' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '13500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Spanish' ,`Subdivision` = 'Royal Oaks Country Club Sec 13' ,`TaxAmount` = '42783' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095788' WHERE `Matrix_Unique_ID` = '212639621'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T12:26:42.557' ,`MLSNumber` = '77062375' ,`ListAgentFullName` = 'Tara Anderson' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.392005' ,`Longitude` = '-95.673823' ,`PhotoCount` = '19' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '1373620.00' ,`Status` = 'Active' ,`StreetName` = 'Mia Lago' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gated community. This lot backs up to the community walking trail and water feature. Currently a vacant. Price includes a landscape. Contact Tara for more information.' ,`Acres` = '2.4563' ,`Area` = '39' ,`BuilderName` = 'Gryphon Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S456200 - ESTATES OF MIA LAGO 01, BLOCK 2, LOT 3, ACRES 2.45' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '106996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Tile' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2.5' ,`Style` = 'Colonial,Mediterranean' ,`Subdivision` = 'Estates Of Mia Lago 01' ,`TaxAmount` = '4917' ,`TaxRate` = '2.2242' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675095788' WHERE `Matrix_Unique_ID` = '213371997'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-26T11:39:44.340' ,`MLSNumber` = '88328450' ,`ListAgentFullName` = 'Raul Rodriguez' ,`ListOfficeName` = 'Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642054' ,`Longitude` = '-95.628306' ,`PhotoCount` = '12' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Hitherfield' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location, Very well maintained. Private pool' ,`Acres` = '0.2223' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COVINGTON WOODS SEC 3, BLOCK 16, LOT 24' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9684' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SUGAR MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Covington Woods Sec 3' ,`TaxAmount` = '4731' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675095788' WHERE `Matrix_Unique_ID` = '213402069'  --> 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','214746052','1675095788','214746052','2022-12-26T12:36:11.363','84729526','Tammy Bateman','Tammy Bateman Properties','','','29.777904','-95.506774','19','77024','14','2200000.00','Active','Beinhorn','10942','Road','Hedwig Village','6','1','5','7383','Single-Family','In affluent Hedwig Village, a huge lot is home to a sprawling custom built contemporary, multi-level home. The large lot and prime location offer the opportunity to renovate or re-build this once custom home to suit your taste! From the raised foyer, impressive site lines through living areas and floor-to-ceiling glass, overlooking the covered lap pool, spa, gazebo and backyard. An atrium, subterannean wine room, incandescent lighting, jade marble floors and vaulted, detailed ceilings are some of the unique features. The destination primary suite has pool access, a craft room, study, and dual walk-ins. A raised tub in the primary bath is surrounded by glass block under an intricate vaulted ceiling. Upstairs: An apartment with kitchenette and private entrance-perfect for a nanny, or extended stay guest. An ensuite bedroom with adjoining library, a colossal game room with wet bar and pool views. All secondary bedrooms are ensuite, spacious and private with walk-ins and carpet. Roof-2017','0.7664','23','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','3','Memorial Villages','Central Gas','0','LT 3 MATHUR PLACE','Subdivision Lot,Wooded','33384','Appraisal District','','','0','','3','Convection Oven,Double Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Aluminum','49 - Spring Branch','MEMORIAL DRIVE ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)','Accompany,Appointment Required','Appraisal District','2','Contemporary/Modern','Mathur Place','','2.2564','Public Sewer,Public Water','1986','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','215227262','1675095788','215227262','2022-12-26T11:18:18.377','52438702','Ronnie Matthews','D.R. Horton Homes','Nancy Albea','Redfin Corporation','30.079941','-95.417160','6','77373','6','301990.00','Pending Continue to Show','Tuscany Hills Lane','5403','','Spring','3','0','5','2498','Single-Family','FIVE BEDROOMS!!!! Wonderful brand NEW Express Home in Breckenridge Forest! Fantastic location! Charming curb appeal! Perfect floor plan with open living spaces and modern finishes! Lovely island kitchen with espresso cabinetry! Great Primary suite with large closet and oversized shower! Great outdoor space with covered back patio and landscape package! Breckenridge Forest has a nice community pool and fun parks! Hurry and call today!!','','12','Express Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Spring East','Central Gas','1','Lot 1, Bkl 3, Section 1','Subdivision Lot','','','','400','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','NORTHGATE ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','SPRINGWOODS VILLAGE MIDDLE SCHOOL','Appointment Required','Builder','2','Traditional','Breckenridge Forest','','','Water District','2022','Builder');  --> 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','215419337','1675095788','215419337','2022-12-26T11:47:08.930','49060931','Denise Moore','RE/MAX Fine Properties','','','29.931763','-95.617947','31','77065','8','385000.00','Active','Brook Mill','11115','Court','Houston','2','1','4','2802','Single-Family','Beautiful 1 story home in prestigious, Wortham Estates.  New double ovens and dishwasher to be installed soon.  Recent paint inside and on the deck. This home features a formal dining and living areas, family room with gas log fireplace overlooking the backyard with an open concept to breakfast and kitchen area.  The island has a cooktop and there is countertop space and cabinets! The primary bedroom has a built-in and a huge bathroom with lots of closet space. Separate shower and tub with two sinks. Office/study has a closet and built-ins (4th bedroom). Low tax rate too!','0.2008','10','','','Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','1960/Cypress','Central Gas','1','LT 22 BLK 4 WORTHAM ESTATES SEC 1','Subdivision Lot','8748','Appraisal District','','650','0','','2','Double Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','ADAM ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Traditional','Wortham Estates Sec 01','7565','2.341','Public Sewer,Public Water','1991','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','215815955','1675095788','215815955','2022-12-26T12:43:44.890','16819857','Justin Dickey','Keller Williams Professionals','','','29.832839','-95.855839','15','77493','9','282990.00','Active','Sundown Glen','1408','Lane','Katy','2','0','3','1445','Single-Family','BRAND NEW COLINA HOME OFFERS 3 BEDROOMS, 2 BATHS. GRANITE KITCHEN COUNTERTOPS, 42\" CABINETS WITH CROWN MOLDING, 9\" SINGLE BOWL KITCHEN SINK, STAINLESS STEEL APPLIANCES WITH 5 BURNER GAS STAINLESS STOVE, BUILT IN PEST CONTROL, RINNAH TANKLESS WATER HEATER, FRONT GUTTERS, FAUX BLINDS, VINYL PLANK FLOORING EVERYWHERE EXCEPT BEDROOMS, DOUBLE SINKS IN MASTER BATHROOM, LARGE MASTER SUITE & CLOSET WITH BUILT IN SHOE RACK. LARGE GARDEN TUB, SEPERATE SHOWER IN MASTER BATH. LENNOX 16 SEER A/C, BACK COVERED PORCH. READY Jan/Feb 2023.','','25','Colina Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','LT 37 Blk 1 SEC 14','Subdivision Lot','7145','Survey','','1000','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sunterra','','3.5','Public Sewer,Public Water','2023','Builder');  --> 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','215817864','1675095788','215817864','2022-12-26T12:10:57.830','82705107','Crystal Mason','CB&A, Realtors','','','30.043740','-95.106648','26','77336','4','410000.00','Active','Wateridge','25702','Drive','Huffman','3','0','4','2720','Single-Family','NEW CONSTRUCTION! Welcome home! This gorgeous 4 bedroom- 3 bathroom home is on a corner lot. Vaulted ceilings/wood beams in living area and high ceilings in kitchen with open concept design. Game room/full bathroom and plenty of storage upstairs. Home modern farmhouse/ matte black finishes and fixtures throughout with stainless kitchen appliances/undermount cabinet lighting/3-zoned A/C… large front and back porches. This beauty also features prewiring for an alarm system and sound, 2 car-garage, 8 foot doors throughout 1st level, and a mud room! {the sign in front of home will be removed}Easy access to 1960 for shopping/restaurants etc.. Schedule your tour today!','0.2479','1','Kensli Homes LLC','','','','No Disclosures','1','','','Huffman Area','Central Electric','0','LT 1 WATER WONDERLAND U/R','Cleared','10800','Appraisal District','','','1','Never Lived In','2','','0','','','','','Composition','28 - Huffman','HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)','HARGRAVE HIGH SCHOOL','HUFFMAN MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card','Builder','2','Traditional','Water Wonderland U/R','689','2.0083','Septic Tank,Well','2022','Builder');  --> New record created successfully<br />