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-21T15:55:59.977' ,`MLSNumber` = '51794384' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215874' ,`Longitude` = '-95.352802' ,`PhotoCount` = '10' ,`PostalCode` = '77302' ,`RoomCount` = '6' ,`ListPrice` = '329990.00' ,`Status` = 'Active' ,`StreetName` = 'Wedge Hill' ,`StreetNumber` = '16837' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2489' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The two-story Granville features a first-floor owner’s suite, with luxurious bath and walk-in closet, ideal for privacy. Entertain in the gourmet kitchen and adjacent dining, and then relax for the night in the great room or upstairs game room.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '26/2/07' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mavera' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093962' WHERE `Matrix_Unique_ID` = '209442588' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T15:48:21.460' ,`MLSNumber` = '20852202' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Joauna Tuck' ,`SellingOfficeName` = 'Walzel Properties' ,`Latitude` = '30.232535' ,`Longitude` = '-95.235762' ,`PhotoCount` = '12' ,`PostalCode` = '77357' ,`RoomCount` = '7' ,`ListPrice` = '270990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Starry Night' ,`StreetNumber` = '21597' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FABULOUS NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Open Concept Design with Desirable Split Plan Layout! Impressive Foyer Opens to Gourmet Island Kitchen, Spacious Breakfast Nook, & Supersized Living Area! Privately Located Primary Suite Features Lovely Bath with Oversized Shower & Big Walk-In Closet! Spacious Secondary Bedrooms - Two with Walk-In Closets! Pretty Guest Bath with Tub/Shower Combo! Indoor Utility Room with Direct Garage Access! Covered Patio Accents Tranquil Outdoor Setting! Carrier 16 SEER A/C, Tankless Water Heater, Built-In Home Automation System Controlled by Single App, & Great Appliance Package! Wonderful Community with Splash Pad, Pool, Recreation Center, Trails, & On-Site Elementary School! WOW! Estimated Completion - November 2022.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Harrington Trails 8, BLOCK 1, Lot 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093963' WHERE `Matrix_Unique_ID` = '211694693' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T16:56:27.043' ,`MLSNumber` = '67979601' ,`ListAgentFullName` = 'Aurelio Valdez' ,`ListOfficeName` = 'RE/MAX Prestige' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036650' ,`Longitude` = '-95.365645' ,`PhotoCount` = '20' ,`PostalCode` = '77373' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Twisting Pine' ,`StreetNumber` = '22923' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is available tenants have moved out. Go and show. \r\n\r\nHome has a new roof year 2022.' ,`Acres` = '0.1085' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 1 SPRING PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'MILDRED JENKINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Place' ,`TaxAmount` = '5076' ,`TaxRate` = '2.9367' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093963' WHERE `Matrix_Unique_ID` = '213842703' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-21T16:34:54.217' ,`MLSNumber` = '65894236' ,`ListAgentFullName` = 'Maria Rocha' ,`ListOfficeName` = 'Stoneburner & Associates ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064087' ,`Longitude` = '-95.512652' ,`PhotoCount` = '50' ,`PostalCode` = '77379' ,`RoomCount` = '11' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairway Meadow' ,`StreetNumber` = '20518' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2381' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A hole in one! Stop your search now! This home is right on the golf course with backyard access to the favorited Wind Rose Golf Course. The kitchen, family room & primary bedroom look directly out onto the low maintenance backyard and stunning view. The large windows paired with high ceilings make this beautiful home so light and bright. The home features 3 bedrooms, 1 was being used as a media room and office and has recessed lighting and is wired for sound. The primary bedroom has an ensuite bathroom complete with dual vanities and sinks, walk in shower, jetted tub and walk in closet with built in drawers and shelving. The kitchen has ample storage, island cooktop, breakfast bar and looks out into the family room and once again the beautiful back yard, patio & golf course! Perfect for entertaining. Greenspace to the right of home means you don\'t have an immediate neighbor on your right. Annual HOA dues include mowing of the front yard. Schedule your private tour today!' ,`Acres` = '0.1512' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 PINELAKES PROMENADE 1 AMEND' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '6585' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1442' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BENIGNUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN OAK HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinelakes Promenade 01 Amd' ,`TaxAmount` = '8192' ,`TaxRate` = '2.6765' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675093963' WHERE `Matrix_Unique_ID` = '213881397' --> 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','215105327','1675093963','215105327','2022-12-21T15:10:36.920','19278197','Alison Thompson','Coldwell Banker Realty, Cy-Fair Office','','','30.235203','-95.301269','11','77302','3','297000.00','Active','Old Houston','14780','Road','Conroe','2','0','3','1256','Single-Family','These two acres of land have so much to offer. With some renovations, these homes and land can be transformed into endless possibilities. This property has TWO homes; the first has three bedrooms and two bathrooms, and the second has three bedrooms and one bathroom. Additionally, there is a RV connection available on site. Due to its fantastic location, this multi-functional space can meet the needs for multiple uses, as it has NO RESTRICTIONS and can be used for COMMERCIAL or RESIDENTIAL.\r\n\r\n You can easily access I69, I45, and 99 from here.','2','19','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Conroe Southeast','Central Gas','0','PINE MEADOWS, LOT 23, ACRES 2.000','Cleared','87120','Appraisal District','','','0','','0','Gas Oven','0','','','Gas Range','','Composition','11 - Conroe','HOPE ELEMENTARY SCHOOL (CONROE)','CANEY CREEK HIGH SCHOOL','MOORHEAD JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Other Style','Pine Meadows','3600','1.8488','Public Water,Septic Tank','1945','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','215216992','1675093963','215216992','2022-12-21T15:20:43.240','62006351','Kitten Leopold','Leopold & Strahan Realty Group','','','29.388067','-94.908073','13','77590','3','129900.00','Active','4th','925','Avenue','Texas City','2','0','3','1074','Single-Family','INVESTOR ALERT! Three bedroom two bath currently tenant occupied. Monthly rent is $975.00. Hurry up and make an offer today! No showings without an agreed upon LOI between buyer and seller.','0.1147','33','','','','','Sellers Disclosure','','','','Texas City','Window Unit','0','LOT 2 BLK 1 PHISHEAD SUB (2019) ABST 205','Cleared','4997','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Phishead Sub','2517','2.5335','Public Sewer,Public Water','1967','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','215428362','1675093963','215428362','2022-12-21T15:31:07.567','41133275','Kitten Leopold','Leopold & Strahan Realty Group','','','29.388070','-94.907714','6','77590','2','103775.00','Active','4th','915','Avenue','Texas City','1','0','2','858','Single-Family','INVESTMENT OPPORTUNITY! One story 2 Bedroom 1 Bath home currently tenant occupied. Make an offer today!','0.1435','33','','','','','Sellers Disclosure','','','','Texas City','Other Heating','0','LOT 3 BLK 1 PHISHEAD SUB (2019) ABST 205','Other','6250','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)','TEXAS CITY HIGH SCHOOL','BLOCKER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Phishead Sub','2043','2.445','Public Sewer,Public Water','1950','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','215542381','1675093964','215542381','2022-12-21T16:02:42.443','22367892','Marisol Sosa','RE/MAX Real Estate Assoc.','','','25.592172','-99.996195','26','65900','8','75000.00','Active','JUAN DE LA BARRERA','1105','','Other','2','0','2','1170','Single-Family','BEAUTIFUL HOME IN THE MAKING!!LOCATED IN THE NICE TOWN OF CERRALVO, NUEVO LEON. YOU CAN FINISH BUILDING IT AT YOUR LIKE. 2 BEDROOM 1 BATH INSIDE, 1 BATH OUTSIDE, OPEN CONCEPT KITCHEN AND LIVING AREA. TONS OF NATURAL LIGHT. TILE TROUGHOUT THE HOUSE. VERY WIDE MAIN DOOR TO THE HOUSE, VERY SPACIOUS BATHROOM. IT HAS A HUGE PATIO, AND A COVER ARE TO PARK 3 CARS. COMPLETE FENCE OUT, WALLS MADE OUT OF BLOCKS AND CONCRETE, FRONT PART OF THE PROPERTY HAS BLOCK FENCE AND IRON BARS. HAS ALL SERVICES: WATER LINES, ELECTRICITY, SEWER AND SEPTIC TANK, TELEPHONE LINE SERVICE AS WELL. VERY WELL LOCATED IN CERRALVO, N.L MEXICO.\r\nCALL ME TO GET MORE INFORMATION!!!','','','','','','','No Disclosures','','','','','No Heating','0','LOTE 6 MANZANA 14B','Cleared','7000','Other','','','0','','0','','0','','','','','Other','','','','','No Supra Keybox','Appraisal','1','Traditional','COLONIA BERNABE BOTELLO','','','Public Sewer,Septic Tank','2004','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','215747510','1675093964','215747510','2022-12-21T15:51:09.263','11220056','Asma Tyebally','Keller Williams Hou Preferred','','','30.102671','-95.610326','45','77375','8','549000.00','Active','Foster','417','Street','Tomball','2','1','4','2592','Single-Family','COUNTRY STYLE LIVING WITH A MODERN TOUCH.FABULOUS HOME SITS ON 5 LOTS, TOTALG 17,500SQ FT.THIS RARE HOME HAS A LG DRIVEWAY& AN OVERSIZED GARAGE (30FT WIDE BY 40 FT DEEP).IT CAN FIT 6-7 CARS EASILY,PLUS IT IS ALSO PLUMBED FOR H2O,ELECTRICITY &A/C LINE.IT HAS A SEPARATE DR &BY ADDING SOME SHEETROCK, IT CAN SERVE AS STUDIO OR MAYBE AN OFFICE.THE HOME HAS BEEN EXTENSIVELY RENOVATED WITH AN OPEN FLRPLAN .BRAND NEW FRONT DR UPON ENTRY WITH WD TILES FLRING, NEW PAINT,NEW LIGHT FIXTURES,NEW BATHRMS, & A TOTALLY NEW STAIRCASE WITH SOLID WD FLRS.FIREPLACE HAS FLR TO CEILING FLAGSTONE TILES. GOURMET KITCHEN HAS AN EXTENDED GRANITE ISLAND, GREY CABINETS, MOSAIC BACKSPLASH COMPLETE WITH SS APPLIANCES,PERFECT FOR ENTERTAINING & HOSTING.MASTER IS DOWN WITH SPACIOUS BATH THAT HAS HIS & HER BASINS ,SEPARATE TUB &SHOWER.ALL OTHER BEDRMS ARE UP INCLUDING THE GAME ROOM.SELLER ADDED ADDITIONAL STAMP CONCRETE IN THE BACKYARD AND GRAVEL BY THE PATHWAYS FOR OUTDR SEATING .ROOF &H2O HEATER IS ONLY 2 YRS OLD.','0.3214','14','','','','','Sellers Disclosure','1','Wood Burning Fireplace','1','Tomball','Central Electric','0','LTS 42&43 BLK 77 TOMBALL PAR R/P','Subdivision Lot','14000','Appraisal District','','','0','','6','Freestanding Oven','0','','','Freestanding Range','','Composition','53 - Tomball','TOMBALL ELEMENTARY SCHOOL','TOMBALL HIGH SCHOOL','TOMBALL JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Other Style','Tomball','7360','2.3717','Public Sewer,Public Water','1997','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','215780554','1675093964','215780554','2022-12-21T16:19:33.217','16016291','Tamatha Mayfield','Lucky Money Real Estate','','','30.092246','-95.214523','16','77365','3','165000.00','Active','Evergreen','24390','Drive','Porter','2','0','3','1120','Single-Family','Great starter property or investment opportunity. New flooring added. A separate studio-like apartment with a kitchen and shower is available! 2 storage sheds in the back with plenty of storage. Must see!','0.2176','40','','','','','Mud,Sellers Disclosure','','','','Porter/New Caney East','Central Electric','0','S866002 - SHADOW LAKE ESTATES 02, LOT 17, SERIAL TXFL1AE2989','Cleared','9480','Appraisal District','','','0','','0','','0','','','','','Other','39 - New Caney','PORTER ELEMENTARY SCHOOL (NEW CANEY)','PORTER HIGH SCHOOL (NEW CANEY)','WOODRIDGE FOREST MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Shadow Lake Estates 02','1293','2.5431','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','215788342','1675093964','215788342','2022-12-21T16:08:44.620','22098777','Kristina Santana','Vibrant Realty LLC','','','29.386948','-94.980329','20','77591','4','95000.00','Active','Woodrow','6113','Street','Texas City','1','0','2','520','Single-Family','CHARMING HOME! FULLY RENOVATED, WOOD FLOOR THROUGH THE WHOLE HOUSE, 2 BEDS 1 BATH, SPACIOUS MASTER BEDROOM, FULL BATH , LARGE LIVING ROOM FOR FAMILY ENTERTAINING, NICE KITCHEN WITH STAIN-LESS STEEL APPLIANCES, WAHER &DRYER ARE INCLUDED. LARGE PATIO FOR CHILDREN ACTIVITIES AND SUMMER PARTIES. THIS HOME IS CONVENIENT LOCATED CLOSE TO FWY, SHOPPING CENTERS AND RESTAURANTS. CALL/TEXT','0.1148','33','','','','','No Disclosures,Sellers Disclosure','','','','Texas City','Window Unit','0','ABST 197 M AUSTIN SUR LOT 43 WRIGHT CUNEY SUB','Cleared','5000','Appraisal District','','','0','','1','','0','','','','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Accompany,Appointment Required,Controlled Access,No Supra Keybox,Request Online Appointment','Appraisal District','1','Traditional','Wright Cuney','','','Public Sewer,Public Water','1945','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','215788682','1675093964','215788682','2022-12-21T16:15:31.580','67328565','Kristina Santana','Vibrant Realty LLC','','','29.503427','-95.095976','37','77573','7','229000.00','Active','Saunders','304','Street','League City','2','0','4','1732','Single-Family','This renovated DOUBLE home plan! The main home (front) has 2 bedrooms and 1 full bath with a spacious living room, kitchen with sufficient amount of cabinetry and storage space that includes stainless steel appliances along with a washer/dryer. You\'ll also love the large outdoor patio, perfect for entertaining. The second home (back) is also plenty large with 2 bedrooms and 1 full bath which also includes all appliances. This home is a must see. Please contact listing agent for additional information! All room measurements should be verified by buyer.','0.1689','33','','','','','Sellers Disclosure','','','','League City','Central Gas','0','ABST 3 S F AUSTIN SUR LOT 63 PATTON SUB SEC TWO','Cleared','7357','Appraisal District','','','0','','2','','0','','','','','Composition','9 - Clear Creek','RALPH PARR ELEMENTARY SCHOOL','CLEAR CREEK HIGH SCHOOL','VICTORYLAKES INTERMEDIATE SCHOOL','Accompany,Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Patton 2','3434','2.0697','Public Sewer,Public Water','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','215789008','1675093964','215789008','2022-12-21T16:23:09.647','73858667','Kristina Santana','Vibrant Realty LLC','','','29.382461','-94.986623','32','77591','3','139000.00','Active','Cobb','108','Street','Texas City','1','0','2','804','Single-Family','Beautifully remodeled one bedroom home located in La Marque. Enjoy the oversized yard with plenty of room. This renovated home features a gourmet kitchen with brandnew stainless steel appliances, quartz countertops, and the fridge is included. Conveniently located near restaurants and major highways while offering an updated bathroom plus plenty of room, this home is a must see.','0.1213','33','','','','','No Disclosures','','','','Texas City','Central Electric','0','ABST 638 J LEAGUE SUR LOT 91 THELMA D ARMSTRONG SUB','Cleared','5283','Appraisal District','','','0','','0','','0','','','','','Composition','52 - Texas City','SIMMS ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Armstrong T D','1741','2.582','Public Sewer,Public Water','1950','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','215789231','1675093964','215789231','2022-12-21T16:42:00.177','26412839','Bradley Tiffan','Legend Home Corporation','','','29.831112','-95.803706','29','77493','4','245990.00','Active','Landolfi','24826','Drive','Katy','2','1','3','1311','Single-Family','Love where you live in Camillo Lakes in Katy, TX! The Butler floor plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all - including blinds, upgraded carpeting in the bedrooms, and vinyl plank flooring throughout the first-floor common areas! The first floor offers the perfect entertainment space with a large kitchen overlooking the family room! The gourmet kitchen is sure to please with 42\" cabinets and granite countertops! Retreat to the Owner\'s Suite featuring a sizable shower and spacious walk-in closet! Enjoy the great outdoors with full sod, sprinkler system, and covered patio! Don\'t miss your opportunity to call Camillo Lakes home, schedule a visit today!','','25','Legend Homes','','Electric Dryer Connections,Washer Connections','','Mud','1','','','Katy - Old Towne','Central Gas','1','LT 81 BLK 1 Sec 6','Subdivision Lot','2550','Appraisal District','','875','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','30 - Katy','LEONARD ELEMENTARY SCHOOL (KATY)','PAETOW HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','2','Traditional','Camillo Lakes','','3.52','Water District','2023','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','215789521','1675093964','215789521','2022-12-21T16:44:49.277','33029384','Ryan Rush','HomeSmart','','','29.989129','-95.163244','30','77346','4','299000.00','Active','Fuchsia','7518','Lane','Humble','2','1','4','2021','Single-Family','Upgraded and in a premium culdesac lot, this house is ready for immediate occupancy. Close to a large variety of restaurants and shopping, and not far from 59 or the Beltway. Close to Lake Houston as well. Once the FM 1960 expansion has been completed, longer commuting times will be reduced even more. Some highlights: New flooring almost throughout the house, brand new stainless steel appliances, brand new granite counter top in the kitchen, LED lights everywhere, no carpet. See the pics! Super quiet part of the neighborhood','0.1492','1','','','','','Owner/Agent','1','','1','Atascocita South','Central Gas','1','LT 32 BLK 4 ATASCOCITA SOUTH SEC 1','Subdivision Lot','6500','Appraisal District','','443','0','','2','','0','','','','','Composition','29 - Humble','TIMBERS ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Atascocita South Sec 01','4571','2.3974','Public Sewer,Public Water','1979','Appraisal District'); --> New record created successfully