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-12-21T21:13:50.553' ,`MLSNumber` = '21356929' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.585614' ,`Longitude` = '-95.055143' ,`PhotoCount` = '8' ,`PostalCode` = '77586' ,`RoomCount` = '9' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmgrove Park' ,`StreetNumber` = '1215' ,`StreetSuffix` = 'Lane' ,`City` = 'Pasadena' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 4 bedroom home located in the Clear Lake Area. Part of CCISD with an elementary school down the street. 10 minutes from NASA bypass and 10 minutes from Beltway 8.\r\n\r\nHouse within last month has been professionally painted and cleaned inside and out. Spotless and ready to move in. Bathrooms have been remodeled and backyard is a shade tree porch paradise.\r\n\r\n--Roof- 2008 / AC\'s & Partial ductwork - 2010 / Tankless water heater - 2020\r\n--The roof was inspected/approved this month by local roofer. Documentation and contact info will be provided.' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 1 KIRBY PLACE' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROBINSON ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirby Place' ,`TaxAmount` = '5382' ,`TaxRate` = '2.5419' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675094057' WHERE `Matrix_Unique_ID` = '210863430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T21:07:26.303' ,`MLSNumber` = '30719955' ,`ListAgentFullName` = 'Paulino Miranda' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704473' ,`Longitude` = '-95.366007' ,`PhotoCount` = '39' ,`PostalCode` = '77021' ,`RoomCount` = '4' ,`ListPrice` = '337999.00' ,`Status` = 'Active' ,`StreetName` = 'Tampa' ,`StreetNumber` = '3507' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home near the medical center, zoo, museums, NRG Stadium, shopping and easy access freeways. This home is a 4 bedroom 2 full baths with modern updates from flooring to tub tiles. Stainless steel appliances surrounded with shaker style cabinets, quartz countertops, patio in back yard for your entertaining, great floor plan. Come visit this home and make it yours!' ,`Acres` = '0.1337' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 TERRACE OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'THOMPSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Terrace Oaks' ,`TaxAmount` = '5292' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094057' WHERE `Matrix_Unique_ID` = '215115371' --> 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','215556394','1675094058','215556394','2022-12-21T21:39:13.070','89628367','Dwight Vincent','Icon Realty Group, L.L.C.','','','30.368439','-95.621544','48','77356','7','347499.00','Active','April Waters','185','Drive','Conroe','2','0','3','1814','Single-Family','TOTALLY UPDATED 1 STORY HOME IN WELL SOUGHT APRIL SOUND SUBDIVISION- LAKE AND COUNTRY CLUB LIFE ALL IN ONE - FRESH PAINT INSIDE AND OUT- GORGEOUS VINYL PLANK WOOD FLOORS- NEW STAINLESS STEEl APPLIANCES- NEW KITCHEN AND BATHROOMS W/ GRANITE COUNTERTOPS- SPACIOUS MASTER SHOWER WITH BENCH SEAT - NEW HARDWARE- BEAUTIFUL ACCENT FIREPLACE- LARGE MASTER CLOSET WITH BUILT-INS - 2 SKYLIGHTS FOR NATURAL LIGHT- PLANTATION SHUTTERS IN BEDROOMS- YOU WILL LOVE THIS HOUSE- COME SEE ME TO FULLY APPRECIATE ALL WE HAVE TO OFFER...','0.2247','39','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding','1','Lake Conroe Area','Central Gas','1','APRIL SOUND 07, BLOCK 1, LOT 63','Cul-De-Sac,In Golf Course Community,Subdivision Lot','9788','Appraisal District','','234','0','','2','Freestanding Oven','0','','','Gas Cooktop,Gas Range','','Composition','37 - Montgomery','STEWART CREEK ELEMENTARY SCHOOL','LAKE CREEK HIGH SCHOOL','OAK HILL JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Vacant/Unoccupied','Appraisal District','1','Ranch,Traditional','April Sound 07','4176','2.2625','Public Sewer,Public Water,Water District','1994','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','215579107','1675094058','215579107','2022-12-21T21:14:20.160','49719838','Atia Willis','NextHome Executives','','','29.655610','-95.378534','25','77051','3','150000.00','Active','Wilmington','3102','Street','Houston','1','0','3','807','Single-Family','This is a fantastic investment opportunity on a large lot. This neighborhood is developing and growing every year. This home has only had one family life since it was built in 1955. Still a charming home that can be lived in. The roof is less than five years old. And the house has been loved and cared for by the precious owner\'s family. Now they are ready to sell. This home could be renovated or the lot could be an area for a new construction project.','0.2104','3','','','','','No Disclosures','','','','Medical Center South','Other Heating','0','LT 3 BLK 5 REEDWOODS','Cleared','9165','Appraisal District','','','0','','1','','0','','','','','Slate','27 - Houston','REYNOLDS ELEMENTARY SCHOOL (HOUSTON)','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Reedwoods','1479','2.3307','Water District','1955','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','215769588','1675094058','215769588','2022-12-21T22:47:26.737','63888951','Mio Yamada','Seeto Realty','','','30.018950','-95.297875','22','77338','7','224000.00','Active','Oak Limb','20419','Court','Humble','2','0','3','1524','Single-Family','Located just 10 minutes from George Bush International Airport, the house is tucked away in a quiet neighborhood with fast access to major highways and retail/restaurants. The floorplan combines comfort and utility, with vaulted living room ceilings and a cozy fireplace, tiled floors throughout, and organizational shelving in the bedrooms and utility area. The water heater was replaced in 2020, and landscaping work including the backyard fence and raised garden beds was also updated in recent years.','','12','','','Gas Dryer Connections','','Mud,Other Disclosures,Sellers Disclosure','','','','Humble Area West','Central Electric','0','LT 16 BLK 6 KENSWICK SEC 5','Cul-De-Sac,Subdivision Lot','','','','245','0','','2','','0','','','','','Composition','1 - Aldine','JONES ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Temporarily No Showings','Appraisal District','1','Traditional','Kenswick','','','Public Sewer,Water District','1983','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','215769796','1675094058','215769796','2022-12-21T22:57:47.240','75945732','Mio Yamada','Seeto Realty','','','29.962651','-95.470247','8','77067','6','220000.00','Active','Kodiak','2658','Court','Houston','2','0','3','1530','Single-Family','Huge corner lot with a spacious fenced backyard and a great 3 bedroom 2 full bathroom floorplan. The house has tiled floors throughout (no carpet) and granite countertops. The A/C Condenser and Ducts were replaced new within the last 2 years. Quick access to Sam Houston Tollway and reasonable distance of I-45, making commuting into the city or up north convenient. Also has many retail/restaurant options in the vicinity, not to mention the proximity to IAH.','','13','','','','','Mud','','','','1960/Cypress Creek South','Central Electric','0','LT 3 BLK 5 CAMDEN PARK SEC 3','Corner,Subdivision Lot','','','','400','0','','2','','0','','','','','Composition','48 - Spring','DONNA LEWIS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','STELLE CLAUGHTON MIDDLE SCHOOL','Appointment Required,Temporarily No Showings','Appraisal District','1','Traditional','Camden Park','','','Public Sewer,Public Water','1983','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','215789866','1675094058','215789866','2022-12-21T21:04:22.463','59682054','Sherrie Bass','Bluewater Realty','','','29.073298','-95.125396','5','77541','5','598000.00','Active','Buccaneer','13019','Parkway','Freeport','2','1','3','1500','Single-Family','New Construction! New construction beachside in Treasure Island. Home is projected to be finished March 2023, just in time for Spring and Summer use. 3 bedroom, 2.5 bath open concept home. Treasure Island is a fun golf cart community that offers easy access to beach and bay.','0.1435','5','Speich Custom Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Treasure Island','Central Electric','1','TREASURE ISLAND (A0029 S F AUSTIN), BLOCK 6, LOT 29','Subdivision Lot,Water View','6251','Appraisal District','','100','1','To Be Built/Under Construction','0','','0','','','Freestanding Range','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Builder','1','Other Style','Treasure Island','1766','2.1725','Aerobic,Water District','2022','Builder'); --> 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','215793957','1675094058','215793957','2022-12-21T21:01:12.943','26536863','Chynna Withrow','Champions Realty, LLC','','','30.101961','-94.127809','34','77703','3','280000.00','Active','10th','2540','Street','Beaumont','2','0','3','1891','Single-Family','LT 8A REPLAT S37.75\' LT 7 ALL LT 8 & N41.5\' L9 BLK 2 PECAN GROVE .2443AC','0.2443','51','Landry & Jackson Res','','','','No Disclosures','','','','','Central Electric','0','LT 8A REPLAT S37.75\' LT 7 ALL LT 8 & N41.5\' L9 BLK 2 PECAN G','Cleared','10641','Appraisal District','','','1','Never Lived In','2','','0','','','','','Composition','143 - Beaumont','JONES-CLARK ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','SMITH MIDDLE SCHOOL (BEAUMONT)','Leave Business Card,Supra Keybox','Builder','1','Traditional','Pecan Grove To Beaumont','88','2.6134','Public Sewer,Public Water','2022','Builder'); --> New record created successfully