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-24T22:43:19.250' ,`MLSNumber` = '80138296' ,`ListAgentFullName` = 'Mohammed Maniar' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694860' ,`Longitude` = '-95.609067' ,`PhotoCount` = '32' ,`PostalCode` = '77072' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Villawood' ,`StreetNumber` = '12914' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SPACIOUS OPEN CONCEPT DESIGN WITH LIVING DINNING COMBO INCLUDES FIRE PLACE TILES ON GROUND FLOOR,LAMINATED WOOD FLOOR ON ALL BED ROOMS NEWLY PAINTED INSIDE AND OUTSIDE,NEW BATH ROOM FAUCETS,REMODEL MASTER BATHROOM ,FRESHLY PAINTED KITCHEN AND BATHROOM CABINETS,WET BAR FOR YOUR GUEST HUGE BACKYARD  AREA FOR BBQ AND PARTY AND ENTERTAINMENT FOR GUEST.KITCHEN AREA CAN ALSO BE USED AS FAMILY DEN.' ,`Acres` = '0.1719' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TR 18A BLK 6 W 40 FT OF LT 17 & E 27.3 FT OF LT 18 BRAEWOOD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7487' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'LIESTMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braewood Glen Sec 04' ,`TaxAmount` = '4705' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702637' WHERE `Matrix_Unique_ID` = '207610579'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T23:14:54.250' ,`MLSNumber` = '62430292' ,`ListAgentFullName` = 'Cecilia Whitaker' ,`ListOfficeName` = 'RE/MAX Distinction' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082186' ,`Longitude` = '-95.670913' ,`PhotoCount` = '20' ,`PostalCode` = '77377' ,`RoomCount` = '8' ,`ListPrice` = '649000.00' ,`Status` = 'Active' ,`StreetName` = 'Lutheran Church' ,`StreetNumber` = '21947' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2427' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great potential.  Some maintenance and construction is happening, so be careful when you go to view.  This 4 bedroom home has 2.5 baths and large gathering room with open concept to the kitchen and breakfast room.   There is a multi use room that was used as an office.  A 650 foot enclosed building that is perfect for RV, Boat or workshop is at back of property.  This property is unrestricted. professional photos in a few days.' ,`Acres` = '1.5' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Approx 1.5 acres' ,`LotDesciption` = 'Cleared' ,`LotSize` = '65340' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'none' ,`TaxAmount` = '270' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702637' WHERE `Matrix_Unique_ID` = '207893999'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T22:24:19.650' ,`MLSNumber` = '74169058' ,`ListAgentFullName` = 'Danielle Dove' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = 'Katherine Freeman' ,`SellingOfficeName` = 'Keller Williams Professionals' ,`Latitude` = '30.104356' ,`Longitude` = '-95.123225' ,`PhotoCount` = '36' ,`PostalCode` = '77336' ,`RoomCount` = '7' ,`ListPrice` = '498000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Old Field' ,`StreetNumber` = '57' ,`StreetSuffix` = 'Drive' ,`City` = 'Huffman' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1922' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Totally transformed 4 bedroom 2 1/2 bath on 4.4 fully fenced acres! This industrial farmhouse design was started in 2015 and includes: Added on primary suite, den, new roof, new AC in 2015. All electrical, plumbing and panel box replaced. Kitchen remodeled in 2019. Laminate floors 1 year-old, brand-new carpet in bedrooms, replaced windows, well has new pump and tank. Property is unrestricted and includes a chicken coop with its own fenced chicken run. Mature chickens can be included to continue to lay eggs for you. Goats can also stay if so desired. Horse safe fencing and specialty run in shed with added height for livestock. Plenty of room for an arena and round pen should that be needed for your equine activities or business. 34X23 barn could hold a couple stalls. The inside has room for storing a tractor, implements, RV etc. A 26X13 storage shed is also present behind the barn. All appliances and curtains included. Zoned to brand new elementary schools. Make your appointment today!' ,`Acres` = '4.49' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 CYPRESS POINT SEC 2 U/R ABST 1430 J F SMITH' ,`LotDesciption` = 'Cleared' ,`LotSize` = '195613' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'CYPRESS POINT SEC 2 U/R' ,`TaxAmount` = '3039' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702637' WHERE `Matrix_Unique_ID` = '210407119'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T22:32:21.030' ,`MLSNumber` = '72528253' ,`ListAgentFullName` = 'Tamie Hoang' ,`ListOfficeName` = 'Insight Realty Network' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.895747' ,`Longitude` = '-95.518271' ,`PhotoCount` = '34' ,`PostalCode` = '77040' ,`RoomCount` = '9' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Redland Woods' ,`StreetNumber` = '7954' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous single home in a corner lot home site. Stainless steel appliance and granite kitchen countertop. Ceramic tile flooring in wet areas and upgraded laminated woods throughout all bedrooms and flooring. Elegant front porch and covered back patio make this home a Must See.  \r\nYou Must Stop to See this Cute One Story Home' ,`Acres` = '0.1652' ,`Area` = '11' ,`BuilderName` = 'Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 53 BLK 1 TERRACE BROOK SEC 1' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7196' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '454' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Terrace Brook Sec 01' ,`TaxAmount` = '6962' ,`TaxRate` = '2.851' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702637' WHERE `Matrix_Unique_ID` = '210695724'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T23:22:03.830' ,`MLSNumber` = '11599845' ,`ListAgentFullName` = 'Thomas Caine' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.960726' ,`Longitude` = '-95.429542' ,`PhotoCount` = '23' ,`PostalCode` = '77067' ,`RoomCount` = '5' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Ivy' ,`StreetNumber` = '823' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully updated single storied house !!   3 bedrooms and two baths.  New flooring and new stainless steel appliances in kitchen, new faucets and fixtures, fresh paint inside and out, brand new frieze carpet.' ,`Acres` = '0.0724' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 2 NORTHBOROUGH VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3154' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northborough Village Sec 03' ,`TaxAmount` = '4100' ,`TaxRate` = '2.7252' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702638' WHERE `Matrix_Unique_ID` = '211659949'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T23:58:12.633' ,`MLSNumber` = '27748471' ,`ListAgentFullName` = 'Gillus Blanchard' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826928' ,`Longitude` = '-95.091538' ,`PhotoCount` = '11' ,`PostalCode` = '77360' ,`RoomCount` = '8' ,`ListPrice` = '217000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Bud' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath, 1 car, detached garage home, is tucked away in the waterfront community of Yaupon Cove, only a 2\r\nminute drive off of Lake Livingston! Why look any where else? When you enter this beauty, you will be greeted with a spacious\r\nopen concept living room that opens into the dining room, then graduates into the kitchen. Upon entry, you will also notice the\r\nunhindered light pouring into this space from every direction. The kitchen is graced with granite counter tops, tiled back\r\nsplash and ample cabinet space for all of your dishes. The hall bath features a granite singlee vanity, over-the-toilet cabinet\r\nand a full tub and shower combo. The master bath features a double vanity, trimmed with granite counter tops and fitted with\r\ndrawer space for storage. You will be pleased with your new home close to one of the most beautiful lakes in Texas! This\r\nproperty is being offered through TSAHC’s Hero Program.' ,`Acres` = '0.1894' ,`Area` = '44' ,`BuilderName` = 'Homes by Cooper' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'YAUPON COVE BLK 7 LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Cove' ,`TaxAmount` = '127' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702638' WHERE `Matrix_Unique_ID` = '211737832'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T23:50:19.533' ,`MLSNumber` = '61966064' ,`ListAgentFullName` = 'Gillus Blanchard' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.826904' ,`Longitude` = '-95.091621' ,`PhotoCount` = '12' ,`PostalCode` = '77360' ,`RoomCount` = '8' ,`ListPrice` = '217000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Bud' ,`StreetNumber` = '210' ,`StreetSuffix` = 'Lane' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1356' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath, 1 car, detached garage\r\nhome, is tucked away in the waterfront community\r\nof Yaupon Cove, only a 2 minute drive off of Lake\r\nLivingston! Why look any where else? When you enter this beauty, you will be greeted with a spacious\r\nopen concept living room that opens into the dining room, then\r\ngraduates into the kitchen. Upon entry, you will also notice the\r\nunhindered light pouring into this space from every direction. The\r\nkitchen is graced with granite counter tops, tiled back splash and\r\nample cabinet space for all of your dishes. The hall bath features\r\na granite singlee vanity, over-the-toilet cabinet and a full tub and\r\nshower combo. The master bath features a double vanity, trimmed\r\nwith granite counter tops and fitted with drawer space for storage.\r\nYou will be pleased with your new home close to one of the most\r\nbeautiful lakes in Texas! This property is being offered through TSAHC’s Hero Program.' ,`Acres` = '0.1894' ,`Area` = '44' ,`BuilderName` = 'Homes by Cooper' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'YAUPON COVE BLK 7 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Cove' ,`TaxAmount` = '127' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702638' WHERE `Matrix_Unique_ID` = '211738193'  --> Updated record success<br />