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-11-24T20:13:17.237' ,`MLSNumber` = '39760307' ,`ListAgentFullName` = 'Rachele Jones' ,`ListOfficeName` = 'A\'Lon Realty Co.' ,`SellingAgentFullName` = 'Veronica Cisneros' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '29.982794' ,`Longitude` = '-95.399406' ,`PhotoCount` = '30' ,`PostalCode` = '77073' ,`RoomCount` = '5' ,`ListPrice` = '209900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hade Falls' ,`StreetNumber` = '1511' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bedroom, 2 bath brick home is located minutes away from the Hardy Toll, Beltway 8, Bush Airport and 45 North freeway.  Recent updates include a new 30 year composition roof, water heater, new carpet, recently installed flooring in the bathrooms and freshly painted rooms. This home has an attached 2 car garage with a garage opener, wired for satellite TV and alarm system. This property also includes a stainless steel stove and refrigerator.  THIS IS A MUST SEE!! SELLER IS MOTIVATED TO SALE.' ,`Acres` = '0.1056' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 BLK 1 MEADOWVIEW FARMS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadowview Farms Sec 02' ,`TaxAmount` = '3957' ,`TaxRate` = '2.8445' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642154' WHERE `Matrix_Unique_ID` = '209561346'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:34:54.603' ,`MLSNumber` = '48730970' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904564' ,`Longitude` = '-95.368270' ,`PhotoCount` = '7' ,`PostalCode` = '77039' ,`RoomCount` = '6' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Reeveston' ,`StreetNumber` = '13119' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1353' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your very own 1 acre lot, just walking distance from Aldine Mail Rte Rd and around the corner from Hardy Toll Rd. This property is unrestricted and can also be used for commercial use.' ,`Acres` = '1' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 75B ALDINE GARDENS SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'GRANTHAM ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Aldine Gardens' ,`TaxAmount` = '3558' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642154' WHERE `Matrix_Unique_ID` = '209809596'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:13:34.567' ,`MLSNumber` = '73299451' ,`ListAgentFullName` = 'Luis Salazar' ,`ListOfficeName` = 'Jane Byrd Properties INTL.' ,`SellingAgentFullName` = 'Lacey Godwin' ,`SellingOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`Latitude` = '29.935451' ,`Longitude` = '-94.846037' ,`PhotoCount` = '48' ,`PostalCode` = '77535' ,`RoomCount` = '3' ,`ListPrice` = '214999.00' ,`Status` = 'Option Pending' ,`StreetName` = 'County Road 440' ,`StreetNumber` = '553' ,`StreetSuffix` = '' ,`City` = 'Dayton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '1.342' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'THE RANCH, SEC 3, LOT 114, ACRES 1.342, MH LABEL# PFS0818857' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '58458' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'KIMMIE M. BROWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'The Ranch, Sec 3' ,`TaxAmount` = '2431' ,`TaxRate` = '1.7507' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642155' WHERE `Matrix_Unique_ID` = '211588639'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:28:23.990' ,`MLSNumber` = '32226053' ,`ListAgentFullName` = 'Joshua Want' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.097270' ,`Longitude` = '-95.399404' ,`PhotoCount` = '34' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Maddie Springs' ,`StreetNumber` = '1710' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1.5 story home sits on a beautiful corner lot in Spring Trails and boasts many updates, including: Upgraded LED recessed lights, LED under/above cabinet lighting, modern ceiling fans, a Honeywell zone system w/WiFi thermostats, fresh paint and new carpet. Seller will also include allowances for living room floor & counter top upgrades for the new owner.\r\n\r\nThe LARGE kitchen opens to the living room w/10\' ceilings throughout, and a true dining room up front with space for a large table -- a RARE find! The primary bedroom and ensuite bathroom are located on the main level, and the spacious master closet connects directly to the laundry room making laundry a breeze. Three additional bedrooms are also located on the first level. An additional room has been finished upstairs which was previously used as a fifth bedroom, and is connected to the large game room; a MUST see!' ,`Acres` = '0.1779' ,`Area` = '40' ,`BuilderName` = 'Darling Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SPRING TRAILS 05, BLOCK 2, LOT 64' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7748' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BROADWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Trails' ,`TaxAmount` = '6594' ,`TaxRate` = '2.6137' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642155' WHERE `Matrix_Unique_ID` = '211946213'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:09:02.607' ,`MLSNumber` = '91736383' ,`ListAgentFullName` = 'James Green' ,`ListOfficeName` = 'Green & Associates Real Estate' ,`SellingAgentFullName` = 'Cheryl Gaskins' ,`SellingOfficeName` = 'Integrity Home & RanchProperties' ,`Latitude` = '30.366556' ,`Longitude` = '-95.669815' ,`PhotoCount` = '23' ,`PostalCode` = '77316' ,`RoomCount` = '6' ,`ListPrice` = '315000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sandstone Hills' ,`StreetNumber` = '1266' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well taken care of house in Fairwater, close to Lake Creek High School in Montgomery!    Nice flooring in all living areas and with carpet in the bedrooms.   The kitchen has granite counter tops with a nice sized island with a breakfast bar.   Open to the breakfast/dining area and living room, you can make sure the biscuits are not burning while watching morning cartoons.   Spacious master bedroom, master bath has double sinks, walk in shower and separate tub, and a large walk-in closet.   The spare bedrooms are nice and have a shared bath between the rooms, there is a 1/2 bath located by the laundry room, leading to the garage.  Nice, fenced back yard with no back neighbors.   This neighborhood offers a splash pad and other recreational activities for the family.' ,`Acres` = '0.1559' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S503203 - FAIRWATER 03, BLOCK 4, LOT 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6793' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'KEENAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairwater 03' ,`TaxAmount` = '3210' ,`TaxRate` = '1.8242' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642155' WHERE `Matrix_Unique_ID` = '211948812'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:56:22.080' ,`MLSNumber` = '98541931' ,`ListAgentFullName` = 'Marlana Mack' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.804420' ,`Longitude` = '-97.601701' ,`PhotoCount` = '25' ,`PostalCode` = '76537' ,`RoomCount` = '5' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Ibis Falls' ,`StreetNumber` = '1001' ,`StreetSuffix` = 'Loop' ,`City` = 'Jarrell' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2121' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful DR Horton home is located in 9th fastest growing masterplan community in the nation. Move to Sonterra West before everyone else does! Even though this gorgeous home is only 2 years old, the original owners have already added upgrades to make it stand out from others. The open floor plan, new full gutters, new gazebo, extended patio area and sand pit make it perfect for entertaining or peaceful areas to unwind. With many still working from home, the office space is located at the front of the home with natural lighting. Separate from the office space is the den which is currently used as a man cave/game room. Come see this gem before it’s gone!' ,`Acres` = '0.1495' ,`Area` = '83' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S11990 - SONTERRA WEST SEC 12 PH 2, BLOCK A, LOT 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6513' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '187 - Jarrell' ,`SchoolElementary` = 'JARRELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JARRELL HIGH SCHOOL' ,`SchoolMiddle` = 'JARRELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sonterra West' ,`TaxAmount` = '7217' ,`TaxRate` = '2.8476' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642155' WHERE `Matrix_Unique_ID` = '212198588'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:26:35.280' ,`MLSNumber` = '20006735' ,`ListAgentFullName` = 'David Gutierrez' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.108471' ,`Longitude` = '-95.096752' ,`PhotoCount` = '42' ,`PostalCode` = '77554' ,`RoomCount` = '6' ,`ListPrice` = '699999.00' ,`Status` = 'Active' ,`StreetName` = 'Bay Breeze' ,`StreetNumber` = '25818' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1859' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxurious New Construction Home in highly sought-after Pointe West community. Home is still under construction with a targeted completion date of 12/20/2022. Home features an open concept living, dining, and kitchen space.  Perfect for entertaining. Primary bedroom is located on the first floor. Loft space is a perfect area for bunk beds. Two additional bedrooms are on the second floor along with an additional bath. Community feature a lazy river pool, club house with an infinite pool, fitness center, grilling areas, cabanas, game room, fishing piers, wading areas, and a restaurant and bar. Pointe West is the premier community in Galveston with the best beaches on Galveston Island.  Proven Vacation Rental income area. Seller has 2 additional lots available to build your dream vacation home.' ,`Acres` = '0.2199' ,`Area` = '33' ,`BuilderName` = 'McDaniel Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINTE WEST SEC 3-C PH 2 (2009) ABST 121, BLOCK 1, LOT 8, AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '9578' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pointe West Sec 3-C Ph 22009' ,`TaxAmount` = '526' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669642155' WHERE `Matrix_Unique_ID` = '212557136'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T20:08:54.120' ,`MLSNumber` = '29842982' ,`ListAgentFullName` = 'Sharon Womack-Asp' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Cindi Rickman' ,`SellingOfficeName` = 'ROCK REALTY' ,`Latitude` = '29.987728' ,`Longitude` = '-95.155884' ,`PhotoCount` = '32' ,`PostalCode` = '77346' ,`RoomCount` = '10' ,`ListPrice` = '367900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sports Haven' ,`StreetNumber` = '8007' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM BUILT HOME BY MICHAEL HOLIGAN WITH DRAMATIC ENTRY AND STAIRCASE. LARGE FAMILY HOME IN A GREAT NEIGHBORHOOD. 4 BEDROOMS/3 ½ BATHS/LARGE MEDIA/ FAMILY/GAMEROOM UPSTAIRS. DOWNSTAIRS OFFICE OR LIVING ROOM, FORMAL DINING/OPEN FAMILY ROOM WITH HIGH CEILINGS/GAS FIREPLACE WITH FLOOR TO CEILING BRICK. NICE CHANDELIERS/FANS.  KITCHEN WITH BLACK GRANITE COUNTERS/FARM SINK/GAS STOVE/WHITE GLASS BACK-SPLASH/PLATE RACKS/PENDANT LIGHTS/WHITE WOOD PLANKED CEILINGS/BREAKFAST NOOK/WOOD/TILE FLOORS DOWNSTAIRS. PRIMARY BEDROOM WITH TRAY CEILING/BATH WITH 2 SINKS/JACUZZI TUB/SEPARATE SHOWER/PLUS LARGE CLOSET AND BUILT IN DRAWER STORAGE. 4TH BEDROOM COULD BE CONVERTED INTO A MEDIA ROOM. CARPET /TILE UPSTAIRS. LARGE FENCED BACKYARD. BRAND NEW HVAC UNIT FOR UPSTAIRS. LOTS OF EXTRA STORAGE/LINEN CLOSETS.' ,`Acres` = '0.1652' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 27 SPORTSMAN VILLAGE AMEND WALDEN ON LAKE HOUSTON' ,`LotDesciption` = 'Greenbelt,In Golf Course Community' ,`LotSize` = '7198' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'MAPLEBROOK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'ATASCOCITA MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden On Lake Houston Ph 03' ,`TaxAmount` = '8081' ,`TaxRate` = '2.5885' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642156' WHERE `Matrix_Unique_ID` = '212769812'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:24:09.313' ,`MLSNumber` = '54651631' ,`ListAgentFullName` = 'Maggie Pearson' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.396544' ,`Longitude` = '-94.909597' ,`PhotoCount` = '36' ,`PostalCode` = '77590' ,`RoomCount` = '5' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = '11th' ,`StreetNumber` = '1200' ,`StreetSuffix` = 'Street' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '969' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable home in the heart of Texas City. 2 Bedrooms and 2 full bathrooms in the home PLUS a Guest house behind the home with a large room, half bathroom, and washer/dryer connections. This extra room would make an excellent guest house, man cave or rental income! Large yard with a private patio, chain link fence all the way around the property! Covered front porch and freshly painted inside. Luxury Vinyl flooring throughout, gorgeous primary bathroom with walk in closet, granite countertops in the kitchen and refrigerator stays with the home! Make an appointment to see today!!' ,`Acres` = '0.1477' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 205 PAGE 5 LOT 143 SNUG HARBOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'ROOSEVELT-WILSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Snug Harbor' ,`TaxAmount` = '2347' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642156' WHERE `Matrix_Unique_ID` = '213894745'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:31:30.717' ,`MLSNumber` = '71641883' ,`ListAgentFullName` = 'Toan Nguyen' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677322' ,`Longitude` = '-95.619948' ,`PhotoCount` = '16' ,`PostalCode` = '77083' ,`RoomCount` = '12' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Castle Way' ,`StreetNumber` = '13415' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated single family residence in a subdivision that is rarely available. Large porcelain tile flooring for easy cleaning and warm luxury laminate wood floors in bedrooms. Modern frameless master bath standing shower and jet tub. Designer wall tile in the hall bath with brush nickel fixtures. New stain hardwood stairs for an easy climb up to a upstair sitting area for the family to view a beautiful scenic backyard. Do not miss this opportunity to a quiet and friendly neighborhood and close access to most major convenience shop and food eatery. Hoa is strict to maintain subdivision but flexible to homeowner desire.' ,`Acres` = '0.1178' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 3 KINGSVILLE PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsville Park' ,`TaxAmount` = '4744' ,`TaxRate` = '2.753' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642156' WHERE `Matrix_Unique_ID` = '214135448'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:19:27.680' ,`MLSNumber` = '7190618' ,`ListAgentFullName` = 'Kendall Niles' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Laura Cooper' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '28.989644' ,`Longitude` = '-95.940448' ,`PhotoCount` = '18' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '159900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Crescent' ,`StreetNumber` = '4024' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1418' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom 2 bath home with formal room off entry.  Solid home with side garage & drive on a corner lot.  Great quiet, established neighborhood to start/raise a family or retire in.  Solid wood cabinetry and breakfast bar.' ,`Acres` = '0.233' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BIRKNER ANNEX #2, BLOCK 3, LOT 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '10150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Birkner Annex #2' ,`TaxAmount` = '3193' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642156' WHERE `Matrix_Unique_ID` = '214171531'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:34:18.007' ,`MLSNumber` = '77844655' ,`ListAgentFullName` = 'Cindy Beltran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.240119' ,`Longitude` = '-95.313416' ,`PhotoCount` = '22' ,`PostalCode` = '77302' ,`RoomCount` = '7' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Rich Pines' ,`StreetNumber` = '16937' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to fantastic DR Horton home in the beautiful Granger Pines community! Wonderful floor plan with island kitchen! Modern finishes, espresso cabinetry in the kitchen and so much more!  Also features a home automation system! Landscape package with useful covered back patio! Neighborhood includes an 11-acre community park, with a splash pad, 6-acre lake, pocket parks, trails, pavilion and more! Along with preserved open space, natural creeks, walking trails and green space! Schedule your appointment today!' ,`Acres` = '0.1626' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539500 - GRANGER PINES 01, BLOCK 1, LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7085' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Granger Pines 01' ,`TaxAmount` = '3777' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642157' WHERE `Matrix_Unique_ID` = '214439977'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:42:26.523' ,`MLSNumber` = '47971759' ,`ListAgentFullName` = 'Trung Nguyen' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583060' ,`Longitude` = '-95.196488' ,`PhotoCount` = '37' ,`PostalCode` = '77089' ,`RoomCount` = '7' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Field Brook' ,`StreetNumber` = '12302' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home at the corner lot. Open floor plan, kitchen with huge island opening to family area. Tall 42\" Cherry Raised Panel Cabinets, Granite Counter Top, Marble Backflash, and Stainless Appliances in the Kitchen. Modern and beautiful Cobblestone Design Tile Flooring. Windows covered with Plantation Shutters, Solar Screens, which provide Energy Efficiency. Study Area. Larger Family room. Great Location. Close to Jacinto JR Collegen and Clear Creek ISD.' ,`Acres` = '0.13' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 COLLEGE PLACE SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '5662' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'NORTH POINTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'WESTBROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'College Place' ,`TaxAmount` = '6506' ,`TaxRate` = '2.6399' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642157' WHERE `Matrix_Unique_ID` = '214796462'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T19:57:42.153' ,`MLSNumber` = '90431613' ,`ListAgentFullName` = 'Priscilla Pompey' ,`ListOfficeName` = 'PHP & Associates, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.618589' ,`Longitude` = '-95.406079' ,`PhotoCount` = '2' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Bell' ,`StreetNumber` = '13106' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story home located on a cul-de-sac  lot with 3 bedrooms 2 full baths plus 1/2 bath down stairs and a game room upstairs.  House needs minor upgrade.  Kitchen has sile stone countertops and entire house is equipped with faux wooden blinds.' ,`Acres` = '0.1229' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 79 BLK 2 REGAL OAKS SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Regal Oaks Sec 05' ,`TaxAmount` = '5800' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642157' WHERE `Matrix_Unique_ID` = '214920757'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215048349','1669642157','215048349','2022-11-24T20:09:34.647','29434878','Priscilla Raji','Summit Realty','','','29.739317','-95.882898','27','77494','7','389990.00','Active','Windham','3403','Way','Katy','3','0','4','2199','Single-Family','New beautiful 4 bed room, 3 full bath, with an open kitchen concept and nice tile flooring on the first floor, carpet on the stair way, and in all bed rooms. Master bedroom and guest suite with full bath on the first floor, along with 2 bedrooms upstairs with full bath as well. Located in a planned community of Tamarron. Tenants occupied.','0.1402','30','DR HORTON','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Katy - Southwest','Central Electric','1','TAMARRON SEC 53, BLOCK 4, LOT 53','Cul-De-Sac','6106','Appraisal District','','1100','0','','2','Gas Oven','0','','','Gas Range','','Composition','33 - Lamar Consolidated','TAMARRON ELEMENTARY SCHOOL','FULSHEAR HIGH SCHOOL','ROBERTS/LEAMAN JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Tamarron Sec 53','10983','3.0648','Public Sewer,Public Water,Water District','2020','Builder');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215079176','1669642157','215079176','2022-11-24T20:32:39.293','21262482','Ellis Young','CB&A, Realtors- Southeast','','','29.788769','-95.580387','23','77043','7','409999.00','Active','Sherwood Forest Glen','11127','Drive','Houston','3','1','4','2307','Single-Family','Holy Smokes!!!! Welcome home!!! This Beautiful gated Sherwood Forest Glen home with a striking stone and stucco elevation. Beautiful hardwood floors and eloquent crown molding greet you as you enter into the main floor living spaces that include a spacious living room and dining area. The kitchen features stainless appliances, granite countertops, tile backsplash and pantry. The 2nd floor reveals 3 bedrooms including the primary suite with double closets, a Juliette balcony and stylish ensuite bath. The 3rd floor opens into a 4th bedroom suite with full bath and closet that could also serve as a great media room or game room. Wonderful central location close to I10, Beltway 8, the Energy Corridor, City Center and great schools! Gate code is 1995!!!!!','0.0415','24','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Spring Branch','Central Gas','1','LT 18 BLK 1 SHERWOOD FOREST GLEN','Subdivision Lot','1806','Appraisal District','','2400','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','49 - Spring Branch','SHERWOOD ELEMENTARY SCHOOL','STRATFORD HIGH SCHOOL (SPRING BRANCH)','SPRING FOREST MIDDLE SCHOOL','Appointment Required','Appraisal District','3','Split Level,Traditional','Sherwood Forest Glen','8295','2.4415','Public Sewer,Public Water','2004','Appraisal District');  --> New record created successfully<br />