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-28T20:49:20.717' ,`MLSNumber` = '23976472' ,`ListAgentFullName` = 'Javier Sepulveda' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.781614' ,`Longitude` = '-95.363202' ,`PhotoCount` = '13' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Freeman' ,`StreetNumber` = '2314' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location, Location !! Location !!!  7mins to downtown, 7mins to Minute Maid Park, 5mins to U of H, 1min walking to the MetroRail stop on Main St and 3 mins to Hwy45 . This property is a grate starter home / investment  with a great view of downtown Houston. With a 500 sq foot 2 bed Apartment. Never flooded .. Lots of potential investment, Airbnb, rentals or to build a half million dollar home near Downtown Houston with out the excess expenses' ,`Acres` = '0.0769' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2C BLK 63-7 ALLEN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3350' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Allen' ,`TaxAmount` = '3397' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704185' WHERE `Matrix_Unique_ID` = '201612197'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T20:10:22.223' ,`MLSNumber` = '10006556' ,`ListAgentFullName` = 'Jennifer Arriaga' ,`ListOfficeName` = 'Daniel Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723585' ,`Longitude` = '-95.587589' ,`PhotoCount` = '35' ,`PostalCode` = '77082' ,`RoomCount` = '10' ,`ListPrice` = '1399000.00' ,`Status` = 'Active' ,`StreetName` = 'Legend Manor' ,`StreetNumber` = '11911' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SHOWINGS will begin Tuesday, July 12th! Fabulous renovated  1 1/2 story home situated on the 11th hole in Royal Oaks Country Club featuring a quaint gated courtyard entrance for extra privacy.  A rare find with all bedrooms downstairs! This home features over 4,100 sq ft on the first floor with multiple living spaces, a gourmet kitchen, large mud and utility area, a gentlemen\'s lounge or office, and two bar areas located on the first and second floors. Second floor includes a spacious gameroom, half bath, bar, and balcony area perfect for entertaining. Newly updated spa-like master bath with a freestanding tub, separate shower, expansive vanity space and separate his and her closets.  Beautifully maintained yard, large back patio, fire pit, and grass area.  Garage is finished out with plenty of storage space and extra room for a golf cart, bikes, etc. Extra-wide driveway space for additional cars. One- story living at its finest. This light, bright and open home will not last long!' ,`Acres` = '0.2466' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 2 ROYAL OAKS COUNTRY CLUB SEC 10' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '10741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3130' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'French,Mediterranean' ,`Subdivision` = 'Royal Oaks Country Club Sec 10' ,`TaxAmount` = '23684' ,`TaxRate` = '2.6086' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704185' WHERE `Matrix_Unique_ID` = '209920002'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T21:57:18.780' ,`MLSNumber` = '73760844' ,`ListAgentFullName` = 'Estelle Elles' ,`ListOfficeName` = 'Bernstein Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759106' ,`Longitude` = '-95.614773' ,`PhotoCount` = '35' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '394500.00' ,`Status` = 'Active' ,`StreetName` = 'Normans Woods' ,`StreetNumber` = '1207' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2146' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in quiet, secluded gated community. Close to hike and bike trails of Terry Hersey Park.  High ceilings in living room, gleaming wood flooring in living / dining room. Gaslog fireplace.  Great kitchen with custom cabinets and special details to make life easier, gas cooktop and stainless appliances.  Wonderful views from breakfast area of outside deck and green space.  The upstairs offers two bedrooms, a gameroom and a spacious main bedroom.  Luxurious bathroom with air bubble tub, separate shower and large closet.  Enjoy the outdoors from the deck.  Located on greenbelt which leads to subdivision lake.' ,`Acres` = '0.0803' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 47 BLK 2 LAKE AT STONEHENGE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1080' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lake At Stonehenge' ,`TaxAmount` = '7181' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704185' WHERE `Matrix_Unique_ID` = '210480596'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T21:08:05.723' ,`MLSNumber` = '53432395' ,`ListAgentFullName` = 'Kim Tyson' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342869' ,`Longitude` = '-95.321515' ,`PhotoCount` = '28' ,`PostalCode` = '77303' ,`RoomCount` = '8' ,`ListPrice` = '178000.00' ,`Status` = 'Active' ,`StreetName` = 'Kingsbury Ct' ,`StreetNumber` = '317' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The inside of this 2021 Clayton Home is a must see sitting on .294 acres.  Super clean open concept 3 bdrm/2 bath split floor plan.    New griege tones throughout with large spacious rooms.  This home is in excellent condition.  The seller recently had a wooden privacy fence built enclosing the back yard with a 12X20 shed.  No back neighbors.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Crockett Trace Estates 11, Block 3, lot 22' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12791' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Trace Estates' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663704185' WHERE `Matrix_Unique_ID` = '211234669'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T20:25:23.550' ,`MLSNumber` = '55693878' ,`ListAgentFullName` = 'Sissy Bellar' ,`ListOfficeName` = 'Keller Williams Arlington' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.310656' ,`Longitude` = '-95.250469' ,`PhotoCount` = '26' ,`PostalCode` = '75707' ,`RoomCount` = '5' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookview' ,`StreetNumber` = '3614' ,`StreetSuffix` = 'Court' ,`City` = 'Tyler' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2691' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful treed lot in a quiet cul-de-sac. You are greeted with a beautiful entry and living space that looks straight back to the impressive pool and outdoor living space. To your right you will find a large master bedroom with a large master bathroom with 2 closet spaces and a separate shower and tub. 2 more bedrooms with a bathroom share this side of the home. To the left is a formal dining room (currently used as an office) plus another living space with fireplace, a large eat in kitchen and the 4th bedroom plus bathroom, laundry room and garage entry. This large house is ready for the next family to call it home. Home is sold as-is.' ,`Acres` = '0.304' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OAK TREE VILLAGE BLOCK 1441-D LOT 6' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '13242' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '258 - Chapel Hill (Smith)' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Tree Village' ,`TaxAmount` = '7578' ,`TaxRate` = '1.9038' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704185' WHERE `Matrix_Unique_ID` = '211916761'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-28T20:48:50.563' ,`MLSNumber` = '15089003' ,`ListAgentFullName` = 'Ibk Eweje' ,`ListOfficeName` = '1st Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676596' ,`Longitude` = '-95.348699' ,`PhotoCount` = '7' ,`PostalCode` = '77033' ,`RoomCount` = '3' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Van Fleet' ,`StreetNumber` = '5002' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom and 1 bathroom house is located in South Houston only minutes from some of the city\'s best food, entertainment and shopping! The perfect investment property that offers great rental opportunity in a neighborhood on the edge of urban revival! This quaint and charming home features new flooring throughout, a new outside A/C unit and a kitchen with brand-new cabinets, counter tops, sink and appliances. Exterior has new fascia and soffit around the roof. New drain line for the laundry room as well as new electrical run through the kitchen. The large covered front porch is the perfect place to relax while watching the sun go down on a warm afternoon. This home is priced to sell! Don\'t miss out on this great opportunity, and come see this home now before it\'s too late!' ,`Acres` = '0.1243' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 23 BLK 4 SOUTH PARK SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '5415' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'South Park Sec 03' ,`TaxAmount` = '2585' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704186' WHERE `Matrix_Unique_ID` = '211920860'  --> Updated record success<br />