Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:53:41.477' ,`MLSNumber` = '94673170' ,`ListAgentFullName` = 'Kimberly Walt' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.775345' ,`Longitude` = '-94.414879' ,`PhotoCount` = '23' ,`PostalCode` = '75979' ,`RoomCount` = '6' ,`ListPrice` = '114950.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 92' ,`StreetNumber` = '3135' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a property that you can use to get away or rent out for additional income stream? This may be the perfect opportunity. The possibilities are endless, the proximity to Lake Steinhagen is  5 minutes away and if you are feeling more adventurous The Neches River is just down the road, or you can relax and fish from the shore just a few feet from the home. With the 3 car garage you have plenty of room to store your boat and other items and cut out storage fees. You can also use it as an AirBNB and still have time booked out for you to enjoy. Within 2 hours from Houston & Beaumont makes going so much easier. Call a Realtor to schedule a showing, go on a pretty day so you can get a great view of the lake. Possible option to purchase home next door increase lot size and rent-ability, speak with your Realtor for details.If not interested the seller of primary estate will finish the privacy fence, and install a gate entry to street, to completely separate the two properties.' ,`Acres` = '' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S5510 WEST TOWN BLUFF (A29), BLK 4, LOT 28,29,30,31,&32, RES' ,`LotDesciption` = 'Other' ,`LotSize` = '32250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '99 - Other' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Town Bluff' ,`TaxAmount` = '1621' ,`TaxRate` = '2.1587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097907' WHERE `Matrix_Unique_ID` = '202572456'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:31:53.627' ,`MLSNumber` = '94781707' ,`ListAgentFullName` = 'Todd Anderson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679954' ,`Longitude` = '-95.533977' ,`PhotoCount` = '8' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley View' ,`StreetNumber` = '8835' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2087' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a nice rented out through June 3 bedroom 2 bathroom home. Kitchen has granite countertops appliances. Large living space and master bedroom. Double sink in guest bathroom. Utility room has connections for washer and dryer in the home. Huge fully fenced back yard. Great for a family or keep as a rental.' ,`Acres` = '0.2508' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 14 BLK 6 BRAEBURN GLEN SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10927' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BONHAM ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeburn Glen Sec 01' ,`TaxAmount` = '5714' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097907' WHERE `Matrix_Unique_ID` = '206768058'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T09:27:56.447' ,`MLSNumber` = '53270760' ,`ListAgentFullName` = 'Delores Ramirez' ,`ListOfficeName` = 'Reyes Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.313346' ,`Longitude` = '-95.246982' ,`PhotoCount` = '45' ,`PostalCode` = '77511' ,`RoomCount` = '10' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2917' ,`StreetNumber` = '3121' ,`StreetSuffix` = 'Road' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2445' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Tilson home on 15.8 acres along with a 36x24 workshop is the answer to all your needs.  This beautiful custom home HAS NEVER FLOODED and is not located in the flood zone.  NO HOA\'s and NO RESTRICTIONS !!!\r\nIt also comes with an AG EXEMPTION !!!  If all this is not enough, the house is owned by it\'s original owner\'s who definitely show pride of ownership.  This well maintained home has a beautiful fireplace, tile flooring, open floor concept, large island in the kitchen with it\'s granite countertops and surreal view of the backyard .  Lots of natural lighting throughout.  French doors welcome you into the office/library for those working at home.  This property is a MUST SEE ... with all the positive benefits ... IT WILL NOT LAST LONG !!!' ,`Acres` = '15.83' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0037 S F AUSTIN TRACT 60C-84L ACRES 15.83' ,`LotDesciption` = 'Cleared' ,`LotSize` = '689555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '5814' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097907' WHERE `Matrix_Unique_ID` = '210372478'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:19:51.710' ,`MLSNumber` = '30206425' ,`ListAgentFullName` = 'Emilio Zaporteza' ,`ListOfficeName` = 'Vez Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.430210' ,`Longitude` = '-95.439762' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '11' ,`ListPrice` = '369999.00' ,`Status` = 'Active' ,`StreetName` = 'Sentinel Dome' ,`StreetNumber` = '10610' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained home with 4 bedrooms, 3 and a half bathroom,  High ceiling in family room and foyer, large gameroom, extra room can be a media room or a guest quarter. Built by Meritage homes with spray foam insulation of better energy efficiency. Enjoy the backyard with no back neighbor.' ,`Acres` = '0.1469' ,`Area` = '5' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4A (A0288 HT&BRR) BLK 1 LOT 39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '10816' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097907' WHERE `Matrix_Unique_ID` = '210935463'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:24:06.043' ,`MLSNumber` = '76644843' ,`ListAgentFullName` = 'Emilio Zaporteza' ,`ListOfficeName` = 'Vez Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.526354' ,`Longitude` = '-95.481100' ,`PhotoCount` = '24' ,`PostalCode` = '77545' ,`RoomCount` = '10' ,`ListPrice` = '329000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Haven' ,`StreetNumber` = '1815' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2351' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained owner occopied property. Located on a very large cul-de-sac lot. with large gazebo to entertain guest and family. The island kitchen is well lighted due to skylight. High ceiling in most area.  Many updates were done in this property. You have to see it.  Recent interior paint,  Wall accent tile in the bathroom. Backyard is too large to accomodate pool and have extra yard to have a garden to grow vegetable and fruit trees.' ,`Acres` = '0.3029' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEAL RUN SEC 4, BLOCK 2, LOT 4' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'HIGHTOWER HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE OLYMPIA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Teal Run Sec 4' ,`TaxAmount` = '5518' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097908' WHERE `Matrix_Unique_ID` = '211380086'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:47:55.447' ,`MLSNumber` = '46943486' ,`ListAgentFullName` = 'Brianne Clark' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.383811' ,`Longitude` = '-94.948240' ,`PhotoCount` = '19' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '3434' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special! Fully Renovated adorable home. This plan features an open floor plan with three bedrooms and one full bath. Very large partially fenced yard, and easy access to hwy 146. Only a 20 minute drive to the heart of Galveston. Currently has great tenants.' ,`Acres` = '0.1481' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 63 PAGE 5 LOT 16 BLK 148 KOHFELDT 2ND ADDN' ,`LotDesciption` = 'Other' ,`LotSize` = '6450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Kohfeldt 2nd' ,`TaxAmount` = '3117' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097908' WHERE `Matrix_Unique_ID` = '212225258'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T10:48:16.507' ,`MLSNumber` = '77470664' ,`ListAgentFullName` = 'Wojciech Kic' ,`ListOfficeName` = 'HOUSEforPURCHASE.com, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.720269' ,`Longitude` = '-95.367278' ,`PhotoCount` = '32' ,`PostalCode` = '77004' ,`RoomCount` = '7' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor' ,`StreetNumber` = '3123' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2150' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Let nature and nurture combine in this University area townhome.   Enjoy sweeping views of the nature trail from this breathtaking property. Everything to please inside and out, this property offers, three bedrooms, three and one half bathrooms, spacious living and dining areas, hardwood and tile floors, balcony, two-car garage, cul-de-sac, next to nature trail; Appointments required prior to 12/30. Enjoy all that nature has to offer without sacrificing the benefits of inner-city living.' ,`Acres` = '0.0351' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ARBOR VILLAS' ,`LotDesciption` = 'Other' ,`LotSize` = '1529' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Arbor Villas' ,`TaxAmount` = '9783' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097908' WHERE `Matrix_Unique_ID` = '213282642'  --> Updated record success<br />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','215908195','1675097908','215908195','2022-12-31T09:49:10.620','36853583','Jennifer Thomas','Point of View Realty','','','29.260864','-94.846609','35','77551','7','272000.00','Active','Beluche','8007','Drive','Galveston','2','0','3','1840','Single-Family','','0.124','33','','','','','Sellers Disclosure','','','','Near West End','Central Electric','0','ABST 121 HALL & JONES SUR PT OF LOT 181 (181-3) TRIMBLE & LI','Subdivision Lot','5400','Appraisal District','','','0','','3','','0','','','','','Composition,Other','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Appointment Required,Supra Keybox','Appraisal District','1.5','Traditional','Trimble & Lindsey Sec 1','3648','2.0161','Public Sewer,Public Water','1977','Appraisal District');  --> New record created successfully<br />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','215936440','1675097908','215936440','2022-12-31T09:20:17.120','30536712','Etha Eglin','Keller Williams Metropolitan','','','30.137220','-94.181498','27','77708','7','299990.00','Active','Highpoint','6390','Avenue','Beaumont','2','0','3','1796','Single-Family','Beautifully crafted new construction home by D.R. Horton, America\'s Builder. Located in Highpoint a quaint gated community in Beaumont. The Cali plan is a one-story home featuring 3 bedrooms with a flex space for a 4th bedroom or study, 2 baths, 2 car garage and the Builders former model. The long foyer with an entry coat closet leads to the open concept kitchen and breakfast area. The kitchen includes a breakfast bar with beautiful counter tops, stainless steel appliances, corner pantry and opens to the family room. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and spacious walk-in closet. The standard rear covered patio is located off the breakfast area Standard features include fenced backyard and front yard sprinkler system.','0.1676','51','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','1','HIGHPOINT PHASE 1 LOT 8 BLK 1','Subdivision Lot','7300','Appraisal District','','600','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','143 - Beaumont','GUESS ELEMENTARY SCHOOL','WEST BROOK HIGH SCHOOL','VINCENT MIDDLE SCHOOL','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Highpoint Ph 1','393','2.645','Public Sewer,Public Water','2022','Builder');  --> New record created successfully<br />