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-25T16:44:53.513' ,`MLSNumber` = '80954081' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '42' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '878582.00' ,`Status` = 'Active' ,`StreetName` = 'Trace' ,`StreetNumber` = '4406' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4048' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Hemleigh floorplan - AUGUST MOVE-IN! New home in Cross Creek Ranch features stucco, brick and stone elevation located in a\r\ncorner homesite. Enjoy the spacious home with 4 beds, 3.5 bath and 3 car garage size.\r\nYou will be welcomed into the spacious open-concept design, perfect for entertaining.\r\nHost a neighborhood BBQ on the extended covered patio. Create your special dish in the\r\nchef inspired kitchen featuring stainless appliance including double ovens, tons of counter\r\nspace, Silestone countertops, herringbone backsplash, undercabinet lighting and more!\r\nThe primary suite is the perfect place to relax with a spacious bedroom, free-standing\r\nbathtub, dual sinks, and huge closet! Working form home? The home office offers privacy\r\nand space. The home is designed with durable and easy-to-maintain luxury wood look\r\nflooring throughout the home. This two-story home will check all the boxes for function\r\nand style!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '20/02/CT05' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13941' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '207932394' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:21:59.563' ,`MLSNumber` = '50002952' ,`ListAgentFullName` = 'Donna Story' ,`ListOfficeName` = 'Keller Williams Advntge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.680595' ,`Longitude` = '-95.570202' ,`PhotoCount` = '29' ,`PostalCode` = '77340' ,`RoomCount` = '8' ,`ListPrice` = '149500.00' ,`Status` = 'Active' ,`StreetName` = 'Kingston' ,`StreetNumber` = '3221' ,`StreetSuffix` = 'Drive' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This IMMACULATELY maintained home sits on just under a half-acre corner lot located in the established neighborhood of Majestic Forest. Located less than 4 miles from Sam Houston State University and the I-45 corridor between Houston to Dallas and many other local amenities. This floorplan features a huge family room, dining room, kitchen with lots of cabinets, a breakfast bar, and lots of additional room for your family gatherings. Primary Bedroom is spacious with a bathroom with a soaking tub, separate shower, double sinks, and a walk-in closet. Fenced backyard and attached/detached 1- car garage with workshop. The exterior has been recently painted and priced for you to update your interior flooring to your specifications.' ,`Acres` = '0.44' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MAJESTIC FOREST, BLOCK 3, LOT 19, ACRES 0.44' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '19166' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Majestic Forest' ,`TaxAmount` = '1293' ,`TaxRate` = '1.9609' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '207961278' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:44:36.710' ,`MLSNumber` = '82272326' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '46' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '572756.00' ,`Status` = 'Active' ,`StreetName` = 'Hauter Way' ,`StreetNumber` = '29026' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Tanager floorplan - This delighting 2-single-story home greets you with a gallery-style foyer that leads into an open-to below layout, perfect for having guests over. Whip up some goodies in the kitchen and benefit from stainless steel appliances, walk-in pantry, central island, ideal for entertaining. Sometimes we just need extra flex space, and this home has it. The open room is ideal for a den, home office, or playroom. Cozy up in the master suite after a long day with a large shower, double sinks, and a walk-in closet. Complete with a vaulted covered\r\npatio, you will have a smartly laid-out home, ready for everyday function!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '01/02/CT06' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '208193638' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:04:22.273' ,`MLSNumber` = '40007620' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569111' ,`Longitude` = '-95.616948' ,`PhotoCount` = '34' ,`PostalCode` = '77479' ,`RoomCount` = '10' ,`ListPrice` = '899999.00' ,`Status` = 'Active' ,`StreetName` = 'Massey' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Row' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FANTASTIC OPPORTUNITY TO OWN IN THE PRESTIGIOUS SWEETWATER! THIS ELEGANT CUSTOM HOME IS SITUATED ON AN IMPRESSIVE ELEVATION WITH LUSH LANDSCAPING. A BEAUTIFUL FRONT DOOR LEADS YOU TO A ONE OF A KIND GRAND ENTRY WITH SOARING CEILINGS, CROWN MOLDINGS, AND CURVED STAIRS CASE ALL OPEN UP TO ELEGANT FORMALS WITH LARGE WINDOWS TO TAKE IN ALL THE VIEWS. AMAZING ISLAND KITCHEN FLOWS INTO THE LARGE FAMILY ROOM. GREAT FOR ENTERTAINING! ROMANTIC PRIMARY SUITE WITH FIREPLACE THAT FEATURES SPA-LIKE BATH, AND A PRIVATE BALCONY! UPSTAIRS FEATURES LARGE SECONDARY BEDROOMS WITH WALK-IN CLOSETS. 3 CAR GARAGE. SWEETWATER CC & GOLF COURSE IS NEARBY. MINS AWAY FROM MANY AMENITIES, ENTERTAINMENT & MAJOR ACCESSWAYS. CLOSE TO TOP-RATED FORT BEND SCHOOLS & LOW TAX RATE!' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SWEETWATER SEC 2, BLOCK 4, LOT 3' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '12975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2110' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sweetwater' ,`TaxAmount` = '12029' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '208372296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:03:02.793' ,`MLSNumber` = '13491929' ,`ListAgentFullName` = 'Isabel Lopez' ,`ListOfficeName` = 'Isabel Lopez Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.687857' ,`Longitude` = '-95.243584' ,`PhotoCount` = '13' ,`PostalCode` = '77017' ,`RoomCount` = '12' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Oriole' ,`StreetNumber` = '5321' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3073' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'nice and spacious house, built in 2008. good location. located 20 minutes from Downtown. This house has so much charm, spacious for your cars.' ,`Acres` = '0.1562' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 14 FOREST OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6803' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'STEVENSON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Forest Oaks' ,`TaxAmount` = '6554' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '208935524' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:36:40.750' ,`MLSNumber` = '54557292' ,`ListAgentFullName` = 'Pompello Rubio' ,`ListOfficeName` = 'Texas Key Holders Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.118886' ,`Longitude` = '-95.384093' ,`PhotoCount` = '19' ,`PostalCode` = '77386' ,`RoomCount` = '4' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Fuller Bluff' ,`StreetNumber` = '3519' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1625' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very spacious and cozy home. Very clean and well kept home. Home has a front porch where you can sit back and relax. Nice open kitchen with breakfast kitchen combo. Easy access to Freeway and schools. ***Currently tenant occupied, investors would be great, month to month at this time.***' ,`Acres` = '0.1012' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S688206 - LEGENDS RUN 06, BLOCK 1, LOT 15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Legends Run 06' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '209071091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:25:36.163' ,`MLSNumber` = '17306055' ,`ListAgentFullName` = 'Marina Serbantez' ,`ListOfficeName` = 'Ambassador Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.179796' ,`Longitude` = '-95.716600' ,`PhotoCount` = '18' ,`PostalCode` = '77486' ,`RoomCount` = '3' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Osceola' ,`StreetNumber` = '8481' ,`StreetSuffix` = 'Lane' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1834' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HUGE PRICE REDUCTION!!! If you are looking for peace, tranquility, a place where you can sit outside and watch the deer gather in your back yard, this is it! We have 3 large bedrooms and 2 full baths. Open kitchen and living which makes for a great place to hold all you special family gatherings. Additional room that can be used for second living area or home office. Inside utility room. Here is your chance to own 1.9 acres in Gayle Estates. Call today to schedule your personal showing. Seller giving buyer $5000 to use which ever way they would like! Seller is ready to sell.' ,`Acres` = '1.9' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GAYLE ESTATES (A0132 JESSE THOMPSON) BLK 4 LOT 5-5A ACRES 1.' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '82764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gayle Estates' ,`TaxAmount` = '3287' ,`TaxRate` = '1.6563' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '209629154' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:08:11.587' ,`MLSNumber` = '20204867' ,`ListAgentFullName` = 'Stacey Hawkins' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.977081' ,`Longitude` = '-95.473902' ,`PhotoCount` = '16' ,`PostalCode` = '77014' ,`RoomCount` = '8' ,`ListPrice` = '230000.00' ,`Status` = 'Active' ,`StreetName` = 'Repa' ,`StreetNumber` = '13631' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A \"MUST SEE\"!!! Won\'t last long. This is a beautiful 4 bedroom home and is in a nice area. The home is not updated and is well kept. Measurements are approximate. Buyers want $1,000 EM and $200 option fee. All sizes are approximate. Beautiful home that needs a little TLC. A/C needs work, plumbing in the home was fixed and the bathroom tub wall needs replacing or update. Highest and best offer!!!!!!!!! Showings will ONLY be on Saturdays and Sundays afternoons.' ,`Acres` = '0.0983' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 3 SABLECHASE SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '4284' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'BENEKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sablechase Sec 03' ,`TaxAmount` = '5306' ,`TaxRate` = '2.8817' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702922' WHERE `Matrix_Unique_ID` = '210036980' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:47:37.087' ,`MLSNumber` = '20385483' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425115' ,`Longitude` = '-95.456916' ,`PhotoCount` = '21' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '453415.00' ,`Status` = 'Active' ,`StreetName` = 'Pioneer Rest' ,`StreetNumber` = '10843' ,`StreetSuffix` = 'Lane' ,`City` = 'Iowa Colony' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Skip the theater and enjoy movie night at home from the comfort of the Kessler\'s second-story game room. Linen cabinets with white-toned quartz countertops, beige tone EVP flooring with dark gray tweed carpet in our Balanced package. Situated along the Manuel growth corridor, Sierra Vista is 25 miles south of metro Houston in the sought-after Alvin ISD, consistently rated among the best in the region. Nearby, the brand-new rec center offers amenities like fitness classes, youth sports, and a swimming pool. Known for our energy saving features, our homes help you live a healthier and quieter lifestyle, while saving you thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0319 Plan L454B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`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` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.61' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '210356204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:43:45.183' ,`MLSNumber` = '56661998' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '50' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '822469.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy Bend' ,`StreetNumber` = '28910' ,`StreetSuffix` = 'Court' ,`City` = 'Fulshear' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3613' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful two-story Windsor home. Enter through the grand 8\' double front doors\r\nshowcasing the stunning curved staircase and high ceilings. Save time on your commute\r\nby utilizing the spacious at-home office. Entertain guests in the open-concept layout, with\r\nthe kitchen and great room flowing together. In the kitchen, benefit from the centralized\r\nisland and a large pantry and share a meal in the casual dining area. Unwind in the\r\nprimary suite that features two vanities, a free-standing tub, and a large walk-in closet.\r\nHead upstairs and host a game night in the game room, that oversees that main great\r\nroom. Retreat to your covered patio or cozy up with a book by the fireplace. This twostory will check all the boxes for function and style! Huge homesite and ready for pool.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '34/1/CTO4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '210628194' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:39:20.913' ,`MLSNumber` = '43916275' ,`ListAgentFullName` = 'Mary Carrizal' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654497' ,`Longitude` = '-95.223938' ,`PhotoCount` = '24' ,`PostalCode` = '77587' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue M' ,`StreetNumber` = '607' ,`StreetSuffix` = '' ,`City` = 'South Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come See this customized beauty! 4 Bedrooms, 2 bath, 2 vehicle attached carport, with all tile flooring and quartz counter tops, high ceilings through out the house are only few of the features this house has to offer. Located in the heart of South Houston. Close to restaurants and shopping centers and a short drive to Sam Houston Tollway, I-45 and La Porte Fwy 225. A Must See!!! Set up your appointment today to see all this new home has to offer!' ,`Acres` = '0.163' ,`Area` = '6' ,`BuilderName` = 'Private Builder' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'South Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 201 SOUTH HOUSTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'PEARL HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Houston' ,`TaxAmount` = '1400' ,`TaxRate` = '2.8255' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '210717900' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:59:48.393' ,`MLSNumber` = '46208585' ,`ListAgentFullName` = 'Jane NgaDung Nguyen' ,`ListOfficeName` = 'Alpha, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729557' ,`Longitude` = '-95.607633' ,`PhotoCount` = '17' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashton Park' ,`StreetNumber` = '3203' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Easy access to Beechnut & Beltway 8. Low HOA, Low Tax Rate. May need some TLC. \"AS IS\" Property. Seller will make NO REPAIRS.' ,`Acres` = '0.1917' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 4 ASHTON VILLAGE' ,`LotDesciption` = 'Corner' ,`LotSize` = '8350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashton Village' ,`TaxAmount` = '5743' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '210828087' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:22:52.057' ,`MLSNumber` = '25251955' ,`ListAgentFullName` = 'John Cope' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.727191' ,`Longitude` = '-95.412558' ,`PhotoCount` = '50' ,`PostalCode` = '77098' ,`RoomCount` = '12' ,`ListPrice` = '950000.00' ,`Status` = 'Active' ,`StreetName` = 'Bartlett' ,`StreetNumber` = '2250' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story (1938) all brick home in one of Houston\'s most desirable areas: Rice/Museum District. This home is approximately 2600/sqft divided into two apartments: 1st floor and 2nd floor. Great high-end investment opportunity, or with little effort, the apartments could be converted back into a home, OR, live in one apartment and lease the other. First floor and second floor are divided creating two apartments with approximately 1288/sqft each. The apartments each have their own character, but both feature: Two Bedrooms, Full Bath, Kitchen, Dining, Den, All Wood Floors, French Doors, Large Windows, and Private (front & back) Entrances. Only the garage and grounds are common. Walking or biking distance to Rice Village, Museums, Miller Outdoor Theater, Herman Park, Metro Rail and several Great Local Restaurants. . Close to Downtown, Sports Arenas, Medical Center, and Rice University. Owned & cared for by one family for several decades; first time on the market in over 30 years.' ,`Acres` = '0.1492' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 4A CHEVY CHASE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chevy Chase' ,`TaxAmount` = '15231' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '211062463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:43:26.803' ,`MLSNumber` = '71264170' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '44' ,`PostalCode` = '77441' ,`RoomCount` = '7' ,`ListPrice` = '472900.00' ,`Status` = 'Active' ,`StreetName` = 'Chloe Ridge' ,`StreetNumber` = '4203' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this stunning one story home. The Egret floorplan offers a gallery-style foyer that opens to an open concept living space that includes a spacious great room, kitchen and casual dining area. The kitchen features plenty of cabinet space for organizing and storing with a large pantry and central island. Great primary bedroom as well as an extended patio. This house is a must see.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/6/8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6779' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '211293532' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:43:08.880' ,`MLSNumber` = '76113013' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '43' ,`PostalCode` = '77441' ,`RoomCount` = '5' ,`ListPrice` = '544852.00' ,`Status` = 'Active' ,`StreetName` = 'Chloe Ridge' ,`StreetNumber` = '4215' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The open Concept Kingle floorplan - 1 story with 3 bedrooms, 3 baths, and a study. The gallery style foyer has tray ceilings offering a welcoming entry. This home has many added options covered patio , 8 \' entry doors , luxury vinyl plank wood through out home. Located in a cul-de -sac , this home is a must see.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '1/6/11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6429' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702923' WHERE `Matrix_Unique_ID` = '211293931' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:42:51.593' ,`MLSNumber` = '17212821' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Tri Pointe Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.719533' ,`Longitude` = '-95.871403' ,`PhotoCount` = '39' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '557734.00' ,`Status` = 'Active' ,`StreetName` = 'Sherman Oaks' ,`StreetNumber` = '4106' ,`StreetSuffix` = '' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2601' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Sanderling floorplan with stucco, stone exterior with a welcoming entry to a very open 2 story ceiling home. Central island with lots of cabintry with a large dining area and great covered patio.' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Tri Pointe Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '2/6/39' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cross Creek Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.33' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211300570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:51:15.637' ,`MLSNumber` = '57441045' ,`ListAgentFullName` = 'Alma Puerto' ,`ListOfficeName` = 'Texas Fast Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649978' ,`Longitude` = '-95.234103' ,`PhotoCount` = '28' ,`PostalCode` = '77034' ,`RoomCount` = '4' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Globe' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has been completely renovated and has lots of space. This house is located down the street from it\'s designated Elementary & Jr High School. Garage has been converted into an extra area for home so you can use your creativity and make it your own. Kitchen has granite countertops and stainless-steel appliances. Great for first time home buyers has a spacious backyard and covered patio for entertaining. Contact and schedule your showing today! Yo hablo espaƱol!' ,`Acres` = '0.1584' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 30 FREEWAY MANOR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'FREEMAN ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHHOUSTON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Freeway Manor Sec 03' ,`TaxAmount` = '4125' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211391672' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:13:58.287' ,`MLSNumber` = '71590919' ,`ListAgentFullName` = 'Trang Le' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.839386' ,`Longitude` = '-95.855295' ,`PhotoCount` = '30' ,`PostalCode` = '77493' ,`RoomCount` = '6' ,`ListPrice` = '419990.00' ,`Status` = 'Active' ,`StreetName` = 'Greenshank Drive' ,`StreetNumber` = '1020' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2331' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION HOME WITH LAKE VIEW. Come home to this modern and meticulous 2-story home and the windows are all facing the lake, so it is very cool. The house is designed with 2 shades of white paint and elegant brown wood furniture, creating a cozy and enjoyable feeling. House with 4 large bedrooms, 3 full baths. The primary bedroom offers a luxurious bathroom with a tub and walk-in shower. Open island kitchen overlooks the large room and dining area, with stainless steel appliances and granite countertops. The house located in Sunterra - is the newest community of Katy, Texas. It has a Crystal Lagoons campus of about 3.5 acres, with white sand beaches and blue waters in the Caribbean, regular activities such as swimming, kayaking, windsurfing. The lagoon will be located in a resort, elevates the entire population into a prime location to live, work and play, creating the feeling of living here \"every day is a holiday\". All schools are excellent \nSchedule a tour today!!!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Centex' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211419195' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:34:26.220' ,`MLSNumber` = '16883562' ,`ListAgentFullName` = 'Juan Salcedo' ,`ListOfficeName` = 'ASIN Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182466' ,`Longitude` = '-95.587524' ,`PhotoCount` = '25' ,`PostalCode` = '77382' ,`RoomCount` = '11' ,`ListPrice` = '655000.00' ,`Status` = 'Active' ,`StreetName` = 'Antico' ,`StreetNumber` = '6' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful house, great location near restaurants & shops! 4 Bedrooms, 3-1/2 bathrooms, open entrance, granite counter tops and lots of cabinet space, gorgeous wall designs in family room, wood floors in master bedroom and master closet, large game room, huge backyard & covered patio.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S969961 - WDLNDS VIL STERLING RIDGE 61, BLOCK 1, LOT 14' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Wooded' ,`LotSize` = '10604' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DERETCHIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Sterling Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211453030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:41:45.960' ,`MLSNumber` = '32423656' ,`ListAgentFullName` = 'Jenericia Sanders' ,`ListOfficeName` = 'Worth Clark Realty' ,`SellingAgentFullName` = 'Ibtesam Addahbly' ,`SellingOfficeName` = 'Keller Williams Realty -SW' ,`Latitude` = '29.641031' ,`Longitude` = '-95.547156' ,`PhotoCount` = '9' ,`PostalCode` = '77031' ,`RoomCount` = '8' ,`ListPrice` = '190000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Airport' ,`StreetNumber` = '9563' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1771' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is what investors dream of!!! It has a very modern floor plan and it also has a huge backyard. Please come out and view your new investment : )' ,`Acres` = '0.197' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 28 GLENSHIRE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Glenshire Sec 09' ,`TaxAmount` = '4606' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211522961' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:17:56.837' ,`MLSNumber` = '33825962' ,`ListAgentFullName` = 'Grecia Coronado' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.231645' ,`Longitude` = '-95.289940' ,`PhotoCount` = '42' ,`PostalCode` = '77306' ,`RoomCount` = '4' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Beeson' ,`StreetNumber` = '18267' ,`StreetSuffix` = 'Road' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If a beautiful modern home sitting on a large unrestricted property is what you\'ve been looking for... this is for you!!! This beautiful Mobile Home features a ton of upgrades inside and out, the property sits on nearly 2 acres and there\'s a pond!!!! Sit back and enjoy a cup of coffee on the extended front porch or go for a relaxing walk on your very own property. The carport will fit up to 4 vehicles, and the overextended drive-up-driveway will lead you to the front porch. The beautiful electric gate will make you feel so welcomed as soon as you drive up.There\'s so much this property has to offer, and for this price IT WILL NOT LAST!' ,`Acres` = '1.822' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0303 - KIBBE WM, TRACT 38-A, ACRES 1.822' ,`LotDesciption` = 'Cleared' ,`LotSize` = '79366' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Abstract Area 3 (Fm 149 South-Abst-A3' ,`TaxAmount` = '1989' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211596907' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:36:34.603' ,`MLSNumber` = '41787932' ,`ListAgentFullName` = 'Nancy Torres' ,`ListOfficeName` = 'Bates-Brinkley Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.892960' ,`Longitude` = '-94.992566' ,`PhotoCount` = '49' ,`PostalCode` = '77532' ,`RoomCount` = '8' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Kennings' ,`StreetNumber` = '4515' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4083' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to El Centenario! This gorgeous 4/3.5/2 sitting on 2.89-Acres with a controlled remote driveway gate and a long entrance driveway. Marble floors throughout the entire house, high ceilings. Oversized walk-in shower, huge utility room with soaking sink, walk-in pantry. Stainless Steel appliances and 36\"-range stove and custom-made wood cabinets, backsplash, granite countertops, crystal chandeliers. You will love the beautiful front door. Ready to entertain with the outdoor kitchenet, one full bathroom outside and high wood ceilings porch. Plenty of room for all your toys. To many upgrades, you have to see it!' ,`Acres` = '2.897' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 1 TURFWOOD ESTATES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '126193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Turfwood Estates' ,`TaxAmount` = '2726' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702924' WHERE `Matrix_Unique_ID` = '211683363' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:15:16.990' ,`MLSNumber` = '15083031' ,`ListAgentFullName` = 'Loyce Hutson' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.977713' ,`Longitude` = '-95.568268' ,`PhotoCount` = '36' ,`PostalCode` = '77422' ,`RoomCount` = '7' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Riverview Ranch' ,`StreetNumber` = '1092' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make your appointment today to view this beautiful 4 bedroom 2.5 bath home. This home sits on 2 acres and boosts a bright open kitchen that opens up to the family room and is perfect for large gatherings. The primary bedroom is very large and opens to the covered patio. There are 3 other nice size bedrooms in the home. One of the bedrooms can be used as an office. Relax on the covered patio where you can enjoy the serene sounds of your pond complete with fountain in your backyard. Residents have access to a private boat ramp. This one will not last long. Make your appointment today.' ,`Acres` = '2.034' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIVERVIEW RANCH ESTATES SEC 1 (A0041 T B BELL) BLK 1 LOT 28-' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '88601' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '36' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riverview Ranch Estates Sec 1' ,`TaxAmount` = '5214' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702925' WHERE `Matrix_Unique_ID` = '211701738' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:41:07.910' ,`MLSNumber` = '43898707' ,`ListAgentFullName` = 'Amanda Brown' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.820437' ,`Longitude` = '-95.174751' ,`PhotoCount` = '35' ,`PostalCode` = '77049' ,`RoomCount` = '11' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Arvonshire' ,`StreetNumber` = '14907' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You will be astonished by this 4/5 bedroom home located in the gated section of New Forest. This home is bursting with unique finishes and an incredible floor plan. Being a one story with 3 separate wings, each with a full bath, set this home apart. Upon entry, you are welcomed by a formal dining and office with a large closet, making a 5th bedroom possible. Behind the office, 2 bedrooms, a full bath, and laundry make up the first wing. The spacious living room boasts a wall of windows, soaring ceilings, and a gas fireplace. A primary suite is perfectly tucked beyond the living room with an impressive primary bath and vaulted ceilings. The kitchen is open to the main living area, and also an additional living/game room! The 3rd wing offers a guest suite or 4th bedroom with a private bath. As you make your way outside, the backyard will impress you with lush landscaping and a sparkling pool and spa. Located directly adjacent to Beltway 8 makes any commute a breeze! This home has it all!' ,`Acres` = '0.2162' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 NEW FOREST WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9419' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'DR SHIRLEY J WILLIAMSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'New Forest West Sec 02' ,`TaxAmount` = '10670' ,`TaxRate` = '2.9394' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702925' WHERE `Matrix_Unique_ID` = '211727564' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T16:37:57.140' ,`MLSNumber` = '74404297' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598419' ,`Longitude` = '-95.805102' ,`PhotoCount` = '23' ,`PostalCode` = '77471' ,`RoomCount` = '15' ,`ListPrice` = '523253.00' ,`Status` = 'Active' ,`StreetName` = 'Mason' ,`StreetNumber` = '6002' ,`StreetSuffix` = 'Way' ,`City` = 'Rosenberg' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3211' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning two-story Leo home design features 5 bedrooms, 4 baths and 2 car attached garage. Open dining room off hall. Beautiful maple cabinets and granite countertops in gourmet kitchen. Two bedrooms, including owner\'s suite, located downstairs. Huge walk-in closet, double sinks, separate tub and shower in owner\'s bath. Upstairs, you\'ll find a loft space, media room and 3 secondary bedrooms. Covered patio in backyard, perfect for entertaining. \r\nEnjoy the convenience of the community\'s Recreation Center, Lakes and Parks. Kingdom Heights in Rosenberg is conveniently located between Sugar Land and Katy/Fulshear with easy access to the major Highway 99 (Grand Pkwy). Offered by: K. Hovnanian of Houston II, L.L.C' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5/5/6' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8164' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '665' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'FROST ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingdom Heights' ,`TaxAmount` = '' ,`TaxRate` = '2.7948' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702925' WHERE `Matrix_Unique_ID` = '211825045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T17:20:22.443' ,`MLSNumber` = '67826355' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.832673' ,`Longitude` = '-95.855734' ,`PhotoCount` = '19' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '409690.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1589' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AMAZING NEW D. R. HORTON BUILT 1 STORY 4 BEDROOM! Incredible Features Abound: High Ceilings, Luxury Vinyl Plank Wood-Look Flooring, Stainless Appliances with 5 Burner Cooktop, Black & White Granite Countertops, White Subway Tile Backsplash & 42\" White Kitchen Cabinetry with Under Cabinet Lighting, Primary Bath with Separate Tub & Shower, Tankless Water Heater, Oversized Covered Patio, & Full Sprinkler System! WOW! Open Concept Interior Design with Island Kitchen Open to Spacious Dining & Living Areas! Privately Located Primary Suite with Pretty Garden Bath & Walk-In Closet! Indoor Utility Room! Zoned to Katy ISD Schools! Unbelievable Community with Crystal Lagoon & Amenity Center with Clubhouse, Playground, Trails, Pool, PLUS MORE! Easy Access to the Grand Parkway! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '23/1/15' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6663' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702925' WHERE `Matrix_Unique_ID` = '211829882' --> Updated record success