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-13T17:57:08.527' ,`MLSNumber` = '9474955' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.425184' ,`Longitude` = '-95.439334' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '391951.00' ,`Status` = 'Active' ,`StreetName` = 'Palisade Crest' ,`StreetNumber` = '2405' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2268' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR! Welcome home to your beautiful 2 Story, The Bedford Floor Plan with 4/5 Bedrooms, 2 1/2 Baths, with a 2 Car Garage. This floor plan boasts High Ceilings & SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Study, Half Bath, & Owner\'s Retreat downstairs. Upstairs you will find a Game Room, 3 Bedrooms with another full bath. You will love the Kitchen with granite/quartz countertops & SS appliances, & even a USB outlet. 10X20 PATIO. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, PEX Hot & Cold Water Lines, Radiant Barrier, Rheem Tankless Gas Water Heater, & Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. COMING SOON 4 ACRE LAGOON! Other amenities include Jr. Olympic Pool, Splash Pad, Bark Park, Exercise Facility, Hike & Bike Trails & MORE. Convenient to Pearland and 20 min. from Houston offering lots of entertainment, dining, & shopping options.' ,`Acres` = '0.1782' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4B (A0288 HT&BRR) BLK 3 LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '1554' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '208844981' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T17:57:38.883' ,`MLSNumber` = '79379842' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.426916' ,`Longitude` = '-95.437794' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '401040.00' ,`Status` = 'Active' ,`StreetName` = 'Brich Manor' ,`StreetNumber` = '2418' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1848' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D TOUR! Welcome home to your beautiful 1 Story, The Wetherby Floor Plan with 4 Bedrooms, 2 Baths, with a 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room, Kitchen, Breakfast Room, Study/Flex Room, and 4 Bedrooms with 2 full Baths. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, black appliances, and even a USB outlet. COVERED PATIO and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. COMING SOON 4 ACRE LAGOON! Other amenities include Jr. Olympic Pool, Splash Pad, Bark Park, Exercise Facility, Hike & Bike Trails & MORE. Convenient to Pearland and 20 min. from Houston offering lots of entertainment, dining, & shopping options.' ,`Acres` = '0.1702' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4B (A0288 HT&BRR) BLK 4 LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7414' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`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` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '1524' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '208930484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T17:58:10.083' ,`MLSNumber` = '84844085' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.482459' ,`Longitude` = '-95.415496' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '392909.00' ,`Status` = 'Active' ,`StreetName` = 'Brich Manor' ,`StreetNumber` = '2414' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1931' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See SAMPLE 3D Tour! Welcome home to this beautiful Epsom Floorplan with 3 Bedroom, 2 Bath, with a 2 Car Garage. This home has a spacious OPEN CONCEPT FLOOR PLAN with Study and Formal Dining Room that can be used as you wish. You will love the Kitchen with lots of cabinets with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Tile and Carpet throughout. COVERED PATIO with fenced backyard. COST & ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Low E Windows that open to the inside of the home for cleaning. COMING SOON 4 ACRE LAGOON! Other amenities include Jr. Olympic Pool, Splash Pad, Bark Park, Exercise Facility, Hike & Bike Trails & MORE. Convenient to Pearland and 20 min. from Houston offering lots of entertainment, dining, & shopping options. Alvin ISD!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 4B (A0288 HT&BRR) BLK 4 LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`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` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '209151249' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T16:33:17.270' ,`MLSNumber` = '45006380' ,`ListAgentFullName` = 'Charles Miller' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.673024' ,`Longitude` = '-94.946069' ,`PhotoCount` = '24' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '269751.00' ,`Status` = 'Active' ,`StreetName` = 'Ash' ,`StreetNumber` = '134' ,`StreetSuffix` = 'Street' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2006' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2006 SQ FT OPEN CONCEPT HOME IN A PRIVATE WATERFRONT COMMUNITY- LAKESIDE VILLAGE, HOME FEATURES 3/4 BEDROOMS, 2 FULL BATHROOMS. KITCHEN HAS GRANITE COUNTER TOPS, CUSTOM SINK AND PLENTY OF CABINET SPACE,TILE BACK SPLASH, MICRO-HOOD, DINING AREA, SPACIOUS LIVING AREA, COMFORTABLE MASTER BEDROOM WITH WALK-IN CLOSET, MASTER BATHROOM, TILE SHOWER AND BATHTUB, 1 OF THE LIVING AREAS COULD BE A BEDROOM, GAME ROOM, 2 LARGE BEDROOMS WITH WALK IN CLOSETS, RELAX ON THE 11 x 16 COVERED PORCH AND WATCH THE WILDLIFE( DEER, SQUIRRELS, HUMMINGBIRDS AND MORE) 2 CAR ATTACHED CARPORT, PRIVATE LAKE HAS GREAT FISHING, NO MOTORIZED BOATS. CLOSE TO THE HOSPITAL,WAL-MART, RESTAURANTS, SHOPPING AND ONLY MINUTES AWAY FROM THE 2ND LARGEST LAKE IN TEXAS- LAKE LIVINGSTON' ,`Acres` = '0.2711' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKESIDE VILLAGE BLK 12 LOT 2 SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11811' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Village' ,`TaxAmount` = '2648' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '209345344' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T16:06:15.607' ,`MLSNumber` = '7638071' ,`ListAgentFullName` = 'James Oolut' ,`ListOfficeName` = 'National Realty Company' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.680873' ,`Longitude` = '-95.720303' ,`PhotoCount` = '9' ,`PostalCode` = '77407' ,`RoomCount` = '10' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrow Grand' ,`StreetNumber` = '19326' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New roof - less than 1 year old.\r\nDistributed Plumbing System' ,`Acres` = '0.1472' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BRADFORD PARK SEC 2, BLOCK 1, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6412' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Supra Keybox,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Bradford Park Sec 2' ,`TaxAmount` = '5574' ,`TaxRate` = '2.3529' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '209708740' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T17:23:43.550' ,`MLSNumber` = '22431345' ,`ListAgentFullName` = 'LeAnne McMillen' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.192419' ,`Longitude` = '-95.813924' ,`PhotoCount` = '36' ,`PostalCode` = '77355' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Candleridge' ,`StreetNumber` = '25420' ,`StreetSuffix` = 'Court' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home Is move in Ready..... This adorable home is like new. It has been completely remodeled inside.This Large double wide home offers Tile floors, Laminate wood flooring in the bedrooms, granite countertops, undercounter mounted sinks, nice closets in each room.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S732301 REMINGTON FOREST 1 BLK 1 LOT 10 ACRES .5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Remington Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663698123' WHERE `Matrix_Unique_ID` = '211228953' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T16:34:05.740' ,`MLSNumber` = '73065913' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.432152' ,`Longitude` = '-95.458824' ,`PhotoCount` = '11' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '322329.00' ,`Status` = 'Active' ,`StreetName` = 'Red Hills' ,`StreetNumber` = '1313' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1464' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR!!! Beautiful 1 story, The Darlington Floor Plan with 3 Bedrooms, 2 Baths, and an attached 2 Car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with a Family Room, Kitchen, Breakfast Room, and 4 Bedrooms with 2 full Baths. Tile and carpet flooring. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, Stainless Steel Appliances, and even a USB outlet. Fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon. Convenient to Downtown Houston, Medical Center, Pearland, & the Beach! Alvin ISD. Call today for your private tour!' ,`Acres` = '0.1435' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 3 LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6251' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`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` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1406' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698124' WHERE `Matrix_Unique_ID` = '211270078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T17:31:31.333' ,`MLSNumber` = '45560869' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434105' ,`Longitude` = '-95.460045' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '7' ,`ListPrice` = '370624.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Peak' ,`StreetNumber` = '10311' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR! Welcome home to your beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 1/2 Baths, with a 2 Car Garage. This floor plan boasts a spacious OPEN CONCEPT FLOOR PLAN with Family Room, Kitchen, Primary Bedroom Suite downstairs. Upstairs you will find a Tech Center, 3 Bedrooms, and another Full Bath. The bedrooms all have huge walk-in closets. You will love the Kitchen with lots of cabinets, SS appliances, and even a USB outlet. Tile and carpet throughout. Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Low E Windows that open to the inside of the home for cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon. Convenient to Downtown Houston, Medical Center, Pearland, & the Beach! Alvin ISD. Call today for your private tour!' ,`Acres` = '0.1705' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 4 LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7427' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`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` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1527' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698124' WHERE `Matrix_Unique_ID` = '211271106' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T17:53:37.810' ,`MLSNumber` = '40245639' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.434353' ,`Longitude` = '-95.460625' ,`PhotoCount` = '12' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '387962.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Peak' ,`StreetNumber` = '10302' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2502' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See sample VIRTUAL TOUR! Beautiful Beckenham Floor Plan with 4 Bedrooms, 2 ½ Baths, with attached 2 car Garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, Half Bath, Utility Room, and Owner’s Retreat downstairs. Upstairs you will find a Game room, 3 Bedrooms, 2 with walk in closets, and another Full Bath. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, SS appliances, & even a USB outlet. Fenced Backyard. COST AND ENERGY EFFICIENT FEATURES: 16 Seer HVAC System, Honeywell Programmable Thermostat, Pex Hot and cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for easy cleaning. Amenities include Playground, Dog Park, Splash Pad and Olympic size pool, Hiking/Biking Trails and 4 ACRE Lagoon coming soon. Convenient to Downtown Houston, Medical Center, Pearland, & the Beach! Alvin ISD.' ,`Acres` = '0.3134' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA WEST SEC 3 (A0329 LAV NAV CO) BLK 2 LOT 44' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13652' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`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` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista West' ,`TaxAmount` = '1936' ,`TaxRate` = '3.6007' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698124' WHERE `Matrix_Unique_ID` = '211272255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T16:46:55.017' ,`MLSNumber` = '21231225' ,`ListAgentFullName` = 'Jacki Hart' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.115419' ,`Longitude` = '-95.085298' ,`PhotoCount` = '9' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '590000.00' ,`Status` = 'Active' ,`StreetName` = 'Mendocino' ,`StreetNumber` = '3942' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new construction home will be a great family home or a perfect vacation rental opportunity. Enjoy all that Galveston has to offer and make this home yours today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'super tech co' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 29 BLK 2 LAGUNA SAN LUIS SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Laguna San Luis' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698124' WHERE `Matrix_Unique_ID` = '211362759' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T16:48:25.990' ,`MLSNumber` = '53806992' ,`ListAgentFullName` = 'Roscoe Ford' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.330277' ,`Longitude` = '-96.095112' ,`PhotoCount` = '40' ,`PostalCode` = '77488' ,`RoomCount` = '5' ,`ListPrice` = '529900.00' ,`Status` = 'Active' ,`StreetName` = 'Richmond' ,`StreetNumber` = '2104' ,`StreetSuffix` = 'Road' ,`City` = 'Wharton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '+4,000 SF Freestanding Building on +30,000 SF Prime Frontage Location! There are so many options with this space. 12,868 SF of stabilized concrete driveway, Fully-fenced security system with ingress/ egress from multiple streets, Garage has central air,175\' Frontage along Business 59/Richmond Rd, Centrally located, yet Unaffected by flooding during Hurrican Harvey (2017), Built 2011-2012.' ,`Acres` = '0.6887' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AHLDAG BLOCK 38F-1,38F-2,BARCLAY' ,`LotDesciption` = 'Corner' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ahldag' ,`TaxAmount` = '8058' ,`TaxRate` = '2.4334' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698124' WHERE `Matrix_Unique_ID` = '211399464' --> Updated record success