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-20T17:13:39.160' ,`MLSNumber` = '8828948' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Active' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9919' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now  Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093619' WHERE `Matrix_Unique_ID` = '206838760'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T17:04:32.923' ,`MLSNumber` = '4419657' ,`ListAgentFullName` = 'Louis Vargas' ,`ListOfficeName` = 'Tevas Real Estate Group INC' ,`SellingAgentFullName` = 'Melissa Perez' ,`SellingOfficeName` = 'Nan & Company PropertiesChristie\'s International R' ,`Latitude` = '29.759661' ,`Longitude` = '-95.253536' ,`PhotoCount` = '25' ,`PostalCode` = '77029' ,`RoomCount` = '3' ,`ListPrice` = '249955.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Lanewell' ,`StreetNumber` = '9943' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1626' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '28 homes on this street all starting at the same time. Pre selling now  Come pick your lot. Beautiful 3 bed 2-1/2 bath home will amaze you with all the updates put in. Custom cabinetry done on site with designer gray paint in all areas, kitchen, and bathrooms. quartz counter tops with stainless steal appliances which brings the whole home together. All light fixtures are dark black giving you a gorgeous modern look. The stairs are wood and stained to match the home. Upstairs you have 3 large bedrooms laid out perfect for your family. The back yard is large enough for entertaining. Come see this home before its gone. Final trims will be based on availability of materials' ,`Acres` = '0' ,`Area` = '2' ,`BuilderName` = 'SVG' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 33 THRU 46 BLK 83 FIDELITY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'WOODLAND ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODLAND ACRES MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fidelity' ,`TaxAmount` = '' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093619' WHERE `Matrix_Unique_ID` = '206840728'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T17:22:05.483' ,`MLSNumber` = '38926351' ,`ListAgentFullName` = 'Frank Oveo' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194858' ,`Longitude` = '-95.068106' ,`PhotoCount` = '50' ,`PostalCode` = '77327' ,`RoomCount` = '5' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5005' ,`StreetNumber` = '476' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this captivating 3 Bedroom 2, bath home with 1848 sq ft of generous open space to move about while maintaining a quaint, cozy atmosphere—with picturesque tree-lined lots on each side. Enjoy Contemporary high-end designs throughout: Including granite counters, high-end cabinets, nickel light fixtures, tiled flooring, and much more. Spend rainy days on the front porch with coffee & a book and summer days entertaining or in the hammock on the back porch. Apart from the main house is a Luxurious 2nd house with 2 bedrooms & 1.5 baths with 1202 sq ft of ample space & modern finishes. The oversized above-ground pool has a full bathroom that needs finishing touches. The landscaping & chicken coop is a nature enthusiast\'s dream with Sprinkler, Irrigation, & Mosquito systems & a concreted horseshoe-like driveway. A hop & skip away from Big River Waterpark & many other of Cleveland\'s most exciting places. This is not just a house; it\'s a home. Call us to schedule a tour today!' ,`Acres` = '0.92' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CAMINO REAL, SEC 1, BLOCK 52, LOT 2710, ACRES .46' ,`LotDesciption` = 'Other' ,`LotSize` = '40076' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Camino Real' ,`TaxAmount` = '4149' ,`TaxRate` = '1.8013' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093619' WHERE `Matrix_Unique_ID` = '211513965'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T18:02:47.670' ,`MLSNumber` = '20970649' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.813893' ,`Longitude` = '-95.842947' ,`PhotoCount` = '36' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '759001.00' ,`Status` = 'Active' ,`StreetName` = 'South Upland' ,`StreetNumber` = '3122' ,`StreetSuffix` = 'Street' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on an oversized lot with plenty of space for a pool, this stunning one-story home checks off all the boxes with 4 bedrooms, 4 bathrooms, a spacious study perfect for working from home, formal dining, game room, media room, and even a 4-car garage! This new home is equipped with gorgeous wood floors throughout the main living areas and 14\' ceilings. Natural light pours into this gorgeous home through a wall of windows in the family room. The open concept design makes this stunning home perfect for entertaining family and friends. Don’t miss out, make it yours today!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Coventry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 32 Block 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cane Island' ,`TaxAmount` = '' ,`TaxRate` = '3.4' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093619' WHERE `Matrix_Unique_ID` = '214503631'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T17:51:25.127' ,`MLSNumber` = '96210196' ,`ListAgentFullName` = 'Barbarette Twiggs' ,`ListOfficeName` = 'Alpha & Omega Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033870' ,`Longitude` = '-95.586584' ,`PhotoCount` = '9' ,`PostalCode` = '77375' ,`RoomCount` = '11' ,`ListPrice` = '595754.00' ,`Status` = 'Active' ,`StreetName` = 'Wind Pine' ,`StreetNumber` = '11218' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome! Beautiful 4 bedroom, 3 bath, on 1/2 to 1 acre lot. This home features large rooms throughout (21x19\r\nden) Oversize master bedroom with sun room attached. Large 18x18 covered patio with tile floor. Two more patios for early morning coffee/tea, Island kitchen with extra wall of cabinet space. New laminate wood flooring throughout, inside fresh painting and more!' ,`Acres` = '0.6591' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 PINE GLEN U/R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '28710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pine Glen U/R' ,`TaxAmount` = '6662' ,`TaxRate` = '2.0766' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093620' WHERE `Matrix_Unique_ID` = '214988522'  --> 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','215571104','1675093620','215571104','2022-12-20T18:12:18.003','66982836','Cyndi Kornegay','Gatehouse Properties','','','29.785920','-95.441006','14','77055','7','762482.00','Active','Eaton Estates','3503','Lane','Houston','3','1','3','2371','Single-Family','Located in the stunning master-planned community of Somerset Green offers beautiful lakes, walking trails, and dog parks! This gated community offers lock and leave living only minutes from Downtown, the Heights, and the Galleria, making it easy to monitor your home from afar. This 3-story townhome features three bedrooms, three-and-a-half bathrooms, and a beautiful kitchen and living area on the second floor. In addition to a notable oversized back and side yard! Complete with designer finishes, a 1-year builder warranty, and a smart home system, you don’t want to miss out on this gorgeous townhome!','','9','Coventry Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','','0','Timbergrove/Lazybrook','Central Gas','1','Lot 14 Block 2','Other','1938','Survey','','2500','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany,Appointment Required,No Supra Keybox','Builder','3','Colonial,English,French,Traditional','Somerset Green','','2.9','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','215717539','1675093620','215717539','2022-12-20T17:08:52.670','48238725','Peiru Liu','KingFay Inc','','','29.134783','-95.052264','4','77554','4','759000.00','Active','Vista Del Mar','22413','','Galveston','3','0','4','1808','Single-Family','Brand new home under construction in the Isla del Sol Subdivision! Featuring an open concept floor plan with a kitchen island, 3 bedrooms, AND a home office/extra bedroom. There are 3 full bathrooms, 2 walk-in showers, and 1 bathtub. All the doors and windows are storm-rated. There is a one-car garage downstairs which can also be used as storage, as well as driveway parking. An outdoor shower, a large balcony with amazing beach views, and a short ride to the beach make this house the perfect vacation home as well as a forever home! Subdivision amenities offer a boat launch and fishing pier. Decide now and enjoy the coming Summer.','0.117','33','Jerry Homes LLC','','','','No Disclosures','','','','West End','Central Electric','1','ABST 121 HALL & JONES SUR LOT 4 BLK 1 ISLA DEL SOL SUB','Cleared','5097','Appraisal District','','300','1','To Be Built/Under Construction','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Lockbox Front','Builder','2','Other Style','Isla Del Sol','','','Public Sewer,Public Water','2023','Builder');  --> New record created successfully<br />