Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:08:22.103' ,`MLSNumber` = '33310619' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085724' ,`Longitude` = '-95.951473' ,`PhotoCount` = '6' ,`PostalCode` = '77484' ,`RoomCount` = '12' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Upland' ,`StreetNumber` = '212' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Settle into this lovely Briarwood Home in the desirable Beacon Hill. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, tile flooring, 3-car garage, faux wood blinds, limestone fireplace, full gutters, and a covered patio. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. With dual vanities, framed mirrors, and a shower, the primary suite is a wonderful place to unwind. Community comforts include 30-acres of green recreational spaces, paved trails, and a recreation center. Situated off U.S. 290, the Northwest Freeway, between FM 362 and James Muse Parkway, residents love the easy access to a variety of restaurants, shops, and outdoor recreation areas. Nearby schools are zoned to Waller ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694015' WHERE `Matrix_Unique_ID` = '204953291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:07:35.240' ,`MLSNumber` = '74115775' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085724' ,`Longitude` = '-95.951473' ,`PhotoCount` = '6' ,`PostalCode` = '77484' ,`RoomCount` = '11' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Upland' ,`StreetNumber` = '216' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Thi home is under construction. Settle into this beautiful Briarwood Homes in the incredible Beacon Hill community. This 4-sided brick home boasts a premium elevation, tile flooring, 3-car garage, entry crown molding, wrought iron spindles, direct vent fireplace, faux wood blinds, full gutters, and a covered patio. Create new dishes in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, pendant lighting, and undercabinet lighting. Unwind in the serene primary suite, featuring dual vanities, a drop-in tub, and a separate shower. Community comforts include 30-acres of green recreational spaces, paved trails, and a recreation center. Situated off U.S. 290, the Northwest Freeway, between FM 362 and James Muse Parkway, residents love the easy access to a variety of restaurants, shops, and outdoor recreation areas. Nearby schools are zoned to Waller ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beacon Hill' ,`TaxAmount` = '' ,`TaxRate` = '3.3' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694015' WHERE `Matrix_Unique_ID` = '205441052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T13:17:52.487' ,`MLSNumber` = '62826463' ,`ListAgentFullName` = 'Angela Hernandez' ,`ListOfficeName` = 'CB&A, Realtors- Southeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '25.925612' ,`Longitude` = '-97.488921' ,`PhotoCount` = '19' ,`PostalCode` = '78521' ,`RoomCount` = '4' ,`ListPrice` = '174900.00' ,`Status` = 'Active' ,`StreetName` = 'Paredes Line' ,`StreetNumber` = '258' ,`StreetSuffix` = 'Road' ,`City` = 'Brownsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous property surrounded by commercial properties on a busy street. Right down the street from the HEB! 4 bedrooms, plenty of space, a large back yard, 7 ft. fence in the backyard, recently updated water heater, HVAC unit, electrical & electrical box! 10X20 storage shed in backyard! Currently being leased on a month-to-month lease. Do not disturb tenants.' ,`Acres` = '0.1607' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOS EBANOS ESTATES SUBDIVISION LOT 21 BLK 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '374 - Brownsville' ,`SchoolElementary` = 'PEREZ ELEMENTARY SCHOOL (BROWNSVILLE)' ,`SchoolHigh` = 'HANNA HIGH SCHOOL' ,`SchoolMiddle` = 'OLIVEIRA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Los Ebanos Estates Sub' ,`TaxAmount` = '1065' ,`TaxRate` = '2.5428' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694015' WHERE `Matrix_Unique_ID` = '206660644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T13:32:42.753' ,`MLSNumber` = '18216914' ,`ListAgentFullName` = 'Debra Kraemer' ,`ListOfficeName` = 'Crystal Beach Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472893' ,`Longitude` = '-94.594744' ,`PhotoCount` = '28' ,`PostalCode` = '77650' ,`RoomCount` = '4' ,`ListPrice` = '354900.00' ,`Status` = 'Active' ,`StreetName` = 'Stingaree' ,`StreetNumber` = '1008' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ADORABLE WATERVIEW 2/2 WITH AN EXTERIOR PAINT JOB COMPLETED THIS MONTH IN THE HEART OF CRYSTAL BEACH! THIS PROPERTY IS CENTRALLY LOCATED CLOSE TO RESTAURANTS, BARS & THE BIG STORE. THE HOME IS BEING SOLD FULLY FURNISHED. THE HOME IS CURRENTLY IN A RENTAL POOL AND THE RENTALS CAN BE ASSUMED IF YOU ARE PURCHASING THIS AS AN INVESTMENT PROPERTY. MAKE AN APPOINTMENT TO SEE IT TODAY! THIS ONE WON\'T LAST LONG!!\r\nTHE VACANT LOT NEXT TO THIS PROPERTY CAN BE PURCHASED FOR AN ADDITIONAL AMOUNT IF DESIRED.' ,`Acres` = '0.0918' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 5 & 6 BLK 4 MARYLAND SUB' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Maryland' ,`TaxAmount` = '3534' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694015' WHERE `Matrix_Unique_ID` = '206834210' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:55:26.983' ,`MLSNumber` = '93768628' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583381' ,`Longitude` = '-95.746453' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '382030.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine Hollow' ,`StreetNumber` = '1223' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready November 2022! Live.Now Collection: Balanced. A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Make long commutes a thing of the past thanks to major road improvements on US-90 and FM 359. The kids will love attending school in the sought-after Lamar Consolidated ISD and the area offers an affordably low tax rate. Downtown Richmond is home to many new boutiques, restaurants, and longstanding businesses. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0215 Plan L401F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.41' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694015' WHERE `Matrix_Unique_ID` = '207380209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:36:17.340' ,`MLSNumber` = '91020072' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960705' ,`Longitude` = '-95.438528' ,`PhotoCount` = '11' ,`PostalCode` = '77067' ,`RoomCount` = '5' ,`ListPrice` = '224900.00' ,`Status` = 'Active' ,`StreetName` = 'Gregory Crossing' ,`StreetNumber` = '12010' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.0918' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 SPEARS CROSSING' ,`LotDesciption` = 'Other' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spears Xing' ,`TaxAmount` = '4570' ,`TaxRate` = '3.0367' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '207838350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:12:54.880' ,`MLSNumber` = '26260488' ,`ListAgentFullName` = 'Estella Dawson' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320533' ,`Longitude` = '-95.458936' ,`PhotoCount` = '28' ,`PostalCode` = '77301' ,`RoomCount` = '5' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'San Jacinto' ,`StreetNumber` = '1202' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4333' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stately Home in the Heart of Conroe! Lots of charm in this 5 bdrm 4 bath home. Currently in the make ready phase. Beautiful foyer entry w/French doors leading to the den w/custom built ins and another set leading to the frml dining room. There is a flex room behind the dining room that can be used as an office or tv room. There are 2 bdrms down, large kitchen and breakfast room and frml dining room. Private covered patio off the primary bedroom suite that includes full bath w/clawfoot soaking tub. Upstairs are 3 bdrms, one with a balcony and 2 more full baths. Off of the brkfast room is a large mud room area and hall leading to the laundry area. Lots of options here with the garage aptment and guest house in the back. The guest house has a bath and is plumbed for a kitchenette. The apartment is a 1 bdrm w/study. This property could be a great bed and breakfast, airbnb or your full time home. All this on a large 16,000 sq. ft. lot. Hurry, call your agent today!!' ,`Acres` = '0.3788' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'FAIRWOOD, BLOCK 2, LOT 22, 23' ,`LotDesciption` = 'Corner' ,`LotSize` = '16500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwood' ,`TaxAmount` = '5856' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '208581227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:38:07.597' ,`MLSNumber` = '24052414' ,`ListAgentFullName` = 'Kyle Pryor' ,`ListOfficeName` = 'Pryor Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.405015' ,`Longitude` = '-95.632236' ,`PhotoCount` = '17' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '349000.00' ,`Status` = 'Active' ,`StreetName` = 'Windswept' ,`StreetNumber` = '4234' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1804' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in the beautiful community of Walden on Lake Conroe. Ready for end of August move in. 3 bedroom, 2 bath, 2 car garage with dining room open to family room. Kitchen with center island and breakfast room. Granite countertops, stainless appliances include dishwasher, electric stove/oven, and microwave. Plank wood tile throughout main living area, kitchen/breakfast, baths and utility room. Primary bathroom is en suite and includes jetted tub, separate shower and dual vanity. Anticipated completion date is July 30, 2022.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Camillo Properties' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 42, Block 70, Section 17' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden on Lake Conroe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '208702376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T13:01:16.217' ,`MLSNumber` = '41057279' ,`ListAgentFullName` = 'Monica Rojas' ,`ListOfficeName` = 'RE/MAX 1st Choice' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.380770' ,`Longitude` = '-95.148155' ,`PhotoCount` = '32' ,`PostalCode` = '77517' ,`RoomCount` = '10' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '5025' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Everything! Completely redone home sitting on 4.33 acres, fully fenced with a driveway gate for home security. New windows, vinyl plank flooring, fresh interior and exterior paint. Carpeted bedrooms. Very modern and open kitchen. All new appliances. Multi use rooms--Home office/Dining Room. Three bedrooms. Oversized secondary bedrooms with Jack and Jill bath between them and opens to hallway. Supersized laundry room. Lots of patio in\r\nfront and back of the house. Carport in the back. Located in the county! No deed restrictions. Bring your horses and enjoy country living!' ,`Acres` = '4.3' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 34 C BIGALOW SUR TR 57, 4.33 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '187308' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Angel-Runge Addn Pt A-1160.2a' ,`TaxAmount` = '4982' ,`TaxRate` = '2.0881' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '208737407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T13:11:52.223' ,`MLSNumber` = '78754655' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518921' ,`Longitude` = '-95.478415' ,`PhotoCount` = '19' ,`PostalCode` = '77545' ,`RoomCount` = '12' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Bend' ,`StreetNumber` = '1718' ,`StreetSuffix` = 'Court' ,`City` = 'Fresno' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1688' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TEAL RUN COURT SEC 1, BLOCK 1, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`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' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Teal Run Court Sec 1' ,`TaxAmount` = '5921' ,`TaxRate` = '2.4829' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '208894773' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:53:50.623' ,`MLSNumber` = '35556540' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.584473' ,`Longitude` = '-95.744379' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '381745.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine Hollow' ,`StreetNumber` = '1114' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Make long commutes a thing of the past thanks to major road improvements on US-90 and FM 359. The kids will love attending school in the sought-after Lamar Consolidated ISD and the area offers an affordably low tax rate. Downtown Richmond is home to many new boutiques, restaurants, and longstanding businesses. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0256 Plan L401F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.41' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '209241427' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:18:07.270' ,`MLSNumber` = '10426613' ,`ListAgentFullName` = 'Mohamad Hafez' ,`ListOfficeName` = 'CNA Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.999136' ,`Longitude` = '-95.723329' ,`PhotoCount` = '45' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Geneva Fields' ,`StreetNumber` = '19902' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3986' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 2 STORY HOME ON A CORNER LAKE VIEW LOT*SHOWS LIKE A MODEL! GRANITE COUNTERS IN KITCHEN/BATHROOMS*42in CABINETS*CROWN MOLDING*2in BLINDS *OVERSIZED TANDEM GARAGE*DOUBLE OVENS*BRICK ON ALL FOUR SIDES AND BEAUTIFUL STONE * Fans IN ALL ROOMS*COMMUNITY POOL/PARK WALKING DISTANCE*CY-FAIR ISD*EXCELLENT LOCATION ONLY MINS. TO 290 AND THE OUTLET MALL*THIS IS A MUST SEE!' ,`Acres` = '0.1685' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 CYPRESS LANDING EAST SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7338' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '762' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'KEITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Landing' ,`TaxAmount` = '9479' ,`TaxRate` = '2.761' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694016' WHERE `Matrix_Unique_ID` = '209311583' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T13:08:03.530' ,`MLSNumber` = '81238028' ,`ListAgentFullName` = 'Massiel Romero' ,`ListOfficeName` = '2M Realty Advisors, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.001343' ,`Longitude` = '-95.554287' ,`PhotoCount` = '23' ,`PostalCode` = '77379' ,`RoomCount` = '9' ,`ListPrice` = '705000.00' ,`Status` = 'Active' ,`StreetName` = 'Chipstead' ,`StreetNumber` = '9703' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location!!! Newly renovated and with lots of space wonderful home.\nGorgeous inside and out!! Close to major freeways in the highly desired Spring Champions área. \nSchedule your showing today!! ' ,`Acres` = '0.2215' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 ESTATES AT WINDRUSH SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BRILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Estates At Windrush Sec 03' ,`TaxAmount` = '11276' ,`TaxRate` = '2.3465' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '209969934' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:57:33.030' ,`MLSNumber` = '6948083' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968019' ,`Longitude` = '-95.465004' ,`PhotoCount` = '18' ,`PostalCode` = '77014' ,`RoomCount` = '6' ,`ListPrice` = '269900.00' ,`Status` = 'Active' ,`StreetName` = 'Wisner' ,`StreetNumber` = '2823' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2055' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1281' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 SILVERLEAF' ,`LotDesciption` = 'Other' ,`LotSize` = '5580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverleaf Sec 1' ,`TaxAmount` = '5252' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210111986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:06:00.457' ,`MLSNumber` = '46699492' ,`ListAgentFullName` = 'Miguel Rosario' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831354' ,`Longitude` = '-95.197453' ,`PhotoCount` = '7' ,`PostalCode` = '77049' ,`RoomCount` = '3' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivydale' ,`StreetNumber` = '13034' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '949' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new roof installed on this 3 bedroom home. This fixer-upper has excellent income potential with two separate septics and two separate incoming power lines. This property had a Manufactured home in the backyard that was being leased out and since has been moved. With the large yard, there are endless possibilities for what you can do.' ,`Acres` = '0.2479' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LT 310 BLK 23 BEAUMONT PLACE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'ROYALWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'C.E. KING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Beaumont Place' ,`TaxAmount` = '929' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210170224' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:41:17.730' ,`MLSNumber` = '8886720' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544192' ,`Longitude` = '-95.229552' ,`PhotoCount` = '28' ,`PostalCode` = '77581' ,`RoomCount` = '6' ,`ListPrice` = '404900.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Grove' ,`StreetNumber` = '1512' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1848' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PINE HOLLOW SEC 1-A (A0111 PERRY & AUSTIN)(PEARLAND), BLOCK' ,`LotDesciption` = 'Other' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'RUSTIC OAK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Hollow Sec 1-A/1-B/1-C' ,`TaxAmount` = '6132' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210171523' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:08:25.177' ,`MLSNumber` = '26762066' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.146239' ,`Longitude` = '-95.413470' ,`PhotoCount` = '28' ,`PostalCode` = '77385' ,`RoomCount` = '6' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgemoor Estates' ,`StreetNumber` = '22993' ,`StreetSuffix` = 'Court' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3147' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.3156' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'IMPERIAL OAKS ESTATES 02, BLOCK 2, LOT 8' ,`LotDesciption` = 'Other' ,`LotSize` = '13747' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'KAUFMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Oaks Estates 02' ,`TaxAmount` = '6683' ,`TaxRate` = '2.4827' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210393113' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:12:24.197' ,`MLSNumber` = '7535604' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003986' ,`Longitude` = '-95.402896' ,`PhotoCount` = '22' ,`PostalCode` = '77073' ,`RoomCount` = '6' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Trace' ,`StreetNumber` = '15803' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1910' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1103' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 10 IMPERIAL TRACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4805' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Trace Sec 1' ,`TaxAmount` = '5064' ,`TaxRate` = '2.5095' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210393131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:28:38.250' ,`MLSNumber` = '69649691' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.505968' ,`Longitude` = '-95.509007' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '5' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Dell' ,`StreetNumber` = '4042' ,`StreetSuffix` = 'Lane' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1527' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA STEEP BANK VILLAGE SEC 9, BLOCK 1, LOT 21' ,`LotDesciption` = 'Other' ,`LotSize` = '6651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1229' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SIENNA CROSSING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Steep Bank Village Sec 9' ,`TaxAmount` = '6047' ,`TaxRate` = '2.5729' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210393222' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:31:04.593' ,`MLSNumber` = '26704257' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.929725' ,`Longitude` = '-95.174019' ,`PhotoCount` = '32' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Knoll' ,`StreetNumber` = '15035' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3163' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1892' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 15 BLK 1 LAKE FOREST VILLAGE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '8243' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '882' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake Forest Village Sec 03' ,`TaxAmount` = '8204' ,`TaxRate` = '2.793' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694017' WHERE `Matrix_Unique_ID` = '210408256' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:40:05.063' ,`MLSNumber` = '38067658' ,`ListAgentFullName` = 'Steven Andrews' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.802187' ,`Longitude` = '-94.722470' ,`PhotoCount` = '29' ,`PostalCode` = '75683' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Redbud' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Ore City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home has a fresh new look and is absolutely a show stopper. This beauty is perfect with a nice sized back yard for the kids and Fido to play. This home features new granite countertops, new appliances, floors and much more. It also has a nice covered patio in the back yard great for entertaining. Call today to schedule your private home tour.' ,`Acres` = '0.4821' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 4-6, BLK 60 ORE CITY S269 (A297) .4821 ACRES & HOUSE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '793 - Ore City' ,`SchoolElementary` = 'ORE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ORE CITY HIGH SCHOOL' ,`SchoolMiddle` = 'ORE CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ore City' ,`TaxAmount` = '2237' ,`TaxRate` = '2.5779' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694018' WHERE `Matrix_Unique_ID` = '210870221' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:05:25.823' ,`MLSNumber` = '69291480' ,`ListAgentFullName` = 'Lindsay Howard' ,`ListOfficeName` = 'Howard Home Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.930563' ,`Longitude` = '-95.336651' ,`PhotoCount` = '48' ,`PostalCode` = '75862' ,`RoomCount` = '11' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Lake' ,`StreetNumber` = '46' ,`StreetSuffix` = '' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1649' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Experienced custom builder has acquired 40+ lots in Westwood Shores on the golf course, some patio and some wooded, throughout this gated community. This home is a sample of the style and amenities included in some homes. The sizes will range from 1200 plus square feet, so now is the time to pick your lot and floor plan. This beautiful modern Prairie-style house plan has great curb appeal. The modern windows and bold columns on either side of the entryway complete this look. The foyer which boasts an 11’ ceiling welcomes you into the spacious great room where you will find an elegant boxed ceiling and cozy fireplace. The great room is partially open to the kitchen over a raised eat-at bar. The master bedroom boasts an elegant 10’ boxed ceiling and has direct access to the grilling porch. The master bath is complete with a glass shower, freestanding tub, dual sink vanity, private toilet room and spacious walk-in closet.' ,`Acres` = '0.2667' ,`Area` = '42' ,`BuilderName` = 'Raa Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 67 LOT 17' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '11618' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Westwood Shores Sec 4' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694018' WHERE `Matrix_Unique_ID` = '210989737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:27:07.333' ,`MLSNumber` = '45028974' ,`ListAgentFullName` = 'Reginald Hays' ,`ListOfficeName` = 'RE/MAX Advanced Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.497693' ,`Longitude` = '-96.544781' ,`PhotoCount` = '48' ,`PostalCode` = '76642' ,`RoomCount` = '10' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'LCR 786' ,`StreetNumber` = '954' ,`StreetSuffix` = '' ,`City` = 'Groesbeck' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet country setting located just a few minutes from town! This roomy 3 bed/2 bath home has some nice upgrades with large rooms. Upgrades include new flooring, New HVAC system, and is freshly painted throughout. There\'s a large covered front porch and a large covered back porch to enjoy your morning coffee and evening beverage. You will enjoy the workshop (on a slab) with electric in place, plenty of storage for your lawn equipment and tools. The home is equipped with a concrete storm seller, metal roof, aerobic septic system, water well, and several additional buildings including a guest apt. Enjoy the peace and quite of small town country living.' ,`Acres` = '0.94' ,`Area` = '73' ,`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` = '0.94 Acres in the A VARELA Survey A-029' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '222 - Groesbeck' ,`SchoolElementary` = 'GROESBECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROESBECK HIGH SCHOOL' ,`SchoolMiddle` = 'GROESBECK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694018' WHERE `Matrix_Unique_ID` = '210991742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T12:02:15.723' ,`MLSNumber` = '16931112' ,`ListAgentFullName` = 'Mary Garbett' ,`ListOfficeName` = 'Hodde Real Estate Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.176274' ,`Longitude` = '-96.390164' ,`PhotoCount` = '17' ,`PostalCode` = '77833' ,`RoomCount` = '8' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Armbrister' ,`StreetNumber` = '815' ,`StreetSuffix` = 'Street' ,`City` = 'Brenham' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1588' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Convenient location near Loop 577 and Brenham area schools. Two story home with 3-4 bedrooms and 2-1/2 baths, living room, breakfast nook and utility room off of kitchen. Recent updates include attached single car garage on slab, some home plumbing replaced, and composition roof. Duct-work present for central A/C & heat, but currently using window units. A beautiful large oak tree shades the backyard and front porch looks over attractive front yard. A little more TLC will go a long way toward making this house your own home or an investment property.' ,`Acres` = '0.1452' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'WOODS/ARMBRISTER, BLOCK 4, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6323' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woods/Armbrister' ,`TaxAmount` = '1446' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694018' WHERE `Matrix_Unique_ID` = '210994876' --> Updated record success