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-27T19:28:12.720' ,`MLSNumber` = '6777104' ,`ListAgentFullName` = 'Dorothy Arnaud' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.792911' ,`Longitude` = '-95.584195' ,`PhotoCount` = '32' ,`PostalCode` = '77043' ,`RoomCount` = '12' ,`ListPrice` = '382000.00' ,`Status` = 'Active' ,`StreetName` = 'Scenic Ridge Drive' ,`StreetNumber` = '1439' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2574' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '***********BUYER CHANGED THEIR MIND**********THIS ONE HAS IT ALL NEW ROOF 3 YEARS OLD, 2 MINI-SPLIT AIR CONDITIONERS GREAT FOR KEEPING MASTER BEDROOM EXTRA COOL ON HOT SUMMER NIGHTS,***TANKLESS WATER HEATER***DOUBLE PANE WINDOWS, FOR LOW ELECTRIC BILLS,COVERED PATIO FOR ENTERTAINING,WORKSHOP FOR THE HANDYMAN, NO NEIGHBORS IN THE BACK. FORMAL LIVING AND DINING WITH BAY WINDOW ,OVERSIZED FAMILY ROOM WITH CUSTOM BUILT INS. NEIGHBORHOOD CONVENIENT TO MAJOR HIGHWAYS ,SHOPPING AND MEDICAL HOSPITALS, WONDERFUL SPRING BRANCH SCHOOLS **NEW CARPET IN MOTHER-IN LAW QUARTERS \r\n******* PRICE REDUCTION DON\'T MISS THIS OPPORTUNITY ********' ,`Acres` = '0.2066' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 4 SHERWOOD OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '671' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sherwood Oaks' ,`TaxAmount` = '8042' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703778' WHERE `Matrix_Unique_ID` = '206949637'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T19:39:35.573' ,`MLSNumber` = '64096716' ,`ListAgentFullName` = 'Faye Ausmus' ,`ListOfficeName` = 'Ausmus Premier Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.546593' ,`Longitude` = '-95.417398' ,`PhotoCount` = '40' ,`PostalCode` = '77583' ,`RoomCount` = '8' ,`ListPrice` = '2000000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 48' ,`StreetNumber` = '2750' ,`StreetSuffix` = '' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy country living in this stunning, 4,000 sq. ft home on 9.5 acres! Beautiful marble tiles throughout the 1st floor & new carpet on the 2nd. Home features 2 sets of staircases, 2 wood burning fire places, coffered ceilings in bedrooms, 3 zoned HVAC, 4 car garage, 4 large size bedrooms, each with their own bathroom & walk-in closets! Property also includes a 2 story guest quarters on the front lawn with a 2 car garage (lease for additional income or reserve for guest!). The grounds boast green grasses, a fishing pond, & 2 wells. No restrictions. Bring your family, your horses, use the expansive acreage to build another home or an office to walk to work! 2 Miles to Pearland Town Center, verity of Restaurants nearby, Medical facilities within 2-3 Miles While Houston Medical Center is a short commute!\r\nMake your appointment to see. So many possibilities with this unique property!' ,`Acres` = '9.5667' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0538 H T & B R R BLOCK 12 TRACT 13 (SD TR 11-12) ACRES 9.56' ,`LotDesciption` = 'Cleared' ,`LotSize` = '416725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'RED DUKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MCNAIR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '19603' ,`TaxRate` = '2.2194' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703778' WHERE `Matrix_Unique_ID` = '208562502'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T19:03:25.490' ,`MLSNumber` = '13545585' ,`ListAgentFullName` = 'Eric Thomson' ,`ListOfficeName` = 'Crossvine Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462253' ,`Longitude` = '-94.647883' ,`PhotoCount` = '20' ,`PostalCode` = '77650' ,`RoomCount` = '2' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Monkhouse' ,`StreetNumber` = '1208' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1203' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 2 bedroom home sits on two lots with lots of space. Canal behind home is perfect for crabbing! Luxury vinyl plank flooring throughout, beautiful quartz countertops, RV electrical hookup, and loads of charm. Experience the best of both worlds with views of the Intercoastal Canal, but also a short drive to the beach (Monkhouse Dr has beach access). Home comes fully furnished, ready to be rented out, for weekend getaways, or permanent change of scenery. Large enclosed storage area below to house all your beach toys or tools.' ,`Acres` = '0.2806' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOTS 112 & 114 (114-0) INTRACOASTAL CANA' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '12225' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Intercoastal Canal Add' ,`TaxAmount` = '1817' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '210286438'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T18:22:21.607' ,`MLSNumber` = '20095041' ,`ListAgentFullName` = 'Terin Varghese' ,`ListOfficeName` = 'XAG Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644748' ,`Longitude` = '-95.352203' ,`PhotoCount` = '32' ,`PostalCode` = '77048' ,`RoomCount` = '4' ,`ListPrice` = '238900.00' ,`Status` = 'Active' ,`StreetName` = 'Richfield' ,`StreetNumber` = '4910' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1719' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this fully renovated home. This home features a Full 4 Bedrooms with 2 Full Bath close to the South of Medical Center. BRAND NEW 30 YEAR ROOF, NEW PAINT, 2 Year old 4 Ton AC, Water Heater replaced, plumbing upgraded, Full Mater suite with Full Bath with his & her sinks with lots of storage, Primary shower with custom tile with black accent shower heads and matching trims. This home boasts lots of natural lights throughout the home with Double Pane Windows. No carpets anywhere and only hardwood flooring and tiles everywhere. Granite countertops in kitchen with matching backsplash and lots of cabinet space,  Stainless Steel Gas Range, Microwave and Dishwasher and very spacious for a family gathering cook off. Driveway built recently, LED Lights throughout the home and fans in all rooms. The utility room is extremely spacious with a custom table for all your ironing and folding needs. Call for your very own Private Tour of this gorgeous home!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 10 SOUTH ACRES ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Acres Estates Sec 02' ,`TaxAmount` = '1944' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '210289121'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T18:24:21.257' ,`MLSNumber` = '80505723' ,`ListAgentFullName` = 'Khawaja Mansoor' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Khawaja Mansoor' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.756332' ,`Longitude` = '-95.749417' ,`PhotoCount` = '20' ,`PostalCode` = '77450' ,`RoomCount` = '6' ,`ListPrice` = '324000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Mill Crossing' ,`StreetNumber` = '1722' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2054' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 3 bedroom plus flex room, Single story home. Tenant occupied . Great school. Tenant is on month to month lease. They love to stay if possible for investor.\r\ncall your agent\r\nNever flooded.\r\nMotivated seller\r\nBack on Market' ,`Acres` = '0.1515' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 1 OAK PARK TRAILS SEC 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'EXLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MCMEANS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Park Trails Sec 08' ,`TaxAmount` = '5303' ,`TaxRate` = '2.4133' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '210896495'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T18:36:42.640' ,`MLSNumber` = '92778282' ,`ListAgentFullName` = 'Sue Crow' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.979012' ,`Longitude` = '-95.967823' ,`PhotoCount` = '36' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '2420' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HISTORIC HOME near downtown, lovingly restored. Enter the foyer which opens to cozy study or office area with fireplace and lots of windows and Beautiful Living room with large east windows. Formal Dining Room with fireplace, which will hold all your family and friends.  Master Bedroom and Bath are amplle in size and quite a private space.  Kitchen is mostly original, but has had some love over the years.  Further back is Laundry room, lots of storage and a sitting room, or small private office or reading room, which could also be 5th Bedroom if you have a need for that.  Upstairs is large landing area, porches front and back, 3 bedrooms, 2 with fireplaces and featuring center cut pine flooring.  Beautiful views from the porches up here.  Separate guest or maid quarters with living room, kitchen, one bedroom and full bath.  List of amenities are available upon request.  Call for your private tour.' ,`Acres` = '0.3213' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '5' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BAY CITY ORIGINAL TOWNSITE, BLOCK 109, LOT 11-12' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '13996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '8011' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1896' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '211264103'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T19:40:58.033' ,`MLSNumber` = '53931357' ,`ListAgentFullName` = 'Christian Rodriguez' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683992' ,`Longitude` = '-95.190570' ,`PhotoCount` = '21' ,`PostalCode` = '77502' ,`RoomCount` = '4' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Claremont' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1634' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home, Features 4 bedrooms, 2 Baths. Original hard wood floors thru out, Plus ceramic tile recently installed.  Short walk to corner stores, Schools, Fast food restaurants. Updates include A/C system, Kitchen cabinets and quartz counter tops , Water heater, Main sewer lines coming from restrooms, kitchen and laundry all installed. Home needs some TLC, Waiting on your final touches.. Schedule showing today!' ,`Acres` = '0.1882' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 29 BLK 6 STADIUM ESTATES SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MAE SMYTHE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stadium Estates Sec 01 R/P' ,`TaxAmount` = '3569' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '211315100'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T19:40:34.023' ,`MLSNumber` = '86400218' ,`ListAgentFullName` = 'Anne Park' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697192' ,`Longitude` = '-95.461014' ,`PhotoCount` = '30' ,`PostalCode` = '77401' ,`RoomCount` = '9' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Welford' ,`StreetNumber` = '4710' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellaire' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2959' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*NEVER FLOODED* Location Location! Welcome to this two story Bellaire 4 bedroom 3.5 bathroom with a pergola and pool. First floor primary bedroom with ensuite bath, formal dining, study/library. Recent improvements include: Adding secondary windows throughout the entire house for better insulation, Resurfacing and rebuilt motors for the pool (2020), new roof (2021), new water heater (2019), new Heaters (2021), HVAC replaced (2017-2018). Recently installed Automatic Driveway gate.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Bellaire Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 Bellview' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CONDIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bellview' ,`TaxAmount` = '13624' ,`TaxRate` = '2.3' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703779' WHERE `Matrix_Unique_ID` = '211827633'  --> Updated record success<br />