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-23T16:17:51.773' ,`MLSNumber` = '98361002' ,`ListAgentFullName` = 'Joaquin Santamaria' ,`ListOfficeName` = 'JOSA Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.878932' ,`Longitude` = '-95.461224' ,`PhotoCount` = '12' ,`PostalCode` = '77088' ,`RoomCount` = '6' ,`ListPrice` = '250900.00' ,`Status` = 'Active' ,`StreetName` = 'Storm Creek' ,`StreetNumber` = '3718' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'did not flood , all updated . great floor plan . for investor leased until July 24 rent $1700' ,`Acres` = '0.1025' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 INWOOD FOREST VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARAWAY ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'EISENHOWER HIGH SCHOOL' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Inwood Forest Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675218075' WHERE `Matrix_Unique_ID` = '199603127' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:27:52.917' ,`MLSNumber` = '45181236' ,`ListAgentFullName` = 'Leta Renee Ward' ,`ListOfficeName` = 'Ward Real Estate, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.980351' ,`Longitude` = '-95.981593' ,`PhotoCount` = '23' ,`PostalCode` = '77414' ,`RoomCount` = '9' ,`ListPrice` = '649999.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '700' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This spacious, stately home is centered on a full city block. The mature oak trees create a “park like” atmosphere where birds and squirrels abound. The entrance of this home possesses a grand spiral staircase with curved walls extending to the second floor. The entrance opens to a large living room with fireplace, dining room and warm welcoming den/family room also with a fireplace. The kitchen and breakfast area are loaded with storage, a china cabinet, large pantry and 2 locked silver closets. The utility room completes this area with ample storage, sink and work surface. To access the second floor an elevator is located in the hallway. The second floor boasts of 3 bedrooms with 3 full baths and large closets. This floor also has small room with a desk and a “bonus room”. The 5 car garage includes a wall of storage rooms and ½ bath. Off the garage is the former maid quarters which includes a bedroom and full bath with its own private entrance.' ,`Acres` = '2.0661' ,`Area` = '54' ,`BuilderName` = 'John Dibbern' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARK ADDITION, BLOCK 4, LOT 1-12' ,`LotDesciption` = 'Other' ,`LotSize` = '90000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Add' ,`TaxAmount` = '11514' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218075' WHERE `Matrix_Unique_ID` = '203805567' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:01:15.630' ,`MLSNumber` = '21080607' ,`ListAgentFullName` = 'Theresa Frazier' ,`ListOfficeName` = 'Heart of Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704959' ,`Longitude` = '-95.538114' ,`PhotoCount` = '26' ,`PostalCode` = '77340' ,`RoomCount` = '6' ,`ListPrice` = '199500.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '2511' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1491' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in right away! Great Location! Conveniently located close to Sam Houston State University, Interstate 45, and downtown Huntsville. Large non-restricted front and backyard. Great location for residential living, your rental, or a commercial business! Large 3 bedroom, 2 bath, hardwood floors, stove and refrigerator included. BIG backyard!' ,`Acres` = '0.5002' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIDS E SURVEY, LOT 28, ACRES 0.5002' ,`LotDesciption` = 'Corner' ,`LotSize` = '21789' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TBD' ,`TaxAmount` = '2378' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218076' WHERE `Matrix_Unique_ID` = '205642982' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:31:08.050' ,`MLSNumber` = '54172662' ,`ListAgentFullName` = 'Gene Feigelson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.914830' ,`Longitude` = '-93.986667' ,`PhotoCount` = '20' ,`PostalCode` = '75951' ,`RoomCount` = '0' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'GIBSON' ,`StreetNumber` = '915' ,`StreetSuffix` = 'Street' ,`City` = 'Jasper' ,`BathsFull` = '0' ,`BathsHalf` = '1' ,`BedsTotal` = '0' ,`SqFtTotal` = '2244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A COMMERCIAL BUILDING WITH FIVE BAYS OR CARPORTS. IT CAN BE A RETAIL STORE LOCATION FOR GROCERY OR AUTOMOTIVE. MECHANIC FOR TRUCK, AUTO OR MARINE EQUIPMENT. LARGE TRACT OF LAND WILL ACCOMODATE TRUCK TRACTOR OR TRACTOR UNIT WITH LONG VANS. PER APPRAISAL DISTRICT IT IS .599 ACRES OR OVER A HALF ACRE, 26092 SQ FT OF LAND. BUILDING IS ABOUT 2244 SQ FT WITH A STORAGE BUILDING IN THE REAR OF THE PROPERTY.' ,`Acres` = '0.599' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 2 JNO BEVIL TR 1499 1062 /796 0.599 ACRES' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '26092' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = 'JASPER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'JOHN BEVIL TRACT' ,`TaxAmount` = '1538' ,`TaxRate` = '2.1745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218076' WHERE `Matrix_Unique_ID` = '206379381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:24:30.837' ,`MLSNumber` = '76202743' ,`ListAgentFullName` = 'Lizabeth Comiskey' ,`ListOfficeName` = 'Comiskey Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297347' ,`Longitude` = '-94.924781' ,`PhotoCount` = '39' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '799997.00' ,`Status` = 'Active' ,`StreetName` = 'Easterly' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Canal Home with Two boat lifts and private pool.\r\nAll fenced\r\nFRESHLY PAINTED and NEW FLOORING on upstairs landing /hallway/bedrooms/closets\r\n\r\nFURNISHED!!!!\r\n\r\nMake this home yours!' ,`Acres` = '0.118' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 44 TIKI ISLAND SEC 9' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '26 - Hitchcock' ,`SchoolElementary` = 'HITCHCOCK PRIMARY/STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HITCHCOCK HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (HITCHCOCK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Tiki Island' ,`TaxAmount` = '13205' ,`TaxRate` = '2.2119' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218076' WHERE `Matrix_Unique_ID` = '207010740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:01:33.600' ,`MLSNumber` = '24624464' ,`ListAgentFullName` = 'Amanda Ham' ,`ListOfficeName` = 'AE Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.313481' ,`Longitude` = '-94.767491' ,`PhotoCount` = '50' ,`PostalCode` = '75904' ,`RoomCount` = '3' ,`ListPrice` = '849999.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '1208' ,`StreetSuffix` = 'Lane' ,`City` = 'Lufkin' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful 3/2, 3767 sqft home located on 1.5 acres in Lufkin, Tx. The outdoor living area consists of a sparkling pool, pergola and a fort for the children...or parents. The garage is 3 car with 1/3 going all the was through to the back. There is a game/pool room with a half bath and kitchenette great for entertainment. The master suite is a nice space with a door leading to the outside pergola. Also on the property, located in the back left of, there is a storage shed that can be used for a workshop, man cave, she-shed, or to store your toys. There are no back neighbors and the property backs up to privately owned land.' ,`Acres` = '1.5587' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3301 BROOKHOLLOW #7 BLK 1 LOT 43' ,`LotDesciption` = 'Other' ,`LotSize` = '67895' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'BROOKHOLLOW ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookhollow #7' ,`TaxAmount` = '9879' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218076' WHERE `Matrix_Unique_ID` = '207513026' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:30:54.700' ,`MLSNumber` = '8231361' ,`ListAgentFullName` = 'Carol Gerault' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.027447' ,`Longitude` = '-95.405439' ,`PhotoCount` = '48' ,`PostalCode` = '77531' ,`RoomCount` = '10' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Cannon' ,`StreetNumber` = '144' ,`StreetSuffix` = 'Street' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1812' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Front Room ( Entry) can be a Formal Living Room, Dining Room or Office/Study. The large Family Room can be\r\nthe dining area combo & entertainment area. The Kitchen is open to the Family Room for convenient serving.\r\nThere is a Breakfast area for those quick morning breakfasts. The bedrooms are all large and the inside Utility Room is close to the attached Sunroom in the back. The Guest Bath has a large walk-in Shower and a large\r\nMirrored Vanity area. All this on a beautiful landscaped lot.' ,`Acres` = '0.3712' ,`Area` = '5' ,`BuilderName` = 'Cut Rate - Macon' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EMERALD FOREST (A0066 J E GROCE)(CLUTE) BLK 2 LOT 2-3 **LIFE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16169' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Emerald Forest' ,`TaxAmount` = '5651' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218076' WHERE `Matrix_Unique_ID` = '208939124' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:06:27.947' ,`MLSNumber` = '11915583' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.367445' ,`Longitude` = '-95.672310' ,`PhotoCount` = '15' ,`PostalCode` = '77316' ,`RoomCount` = '7' ,`ListPrice` = '389990.00' ,`Status` = 'Active' ,`StreetName` = 'Gentle Falls' ,`StreetNumber` = '1407' ,`StreetSuffix` = 'Court' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Glenwood features three bedrooms, three bathrooms, and a massive family room for entertaining!' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 1, Section 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14936' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'Fairwater' ,`TaxAmount` = '' ,`TaxRate` = '2.58' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218077' WHERE `Matrix_Unique_ID` = '208974565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:32:25.360' ,`MLSNumber` = '89778324' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.849315' ,`Longitude` = '-102.348692' ,`PhotoCount` = '6' ,`PostalCode` = '79761' ,`RoomCount` = '3' ,`ListPrice` = '48999.00' ,`Status` = 'Active' ,`StreetName` = 'Fitch' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Avenue' ,`City` = 'Odessa' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1144' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A cute home in the heart of Odessa so expect a short commute to plenty of different dining and shopping options. Easy access to E Business Loop 20. Only a few minutes away from Odessa College and the University of Texas Permian Basin. Give us a call today for more information! AS IS.' ,`Acres` = '0.1377' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PATTERSON BLOCK 13 LOT 14' ,`LotDesciption` = 'Other' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '492 - Ector County' ,`SchoolElementary` = 'EL MAGNET AT MILAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PERMIAN HIGH SCHOOL' ,`SchoolMiddle` = 'NIMITZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Patterson' ,`TaxAmount` = '991' ,`TaxRate` = '2.3718' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218077' WHERE `Matrix_Unique_ID` = '209028611' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:28:16.720' ,`MLSNumber` = '65942998' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.212867' ,`Longitude` = '-101.488737' ,`PhotoCount` = '10' ,`PostalCode` = '79720' ,`RoomCount` = '3' ,`ListPrice` = '99777.00' ,`Status` = 'Active' ,`StreetName` = 'Connally' ,`StreetNumber` = '3700' ,`StreetSuffix` = 'Street' ,`City` = 'Big Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute starter home located in a quiet and developing subdivision. The property is within walking distance to Marcy Elementary School. Enjoy your weekends at Comanche Trail Park at the lake, golf course, theater, aquatic center, or playground. Family fun, peace and quiet awaits you at this location. This home currently features new interior/exterior paint, a new water heater, a new mailbox, painted kitchen cabinets, a new kitchen vent hood, and a new kitchen countertop. The 2 bathrooms also feature new light fixtures. Call to see it today!' ,`Acres` = '0.156' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.156 LT 23 BK 13 DOUGLASS #2 59X115 323 ACQ 11192020' ,`LotDesciption` = 'Other' ,`LotSize` = '6795' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '341 - Big Spring' ,`SchoolElementary` = 'GOLIAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BIG SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'BIG SPRING JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Douglass Add #2' ,`TaxAmount` = '902' ,`TaxRate` = '2.2535' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218077' WHERE `Matrix_Unique_ID` = '209030089' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:00:48.410' ,`MLSNumber` = '93770700' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.922002' ,`Longitude` = '-98.504089' ,`PhotoCount` = '8' ,`PostalCode` = '76306' ,`RoomCount` = '1' ,`ListPrice` = '35879.00' ,`Status` = 'Active' ,`StreetName` = '7th' ,`StreetNumber` = '1208' ,`StreetSuffix` = 'Street' ,`City` = 'Wichita Falls' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '621' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make this cute little home yours today! It needs a little bit of work and then it can be the home of your dreams. You can also expand the living areas and still have plenty of space left over for the children to play in or create your own personal garden! Easy access to HWY 240 and I-45. Surrounded by so many amenities, eateries, and shopping locations! AS IS.' ,`Acres` = '0.1607' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 20 BLK 16 SCOTLAND' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1036 - Wichita Falls' ,`SchoolElementary` = 'SCOTLAND PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIRSCHI HIGH SCHOOL' ,`SchoolMiddle` = 'KIRBY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scotland' ,`TaxAmount` = '126' ,`TaxRate` = '2.7399' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218077' WHERE `Matrix_Unique_ID` = '209036351' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:24:07.110' ,`MLSNumber` = '31266330' ,`ListAgentFullName` = 'Yolanda Dittmar' ,`ListOfficeName` = 'Dittmar Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.177784' ,`Longitude` = '-99.014101' ,`PhotoCount` = '47' ,`PostalCode` = '78624' ,`RoomCount` = '9' ,`ListPrice` = '2100000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 16' ,`StreetNumber` = '12044' ,`StreetSuffix` = '' ,`City` = 'Fredericksburg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COME SEE THIS BEAUTIFUL TEXAS HILL COUNTRY 3+ ACRES WITH BEAUTIFUL SHADED TREES AND NO RESTRICTIONS (ZONED FOR COMMERCIAL & RESIDENTIAL). THE POSSIBILITES ARE ENDLESS.. ESTABLISHED WINERY IN PLACE OR WEDDING & EVENT CENTER! LOCATED ON HWY 16 BETWEEN FREDERICKSBURG & KERRVILLE. FEATURES INCLUDE: 2 SHEDS (12X20); METAL BUILDING (20X26 WITH 14 FT CEILING; ADDT\'L LRG CONCRETE BAR & GRILLING AREA W/ COMMERCIAL GRADE SINK & REF.; ALL PATIO FURNITURE REMAINS PLUS 200 CASES OF WINE & ALL EQUIPMENT FOR WINE MAKING; 4 BDRMS, 2 BATH, 2 CAR GARAGE AND SO MUCH MORE! You can see deer and other wildlife every evening and watch the most amazing sunsets right outside the back patio. Plenty of comfy patio seating, fire pits, grills, a beautiful fountain & hot tub where you can sit back & enjoy the nature with a glass of wine, grilling or just relaxing & entertaining friends.' ,`Acres` = '3.2' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace,Stove' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A0492 W MC MASTERS #108, 2.2 ACRES, -M/H HOMESITE-, HUD#' ,`LotDesciption` = 'Other' ,`LotSize` = '139392' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '285 - Fredericksburg' ,`SchoolElementary` = 'FREDERICKSBURG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FREDERICKSBURG HIGH SCHOOL' ,`SchoolMiddle` = 'FREDERICKSBURG MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '1784' ,`TaxRate` = '1.3418' ,`WaterSewer` = 'Well' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218077' WHERE `Matrix_Unique_ID` = '209051705' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:01:30.640' ,`MLSNumber` = '26977644' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.894889' ,`Longitude` = '-98.467764' ,`PhotoCount` = '6' ,`PostalCode` = '76301' ,`RoomCount` = '2' ,`ListPrice` = '28999.00' ,`Status` = 'Active' ,`StreetName` = 'Old Windthorst' ,`StreetNumber` = '1923' ,`StreetSuffix` = 'Road' ,`City` = 'Wichita Falls' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fixer upper home with a promising future on the horizon! This home is surrounded by many great parks, eateries and stores, and the peaceful neighborhood offers the perfect place for you and your family to live in. Aside from the great location this home offers you, Wichita falls also has fun destinations to choose from like Castaway Cove Waterpark and Lake Wichita Park. Give us a call and schedule your personal viewing today! As Is.' ,`Acres` = '0.176' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 2 BLK E SOUTH SIDE ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '7667' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1036 - Wichita Falls' ,`SchoolElementary` = 'LAMAR ELEMENTARY SCHOOL (WICHITA FALLS)' ,`SchoolHigh` = 'HIRSCHI HIGH SCHOOL' ,`SchoolMiddle` = 'KIRBY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Side Acre' ,`TaxAmount` = '695' ,`TaxRate` = '2.7399' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218078' WHERE `Matrix_Unique_ID` = '209055069' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:23:58.457' ,`MLSNumber` = '8962533' ,`ListAgentFullName` = 'Wendy Dozier' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = 'Wendy Dozier' ,`SellingOfficeName` = 'RE/MAX On The Water - Bolivar' ,`Latitude` = '29.503746' ,`Longitude` = '-94.521354' ,`PhotoCount` = '50' ,`PostalCode` = '77617' ,`RoomCount` = '2' ,`ListPrice` = '275000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Cedar' ,`StreetNumber` = '1094' ,`StreetSuffix` = 'Lane' ,`City` = 'Gilchrist' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MUST SEE EXTRAORDINARY OPPORTUNITY! Exterior Colors of the homes will depend on lot #. Website/video attached. Brand New Villas Priced in The Mid $200\'s + ADDITIONAL OPTIONS such as a loft area, garage, outside shower, RV connections & Quartz Kitchen Counters. 30 second Golf Cart Ride To The Beach! Incredible Beach Community With Magnificent Views of the Beach & Intracoastal. Community Amenities Featuring; Ponds, Pavilion, Observatory Deck, Splash Pad, BBQ and Lounging Areas. Tongue and Groove Wood Stained Flooring, Stainless Steel Appliances, Stained Butcher Block Counters, Quartz Bathroom Counters. SELLING FAST! Builder Base Price Is Subject To Change.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'LOR Design' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Caplen' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 64 PAGE 3 & 4 LOT 41 NORTH CAPLEN AD' ,`LotDesciption` = 'Water View' ,`LotSize` = '4430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villas at Rollover Bay' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675218078' WHERE `Matrix_Unique_ID` = '209255984' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:20:37.733' ,`MLSNumber` = '43418568' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '34.026431' ,`Longitude` = '-98.917097' ,`PhotoCount` = '6' ,`PostalCode` = '76360' ,`RoomCount` = '2' ,`ListPrice` = '26999.00' ,`Status` = 'Active' ,`StreetName` = 'Wharton' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Avenue' ,`City` = 'Electra' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '818' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 bedroom 1 bathroom is the perfect opportunity for an investor who wants to breathe new life into this home! With a little bit of hard work, this home can transform into the home of your dreams! Lots of yard space for kids, a few minutes away from Electra High School, and a 30 minute drive to Wichita falls. AS IS.' ,`Acres` = '0.14' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'W 50\' OF LOT 5 BLK 99 ORIGINAL TOWN, E' ,`LotDesciption` = 'Other' ,`LotSize` = '6098' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '498 - Electra' ,`SchoolElementary` = 'ELECTRA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELECTRA JUNIOR/HIGH SCHOOL' ,`SchoolMiddle` = 'ELECTRA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Original Town E' ,`TaxAmount` = '125' ,`TaxRate` = '3.0719' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1935' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218078' WHERE `Matrix_Unique_ID` = '209299542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:29:27.200' ,`MLSNumber` = '56238456' ,`ListAgentFullName` = 'Delia Rodriguez' ,`ListOfficeName` = 'Redding & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.950493' ,`Longitude` = '-95.959349' ,`PhotoCount` = '43' ,`PostalCode` = '77414' ,`RoomCount` = '6' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Magnolia' ,`StreetNumber` = '5004' ,`StreetSuffix` = 'Lane' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4503' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the most Magnificent Unique Homes located in the city limits. Situated in Country Estates, there\'s not much this GORGEOUS, 5BDRM 3.5BATH CUSTOM home doesn\'t have to offer. If you are entertaining guests out back or upstairs in the huge GameRoom/Theater Room, there\'s plenty of room for everyone. Each Bedroom is oversized with built in custom features. The Main Living Area, opens to the pool & backyard, which has built in shelves following the fireplace wall, floor to ceiling. They create a perfect spot for any avid hunter to display mounts. A Victorian touch was added to the Formal Dining room, w/Glass Chandelier, Wall Sconces, French Glass Doors and Wainscot. Additional Study or Living Area opens to the Front Foyer, which features a beautiful hardwood staircase leading to the Interior Hallway Balcony, which overlooks the Main Living Area, Backyard and Entry. Take a walk around the home by clicking on the Matterport Link & see for yourself what makes this home so special.' ,`Acres` = '0.714' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTRY ESTATES SEC 1 LOT 9 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Waterfront' ,`LotSize` = '31102' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Country Estates Sec 1' ,`TaxAmount` = '10436' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218078' WHERE `Matrix_Unique_ID` = '209358395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:52:10.927' ,`MLSNumber` = '81471347' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '33.440814' ,`Longitude` = '-94.069564' ,`PhotoCount` = '8' ,`PostalCode` = '75501' ,`RoomCount` = '2' ,`ListPrice` = '34999.00' ,`Status` = 'Active' ,`StreetName` = 'Blanton' ,`StreetNumber` = '507' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texarkana' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1058' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2 bedroom, 1 bathroom fixer upper home is located in a quiet neighborhood with quick access to 369 HWY. This home also features a new roof! Contact us today for more information! As Is.' ,`Acres` = '0.15' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'BEVERLY HEIGHTS (TXKA) LOT 4 2017-6072 05/26/17 BLK/TRACT 29' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '970 - Texarkana' ,`SchoolElementary` = 'WESTLAWN ELEMENTARY SCHOOL (TEXARKANA)' ,`SchoolHigh` = 'TEXAS HIGH SCHOOL' ,`SchoolMiddle` = 'TEXAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beverly Heights' ,`TaxAmount` = '459' ,`TaxRate` = '2.5041' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '0' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218079' WHERE `Matrix_Unique_ID` = '209729545' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:21:23.627' ,`MLSNumber` = '11055639' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505589' ,`Longitude` = '-95.000887' ,`PhotoCount` = '44' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2813' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1860' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stratford floor plan comes with a covered patio and covered front porch. It includes the optional fourth bedroom and third bathroom. Stratford has a spacious kitchen, which includes a pantry and oversized island with breakfast bar; a spacious owner’s retreat, which includes a large walk-in closet and spa-like ensuite.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218079' WHERE `Matrix_Unique_ID` = '209740706' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:35:35.617' ,`MLSNumber` = '82451591' ,`ListAgentFullName` = 'Dianna Richards' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444062' ,`Longitude` = '-95.266512' ,`PhotoCount` = '43' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '625000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 149' ,`StreetNumber` = '1513' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*** PRICED REDUCED !! OWNER READY TO SELL !!!***OWNER JUST REPLACED THE COUNTERS IN THE KITCHEN WITH GRANITE 1/23/23. THIS HOME HAS SO MUCH TO OFFER-COUNRTY LIVING WITH NO DEED RESTRICTIONS-LARGE MAINTAINED HOME-HOME HAS BEEN USED AS A RENTAL SHOWING INCOME PRODUCING PROPERTY-BEAUTIFUL POOL AND SPA. 1.78 ACRES TO ENJOY OUTDOOR LIVING. CALL FOR YOUR PRIVATE SHOWING' ,`Acres` = '1.78' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'EMERALD MANOR (A0412 A C H & B) BLK 1 LOT 1A-2-3A ACRES 1.78' ,`LotDesciption` = 'Cleared' ,`LotSize` = '77537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Emerald Manor' ,`TaxAmount` = '9948' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218079' WHERE `Matrix_Unique_ID` = '210242256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:49:52.937' ,`MLSNumber` = '90622367' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.034471' ,`Longitude` = '-95.412152' ,`PhotoCount` = '15' ,`PostalCode` = '77531' ,`RoomCount` = '7' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Marsh Hawk' ,`StreetNumber` = '504' ,`StreetSuffix` = 'Court' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The unique Leo plan features three bedrooms, two full bathrooms & an open kitchen/breakfast area!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19, Block 5, Section 5' ,`LotDesciption` = 'Water View' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '' ,`TaxRate` = '2.81' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218079' WHERE `Matrix_Unique_ID` = '210276822' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:24:45.440' ,`MLSNumber` = '17682228' ,`ListAgentFullName` = 'Linda Ihns' ,`ListOfficeName` = 'F C Realty ADV.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.043212' ,`Longitude` = '-95.605677' ,`PhotoCount` = '38' ,`PostalCode` = '77375' ,`RoomCount` = '10' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Hayden Wood' ,`StreetNumber` = '19115' ,`StreetSuffix` = 'Drive' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2332' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Worried about the Power Grid going out and having NO Electricity? Not this Home GENERAC GENERATOR Included!\r\nEven the Garage has it\'s own HVAC System. 40X12 Covered Back Porch, Kitchen countertops & Stainless Sink Stainless Appliances, Carpet on the Stairs and 3 Br\'s replaced Plus the interior has been Freshly painted a Neutral color. In 10-22 Carpet in Front Room rep[laced 2019, Roof 2013, Fence 2013, Water Heater 2022, Faux Wood Blinds 2017, ALARM SYSTEM w/Cameras 2017, Garage AC Added 2019, Laminate Floors 2017, Front Door 2017, Garage Door and many more Items!!! Call a REALTOR TODAY!!!' ,`Acres` = '0.1355' ,`Area` = '14' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 2 PINECREST FOREST SEC 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5903' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KOHRVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pinecrest Forest Sec 06' ,`TaxAmount` = '5788' ,`TaxRate` = '2.7066' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218080' WHERE `Matrix_Unique_ID` = '210367456' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:29:44.403' ,`MLSNumber` = '64412854' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.891862' ,`Longitude` = '-94.045346' ,`PhotoCount` = '37' ,`PostalCode` = '75951' ,`RoomCount` = '7' ,`ListPrice` = '198500.00' ,`Status` = 'Active' ,`StreetName` = 'Woodlake' ,`StreetNumber` = '292' ,`StreetSuffix` = 'Drive' ,`City` = 'Jasper' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1617' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Front Brick beauty in the Holmwood Community of Jasper, TX! This single story brick charmer features 3 Bedrooms, 2 Baths an attached garage & a covereved patio/deck overlooking a quaint lake! Home features a master bedroom with en-suite bath for privacy and a wet bar that opens onto the living and kitchen spaces.' ,`Acres` = '0.7' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 6 BLK 1 SEC 2 HOLMWOOD 1223/791 0.7 ACRES' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '30492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = 'JASPER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Holmwood Sub Sec 2' ,`TaxAmount` = '2452' ,`TaxRate` = '1.8166' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218080' WHERE `Matrix_Unique_ID` = '210572648' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:38:32.793' ,`MLSNumber` = '37574649' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.319527' ,`Longitude` = '-98.473658' ,`PhotoCount` = '7' ,`PostalCode` = '78214' ,`RoomCount` = '2' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Saenz' ,`StreetNumber` = '1443' ,`StreetSuffix` = '' ,`City` = 'San Antonio' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '846' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 bedrooms, 1 bathroom home with foundation repairs and a new 30-year roof. This property is in need of some work, but it\'s worth the purchase! Quick access to 410 FWY. Great location! Stores and restaurants are easily found in the area. Give us a call today! As Is' ,`Acres` = '0.1435' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'NCB 11048 BLK 3 LOT 53' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '938 - Southside' ,`SchoolElementary` = 'GALLARDO ELEMENTARY' ,`SchoolHigh` = 'SOUTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'LOSOYA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Villa Coronado Bl 11048' ,`TaxAmount` = '1244' ,`TaxRate` = '2.6914' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218080' WHERE `Matrix_Unique_ID` = '210628128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:38:03.263' ,`MLSNumber` = '80255497' ,`ListAgentFullName` = 'Autumn Morrell' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.067944' ,`Longitude` = '-94.039533' ,`PhotoCount` = '19' ,`PostalCode` = '75931' ,`RoomCount` = '6' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Longleaf' ,`StreetNumber` = '760' ,`StreetSuffix` = 'Drive' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully furnished home in the sought after Forest Hills Subdivision at Lake Sam Rayburn. 3 Bed/2 Bath featuring an open concept living area, great for entertaining! Tons of natural light throughout. Within walking distance to the community swimming pool and tennis courts. Minutes of local restaurants, shopping, and public boat ramps including Twin Dikes & Umphrey.' ,`Acres` = '0.72' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 215 FOREST HILLS 989 /780 .72 ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '31363' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = 'JASPER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Hills Sub Sec II' ,`TaxAmount` = '3781' ,`TaxRate` = '1.846' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218080' WHERE `Matrix_Unique_ID` = '210659943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:31:28.720' ,`MLSNumber` = '24629651' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.920600' ,`Longitude` = '-94.004863' ,`PhotoCount` = '34' ,`PostalCode` = '75951' ,`RoomCount` = '6' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '437' ,`StreetSuffix` = 'Street' ,`City` = 'Jasper' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable cottage home in the heart of Historic Jasper! This ideally located home leaves you within a few miles of all major shopping, medical centers, schools and city events! Currently housing a retail and salon business, this adorable home 2 Bed / 1.5 Bath features multiple updates, large entertainment spaces and a quaint covered patio overlooking the fenced backyard! Space abounds with over 1900 sqft consisting of both a large living and separate dining space that opens onto the kitchen and finally leads to the covered patio. In keeping with the historic charm, the home features high ceilings throughout! A detached carport with large storage/office space is also located just off of the home and back covered patio! Call for more information today!' ,`Acres` = '0.28' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 2 JNO BEVIL 1179/313 0.28 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = 'JASPER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1754' ,`TaxRate` = '2.1745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218080' WHERE `Matrix_Unique_ID` = '211095128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:02:16.530' ,`MLSNumber` = '95874518' ,`ListAgentFullName` = 'Cynthia Pierce' ,`ListOfficeName` = 'Gann Medford Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.313810' ,`Longitude` = '-94.758218' ,`PhotoCount` = '50' ,`PostalCode` = '75904' ,`RoomCount` = '8' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Copeland' ,`StreetNumber` = '1708' ,`StreetSuffix` = 'Street' ,`City` = 'Lufkin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hidden jewel in Brookhollow on 2.98 acres! This charming estate has a library & media room. The family room enjoys a view of the beautifully landscaped yard, outdoor living area, FP. Spacious kitchen with Super White Quartz countertops. So much storage. Follow the path outside to the gunite pool & outdoor kitchen. Beyond this is Granddad\'s Cottage (1084 sq ft). The cottage offers 1 bed 1 bath downstairs with a living room, FP, kitchen, laundry closet, upstairs loft. You will enjoy relaxing on your front porch or back patio! There is so much to love in this 5800+ sq ft combined living space.' ,`Acres` = '2.9839' ,`Area` = '45' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Angelina County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = '6910 WOODED ESTATES BLK 1 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '129980' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '186 - Lufkin' ,`SchoolElementary` = 'BROOKHOLLOW ELEMENTARY' ,`SchoolHigh` = 'LUFKIN HIGH SCHOOL' ,`SchoolMiddle` = 'LUFKIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wooded Estates' ,`TaxAmount` = '11272' ,`TaxRate` = '2.3856' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218081' WHERE `Matrix_Unique_ID` = '211269957' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:13:12.290' ,`MLSNumber` = '13013151' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.398260' ,`Longitude` = '-95.688962' ,`PhotoCount` = '15' ,`PostalCode` = '77356' ,`RoomCount` = '10' ,`ListPrice` = '382758.00' ,`Status` = 'Active' ,`StreetName` = 'Little Dog' ,`StreetNumber` = '234' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning one-story Blakemore II home features 3 bedrooms, 2 baths and 2 car attached garage on a corner lot. Beautiful maple cabinets, under cabinet lighting, quartz countertops and farmhouse sink in kitchen. Convenient home office located off gallery. Huge owner\'s walk-in closet, double sinks, separate tub and shower in owner\'s luxury bath. Covered patio in backyard, perfect for entertaining.\r\nStudents are zoned to MISD. Take a tour and see why you\'ll love calling this community home. Town Creek Crossing is offered by K. Hovnanian of Houston II, L.L.C.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/2/1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8443' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Town Creek Crossing' ,`TaxAmount` = '' ,`TaxRate` = '2.8481' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218081' WHERE `Matrix_Unique_ID` = '211487016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:00:56.440' ,`MLSNumber` = '77816606' ,`ListAgentFullName` = 'Dan Cook' ,`ListOfficeName` = 'SWE Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.248931' ,`Longitude` = '-101.488482' ,`PhotoCount` = '8' ,`PostalCode` = '79720' ,`RoomCount` = '1' ,`ListPrice` = '26999.00' ,`Status` = 'Active' ,`StreetName` = 'Galveston' ,`StreetNumber` = '203' ,`StreetSuffix` = 'Street' ,`City` = 'Big Spring' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A fixer upper with a lot of potential, at a price you will love! This home has easy access to I-20 with plenty of shopping and eateries nearby! If you want to experience nature in all its splendor, the property is minutes away from Big Spring State Park, and Comanche Trail Park. Take advantage of this opportunity, create your dream home! Give us a call today for more information! AS IS.' ,`Acres` = '0.078' ,`Area` = '86' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ACRES: 0.078 N/34 S/90 OF LTS 1-2 BK 6 JONES VALLEY 34X100 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '3398' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '341 - Big Spring' ,`SchoolElementary` = 'GOLIAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BIG SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'BIG SPRING JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '134' ,`TaxRate` = '2.2535' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675218081' WHERE `Matrix_Unique_ID` = '211586372' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:53:05.040' ,`MLSNumber` = '20870668' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = 'Rhoda Reese' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.832216' ,`Longitude` = '-94.839897' ,`PhotoCount` = '23' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '599990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gretzky' ,`StreetNumber` = '13927' ,`StreetSuffix` = 'Drive' ,`City` = 'Mont Belvieu' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous brick and stone executive home built for entertaining with a large covered patio and 2nd-floor balcony. Enter through the 8 ft. mahogany leaded glass front door into an expansive 2-story entry with a sweeping circular staircase with stained treads & painted risers. The kitchen was designed for a chef in mind with 54\" high shaker style cabinetry, a wood cabinet range hood above a 36\"-5 burner gas cooktop, a large walk-in pantry, a butler\'s pantry & GE stainless steel built-in appliances. The fireplace in the family room is surrounded by floor-to-ceiling stone. The oversized master bedroom has an equally large master bath with his & her closets, a deep soaking tub, a walk-in shower with a seat, & separate vanities. There are 4 larger than average secondary bedrooms, 2 full bathrooms, a large game room with an 8\' x 32\' walk-out balcony & media room. Window blinds, garage door opener, security system, fully sodded front, sides and rear yard w/a full sprinkler system are included!' ,`Acres` = '0.2238' ,`Area` = '53' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38, Block 2, Section 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9750' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Reserve of Champions Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.1606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675218081' WHERE `Matrix_Unique_ID` = '211780096' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T15:33:18.167' ,`MLSNumber` = '3374078' ,`ListAgentFullName` = 'Twila Bertrand' ,`ListOfficeName` = 'Century 21 Cota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.994833' ,`Longitude` = '-94.146598' ,`PhotoCount` = '21' ,`PostalCode` = '75951' ,`RoomCount` = '4' ,`ListPrice` = '79900.00' ,`Status` = 'Active' ,`StreetName` = 'St Hwy 63 W' ,`StreetNumber` = '10101' ,`StreetSuffix` = '' ,`City` = 'Jasper' ,`BathsFull` = '0' ,`BathsHalf` = '1' ,`BedsTotal` = '1' ,`SqFtTotal` = '1640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investors and Business Owners take notice -- This Commercial or Residential Brick building has tons of highway road frontage on State Hwy 63 W and includes almost a half acre of land. This property was previously used for a commercial resale shop and has a kitchen and a half bath so it could be converted into a residential property. It has tons of potential and features a huge open area that would be perfect for a commercial warehouse/shop and has stained concrete floors for long lasting durability and includes a large gravel/asphalt parking area and a large grassy back yard.' ,`Acres` = '0.495' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'AB 19 T B HULING TR 93 986/553-993/218 0.495 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = 'JASPER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'None' ,`TaxAmount` = '589' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675218082' WHERE `Matrix_Unique_ID` = '211987946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-23T16:14:08.917' ,`MLSNumber` = '89232911' ,`ListAgentFullName` = 'Ashley Ruby' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Angel Martinez Bueno' ,`SellingOfficeName` = 'Keller Williams Metropolitan' ,`Latitude` = '30.042506' ,`Longitude` = '-95.329203' ,`PhotoCount` = '32' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Brookgate' ,`StreetNumber` = '6627' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully remodeled 3 Bed 2 Bath home in a quiet neighborhood in Spring, Tx! Many upgrades for peace of mind including a BRAND NEW ROOF, New flooring throughout, New granite countertops in the Kitchen and Bathrooms! NEW