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-25T07:51:49.427' ,`MLSNumber` = '84351034' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '6.100832' ,`Longitude` = '-75.418329' ,`PhotoCount` = '6' ,`PostalCode` = '00000' ,`RoomCount` = '4' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'El Callejon' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Other' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect agricultural land or site for condominium development. Located close to Medellin in Columbia in vicinity of the airport.' ,`Acres` = '' ,`Area` = '' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'M.I. 001-70598,M.I. 001-70599,M.I. 001-70600,M.I001-26302' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '2281949' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tierra Alta' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702762' WHERE `Matrix_Unique_ID` = '206222112'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T06:05:17.570' ,`MLSNumber` = '3838578' ,`ListAgentFullName` = 'Carolyn Evans' ,`ListOfficeName` = 'G. K. Coleman & Son Realty    ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733794' ,`Longitude` = '-95.363229' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '0' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak Street' ,`StreetNumber` = '3108' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '964' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Old wood frame home with central air and heat. Nice hardwood floors. Close to the freeways and newly renovated Emancipation Park.  New development throughout the area. Great opportunity for investor to build 3 or 4 condos in a great location.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Real Estate Owned,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK B DUMBLE MARY' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dumble Mary' ,`TaxAmount` = '3162' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702762' WHERE `Matrix_Unique_ID` = '208138755'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T07:18:47.730' ,`MLSNumber` = '57666130' ,`ListAgentFullName` = 'Margaret Blanchard' ,`ListOfficeName` = 'Benevides & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.617793' ,`Longitude` = '-95.634916' ,`PhotoCount` = '35' ,`PostalCode` = '77478' ,`RoomCount` = '9' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'BROOKS' ,`StreetNumber` = '207' ,`StreetSuffix` = 'Street' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1970' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect time to own a home in Sugar Land\'s historic Belknap neighborhood. This 1953 home has original character w/ plenty of updates. The family/dining room features wood flooring & fireplace. The open concept is great for entertaining. Updated kitchen w/new light fixtures, quartz counters & Bosch appliances. Breakfast rm could be used as an additional sitting area, office or for a more private dining room.  You are going to love the addition of the Master bedroom & en suite. There are two additional generous sized bedrooms w/large closets. Secondary bath & half bath have original tile for that charming cottage feel! Fourth room could be used as an office, nursery, playroom. No carpet! Glass door knobs. Large lot w/fenced in back yard! Private access to master BR. Two car detached garage with workshop! Did we talk about LOCATION?!!  Close to everything~ Highway 6,90 and 69, restaurants, shopping, Imperial Farmers Market, Constellation Field and Smart Financial Centre!' ,`Acres` = '0.2554' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BELKNAP S/D SEC 1, BLOCK 1, LOT 2, ACRES 0.258' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '20' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Belknap Sub' ,`TaxAmount` = '6309' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1953' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702762' WHERE `Matrix_Unique_ID` = '208727288'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T06:39:05.460' ,`MLSNumber` = '71378710' ,`ListAgentFullName` = 'Heather Lott' ,`ListOfficeName` = 'The Cox Company Real Estate Gr' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473109' ,`Longitude` = '-94.593774' ,`PhotoCount` = '22' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'S Cove' ,`StreetNumber` = '975' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful new construction 3/2 home was completed on 07/02/2022. It boasts an open floor plan and offers easy beach access directly down Cove Drive. The spacious kitchen with breakfast nook overlooking your living area make it easy to entertain. The home has quartz countertops, under-cabinet lighting, and soft close drawers and cabinets throughout. Check out the view of the Gulf from the front deck! You will love the en-suite, walk in closet, and a spacious private balcony off the primary bedroom. Primary bath has a custom tile shower and is finished with a frameless shower glass. Downstairs you’ll find a 1 car garage as well as an outdoor shower and plenty of extra covered parking for your boat and golf cart.  This home would make a great family getaway or rental home. Close to Stingaree Restaurant. Don\'t miss seeing this one, call today!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = 'Capstone Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 11 LOT 14 BLK 4 STINGAREE COVE ADDN' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stingaree Cove' ,`TaxAmount` = '333' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702762' WHERE `Matrix_Unique_ID` = '209812218'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T06:07:22.817' ,`MLSNumber` = '35411908' ,`ListAgentFullName` = 'Cesar Espinoza' ,`ListOfficeName` = 'Equity Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.806069' ,`Longitude` = '-95.499612' ,`PhotoCount` = '48' ,`PostalCode` = '77055' ,`RoomCount` = '9' ,`ListPrice` = '399800.00' ,`Status` = 'Active' ,`StreetName` = 'Westcrest' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2184' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Completely updated home in with all the \"bells and whistles\". Exterior renovations feature a new raised pitch roof, stone and stucco exterior, and new windows. The interior features a totally remodeled spacious kitchen that opens up to the living & dining room areas, making this a perfect space for entertaining. The elegant kitchen features new cabinets, granite countertops, and new appliances.  Additional updates include new electrical wiring throughout the home, along with a new electrical box. Additional updates include updated plumbing and new HVAC.  All bathrooms have been updated with high-end finishes. The spacious interior also features a study and 2 living rooms and refinished original hardwood floors. Too many upgrades to mention!! There is also a detached building that can be used as a workshop or studio. Close to the premier shopping center at Memorial City and top-ranked restaurants and nightlife at CityCentre. ( Buyer to verify all dimensions and measurements )' ,`Acres` = '0.2009' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S 25 FT LT 1O5 & N 45 FT LT 1O6 BLK 6 RIDGECREST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RIDGECREST ELEMENTARY SCHOOL (SPRING BRANCH)' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgecrest Sec 02' ,`TaxAmount` = '8994' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702763' WHERE `Matrix_Unique_ID` = '210577964'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T07:25:07.670' ,`MLSNumber` = '10197444' ,`ListAgentFullName` = 'James Dolson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.601037' ,`Longitude` = '-94.941380' ,`PhotoCount` = '17' ,`PostalCode` = '77335' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2665' ,`StreetNumber` = '752' ,`StreetSuffix` = '' ,`City` = 'Goodrich' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 bath house that sits on 5.84 acres. Home has a water well, was recently painted inside and outside, new carpet in bedrooms and new flooring in the bathrooms. Kitchen was just updated with new granite countertops in the kitchen. Room sizes are approximate, please verify. Showings are by appointment only. Please give at least one hour notice.' ,`Acres` = '5.84' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 77 AUGUSTIN VIESCA SURVEY TRACT 413' ,`LotDesciption` = 'Other' ,`LotSize` = '254390' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '138 - Goodrich' ,`SchoolElementary` = 'GOODRICH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOODRICH HIGH SCHOOL' ,`SchoolMiddle` = 'GOODRICH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2714' ,`TaxRate` = '1.7032' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702763' WHERE `Matrix_Unique_ID` = '210982531'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-25T07:37:46.430' ,`MLSNumber` = '85451844' ,`ListAgentFullName` = 'Trisha Cranney' ,`ListOfficeName` = 'Anne Vickery & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.193888' ,`Longitude` = '-95.248587' ,`PhotoCount` = '9' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '99500.00' ,`Status` = 'Active' ,`StreetName` = 'Lost Lake' ,`StreetNumber` = '20890' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '792' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investor Opportunity! Adorable 1 Bedroom 1 Bath surrounded by large beautiful trees in country like setting with beautiful shade trees. Once a detached garage, the home offers large living room, Open kitchen with spacious breakfast bar, full bathroom with walk in shower, washer and dryer connections in utility closet. Property has a private water well and septic, Main house is handyman\'s dream ready to be torn down to make room for a larger main home (Manufactured homes welcome) Easy access to FM 1485, Centrally located between Hwy 242 & Hwy 59. Minutes from Grand Texas Theme Park, Valley Ranch, Gene Campbell Industrial Park and Hwy 99 (Grand Pkwy).' ,`Acres` = '0.62' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0420 PREWETT BEASLEY, TRACT 79, ACRES 0.620' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '27007' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'MILAM ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Other' ,`TaxAmount` = '1182' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702763' WHERE `Matrix_Unique_ID` = '211534339'  --> Updated record success<br />