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-26T23:09:33.267' ,`MLSNumber` = '52643547' ,`ListAgentFullName` = 'Debra Spurr' ,`ListOfficeName` = 'Grace Team Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498971' ,`Longitude` = '-94.992512' ,`PhotoCount` = '20' ,`PostalCode` = '77518' ,`RoomCount` = '5' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue D' ,`StreetNumber` = '1901' ,`StreetSuffix` = '' ,`City` = 'Bacliff' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '4650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FOR LEASE OR SALE! Great remodeled living quarters and warehouse/GREAT POTENTIAL INCOME PRODUCING PROPERTY!  You won\'t want to miss this property on a corner lot in Bacliff.  This property sets just off of Hwy. 146 and just blocks away from Galveston Bay. Property consists of a two bedroom, two bath, living room and kitchen upstairs apartment, with an expansive income producing warehouse/workshop, and RV/Boat storage. This multipurpose property could also be built out as a large, lovely barndominium. The workshop has one set of sliding garage doors and one large roller door, two lofts, one office, laundry room and bathroom, car/boat lift. **ROOF REPLACED/2022; DOUBLE PANED LOW E WINDOWS IN LIVING QUARTERS REPLACED 2022! LOVELY APARTMENT WAS REMODELED IN 2022! LEASE OPTION available!' ,`Acres` = '0.1435' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 164 E PAYNE SUR LOTS 47 & 48 BLK 131 CLIFTON BY THE' ,`LotDesciption` = 'Corner' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '8' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'KENNETH E. LITTLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Barndominium,Split Level' ,`Subdivision` = 'Clifton By The Sea' ,`TaxAmount` = '419' ,`TaxRate` = '2.2342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651538' WHERE `Matrix_Unique_ID` = '208409523'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T00:20:19.353' ,`MLSNumber` = '89413742' ,`ListAgentFullName` = 'Janette Herring' ,`ListOfficeName` = 'Lakefair Realty & PropertyManagement LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708444' ,`Longitude` = '-95.356840' ,`PhotoCount` = '47' ,`PostalCode` = '77021' ,`RoomCount` = '16' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'Macgregor' ,`StreetNumber` = '3803' ,`StreetSuffix` = 'Way' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '4442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home on spacious corner lot. Notice all of the attention to detail from the tigerwood facade to the chef\'s kitchen. The custom staircase is a showstopper! Lovely primary suite with ensuite, 2 large walk in closets with built in wall safe. Outdoor patio includes full outdoor kitchen and an outdoor fireplace. plenty of space for that dream pool! This house offers a rare opportunity to live in a historic community just minutes from The Medical Center, University of Houston and Downtown.Call to schedule your viewing today!' ,`Acres` = '0.2695' ,`Area` = '4' ,`BuilderName` = 'Aplomb Development' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR A BLK 60 RIVERSIDE TERRACE SEC 12' ,`LotDesciption` = 'Corner' ,`LotSize` = '11741' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverside Terrace Sec 12' ,`TaxAmount` = '18242' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669651538' WHERE `Matrix_Unique_ID` = '210164942'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T23:33:20.140' ,`MLSNumber` = '60333090' ,`ListAgentFullName` = 'Jessica Rocha' ,`ListOfficeName` = 'JMR & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683801' ,`Longitude` = '-95.341480' ,`PhotoCount` = '28' ,`PostalCode` = '77033' ,`RoomCount` = '7' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Southlea' ,`StreetNumber` = '5218' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled home close to freeway.  House has been updated and a master bedroom with walk-in closet has been added in the back.  Includes stove and refrigerator. Set your appointment to view today!' ,`Acres` = '0.1435' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 11 SOUTH PARK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KELSO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Park Sec 02' ,`TaxAmount` = '1714' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669651538' WHERE `Matrix_Unique_ID` = '210681963'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T00:20:19.277' ,`MLSNumber` = '71039556' ,`ListAgentFullName` = 'Roger Alvarez' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692576' ,`Longitude` = '-95.683724' ,`PhotoCount` = '30' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Sorbete' ,`StreetNumber` = '7503' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home in a cul-de-sac. Seller has meticulously maintained this home and there are a lot of upgrades. **Home features 3 bedrooms, 2 bath, you will love the High ceiling in family room and kitchen. Granite countertops, upgraded kitchen cabinets, and added an extra room which can be used as a den, a game room or 2nd family room. The Back yard is a wonderful spot for gatherings and a great size to inspire the Gardner in you. There is a covered patio at back. You must see this home.' ,`Acres` = '0.1844' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MISSION WEST SEC 2, BLOCK 4, LOT 55' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8032' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MISSION WEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission West Sec 2' ,`TaxAmount` = '3905' ,`TaxRate` = '2.4297' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651539' WHERE `Matrix_Unique_ID` = '212094001'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T23:59:39.393' ,`MLSNumber` = '38125390' ,`ListAgentFullName` = 'David Moosavi' ,`ListOfficeName` = 'Rose Above Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.036656' ,`Longitude` = '-95.427576' ,`PhotoCount` = '17' ,`PostalCode` = '77566' ,`RoomCount` = '6' ,`ListPrice` = '189999.00' ,`Status` = 'Active' ,`StreetName` = 'Carnation' ,`StreetNumber` = '301' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1245' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Awesome three bedroom home on an oversized lot! Whether you enjoy grilling on the stamped concrete patio or lounging in the shade, you\'re sure to make use of the abundance of yard space. Situated on a corner lot in a nice neighborhood, this cozy home is the one to make your own.' ,`Acres` = '0.2353' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PARKWOOD TERRACE (LAKE JACKSON) BLK 11 LOT 23' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BEUTEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Terrace Lake Jackson' ,`TaxAmount` = '3920' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651539' WHERE `Matrix_Unique_ID` = '213122247'  --> 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','214377248','1669651539','214377248','2022-11-27T00:20:19.027','31425451','Steven Fernandes','Substantia Realty LLC','','','29.726998','-95.754074','4','77450','11','799000.00','Active','Cassidy Park','4310','Lane','Katy','4','1','5','4725','Single-Family','','0.285','36','','','','','Sellers Disclosure','1','','2','Katy - Southeast','Central Gas','1','CINCO AT WILLOW FORK SEC 1, BLOCK 3, LOT 16','Subdivision Lot','12416','Appraisal District','','1150','0','','2','','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','30 - Katy','EXLEY ELEMENTARY SCHOOL','CINCO RANCH HIGH SCHOOL','BECK JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Cinco At Willow Fork Sec 1','12516','2.5095','Water District','2000','Appraisal District');  --> 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','214445875','1669651539','214445875','2022-11-27T00:20:18.730','74463536','Donna Pop','eXp Realty, LLC','','','30.276588','-95.543047','0','77316','0','555000.00','Active','Bearkat','154','Court','Montgomery','3','1','4','3110','Single-Family','Welcome to this beautiful home on an oversized cup-de-sac lot in the Deerbourne section of Woodforest, a Master Planned community. This home has wonderful curb appeal from the covered front porch, limestone elevation to the double wide driveway. Upon entry you\'re met with a remarkable 2 story foyer that leads you pass the dining-room into the living-room & large open kitchen w/breakfast area with lots of windows. Just off the living-room you find your way into the large primary bedroom that features en suite bathroom with double sinks, oversized shower, a soaker tub and a nice walk-in closet. Down stairs also includes the laundry, secondary bedroom and full bath. Upstairs is where you\'ll find a spacious game room w/half bath, no window media room, also the remaining 2 bedrooms w/jack and jill full bath. Backyard features covered patio and storage shed on the oversized lot with plenty of room for a pool/backyard oasis and then some. Woodforest includes many parks, trails and pools!','0.3524','39','Lennar','','Electric Dryer Connections,Washer Connections','','Exclusions,Mud,Owner/Agent,Sellers Disclosure','1','Gaslog Fireplace','1','Conroe Southwest','Central Gas','1','S965269 - WOODFOREST 69, BLOCK 1, LOT 10','Cul-De-Sac,In Golf Course Community,Subdivision Lot','15352','Survey','','1250','0','','2','Gas Oven,Single Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','STEWART ELEMENTARY SCHOOL (CONROE)','CONROE HIGH SCHOOL','PEET JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Woodforest 69','12020','2.6888','Water District','2018','Builder');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-27T00:20:18.947' ,`MLSNumber` = '27779068' ,`ListAgentFullName` = 'Kelly Lark' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936867' ,`Longitude` = '-95.547412' ,`PhotoCount` = '38' ,`PostalCode` = '77064' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Heron Nest' ,`StreetNumber` = '8710' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING! You will fall in love with this totally remodeled home with custom designer finishes. Beautiful LVP flooring, new fireplace surround, granite countertops, new chevron tile backsplash, all new lighting, fans, paint and carpets. Garage has been painted and new epoxy floors have been added. Primary bedroom with soaring ceiling with fan, primary bath has new white double sink vanity with pull out drawers, new lighting, faucets, mirrors and new LVP flooring, new carpet in the large walk-in closet. Laundry room has new white barn rail door and updated laundry room. The home has a gameroom and a wonderful split floor plan, secondary bath has also been updated too. Backyard has patio and room for a pool!! Great school and easy access to major highways.\r\nThis Home is a MUST SEE!!' ,`Acres` = '0.1406' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Willowbrook South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 3 HERON NEST' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '6126' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '775' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WILLBERN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CAMPBELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heron Nest' ,`TaxAmount` = '4254' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651539' WHERE `Matrix_Unique_ID` = '214523264'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-26T23:03:24.773' ,`MLSNumber` = '66468144' ,`ListAgentFullName` = 'Debra Spurr' ,`ListOfficeName` = 'Grace Team Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.331381' ,`Longitude` = '-94.938927' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '460000.00' ,`Status` = 'Active' ,`StreetName` = 'Redwing' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Street' ,`City` = 'La Marque' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Waterfront Property! Outside staircase leads to upper covered deck, catwalk and outer part deck for additional entertaining. This beautiful remodeled, open floor plan has a french door entry with high ceilings, dining, kitchen with with island enclosing an electric fireplace, facing the living area.  The beautiful kitchen has lots of custom cabinets and drawers, and beautiful custom lighting. The bottom floor offers a one bedroom, one bath apartment with living room, and mini kitchen.  This extra living space is adorable! Both floors have central AC and heat.  French doors lead to a covered patio, with built in bar, and just steps away is your boathouse with cleaning station ready for the days catch!  HVAC was replaced in 2022!' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Omega Bay' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S C BUNDICK SUR LOT 5 OMEGA BAY SEC 9' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Omega Bay Numbered Sections' ,`TaxAmount` = '8762' ,`TaxRate` = '2.8033' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669651539' WHERE `Matrix_Unique_ID` = '214920548'  --> 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','215106956','1669651540','215106956','2022-11-27T00:32:18.587','26918932','Kathryn Anne Freeland-Foley','eXp Realty, LLC','','','31.917987','-96.543877','30','76679','3','295000.00','Active','Fm 642','8015','','Purdon','2','0','3','2650','Single-Family','Welcome to country living at its best.\r\nThis beautiful home sits on an acre of land out on a quiet paved country road. Just up the way is a cute little county store cafe where you can have a cup of coffee in the morning and catch up on the local talk and on Friday nights have the best catfish dinner and homemade pie.\r\nThis country house is ready for you to move in. It has been well cared for with love and is in excellent condition; and don\'t worry about watering that gorgeous, green yard in the summer because it also has a fully functioning sprinkler system.\r\nIf you love a more modern farmhouse look you can add your own changes and updates to make it your own.\r\nCorsicana is nearby but you are also close to Waco, Waxahachie, Ennis and even Dallas. It\'s the best of both worlds; live a quiet country life with easy access to the city for shopping, eating and entertainment. \r\nSo what are you waiting for?!','1','84','','','Electric Dryer Connections','','Sellers Disclosure','','','0','','Central Electric','0','ABS A10422 P JACKSON ABST TRACT 14A 1.0 ACRES','Other','43560','Appraisal District','','','0','','2','Convection Oven','0','','','Electric Cooktop','','Composition','464 - Dawson (Navarro)','DAWSON ELEMENTARY SCHOOL (DAWSON)','DAWSON HIGH SCHOOL','DAWSON HIGH SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Pursley','3046','1.8965','Septic Tank','1961','Appraisal District');  --> New record created successfully<br />