Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T14:50:26.660' ,`MLSNumber` = '19311001' ,`ListAgentFullName` = 'Sara Farzana Patel' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.180376' ,`Longitude` = '-96.535749' ,`PhotoCount` = '30' ,`PostalCode` = '76629' ,`RoomCount` = '3' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2293' ,`StreetNumber` = '16286' ,`StreetSuffix` = '' ,`City` = 'Bremond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3317' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Definitely a MUST SEE!! This breathtaking & spacious home sits on 1/2 acre. THIS UNIQUE GEM WILL NOT LAST LONG!! It is located on Fm 2293, perfect for your home business to prosper. This  3 bedrooms and 2 full baths, open kitchen with dining and breakfast area, the spacious family room is very inviting.  The Upstairs huge   Bedroom is perfect for an adult kid. It has its own door with stairs to give complete privacy. The stairs lead to a very cozy and private patio, perfect for outdoor entertaining. Circle drive in front of the house and garage houses 2 cars w/workshop area. The back of the house has a small building.  Lots of closets and storage upstairs. Appraisal district has sqft 2857 previous owner added additional 460sqft bringing the total sqft of heated and cool space to be 3317sqft. There is absolutely too much to mention! Great country living!' ,`Acres` = '0.5' ,`Area` = '72' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 347 TR 32 F THOMPSON QD#6 1146/538 0.5 ACRES' ,`LotDesciption` = 'Other' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '366 - Bremond' ,`SchoolElementary` = 'BREMOND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BREMOND HIGH SCHOOL' ,`SchoolMiddle` = 'BREMOND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '3879' ,`TaxRate` = '1.8806' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '206207465'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T14:42:04.977' ,`MLSNumber` = '30355331' ,`ListAgentFullName` = 'Daphne Carlsen' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.811526' ,`Longitude` = '-95.668834' ,`PhotoCount` = '29' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 652' ,`StreetNumber` = '143' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice 2/1 home on beautiful tree shaded lot (live Oaks) well maintained. featuring open concept kitchen, dining and living room, breakfast bar, furnished. Laminate flooring HVAC split unit. storage with washer/dryer, freezer included.\r\nFront porch and large deck facing Caney Creek 1/2 covered other end open. Deck furniture conveys. NEW BOAT LIFT,PIER,CLEANINF TABLE, vinyl bulkhead. underneath storage. INCLUDES TWO OFF WATER LOTS. great boat parking and to build barn.\r\n Only minutes to the ICW, east Matagorda Bay and beach. Enjoy swimming, skiing, fishing right out your back. Close to all restaurant\'s bait camps. Beautiful sunsets. Peaceful walks on beach, shell hunting or just relaxing.' ,`Acres` = '0.1951' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LIVE OAK BEND SEC II, LOT 143' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '8499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Live Oak Bend Sec II' ,`TaxAmount` = '4060' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '207374009'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T14:14:16.980' ,`MLSNumber` = '30080552' ,`ListAgentFullName` = 'Julia Medellin' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.287510' ,`Longitude` = '-94.822446' ,`PhotoCount` = '35' ,`PostalCode` = '77551' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Ursuline' ,`StreetNumber` = '5028' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '2852' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking to buy in the hot Galveston market? Look no further! This home is selling fully furnished and offers an open living/dining/kitchen floor plan, ideal for family gatherings. The updated kitchen is filled with natural light from the large bay window with seating, perfect as a reading nook with the built in bookshelves. Throughout the home, you will find original construction touches along with trendy and updated features.The upstairs includes 3 bedrooms / 2 baths and the downstairs includes 3 bedrooms and 1 bath. The upstairs has been operating as a vacation rental since February 2022. There is also future income potential with a light rehab on the lower level. All showings will be scheduled around guest bookings and with a 2 hour showing notice. Thank you' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 7 H REID ROBINSON SUB' ,`LotDesciption` = 'Corner' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Robinson Sub 96' ,`TaxAmount` = '4371' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '208565956'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T15:46:13.350' ,`MLSNumber` = '19552246' ,`ListAgentFullName` = 'Bryann Owen' ,`ListOfficeName` = 'The Ashton Agency' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.489432' ,`Longitude` = '-94.549887' ,`PhotoCount` = '29' ,`PostalCode` = '77617' ,`RoomCount` = '5' ,`ListPrice` = '925000.00' ,`Status` = 'Active' ,`StreetName` = 'Caplen Shores' ,`StreetNumber` = '512' ,`StreetSuffix` = '' ,`City` = 'Gilchrist' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW! Your beach home awaits. This new construction beach bungalow with amazing views of the Gulf is located in a quiet area on the eastern side of Bolivar Peninsula. The one-of-a-kind open floor plan offers gorgeous views from the large wall of windows in the living rm, kitchen and primary bedroom. 4 large bedrooms and 3 bathrooms offer plenty of room for your family and guests. Could easily sleep 14+. The oversized front and side decks offer breathtaking views and the oversized lot offers endless possibilities for outdoor living. Estimated completion around the first of the year. Purchase now and select all finishes (flooring, colors, countertops and appliances, etc). Truly a custom opportunity steps from the beach! Generated photos are for visualization purposes only- actual finishes and colors will vary. Interior photos represent quality of work by the builder. Home is under construction- please use caution when visiting the homesite.' ,`Acres` = '0.236' ,`Area` = '33' ,`BuilderName` = 'Traditional Craftsm' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Caplen' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 31 R BARROW SUR CAPLEN SHORES SUB LOT 45' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '10280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '25 - High Island' ,`SchoolElementary` = 'HIGH ISLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HIGH ISLAND HIGH SCHOOL' ,`SchoolMiddle` = 'HIGH ISLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Caplen Shores 87' ,`TaxAmount` = '64' ,`TaxRate` = '1.5543' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '210598910'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T15:14:45.167' ,`MLSNumber` = '40694825' ,`ListAgentFullName` = 'Zoheb Noorani' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.713033' ,`Longitude` = '-95.368292' ,`PhotoCount` = '7' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'Binz' ,`StreetNumber` = '3216' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location home! Near downtown and the medical center. This house has 4 bedrooms and 3.5 bathrooms. There are 3 bedrooms upstairs with a spacious master bedroom, bath and closet located on the first floor with the living room and kitchen.  The house has a 2 car garage and long drive way for additional parking for hosting.' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 2 NORTH MACGREGOR OAKS' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'North Macgregor Oaks' ,`TaxAmount` = '13110' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1941' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '210880227'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-13T14:56:05.853' ,`MLSNumber` = '98134090' ,`ListAgentFullName` = 'Kristi Schmidt' ,`ListOfficeName` = 'Clay Property' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.349651' ,`Longitude` = '-95.479294' ,`PhotoCount` = '42' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '699900.00' ,`Status` = 'Active' ,`StreetName` = 'Wrangler' ,`StreetNumber` = '16311' ,`StreetSuffix` = 'Road' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3166' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Horses Allowed! Great layout! Beautiful home on 5 acres with a 40\' x 60\' shop in Suncreek Ranch! This 4 bedroom home has a kitchen that is open to the living room with formal dining and an office/playroom.  The kitchen includes breakfast bar seating and a Jenn-Air gas stove. On one side of the home you will find 3 bedrooms with a full bath, a laundry room, and a half bath.  The office/playroom and primary bedroom are on the other.  You can look out of the primary bedroom or living room windows to watch turkeys and other wildlife that frequent the property.  There is a garden in the back yard along with pecan, pear, guava, fig, and banana trees around the home.  The three car garage and wide driveway allow for plenty of parking.  The shop has 10\' of custom built storage space included along one side. It also has a two post lift.  Easy access to 288, 1462, and 521. Never flooded.  Access to neighborhood park and 100 acre lake.' ,`Acres` = '5' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 1 (A0125 A ROBINSON) BLK 2 LOT 8' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Suncreek Ranch' ,`TaxAmount` = '7195' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698081' WHERE `Matrix_Unique_ID` = '211132350'  --> Updated record success<br />