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-19T20:02:39.273' ,`MLSNumber` = '71660077' ,`ListAgentFullName` = 'Rick Dittemore' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875742' ,`Longitude` = '-95.701874' ,`PhotoCount` = '17' ,`PostalCode` = '77449' ,`RoomCount` = '5' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Dillsbury' ,`StreetNumber` = '19219' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great starter home in a prime Katy location close to schools shopping and restaurants. This brick home boasts large rooms, an eat in kitchen, double sinks in both baths, spacious closets and a covered back patio. This home is great for entertaining family and friends. Seller may carry note... Hurry this one won\'t last!' ,`Acres` = '0.1313' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 66 BLK 1 STRATHMORE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Strathmore Sec 02' ,`TaxAmount` = '4706' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675216327' WHERE `Matrix_Unique_ID` = '211132904' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T20:28:20.493' ,`MLSNumber` = '20336082' ,`ListAgentFullName` = 'Holly Jackson' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834890' ,`Longitude` = '-94.858135' ,`PhotoCount` = '47' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Wincrest' ,`StreetNumber` = '9719' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You’ll love everything about this executive style home. If you need room for your large group, or just want to spread out in a larger home and lot, this home will check all your boxes. Inside you’ll find a formal dining room, separate study/formal living, kitchen with a gas stove top, wall oven and microwave, large breakfast space, and huge primary suite down stairs. Five bedrooms, two full baths and game room upstairs. One of the large bedrooms would make a great media room or second game room. Outside there’s an extra wide drive for overflow parking, fully fenced back yard with a nice pool, huge covered patio with custom stamped concrete, outdoor kitchen space, and built-in, gas fire pit. No back neighbors here with the new Mont Belvieu park just behind this property (see park plan in photo section). Call today to make his great home yours!' ,`Acres` = '0.218' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 6 LT 18 EAGLE CREEK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL NORTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL NORTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Creek' ,`TaxAmount` = '7413' ,`TaxRate` = '2.1487' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216327' WHERE `Matrix_Unique_ID` = '211682937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T19:49:27.347' ,`MLSNumber` = '87191614' ,`ListAgentFullName` = 'Ebin Kurian' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.510009' ,`Longitude` = '-95.416449' ,`PhotoCount` = '16' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 48' ,`StreetNumber` = '5134' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in a prime location facing County Road 48 with easy access to Hwy 288 and Hwy 6. This property holds a world of opportunities including commercial and residential. With no restrictions, this property offers all the convenience of the city and plenty of room like in the country. Plenty of new developments close by including major gas stations. This property and the adjacent property are both for sale. Great for investors and homeowners. Located between the sought-out communities of Lakes of Savannah, Rodeo Palms, Cold River Ranch, Newport Lake Estates & Pomona!' ,`Acres` = '0.424' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0562 H T & B R R TRACT 1A LOT 15C-15B1 ACRES 0.424' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '18469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '3649' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216327' WHERE `Matrix_Unique_ID` = '213564549' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T19:21:34.077' ,`MLSNumber` = '39136663' ,`ListAgentFullName` = 'Rohit Sareen' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405356' ,`Longitude` = '-95.259525' ,`PhotoCount` = '18' ,`PostalCode` = '77511' ,`RoomCount` = '6' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwood' ,`StreetNumber` = '1713' ,`StreetSuffix` = 'Circle' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1952' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home offers 3 bedrooms 2 baths, New Roof, New Flooring, Fresh Paint, New Granite Countertops, New windows, New water heater, Fully renovated baths, an extra room off the kitchen area, large pantry, open concept living, beautiful flooring & lovely color decor. Large open den area, high ceilings, french doors! overlooking back yard area with nice shade trees! NO HOA. Large Cul-de-sac lot with no back neighbors' ,`Acres` = '0.2197' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PARK CREST (ALVIN), LOT 31 SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9570' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Crest Alvin' ,`TaxAmount` = '5918' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216328' WHERE `Matrix_Unique_ID` = '214476637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-19T20:46:14.120' ,`MLSNumber` = '34820179' ,`ListAgentFullName` = 'Kamilah Sage' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659732' ,`Longitude` = '-95.366229' ,`PhotoCount` = '26' ,`PostalCode` = '77051' ,`RoomCount` = '6' ,`ListPrice` = '160000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallow' ,`StreetNumber` = '4134' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION, LOCATION, LOCATION!!! Seller now able to Accept CONV, FHA, & VA !!!! Bring All Offers!!!\r\nThis home is conveniently located just 10 mins from the medical center, 15 mins from Meyerland Shopping Center and Downtown Houston, and 10 mins to NRG Stadium! New Development all Around!! SIMPLY GORGEOUS 3 bedroom home is Fully Updated and Ready for you to make your own!! With beautiful laminate flooring, LED Recess lighting all throughout, Quartz counter tops, huge backyard-perfect for entertaining and family cookouts, or simply build a garage apartment. In addition, Roof and Foundation is in great condition! Makes it perfect for a first-time homeowner, Short term rental (Air bnb), or Investment property...the possibilities are endless! No HOA Make an appointment to view this Magnificent Home today!!' ,`Acres` = '0.1518' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 8 REED TERRACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Reed Terrace' ,`TaxAmount` = '4168' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675216328' WHERE `Matrix_Unique_ID` = '215084218' --> 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','215890530','1675216328','215890530','2023-01-19T20:22:33.483','6150520','Carole Michalak','Coastal Dream Properties','','','29.492898','-95.126379','10','77573','6','219900.00','Active','Ewell','2515','Drive','League City','2','0','3','1251','Single-Family','Great neighborhood in CCISD. Home features 3 bedrooms, 2 bathrooms with a one car garage and oversized back yard. Floor plan is split with primary bedroom and bath on one side of the house, and secondary bedrooms and bathroom on the other side for privacy for everyone. Living room features vaulted ceilings and a pass through kitchen breakfast bar with great windows in all rooms, for all day natural light. Excellent schools, beautiful community pool and parks just steps away. Perfect distance to commute to Houston or Galveston or just a few miles from NASA. This house is the perfect central location for you!','0.1679','33','','','','','Mud,Sellers Disclosure','1','','0','League City','Central Electric','1','ABST 9 DICKINSON J SUR LOT 3 BLK 5 THE LANDING SEC 1','Subdivision Lot','7315','Appraisal District','','','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','9 - Clear Creek','ROSS ELEMENTARY SCHOOL (CLEAR CREEK)','CLEAR SPRINGS HIGH SCHOOL','CREEKSIDE INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','The Landing','3449','2.0262','Water District','1980','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','216347514','1675216328','216347514','2023-01-19T20:40:39.023','5744328','Judith Hayes','Designed Realty Group','','','29.941784','-95.237984','43','77396','8','330000.00','Active','Small Pebble','10038','Way','Humble','2','0','4','2177','Single-Family','Conveniently located in this gorgeous gated community! Very desirable 4 bedroom 2 bath ONE story home on cul de sac lot. STUNNING owner\'s retreat with spa like bath means Friday night bubbles in this beautiful soaking tub! Frameless tile shower with rock tile floor, spa fixtures, tile floors, granite counters, double sinks, cabinets with hardware and huge walk in closet! Updated kitchen provides newer appliances with refrigerator included, granite counters, island with seating and storage, built in desk with tons of cabinets for storage all open to the HUGE family room! Formal dining with kitchen access. Tile flooring that looks like wood throughout main areas of home. Neutral paint. Secondary bedrooms are nice sized and secondary bath is updated. Covered back patio with large back yard spacious enough for fur babies and children. AC replaced in 2020. Enjoy all the amenities Canyon Gate has to offer your family including the recreational center, pool, tennis courts, lakes and parks.','0.1515','1','Chesmar Builder','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Humble Area East','Central Gas','1','LT 27 BLK 2 CANYON GATE AT PARK LAKES SEC 7','Cul-De-Sac','6600','Appraisal District','','1045','0','','2','','0','','','','','Composition','29 - Humble','PARK LAKES ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','HUMBLE MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','1','Traditional','Canyon Gate/Pk Lakes Sec 07','6972','2.9873','Public Sewer,Public Water,Water District','2006','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','216429544','1675216328','216429544','2023-01-19T19:07:55.163','22860761','Darlene Torres','Brokerology Properties','','','27.652794','-97.364000','22','78414','4','550000.00','Active','Longitude','7309','Court','Corpus Christi','2','0','4','2716','Single-Family','The house is a 4/3, 3,375 sq. ft. living and the lot is 8,847 sq. ft. Top schools, theater room, 4 parking spaces, a wet bar. A MUST SEE.','0.2031','85','','','Electric Dryer Connections,Washer Connections','','No Disclosures','','','','','Central Gas','0','AIRLINE ESTATES BLK 2 LOT 34','Subdivision Lot','8847','Appraisal District','','','0','','2','','0','','','','','Composition','440 - Corpus Christi','KOLDA ELEMENTARY SCHOOL','VETERANS MEMORIAL HIGH SCHOOL (CORPUS CHRISTI)','KAFFIE MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Contemporary/Modern','Airline Estates','9447','2.488','Public Sewer','2020','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','216450836','1675216328','216450836','2023-01-19T20:55:11.150','58867898','Johnny Tran','Texas Ally Real Estate Group,','','','29.729245','-95.361363','44','77004','6','449900.00','Active','Ennis','3509','Street','Houston','3','1','3','1957','Single-Family','Modern freestanding homes in the highly sought after Emancipation Park neighborhood. Contemporary design with many upgraded features including luxury vinyl plank floors, quartz countertops, stainless steel appliances, shaker style cabinets, modern backsplash, and much more. The neutral gray colors make the home feel very warm and inviting. Enjoy entertaining your guests with the open living/kitchen area leading to a large private backyard with covered patio. Each bedroom has its own private bathroom. Bonus flex space upstairs can make for an extra living room. Convenient location to downtown, freeways, and the newly renovated Emancipation Park. No HOA so short term rentals and airbnb rentals are welcome. Enjoy your covered patio with your very own private backyard. Home expected completion March 2023','','4','Andares Construction','','','','No Disclosures','','','','University Area','Central Electric','0','Lot 6 Block 1 Ennis Crossing','Subdivision Lot','2500','Other','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','2','Contemporary/Modern','Ennis Crossing','','','Public Sewer,Public Water','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','216451302','1675216328','216451302','2023-01-19T19:04:58.327','97659904','Johnny Tran','Texas Ally Real Estate Group,','','','29.729076','-95.361268','37','77004','5','439900.00','Active','Holman','3004','Street','Houston','3','1','3','1925','Single-Family','Modern freestanding homes in the highly sought after Emancipation Park neighborhood. Contemporary design with many upgraded features including luxury vinyl plank floors, quartz countertops, stainless steel appliances, shaker style cabinets, modern backsplash, and much more. The neutral colors make the home feel very warm and inviting. Enjoy entertaining your guests with the open living/kitchen area leading to a large private balcony. Convenient location to downtown, freeways, and the newly renovated Emancipation Park. No HOA so short term rentals allowed. Expected home completion in Mar 2023','','4','Andares','','','','No Disclosures','','','','University Area','Central Electric','0','Lot 2 Block 1 Ennis Crossing','Subdivision Lot','1716','Appraisal District','','','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)','YATES HIGH SCHOOL','CULLEN MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','3','Contemporary/Modern','Ennis Crossing','','','Public Sewer,Public Water','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','216491155','1675216328','216491155','2023-01-19T19:55:27.573','43902778','April Ryan Glaser','Walzel Properties','','','29.854738','-95.597710','32','77041','5','439500.00','Active','Eldridge Place','12811','Drive','Houston','2','1','4','3271','Single-Family','No back neighbors!! Large home with four bedrooms, two and half bathrooms and a two-car garage. Backs to green space with a walking path and a large covered outdoor kitchen. Tree lined street in a well-established neighborhood. Island kitchen with stainless kitchen appliances. All appliances included. Covered main entry door. Walking distance to community pool. Lots of natural light. Move-in ready!!','0.1779','8','','','','','Mud,Sellers Disclosure','1','','1','Eldridge North','Central Gas','1','LT 6 BLK 4 ELDRIDGE PARK SEC 5','Greenbelt,Subdivision Lot','7751','Appraisal District','','610','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Eldridge Park Sec 05','8841','2.471','Water District','1999','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','216505366','1675216328','216505366','2023-01-19T20:03:41.860','57959981','Jeffrey Lutz','RE/MAX Fine Properties','','','29.388118','-95.838186','50','77461','11','339900.00','Active','Candlewood','3810','Circle','Needville','2','0','4','2097','Single-Family','FINALLY, Another home in the desired Highland Pointe Subdivision. This wonderful home offers a very spacious and well maintained, 1 story home. Light bright and neutral, not to mention clean as a whistle. With four nice size bedrooms, this +/-2097 sqft home is very well used with no wasted space. The family room is massive, with raised ceiling, nice ceramic tile, and wood burning fireplace. The kitchen, breakfast and dining are all defined spaces, yet still connected to and open to the family room. The primary suite is huge, with en-suite bath featuring double sinks, separate shower, soaking tub, water closet and walk in closet. Located in the back of the home and split from the secondary bedrooms. The other three big bedrooms and full bath are at the front of the home. Don\'t miss the great outdoor entertaining area both covered and uncovered patios ready to enjoy with friends and family. Recent HVAC system and hot water heater, along with lots of other nice touches an updates as well.','0.1928','30','Identity Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','1','','Central Gas','1','HIGHLAND POINTE SEC 2, BLOCK 1, LOT 15','Subdivision Lot','8400','Appraisal District','','75','0','','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','38 - Needville','NEEDVILLE ELEMENTARY SCHOOL','NEEDVILLE HIGH SCHOOL','NEEDVILLE JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Highland Pointe Sec 2','5769','2.2544','Public Sewer,Public Water','2003','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','216520435','1675216328','216520435','2023-01-19T19:11:55.817','47865683','Darlene Torres','Brokerology Properties','','','29.932631','-93.906249','9','77619','2','130000.00','Active','Owens','2300','Avenue','Groves','1','0','2','1768','Single-Family','Investor special must see. House is vacant, needs TLC please call for showings.','0.1912','51','','','','','No Disclosures','','','','','Central Electric','0','LT 40 BLK ROSELAWN','Other','8330','Appraisal District','','','0','','0','','0','','','','','Composition','236 - Port Arthur','ADAMS ELEMENTARY SCHOOL (PORT ARTHUR)','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)','Appointment Required','Appraisal District','1','Other Style','Roselawn','3182','3.1203','Public Water','1968','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','216556822','1675216328','216556822','2023-01-19T19:39:28.310','56129435','Nicole Handy','Braden Real Estate Group, LLC','','','29.624126','-95.291987','18','77075','8','342380.00','Active','Heath Knoll','7309','Lane','Houston','3','0','4','2606','Single-Family','The dual-level Mesilla plan addresses family needs for both privacy and\r\nsocialization. A first-floor fourth bedroom can easily convert to a separate guest\r\nsuite, home office, or playroom for the kids. A corner study is perfect for a home\r\noffice or playroom. Mom and Dad can unwind in their upstairs owner’s suite, then\r\nenjoy family time in the nearby game room.','','3','Centex','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','Hobby Area','Central Gas','1','Lot 4, Block 1','Subdivision Lot','','','','375','1','To Be Built/Under Construction','2','Electric Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','27 - Houston','DEANDA ELEMENTARY SCHOOL','STERLING HIGH SCHOOL (HOUSTON)','THOMAS MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Forbes Crossing','','2.94','Public Sewer,Public Water,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','216561634','1675216328','216561634','2023-01-19T19:53:15.130','91458192','Darlene Torres','Brokerology Properties','','','32.439447','-99.784726','8','79605','1','140000.00','Active','Bowie','1026','Drive','Abilene','1','0','1','1060','Single-Family','Great property, the bathrooms have been redone, the living room has new floors, and the kitchen needs a new floor. Just needs a little TLC','0.1594','84','','','','','No Disclosures','','','','','Central Gas','0','ELMWOOD WEST SEC 8, BLOCK 21, LOT 4','Other','6944','Appraisal District','','','0','','0','','0','','','','','Composition','275 - Abilene','BONHAM ELEMENTARY SCHOOL (ABILENE)','COOPER HIGH SCHOOL (ABILENE)','CLACK MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style','Elmwood West','2844','2.5389','Public Sewer','1953','Appraisal District'); --> New record created successfully