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-02T17:39:20.763' ,`MLSNumber` = '25763617' ,`ListAgentFullName` = 'Nancy Perry' ,`ListOfficeName` = 'Navasota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.373679' ,`Longitude` = '-96.117832' ,`PhotoCount` = '41' ,`PostalCode` = '77868' ,`RoomCount` = '3' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway Drive' ,`StreetNumber` = 'TBD' ,`StreetSuffix` = '' ,`City` = 'Navasota' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3.168+/- Acres with 110 Feet frontage on Fairway drive. This tract can be developed into any number of different uses. Commercial, Multi Family, and or simply residential. With an existing 3 Bed 2 bath 2,019 SF home recently upgraded . Fresh paint throughout. Tile floors throughout plus granite counters. Metal roof and large covered patio detached garage and workshop plus 1 car attached garage and three car covered carport/ Lots of space for entertaining with additional concrete area. The property has a 2,400 SF metal warehouse with covered RV parking. There is room for additional homes and or multi-family to be built on this property, plus you could add commercial buildings fronting Fairway Dr. See plat and aerial pictures attached. Workshop and home are both currently leased. Call today for more details.' ,`Acres` = '3.168' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'FLY AWAY FIELD, BLOCK 1, Lot 3-R2, ACRES 3.168, (RE-PLAT 326' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'BRULE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Other' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675098973' WHERE `Matrix_Unique_ID` = '209253351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T17:34:56.397' ,`MLSNumber` = '69478126' ,`ListAgentFullName` = 'Dinah Wicker' ,`ListOfficeName` = 'Texas Team Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.170976' ,`Longitude` = '-97.001445' ,`PhotoCount` = '31' ,`PostalCode` = '78382' ,`RoomCount` = '8' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '461' ,`StreetSuffix` = 'Lane' ,`City` = 'Rockport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you are looking for serenity and lots of outdoor space with loads of privacy, this home is the perfect place. Whether you are downsizing or thinking about a holiday home, this 2-bedroom, one bath cutie will make you fall in love. This furnished home sits on one lot with a two lot, privately fenced backyard. There is a gate entrance to the back from the adjoining street. Also included is a large tool shed and riding lawnmower. Both the roof and air conditioner are 2017 updates. The community of Holiday Beach can enjoy two boat launches, kayak launch, clubhouse, pool, play yard, and a fantastic lighted pier. This area is directly on Copano Bay and adjacent to other great fishing and birding bays. Come see the new Toast of Rockport Living.' ,`Acres` = '0.3444' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2684 HOLIDAY BEACH MESQUITE TREE LOT 452, 453 & 461 .3444 A' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '15002' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '310 - Aransas County' ,`SchoolElementary` = 'LIVE OAK 1-3 LEARNING CENTER' ,`SchoolHigh` = 'ROCKPORT-FULTON HIGH SCHOOL' ,`SchoolMiddle` = 'ROCKPORT-FULTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Beach Mesquite Tree' ,`TaxAmount` = '2835' ,`TaxRate` = '1.3696' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098974' WHERE `Matrix_Unique_ID` = '214213561' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T17:02:06.237' ,`MLSNumber` = '7770812' ,`ListAgentFullName` = 'Ephrem Wegayehu' ,`ListOfficeName` = 'Green Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.009171' ,`Longitude` = '-95.306662' ,`PhotoCount` = '26' ,`PostalCode` = '77338' ,`RoomCount` = '8' ,`ListPrice` = '214999.00' ,`Status` = 'Active' ,`StreetName` = 'Birchbark' ,`StreetNumber` = '7823' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious 4 bedroom house offers a large living room and a master bedroom with a walk in closet and a double sink in the master bathroom. Property has a large backyard and it\'s priced right!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 7 MILL CREEK SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mill Creek Sec 01' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098974' WHERE `Matrix_Unique_ID` = '214701307' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T17:17:25.457' ,`MLSNumber` = '29434878' ,`ListAgentFullName` = 'Priscilla Raji' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.739317' ,`Longitude` = '-95.882898' ,`PhotoCount` = '27' ,`PostalCode` = '77494' ,`RoomCount` = '7' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Windham' ,`StreetNumber` = '3403' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2199' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New beautiful 4 bed room, 3 full bath, with an open kitchen concept and nice tile flooring on the first floor, carpet on the stair way, and in all bed rooms. Master bedroom and guest suite with full bath on the first floor, along with 2 bedrooms upstairs with full bath as well. Located in a planned community of Tamarron. Tenants occupied.' ,`Acres` = '0.1402' ,`Area` = '30' ,`BuilderName` = 'DR HORTON' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 53, BLOCK 4, LOT 53' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tamarron Sec 53' ,`TaxAmount` = '10983' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098974' WHERE `Matrix_Unique_ID` = '215048349' --> 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','215986734','1675098974','215986734','2023-01-02T18:13:58.890','78559380','Lynne LaQue','Keller Williams Realty - Clear Lake/ NASA','','','29.400245','-95.079636','22','77510','11','425000.00','Active','Avenue J','2901','','Santa Fe','2','0','4','3942','Single-Family','This 3942 Sqft Investment home sits on 2 Acres of land with a 750 sqft detached Mother- In-Law Suite!\r\nThis home does need some updating, but has great potential and is located one block from William F. Barnette Elementry in Santa Fe. Stained concrete and wood flooring throughout, no carpet! Light and bright. Large living room with fireplace. Covered patio, outbuildings for your storage needs and small horse stall area. This property provides beautiful open spaces with trees, privacy and No Back Neighbors!','2.02','33','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Santa Fe','Central Electric','0','ABST 1 M AUSTIN SU PT OF LOTS 31 & 33 (31-5) MCGREGORS SUB','Other,Wooded','87991','Appraisal District','','','0','','0','','0','','','Electric Range,Freestanding Range','','Composition','45 - Santa Fe','WILLIAM F BARNETT ELEMENTARY SCHOOL','SANTA FE HIGH SCHOOL','SANTA FE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Mcgregors Sub','8668','2.3536','Septic Tank,Well','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','216001050','1675098974','216001050','2023-01-02T18:56:12.273','59593121','Vanessa Burban','J. Lindsey Properties','','','29.876651','-95.741316','7','77449','6','290000.00','Active','Bluebonnet','21403','Cove','Katy','2','0','3','1436','Single-Family','Welcome home to 21403 Bluebonnet Cove ct situated on a corner lot 3 bd, 2 bath, 1,410 sq ft with tile throughout the family room, kitchen, breakfast room! White cabinets with granite countertops and stainless steel appliances. Spacious master bedroom and secondary bedrooms. Lovely covered patio and oversized backyard. This home is so CHARMING! Quick access to grand pkwy and I- 10. Nearby grocery stores, shopping and schools! Schedule home tour today.','','25','BEAZER','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','','Bear Creek South','Central Gas','1','LT 16 BLK 1 LANTANA SEC 2','Corner,Subdivision Lot','7196','Appraisal District','','470','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS PARK HIGH SCHOOL','ROWE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Lantana','','','Water District','2020','Appraisal District'); --> New record created successfully