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` = '2022-09-20T05:33:23.243' ,`MLSNumber` = '51895269' ,`ListAgentFullName` = 'Kerri Canales' ,`ListOfficeName` = '316 Realty Group' ,`SellingAgentFullName` = 'Alisha Cunningham' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.060248' ,`Longitude` = '-94.792982' ,`PhotoCount` = '13' ,`PostalCode` = '77575' ,`RoomCount` = '7' ,`ListPrice` = '205000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Centennial' ,`StreetNumber` = '2217' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This three-bedroom one bath home has been updated! The kitchen, bathroom, windows, roof have been updated and/or replaced. The original wood floors have been refinished and fresh paint throughout the home. The Refrigerator stays along with appliances in the garage apartment. The garage apartment is approximately 400 sq ft great for guests or use as rental for extra income. Also, the property has a storm cellar that needs some work. Do not enter the storm cellar there is no lighting and steep steps.' ,`Acres` = '0.1625' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PEARSON, LOT 4, ACRES .1625' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7079' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pearson' ,`TaxAmount` = '3743' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663712894' WHERE `Matrix_Unique_ID` = '209510903' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-20T04:05:23.260' ,`MLSNumber` = '13622763' ,`ListAgentFullName` = 'Rhonda Walker' ,`ListOfficeName` = 'DOSS Pros, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.531315' ,`Longitude` = '-95.304792' ,`PhotoCount` = '22' ,`PostalCode` = '77584' ,`RoomCount` = '5' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Balmorhea' ,`StreetNumber` = '5409' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1886' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO 5409 BALMORHEA! Exceptional starter home. Home features a NEW ROOF, a pleasant entry way, leading to a split floor plan with charming updates from wood tile flooring, 12ft ceilings with an open living concept for a comfortably inviting feel. Home offers abundant living room space for any mood with a cozy fireplace. Kitchen boasts high-bar with granite counter tops, breakfast area with separate dining room. Large primary bedroom with the primary bath featuring newly updated separate vanities, custom mirrors, garden soaking tub, walk-in shower and walk in closet. Rear exit leads to your private deck where you can lounge and enjoy the beautiful sunset of the Texas sky or entertain your guests at the fire pit under a gorgeous moon light. Fencing offers double gated opening. Garage is wired with speakers. Home is wired for an alarm system, with 2 alarm cameras and recording box. Utility boxes accessible at the front of home. Come visit your new home. THIS IS 5409 BALMORHEA!' ,`Acres` = '0.1504' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PARK VILLAGE ESTATES SEC 5 (A0509 HT&BRR) (PEARLAND) BLK 2 L' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (PEARLAND)' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Village Estates Sec 5 A0' ,`TaxAmount` = '6677' ,`TaxRate` = '2.8451' ,`WaterSewer` = 'No Sewer,No Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663712894' WHERE `Matrix_Unique_ID` = '210930255' --> 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','212147837','1663712894','212147837','2022-09-20T05:57:01.377','54427130','James Dolson','Berkshire Hathaway HomeServicePremier Properties','','','30.708005','-94.949273','24','77351','4','235000.00','Active','Andover','1404','Lane','Livingston','0','3','3','1536','Single-Family','','0.1961','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','Wood Burning Fireplace','1','Livingston Area','Central Electric','0','BRIARBEND LOT 41','Subdivision Lot','8540','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Leave Business Card','Appraisal District','1','Traditional','Briarbend','3026','1.8745','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','212281761','1663712894','212281761','2022-09-20T04:58:51.057','63570830','Maria Acosta','Vive Realty LLC','','','29.834905','-95.550173','44','77041','6','210000.00','Active','Terrace Manor','4427','Drive','Houston','1','0','2','1239','Single-Family','Move in ready patio home close to energy corridor. Home has new windows, new front door, new ceiling fans, new electrical panel, new pipes, many light fixtures replaced, freshly painted inside and out. Home is located close to \r\nI-10 and Beltway 8, in close proximity to HEB, City Center and all the shopping and entertaining offered in the I-10 corridor. Covered patio area with colorful landscaping. Subdivision has area pool. Nice find in great area.','','24','','','Electric Dryer Connections,Washer Connections','','Estate','','','','Spring Branch','Central Electric','1','LT3 BLK7 COMMON AREA COURTYARD HOMES U/R WESTWAY','Subdivision Lot','2829','Appraisal District','','47','0','','1','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Westway','','','Public Sewer,Public Water','1977','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','212361891','1663712894','212361891','2022-09-20T04:23:02.147','67817169','Pauline Frech','Bella Properties','','','30.046326','-95.219960','50','77339','12','449000.00','Active','Thousand Pines','2115','Drive','Kingwood','2','1','4','2807','Single-Family','Completely Remodeled 2022 Home filled w/ charm & glamour. Expansive Family Room boats cathedral ceiling w/ extensive Millwork, Gas Fireplace with accented stone wall, open to a fabulous Gallery Kitchen that features: custom made cabinets w/ soft close & glass doors, SS Appliances, 7Ft Island, Quartz Countertops, Subway Backsplash, Farm Sink & gold-tone fixtures. Opulent Primary Bedroom w/ large Dressing Rm & Secondary Closet. En-suite Bath w/ Marble-design tile, custom-built Cabinets, Dual Vanity & Frameless-Glass Shower. Guest Bath offers new double-sink vanity, Tub & new Fixtures. The 11,616 SF lot is nestled among mature trees, lush landscaping, sweeping lawns & covered Bk Porch w/ space for a pool & summer kitchen. New Electric Panel, PEX Plumbing, New A/C & Heating Systems (*Per Seller). Porcelain Wood-look Tile, Low-e Windows, Solid Wood front door w/ wrought iron grill & LED Lights are just few exquisite options this home offers. Check Features & Updates Sheet for more details!','0.2667','32','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Kingwood West','Central Electric,Central Gas','1','LT 15 BLK 13 TRAILWOOD VILLAGE SEC 2 R/P','Subdivision Lot','11616','Appraisal District','','410','0','','2','Freestanding Oven','0','','','Electric Range','','Composition','29 - Humble','FOSTER ELEMENTARY SCHOOL (HUMBLE)','KINGWOOD PARK HIGH SCHOOL','KINGWOOD MIDDLE SCHOOL','Supra Keybox','Appraisal','1','Traditional','Trailwood Village Sec 02 R/P','6393','2.5839','Public Sewer,Public Water','1973','Appraisal'); --> 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','212458423','1663712894','212458423','2022-09-20T04:22:39.543','24584214','Marouane Nejmaoui','K & T Realty Group, Inc.','','','29.817895','-95.711121','34','77449','3','199500.00','Active','Silverside','3359','Drive','Katy','2','0','3','1305','Single-Family','Beautiful Duplex in Katy perfect for a first time home buyer, minutes from I10 and 99 and Katy Mills Mall and zoned to the Highly rated Katy school district. Recent updates include new fresh inside paint, new granite countertops and new kitchen cabinets and all laminate flooring. Schedule your showing today!!','0.1176','25','','','','','Sellers Disclosure','1','','1','Katy - North','Central Electric','1','LT 2 BLK 10 SILVERMILL SEC 1 R/P','Subdivision Lot','5123','Appraisal District','','380','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','30 - Katy','RHOADS ELEMENTARY SCHOOL','MAYDE CREEK HIGH SCHOOL','CARDIFF JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Silvermill Sec 01 R/P','3693','2.822','Public Sewer,Water District','1981','Appraisal District'); --> New record created successfully